| 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 | |
| CreditID | query | string | No | |
| CreditIDStartsWith | query | string | No | |
| CreditIDEndsWith | query | string | No | |
| CreditIDContains | query | string | No | |
| CreditIDLike | query | string | No | |
| CreditIDBetween | query | string[] | No | |
| CreditIDIn | query | string[] | No | |
| CreditLineID | query | string | No | |
| CreditLineIDStartsWith | query | string | No | |
| CreditLineIDEndsWith | query | string | No | |
| CreditLineIDContains | query | string | No | |
| CreditLineIDLike | query | string | No | |
| CreditLineIDBetween | query | string[] | No | |
| CreditLineIDIn | query | string[] | No | |
| ShipID | query | string | No | |
| ShipIDStartsWith | query | string | No | |
| ShipIDEndsWith | query | string | No | |
| ShipIDContains | query | string | No | |
| ShipIDLike | query | string | No | |
| ShipIDBetween | query | string[] | No | |
| ShipIDIn | query | string[] | No | |
| ShipLineID | query | string | No | |
| ShipLineIDStartsWith | query | string | No | |
| ShipLineIDEndsWith | query | string | No | |
| ShipLineIDContains | query | string | No | |
| ShipLineIDLike | query | string | No | |
| ShipLineIDBetween | query | string[] | No | |
| ShipLineIDIn | query | string[] | No | |
| ShipLineDetailID | query | string | No | |
| ShipLineDetailIDStartsWith | query | string | No | |
| ShipLineDetailIDEndsWith | query | string | No | |
| ShipLineDetailIDContains | query | string | No | |
| ShipLineDetailIDLike | query | string | No | |
| ShipLineDetailIDBetween | query | string[] | No | |
| ShipLineDetailIDIn | query | string[] | No | |
| InvID | query | string | No | |
| InvIDStartsWith | query | string | No | |
| InvIDEndsWith | query | string | No | |
| InvIDContains | query | string | No | |
| InvIDLike | query | string | No | |
| InvIDBetween | query | string[] | No | |
| InvIDIn | 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 | |
| SOHID | query | string | No | |
| SOHIDStartsWith | query | string | No | |
| SOHIDEndsWith | query | string | No | |
| SOHIDContains | query | string | No | |
| SOHIDLike | query | string | No | |
| SOHIDBetween | query | string[] | No | |
| SOHIDIn | 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 |
|---|---|---|---|---|
| RecID | form | string | No | |
| CreditID | form | string | No | |
| CreditLineID | form | string | No | |
| ShipID | form | string | No | |
| ShipLineID | form | string | No | |
| ShipLineDetailID | form | string | No | |
| InvID | form | string | No | |
| Quantity | form | decimal? | No | |
| SOHID | 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/RA_SelectedShipLinesQuery 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"],"CreditID":"String","CreditIDStartsWith":"String","CreditIDEndsWith":"String","CreditIDContains":"String","CreditIDLike":"String","CreditIDBetween":["String"],"CreditIDIn":["String"],"CreditLineID":"String","CreditLineIDStartsWith":"String","CreditLineIDEndsWith":"String","CreditLineIDContains":"String","CreditLineIDLike":"String","CreditLineIDBetween":["String"],"CreditLineIDIn":["String"],"ShipID":"String","ShipIDStartsWith":"String","ShipIDEndsWith":"String","ShipIDContains":"String","ShipIDLike":"String","ShipIDBetween":["String"],"ShipIDIn":["String"],"ShipLineID":"String","ShipLineIDStartsWith":"String","ShipLineIDEndsWith":"String","ShipLineIDContains":"String","ShipLineIDLike":"String","ShipLineIDBetween":["String"],"ShipLineIDIn":["String"],"ShipLineDetailID":"String","ShipLineDetailIDStartsWith":"String","ShipLineDetailIDEndsWith":"String","ShipLineDetailIDContains":"String","ShipLineDetailIDLike":"String","ShipLineDetailIDBetween":["String"],"ShipLineDetailIDIn":["String"],"InvID":"String","InvIDStartsWith":"String","InvIDEndsWith":"String","InvIDContains":"String","InvIDLike":"String","InvIDBetween":["String"],"InvIDIn":["String"],"Quantity":0,"QuantityGreaterThanOrEqualTo":0,"QuantityGreaterThan":0,"QuantityLessThan":0,"QuantityLessThanOrEqualTo":0,"QuantityNotEqualTo":0,"QuantityBetween":[0],"QuantityIn":[0],"SOHID":"String","SOHIDStartsWith":"String","SOHIDEndsWith":"String","SOHIDContains":"String","SOHIDLike":"String","SOHIDBetween":["String"],"SOHIDIn":["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":[{"RecID":"String","CreditID":"String","CreditLineID":"String","ShipID":"String","ShipLineID":"String","ShipLineDetailID":"String","InvID":"String","Quantity":0,"SOHID":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}