JiwaAPI

<back to all web services

V_ShipmentReconciliationQuery

Requires Authentication
V_ShipmentReconciliationQuery Parameters:
NameParameterData TypeRequiredDescription
SourceIDquerystringNo
SourceIDStartsWithquerystringNo
SourceIDEndsWithquerystringNo
SourceIDContainsquerystringNo
SourceIDLikequerystringNo
SourceIDBetweenquerystring[]No
SourceIDInquerystring[]No
ShipmentNoquerystringNo
ShipmentNoStartsWithquerystringNo
ShipmentNoEndsWithquerystringNo
ShipmentNoContainsquerystringNo
ShipmentNoLikequerystringNo
ShipmentNoBetweenquerystring[]No
ShipmentNoInquerystring[]No
ImportCostClearingAccountIDquerystringNo
ImportCostClearingAccountIDStartsWithquerystringNo
ImportCostClearingAccountIDEndsWithquerystringNo
ImportCostClearingAccountIDContainsquerystringNo
ImportCostClearingAccountIDLikequerystringNo
ImportCostClearingAccountIDBetweenquerystring[]No
ImportCostClearingAccountIDInquerystring[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
V_ShipmentReconciliation Parameters:
NameParameterData TypeRequiredDescription
SourceIDformstringNo
ShipmentNoformstringNo
ImportCostClearingAccountIDformstringNo
QueryResponse<T> Parameters:
NameParameterData TypeRequiredDescription
OffsetformintNo
TotalformintNo
ResultsformList<T>No
MetaformDictionary<string, string>No
ResponseStatusformResponseStatusNo

To override the Content-type in your clients, use the HTTP Accept Header, append the .csv suffix or ?format=csv

HTTP + CSV

The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.

POST /csv/reply/V_ShipmentReconciliationQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: text/csv
Content-Type: text/csv
Content-Length: length

{"SourceID":"String","SourceIDStartsWith":"String","SourceIDEndsWith":"String","SourceIDContains":"String","SourceIDLike":"String","SourceIDBetween":["String"],"SourceIDIn":["String"],"ShipmentNo":"String","ShipmentNoStartsWith":"String","ShipmentNoEndsWith":"String","ShipmentNoContains":"String","ShipmentNoLike":"String","ShipmentNoBetween":["String"],"ShipmentNoIn":["String"],"ImportCostClearingAccountID":"String","ImportCostClearingAccountIDStartsWith":"String","ImportCostClearingAccountIDEndsWith":"String","ImportCostClearingAccountIDContains":"String","ImportCostClearingAccountIDLike":"String","ImportCostClearingAccountIDBetween":["String"],"ImportCostClearingAccountIDIn":["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":[{"SourceID":"String","ShipmentNo":"String","ImportCostClearingAccountID":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}