JiwaAPI

<back to all web services

GL_BankDetailsQuery

Requires Authentication
GL_BankDetailsQuery Parameters:
NameParameterData TypeRequiredDescription
RecIDquerystringNo
RecIDStartsWithquerystringNo
RecIDEndsWithquerystringNo
RecIDContainsquerystringNo
RecIDLikequerystringNo
RecIDBetweenquerystring[]No
RecIDInquerystring[]No
GLLedgerIDquerystringNo
GLLedgerIDStartsWithquerystringNo
GLLedgerIDEndsWithquerystringNo
GLLedgerIDContainsquerystringNo
GLLedgerIDLikequerystringNo
GLLedgerIDBetweenquerystring[]No
GLLedgerIDInquerystring[]No
NextChequeNumberquerystringNo
NextChequeNumberStartsWithquerystringNo
NextChequeNumberEndsWithquerystringNo
NextChequeNumberContainsquerystringNo
NextChequeNumberLikequerystringNo
NextChequeNumberBetweenquerystring[]No
NextChequeNumberInquerystring[]No
BankNamequerystringNo
BankNameStartsWithquerystringNo
BankNameEndsWithquerystringNo
BankNameContainsquerystringNo
BankNameLikequerystringNo
BankNameBetweenquerystring[]No
BankNameInquerystring[]No
BSBNquerystringNo
BSBNStartsWithquerystringNo
BSBNEndsWithquerystringNo
BSBNContainsquerystringNo
BSBNLikequerystringNo
BSBNBetweenquerystring[]No
BSBNInquerystring[]No
AccountNumberquerystringNo
AccountNumberStartsWithquerystringNo
AccountNumberEndsWithquerystringNo
AccountNumberContainsquerystringNo
AccountNumberLikequerystringNo
AccountNumberBetweenquerystring[]No
AccountNumberInquerystring[]No
AccountNamequerystringNo
AccountNameStartsWithquerystringNo
AccountNameEndsWithquerystringNo
AccountNameContainsquerystringNo
AccountNameLikequerystringNo
AccountNameBetweenquerystring[]No
AccountNameInquerystring[]No
DefaultBankquerybool?No
LastSavedDateTimequeryDateTime?No
LastSavedDateTimeGreaterThanOrEqualToqueryDateTime?No
LastSavedDateTimeGreaterThanqueryDateTime?No
LastSavedDateTimeLessThanqueryDateTime?No
LastSavedDateTimeLessThanOrEqualToqueryDateTime?No
LastSavedDateTimeNotEqualToqueryDateTime?No
LastSavedDateTimeBetweenqueryDateTime[]No
LastSavedDateTimeInqueryDateTime[]No
FeesLedgerIDquerystringNo
FeesLedgerIDStartsWithquerystringNo
FeesLedgerIDEndsWithquerystringNo
FeesLedgerIDContainsquerystringNo
FeesLedgerIDLikequerystringNo
FeesLedgerIDBetweenquerystring[]No
FeesLedgerIDInquerystring[]No
EFTBankCodequerystringNo
EFTBankCodeStartsWithquerystringNo
EFTBankCodeEndsWithquerystringNo
EFTBankCodeContainsquerystringNo
EFTBankCodeLikequerystringNo
EFTBankCodeBetweenquerystring[]No
EFTBankCodeInquerystring[]No
UserIdentificationNumberquerystringNo
UserIdentificationNumberStartsWithquerystringNo
UserIdentificationNumberEndsWithquerystringNo
UserIdentificationNumberContainsquerystringNo
UserIdentificationNumberLikequerystringNo
UserIdentificationNumberBetweenquerystring[]No
UserIdentificationNumberInquerystring[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
GL_BankDetails Parameters:
NameParameterData TypeRequiredDescription
RecIDformstringNo
GLLedgerIDformstringNo
NextChequeNumberformstringNo
BankNameformstringNo
BSBNformstringNo
AccountNumberformstringNo
AccountNameformstringNo
DefaultBankformbool?No
LastSavedDateTimeformDateTimeNo
FeesLedgerIDformstringNo
EFTBankCodeformstringNo
UserIdentificationNumberformstringNo
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_BankDetailsQuery 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"],"GLLedgerID":"String","GLLedgerIDStartsWith":"String","GLLedgerIDEndsWith":"String","GLLedgerIDContains":"String","GLLedgerIDLike":"String","GLLedgerIDBetween":["String"],"GLLedgerIDIn":["String"],"NextChequeNumber":"String","NextChequeNumberStartsWith":"String","NextChequeNumberEndsWith":"String","NextChequeNumberContains":"String","NextChequeNumberLike":"String","NextChequeNumberBetween":["String"],"NextChequeNumberIn":["String"],"BankName":"String","BankNameStartsWith":"String","BankNameEndsWith":"String","BankNameContains":"String","BankNameLike":"String","BankNameBetween":["String"],"BankNameIn":["String"],"BSBN":"String","BSBNStartsWith":"String","BSBNEndsWith":"String","BSBNContains":"String","BSBNLike":"String","BSBNBetween":["String"],"BSBNIn":["String"],"AccountNumber":"String","AccountNumberStartsWith":"String","AccountNumberEndsWith":"String","AccountNumberContains":"String","AccountNumberLike":"String","AccountNumberBetween":["String"],"AccountNumberIn":["String"],"AccountName":"String","AccountNameStartsWith":"String","AccountNameEndsWith":"String","AccountNameContains":"String","AccountNameLike":"String","AccountNameBetween":["String"],"AccountNameIn":["String"],"DefaultBank":false,"LastSavedDateTime":"0001-01-01T00:00:00.0000000","LastSavedDateTimeGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","LastSavedDateTimeGreaterThan":"0001-01-01T00:00:00.0000000","LastSavedDateTimeLessThan":"0001-01-01T00:00:00.0000000","LastSavedDateTimeLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","LastSavedDateTimeNotEqualTo":"0001-01-01T00:00:00.0000000","LastSavedDateTimeBetween":["0001-01-01T00:00:00.0000000"],"LastSavedDateTimeIn":["0001-01-01T00:00:00.0000000"],"FeesLedgerID":"String","FeesLedgerIDStartsWith":"String","FeesLedgerIDEndsWith":"String","FeesLedgerIDContains":"String","FeesLedgerIDLike":"String","FeesLedgerIDBetween":["String"],"FeesLedgerIDIn":["String"],"EFTBankCode":"String","EFTBankCodeStartsWith":"String","EFTBankCodeEndsWith":"String","EFTBankCodeContains":"String","EFTBankCodeLike":"String","EFTBankCodeBetween":["String"],"EFTBankCodeIn":["String"],"UserIdentificationNumber":"String","UserIdentificationNumberStartsWith":"String","UserIdentificationNumberEndsWith":"String","UserIdentificationNumberContains":"String","UserIdentificationNumberLike":"String","UserIdentificationNumberBetween":["String"],"UserIdentificationNumberIn":["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":[{"RecID":"String","GLLedgerID":"String","NextChequeNumber":"String","BankName":"String","BSBN":"String","AccountNumber":"String","AccountName":"String","DefaultBank":false,"FeesLedgerID":"String","EFTBankCode":"String","UserIdentificationNumber":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}