JiwaAPI

<back to all web services

GL_TransactionsQuery

Requires Authentication
GL_TransactionsQuery Parameters:
NameParameterData TypeRequiredDescription
GLTransactionIDquerystringNo
GLTransactionIDStartsWithquerystringNo
GLTransactionIDEndsWithquerystringNo
GLTransactionIDContainsquerystringNo
GLTransactionIDLikequerystringNo
GLTransactionIDBetweenquerystring[]No
GLTransactionIDInquerystring[]No
GLSetIDquerystringNo
GLSetIDStartsWithquerystringNo
GLSetIDEndsWithquerystringNo
GLSetIDContainsquerystringNo
GLSetIDLikequerystringNo
GLSetIDBetweenquerystring[]No
GLSetIDInquerystring[]No
GLLedgerIDquerystringNo
GLLedgerIDStartsWithquerystringNo
GLLedgerIDEndsWithquerystringNo
GLLedgerIDContainsquerystringNo
GLLedgerIDLikequerystringNo
GLLedgerIDBetweenquerystring[]No
GLLedgerIDInquerystring[]No
DebitCreditquerybool?No
Amountquerydecimal?No
AmountGreaterThanOrEqualToquerydecimal?No
AmountGreaterThanquerydecimal?No
AmountLessThanquerydecimal?No
AmountLessThanOrEqualToquerydecimal?No
AmountNotEqualToquerydecimal?No
AmountBetweenqueryNullable<Decimal>[]No
AmountInqueryNullable<Decimal>[]No
RefquerystringNo
RefStartsWithquerystringNo
RefEndsWithquerystringNo
RefContainsquerystringNo
RefLikequerystringNo
RefBetweenquerystring[]No
RefInquerystring[]No
RemarkquerystringNo
RemarkStartsWithquerystringNo
RemarkEndsWithquerystringNo
RemarkContainsquerystringNo
RemarkLikequerystringNo
RemarkBetweenquerystring[]No
RemarkInquerystring[]No
LineNumqueryint?No
LineNumGreaterThanOrEqualToqueryint?No
LineNumGreaterThanqueryint?No
LineNumLessThanqueryint?No
LineNumLessThanOrEqualToqueryint?No
LineNumNotEqualToqueryint?No
LineNumBetweenqueryint[]No
LineNumInqueryint[]No
TransCode1IDquerystringNo
TransCode1IDStartsWithquerystringNo
TransCode1IDEndsWithquerystringNo
TransCode1IDContainsquerystringNo
TransCode1IDLikequerystringNo
TransCode1IDBetweenquerystring[]No
TransCode1IDInquerystring[]No
TransCode2IDquerystringNo
TransCode2IDStartsWithquerystringNo
TransCode2IDEndsWithquerystringNo
TransCode2IDContainsquerystringNo
TransCode2IDLikequerystringNo
TransCode2IDBetweenquerystring[]No
TransCode2IDInquerystring[]No
TransCode3IDquerystringNo
TransCode3IDStartsWithquerystringNo
TransCode3IDEndsWithquerystringNo
TransCode3IDContainsquerystringNo
TransCode3IDLikequerystringNo
TransCode3IDBetweenquerystring[]No
TransCode3IDInquerystring[]No
StaffIDquerystringNo
StaffIDStartsWithquerystringNo
StaffIDEndsWithquerystringNo
StaffIDContainsquerystringNo
StaffIDLikequerystringNo
StaffIDBetweenquerystring[]No
StaffIDInquerystring[]No
Reconciledquerybool?No
Clearedquerybool?No
TransPostDateTimequeryDateTime?No
TransPostDateTimeGreaterThanOrEqualToqueryDateTime?No
TransPostDateTimeGreaterThanqueryDateTime?No
TransPostDateTimeLessThanqueryDateTime?No
TransPostDateTimeLessThanOrEqualToqueryDateTime?No
TransPostDateTimeNotEqualToqueryDateTime?No
TransPostDateTimeBetweenqueryNullable<DateTime>[]No
TransPostDateTimeInqueryNullable<DateTime>[]No
JB_JobStages_RecIDquerystringNo
JB_JobStages_RecIDStartsWithquerystringNo
JB_JobStages_RecIDEndsWithquerystringNo
JB_JobStages_RecIDContainsquerystringNo
JB_JobStages_RecIDLikequerystringNo
JB_JobStages_RecIDBetweenquerystring[]No
JB_JobStages_RecIDInquerystring[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
GL_Transactions Parameters:
NameParameterData TypeRequiredDescription
GLTransactionIDformstringNo
GLSetIDformstringNo
GLLedgerIDformstringNo
DebitCreditformbool?No
Amountformdecimal?No
RefformstringNo
RemarkformstringNo
LineNumformintNo
TransCode1IDformstringNo
TransCode2IDformstringNo
TransCode3IDformstringNo
StaffIDformstringNo
Reconciledformbool?No
Clearedformbool?No
TransPostDateTimeformDateTime?No
JB_JobStages_RecIDformstringNo
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_TransactionsQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: text/csv
Content-Type: text/csv
Content-Length: length

{"GLTransactionID":"String","GLTransactionIDStartsWith":"String","GLTransactionIDEndsWith":"String","GLTransactionIDContains":"String","GLTransactionIDLike":"String","GLTransactionIDBetween":["String"],"GLTransactionIDIn":["String"],"GLSetID":"String","GLSetIDStartsWith":"String","GLSetIDEndsWith":"String","GLSetIDContains":"String","GLSetIDLike":"String","GLSetIDBetween":["String"],"GLSetIDIn":["String"],"GLLedgerID":"String","GLLedgerIDStartsWith":"String","GLLedgerIDEndsWith":"String","GLLedgerIDContains":"String","GLLedgerIDLike":"String","GLLedgerIDBetween":["String"],"GLLedgerIDIn":["String"],"DebitCredit":false,"Amount":0,"AmountGreaterThanOrEqualTo":0,"AmountGreaterThan":0,"AmountLessThan":0,"AmountLessThanOrEqualTo":0,"AmountNotEqualTo":0,"AmountBetween":[0],"AmountIn":[0],"Ref":"String","RefStartsWith":"String","RefEndsWith":"String","RefContains":"String","RefLike":"String","RefBetween":["String"],"RefIn":["String"],"Remark":"String","RemarkStartsWith":"String","RemarkEndsWith":"String","RemarkContains":"String","RemarkLike":"String","RemarkBetween":["String"],"RemarkIn":["String"],"LineNum":0,"LineNumGreaterThanOrEqualTo":0,"LineNumGreaterThan":0,"LineNumLessThan":0,"LineNumLessThanOrEqualTo":0,"LineNumNotEqualTo":0,"LineNumBetween":[0],"LineNumIn":[0],"TransCode1ID":"String","TransCode1IDStartsWith":"String","TransCode1IDEndsWith":"String","TransCode1IDContains":"String","TransCode1IDLike":"String","TransCode1IDBetween":["String"],"TransCode1IDIn":["String"],"TransCode2ID":"String","TransCode2IDStartsWith":"String","TransCode2IDEndsWith":"String","TransCode2IDContains":"String","TransCode2IDLike":"String","TransCode2IDBetween":["String"],"TransCode2IDIn":["String"],"TransCode3ID":"String","TransCode3IDStartsWith":"String","TransCode3IDEndsWith":"String","TransCode3IDContains":"String","TransCode3IDLike":"String","TransCode3IDBetween":["String"],"TransCode3IDIn":["String"],"StaffID":"String","StaffIDStartsWith":"String","StaffIDEndsWith":"String","StaffIDContains":"String","StaffIDLike":"String","StaffIDBetween":["String"],"StaffIDIn":["String"],"Reconciled":false,"Cleared":false,"TransPostDateTime":"0001-01-01T00:00:00.0000000","TransPostDateTimeGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","TransPostDateTimeGreaterThan":"0001-01-01T00:00:00.0000000","TransPostDateTimeLessThan":"0001-01-01T00:00:00.0000000","TransPostDateTimeLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","TransPostDateTimeNotEqualTo":"0001-01-01T00:00:00.0000000","TransPostDateTimeBetween":["0001-01-01T00:00:00.0000000"],"TransPostDateTimeIn":["0001-01-01T00:00:00.0000000"],"JB_JobStages_RecID":"String","JB_JobStages_RecIDStartsWith":"String","JB_JobStages_RecIDEndsWith":"String","JB_JobStages_RecIDContains":"String","JB_JobStages_RecIDLike":"String","JB_JobStages_RecIDBetween":["String"],"JB_JobStages_RecIDIn":["String"],"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":[{"GLTransactionID":"String","GLSetID":"String","GLLedgerID":"String","DebitCredit":false,"Amount":0,"Ref":"String","Remark":"String","TransCode1ID":"String","TransCode2ID":"String","TransCode3ID":"String","StaffID":"String","Reconciled":false,"Cleared":false,"TransPostDateTime":"0001-01-01T00:00:00.0000000","JB_JobStages_RecID":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}