JiwaAPI

v_Jiwa_Stock_In_BinsQuery

The following routes are available for this service:
GET	/Inventory/StockInBins	AutoQuery to retrieve contents of bin locations

**v_Jiwa_Stock_In_BinsQuery** Parameters:
Name	Parameter	Data Type	Required
BinLocationDesc	query	string	No
BinLocationDescStartsWith	query	string	No
BinLocationDescEndsWith	query	string	No
BinLocationDescContains	query	string	No
BinLocationDescLike	query	string	No
BinLocationDescBetween	query	string[]	No
BinLocationDescIn	query	string[]	No
InventoryID	query	string	No
InventoryIDStartsWith	query	string	No
InventoryIDEndsWith	query	string	No
InventoryIDContains	query	string	No
InventoryIDLike	query	string	No
InventoryIDBetween	query	string[]	No
InventoryIDIn	query	string[]	No
PartNo	query	string	No
PartNoStartsWith	query	string	No
PartNoEndsWith	query	string	No
PartNoContains	query	string	No
PartNoLike	query	string	No
PartNoBetween	query	string[]	No
PartNoIn	query	string[]	No
Description	query	string	No
DescriptionStartsWith	query	string	No
DescriptionEndsWith	query	string	No
DescriptionContains	query	string	No
DescriptionLike	query	string	No
DescriptionBetween	query	string[]	No
DescriptionIn	query	string[]	No
IN_LogicalID	query	string	No
IN_LogicalIDStartsWith	query	string	No
IN_LogicalIDEndsWith	query	string	No
IN_LogicalIDContains	query	string	No
IN_LogicalIDLike	query	string	No
IN_LogicalIDBetween	query	string[]	No
IN_LogicalIDIn	query	string[]	No
LogicalWarehouseDescription	query	string	No
LogicalWarehouseDescriptionStartsWith	query	string	No
LogicalWarehouseDescriptionEndsWith	query	string	No
LogicalWarehouseDescriptionContains	query	string	No
LogicalWarehouseDescriptionLike	query	string	No
LogicalWarehouseDescriptionBetween	query	string[]	No
LogicalWarehouseDescriptionIn	query	string[]	No
IN_PhysicalID	query	string	No
IN_PhysicalIDStartsWith	query	string	No
IN_PhysicalIDEndsWith	query	string	No
IN_PhysicalIDContains	query	string	No
IN_PhysicalIDLike	query	string	No
IN_PhysicalIDBetween	query	string[]	No
IN_PhysicalIDIn	query	string[]	No
PhysicalWarehouseDescription	query	string	No
PhysicalWarehouseDescriptionStartsWith	query	string	No
PhysicalWarehouseDescriptionEndsWith	query	string	No
PhysicalWarehouseDescriptionContains	query	string	No
PhysicalWarehouseDescriptionLike	query	string	No
PhysicalWarehouseDescriptionBetween	query	string[]	No
PhysicalWarehouseDescriptionIn	query	string[]	No
Quantity	query	decimal?	No
QuantityGreaterThanOrEqualTo	query	decimal?	No
QuantityGreaterThan	query	decimal?	No
QuantityLessThan	query	decimal?	No
QuantityLessThanOrEqualTo	query	decimal?	No
QuantityNotEqualTo	query	decimal?	No
QuantityBetween	query	Nullable<Decimal>[]	No
QuantityIn	query	Nullable<Decimal>[]	No

**QueryBase** Parameters:
Name	Parameter	Data Type	Required
Skip	form	int?	No
Take	form	int?	No
OrderBy	form	string	No
OrderByDesc	form	string	No
Include	form	string	No
Fields	form	string	No
Meta	form	Dictionary<string, string>	No

**v_Jiwa_Stock_In_Bins** Parameters:
Name	Parameter	Data Type	Required
BinLocationDesc	form	string	No
InventoryID	form	string	No
PartNo	form	string	No
Description	form	string	No
IN_LogicalID	form	string	No
LogicalWarehouseDescription	form	string	No
IN_PhysicalID	form	string	No
PhysicalWarehouseDescription	form	string	No
Quantity	form	decimal?	No

**QueryResponse<T>** Parameters:
Name	Parameter	Data Type	Required
Offset	form	int	No
Total	form	int	No
Results	form	List<T>	No
Meta	form	Dictionary<string, string>	No
ResponseStatus	form	ResponseStatus	No

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.

GET /Inventory/StockInBins HTTP/1.1 
Host: millers.jiwa.com.au 
Accept: text/csv

HTTP/1.1 200 OK
Content-Type: text/csv
Content-Length: length

{"Results":[{"BinLocationDesc":"String","InventoryID":"String","PartNo":"String","Description":"String","IN_LogicalID":"String","LogicalWarehouseDescription":"String","IN_PhysicalID":"String","PhysicalWarehouseDescription":"String","Quantity":0}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}