| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| WH_TransferLineID | query | string | No | |
| WH_TransferLineIDStartsWith | query | string | No | |
| WH_TransferLineIDEndsWith | query | string | No | |
| WH_TransferLineIDContains | query | string | No | |
| WH_TransferLineIDLike | query | string | No | |
| WH_TransferLineIDBetween | query | string[] | No | |
| WH_TransferLineIDIn | query | string[] | No | |
| WH_TransferID | query | string | No | |
| WH_TransferIDStartsWith | query | string | No | |
| WH_TransferIDEndsWith | query | string | No | |
| WH_TransferIDContains | query | string | No | |
| WH_TransferIDLike | query | string | No | |
| WH_TransferIDBetween | query | string[] | No | |
| WH_TransferIDIn | query | string[] | No | |
| InventoryID | query | string | No | |
| InventoryIDStartsWith | query | string | No | |
| InventoryIDEndsWith | query | string | No | |
| InventoryIDContains | query | string | No | |
| InventoryIDLike | query | string | No | |
| InventoryIDBetween | query | string[] | No | |
| InventoryIDIn | query | string[] | 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 | |
| QtyWanted | query | decimal? | No | |
| QtyWantedGreaterThanOrEqualTo | query | decimal? | No | |
| QtyWantedGreaterThan | query | decimal? | No | |
| QtyWantedLessThan | query | decimal? | No | |
| QtyWantedLessThanOrEqualTo | query | decimal? | No | |
| QtyWantedNotEqualTo | query | decimal? | No | |
| QtyWantedBetween | query | Nullable<Decimal>[] | No | |
| QtyWantedIn | query | Nullable<Decimal>[] | No | |
| QtyTrans | query | decimal? | No | |
| QtyTransGreaterThanOrEqualTo | query | decimal? | No | |
| QtyTransGreaterThan | query | decimal? | No | |
| QtyTransLessThan | query | decimal? | No | |
| QtyTransLessThanOrEqualTo | query | decimal? | No | |
| QtyTransNotEqualTo | query | decimal? | No | |
| QtyTransBetween | query | Nullable<Decimal>[] | No | |
| QtyTransIn | query | Nullable<Decimal>[] | No | |
| Cost | query | decimal? | No | |
| CostGreaterThanOrEqualTo | query | decimal? | No | |
| CostGreaterThan | query | decimal? | No | |
| CostLessThan | query | decimal? | No | |
| CostLessThanOrEqualTo | query | decimal? | No | |
| CostNotEqualTo | query | decimal? | No | |
| CostBetween | query | Nullable<Decimal>[] | No | |
| CostIn | query | Nullable<Decimal>[] | No | |
| Ref | query | string | No | |
| RefStartsWith | query | string | No | |
| RefEndsWith | query | string | No | |
| RefContains | query | string | No | |
| RefLike | query | string | No | |
| RefBetween | query | string[] | No | |
| RefIn | query | string[] | No | |
| LineNum | query | short? | No | |
| LineNumGreaterThanOrEqualTo | query | short? | No | |
| LineNumGreaterThan | query | short? | No | |
| LineNumLessThan | query | short? | No | |
| LineNumLessThanOrEqualTo | query | short? | No | |
| LineNumNotEqualTo | query | short? | No | |
| LineNumBetween | query | short[] | No | |
| LineNumIn | query | short[] | No | |
| BackOrderID | query | string | No | |
| BackOrderIDStartsWith | query | string | No | |
| BackOrderIDEndsWith | query | string | No | |
| BackOrderIDContains | query | string | No | |
| BackOrderIDLike | query | string | No | |
| BackOrderIDBetween | query | string[] | No | |
| BackOrderIDIn | query | string[] | No | |
| PurchaseOrderID | query | string | No | |
| PurchaseOrderIDStartsWith | query | string | No | |
| PurchaseOrderIDEndsWith | query | string | No | |
| PurchaseOrderIDContains | query | string | No | |
| PurchaseOrderIDLike | query | string | No | |
| PurchaseOrderIDBetween | query | string[] | No | |
| PurchaseOrderIDIn | query | string[] | No | |
| PurchaseOrderLineID | query | string | No | |
| PurchaseOrderLineIDStartsWith | query | string | No | |
| PurchaseOrderLineIDEndsWith | query | string | No | |
| PurchaseOrderLineIDContains | query | string | No | |
| PurchaseOrderLineIDLike | query | string | No | |
| PurchaseOrderLineIDBetween | query | string[] | No | |
| PurchaseOrderLineIDIn | query | string[] | No | |
| DestinationBinLoc | query | string | No | |
| DestinationBinLocStartsWith | query | string | No | |
| DestinationBinLocEndsWith | query | string | No | |
| DestinationBinLocContains | query | string | No | |
| DestinationBinLocLike | query | string | No | |
| DestinationBinLocBetween | query | string[] | No | |
| DestinationBinLocIn | query | string[] | No | |
| QtyReceived | query | decimal? | No | |
| QtyReceivedGreaterThanOrEqualTo | query | decimal? | No | |
| QtyReceivedGreaterThan | query | decimal? | No | |
| QtyReceivedLessThan | query | decimal? | No | |
| QtyReceivedLessThanOrEqualTo | query | decimal? | No | |
| QtyReceivedNotEqualTo | query | decimal? | No | |
| QtyReceivedBetween | query | decimal[] | No | |
| QtyReceivedIn | query | decimal[] | No | |
| LinkID | query | string | No | |
| LinkIDStartsWith | query | string | No | |
| LinkIDEndsWith | query | string | No | |
| LinkIDContains | query | string | No | |
| LinkIDLike | query | string | No | |
| LinkIDBetween | query | string[] | No | |
| LinkIDIn | query | string[] | No | |
| AddCostLedgerID1 | query | string | No | |
| AddCostLedgerID1StartsWith | query | string | No | |
| AddCostLedgerID1EndsWith | query | string | No | |
| AddCostLedgerID1Contains | query | string | No | |
| AddCostLedgerID1Like | query | string | No | |
| AddCostLedgerID1Between | query | string[] | No | |
| AddCostLedgerID1In | query | string[] | No | |
| AddCostLedgerID2 | query | string | No | |
| AddCostLedgerID2StartsWith | query | string | No | |
| AddCostLedgerID2EndsWith | query | string | No | |
| AddCostLedgerID2Contains | query | string | No | |
| AddCostLedgerID2Like | query | string | No | |
| AddCostLedgerID2Between | query | string[] | No | |
| AddCostLedgerID2In | query | string[] | No | |
| AddCostLedgerID3 | query | string | No | |
| AddCostLedgerID3StartsWith | query | string | No | |
| AddCostLedgerID3EndsWith | query | string | No | |
| AddCostLedgerID3Contains | query | string | No | |
| AddCostLedgerID3Like | query | string | No | |
| AddCostLedgerID3Between | query | string[] | No | |
| AddCostLedgerID3In | query | string[] | No | |
| Weight | query | decimal? | No | |
| WeightGreaterThanOrEqualTo | query | decimal? | No | |
| WeightGreaterThan | query | decimal? | No | |
| WeightLessThan | query | decimal? | No | |
| WeightLessThanOrEqualTo | query | decimal? | No | |
| WeightNotEqualTo | query | decimal? | No | |
| WeightBetween | query | decimal[] | No | |
| WeightIn | query | decimal[] | No | |
| Cubic | query | decimal? | No | |
| CubicGreaterThanOrEqualTo | query | decimal? | No | |
| CubicGreaterThan | query | decimal? | No | |
| CubicLessThan | query | decimal? | No | |
| CubicLessThanOrEqualTo | query | decimal? | No | |
| CubicNotEqualTo | query | decimal? | No | |
| CubicBetween | query | decimal[] | No | |
| CubicIn | query | decimal[] | No | |
| QtyBackOrdered | query | decimal? | No | |
| QtyBackOrderedGreaterThanOrEqualTo | query | decimal? | No | |
| QtyBackOrderedGreaterThan | query | decimal? | No | |
| QtyBackOrderedLessThan | query | decimal? | No | |
| QtyBackOrderedLessThanOrEqualTo | query | decimal? | No | |
| QtyBackOrderedNotEqualTo | query | decimal? | No | |
| QtyBackOrderedBetween | query | decimal[] | No | |
| QtyBackOrderedIn | query | decimal[] | 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 | DateTime[] | No | |
| LastSavedDateTimeIn | query | DateTime[] | 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 |
|---|---|---|---|---|
| WH_TransferLineID | form | string | No | |
| WH_TransferID | form | string | No | |
| InventoryID | form | string | No | |
| PartNo | form | string | No | |
| Description | form | string | No | |
| QtyWanted | form | decimal? | No | |
| QtyTrans | form | decimal? | No | |
| Cost | form | decimal? | No | |
| Ref | form | string | No | |
| LineNum | form | short | No | |
| BackOrderID | form | string | No | |
| PurchaseOrderID | form | string | No | |
| PurchaseOrderLineID | form | string | No | |
| DestinationBinLoc | form | string | No | |
| QtyReceived | form | decimal | No | |
| LinkID | form | string | No | |
| AddCostLedgerID1 | form | string | No | |
| AddCostLedgerID2 | form | string | No | |
| AddCostLedgerID3 | form | string | No | |
| Weight | form | decimal | No | |
| Cubic | form | decimal | No | |
| QtyBackOrdered | form | decimal | No | |
| LastSavedDateTime | form | DateTime | 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/WH_TransferLinesQuery HTTP/1.1
Host: api.jiwa.com.au
Accept: text/csv
Content-Type: text/csv
Content-Length: length
{"WH_TransferLineID":"String","WH_TransferLineIDStartsWith":"String","WH_TransferLineIDEndsWith":"String","WH_TransferLineIDContains":"String","WH_TransferLineIDLike":"String","WH_TransferLineIDBetween":["String"],"WH_TransferLineIDIn":["String"],"WH_TransferID":"String","WH_TransferIDStartsWith":"String","WH_TransferIDEndsWith":"String","WH_TransferIDContains":"String","WH_TransferIDLike":"String","WH_TransferIDBetween":["String"],"WH_TransferIDIn":["String"],"InventoryID":"String","InventoryIDStartsWith":"String","InventoryIDEndsWith":"String","InventoryIDContains":"String","InventoryIDLike":"String","InventoryIDBetween":["String"],"InventoryIDIn":["String"],"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"],"QtyWanted":0,"QtyWantedGreaterThanOrEqualTo":0,"QtyWantedGreaterThan":0,"QtyWantedLessThan":0,"QtyWantedLessThanOrEqualTo":0,"QtyWantedNotEqualTo":0,"QtyWantedBetween":[0],"QtyWantedIn":[0],"QtyTrans":0,"QtyTransGreaterThanOrEqualTo":0,"QtyTransGreaterThan":0,"QtyTransLessThan":0,"QtyTransLessThanOrEqualTo":0,"QtyTransNotEqualTo":0,"QtyTransBetween":[0],"QtyTransIn":[0],"Cost":0,"CostGreaterThanOrEqualTo":0,"CostGreaterThan":0,"CostLessThan":0,"CostLessThanOrEqualTo":0,"CostNotEqualTo":0,"CostBetween":[0],"CostIn":[0],"Ref":"String","RefStartsWith":"String","RefEndsWith":"String","RefContains":"String","RefLike":"String","RefBetween":["String"],"RefIn":["String"],"LineNum":0,"LineNumGreaterThanOrEqualTo":0,"LineNumGreaterThan":0,"LineNumLessThan":0,"LineNumLessThanOrEqualTo":0,"LineNumNotEqualTo":0,"LineNumBetween":[0],"LineNumIn":[0],"BackOrderID":"String","BackOrderIDStartsWith":"String","BackOrderIDEndsWith":"String","BackOrderIDContains":"String","BackOrderIDLike":"String","BackOrderIDBetween":["String"],"BackOrderIDIn":["String"],"PurchaseOrderID":"String","PurchaseOrderIDStartsWith":"String","PurchaseOrderIDEndsWith":"String","PurchaseOrderIDContains":"String","PurchaseOrderIDLike":"String","PurchaseOrderIDBetween":["String"],"PurchaseOrderIDIn":["String"],"PurchaseOrderLineID":"String","PurchaseOrderLineIDStartsWith":"String","PurchaseOrderLineIDEndsWith":"String","PurchaseOrderLineIDContains":"String","PurchaseOrderLineIDLike":"String","PurchaseOrderLineIDBetween":["String"],"PurchaseOrderLineIDIn":["String"],"DestinationBinLoc":"String","DestinationBinLocStartsWith":"String","DestinationBinLocEndsWith":"String","DestinationBinLocContains":"String","DestinationBinLocLike":"String","DestinationBinLocBetween":["String"],"DestinationBinLocIn":["String"],"QtyReceived":0,"QtyReceivedGreaterThanOrEqualTo":0,"QtyReceivedGreaterThan":0,"QtyReceivedLessThan":0,"QtyReceivedLessThanOrEqualTo":0,"QtyReceivedNotEqualTo":0,"QtyReceivedBetween":[0],"QtyReceivedIn":[0],"LinkID":"String","LinkIDStartsWith":"String","LinkIDEndsWith":"String","LinkIDContains":"String","LinkIDLike":"String","LinkIDBetween":["String"],"LinkIDIn":["String"],"AddCostLedgerID1":"String","AddCostLedgerID1StartsWith":"String","AddCostLedgerID1EndsWith":"String","AddCostLedgerID1Contains":"String","AddCostLedgerID1Like":"String","AddCostLedgerID1Between":["String"],"AddCostLedgerID1In":["String"],"AddCostLedgerID2":"String","AddCostLedgerID2StartsWith":"String","AddCostLedgerID2EndsWith":"String","AddCostLedgerID2Contains":"String","AddCostLedgerID2Like":"String","AddCostLedgerID2Between":["String"],"AddCostLedgerID2In":["String"],"AddCostLedgerID3":"String","AddCostLedgerID3StartsWith":"String","AddCostLedgerID3EndsWith":"String","AddCostLedgerID3Contains":"String","AddCostLedgerID3Like":"String","AddCostLedgerID3Between":["String"],"AddCostLedgerID3In":["String"],"Weight":0,"WeightGreaterThanOrEqualTo":0,"WeightGreaterThan":0,"WeightLessThan":0,"WeightLessThanOrEqualTo":0,"WeightNotEqualTo":0,"WeightBetween":[0],"WeightIn":[0],"Cubic":0,"CubicGreaterThanOrEqualTo":0,"CubicGreaterThan":0,"CubicLessThan":0,"CubicLessThanOrEqualTo":0,"CubicNotEqualTo":0,"CubicBetween":[0],"CubicIn":[0],"QtyBackOrdered":0,"QtyBackOrderedGreaterThanOrEqualTo":0,"QtyBackOrderedGreaterThan":0,"QtyBackOrderedLessThan":0,"QtyBackOrderedLessThanOrEqualTo":0,"QtyBackOrderedNotEqualTo":0,"QtyBackOrderedBetween":[0],"QtyBackOrderedIn":[0],"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"],"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":[{"WH_TransferLineID":"String","WH_TransferID":"String","InventoryID":"String","PartNo":"String","Description":"String","QtyWanted":0,"QtyTrans":0,"Cost":0,"Ref":"String","BackOrderID":"String","PurchaseOrderID":"String","PurchaseOrderLineID":"String","DestinationBinLoc":"String","LinkID":"String","AddCostLedgerID1":"String","AddCostLedgerID2":"String","AddCostLedgerID3":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}