JiwaAPI

<back to all web services

PI_LinesDetailsQuery

Requires Authentication
PI_LinesDetailsQuery Parameters:
NameParameterData TypeRequiredDescription
PI_LinesDetailsIDquerystringNo
PI_LinesDetailsIDStartsWithquerystringNo
PI_LinesDetailsIDEndsWithquerystringNo
PI_LinesDetailsIDContainsquerystringNo
PI_LinesDetailsIDLikequerystringNo
PI_LinesDetailsIDBetweenquerystring[]No
PI_LinesDetailsIDInquerystring[]No
PI_LinesIDquerystringNo
PI_LinesIDStartsWithquerystringNo
PI_LinesIDEndsWithquerystringNo
PI_LinesIDContainsquerystringNo
PI_LinesIDLikequerystringNo
PI_LinesIDBetweenquerystring[]No
PI_LinesIDInquerystring[]No
SerialNoquerystringNo
SerialNoStartsWithquerystringNo
SerialNoEndsWithquerystringNo
SerialNoContainsquerystringNo
SerialNoLikequerystringNo
SerialNoBetweenquerystring[]No
SerialNoInquerystring[]No
Quantityquerydecimal?No
QuantityGreaterThanOrEqualToquerydecimal?No
QuantityGreaterThanquerydecimal?No
QuantityLessThanquerydecimal?No
QuantityLessThanOrEqualToquerydecimal?No
QuantityNotEqualToquerydecimal?No
QuantityBetweenquerydecimal[]No
QuantityInquerydecimal[]No
ExpiryDatequeryDateTime?No
ExpiryDateGreaterThanOrEqualToqueryDateTime?No
ExpiryDateGreaterThanqueryDateTime?No
ExpiryDateLessThanqueryDateTime?No
ExpiryDateLessThanOrEqualToqueryDateTime?No
ExpiryDateNotEqualToqueryDateTime?No
ExpiryDateBetweenqueryNullable<DateTime>[]No
ExpiryDateInqueryNullable<DateTime>[]No
BinLocationquerystringNo
BinLocationStartsWithquerystringNo
BinLocationEndsWithquerystringNo
BinLocationContainsquerystringNo
BinLocationLikequerystringNo
BinLocationBetweenquerystring[]No
BinLocationInquerystring[]No
RowHashquerybyte[]No
RE_LineDetails_RecIDquerystringNo
RE_LineDetails_RecIDStartsWithquerystringNo
RE_LineDetails_RecIDEndsWithquerystringNo
RE_LineDetails_RecIDContainsquerystringNo
RE_LineDetails_RecIDLikequerystringNo
RE_LineDetails_RecIDBetweenquerystring[]No
RE_LineDetails_RecIDInquerystring[]No
IN_SOH_RecIDquerystringNo
IN_SOH_RecIDStartsWithquerystringNo
IN_SOH_RecIDEndsWithquerystringNo
IN_SOH_RecIDContainsquerystringNo
IN_SOH_RecIDLikequerystringNo
IN_SOH_RecIDBetweenquerystring[]No
IN_SOH_RecIDInquerystring[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
PI_LinesDetails Parameters:
NameParameterData TypeRequiredDescription
PI_LinesDetailsIDformstringNo
PI_LinesIDformstringNo
SerialNoformstringNo
QuantityformdecimalNo
ExpiryDateformDateTime?No
BinLocationformstringNo
RowHashformbyte[]No
RE_LineDetails_RecIDformstringNo
IN_SOH_RecIDformstringNo
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/PI_LinesDetailsQuery HTTP/1.1 
Host: localhost 
Accept: text/csv
Content-Type: text/csv
Content-Length: length

{"PI_LinesDetailsID":"String","PI_LinesDetailsIDStartsWith":"String","PI_LinesDetailsIDEndsWith":"String","PI_LinesDetailsIDContains":"String","PI_LinesDetailsIDLike":"String","PI_LinesDetailsIDBetween":["String"],"PI_LinesDetailsIDIn":["String"],"PI_LinesID":"String","PI_LinesIDStartsWith":"String","PI_LinesIDEndsWith":"String","PI_LinesIDContains":"String","PI_LinesIDLike":"String","PI_LinesIDBetween":["String"],"PI_LinesIDIn":["String"],"SerialNo":"String","SerialNoStartsWith":"String","SerialNoEndsWith":"String","SerialNoContains":"String","SerialNoLike":"String","SerialNoBetween":["String"],"SerialNoIn":["String"],"Quantity":0,"QuantityGreaterThanOrEqualTo":0,"QuantityGreaterThan":0,"QuantityLessThan":0,"QuantityLessThanOrEqualTo":0,"QuantityNotEqualTo":0,"QuantityBetween":[0],"QuantityIn":[0],"ExpiryDate":"0001-01-01T00:00:00.0000000","ExpiryDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","ExpiryDateGreaterThan":"0001-01-01T00:00:00.0000000","ExpiryDateLessThan":"0001-01-01T00:00:00.0000000","ExpiryDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","ExpiryDateNotEqualTo":"0001-01-01T00:00:00.0000000","ExpiryDateBetween":["0001-01-01T00:00:00.0000000"],"ExpiryDateIn":["0001-01-01T00:00:00.0000000"],"BinLocation":"String","BinLocationStartsWith":"String","BinLocationEndsWith":"String","BinLocationContains":"String","BinLocationLike":"String","BinLocationBetween":["String"],"BinLocationIn":["String"],"RowHash":"AA==","RE_LineDetails_RecID":"String","RE_LineDetails_RecIDStartsWith":"String","RE_LineDetails_RecIDEndsWith":"String","RE_LineDetails_RecIDContains":"String","RE_LineDetails_RecIDLike":"String","RE_LineDetails_RecIDBetween":["String"],"RE_LineDetails_RecIDIn":["String"],"IN_SOH_RecID":"String","IN_SOH_RecIDStartsWith":"String","IN_SOH_RecIDEndsWith":"String","IN_SOH_RecIDContains":"String","IN_SOH_RecIDLike":"String","IN_SOH_RecIDBetween":["String"],"IN_SOH_RecIDIn":["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":[{"PI_LinesDetailsID":"String","PI_LinesID":"String","SerialNo":"String","ExpiryDate":"0001-01-01T00:00:00.0000000","BinLocation":"String","RowHash":"AA==","RE_LineDetails_RecID":"String","IN_SOH_RecID":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}