Name | Parameter | Data Type | Required | Description |
---|---|---|---|---|
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 | |
IN_PhysicalID | query | string | No | |
IN_PhysicalIDStartsWith | query | string | No | |
IN_PhysicalIDEndsWith | query | string | No | |
IN_PhysicalIDContains | query | string | No | |
IN_PhysicalIDLike | query | string | No | |
IN_PhysicalIDBetween | query | string[] | No | |
IN_PhysicalIDIn | query | string[] | No | |
LogicalWarehouseDesciption | query | string | No | |
LogicalWarehouseDesciptionStartsWith | query | string | No | |
LogicalWarehouseDesciptionEndsWith | query | string | No | |
LogicalWarehouseDesciptionContains | query | string | No | |
LogicalWarehouseDesciptionLike | query | string | No | |
LogicalWarehouseDesciptionBetween | query | string[] | No | |
LogicalWarehouseDesciptionIn | query | string[] | No | |
PhysicalWarehouseDesciption | query | string | No | |
PhysicalWarehouseDesciptionStartsWith | query | string | No | |
PhysicalWarehouseDesciptionEndsWith | query | string | No | |
PhysicalWarehouseDesciptionContains | query | string | No | |
PhysicalWarehouseDesciptionLike | query | string | No | |
PhysicalWarehouseDesciptionBetween | query | string[] | No | |
PhysicalWarehouseDesciptionIn | 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 |
---|---|---|---|---|
IN_LogicalID | form | string | No | |
IN_PhysicalID | form | string | No | |
LogicalWarehouseDesciption | form | string | No | |
PhysicalWarehouseDesciption | 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_JIWA_DefaultOrderLocationsQuery HTTP/1.1
Host: api.jiwa.com.au
Accept: text/csv
Content-Type: text/csv
Content-Length: length
{"IN_LogicalID":"String","IN_LogicalIDStartsWith":"String","IN_LogicalIDEndsWith":"String","IN_LogicalIDContains":"String","IN_LogicalIDLike":"String","IN_LogicalIDBetween":["String"],"IN_LogicalIDIn":["String"],"IN_PhysicalID":"String","IN_PhysicalIDStartsWith":"String","IN_PhysicalIDEndsWith":"String","IN_PhysicalIDContains":"String","IN_PhysicalIDLike":"String","IN_PhysicalIDBetween":["String"],"IN_PhysicalIDIn":["String"],"LogicalWarehouseDesciption":"String","LogicalWarehouseDesciptionStartsWith":"String","LogicalWarehouseDesciptionEndsWith":"String","LogicalWarehouseDesciptionContains":"String","LogicalWarehouseDesciptionLike":"String","LogicalWarehouseDesciptionBetween":["String"],"LogicalWarehouseDesciptionIn":["String"],"PhysicalWarehouseDesciption":"String","PhysicalWarehouseDesciptionStartsWith":"String","PhysicalWarehouseDesciptionEndsWith":"String","PhysicalWarehouseDesciptionContains":"String","PhysicalWarehouseDesciptionLike":"String","PhysicalWarehouseDesciptionBetween":["String"],"PhysicalWarehouseDesciptionIn":["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":[{"IN_LogicalID":"String","IN_PhysicalID":"String","LogicalWarehouseDesciption":"String","PhysicalWarehouseDesciption":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}