JiwaAPI

<back to all web services

V_INV_PIQuery

Requires Authentication
V_INV_PIQuery Parameters:
NameParameterData TypeRequiredDescription
InvoiceNOquerystringNo
InvoiceNOStartsWithquerystringNo
InvoiceNOEndsWithquerystringNo
InvoiceNOContainsquerystringNo
InvoiceNOLikequerystringNo
InvoiceNOBetweenquerystring[]No
InvoiceNOInquerystring[]No
SuppPartquerystringNo
SuppPartStartsWithquerystringNo
SuppPartEndsWithquerystringNo
SuppPartContainsquerystringNo
SuppPartLikequerystringNo
SuppPartBetweenquerystring[]No
SuppPartInquerystring[]No
DatequerystringNo
DateStartsWithquerystringNo
DateEndsWithquerystringNo
DateContainsquerystringNo
DateLikequerystringNo
DateBetweenquerystring[]No
DateInquerystring[]No
AccountNoquerystringNo
AccountNoStartsWithquerystringNo
AccountNoEndsWithquerystringNo
AccountNoContainsquerystringNo
AccountNoLikequerystringNo
AccountNoBetweenquerystring[]No
AccountNoInquerystring[]No
SerialNoquerystringNo
SerialNoStartsWithquerystringNo
SerialNoEndsWithquerystringNo
SerialNoContainsquerystringNo
SerialNoLikequerystringNo
SerialNoBetweenquerystring[]No
SerialNoInquerystring[]No
BinLocquerystringNo
BinLocStartsWithquerystringNo
BinLocEndsWithquerystringNo
BinLocContainsquerystringNo
BinLocLikequerystringNo
BinLocBetweenquerystring[]No
BinLocInquerystring[]No
PI_LinesDetailsIDquerystringNo
PI_LinesDetailsIDStartsWithquerystringNo
PI_LinesDetailsIDEndsWithquerystringNo
PI_LinesDetailsIDContainsquerystringNo
PI_LinesDetailsIDLikequerystringNo
PI_LinesDetailsIDBetweenquerystring[]No
PI_LinesDetailsIDInquerystring[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
V_INV_PI Parameters:
NameParameterData TypeRequiredDescription
InvoiceNOformstringNo
SuppPartformstringNo
DateformstringNo
AccountNoformstringNo
SerialNoformstringNo
BinLocformstringNo
PI_LinesDetailsIDformstringNo
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/V_INV_PIQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/json
Content-Type: application/json
Content-Length: length

{"InvoiceNO":"String","InvoiceNOStartsWith":"String","InvoiceNOEndsWith":"String","InvoiceNOContains":"String","InvoiceNOLike":"String","InvoiceNOBetween":["String"],"InvoiceNOIn":["String"],"SuppPart":"String","SuppPartStartsWith":"String","SuppPartEndsWith":"String","SuppPartContains":"String","SuppPartLike":"String","SuppPartBetween":["String"],"SuppPartIn":["String"],"Date":"String","DateStartsWith":"String","DateEndsWith":"String","DateContains":"String","DateLike":"String","DateBetween":["String"],"DateIn":["String"],"AccountNo":"String","AccountNoStartsWith":"String","AccountNoEndsWith":"String","AccountNoContains":"String","AccountNoLike":"String","AccountNoBetween":["String"],"AccountNoIn":["String"],"SerialNo":"String","SerialNoStartsWith":"String","SerialNoEndsWith":"String","SerialNoContains":"String","SerialNoLike":"String","SerialNoBetween":["String"],"SerialNoIn":["String"],"BinLoc":"String","BinLocStartsWith":"String","BinLocEndsWith":"String","BinLocContains":"String","BinLocLike":"String","BinLocBetween":["String"],"BinLocIn":["String"],"PI_LinesDetailsID":"String","PI_LinesDetailsIDStartsWith":"String","PI_LinesDetailsIDEndsWith":"String","PI_LinesDetailsIDContains":"String","PI_LinesDetailsIDLike":"String","PI_LinesDetailsIDBetween":["String"],"PI_LinesDetailsIDIn":["String"],"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":[{"InvoiceNO":"String","SuppPart":"String","Date":"String","AccountNo":"String","SerialNo":"String","BinLoc":"String","PI_LinesDetailsID":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}