| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| RecID | query | string | No | |
| RecIDStartsWith | query | string | No | |
| RecIDEndsWith | query | string | No | |
| RecIDContains | query | string | No | |
| RecIDLike | query | string | No | |
| RecIDBetween | query | string[] | No | |
| RecIDIn | query | string[] | No | |
| SalesDelBatchID | query | string | No | |
| SalesDelBatchIDStartsWith | query | string | No | |
| SalesDelBatchIDEndsWith | query | string | No | |
| SalesDelBatchIDContains | query | string | No | |
| SalesDelBatchIDLike | query | string | No | |
| SalesDelBatchIDBetween | query | string[] | No | |
| SalesDelBatchIDIn | query | string[] | No | |
| LineNumber | query | int? | No | |
| LineNumberGreaterThanOrEqualTo | query | int? | No | |
| LineNumberGreaterThan | query | int? | No | |
| LineNumberLessThan | query | int? | No | |
| LineNumberLessThanOrEqualTo | query | int? | No | |
| LineNumberNotEqualTo | query | int? | No | |
| LineNumberBetween | query | int[] | No | |
| LineNumberIn | query | int[] | 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 | |
| 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 | |
| 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 | |
| DebtorAccountNo | query | string | No | |
| DebtorAccountNoStartsWith | query | string | No | |
| DebtorAccountNoEndsWith | query | string | No | |
| DebtorAccountNoContains | query | string | No | |
| DebtorAccountNoLike | query | string | No | |
| DebtorAccountNoBetween | query | string[] | No | |
| DebtorAccountNoIn | query | string[] | No | |
| DebtorName | query | string | No | |
| DebtorNameStartsWith | query | string | No | |
| DebtorNameEndsWith | query | string | No | |
| DebtorNameContains | query | string | No | |
| DebtorNameLike | query | string | No | |
| DebtorNameBetween | query | string[] | No | |
| DebtorNameIn | 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 | |
| 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 | |
| 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 | decimal[] | No | |
| QuantityIn | query | decimal[] | No | |
| QuantityBackOrdered | query | decimal? | No | |
| QuantityBackOrderedGreaterThanOrEqualTo | query | decimal? | No | |
| QuantityBackOrderedGreaterThan | query | decimal? | No | |
| QuantityBackOrderedLessThan | query | decimal? | No | |
| QuantityBackOrderedLessThanOrEqualTo | query | decimal? | No | |
| QuantityBackOrderedNotEqualTo | query | decimal? | No | |
| QuantityBackOrderedBetween | query | decimal[] | No | |
| QuantityBackOrderedIn | query | decimal[] | No | |
| ForwardOrderDate | query | DateTime? | No | |
| ForwardOrderDateGreaterThanOrEqualTo | query | DateTime? | No | |
| ForwardOrderDateGreaterThan | query | DateTime? | No | |
| ForwardOrderDateLessThan | query | DateTime? | No | |
| ForwardOrderDateLessThanOrEqualTo | query | DateTime? | No | |
| ForwardOrderDateNotEqualTo | query | DateTime? | No | |
| ForwardOrderDateBetween | query | DateTime[] | No | |
| ForwardOrderDateIn | query | DateTime[] | No | |
| ScheduledDate | query | DateTime? | No | |
| ScheduledDateGreaterThanOrEqualTo | query | DateTime? | No | |
| ScheduledDateGreaterThan | query | DateTime? | No | |
| ScheduledDateLessThan | query | DateTime? | No | |
| ScheduledDateLessThanOrEqualTo | query | DateTime? | No | |
| ScheduledDateNotEqualTo | query | DateTime? | No | |
| ScheduledDateBetween | query | DateTime[] | No | |
| ScheduledDateIn | query | DateTime[] | No | |
| NewDeliverStockFlag | query | bool? | No | |
| NewQuantityDelivered | query | decimal? | No | |
| NewQuantityDeliveredGreaterThanOrEqualTo | query | decimal? | No | |
| NewQuantityDeliveredGreaterThan | query | decimal? | No | |
| NewQuantityDeliveredLessThan | query | decimal? | No | |
| NewQuantityDeliveredLessThanOrEqualTo | query | decimal? | No | |
| NewQuantityDeliveredNotEqualTo | query | decimal? | No | |
| NewQuantityDeliveredBetween | query | decimal[] | No | |
| NewQuantityDeliveredIn | query | decimal[] | No | |
| UpdateFailed | query | bool? | No | |
| FailReason | query | string | No | |
| FailReasonStartsWith | query | string | No | |
| FailReasonEndsWith | query | string | No | |
| FailReasonContains | query | string | No | |
| FailReasonLike | query | string | No | |
| FailReasonBetween | query | string[] | No | |
| FailReasonIn | query | string[] | No | |
| QuantityDecimalPlaces | query | short? | No | |
| QuantityDecimalPlacesGreaterThanOrEqualTo | query | short? | No | |
| QuantityDecimalPlacesGreaterThan | query | short? | No | |
| QuantityDecimalPlacesLessThan | query | short? | No | |
| QuantityDecimalPlacesLessThanOrEqualTo | query | short? | No | |
| QuantityDecimalPlacesNotEqualTo | query | short? | No | |
| QuantityDecimalPlacesBetween | query | short[] | No | |
| QuantityDecimalPlacesIn | query | short[] | 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 |
|---|---|---|---|---|
| RecID | form | string | No | |
| SalesDelBatchID | form | string | No | |
| LineNumber | form | int | No | |
| InvoiceID | form | string | No | |
| InvoiceNo | form | string | No | |
| DebtorID | form | string | No | |
| DebtorAccountNo | form | string | No | |
| DebtorName | form | string | No | |
| InvoiceLineID | form | string | No | |
| InventoryID | form | string | No | |
| PartNo | form | string | No | |
| Description | form | string | No | |
| Quantity | form | decimal | No | |
| QuantityBackOrdered | form | decimal | No | |
| ForwardOrderDate | form | DateTime | No | |
| ScheduledDate | form | DateTime | No | |
| NewDeliverStockFlag | form | bool? | No | |
| NewQuantityDelivered | form | decimal | No | |
| UpdateFailed | form | bool? | No | |
| FailReason | form | string | No | |
| QuantityDecimalPlaces | form | short | 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/SO_SalesDelBatchLinesQuery HTTP/1.1
Host: localhost
Accept: text/csv
Content-Type: text/csv
Content-Length: length
{"RecID":"String","RecIDStartsWith":"String","RecIDEndsWith":"String","RecIDContains":"String","RecIDLike":"String","RecIDBetween":["String"],"RecIDIn":["String"],"SalesDelBatchID":"String","SalesDelBatchIDStartsWith":"String","SalesDelBatchIDEndsWith":"String","SalesDelBatchIDContains":"String","SalesDelBatchIDLike":"String","SalesDelBatchIDBetween":["String"],"SalesDelBatchIDIn":["String"],"LineNumber":0,"LineNumberGreaterThanOrEqualTo":0,"LineNumberGreaterThan":0,"LineNumberLessThan":0,"LineNumberLessThanOrEqualTo":0,"LineNumberNotEqualTo":0,"LineNumberBetween":[0],"LineNumberIn":[0],"InvoiceID":"String","InvoiceIDStartsWith":"String","InvoiceIDEndsWith":"String","InvoiceIDContains":"String","InvoiceIDLike":"String","InvoiceIDBetween":["String"],"InvoiceIDIn":["String"],"InvoiceNo":"String","InvoiceNoStartsWith":"String","InvoiceNoEndsWith":"String","InvoiceNoContains":"String","InvoiceNoLike":"String","InvoiceNoBetween":["String"],"InvoiceNoIn":["String"],"DebtorID":"String","DebtorIDStartsWith":"String","DebtorIDEndsWith":"String","DebtorIDContains":"String","DebtorIDLike":"String","DebtorIDBetween":["String"],"DebtorIDIn":["String"],"DebtorAccountNo":"String","DebtorAccountNoStartsWith":"String","DebtorAccountNoEndsWith":"String","DebtorAccountNoContains":"String","DebtorAccountNoLike":"String","DebtorAccountNoBetween":["String"],"DebtorAccountNoIn":["String"],"DebtorName":"String","DebtorNameStartsWith":"String","DebtorNameEndsWith":"String","DebtorNameContains":"String","DebtorNameLike":"String","DebtorNameBetween":["String"],"DebtorNameIn":["String"],"InvoiceLineID":"String","InvoiceLineIDStartsWith":"String","InvoiceLineIDEndsWith":"String","InvoiceLineIDContains":"String","InvoiceLineIDLike":"String","InvoiceLineIDBetween":["String"],"InvoiceLineIDIn":["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"],"Quantity":0,"QuantityGreaterThanOrEqualTo":0,"QuantityGreaterThan":0,"QuantityLessThan":0,"QuantityLessThanOrEqualTo":0,"QuantityNotEqualTo":0,"QuantityBetween":[0],"QuantityIn":[0],"QuantityBackOrdered":0,"QuantityBackOrderedGreaterThanOrEqualTo":0,"QuantityBackOrderedGreaterThan":0,"QuantityBackOrderedLessThan":0,"QuantityBackOrderedLessThanOrEqualTo":0,"QuantityBackOrderedNotEqualTo":0,"QuantityBackOrderedBetween":[0],"QuantityBackOrderedIn":[0],"ForwardOrderDate":"0001-01-01T00:00:00.0000000","ForwardOrderDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","ForwardOrderDateGreaterThan":"0001-01-01T00:00:00.0000000","ForwardOrderDateLessThan":"0001-01-01T00:00:00.0000000","ForwardOrderDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","ForwardOrderDateNotEqualTo":"0001-01-01T00:00:00.0000000","ForwardOrderDateBetween":["0001-01-01T00:00:00.0000000"],"ForwardOrderDateIn":["0001-01-01T00:00:00.0000000"],"ScheduledDate":"0001-01-01T00:00:00.0000000","ScheduledDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","ScheduledDateGreaterThan":"0001-01-01T00:00:00.0000000","ScheduledDateLessThan":"0001-01-01T00:00:00.0000000","ScheduledDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","ScheduledDateNotEqualTo":"0001-01-01T00:00:00.0000000","ScheduledDateBetween":["0001-01-01T00:00:00.0000000"],"ScheduledDateIn":["0001-01-01T00:00:00.0000000"],"NewDeliverStockFlag":false,"NewQuantityDelivered":0,"NewQuantityDeliveredGreaterThanOrEqualTo":0,"NewQuantityDeliveredGreaterThan":0,"NewQuantityDeliveredLessThan":0,"NewQuantityDeliveredLessThanOrEqualTo":0,"NewQuantityDeliveredNotEqualTo":0,"NewQuantityDeliveredBetween":[0],"NewQuantityDeliveredIn":[0],"UpdateFailed":false,"FailReason":"String","FailReasonStartsWith":"String","FailReasonEndsWith":"String","FailReasonContains":"String","FailReasonLike":"String","FailReasonBetween":["String"],"FailReasonIn":["String"],"QuantityDecimalPlaces":0,"QuantityDecimalPlacesGreaterThanOrEqualTo":0,"QuantityDecimalPlacesGreaterThan":0,"QuantityDecimalPlacesLessThan":0,"QuantityDecimalPlacesLessThanOrEqualTo":0,"QuantityDecimalPlacesNotEqualTo":0,"QuantityDecimalPlacesBetween":[0],"QuantityDecimalPlacesIn":[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":[{"RecID":"String","SalesDelBatchID":"String","InvoiceID":"String","InvoiceNo":"String","DebtorID":"String","DebtorAccountNo":"String","DebtorName":"String","InvoiceLineID":"String","InventoryID":"String","PartNo":"String","Description":"String","NewDeliverStockFlag":false,"UpdateFailed":false,"FailReason":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}