JiwaAPI

<back to all web services

SH_PurchaseOrdersQuery

Requires Authentication
SH_PurchaseOrdersQuery Parameters:
NameParameterData TypeRequiredDescription
RecIDquerystringNo
RecIDStartsWithquerystringNo
RecIDEndsWithquerystringNo
RecIDContainsquerystringNo
RecIDLikequerystringNo
RecIDBetweenquerystring[]No
RecIDInquerystring[]No
SH_Main_RecIDquerystringNo
SH_Main_RecIDStartsWithquerystringNo
SH_Main_RecIDEndsWithquerystringNo
SH_Main_RecIDContainsquerystringNo
SH_Main_RecIDLikequerystringNo
SH_Main_RecIDBetweenquerystring[]No
SH_Main_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
DisplayLinesquerybool?No
FXRatequerydecimal?No
FXRateGreaterThanOrEqualToquerydecimal?No
FXRateGreaterThanquerydecimal?No
FXRateLessThanquerydecimal?No
FXRateLessThanOrEqualToquerydecimal?No
FXRateNotEqualToquerydecimal?No
FXRateBetweenqueryNullable<Decimal>[]No
FXRateInqueryNullable<Decimal>[]No
UserField1querystringNo
UserField1StartsWithquerystringNo
UserField1EndsWithquerystringNo
UserField1ContainsquerystringNo
UserField1LikequerystringNo
UserField1Betweenquerystring[]No
UserField1Inquerystring[]No
UserField2querystringNo
UserField2StartsWithquerystringNo
UserField2EndsWithquerystringNo
UserField2ContainsquerystringNo
UserField2LikequerystringNo
UserField2Betweenquerystring[]No
UserField2Inquerystring[]No
UserField3querystringNo
UserField3StartsWithquerystringNo
UserField3EndsWithquerystringNo
UserField3ContainsquerystringNo
UserField3LikequerystringNo
UserField3Betweenquerystring[]No
UserField3Inquerystring[]No
UserField4querystringNo
UserField4StartsWithquerystringNo
UserField4EndsWithquerystringNo
UserField4ContainsquerystringNo
UserField4LikequerystringNo
UserField4Betweenquerystring[]No
UserField4Inquerystring[]No
UserField5querystringNo
UserField5StartsWithquerystringNo
UserField5EndsWithquerystringNo
UserField5ContainsquerystringNo
UserField5LikequerystringNo
UserField5Betweenquerystring[]No
UserField5Inquerystring[]No
UserField6querystringNo
UserField6StartsWithquerystringNo
UserField6EndsWithquerystringNo
UserField6ContainsquerystringNo
UserField6LikequerystringNo
UserField6Betweenquerystring[]No
UserField6Inquerystring[]No
UserField7querystringNo
UserField7StartsWithquerystringNo
UserField7EndsWithquerystringNo
UserField7ContainsquerystringNo
UserField7LikequerystringNo
UserField7Betweenquerystring[]No
UserField7Inquerystring[]No
UserField8querystringNo
UserField8StartsWithquerystringNo
UserField8EndsWithquerystringNo
UserField8ContainsquerystringNo
UserField8LikequerystringNo
UserField8Betweenquerystring[]No
UserField8Inquerystring[]No
UserField9querystringNo
UserField9StartsWithquerystringNo
UserField9EndsWithquerystringNo
UserField9ContainsquerystringNo
UserField9LikequerystringNo
UserField9Betweenquerystring[]No
UserField9Inquerystring[]No
UserField10querystringNo
UserField10StartsWithquerystringNo
UserField10EndsWithquerystringNo
UserField10ContainsquerystringNo
UserField10LikequerystringNo
UserField10Betweenquerystring[]No
UserField10Inquerystring[]No
ItemNoqueryint?No
ItemNoGreaterThanOrEqualToqueryint?No
ItemNoGreaterThanqueryint?No
ItemNoLessThanqueryint?No
ItemNoLessThanOrEqualToqueryint?No
ItemNoNotEqualToqueryint?No
ItemNoBetweenqueryint[]No
ItemNoInqueryint[]No
RowHashquerybyte[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
SH_PurchaseOrders Parameters:
NameParameterData TypeRequiredDescription
RecIDformstringNo
SH_Main_RecIDformstringNo
PO_Main_RecIDformstringNo
DisplayLinesformboolNo
FXRateformdecimal?No
UserField1formstringNo
UserField2formstringNo
UserField3formstringNo
UserField4formstringNo
UserField5formstringNo
UserField6formstringNo
UserField7formstringNo
UserField8formstringNo
UserField9formstringNo
UserField10formstringNo
ItemNoformintNo
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/SH_PurchaseOrdersQuery 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"],"SH_Main_RecID":"String","SH_Main_RecIDStartsWith":"String","SH_Main_RecIDEndsWith":"String","SH_Main_RecIDContains":"String","SH_Main_RecIDLike":"String","SH_Main_RecIDBetween":["String"],"SH_Main_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"],"DisplayLines":false,"FXRate":0,"FXRateGreaterThanOrEqualTo":0,"FXRateGreaterThan":0,"FXRateLessThan":0,"FXRateLessThanOrEqualTo":0,"FXRateNotEqualTo":0,"FXRateBetween":[0],"FXRateIn":[0],"UserField1":"String","UserField1StartsWith":"String","UserField1EndsWith":"String","UserField1Contains":"String","UserField1Like":"String","UserField1Between":["String"],"UserField1In":["String"],"UserField2":"String","UserField2StartsWith":"String","UserField2EndsWith":"String","UserField2Contains":"String","UserField2Like":"String","UserField2Between":["String"],"UserField2In":["String"],"UserField3":"String","UserField3StartsWith":"String","UserField3EndsWith":"String","UserField3Contains":"String","UserField3Like":"String","UserField3Between":["String"],"UserField3In":["String"],"UserField4":"String","UserField4StartsWith":"String","UserField4EndsWith":"String","UserField4Contains":"String","UserField4Like":"String","UserField4Between":["String"],"UserField4In":["String"],"UserField5":"String","UserField5StartsWith":"String","UserField5EndsWith":"String","UserField5Contains":"String","UserField5Like":"String","UserField5Between":["String"],"UserField5In":["String"],"UserField6":"String","UserField6StartsWith":"String","UserField6EndsWith":"String","UserField6Contains":"String","UserField6Like":"String","UserField6Between":["String"],"UserField6In":["String"],"UserField7":"String","UserField7StartsWith":"String","UserField7EndsWith":"String","UserField7Contains":"String","UserField7Like":"String","UserField7Between":["String"],"UserField7In":["String"],"UserField8":"String","UserField8StartsWith":"String","UserField8EndsWith":"String","UserField8Contains":"String","UserField8Like":"String","UserField8Between":["String"],"UserField8In":["String"],"UserField9":"String","UserField9StartsWith":"String","UserField9EndsWith":"String","UserField9Contains":"String","UserField9Like":"String","UserField9Between":["String"],"UserField9In":["String"],"UserField10":"String","UserField10StartsWith":"String","UserField10EndsWith":"String","UserField10Contains":"String","UserField10Like":"String","UserField10Between":["String"],"UserField10In":["String"],"ItemNo":0,"ItemNoGreaterThanOrEqualTo":0,"ItemNoGreaterThan":0,"ItemNoLessThan":0,"ItemNoLessThanOrEqualTo":0,"ItemNoNotEqualTo":0,"ItemNoBetween":[0],"ItemNoIn":[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","SH_Main_RecID":"String","PO_Main_RecID":"String","FXRate":0,"UserField1":"String","UserField2":"String","UserField3":"String","UserField4":"String","UserField5":"String","UserField6":"String","UserField7":"String","UserField8":"String","UserField9":"String","UserField10":"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"}}}