JiwaAPI

<back to all web services

DB_DetailedGLAuditQuery

Requires Authentication
DB_DetailedGLAuditQuery Parameters:
NameParameterData TypeRequiredDescription
ReceiptIDquerystringNo
ReceiptIDStartsWithquerystringNo
ReceiptIDEndsWithquerystringNo
ReceiptIDContainsquerystringNo
ReceiptIDLikequerystringNo
ReceiptIDBetweenquerystring[]No
ReceiptIDInquerystring[]No
AccountIDquerystringNo
AccountIDStartsWithquerystringNo
AccountIDEndsWithquerystringNo
AccountIDContainsquerystringNo
AccountIDLikequerystringNo
AccountIDBetweenquerystring[]No
AccountIDInquerystring[]No
DBAccountNoquerystringNo
DBAccountNoStartsWithquerystringNo
DBAccountNoEndsWithquerystringNo
DBAccountNoContainsquerystringNo
DBAccountNoLikequerystringNo
DBAccountNoBetweenquerystring[]No
DBAccountNoInquerystring[]No
RemitNoquerystringNo
RemitNoStartsWithquerystringNo
RemitNoEndsWithquerystringNo
RemitNoContainsquerystringNo
RemitNoLikequerystringNo
RemitNoBetweenquerystring[]No
RemitNoInquerystring[]No
ReceiptDatequeryDateTime?No
ReceiptDateGreaterThanOrEqualToqueryDateTime?No
ReceiptDateGreaterThanqueryDateTime?No
ReceiptDateLessThanqueryDateTime?No
ReceiptDateLessThanOrEqualToqueryDateTime?No
ReceiptDateNotEqualToqueryDateTime?No
ReceiptDateBetweenqueryNullable<DateTime>[]No
ReceiptDateInqueryNullable<DateTime>[]No
Amountquerydecimal?No
AmountGreaterThanOrEqualToquerydecimal?No
AmountGreaterThanquerydecimal?No
AmountLessThanquerydecimal?No
AmountLessThanOrEqualToquerydecimal?No
AmountNotEqualToquerydecimal?No
AmountBetweenqueryNullable<Decimal>[]No
AmountInqueryNullable<Decimal>[]No
SourceIDquerystringNo
SourceIDStartsWithquerystringNo
SourceIDEndsWithquerystringNo
SourceIDContainsquerystringNo
SourceIDLikequerystringNo
SourceIDBetweenquerystring[]No
SourceIDInquerystring[]No
SetTypequeryshort?No
SetTypeGreaterThanOrEqualToqueryshort?No
SetTypeGreaterThanqueryshort?No
SetTypeLessThanqueryshort?No
SetTypeLessThanOrEqualToqueryshort?No
SetTypeNotEqualToqueryshort?No
SetTypeBetweenqueryNullable<Int16>[]No
SetTypeInqueryNullable<Int16>[]No
GLSetIDquerystringNo
GLSetIDStartsWithquerystringNo
GLSetIDEndsWithquerystringNo
GLSetIDContainsquerystringNo
GLSetIDLikequerystringNo
GLSetIDBetweenquerystring[]No
GLSetIDInquerystring[]No
GLAccountNoquerystringNo
GLAccountNoStartsWithquerystringNo
GLAccountNoEndsWithquerystringNo
GLAccountNoContainsquerystringNo
GLAccountNoLikequerystringNo
GLAccountNoBetweenquerystring[]No
GLAccountNoInquerystring[]No
RefquerystringNo
RefStartsWithquerystringNo
RefEndsWithquerystringNo
RefContainsquerystringNo
RefLikequerystringNo
RefBetweenquerystring[]No
RefInquerystring[]No
GLTransAmountquerydecimal?No
GLTransAmountGreaterThanOrEqualToquerydecimal?No
GLTransAmountGreaterThanquerydecimal?No
GLTransAmountLessThanquerydecimal?No
GLTransAmountLessThanOrEqualToquerydecimal?No
GLTransAmountNotEqualToquerydecimal?No
GLTransAmountBetweenqueryNullable<Decimal>[]No
GLTransAmountInqueryNullable<Decimal>[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
DB_DetailedGLAudit Parameters:
NameParameterData TypeRequiredDescription
ReceiptIDformstringNo
AccountIDformstringNo
DBAccountNoformstringNo
RemitNoformstringNo
ReceiptDateformDateTime?No
Amountformdecimal?No
SourceIDformstringNo
SetTypeformshort?No
GLSetIDformstringNo
GLAccountNoformstringNo
RefformstringNo
GLTransAmountformdecimal?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 .json suffix or ?format=json

To embed the response in a jsonp callback, append ?callback=myCallback

HTTP + JSON

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

POST /json/reply/DB_DetailedGLAuditQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/json
Content-Type: application/json
Content-Length: length

{"ReceiptID":"String","ReceiptIDStartsWith":"String","ReceiptIDEndsWith":"String","ReceiptIDContains":"String","ReceiptIDLike":"String","ReceiptIDBetween":["String"],"ReceiptIDIn":["String"],"AccountID":"String","AccountIDStartsWith":"String","AccountIDEndsWith":"String","AccountIDContains":"String","AccountIDLike":"String","AccountIDBetween":["String"],"AccountIDIn":["String"],"DBAccountNo":"String","DBAccountNoStartsWith":"String","DBAccountNoEndsWith":"String","DBAccountNoContains":"String","DBAccountNoLike":"String","DBAccountNoBetween":["String"],"DBAccountNoIn":["String"],"RemitNo":"String","RemitNoStartsWith":"String","RemitNoEndsWith":"String","RemitNoContains":"String","RemitNoLike":"String","RemitNoBetween":["String"],"RemitNoIn":["String"],"ReceiptDate":"0001-01-01T00:00:00.0000000","ReceiptDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","ReceiptDateGreaterThan":"0001-01-01T00:00:00.0000000","ReceiptDateLessThan":"0001-01-01T00:00:00.0000000","ReceiptDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","ReceiptDateNotEqualTo":"0001-01-01T00:00:00.0000000","ReceiptDateBetween":["0001-01-01T00:00:00.0000000"],"ReceiptDateIn":["0001-01-01T00:00:00.0000000"],"Amount":0,"AmountGreaterThanOrEqualTo":0,"AmountGreaterThan":0,"AmountLessThan":0,"AmountLessThanOrEqualTo":0,"AmountNotEqualTo":0,"AmountBetween":[0],"AmountIn":[0],"SourceID":"String","SourceIDStartsWith":"String","SourceIDEndsWith":"String","SourceIDContains":"String","SourceIDLike":"String","SourceIDBetween":["String"],"SourceIDIn":["String"],"SetType":0,"SetTypeGreaterThanOrEqualTo":0,"SetTypeGreaterThan":0,"SetTypeLessThan":0,"SetTypeLessThanOrEqualTo":0,"SetTypeNotEqualTo":0,"SetTypeBetween":[0],"SetTypeIn":[0],"GLSetID":"String","GLSetIDStartsWith":"String","GLSetIDEndsWith":"String","GLSetIDContains":"String","GLSetIDLike":"String","GLSetIDBetween":["String"],"GLSetIDIn":["String"],"GLAccountNo":"String","GLAccountNoStartsWith":"String","GLAccountNoEndsWith":"String","GLAccountNoContains":"String","GLAccountNoLike":"String","GLAccountNoBetween":["String"],"GLAccountNoIn":["String"],"Ref":"String","RefStartsWith":"String","RefEndsWith":"String","RefContains":"String","RefLike":"String","RefBetween":["String"],"RefIn":["String"],"GLTransAmount":0,"GLTransAmountGreaterThanOrEqualTo":0,"GLTransAmountGreaterThan":0,"GLTransAmountLessThan":0,"GLTransAmountLessThanOrEqualTo":0,"GLTransAmountNotEqualTo":0,"GLTransAmountBetween":[0],"GLTransAmountIn":[0],"Skip":0,"Take":0,"OrderBy":"String","OrderByDesc":"String","Include":"String","Fields":"String","Meta":{"String":"String"}}
HTTP/1.1 200 OK
Content-Type: application/json
Content-Length: length

{"Results":[{"ReceiptID":"String","AccountID":"String","DBAccountNo":"String","RemitNo":"String","ReceiptDate":"0001-01-01T00:00:00.0000000","Amount":0,"SourceID":"String","SetType":0,"GLSetID":"String","GLAccountNo":"String","Ref":"String","GLTransAmount":0}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}