JiwaAPI

<back to all web services

PO_BatchPurchaseOrdersQuery

Requires Authentication
PO_BatchPurchaseOrdersQuery Parameters:
NameParameterData TypeRequiredDescription
RecIDquerystringNo
RecIDStartsWithquerystringNo
RecIDEndsWithquerystringNo
RecIDContainsquerystringNo
RecIDLikequerystringNo
RecIDBetweenquerystring[]No
RecIDInquerystring[]No
PO_BatchHeader_RecIDquerystringNo
PO_BatchHeader_RecIDStartsWithquerystringNo
PO_BatchHeader_RecIDEndsWithquerystringNo
PO_BatchHeader_RecIDContainsquerystringNo
PO_BatchHeader_RecIDLikequerystringNo
PO_BatchHeader_RecIDBetweenquerystring[]No
PO_BatchHeader_RecIDInquerystring[]No
PO_Main_RecIDquerystringNo
PO_Main_RecIDStartsWithquerystringNo
PO_Main_RecIDEndsWithquerystringNo
PO_Main_RecIDContainsquerystringNo
PO_Main_RecIDLikequerystringNo
PO_Main_RecIDBetweenquerystring[]No
PO_Main_RecIDInquerystring[]No
CR_Main_RecIDquerystringNo
CR_Main_RecIDStartsWithquerystringNo
CR_Main_RecIDEndsWithquerystringNo
CR_Main_RecIDContainsquerystringNo
CR_Main_RecIDLikequerystringNo
CR_Main_RecIDBetweenquerystring[]No
CR_Main_RecIDInquerystring[]No
FXCurrencyRatequerydecimal?No
FXCurrencyRateGreaterThanOrEqualToquerydecimal?No
FXCurrencyRateGreaterThanquerydecimal?No
FXCurrencyRateLessThanquerydecimal?No
FXCurrencyRateLessThanOrEqualToquerydecimal?No
FXCurrencyRateNotEqualToquerydecimal?No
FXCurrencyRateBetweenquerydecimal[]No
FXCurrencyRateInquerydecimal[]No
RowHashquerybyte[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
PO_BatchPurchaseOrders Parameters:
NameParameterData TypeRequiredDescription
RecIDformstringNo
PO_BatchHeader_RecIDformstringNo
PO_Main_RecIDformstringNo
CR_Main_RecIDformstringNo
FXCurrencyRateformdecimalNo
RowHashformbyte[]No
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 .json suffix or ?format=json

To embed the response in a jsonp callback, append ?callback=myCallback

HTTP + JSON

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

POST /json/reply/PO_BatchPurchaseOrdersQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/json
Content-Type: application/json
Content-Length: length

{"RecID":"String","RecIDStartsWith":"String","RecIDEndsWith":"String","RecIDContains":"String","RecIDLike":"String","RecIDBetween":["String"],"RecIDIn":["String"],"PO_BatchHeader_RecID":"String","PO_BatchHeader_RecIDStartsWith":"String","PO_BatchHeader_RecIDEndsWith":"String","PO_BatchHeader_RecIDContains":"String","PO_BatchHeader_RecIDLike":"String","PO_BatchHeader_RecIDBetween":["String"],"PO_BatchHeader_RecIDIn":["String"],"PO_Main_RecID":"String","PO_Main_RecIDStartsWith":"String","PO_Main_RecIDEndsWith":"String","PO_Main_RecIDContains":"String","PO_Main_RecIDLike":"String","PO_Main_RecIDBetween":["String"],"PO_Main_RecIDIn":["String"],"CR_Main_RecID":"String","CR_Main_RecIDStartsWith":"String","CR_Main_RecIDEndsWith":"String","CR_Main_RecIDContains":"String","CR_Main_RecIDLike":"String","CR_Main_RecIDBetween":["String"],"CR_Main_RecIDIn":["String"],"FXCurrencyRate":0,"FXCurrencyRateGreaterThanOrEqualTo":0,"FXCurrencyRateGreaterThan":0,"FXCurrencyRateLessThan":0,"FXCurrencyRateLessThanOrEqualTo":0,"FXCurrencyRateNotEqualTo":0,"FXCurrencyRateBetween":[0],"FXCurrencyRateIn":[0],"RowHash":"AA==","Skip":0,"Take":0,"OrderBy":"String","OrderByDesc":"String","Include":"String","Fields":"String","Meta":{"String":"String"}}
HTTP/1.1 200 OK
Content-Type: application/json
Content-Length: length

{"Results":[{"RecID":"String","PO_BatchHeader_RecID":"String","PO_Main_RecID":"String","CR_Main_RecID":"String","RowHash":"AA=="}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}