| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| InvoiceNo | query | string | No | |
| InvoiceNoStartsWith | query | string | No | |
| InvoiceNoEndsWith | query | string | No | |
| InvoiceNoContains | query | string | No | |
| InvoiceNoLike | query | string | No | |
| InvoiceNoBetween | query | string[] | No | |
| InvoiceNoIn | query | string[] | No | |
| RecordDate | query | DateTime? | No | |
| RecordDateGreaterThanOrEqualTo | query | DateTime? | No | |
| RecordDateGreaterThan | query | DateTime? | No | |
| RecordDateLessThan | query | DateTime? | No | |
| RecordDateLessThanOrEqualTo | query | DateTime? | No | |
| RecordDateNotEqualTo | query | DateTime? | No | |
| RecordDateBetween | query | Nullable<DateTime>[] | No | |
| RecordDateIn | query | Nullable<DateTime>[] | No | |
| OrderNo | query | string | No | |
| OrderNoStartsWith | query | string | No | |
| OrderNoEndsWith | query | string | No | |
| OrderNoContains | query | string | No | |
| OrderNoLike | query | string | No | |
| OrderNoBetween | query | string[] | No | |
| OrderNoIn | query | string[] | No | |
| DebtorID | query | string | No | |
| DebtorIDStartsWith | query | string | No | |
| DebtorIDEndsWith | query | string | No | |
| DebtorIDContains | query | string | No | |
| DebtorIDLike | query | string | No | |
| DebtorIDBetween | query | string[] | No | |
| DebtorIDIn | query | string[] | No | |
| HistoryNo | query | short? | No | |
| HistoryNoGreaterThanOrEqualTo | query | short? | No | |
| HistoryNoGreaterThan | query | short? | No | |
| HistoryNoLessThan | query | short? | No | |
| HistoryNoLessThanOrEqualTo | query | short? | No | |
| HistoryNoNotEqualTo | query | short? | No | |
| HistoryNoBetween | query | Nullable<Int16>[] | No | |
| HistoryNoIn | query | Nullable<Int16>[] | No | |
| PartNo | query | string | No | |
| PartNoStartsWith | query | string | No | |
| PartNoEndsWith | query | string | No | |
| PartNoContains | query | string | No | |
| PartNoLike | query | string | No | |
| PartNoBetween | query | string[] | No | |
| PartNoIn | query | string[] | No | |
| Description | query | string | No | |
| DescriptionStartsWith | query | string | No | |
| DescriptionEndsWith | query | string | No | |
| DescriptionContains | query | string | No | |
| DescriptionLike | query | string | No | |
| DescriptionBetween | query | string[] | No | |
| DescriptionIn | query | string[] | No | |
| QuantityOrdered | query | decimal? | No | |
| QuantityOrderedGreaterThanOrEqualTo | query | decimal? | No | |
| QuantityOrderedGreaterThan | query | decimal? | No | |
| QuantityOrderedLessThan | query | decimal? | No | |
| QuantityOrderedLessThanOrEqualTo | query | decimal? | No | |
| QuantityOrderedNotEqualTo | query | decimal? | No | |
| QuantityOrderedBetween | query | Nullable<Decimal>[] | No | |
| QuantityOrderedIn | query | Nullable<Decimal>[] | No | |
| QuantityThisDel | query | decimal? | No | |
| QuantityThisDelGreaterThanOrEqualTo | query | decimal? | No | |
| QuantityThisDelGreaterThan | query | decimal? | No | |
| QuantityThisDelLessThan | query | decimal? | No | |
| QuantityThisDelLessThanOrEqualTo | query | decimal? | No | |
| QuantityThisDelNotEqualTo | query | decimal? | No | |
| QuantityThisDelBetween | query | Nullable<Decimal>[] | No | |
| QuantityThisDelIn | query | Nullable<Decimal>[] | No | |
| QuantityBackord | query | decimal? | No | |
| QuantityBackordGreaterThanOrEqualTo | query | decimal? | No | |
| QuantityBackordGreaterThan | query | decimal? | No | |
| QuantityBackordLessThan | query | decimal? | No | |
| QuantityBackordLessThanOrEqualTo | query | decimal? | No | |
| QuantityBackordNotEqualTo | query | decimal? | No | |
| QuantityBackordBetween | query | Nullable<Decimal>[] | No | |
| QuantityBackordIn | query | Nullable<Decimal>[] | No | |
| QuantityPrevDel | query | decimal? | No | |
| QuantityPrevDelGreaterThanOrEqualTo | query | decimal? | No | |
| QuantityPrevDelGreaterThan | query | decimal? | No | |
| QuantityPrevDelLessThan | query | decimal? | No | |
| QuantityPrevDelLessThanOrEqualTo | query | decimal? | No | |
| QuantityPrevDelNotEqualTo | query | decimal? | No | |
| QuantityPrevDelBetween | query | Nullable<Decimal>[] | No | |
| QuantityPrevDelIn | query | Nullable<Decimal>[] | No | |
| ItemPrice | query | decimal? | No | |
| ItemPriceGreaterThanOrEqualTo | query | decimal? | No | |
| ItemPriceGreaterThan | query | decimal? | No | |
| ItemPriceLessThan | query | decimal? | No | |
| ItemPriceLessThanOrEqualTo | query | decimal? | No | |
| ItemPriceNotEqualTo | query | decimal? | No | |
| ItemPriceBetween | query | Nullable<Decimal>[] | No | |
| ItemPriceIn | query | Nullable<Decimal>[] | No | |
| TaxToCharge | query | decimal? | No | |
| TaxToChargeGreaterThanOrEqualTo | query | decimal? | No | |
| TaxToChargeGreaterThan | query | decimal? | No | |
| TaxToChargeLessThan | query | decimal? | No | |
| TaxToChargeLessThanOrEqualTo | query | decimal? | No | |
| TaxToChargeNotEqualTo | query | decimal? | No | |
| TaxToChargeBetween | query | Nullable<Decimal>[] | No | |
| TaxToChargeIn | query | Nullable<Decimal>[] | 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 | |
| RptType | query | string | No | |
| RptTypeStartsWith | query | string | No | |
| RptTypeEndsWith | query | string | No | |
| RptTypeContains | query | string | No | |
| RptTypeLike | query | string | No | |
| RptTypeBetween | query | string[] | No | |
| RptTypeIn | 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 |
|---|---|---|---|---|
| InvoiceNo | form | string | No | |
| RecordDate | form | DateTime? | No | |
| OrderNo | form | string | No | |
| DebtorID | form | string | No | |
| HistoryNo | form | short? | No | |
| PartNo | form | string | No | |
| Description | form | string | No | |
| QuantityOrdered | form | decimal? | No | |
| QuantityThisDel | form | decimal? | No | |
| QuantityBackord | form | decimal? | No | |
| QuantityPrevDel | form | decimal? | No | |
| ItemPrice | form | decimal? | No | |
| TaxToCharge | form | decimal? | No | |
| InvoiceLineID | form | string | No | |
| RptType | 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/V_Shipment_BOQuery HTTP/1.1
Host: api.jiwa.com.au
Accept: text/csv
Content-Type: text/csv
Content-Length: length
{"InvoiceNo":"String","InvoiceNoStartsWith":"String","InvoiceNoEndsWith":"String","InvoiceNoContains":"String","InvoiceNoLike":"String","InvoiceNoBetween":["String"],"InvoiceNoIn":["String"],"RecordDate":"0001-01-01T00:00:00.0000000","RecordDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","RecordDateGreaterThan":"0001-01-01T00:00:00.0000000","RecordDateLessThan":"0001-01-01T00:00:00.0000000","RecordDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","RecordDateNotEqualTo":"0001-01-01T00:00:00.0000000","RecordDateBetween":["0001-01-01T00:00:00.0000000"],"RecordDateIn":["0001-01-01T00:00:00.0000000"],"OrderNo":"String","OrderNoStartsWith":"String","OrderNoEndsWith":"String","OrderNoContains":"String","OrderNoLike":"String","OrderNoBetween":["String"],"OrderNoIn":["String"],"DebtorID":"String","DebtorIDStartsWith":"String","DebtorIDEndsWith":"String","DebtorIDContains":"String","DebtorIDLike":"String","DebtorIDBetween":["String"],"DebtorIDIn":["String"],"HistoryNo":0,"HistoryNoGreaterThanOrEqualTo":0,"HistoryNoGreaterThan":0,"HistoryNoLessThan":0,"HistoryNoLessThanOrEqualTo":0,"HistoryNoNotEqualTo":0,"HistoryNoBetween":[0],"HistoryNoIn":[0],"PartNo":"String","PartNoStartsWith":"String","PartNoEndsWith":"String","PartNoContains":"String","PartNoLike":"String","PartNoBetween":["String"],"PartNoIn":["String"],"Description":"String","DescriptionStartsWith":"String","DescriptionEndsWith":"String","DescriptionContains":"String","DescriptionLike":"String","DescriptionBetween":["String"],"DescriptionIn":["String"],"QuantityOrdered":0,"QuantityOrderedGreaterThanOrEqualTo":0,"QuantityOrderedGreaterThan":0,"QuantityOrderedLessThan":0,"QuantityOrderedLessThanOrEqualTo":0,"QuantityOrderedNotEqualTo":0,"QuantityOrderedBetween":[0],"QuantityOrderedIn":[0],"QuantityThisDel":0,"QuantityThisDelGreaterThanOrEqualTo":0,"QuantityThisDelGreaterThan":0,"QuantityThisDelLessThan":0,"QuantityThisDelLessThanOrEqualTo":0,"QuantityThisDelNotEqualTo":0,"QuantityThisDelBetween":[0],"QuantityThisDelIn":[0],"QuantityBackord":0,"QuantityBackordGreaterThanOrEqualTo":0,"QuantityBackordGreaterThan":0,"QuantityBackordLessThan":0,"QuantityBackordLessThanOrEqualTo":0,"QuantityBackordNotEqualTo":0,"QuantityBackordBetween":[0],"QuantityBackordIn":[0],"QuantityPrevDel":0,"QuantityPrevDelGreaterThanOrEqualTo":0,"QuantityPrevDelGreaterThan":0,"QuantityPrevDelLessThan":0,"QuantityPrevDelLessThanOrEqualTo":0,"QuantityPrevDelNotEqualTo":0,"QuantityPrevDelBetween":[0],"QuantityPrevDelIn":[0],"ItemPrice":0,"ItemPriceGreaterThanOrEqualTo":0,"ItemPriceGreaterThan":0,"ItemPriceLessThan":0,"ItemPriceLessThanOrEqualTo":0,"ItemPriceNotEqualTo":0,"ItemPriceBetween":[0],"ItemPriceIn":[0],"TaxToCharge":0,"TaxToChargeGreaterThanOrEqualTo":0,"TaxToChargeGreaterThan":0,"TaxToChargeLessThan":0,"TaxToChargeLessThanOrEqualTo":0,"TaxToChargeNotEqualTo":0,"TaxToChargeBetween":[0],"TaxToChargeIn":[0],"InvoiceLineID":"String","InvoiceLineIDStartsWith":"String","InvoiceLineIDEndsWith":"String","InvoiceLineIDContains":"String","InvoiceLineIDLike":"String","InvoiceLineIDBetween":["String"],"InvoiceLineIDIn":["String"],"RptType":"String","RptTypeStartsWith":"String","RptTypeEndsWith":"String","RptTypeContains":"String","RptTypeLike":"String","RptTypeBetween":["String"],"RptTypeIn":["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":[{"InvoiceNo":"String","RecordDate":"0001-01-01T00:00:00.0000000","OrderNo":"String","DebtorID":"String","HistoryNo":0,"PartNo":"String","Description":"String","QuantityOrdered":0,"QuantityThisDel":0,"QuantityBackord":0,"QuantityPrevDel":0,"ItemPrice":0,"TaxToCharge":0,"InvoiceLineID":"String","RptType":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}