| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| 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 | |
| PartNoAndDescription | query | string | No | |
| PartNoAndDescriptionStartsWith | query | string | No | |
| PartNoAndDescriptionEndsWith | query | string | No | |
| PartNoAndDescriptionContains | query | string | No | |
| PartNoAndDescriptionLike | query | string | No | |
| PartNoAndDescriptionBetween | query | string[] | No | |
| PartNoAndDescriptionIn | query | string[] | No | |
| Category1ID | query | string | No | |
| Category1IDStartsWith | query | string | No | |
| Category1IDEndsWith | query | string | No | |
| Category1IDContains | query | string | No | |
| Category1IDLike | query | string | No | |
| Category1IDBetween | query | string[] | No | |
| Category1IDIn | query | string[] | No | |
| Category2ID | query | string | No | |
| Category2IDStartsWith | query | string | No | |
| Category2IDEndsWith | query | string | No | |
| Category2IDContains | query | string | No | |
| Category2IDLike | query | string | No | |
| Category2IDBetween | query | string[] | No | |
| Category2IDIn | query | string[] | No | |
| Category3ID | query | string | No | |
| Category3IDStartsWith | query | string | No | |
| Category3IDEndsWith | query | string | No | |
| Category3IDContains | query | string | No | |
| Category3IDLike | query | string | No | |
| Category3IDBetween | query | string[] | No | |
| Category3IDIn | query | string[] | No | |
| Category4ID | query | string | No | |
| Category4IDStartsWith | query | string | No | |
| Category4IDEndsWith | query | string | No | |
| Category4IDContains | query | string | No | |
| Category4IDLike | query | string | No | |
| Category4IDBetween | query | string[] | No | |
| Category4IDIn | query | string[] | No | |
| Category5ID | query | string | No | |
| Category5IDStartsWith | query | string | No | |
| Category5IDEndsWith | query | string | No | |
| Category5IDContains | query | string | No | |
| Category5IDLike | query | string | No | |
| Category5IDBetween | query | string[] | No | |
| Category5IDIn | query | string[] | No | |
| ClassificationID | query | string | No | |
| ClassificationIDStartsWith | query | string | No | |
| ClassificationIDEndsWith | query | string | No | |
| ClassificationIDContains | query | string | No | |
| ClassificationIDLike | query | string | No | |
| ClassificationIDBetween | query | string[] | No | |
| ClassificationIDIn | 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 |
|---|---|---|---|---|
| InventoryID | form | string | No | |
| PartNo | form | string | No | |
| Description | form | string | No | |
| PartNoAndDescription | form | string | No | |
| Category1ID | form | string | No | |
| Category2ID | form | string | No | |
| Category3ID | form | string | No | |
| Category4ID | form | string | No | |
| Category5ID | form | string | No | |
| ClassificationID | 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_InventoryQuery HTTP/1.1
Host: localhost
Accept: text/csv
Content-Type: text/csv
Content-Length: length
{"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"],"PartNoAndDescription":"String","PartNoAndDescriptionStartsWith":"String","PartNoAndDescriptionEndsWith":"String","PartNoAndDescriptionContains":"String","PartNoAndDescriptionLike":"String","PartNoAndDescriptionBetween":["String"],"PartNoAndDescriptionIn":["String"],"Category1ID":"String","Category1IDStartsWith":"String","Category1IDEndsWith":"String","Category1IDContains":"String","Category1IDLike":"String","Category1IDBetween":["String"],"Category1IDIn":["String"],"Category2ID":"String","Category2IDStartsWith":"String","Category2IDEndsWith":"String","Category2IDContains":"String","Category2IDLike":"String","Category2IDBetween":["String"],"Category2IDIn":["String"],"Category3ID":"String","Category3IDStartsWith":"String","Category3IDEndsWith":"String","Category3IDContains":"String","Category3IDLike":"String","Category3IDBetween":["String"],"Category3IDIn":["String"],"Category4ID":"String","Category4IDStartsWith":"String","Category4IDEndsWith":"String","Category4IDContains":"String","Category4IDLike":"String","Category4IDBetween":["String"],"Category4IDIn":["String"],"Category5ID":"String","Category5IDStartsWith":"String","Category5IDEndsWith":"String","Category5IDContains":"String","Category5IDLike":"String","Category5IDBetween":["String"],"Category5IDIn":["String"],"ClassificationID":"String","ClassificationIDStartsWith":"String","ClassificationIDEndsWith":"String","ClassificationIDContains":"String","ClassificationIDLike":"String","ClassificationIDBetween":["String"],"ClassificationIDIn":["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":[{"InventoryID":"String","PartNo":"String","Description":"String","PartNoAndDescription":"String","Category1ID":"String","Category2ID":"String","Category3ID":"String","Category4ID":"String","Category5ID":"String","ClassificationID":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}