JiwaAPI

<back to all web services

CR_DetailedGLAuditQuery

Requires Authentication
CR_DetailedGLAuditQuery Parameters:
NameParameterData TypeRequiredDescription
ReceiptIDquerystringNo
ReceiptIDStartsWithquerystringNo
ReceiptIDEndsWithquerystringNo
ReceiptIDContainsquerystringNo
ReceiptIDLikequerystringNo
ReceiptIDBetweenquerystring[]No
ReceiptIDInquerystring[]No
AccountIDquerystringNo
AccountIDStartsWithquerystringNo
AccountIDEndsWithquerystringNo
AccountIDContainsquerystringNo
AccountIDLikequerystringNo
AccountIDBetweenquerystring[]No
AccountIDInquerystring[]No
CRAccountNoquerystringNo
CRAccountNoStartsWithquerystringNo
CRAccountNoEndsWithquerystringNo
CRAccountNoContainsquerystringNo
CRAccountNoLikequerystringNo
CRAccountNoBetweenquerystring[]No
CRAccountNoInquerystring[]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
HomeTransAmountquerydecimal?No
HomeTransAmountGreaterThanOrEqualToquerydecimal?No
HomeTransAmountGreaterThanquerydecimal?No
HomeTransAmountLessThanquerydecimal?No
HomeTransAmountLessThanOrEqualToquerydecimal?No
HomeTransAmountNotEqualToquerydecimal?No
HomeTransAmountBetweenqueryNullable<Decimal>[]No
HomeTransAmountInqueryNullable<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
CR_DetailedGLAudit Parameters:
NameParameterData TypeRequiredDescription
ReceiptIDformstringNo
AccountIDformstringNo
CRAccountNoformstringNo
RemitNoformstringNo
ReceiptDateformDateTime?No
HomeTransAmountformdecimal?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/CR_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"],"CRAccountNo":"String","CRAccountNoStartsWith":"String","CRAccountNoEndsWith":"String","CRAccountNoContains":"String","CRAccountNoLike":"String","CRAccountNoBetween":["String"],"CRAccountNoIn":["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"],"HomeTransAmount":0,"HomeTransAmountGreaterThanOrEqualTo":0,"HomeTransAmountGreaterThan":0,"HomeTransAmountLessThan":0,"HomeTransAmountLessThanOrEqualTo":0,"HomeTransAmountNotEqualTo":0,"HomeTransAmountBetween":[0],"HomeTransAmountIn":[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","CRAccountNo":"String","RemitNo":"String","ReceiptDate":"0001-01-01T00:00:00.0000000","HomeTransAmount":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"}}}