| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| OrdersOnBackID | query | string | No | |
| OrdersOnBackIDStartsWith | query | string | No | |
| OrdersOnBackIDEndsWith | query | string | No | |
| OrdersOnBackIDContains | query | string | No | |
| OrdersOnBackIDLike | query | string | No | |
| OrdersOnBackIDBetween | query | string[] | No | |
| OrdersOnBackIDIn | 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 | |
| TranDate | query | DateTime? | No | |
| TranDateGreaterThanOrEqualTo | query | DateTime? | No | |
| TranDateGreaterThan | query | DateTime? | No | |
| TranDateLessThan | query | DateTime? | No | |
| TranDateLessThanOrEqualTo | query | DateTime? | No | |
| TranDateNotEqualTo | query | DateTime? | No | |
| TranDateBetween | query | Nullable<DateTime>[] | No | |
| TranDateIn | query | Nullable<DateTime>[] | No | |
| InvoiceType | query | short? | No | |
| InvoiceTypeGreaterThanOrEqualTo | query | short? | No | |
| InvoiceTypeGreaterThan | query | short? | No | |
| InvoiceTypeLessThan | query | short? | No | |
| InvoiceTypeLessThanOrEqualTo | query | short? | No | |
| InvoiceTypeNotEqualTo | query | short? | No | |
| InvoiceTypeBetween | query | Nullable<Int16>[] | No | |
| InvoiceTypeIn | query | Nullable<Int16>[] | No | |
| InvoiceID | query | string | No | |
| InvoiceIDStartsWith | query | string | No | |
| InvoiceIDEndsWith | query | string | No | |
| InvoiceIDContains | query | string | No | |
| InvoiceIDLike | query | string | No | |
| InvoiceIDBetween | query | string[] | No | |
| InvoiceIDIn | 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 | |
| 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 | |
| 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 | |
| OrderID | query | string | No | |
| OrderIDStartsWith | query | string | No | |
| OrderIDEndsWith | query | string | No | |
| OrderIDContains | query | string | No | |
| OrderIDLike | query | string | No | |
| OrderIDBetween | query | string[] | No | |
| OrderIDIn | query | string[] | No | |
| OrderLineID | query | string | No | |
| OrderLineIDStartsWith | query | string | No | |
| OrderLineIDEndsWith | query | string | No | |
| OrderLineIDContains | query | string | No | |
| OrderLineIDLike | query | string | No | |
| OrderLineIDBetween | query | string[] | No | |
| OrderLineIDIn | query | string[] | No | |
| Quantity | query | decimal? | No | |
| QuantityGreaterThanOrEqualTo | query | decimal? | No | |
| QuantityGreaterThan | query | decimal? | No | |
| QuantityLessThan | query | decimal? | No | |
| QuantityLessThanOrEqualTo | query | decimal? | No | |
| QuantityNotEqualTo | query | decimal? | No | |
| QuantityBetween | query | Nullable<Decimal>[] | No | |
| QuantityIn | query | Nullable<Decimal>[] | No | |
| Price | query | decimal? | No | |
| PriceGreaterThanOrEqualTo | query | decimal? | No | |
| PriceGreaterThan | query | decimal? | No | |
| PriceLessThan | query | decimal? | No | |
| PriceLessThanOrEqualTo | query | decimal? | No | |
| PriceNotEqualTo | query | decimal? | No | |
| PriceBetween | query | Nullable<Decimal>[] | No | |
| PriceIn | query | Nullable<Decimal>[] | No | |
| EstBOValue | query | decimal? | No | |
| EstBOValueGreaterThanOrEqualTo | query | decimal? | No | |
| EstBOValueGreaterThan | query | decimal? | No | |
| EstBOValueLessThan | query | decimal? | No | |
| EstBOValueLessThanOrEqualTo | query | decimal? | No | |
| EstBOValueNotEqualTo | query | decimal? | No | |
| EstBOValueBetween | query | Nullable<Decimal>[] | No | |
| EstBOValueIn | query | Nullable<Decimal>[] | No | |
| Priority | query | string | No | |
| PriorityStartsWith | query | string | No | |
| PriorityEndsWith | query | string | No | |
| PriorityContains | query | string | No | |
| PriorityLike | query | string | No | |
| PriorityBetween | query | string[] | No | |
| PriorityIn | query | string[] | No | |
| IN_LogicalID | query | string | No | |
| IN_LogicalIDStartsWith | query | string | No | |
| IN_LogicalIDEndsWith | query | string | No | |
| IN_LogicalIDContains | query | string | No | |
| IN_LogicalIDLike | query | string | No | |
| IN_LogicalIDBetween | query | string[] | No | |
| IN_LogicalIDIn | query | string[] | No | |
| ForLogicalID | query | string | No | |
| ForLogicalIDStartsWith | query | string | No | |
| ForLogicalIDEndsWith | query | string | No | |
| ForLogicalIDContains | query | string | No | |
| ForLogicalIDLike | query | string | No | |
| ForLogicalIDBetween | query | string[] | No | |
| ForLogicalIDIn | query | string[] | No | |
| ForAnotherWarehouse | query | short? | No | |
| ForAnotherWarehouseGreaterThanOrEqualTo | query | short? | No | |
| ForAnotherWarehouseGreaterThan | query | short? | No | |
| ForAnotherWarehouseLessThan | query | short? | No | |
| ForAnotherWarehouseLessThanOrEqualTo | query | short? | No | |
| ForAnotherWarehouseNotEqualTo | query | short? | No | |
| ForAnotherWarehouseBetween | query | Nullable<Int16>[] | No | |
| ForAnotherWarehouseIn | query | Nullable<Int16>[] | No | |
| INAssemblyID | query | string | No | |
| INAssemblyIDStartsWith | query | string | No | |
| INAssemblyIDEndsWith | query | string | No | |
| INAssemblyIDContains | query | string | No | |
| INAssemblyIDLike | query | string | No | |
| INAssemblyIDBetween | query | string[] | No | |
| INAssemblyIDIn | query | string[] | No | |
| BackOrderMode | query | short? | No | |
| BackOrderModeGreaterThanOrEqualTo | query | short? | No | |
| BackOrderModeGreaterThan | query | short? | No | |
| BackOrderModeLessThan | query | short? | No | |
| BackOrderModeLessThanOrEqualTo | query | short? | No | |
| BackOrderModeNotEqualTo | query | short? | No | |
| BackOrderModeBetween | query | Nullable<Int16>[] | No | |
| BackOrderModeIn | query | Nullable<Int16>[] | No | |
| PriorityWeight | query | int? | No | |
| PriorityWeightGreaterThanOrEqualTo | query | int? | No | |
| PriorityWeightGreaterThan | query | int? | No | |
| PriorityWeightLessThan | query | int? | No | |
| PriorityWeightLessThanOrEqualTo | query | int? | No | |
| PriorityWeightNotEqualTo | query | int? | No | |
| PriorityWeightBetween | query | Nullable<Int32>[] | No | |
| PriorityWeightIn | query | Nullable<Int32>[] | 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 |
|---|---|---|---|---|
| OrdersOnBackID | form | string | No | |
| LastSavedDateTime | form | DateTime? | No | |
| TranDate | form | DateTime? | No | |
| InvoiceType | form | short? | No | |
| InvoiceID | form | string | No | |
| InvoiceLineID | form | string | No | |
| DebtorID | form | string | No | |
| InventoryID | form | string | No | |
| OrderID | form | string | No | |
| OrderLineID | form | string | No | |
| Quantity | form | decimal? | No | |
| Price | form | decimal? | No | |
| EstBOValue | form | decimal? | No | |
| Priority | form | string | No | |
| IN_LogicalID | form | string | No | |
| ForLogicalID | form | string | No | |
| ForAnotherWarehouse | form | short? | No | |
| INAssemblyID | form | string | No | |
| BackOrderMode | form | short? | No | |
| PriorityWeight | form | int? | 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/IN_OnBackOrderQuery HTTP/1.1
Host: localhost
Accept: text/csv
Content-Type: text/csv
Content-Length: length
{"OrdersOnBackID":"String","OrdersOnBackIDStartsWith":"String","OrdersOnBackIDEndsWith":"String","OrdersOnBackIDContains":"String","OrdersOnBackIDLike":"String","OrdersOnBackIDBetween":["String"],"OrdersOnBackIDIn":["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"],"TranDate":"0001-01-01T00:00:00.0000000","TranDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","TranDateGreaterThan":"0001-01-01T00:00:00.0000000","TranDateLessThan":"0001-01-01T00:00:00.0000000","TranDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","TranDateNotEqualTo":"0001-01-01T00:00:00.0000000","TranDateBetween":["0001-01-01T00:00:00.0000000"],"TranDateIn":["0001-01-01T00:00:00.0000000"],"InvoiceType":0,"InvoiceTypeGreaterThanOrEqualTo":0,"InvoiceTypeGreaterThan":0,"InvoiceTypeLessThan":0,"InvoiceTypeLessThanOrEqualTo":0,"InvoiceTypeNotEqualTo":0,"InvoiceTypeBetween":[0],"InvoiceTypeIn":[0],"InvoiceID":"String","InvoiceIDStartsWith":"String","InvoiceIDEndsWith":"String","InvoiceIDContains":"String","InvoiceIDLike":"String","InvoiceIDBetween":["String"],"InvoiceIDIn":["String"],"InvoiceLineID":"String","InvoiceLineIDStartsWith":"String","InvoiceLineIDEndsWith":"String","InvoiceLineIDContains":"String","InvoiceLineIDLike":"String","InvoiceLineIDBetween":["String"],"InvoiceLineIDIn":["String"],"DebtorID":"String","DebtorIDStartsWith":"String","DebtorIDEndsWith":"String","DebtorIDContains":"String","DebtorIDLike":"String","DebtorIDBetween":["String"],"DebtorIDIn":["String"],"InventoryID":"String","InventoryIDStartsWith":"String","InventoryIDEndsWith":"String","InventoryIDContains":"String","InventoryIDLike":"String","InventoryIDBetween":["String"],"InventoryIDIn":["String"],"OrderID":"String","OrderIDStartsWith":"String","OrderIDEndsWith":"String","OrderIDContains":"String","OrderIDLike":"String","OrderIDBetween":["String"],"OrderIDIn":["String"],"OrderLineID":"String","OrderLineIDStartsWith":"String","OrderLineIDEndsWith":"String","OrderLineIDContains":"String","OrderLineIDLike":"String","OrderLineIDBetween":["String"],"OrderLineIDIn":["String"],"Quantity":0,"QuantityGreaterThanOrEqualTo":0,"QuantityGreaterThan":0,"QuantityLessThan":0,"QuantityLessThanOrEqualTo":0,"QuantityNotEqualTo":0,"QuantityBetween":[0],"QuantityIn":[0],"Price":0,"PriceGreaterThanOrEqualTo":0,"PriceGreaterThan":0,"PriceLessThan":0,"PriceLessThanOrEqualTo":0,"PriceNotEqualTo":0,"PriceBetween":[0],"PriceIn":[0],"EstBOValue":0,"EstBOValueGreaterThanOrEqualTo":0,"EstBOValueGreaterThan":0,"EstBOValueLessThan":0,"EstBOValueLessThanOrEqualTo":0,"EstBOValueNotEqualTo":0,"EstBOValueBetween":[0],"EstBOValueIn":[0],"Priority":"String","PriorityStartsWith":"String","PriorityEndsWith":"String","PriorityContains":"String","PriorityLike":"String","PriorityBetween":["String"],"PriorityIn":["String"],"IN_LogicalID":"String","IN_LogicalIDStartsWith":"String","IN_LogicalIDEndsWith":"String","IN_LogicalIDContains":"String","IN_LogicalIDLike":"String","IN_LogicalIDBetween":["String"],"IN_LogicalIDIn":["String"],"ForLogicalID":"String","ForLogicalIDStartsWith":"String","ForLogicalIDEndsWith":"String","ForLogicalIDContains":"String","ForLogicalIDLike":"String","ForLogicalIDBetween":["String"],"ForLogicalIDIn":["String"],"ForAnotherWarehouse":0,"ForAnotherWarehouseGreaterThanOrEqualTo":0,"ForAnotherWarehouseGreaterThan":0,"ForAnotherWarehouseLessThan":0,"ForAnotherWarehouseLessThanOrEqualTo":0,"ForAnotherWarehouseNotEqualTo":0,"ForAnotherWarehouseBetween":[0],"ForAnotherWarehouseIn":[0],"INAssemblyID":"String","INAssemblyIDStartsWith":"String","INAssemblyIDEndsWith":"String","INAssemblyIDContains":"String","INAssemblyIDLike":"String","INAssemblyIDBetween":["String"],"INAssemblyIDIn":["String"],"BackOrderMode":0,"BackOrderModeGreaterThanOrEqualTo":0,"BackOrderModeGreaterThan":0,"BackOrderModeLessThan":0,"BackOrderModeLessThanOrEqualTo":0,"BackOrderModeNotEqualTo":0,"BackOrderModeBetween":[0],"BackOrderModeIn":[0],"PriorityWeight":0,"PriorityWeightGreaterThanOrEqualTo":0,"PriorityWeightGreaterThan":0,"PriorityWeightLessThan":0,"PriorityWeightLessThanOrEqualTo":0,"PriorityWeightNotEqualTo":0,"PriorityWeightBetween":[0],"PriorityWeightIn":[0],"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":[{"OrdersOnBackID":"String","LastSavedDateTime":"0001-01-01T00:00:00.0000000","TranDate":"0001-01-01T00:00:00.0000000","InvoiceType":0,"InvoiceID":"String","InvoiceLineID":"String","DebtorID":"String","InventoryID":"String","OrderID":"String","OrderLineID":"String","Quantity":0,"Price":0,"EstBOValue":0,"Priority":"String","IN_LogicalID":"String","ForLogicalID":"String","ForAnotherWarehouse":0,"INAssemblyID":"String","BackOrderMode":0,"PriorityWeight":0}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}