JiwaAPI

<back to all web services

INV_PIQuery

Requires Authentication
INV_PIQuery Parameters:
NameParameterData TypeRequiredDescription
InvoiceNOquerystringNo
InvoiceNOStartsWithquerystringNo
InvoiceNOEndsWithquerystringNo
InvoiceNOContainsquerystringNo
InvoiceNOLikequerystringNo
InvoiceNOBetweenquerystring[]No
InvoiceNOInquerystring[]No
SuppPartquerystringNo
SuppPartStartsWithquerystringNo
SuppPartEndsWithquerystringNo
SuppPartContainsquerystringNo
SuppPartLikequerystringNo
SuppPartBetweenquerystring[]No
SuppPartInquerystring[]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
INV_PI Parameters:
NameParameterData TypeRequiredDescription
InvoiceNOformstringNo
SuppPartformstringNo
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 .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/INV_PIQuery HTTP/1.1 
Host: localhost 
Accept: text/csv
Content-Type: text/csv
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"],"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: text/csv
Content-Length: length

{"Results":[{"InvoiceNO":"String","SuppPart":"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"}}}