JiwaAPI

<back to all web services

V_Inv_SalesQuery

Requires Authentication
V_Inv_SalesQuery Parameters:
NameParameterData TypeRequiredDescription
FullInvNoquerystringNo
FullInvNoStartsWithquerystringNo
FullInvNoEndsWithquerystringNo
FullInvNoContainsquerystringNo
FullInvNoLikequerystringNo
FullInvNoBetweenquerystring[]No
FullInvNoInquerystring[]No
DatequerystringNo
DateStartsWithquerystringNo
DateEndsWithquerystringNo
DateContainsquerystringNo
DateLikequerystringNo
DateBetweenquerystring[]No
DateInquerystring[]No
ordernoquerystringNo
ordernoStartsWithquerystringNo
ordernoEndsWithquerystringNo
ordernoContainsquerystringNo
ordernoLikequerystringNo
ordernoBetweenquerystring[]No
ordernoInquerystring[]No
AccountnoquerystringNo
AccountnoStartsWithquerystringNo
AccountnoEndsWithquerystringNo
AccountnoContainsquerystringNo
AccountnoLikequerystringNo
AccountnoBetweenquerystring[]No
AccountnoInquerystring[]No
QtyOrdquerystringNo
QtyOrdStartsWithquerystringNo
QtyOrdEndsWithquerystringNo
QtyOrdContainsquerystringNo
QtyOrdLikequerystringNo
QtyOrdBetweenquerystring[]No
QtyOrdInquerystring[]No
InvoiceLineIDquerystringNo
InvoiceLineIDStartsWithquerystringNo
InvoiceLineIDEndsWithquerystringNo
InvoiceLineIDContainsquerystringNo
InvoiceLineIDLikequerystringNo
InvoiceLineIDBetweenquerystring[]No
InvoiceLineIDInquerystring[]No
InventoryIDquerystringNo
InventoryIDStartsWithquerystringNo
InventoryIDEndsWithquerystringNo
InventoryIDContainsquerystringNo
InventoryIDLikequerystringNo
InventoryIDBetweenquerystring[]No
InventoryIDInquerystring[]No
InvoiceHistoryIDquerystringNo
InvoiceHistoryIDStartsWithquerystringNo
InvoiceHistoryIDEndsWithquerystringNo
InvoiceHistoryIDContainsquerystringNo
InvoiceHistoryIDLikequerystringNo
InvoiceHistoryIDBetweenquerystring[]No
InvoiceHistoryIDInquerystring[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
V_Inv_Sales Parameters:
NameParameterData TypeRequiredDescription
FullInvNoformstringNo
DateformstringNo
ordernoformstringNo
AccountnoformstringNo
QtyOrdformstringNo
InvoiceLineIDformstringNo
InventoryIDformstringNo
InvoiceHistoryIDformstringNo
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_SalesQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/json
Content-Type: application/json
Content-Length: length

{"FullInvNo":"String","FullInvNoStartsWith":"String","FullInvNoEndsWith":"String","FullInvNoContains":"String","FullInvNoLike":"String","FullInvNoBetween":["String"],"FullInvNoIn":["String"],"Date":"String","DateStartsWith":"String","DateEndsWith":"String","DateContains":"String","DateLike":"String","DateBetween":["String"],"DateIn":["String"],"orderno":"String","ordernoStartsWith":"String","ordernoEndsWith":"String","ordernoContains":"String","ordernoLike":"String","ordernoBetween":["String"],"ordernoIn":["String"],"Accountno":"String","AccountnoStartsWith":"String","AccountnoEndsWith":"String","AccountnoContains":"String","AccountnoLike":"String","AccountnoBetween":["String"],"AccountnoIn":["String"],"QtyOrd":"String","QtyOrdStartsWith":"String","QtyOrdEndsWith":"String","QtyOrdContains":"String","QtyOrdLike":"String","QtyOrdBetween":["String"],"QtyOrdIn":["String"],"InvoiceLineID":"String","InvoiceLineIDStartsWith":"String","InvoiceLineIDEndsWith":"String","InvoiceLineIDContains":"String","InvoiceLineIDLike":"String","InvoiceLineIDBetween":["String"],"InvoiceLineIDIn":["String"],"InventoryID":"String","InventoryIDStartsWith":"String","InventoryIDEndsWith":"String","InventoryIDContains":"String","InventoryIDLike":"String","InventoryIDBetween":["String"],"InventoryIDIn":["String"],"InvoiceHistoryID":"String","InvoiceHistoryIDStartsWith":"String","InvoiceHistoryIDEndsWith":"String","InvoiceHistoryIDContains":"String","InvoiceHistoryIDLike":"String","InvoiceHistoryIDBetween":["String"],"InvoiceHistoryIDIn":["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":[{"FullInvNo":"String","Date":"String","orderno":"String","Accountno":"String","QtyOrd":"String","InvoiceLineID":"String","InventoryID":"String","InvoiceHistoryID":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}