| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| ReceiptLineID | query | string | No | |
| ReceiptLineIDStartsWith | query | string | No | |
| ReceiptLineIDEndsWith | query | string | No | |
| ReceiptLineIDContains | query | string | No | |
| ReceiptLineIDLike | query | string | No | |
| ReceiptLineIDBetween | query | string[] | No | |
| ReceiptLineIDIn | query | string[] | No | |
| ReceiptID | query | string | No | |
| ReceiptIDStartsWith | query | string | No | |
| ReceiptIDEndsWith | query | string | No | |
| ReceiptIDContains | query | string | No | |
| ReceiptIDLike | query | string | No | |
| ReceiptIDBetween | query | string[] | No | |
| ReceiptIDIn | query | string[] | No | |
| LastSavedDateTime | query | DateTime? | No | |
| LastSavedDateTimeGreaterThanOrEqualTo | query | DateTime? | No | |
| LastSavedDateTimeGreaterThan | query | DateTime? | No | |
| LastSavedDateTimeLessThan | query | DateTime? | No | |
| LastSavedDateTimeLessThanOrEqualTo | query | DateTime? | No | |
| LastSavedDateTimeNotEqualTo | query | DateTime? | No | |
| LastSavedDateTimeBetween | query | Nullable<DateTime>[] | No | |
| LastSavedDateTimeIn | query | Nullable<DateTime>[] | No | |
| AccountID | query | string | No | |
| AccountIDStartsWith | query | string | No | |
| AccountIDEndsWith | query | string | No | |
| AccountIDContains | query | string | No | |
| AccountIDLike | query | string | No | |
| AccountIDBetween | query | string[] | No | |
| AccountIDIn | query | string[] | No | |
| LedgerID | query | string | No | |
| LedgerIDStartsWith | query | string | No | |
| LedgerIDEndsWith | query | string | No | |
| LedgerIDContains | query | string | No | |
| LedgerIDLike | query | string | No | |
| LedgerIDBetween | query | string[] | No | |
| LedgerIDIn | query | string[] | No | |
| LineReference | query | string | No | |
| LineReferenceStartsWith | query | string | No | |
| LineReferenceEndsWith | query | string | No | |
| LineReferenceContains | query | string | No | |
| LineReferenceLike | query | string | No | |
| LineReferenceBetween | query | string[] | No | |
| LineReferenceIn | query | string[] | No | |
| Remark | query | string | No | |
| RemarkStartsWith | query | string | No | |
| RemarkEndsWith | query | string | No | |
| RemarkContains | query | string | No | |
| RemarkLike | query | string | No | |
| RemarkBetween | query | string[] | No | |
| RemarkIn | query | string[] | No | |
| RemitNo | query | string | No | |
| RemitNoStartsWith | query | string | No | |
| RemitNoEndsWith | query | string | No | |
| RemitNoContains | query | string | No | |
| RemitNoLike | query | string | No | |
| RemitNoBetween | query | string[] | No | |
| RemitNoIn | query | string[] | No | |
| HomeTransAmount | query | decimal? | No | |
| HomeTransAmountGreaterThanOrEqualTo | query | decimal? | No | |
| HomeTransAmountGreaterThan | query | decimal? | No | |
| HomeTransAmountLessThan | query | decimal? | No | |
| HomeTransAmountLessThanOrEqualTo | query | decimal? | No | |
| HomeTransAmountNotEqualTo | query | decimal? | No | |
| HomeTransAmountBetween | query | Nullable<Decimal>[] | No | |
| HomeTransAmountIn | query | Nullable<Decimal>[] | No | |
| LineNum | query | int? | No | |
| LineNumGreaterThanOrEqualTo | query | int? | No | |
| LineNumGreaterThan | query | int? | No | |
| LineNumLessThan | query | int? | No | |
| LineNumLessThanOrEqualTo | query | int? | No | |
| LineNumNotEqualTo | query | int? | No | |
| LineNumBetween | query | int[] | No | |
| LineNumIn | query | int[] | No | |
| OtherLedgerID | query | string | No | |
| OtherLedgerIDStartsWith | query | string | No | |
| OtherLedgerIDEndsWith | query | string | No | |
| OtherLedgerIDContains | query | string | No | |
| OtherLedgerIDLike | query | string | No | |
| OtherLedgerIDBetween | query | string[] | No | |
| OtherLedgerIDIn | query | string[] | No | |
| HomeDispAmount | query | decimal? | No | |
| HomeDispAmountGreaterThanOrEqualTo | query | decimal? | No | |
| HomeDispAmountGreaterThan | query | decimal? | No | |
| HomeDispAmountLessThan | query | decimal? | No | |
| HomeDispAmountLessThanOrEqualTo | query | decimal? | No | |
| HomeDispAmountNotEqualTo | query | decimal? | No | |
| HomeDispAmountBetween | query | Nullable<Decimal>[] | No | |
| HomeDispAmountIn | query | Nullable<Decimal>[] | No | |
| ReceiptDate | query | DateTime? | No | |
| ReceiptDateGreaterThanOrEqualTo | query | DateTime? | No | |
| ReceiptDateGreaterThan | query | DateTime? | No | |
| ReceiptDateLessThan | query | DateTime? | No | |
| ReceiptDateLessThanOrEqualTo | query | DateTime? | No | |
| ReceiptDateNotEqualTo | query | DateTime? | No | |
| ReceiptDateBetween | query | Nullable<DateTime>[] | No | |
| ReceiptDateIn | query | Nullable<DateTime>[] | No | |
| SupplierTransAmount | query | decimal? | No | |
| SupplierTransAmountGreaterThanOrEqualTo | query | decimal? | No | |
| SupplierTransAmountGreaterThan | query | decimal? | No | |
| SupplierTransAmountLessThan | query | decimal? | No | |
| SupplierTransAmountLessThanOrEqualTo | query | decimal? | No | |
| SupplierTransAmountNotEqualTo | query | decimal? | No | |
| SupplierTransAmountBetween | query | Nullable<Decimal>[] | No | |
| SupplierTransAmountIn | query | Nullable<Decimal>[] | No | |
| SupplierDispAmount | query | decimal? | No | |
| SupplierDispAmountGreaterThanOrEqualTo | query | decimal? | No | |
| SupplierDispAmountGreaterThan | query | decimal? | No | |
| SupplierDispAmountLessThan | query | decimal? | No | |
| SupplierDispAmountLessThanOrEqualTo | query | decimal? | No | |
| SupplierDispAmountNotEqualTo | query | decimal? | No | |
| SupplierDispAmountBetween | query | Nullable<Decimal>[] | No | |
| SupplierDispAmountIn | query | Nullable<Decimal>[] | No | |
| CurrencyRateUsed | query | decimal? | No | |
| CurrencyRateUsedGreaterThanOrEqualTo | query | decimal? | No | |
| CurrencyRateUsedGreaterThan | query | decimal? | No | |
| CurrencyRateUsedLessThan | query | decimal? | No | |
| CurrencyRateUsedLessThanOrEqualTo | query | decimal? | No | |
| CurrencyRateUsedNotEqualTo | query | decimal? | No | |
| CurrencyRateUsedBetween | query | Nullable<Decimal>[] | No | |
| CurrencyRateUsedIn | query | Nullable<Decimal>[] | No | |
| TaxID | query | string | No | |
| TaxIDStartsWith | query | string | No | |
| TaxIDEndsWith | query | string | No | |
| TaxIDContains | query | string | No | |
| TaxIDLike | query | string | No | |
| TaxIDBetween | query | string[] | No | |
| TaxIDIn | query | string[] | No | |
| TaxRate | query | decimal? | No | |
| TaxRateGreaterThanOrEqualTo | query | decimal? | No | |
| TaxRateGreaterThan | query | decimal? | No | |
| TaxRateLessThan | query | decimal? | No | |
| TaxRateLessThanOrEqualTo | query | decimal? | No | |
| TaxRateNotEqualTo | query | decimal? | No | |
| TaxRateBetween | query | Nullable<Decimal>[] | No | |
| TaxRateIn | query | Nullable<Decimal>[] | No | |
| TaxAmount | query | decimal? | No | |
| TaxAmountGreaterThanOrEqualTo | query | decimal? | No | |
| TaxAmountGreaterThan | query | decimal? | No | |
| TaxAmountLessThan | query | decimal? | No | |
| TaxAmountLessThanOrEqualTo | query | decimal? | No | |
| TaxAmountNotEqualTo | query | decimal? | No | |
| TaxAmountBetween | query | Nullable<Decimal>[] | No | |
| TaxAmountIn | query | Nullable<Decimal>[] | No | |
| DueDate | query | DateTime? | No | |
| DueDateGreaterThanOrEqualTo | query | DateTime? | No | |
| DueDateGreaterThan | query | DateTime? | No | |
| DueDateLessThan | query | DateTime? | No | |
| DueDateLessThanOrEqualTo | query | DateTime? | No | |
| DueDateNotEqualTo | query | DateTime? | No | |
| DueDateBetween | query | Nullable<DateTime>[] | No | |
| DueDateIn | query | Nullable<DateTime>[] | No | |
| HomeDispAmountIncGST | query | decimal? | No | |
| HomeDispAmountIncGSTGreaterThanOrEqualTo | query | decimal? | No | |
| HomeDispAmountIncGSTGreaterThan | query | decimal? | No | |
| HomeDispAmountIncGSTLessThan | query | decimal? | No | |
| HomeDispAmountIncGSTLessThanOrEqualTo | query | decimal? | No | |
| HomeDispAmountIncGSTNotEqualTo | query | decimal? | No | |
| HomeDispAmountIncGSTBetween | query | Nullable<Decimal>[] | No | |
| HomeDispAmountIncGSTIn | query | Nullable<Decimal>[] | No | |
| CurrencyID | query | string | No | |
| CurrencyIDStartsWith | query | string | No | |
| CurrencyIDEndsWith | query | string | No | |
| CurrencyIDContains | query | string | No | |
| CurrencyIDLike | query | string | No | |
| CurrencyIDBetween | query | string[] | No | |
| CurrencyIDIn | query | string[] | No | |
| JobChargeAmount | query | decimal? | No | |
| JobChargeAmountGreaterThanOrEqualTo | query | decimal? | No | |
| JobChargeAmountGreaterThan | query | decimal? | No | |
| JobChargeAmountLessThan | query | decimal? | No | |
| JobChargeAmountLessThanOrEqualTo | query | decimal? | No | |
| JobChargeAmountNotEqualTo | query | decimal? | No | |
| JobChargeAmountBetween | query | Nullable<Decimal>[] | No | |
| JobChargeAmountIn | query | Nullable<Decimal>[] | No | |
| JB_JobStages_RecID | query | string | No | |
| JB_JobStages_RecIDStartsWith | query | string | No | |
| JB_JobStages_RecIDEndsWith | query | string | No | |
| JB_JobStages_RecIDContains | query | string | No | |
| JB_JobStages_RecIDLike | query | string | No | |
| JB_JobStages_RecIDBetween | query | string[] | No | |
| JB_JobStages_RecIDIn | query | string[] | No |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| Skip | form | int? | No | |
| Take | form | int? | No | |
| OrderBy | form | string | No | |
| OrderByDesc | form | string | No | |
| Include | form | string | No | |
| Fields | form | string | No | |
| Meta | form | Dictionary<string, string> | No |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| ReceiptLineID | form | string | No | |
| ReceiptID | form | string | No | |
| LastSavedDateTime | form | DateTime? | No | |
| AccountID | form | string | No | |
| LedgerID | form | string | No | |
| LineReference | form | string | No | |
| Remark | form | string | No | |
| RemitNo | form | string | No | |
| HomeTransAmount | form | decimal? | No | |
| LineNum | form | int | No | |
| OtherLedgerID | form | string | No | |
| HomeDispAmount | form | decimal? | No | |
| ReceiptDate | form | DateTime? | No | |
| SupplierTransAmount | form | decimal? | No | |
| SupplierDispAmount | form | decimal? | No | |
| CurrencyRateUsed | form | decimal? | No | |
| TaxID | form | string | No | |
| TaxRate | form | decimal? | No | |
| TaxAmount | form | decimal? | No | |
| DueDate | form | DateTime? | No | |
| HomeDispAmountIncGST | form | decimal? | No | |
| CurrencyID | form | string | No | |
| JobChargeAmount | form | decimal? | No | |
| JB_JobStages_RecID | form | string | No |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| Offset | form | int | No | |
| Total | form | int | No | |
| Results | form | List<T> | No | |
| Meta | form | Dictionary<string, string> | No | |
| ResponseStatus | form | ResponseStatus | No |
To override the Content-type in your clients, use the HTTP Accept Header, append the .csv suffix or ?format=csv
The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.
POST /csv/reply/CR_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"],"HomeTransAmount":0,"HomeTransAmountGreaterThanOrEqualTo":0,"HomeTransAmountGreaterThan":0,"HomeTransAmountLessThan":0,"HomeTransAmountLessThanOrEqualTo":0,"HomeTransAmountNotEqualTo":0,"HomeTransAmountBetween":[0],"HomeTransAmountIn":[0],"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"],"HomeDispAmount":0,"HomeDispAmountGreaterThanOrEqualTo":0,"HomeDispAmountGreaterThan":0,"HomeDispAmountLessThan":0,"HomeDispAmountLessThanOrEqualTo":0,"HomeDispAmountNotEqualTo":0,"HomeDispAmountBetween":[0],"HomeDispAmountIn":[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"],"SupplierTransAmount":0,"SupplierTransAmountGreaterThanOrEqualTo":0,"SupplierTransAmountGreaterThan":0,"SupplierTransAmountLessThan":0,"SupplierTransAmountLessThanOrEqualTo":0,"SupplierTransAmountNotEqualTo":0,"SupplierTransAmountBetween":[0],"SupplierTransAmountIn":[0],"SupplierDispAmount":0,"SupplierDispAmountGreaterThanOrEqualTo":0,"SupplierDispAmountGreaterThan":0,"SupplierDispAmountLessThan":0,"SupplierDispAmountLessThanOrEqualTo":0,"SupplierDispAmountNotEqualTo":0,"SupplierDispAmountBetween":[0],"SupplierDispAmountIn":[0],"CurrencyRateUsed":0,"CurrencyRateUsedGreaterThanOrEqualTo":0,"CurrencyRateUsedGreaterThan":0,"CurrencyRateUsedLessThan":0,"CurrencyRateUsedLessThanOrEqualTo":0,"CurrencyRateUsedNotEqualTo":0,"CurrencyRateUsedBetween":[0],"CurrencyRateUsedIn":[0],"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],"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"],"HomeDispAmountIncGST":0,"HomeDispAmountIncGSTGreaterThanOrEqualTo":0,"HomeDispAmountIncGSTGreaterThan":0,"HomeDispAmountIncGSTLessThan":0,"HomeDispAmountIncGSTLessThanOrEqualTo":0,"HomeDispAmountIncGSTNotEqualTo":0,"HomeDispAmountIncGSTBetween":[0],"HomeDispAmountIncGSTIn":[0],"CurrencyID":"String","CurrencyIDStartsWith":"String","CurrencyIDEndsWith":"String","CurrencyIDContains":"String","CurrencyIDLike":"String","CurrencyIDBetween":["String"],"CurrencyIDIn":["String"],"JobChargeAmount":0,"JobChargeAmountGreaterThanOrEqualTo":0,"JobChargeAmountGreaterThan":0,"JobChargeAmountLessThan":0,"JobChargeAmountLessThanOrEqualTo":0,"JobChargeAmountNotEqualTo":0,"JobChargeAmountBetween":[0],"JobChargeAmountIn":[0],"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":[{"ReceiptLineID":"String","ReceiptID":"String","LastSavedDateTime":"0001-01-01T00:00:00.0000000","AccountID":"String","LedgerID":"String","LineReference":"String","Remark":"String","RemitNo":"String","HomeTransAmount":0,"OtherLedgerID":"String","HomeDispAmount":0,"ReceiptDate":"0001-01-01T00:00:00.0000000","SupplierTransAmount":0,"SupplierDispAmount":0,"CurrencyRateUsed":0,"TaxID":"String","TaxRate":0,"TaxAmount":0,"DueDate":"0001-01-01T00:00:00.0000000","HomeDispAmountIncGST":0,"CurrencyID":"String","JobChargeAmount":0,"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"}}}