JiwaAPI

<back to all web services

V_STK_LineDetailsQuery

Requires Authentication
V_STK_LineDetailsQuery Parameters:
NameParameterData TypeRequiredDescription
StockTakeDetailsIDquerystringNo
StockTakeDetailsIDStartsWithquerystringNo
StockTakeDetailsIDEndsWithquerystringNo
StockTakeDetailsIDContainsquerystringNo
StockTakeDetailsIDLikequerystringNo
StockTakeDetailsIDBetweenquerystring[]No
StockTakeDetailsIDInquerystring[]No
StockTakeLineIDquerystringNo
StockTakeLineIDStartsWithquerystringNo
StockTakeLineIDEndsWithquerystringNo
StockTakeLineIDContainsquerystringNo
StockTakeLineIDLikequerystringNo
StockTakeLineIDBetweenquerystring[]No
StockTakeLineIDInquerystring[]No
SerialNumberquerystringNo
SerialNumberStartsWithquerystringNo
SerialNumberEndsWithquerystringNo
SerialNumberContainsquerystringNo
SerialNumberLikequerystringNo
SerialNumberBetweenquerystring[]No
SerialNumberInquerystring[]No
LinkIDquerystringNo
LinkIDStartsWithquerystringNo
LinkIDEndsWithquerystringNo
LinkIDContainsquerystringNo
LinkIDLikequerystringNo
LinkIDBetweenquerystring[]No
LinkIDInquerystring[]No
QtyFoundquerydecimal?No
QtyFoundGreaterThanOrEqualToquerydecimal?No
QtyFoundGreaterThanquerydecimal?No
QtyFoundLessThanquerydecimal?No
QtyFoundLessThanOrEqualToquerydecimal?No
QtyFoundNotEqualToquerydecimal?No
QtyFoundBetweenqueryNullable<Decimal>[]No
QtyFoundInqueryNullable<Decimal>[]No
Qtyquerydecimal?No
QtyGreaterThanOrEqualToquerydecimal?No
QtyGreaterThanquerydecimal?No
QtyLessThanquerydecimal?No
QtyLessThanOrEqualToquerydecimal?No
QtyNotEqualToquerydecimal?No
QtyBetweenqueryNullable<Decimal>[]No
QtyInqueryNullable<Decimal>[]No
Inc_Decqueryint?No
Inc_DecGreaterThanOrEqualToqueryint?No
Inc_DecGreaterThanqueryint?No
Inc_DecLessThanqueryint?No
Inc_DecLessThanOrEqualToqueryint?No
Inc_DecNotEqualToqueryint?No
Inc_DecBetweenqueryint[]No
Inc_DecInqueryint[]No
Costquerydecimal?No
CostGreaterThanOrEqualToquerydecimal?No
CostGreaterThanquerydecimal?No
CostLessThanquerydecimal?No
CostLessThanOrEqualToquerydecimal?No
CostNotEqualToquerydecimal?No
CostBetweenqueryNullable<Decimal>[]No
CostInqueryNullable<Decimal>[]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
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
V_STK_LineDetails Parameters:
NameParameterData TypeRequiredDescription
StockTakeDetailsIDformstringNo
StockTakeLineIDformstringNo
SerialNumberformstringNo
LinkIDformstringNo
QtyFoundformdecimal?No
Qtyformdecimal?No
Inc_DecformintNo
Costformdecimal?No
ExpiryDateformDateTime?No
BinLocationformstringNo
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_STK_LineDetailsQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/json
Content-Type: application/json
Content-Length: length

{"StockTakeDetailsID":"String","StockTakeDetailsIDStartsWith":"String","StockTakeDetailsIDEndsWith":"String","StockTakeDetailsIDContains":"String","StockTakeDetailsIDLike":"String","StockTakeDetailsIDBetween":["String"],"StockTakeDetailsIDIn":["String"],"StockTakeLineID":"String","StockTakeLineIDStartsWith":"String","StockTakeLineIDEndsWith":"String","StockTakeLineIDContains":"String","StockTakeLineIDLike":"String","StockTakeLineIDBetween":["String"],"StockTakeLineIDIn":["String"],"SerialNumber":"String","SerialNumberStartsWith":"String","SerialNumberEndsWith":"String","SerialNumberContains":"String","SerialNumberLike":"String","SerialNumberBetween":["String"],"SerialNumberIn":["String"],"LinkID":"String","LinkIDStartsWith":"String","LinkIDEndsWith":"String","LinkIDContains":"String","LinkIDLike":"String","LinkIDBetween":["String"],"LinkIDIn":["String"],"QtyFound":0,"QtyFoundGreaterThanOrEqualTo":0,"QtyFoundGreaterThan":0,"QtyFoundLessThan":0,"QtyFoundLessThanOrEqualTo":0,"QtyFoundNotEqualTo":0,"QtyFoundBetween":[0],"QtyFoundIn":[0],"Qty":0,"QtyGreaterThanOrEqualTo":0,"QtyGreaterThan":0,"QtyLessThan":0,"QtyLessThanOrEqualTo":0,"QtyNotEqualTo":0,"QtyBetween":[0],"QtyIn":[0],"Inc_Dec":0,"Inc_DecGreaterThanOrEqualTo":0,"Inc_DecGreaterThan":0,"Inc_DecLessThan":0,"Inc_DecLessThanOrEqualTo":0,"Inc_DecNotEqualTo":0,"Inc_DecBetween":[0],"Inc_DecIn":[0],"Cost":0,"CostGreaterThanOrEqualTo":0,"CostGreaterThan":0,"CostLessThan":0,"CostLessThanOrEqualTo":0,"CostNotEqualTo":0,"CostBetween":[0],"CostIn":[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"],"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":[{"StockTakeDetailsID":"String","StockTakeLineID":"String","SerialNumber":"String","LinkID":"String","QtyFound":0,"Qty":0,"Cost":0,"ExpiryDate":"0001-01-01T00:00:00.0000000","BinLocation":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}