JiwaAPI

<back to all web services

GL_AutoJournalLinesQuery

Requires Authentication
GL_AutoJournalLinesQuery Parameters:
NameParameterData TypeRequiredDescription
RecIDquerystringNo
RecIDStartsWithquerystringNo
RecIDEndsWithquerystringNo
RecIDContainsquerystringNo
RecIDLikequerystringNo
RecIDBetweenquerystring[]No
RecIDInquerystring[]No
GL_AutoJournals_RecIDquerystringNo
GL_AutoJournals_RecIDStartsWithquerystringNo
GL_AutoJournals_RecIDEndsWithquerystringNo
GL_AutoJournals_RecIDContainsquerystringNo
GL_AutoJournals_RecIDLikequerystringNo
GL_AutoJournals_RecIDBetweenquerystring[]No
GL_AutoJournals_RecIDInquerystring[]No
GL_Sets_RecID_SourcequerystringNo
GL_Sets_RecID_SourceStartsWithquerystringNo
GL_Sets_RecID_SourceEndsWithquerystringNo
GL_Sets_RecID_SourceContainsquerystringNo
GL_Sets_RecID_SourceLikequerystringNo
GL_Sets_RecID_SourceBetweenquerystring[]No
GL_Sets_RecID_SourceInquerystring[]No
GL_Sets_SourceDescriptionquerystringNo
GL_Sets_SourceDescriptionStartsWithquerystringNo
GL_Sets_SourceDescriptionEndsWithquerystringNo
GL_Sets_SourceDescriptionContainsquerystringNo
GL_Sets_SourceDescriptionLikequerystringNo
GL_Sets_SourceDescriptionBetweenquerystring[]No
GL_Sets_SourceDescriptionInquerystring[]No
PostingDuequeryDateTime?No
PostingDueGreaterThanOrEqualToqueryDateTime?No
PostingDueGreaterThanqueryDateTime?No
PostingDueLessThanqueryDateTime?No
PostingDueLessThanOrEqualToqueryDateTime?No
PostingDueNotEqualToqueryDateTime?No
PostingDueBetweenqueryDateTime[]No
PostingDueInqueryDateTime[]No
ReasonquerystringNo
ReasonStartsWithquerystringNo
ReasonEndsWithquerystringNo
ReasonContainsquerystringNo
ReasonLikequerystringNo
ReasonBetweenquerystring[]No
ReasonInquerystring[]No
GL_Sets_RecID_DestinationquerystringNo
GL_Sets_RecID_DestinationStartsWithquerystringNo
GL_Sets_RecID_DestinationEndsWithquerystringNo
GL_Sets_RecID_DestinationContainsquerystringNo
GL_Sets_RecID_DestinationLikequerystringNo
GL_Sets_RecID_DestinationBetweenquerystring[]No
GL_Sets_RecID_DestinationInquerystring[]No
ItemNoqueryint?No
ItemNoGreaterThanOrEqualToqueryint?No
ItemNoGreaterThanqueryint?No
ItemNoLessThanqueryint?No
ItemNoLessThanOrEqualToqueryint?No
ItemNoNotEqualToqueryint?No
ItemNoBetweenqueryint[]No
ItemNoInqueryint[]No
RowHashquerybyte[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
GL_AutoJournalLines Parameters:
NameParameterData TypeRequiredDescription
RecIDformstringNo
GL_AutoJournals_RecIDformstringNo
GL_Sets_RecID_SourceformstringNo
GL_Sets_SourceDescriptionformstringNo
PostingDueformDateTimeNo
ReasonformstringNo
GL_Sets_RecID_DestinationformstringNo
ItemNoformintNo
RowHashformbyte[]No
QueryResponse<T> Parameters:
NameParameterData TypeRequiredDescription
OffsetformintNo
TotalformintNo
ResultsformList<T>No
MetaformDictionary<string, string>No
ResponseStatusformResponseStatusNo

To override the Content-type in your clients, use the HTTP Accept Header, append the .csv suffix or ?format=csv

HTTP + CSV

The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.

POST /csv/reply/GL_AutoJournalLinesQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: text/csv
Content-Type: text/csv
Content-Length: length

{"RecID":"String","RecIDStartsWith":"String","RecIDEndsWith":"String","RecIDContains":"String","RecIDLike":"String","RecIDBetween":["String"],"RecIDIn":["String"],"GL_AutoJournals_RecID":"String","GL_AutoJournals_RecIDStartsWith":"String","GL_AutoJournals_RecIDEndsWith":"String","GL_AutoJournals_RecIDContains":"String","GL_AutoJournals_RecIDLike":"String","GL_AutoJournals_RecIDBetween":["String"],"GL_AutoJournals_RecIDIn":["String"],"GL_Sets_RecID_Source":"String","GL_Sets_RecID_SourceStartsWith":"String","GL_Sets_RecID_SourceEndsWith":"String","GL_Sets_RecID_SourceContains":"String","GL_Sets_RecID_SourceLike":"String","GL_Sets_RecID_SourceBetween":["String"],"GL_Sets_RecID_SourceIn":["String"],"GL_Sets_SourceDescription":"String","GL_Sets_SourceDescriptionStartsWith":"String","GL_Sets_SourceDescriptionEndsWith":"String","GL_Sets_SourceDescriptionContains":"String","GL_Sets_SourceDescriptionLike":"String","GL_Sets_SourceDescriptionBetween":["String"],"GL_Sets_SourceDescriptionIn":["String"],"PostingDue":"0001-01-01T00:00:00.0000000","PostingDueGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","PostingDueGreaterThan":"0001-01-01T00:00:00.0000000","PostingDueLessThan":"0001-01-01T00:00:00.0000000","PostingDueLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","PostingDueNotEqualTo":"0001-01-01T00:00:00.0000000","PostingDueBetween":["0001-01-01T00:00:00.0000000"],"PostingDueIn":["0001-01-01T00:00:00.0000000"],"Reason":"String","ReasonStartsWith":"String","ReasonEndsWith":"String","ReasonContains":"String","ReasonLike":"String","ReasonBetween":["String"],"ReasonIn":["String"],"GL_Sets_RecID_Destination":"String","GL_Sets_RecID_DestinationStartsWith":"String","GL_Sets_RecID_DestinationEndsWith":"String","GL_Sets_RecID_DestinationContains":"String","GL_Sets_RecID_DestinationLike":"String","GL_Sets_RecID_DestinationBetween":["String"],"GL_Sets_RecID_DestinationIn":["String"],"ItemNo":0,"ItemNoGreaterThanOrEqualTo":0,"ItemNoGreaterThan":0,"ItemNoLessThan":0,"ItemNoLessThanOrEqualTo":0,"ItemNoNotEqualTo":0,"ItemNoBetween":[0],"ItemNoIn":[0],"RowHash":"AA==","Skip":0,"Take":0,"OrderBy":"String","OrderByDesc":"String","Include":"String","Fields":"String","Meta":{"String":"String"}}

HTTP/1.1 200 OK
Content-Type: text/csv
Content-Length: length

{"Results":[{"RecID":"String","GL_AutoJournals_RecID":"String","GL_Sets_RecID_Source":"String","GL_Sets_SourceDescription":"String","Reason":"String","GL_Sets_RecID_Destination":"String","RowHash":"AA=="}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}