JiwaAPI

v_Oscar_StockLevelQuery

The following routes are available for this service:
GET	/Queries/OscarStockLevels	Queryable list stock levels for Oscar

**v_Oscar_StockLevelQuery** Parameters:
Name	Parameter	Data Type	Required
IN_WarehouseSOHID	query	string	No
IN_WarehouseSOHIDStartsWith	query	string	No
IN_WarehouseSOHIDEndsWith	query	string	No
IN_WarehouseSOHIDContains	query	string	No
IN_WarehouseSOHIDLike	query	string	No
IN_WarehouseSOHIDBetween	query	string[]	No
IN_WarehouseSOHIDIn	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
AAPI	query	string	No
AAPIStartsWith	query	string	No
AAPIEndsWith	query	string	No
AAPIContains	query	string	No
AAPILike	query	string	No
AAPIBetween	query	string[]	No
AAPIIn	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
LogicalWarehouseID	query	string	No
LogicalWarehouseIDStartsWith	query	string	No
LogicalWarehouseIDEndsWith	query	string	No
LogicalWarehouseIDContains	query	string	No
LogicalWarehouseIDLike	query	string	No
LogicalWarehouseIDBetween	query	string[]	No
LogicalWarehouseIDIn	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
LogicalWarehouseCode	query	string	No
LogicalWarehouseCodeStartsWith	query	string	No
LogicalWarehouseCodeEndsWith	query	string	No
LogicalWarehouseCodeContains	query	string	No
LogicalWarehouseCodeLike	query	string	No
LogicalWarehouseCodeBetween	query	string[]	No
LogicalWarehouseCodeIn	query	string[]	No
LogicalWarehouseInTransit	query	bool?	No
PhysicalWarehouseID	query	string	No
PhysicalWarehouseIDStartsWith	query	string	No
PhysicalWarehouseIDEndsWith	query	string	No
PhysicalWarehouseIDContains	query	string	No
PhysicalWarehouseIDLike	query	string	No
PhysicalWarehouseIDBetween	query	string[]	No
PhysicalWarehouseIDIn	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
PhysicalWarehouseAddress1	query	string	No
PhysicalWarehouseAddress1StartsWith	query	string	No
PhysicalWarehouseAddress1EndsWith	query	string	No
PhysicalWarehouseAddress1Contains	query	string	No
PhysicalWarehouseAddress1Like	query	string	No
PhysicalWarehouseAddress1Between	query	string[]	No
PhysicalWarehouseAddress1In	query	string[]	No
PhysicalWarehouseAddress2	query	string	No
PhysicalWarehouseAddress2StartsWith	query	string	No
PhysicalWarehouseAddress2EndsWith	query	string	No
PhysicalWarehouseAddress2Contains	query	string	No
PhysicalWarehouseAddress2Like	query	string	No
PhysicalWarehouseAddress2Between	query	string[]	No
PhysicalWarehouseAddress2In	query	string[]	No
PhysicalWarehouseAddress3	query	string	No
PhysicalWarehouseAddress3StartsWith	query	string	No
PhysicalWarehouseAddress3EndsWith	query	string	No
PhysicalWarehouseAddress3Contains	query	string	No
PhysicalWarehouseAddress3Like	query	string	No
PhysicalWarehouseAddress3Between	query	string[]	No
PhysicalWarehouseAddress3In	query	string[]	No
PhysicalWarehouseAddress4	query	string	No
PhysicalWarehouseAddress4StartsWith	query	string	No
PhysicalWarehouseAddress4EndsWith	query	string	No
PhysicalWarehouseAddress4Contains	query	string	No
PhysicalWarehouseAddress4Like	query	string	No
PhysicalWarehouseAddress4Between	query	string[]	No
PhysicalWarehouseAddress4In	query	string[]	No
PhysicalWarehousePostcode	query	string	No
PhysicalWarehousePostcodeStartsWith	query	string	No
PhysicalWarehousePostcodeEndsWith	query	string	No
PhysicalWarehousePostcodeContains	query	string	No
PhysicalWarehousePostcodeLike	query	string	No
PhysicalWarehousePostcodeBetween	query	string[]	No
PhysicalWarehousePostcodeIn	query	string[]	No
PhysicalWarehouseTelephone	query	string	No
PhysicalWarehouseTelephoneStartsWith	query	string	No
PhysicalWarehouseTelephoneEndsWith	query	string	No
PhysicalWarehouseTelephoneContains	query	string	No
PhysicalWarehouseTelephoneLike	query	string	No
PhysicalWarehouseTelephoneBetween	query	string[]	No
PhysicalWarehouseTelephoneIn	query	string[]	No
QuantityLeft	query	decimal?	No
QuantityLeftGreaterThanOrEqualTo	query	decimal?	No
QuantityLeftGreaterThan	query	decimal?	No
QuantityLeftLessThan	query	decimal?	No
QuantityLeftLessThanOrEqualTo	query	decimal?	No
QuantityLeftNotEqualTo	query	decimal?	No
QuantityLeftBetween	query	Nullable<Decimal>[]	No
QuantityLeftIn	query	Nullable<Decimal>[]	No
QuantityAllocated	query	decimal?	No
QuantityAllocatedGreaterThanOrEqualTo	query	decimal?	No
QuantityAllocatedGreaterThan	query	decimal?	No
QuantityAllocatedLessThan	query	decimal?	No
QuantityAllocatedLessThanOrEqualTo	query	decimal?	No
QuantityAllocatedNotEqualTo	query	decimal?	No
QuantityAllocatedBetween	query	Nullable<Decimal>[]	No
QuantityAllocatedIn	query	Nullable<Decimal>[]	No
QuantityAvailable	query	decimal?	No
QuantityAvailableGreaterThanOrEqualTo	query	decimal?	No
QuantityAvailableGreaterThan	query	decimal?	No
QuantityAvailableLessThan	query	decimal?	No
QuantityAvailableLessThanOrEqualTo	query	decimal?	No
QuantityAvailableNotEqualTo	query	decimal?	No
QuantityAvailableBetween	query	Nullable<Decimal>[]	No
QuantityAvailableIn	query	Nullable<Decimal>[]	No
Status	query	short?	No
StatusStartsWith	query	short?	No
StatusEndsWith	query	short?	No
StatusContains	query	short?	No
StatusLike	query	short?	No
StatusBetween	query	Nullable<Int16>[]	No
StatusIn	query	Nullable<Int16>[]	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_Oscar_StockLevel** Parameters:
Name	Parameter	Data Type	Required
IN_WarehouseSOHID	form	string	No
InventoryID	form	string	No
PartNo	form	string	No
AAPI	form	string	No
Description	form	string	No
LogicalWarehouseID	form	string	No
LogicalWarehouseDescription	form	string	No
LogicalWarehouseCode	form	string	No
LogicalWarehouseInTransit	form	bool?	No
PhysicalWarehouseID	form	string	No
PhysicalWarehouseDescription	form	string	No
PhysicalWarehouseAddress1	form	string	No
PhysicalWarehouseAddress2	form	string	No
PhysicalWarehouseAddress3	form	string	No
PhysicalWarehouseAddress4	form	string	No
PhysicalWarehousePostcode	form	string	No
PhysicalWarehouseTelephone	form	string	No
QuantityLeft	form	decimal?	No
QuantityAllocated	form	decimal?	No
QuantityAvailable	form	decimal?	No
Status	form	int?	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 .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.

GET /Queries/OscarStockLevels HTTP/1.1 
Host: 10.150.151.12 
Accept: application/json

HTTP/1.1 200 OK
Content-Type: application/json
Content-Length: length

{"Results":[{"IN_WarehouseSOHID":"String","InventoryID":"String","PartNo":"String","AAPI":"String","Description":"String","LogicalWarehouseID":"String","LogicalWarehouseDescription":"String","LogicalWarehouseCode":"String","LogicalWarehouseInTransit":false,"PhysicalWarehouseID":"String","PhysicalWarehouseDescription":"String","PhysicalWarehouseAddress1":"String","PhysicalWarehouseAddress2":"String","PhysicalWarehouseAddress3":"String","PhysicalWarehouseAddress4":"String","PhysicalWarehousePostcode":"String","PhysicalWarehouseTelephone":"String","QuantityLeft":0,"QuantityAllocated":0,"QuantityAvailable":0,"Status":0}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}