JiwaAPI

<back to all web services

DB_BatchTranLinesQuery

Requires Authentication
DB_BatchTranLinesQuery Parameters:
NameParameterData TypeRequiredDescription
ReceiptLineIDquerystringNo
ReceiptLineIDStartsWithquerystringNo
ReceiptLineIDEndsWithquerystringNo
ReceiptLineIDContainsquerystringNo
ReceiptLineIDLikequerystringNo
ReceiptLineIDBetweenquerystring[]No
ReceiptLineIDInquerystring[]No
ReceiptIDquerystringNo
ReceiptIDStartsWithquerystringNo
ReceiptIDEndsWithquerystringNo
ReceiptIDContainsquerystringNo
ReceiptIDLikequerystringNo
ReceiptIDBetweenquerystring[]No
ReceiptIDInquerystring[]No
LastSavedDateTimequeryDateTime?No
LastSavedDateTimeGreaterThanOrEqualToqueryDateTime?No
LastSavedDateTimeGreaterThanqueryDateTime?No
LastSavedDateTimeLessThanqueryDateTime?No
LastSavedDateTimeLessThanOrEqualToqueryDateTime?No
LastSavedDateTimeNotEqualToqueryDateTime?No
LastSavedDateTimeBetweenqueryNullable<DateTime>[]No
LastSavedDateTimeInqueryNullable<DateTime>[]No
AccountIDquerystringNo
AccountIDStartsWithquerystringNo
AccountIDEndsWithquerystringNo
AccountIDContainsquerystringNo
AccountIDLikequerystringNo
AccountIDBetweenquerystring[]No
AccountIDInquerystring[]No
LedgerIDquerystringNo
LedgerIDStartsWithquerystringNo
LedgerIDEndsWithquerystringNo
LedgerIDContainsquerystringNo
LedgerIDLikequerystringNo
LedgerIDBetweenquerystring[]No
LedgerIDInquerystring[]No
LineReferencequerystringNo
LineReferenceStartsWithquerystringNo
LineReferenceEndsWithquerystringNo
LineReferenceContainsquerystringNo
LineReferenceLikequerystringNo
LineReferenceBetweenquerystring[]No
LineReferenceInquerystring[]No
RemarkquerystringNo
RemarkStartsWithquerystringNo
RemarkEndsWithquerystringNo
RemarkContainsquerystringNo
RemarkLikequerystringNo
RemarkBetweenquerystring[]No
RemarkInquerystring[]No
RemitNoquerystringNo
RemitNoStartsWithquerystringNo
RemitNoEndsWithquerystringNo
RemitNoContainsquerystringNo
RemitNoLikequerystringNo
RemitNoBetweenquerystring[]No
RemitNoInquerystring[]No
Amountquerydecimal?No
AmountGreaterThanOrEqualToquerydecimal?No
AmountGreaterThanquerydecimal?No
AmountLessThanquerydecimal?No
AmountLessThanOrEqualToquerydecimal?No
AmountNotEqualToquerydecimal?No
AmountBetweenqueryNullable<Decimal>[]No
AmountInqueryNullable<Decimal>[]No
DBTransIDquerystringNo
DBTransIDStartsWithquerystringNo
DBTransIDEndsWithquerystringNo
DBTransIDContainsquerystringNo
DBTransIDLikequerystringNo
DBTransIDBetweenquerystring[]No
DBTransIDInquerystring[]No
LineNumqueryint?No
LineNumGreaterThanOrEqualToqueryint?No
LineNumGreaterThanqueryint?No
LineNumLessThanqueryint?No
LineNumLessThanOrEqualToqueryint?No
LineNumNotEqualToqueryint?No
LineNumBetweenqueryint[]No
LineNumInqueryint[]No
OtherLedgerIDquerystringNo
OtherLedgerIDStartsWithquerystringNo
OtherLedgerIDEndsWithquerystringNo
OtherLedgerIDContainsquerystringNo
OtherLedgerIDLikequerystringNo
OtherLedgerIDBetweenquerystring[]No
OtherLedgerIDInquerystring[]No
OtherAmountquerydecimal?No
OtherAmountGreaterThanOrEqualToquerydecimal?No
OtherAmountGreaterThanquerydecimal?No
OtherAmountLessThanquerydecimal?No
OtherAmountLessThanOrEqualToquerydecimal?No
OtherAmountNotEqualToquerydecimal?No
OtherAmountBetweenqueryNullable<Decimal>[]No
OtherAmountInqueryNullable<Decimal>[]No
ReceiptDatequeryDateTime?No
ReceiptDateGreaterThanOrEqualToqueryDateTime?No
ReceiptDateGreaterThanqueryDateTime?No
ReceiptDateLessThanqueryDateTime?No
ReceiptDateLessThanOrEqualToqueryDateTime?No
ReceiptDateNotEqualToqueryDateTime?No
ReceiptDateBetweenqueryNullable<DateTime>[]No
ReceiptDateInqueryNullable<DateTime>[]No
BankNamequerystringNo
BankNameStartsWithquerystringNo
BankNameEndsWithquerystringNo
BankNameContainsquerystringNo
BankNameLikequerystringNo
BankNameBetweenquerystring[]No
BankNameInquerystring[]No
BankAccquerystringNo
BankAccStartsWithquerystringNo
BankAccEndsWithquerystringNo
BankAccContainsquerystringNo
BankAccLikequerystringNo
BankAccBetweenquerystring[]No
BankAccInquerystring[]No
BSBNquerystringNo
BSBNStartsWithquerystringNo
BSBNEndsWithquerystringNo
BSBNContainsquerystringNo
BSBNLikequerystringNo
BSBNBetweenquerystring[]No
BSBNInquerystring[]No
AccountNamequerystringNo
AccountNameStartsWithquerystringNo
AccountNameEndsWithquerystringNo
AccountNameContainsquerystringNo
AccountNameLikequerystringNo
AccountNameBetweenquerystring[]No
AccountNameInquerystring[]No
ParentAccountIDquerystringNo
ParentAccountIDStartsWithquerystringNo
ParentAccountIDEndsWithquerystringNo
ParentAccountIDContainsquerystringNo
ParentAccountIDLikequerystringNo
ParentAccountIDBetweenquerystring[]No
ParentAccountIDInquerystring[]No
TaxIDquerystringNo
TaxIDStartsWithquerystringNo
TaxIDEndsWithquerystringNo
TaxIDContainsquerystringNo
TaxIDLikequerystringNo
TaxIDBetweenquerystring[]No
TaxIDInquerystring[]No
TaxRatequerydecimal?No
TaxRateGreaterThanOrEqualToquerydecimal?No
TaxRateGreaterThanquerydecimal?No
TaxRateLessThanquerydecimal?No
TaxRateLessThanOrEqualToquerydecimal?No
TaxRateNotEqualToquerydecimal?No
TaxRateBetweenqueryNullable<Decimal>[]No
TaxRateInqueryNullable<Decimal>[]No
TaxAmountquerydecimal?No
TaxAmountGreaterThanOrEqualToquerydecimal?No
TaxAmountGreaterThanquerydecimal?No
TaxAmountLessThanquerydecimal?No
TaxAmountLessThanOrEqualToquerydecimal?No
TaxAmountNotEqualToquerydecimal?No
TaxAmountBetweenqueryNullable<Decimal>[]No
TaxAmountInqueryNullable<Decimal>[]No
TaxLedgerIDquerystringNo
TaxLedgerIDStartsWithquerystringNo
TaxLedgerIDEndsWithquerystringNo
TaxLedgerIDContainsquerystringNo
TaxLedgerIDLikequerystringNo
TaxLedgerIDBetweenquerystring[]No
TaxLedgerIDInquerystring[]No
DiscountAmountquerydecimal?No
DiscountAmountGreaterThanOrEqualToquerydecimal?No
DiscountAmountGreaterThanquerydecimal?No
DiscountAmountLessThanquerydecimal?No
DiscountAmountLessThanOrEqualToquerydecimal?No
DiscountAmountNotEqualToquerydecimal?No
DiscountAmountBetweenqueryNullable<Decimal>[]No
DiscountAmountInqueryNullable<Decimal>[]No
DiscountLedgerIDquerystringNo
DiscountLedgerIDStartsWithquerystringNo
DiscountLedgerIDEndsWithquerystringNo
DiscountLedgerIDContainsquerystringNo
DiscountLedgerIDLikequerystringNo
DiscountLedgerIDBetweenquerystring[]No
DiscountLedgerIDInquerystring[]No
DiscountTransIDquerystringNo
DiscountTransIDStartsWithquerystringNo
DiscountTransIDEndsWithquerystringNo
DiscountTransIDContainsquerystringNo
DiscountTransIDLikequerystringNo
DiscountTransIDBetweenquerystring[]No
DiscountTransIDInquerystring[]No
HomeTaxIDquerystringNo
HomeTaxIDStartsWithquerystringNo
HomeTaxIDEndsWithquerystringNo
HomeTaxIDContainsquerystringNo
HomeTaxIDLikequerystringNo
HomeTaxIDBetweenquerystring[]No
HomeTaxIDInquerystring[]No
HomeTaxRatequerydecimal?No
HomeTaxRateGreaterThanOrEqualToquerydecimal?No
HomeTaxRateGreaterThanquerydecimal?No
HomeTaxRateLessThanquerydecimal?No
HomeTaxRateLessThanOrEqualToquerydecimal?No
HomeTaxRateNotEqualToquerydecimal?No
HomeTaxRateBetweenqueryNullable<Decimal>[]No
HomeTaxRateInqueryNullable<Decimal>[]No
HomeTaxAmountquerydecimal?No
HomeTaxAmountGreaterThanOrEqualToquerydecimal?No
HomeTaxAmountGreaterThanquerydecimal?No
HomeTaxAmountLessThanquerydecimal?No
HomeTaxAmountLessThanOrEqualToquerydecimal?No
HomeTaxAmountNotEqualToquerydecimal?No
HomeTaxAmountBetweenqueryNullable<Decimal>[]No
HomeTaxAmountInqueryNullable<Decimal>[]No
DiscountTaxIDquerystringNo
DiscountTaxIDStartsWithquerystringNo
DiscountTaxIDEndsWithquerystringNo
DiscountTaxIDContainsquerystringNo
DiscountTaxIDLikequerystringNo
DiscountTaxIDBetweenquerystring[]No
DiscountTaxIDInquerystring[]No
DiscountTaxRatequerydecimal?No
DiscountTaxRateGreaterThanOrEqualToquerydecimal?No
DiscountTaxRateGreaterThanquerydecimal?No
DiscountTaxRateLessThanquerydecimal?No
DiscountTaxRateLessThanOrEqualToquerydecimal?No
DiscountTaxRateNotEqualToquerydecimal?No
DiscountTaxRateBetweenqueryNullable<Decimal>[]No
DiscountTaxRateInqueryNullable<Decimal>[]No
DiscountTaxAmountquerydecimal?No
DiscountTaxAmountGreaterThanOrEqualToquerydecimal?No
DiscountTaxAmountGreaterThanquerydecimal?No
DiscountTaxAmountLessThanquerydecimal?No
DiscountTaxAmountLessThanOrEqualToquerydecimal?No
DiscountTaxAmountNotEqualToquerydecimal?No
DiscountTaxAmountBetweenqueryNullable<Decimal>[]No
DiscountTaxAmountInqueryNullable<Decimal>[]No
DueDatequeryDateTime?No
DueDateGreaterThanOrEqualToqueryDateTime?No
DueDateGreaterThanqueryDateTime?No
DueDateLessThanqueryDateTime?No
DueDateLessThanOrEqualToqueryDateTime?No
DueDateNotEqualToqueryDateTime?No
DueDateBetweenqueryNullable<DateTime>[]No
DueDateInqueryNullable<DateTime>[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
DB_BatchTranLines Parameters:
NameParameterData TypeRequiredDescription
ReceiptLineIDformstringNo
ReceiptIDformstringNo
LastSavedDateTimeformDateTime?No
AccountIDformstringNo
LedgerIDformstringNo
LineReferenceformstringNo
RemarkformstringNo
RemitNoformstringNo
Amountformdecimal?No
DBTransIDformstringNo
LineNumformintNo
OtherLedgerIDformstringNo
OtherAmountformdecimal?No
ReceiptDateformDateTime?No
BankNameformstringNo
BankAccformstringNo
BSBNformstringNo
AccountNameformstringNo
ParentAccountIDformstringNo
TaxIDformstringNo
TaxRateformdecimal?No
TaxAmountformdecimal?No
TaxLedgerIDformstringNo
DiscountAmountformdecimal?No
DiscountLedgerIDformstringNo
DiscountTransIDformstringNo
HomeTaxIDformstringNo
HomeTaxRateformdecimal?No
HomeTaxAmountformdecimal?No
DiscountTaxIDformstringNo
DiscountTaxRateformdecimal?No
DiscountTaxAmountformdecimal?No
DueDateformDateTime?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/DB_BatchTranLinesQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: text/csv
Content-Type: text/csv
Content-Length: length

{"ReceiptLineID":"String","ReceiptLineIDStartsWith":"String","ReceiptLineIDEndsWith":"String","ReceiptLineIDContains":"String","ReceiptLineIDLike":"String","ReceiptLineIDBetween":["String"],"ReceiptLineIDIn":["String"],"ReceiptID":"String","ReceiptIDStartsWith":"String","ReceiptIDEndsWith":"String","ReceiptIDContains":"String","ReceiptIDLike":"String","ReceiptIDBetween":["String"],"ReceiptIDIn":["String"],"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"],"AccountID":"String","AccountIDStartsWith":"String","AccountIDEndsWith":"String","AccountIDContains":"String","AccountIDLike":"String","AccountIDBetween":["String"],"AccountIDIn":["String"],"LedgerID":"String","LedgerIDStartsWith":"String","LedgerIDEndsWith":"String","LedgerIDContains":"String","LedgerIDLike":"String","LedgerIDBetween":["String"],"LedgerIDIn":["String"],"LineReference":"String","LineReferenceStartsWith":"String","LineReferenceEndsWith":"String","LineReferenceContains":"String","LineReferenceLike":"String","LineReferenceBetween":["String"],"LineReferenceIn":["String"],"Remark":"String","RemarkStartsWith":"String","RemarkEndsWith":"String","RemarkContains":"String","RemarkLike":"String","RemarkBetween":["String"],"RemarkIn":["String"],"RemitNo":"String","RemitNoStartsWith":"String","RemitNoEndsWith":"String","RemitNoContains":"String","RemitNoLike":"String","RemitNoBetween":["String"],"RemitNoIn":["String"],"Amount":0,"AmountGreaterThanOrEqualTo":0,"AmountGreaterThan":0,"AmountLessThan":0,"AmountLessThanOrEqualTo":0,"AmountNotEqualTo":0,"AmountBetween":[0],"AmountIn":[0],"DBTransID":"String","DBTransIDStartsWith":"String","DBTransIDEndsWith":"String","DBTransIDContains":"String","DBTransIDLike":"String","DBTransIDBetween":["String"],"DBTransIDIn":["String"],"LineNum":0,"LineNumGreaterThanOrEqualTo":0,"LineNumGreaterThan":0,"LineNumLessThan":0,"LineNumLessThanOrEqualTo":0,"LineNumNotEqualTo":0,"LineNumBetween":[0],"LineNumIn":[0],"OtherLedgerID":"String","OtherLedgerIDStartsWith":"String","OtherLedgerIDEndsWith":"String","OtherLedgerIDContains":"String","OtherLedgerIDLike":"String","OtherLedgerIDBetween":["String"],"OtherLedgerIDIn":["String"],"OtherAmount":0,"OtherAmountGreaterThanOrEqualTo":0,"OtherAmountGreaterThan":0,"OtherAmountLessThan":0,"OtherAmountLessThanOrEqualTo":0,"OtherAmountNotEqualTo":0,"OtherAmountBetween":[0],"OtherAmountIn":[0],"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"],"BankName":"String","BankNameStartsWith":"String","BankNameEndsWith":"String","BankNameContains":"String","BankNameLike":"String","BankNameBetween":["String"],"BankNameIn":["String"],"BankAcc":"String","BankAccStartsWith":"String","BankAccEndsWith":"String","BankAccContains":"String","BankAccLike":"String","BankAccBetween":["String"],"BankAccIn":["String"],"BSBN":"String","BSBNStartsWith":"String","BSBNEndsWith":"String","BSBNContains":"String","BSBNLike":"String","BSBNBetween":["String"],"BSBNIn":["String"],"AccountName":"String","AccountNameStartsWith":"String","AccountNameEndsWith":"String","AccountNameContains":"String","AccountNameLike":"String","AccountNameBetween":["String"],"AccountNameIn":["String"],"ParentAccountID":"String","ParentAccountIDStartsWith":"String","ParentAccountIDEndsWith":"String","ParentAccountIDContains":"String","ParentAccountIDLike":"String","ParentAccountIDBetween":["String"],"ParentAccountIDIn":["String"],"TaxID":"String","TaxIDStartsWith":"String","TaxIDEndsWith":"String","TaxIDContains":"String","TaxIDLike":"String","TaxIDBetween":["String"],"TaxIDIn":["String"],"TaxRate":0,"TaxRateGreaterThanOrEqualTo":0,"TaxRateGreaterThan":0,"TaxRateLessThan":0,"TaxRateLessThanOrEqualTo":0,"TaxRateNotEqualTo":0,"TaxRateBetween":[0],"TaxRateIn":[0],"TaxAmount":0,"TaxAmountGreaterThanOrEqualTo":0,"TaxAmountGreaterThan":0,"TaxAmountLessThan":0,"TaxAmountLessThanOrEqualTo":0,"TaxAmountNotEqualTo":0,"TaxAmountBetween":[0],"TaxAmountIn":[0],"TaxLedgerID":"String","TaxLedgerIDStartsWith":"String","TaxLedgerIDEndsWith":"String","TaxLedgerIDContains":"String","TaxLedgerIDLike":"String","TaxLedgerIDBetween":["String"],"TaxLedgerIDIn":["String"],"DiscountAmount":0,"DiscountAmountGreaterThanOrEqualTo":0,"DiscountAmountGreaterThan":0,"DiscountAmountLessThan":0,"DiscountAmountLessThanOrEqualTo":0,"DiscountAmountNotEqualTo":0,"DiscountAmountBetween":[0],"DiscountAmountIn":[0],"DiscountLedgerID":"String","DiscountLedgerIDStartsWith":"String","DiscountLedgerIDEndsWith":"String","DiscountLedgerIDContains":"String","DiscountLedgerIDLike":"String","DiscountLedgerIDBetween":["String"],"DiscountLedgerIDIn":["String"],"DiscountTransID":"String","DiscountTransIDStartsWith":"String","DiscountTransIDEndsWith":"String","DiscountTransIDContains":"String","DiscountTransIDLike":"String","DiscountTransIDBetween":["String"],"DiscountTransIDIn":["String"],"HomeTaxID":"String","HomeTaxIDStartsWith":"String","HomeTaxIDEndsWith":"String","HomeTaxIDContains":"String","HomeTaxIDLike":"String","HomeTaxIDBetween":["String"],"HomeTaxIDIn":["String"],"HomeTaxRate":0,"HomeTaxRateGreaterThanOrEqualTo":0,"HomeTaxRateGreaterThan":0,"HomeTaxRateLessThan":0,"HomeTaxRateLessThanOrEqualTo":0,"HomeTaxRateNotEqualTo":0,"HomeTaxRateBetween":[0],"HomeTaxRateIn":[0],"HomeTaxAmount":0,"HomeTaxAmountGreaterThanOrEqualTo":0,"HomeTaxAmountGreaterThan":0,"HomeTaxAmountLessThan":0,"HomeTaxAmountLessThanOrEqualTo":0,"HomeTaxAmountNotEqualTo":0,"HomeTaxAmountBetween":[0],"HomeTaxAmountIn":[0],"DiscountTaxID":"String","DiscountTaxIDStartsWith":"String","DiscountTaxIDEndsWith":"String","DiscountTaxIDContains":"String","DiscountTaxIDLike":"String","DiscountTaxIDBetween":["String"],"DiscountTaxIDIn":["String"],"DiscountTaxRate":0,"DiscountTaxRateGreaterThanOrEqualTo":0,"DiscountTaxRateGreaterThan":0,"DiscountTaxRateLessThan":0,"DiscountTaxRateLessThanOrEqualTo":0,"DiscountTaxRateNotEqualTo":0,"DiscountTaxRateBetween":[0],"DiscountTaxRateIn":[0],"DiscountTaxAmount":0,"DiscountTaxAmountGreaterThanOrEqualTo":0,"DiscountTaxAmountGreaterThan":0,"DiscountTaxAmountLessThan":0,"DiscountTaxAmountLessThanOrEqualTo":0,"DiscountTaxAmountNotEqualTo":0,"DiscountTaxAmountBetween":[0],"DiscountTaxAmountIn":[0],"DueDate":"0001-01-01T00:00:00.0000000","DueDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","DueDateGreaterThan":"0001-01-01T00:00:00.0000000","DueDateLessThan":"0001-01-01T00:00:00.0000000","DueDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","DueDateNotEqualTo":"0001-01-01T00:00:00.0000000","DueDateBetween":["0001-01-01T00:00:00.0000000"],"DueDateIn":["0001-01-01T00:00:00.0000000"],"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":[{"ReceiptLineID":"String","ReceiptID":"String","LastSavedDateTime":"0001-01-01T00:00:00.0000000","AccountID":"String","LedgerID":"String","LineReference":"String","Remark":"String","RemitNo":"String","Amount":0,"DBTransID":"String","OtherLedgerID":"String","OtherAmount":0,"ReceiptDate":"0001-01-01T00:00:00.0000000","BankName":"String","BankAcc":"String","BSBN":"String","AccountName":"String","ParentAccountID":"String","TaxID":"String","TaxRate":0,"TaxAmount":0,"TaxLedgerID":"String","DiscountAmount":0,"DiscountLedgerID":"String","DiscountTransID":"String","HomeTaxID":"String","HomeTaxRate":0,"HomeTaxAmount":0,"DiscountTaxID":"String","DiscountTaxRate":0,"DiscountTaxAmount":0,"DueDate":"0001-01-01T00:00:00.0000000"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}