| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| SOLineExtraRecID | query | string | No | |
| SOLineExtraRecIDStartsWith | query | string | No | |
| SOLineExtraRecIDEndsWith | query | string | No | |
| SOLineExtraRecIDContains | query | string | No | |
| SOLineExtraRecIDLike | query | string | No | |
| SOLineExtraRecIDBetween | query | string[] | No | |
| SOLineExtraRecIDIn | query | string[] | No | |
| InvoiceLineID | query | string | No | |
| InvoiceLineIDStartsWith | query | string | No | |
| InvoiceLineIDEndsWith | query | string | No | |
| InvoiceLineIDContains | query | string | No | |
| InvoiceLineIDLike | query | string | No | |
| InvoiceLineIDBetween | query | string[] | No | |
| InvoiceLineIDIn | query | string[] | No | |
| InvoiceHistoryID | query | string | No | |
| InvoiceHistoryIDStartsWith | query | string | No | |
| InvoiceHistoryIDEndsWith | query | string | No | |
| InvoiceHistoryIDContains | query | string | No | |
| InvoiceHistoryIDLike | query | string | No | |
| InvoiceHistoryIDBetween | query | string[] | No | |
| InvoiceHistoryIDIn | query | string[] | No | |
| LedgerReversePurchaseAccID | query | string | No | |
| LedgerReversePurchaseAccIDStartsWith | query | string | No | |
| LedgerReversePurchaseAccIDEndsWith | query | string | No | |
| LedgerReversePurchaseAccIDContains | query | string | No | |
| LedgerReversePurchaseAccIDLike | query | string | No | |
| LedgerReversePurchaseAccIDBetween | query | string[] | No | |
| LedgerReversePurchaseAccIDIn | query | string[] | No | |
| LedgerMovement_COGAccID | query | string | No | |
| LedgerMovement_COGAccIDStartsWith | query | string | No | |
| LedgerMovement_COGAccIDEndsWith | query | string | No | |
| LedgerMovement_COGAccIDContains | query | string | No | |
| LedgerMovement_COGAccIDLike | query | string | No | |
| LedgerMovement_COGAccIDBetween | query | string[] | No | |
| LedgerMovement_COGAccIDIn | query | string[] | No | |
| LedgerSalesAccID | query | string | No | |
| LedgerSalesAccIDStartsWith | query | string | No | |
| LedgerSalesAccIDEndsWith | query | string | No | |
| LedgerSalesAccIDContains | query | string | No | |
| LedgerSalesAccIDLike | query | string | No | |
| LedgerSalesAccIDBetween | query | string[] | No | |
| LedgerSalesAccIDIn | query | string[] | No | |
| LedgerSalesReturnsAccID | query | string | No | |
| LedgerSalesReturnsAccIDStartsWith | query | string | No | |
| LedgerSalesReturnsAccIDEndsWith | query | string | No | |
| LedgerSalesReturnsAccIDContains | query | string | No | |
| LedgerSalesReturnsAccIDLike | query | string | No | |
| LedgerSalesReturnsAccIDBetween | query | string[] | No | |
| LedgerSalesReturnsAccIDIn | query | string[] | No | |
| LedgerTaxLiabAccID | query | string | No | |
| LedgerTaxLiabAccIDStartsWith | query | string | No | |
| LedgerTaxLiabAccIDEndsWith | query | string | No | |
| LedgerTaxLiabAccIDContains | query | string | No | |
| LedgerTaxLiabAccIDLike | query | string | No | |
| LedgerTaxLiabAccIDBetween | query | string[] | No | |
| LedgerTaxLiabAccIDIn | query | string[] | No | |
| LedgerTaxExpAccID | query | string | No | |
| LedgerTaxExpAccIDStartsWith | query | string | No | |
| LedgerTaxExpAccIDEndsWith | query | string | No | |
| LedgerTaxExpAccIDContains | query | string | No | |
| LedgerTaxExpAccIDLike | query | string | No | |
| LedgerTaxExpAccIDBetween | query | string[] | No | |
| LedgerTaxExpAccIDIn | 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 |
|---|---|---|---|---|
| SOLineExtraRecID | form | string | No | |
| InvoiceLineID | form | string | No | |
| InvoiceHistoryID | form | string | No | |
| LedgerReversePurchaseAccID | form | string | No | |
| LedgerMovement_COGAccID | form | string | No | |
| LedgerSalesAccID | form | string | No | |
| LedgerSalesReturnsAccID | form | string | No | |
| LedgerTaxLiabAccID | form | string | No | |
| LedgerTaxExpAccID | 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/QO_LineExtraQuery HTTP/1.1
Host: api.jiwa.com.au
Accept: text/csv
Content-Type: text/csv
Content-Length: length
{"SOLineExtraRecID":"String","SOLineExtraRecIDStartsWith":"String","SOLineExtraRecIDEndsWith":"String","SOLineExtraRecIDContains":"String","SOLineExtraRecIDLike":"String","SOLineExtraRecIDBetween":["String"],"SOLineExtraRecIDIn":["String"],"InvoiceLineID":"String","InvoiceLineIDStartsWith":"String","InvoiceLineIDEndsWith":"String","InvoiceLineIDContains":"String","InvoiceLineIDLike":"String","InvoiceLineIDBetween":["String"],"InvoiceLineIDIn":["String"],"InvoiceHistoryID":"String","InvoiceHistoryIDStartsWith":"String","InvoiceHistoryIDEndsWith":"String","InvoiceHistoryIDContains":"String","InvoiceHistoryIDLike":"String","InvoiceHistoryIDBetween":["String"],"InvoiceHistoryIDIn":["String"],"LedgerReversePurchaseAccID":"String","LedgerReversePurchaseAccIDStartsWith":"String","LedgerReversePurchaseAccIDEndsWith":"String","LedgerReversePurchaseAccIDContains":"String","LedgerReversePurchaseAccIDLike":"String","LedgerReversePurchaseAccIDBetween":["String"],"LedgerReversePurchaseAccIDIn":["String"],"LedgerMovement_COGAccID":"String","LedgerMovement_COGAccIDStartsWith":"String","LedgerMovement_COGAccIDEndsWith":"String","LedgerMovement_COGAccIDContains":"String","LedgerMovement_COGAccIDLike":"String","LedgerMovement_COGAccIDBetween":["String"],"LedgerMovement_COGAccIDIn":["String"],"LedgerSalesAccID":"String","LedgerSalesAccIDStartsWith":"String","LedgerSalesAccIDEndsWith":"String","LedgerSalesAccIDContains":"String","LedgerSalesAccIDLike":"String","LedgerSalesAccIDBetween":["String"],"LedgerSalesAccIDIn":["String"],"LedgerSalesReturnsAccID":"String","LedgerSalesReturnsAccIDStartsWith":"String","LedgerSalesReturnsAccIDEndsWith":"String","LedgerSalesReturnsAccIDContains":"String","LedgerSalesReturnsAccIDLike":"String","LedgerSalesReturnsAccIDBetween":["String"],"LedgerSalesReturnsAccIDIn":["String"],"LedgerTaxLiabAccID":"String","LedgerTaxLiabAccIDStartsWith":"String","LedgerTaxLiabAccIDEndsWith":"String","LedgerTaxLiabAccIDContains":"String","LedgerTaxLiabAccIDLike":"String","LedgerTaxLiabAccIDBetween":["String"],"LedgerTaxLiabAccIDIn":["String"],"LedgerTaxExpAccID":"String","LedgerTaxExpAccIDStartsWith":"String","LedgerTaxExpAccIDEndsWith":"String","LedgerTaxExpAccIDContains":"String","LedgerTaxExpAccIDLike":"String","LedgerTaxExpAccIDBetween":["String"],"LedgerTaxExpAccIDIn":["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":[{"SOLineExtraRecID":"String","InvoiceLineID":"String","InvoiceHistoryID":"String","LedgerReversePurchaseAccID":"String","LedgerMovement_COGAccID":"String","LedgerSalesAccID":"String","LedgerSalesReturnsAccID":"String","LedgerTaxLiabAccID":"String","LedgerTaxExpAccID":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}