JiwaAPI

<back to all web services

IN_OrderLevelsQuery

Requires Authentication
IN_OrderLevelsQuery Parameters:
NameParameterData TypeRequiredDescription
InventoryLevelsIDquerystringNo
InventoryLevelsIDStartsWithquerystringNo
InventoryLevelsIDEndsWithquerystringNo
InventoryLevelsIDContainsquerystringNo
InventoryLevelsIDLikequerystringNo
InventoryLevelsIDBetweenquerystring[]No
InventoryLevelsIDInquerystring[]No
InventoryIDquerystringNo
InventoryIDStartsWithquerystringNo
InventoryIDEndsWithquerystringNo
InventoryIDContainsquerystringNo
InventoryIDLikequerystringNo
InventoryIDBetweenquerystring[]No
InventoryIDInquerystring[]No
Quantity1querydecimal?No
Quantity1GreaterThanOrEqualToquerydecimal?No
Quantity1GreaterThanquerydecimal?No
Quantity1LessThanquerydecimal?No
Quantity1LessThanOrEqualToquerydecimal?No
Quantity1NotEqualToquerydecimal?No
Quantity1Betweenquerydecimal[]No
Quantity1Inquerydecimal[]No
Quantity2querydecimal?No
Quantity2GreaterThanOrEqualToquerydecimal?No
Quantity2GreaterThanquerydecimal?No
Quantity2LessThanquerydecimal?No
Quantity2LessThanOrEqualToquerydecimal?No
Quantity2NotEqualToquerydecimal?No
Quantity2Betweenquerydecimal[]No
Quantity2Inquerydecimal[]No
Quantity3querydecimal?No
Quantity3GreaterThanOrEqualToquerydecimal?No
Quantity3GreaterThanquerydecimal?No
Quantity3LessThanquerydecimal?No
Quantity3LessThanOrEqualToquerydecimal?No
Quantity3NotEqualToquerydecimal?No
Quantity3Betweenquerydecimal[]No
Quantity3Inquerydecimal[]No
Quantity4querydecimal?No
Quantity4GreaterThanOrEqualToquerydecimal?No
Quantity4GreaterThanquerydecimal?No
Quantity4LessThanquerydecimal?No
Quantity4LessThanOrEqualToquerydecimal?No
Quantity4NotEqualToquerydecimal?No
Quantity4Betweenquerydecimal[]No
Quantity4Inquerydecimal[]No
Quantity5querydecimal?No
Quantity5GreaterThanOrEqualToquerydecimal?No
Quantity5GreaterThanquerydecimal?No
Quantity5LessThanquerydecimal?No
Quantity5LessThanOrEqualToquerydecimal?No
Quantity5NotEqualToquerydecimal?No
Quantity5Betweenquerydecimal[]No
Quantity5Inquerydecimal[]No
Quantity6querydecimal?No
Quantity6GreaterThanOrEqualToquerydecimal?No
Quantity6GreaterThanquerydecimal?No
Quantity6LessThanquerydecimal?No
Quantity6LessThanOrEqualToquerydecimal?No
Quantity6NotEqualToquerydecimal?No
Quantity6Betweenquerydecimal[]No
Quantity6Inquerydecimal[]No
Quantity7querydecimal?No
Quantity7GreaterThanOrEqualToquerydecimal?No
Quantity7GreaterThanquerydecimal?No
Quantity7LessThanquerydecimal?No
Quantity7LessThanOrEqualToquerydecimal?No
Quantity7NotEqualToquerydecimal?No
Quantity7Betweenquerydecimal[]No
Quantity7Inquerydecimal[]No
Quantity8querydecimal?No
Quantity8GreaterThanOrEqualToquerydecimal?No
Quantity8GreaterThanquerydecimal?No
Quantity8LessThanquerydecimal?No
Quantity8LessThanOrEqualToquerydecimal?No
Quantity8NotEqualToquerydecimal?No
Quantity8Betweenquerydecimal[]No
Quantity8Inquerydecimal[]No
Quantity9querydecimal?No
Quantity9GreaterThanOrEqualToquerydecimal?No
Quantity9GreaterThanquerydecimal?No
Quantity9LessThanquerydecimal?No
Quantity9LessThanOrEqualToquerydecimal?No
Quantity9NotEqualToquerydecimal?No
Quantity9Betweenquerydecimal[]No
Quantity9Inquerydecimal[]No
Quantity10querydecimal?No
Quantity10GreaterThanOrEqualToquerydecimal?No
Quantity10GreaterThanquerydecimal?No
Quantity10LessThanquerydecimal?No
Quantity10LessThanOrEqualToquerydecimal?No
Quantity10NotEqualToquerydecimal?No
Quantity10Betweenquerydecimal[]No
Quantity10Inquerydecimal[]No
Quantity11querydecimal?No
Quantity11GreaterThanOrEqualToquerydecimal?No
Quantity11GreaterThanquerydecimal?No
Quantity11LessThanquerydecimal?No
Quantity11LessThanOrEqualToquerydecimal?No
Quantity11NotEqualToquerydecimal?No
Quantity11Betweenquerydecimal[]No
Quantity11Inquerydecimal[]No
Quantity12querydecimal?No
Quantity12GreaterThanOrEqualToquerydecimal?No
Quantity12GreaterThanquerydecimal?No
Quantity12LessThanquerydecimal?No
Quantity12LessThanOrEqualToquerydecimal?No
Quantity12NotEqualToquerydecimal?No
Quantity12Betweenquerydecimal[]No
Quantity12Inquerydecimal[]No
Quantity13querydecimal?No
Quantity13GreaterThanOrEqualToquerydecimal?No
Quantity13GreaterThanquerydecimal?No
Quantity13LessThanquerydecimal?No
Quantity13LessThanOrEqualToquerydecimal?No
Quantity13NotEqualToquerydecimal?No
Quantity13Betweenquerydecimal[]No
Quantity13Inquerydecimal[]No
Quantity14querydecimal?No
Quantity14GreaterThanOrEqualToquerydecimal?No
Quantity14GreaterThanquerydecimal?No
Quantity14LessThanquerydecimal?No
Quantity14LessThanOrEqualToquerydecimal?No
Quantity14NotEqualToquerydecimal?No
Quantity14Betweenquerydecimal[]No
Quantity14Inquerydecimal[]No
Quantity15querydecimal?No
Quantity15GreaterThanOrEqualToquerydecimal?No
Quantity15GreaterThanquerydecimal?No
Quantity15LessThanquerydecimal?No
Quantity15LessThanOrEqualToquerydecimal?No
Quantity15NotEqualToquerydecimal?No
Quantity15Betweenquerydecimal[]No
Quantity15Inquerydecimal[]No
Quantity16querydecimal?No
Quantity16GreaterThanOrEqualToquerydecimal?No
Quantity16GreaterThanquerydecimal?No
Quantity16LessThanquerydecimal?No
Quantity16LessThanOrEqualToquerydecimal?No
Quantity16NotEqualToquerydecimal?No
Quantity16Betweenquerydecimal[]No
Quantity16Inquerydecimal[]No
Quantity17querydecimal?No
Quantity17GreaterThanOrEqualToquerydecimal?No
Quantity17GreaterThanquerydecimal?No
Quantity17LessThanquerydecimal?No
Quantity17LessThanOrEqualToquerydecimal?No
Quantity17NotEqualToquerydecimal?No
Quantity17Betweenquerydecimal[]No
Quantity17Inquerydecimal[]No
Quantity18querydecimal?No
Quantity18GreaterThanOrEqualToquerydecimal?No
Quantity18GreaterThanquerydecimal?No
Quantity18LessThanquerydecimal?No
Quantity18LessThanOrEqualToquerydecimal?No
Quantity18NotEqualToquerydecimal?No
Quantity18Betweenquerydecimal[]No
Quantity18Inquerydecimal[]No
Quantity19querydecimal?No
Quantity19GreaterThanOrEqualToquerydecimal?No
Quantity19GreaterThanquerydecimal?No
Quantity19LessThanquerydecimal?No
Quantity19LessThanOrEqualToquerydecimal?No
Quantity19NotEqualToquerydecimal?No
Quantity19Betweenquerydecimal[]No
Quantity19Inquerydecimal[]No
Quantity20querydecimal?No
Quantity20GreaterThanOrEqualToquerydecimal?No
Quantity20GreaterThanquerydecimal?No
Quantity20LessThanquerydecimal?No
Quantity20LessThanOrEqualToquerydecimal?No
Quantity20NotEqualToquerydecimal?No
Quantity20Betweenquerydecimal[]No
Quantity20Inquerydecimal[]No
Quantity21querydecimal?No
Quantity21GreaterThanOrEqualToquerydecimal?No
Quantity21GreaterThanquerydecimal?No
Quantity21LessThanquerydecimal?No
Quantity21LessThanOrEqualToquerydecimal?No
Quantity21NotEqualToquerydecimal?No
Quantity21Betweenquerydecimal[]No
Quantity21Inquerydecimal[]No
Quantity22querydecimal?No
Quantity22GreaterThanOrEqualToquerydecimal?No
Quantity22GreaterThanquerydecimal?No
Quantity22LessThanquerydecimal?No
Quantity22LessThanOrEqualToquerydecimal?No
Quantity22NotEqualToquerydecimal?No
Quantity22Betweenquerydecimal[]No
Quantity22Inquerydecimal[]No
Quantity23querydecimal?No
Quantity23GreaterThanOrEqualToquerydecimal?No
Quantity23GreaterThanquerydecimal?No
Quantity23LessThanquerydecimal?No
Quantity23LessThanOrEqualToquerydecimal?No
Quantity23NotEqualToquerydecimal?No
Quantity23Betweenquerydecimal[]No
Quantity23Inquerydecimal[]No
Quantity24querydecimal?No
Quantity24GreaterThanOrEqualToquerydecimal?No
Quantity24GreaterThanquerydecimal?No
Quantity24LessThanquerydecimal?No
Quantity24LessThanOrEqualToquerydecimal?No
Quantity24NotEqualToquerydecimal?No
Quantity24Betweenquerydecimal[]No
Quantity24Inquerydecimal[]No
IN_LogicalIDquerystringNo
IN_LogicalIDStartsWithquerystringNo
IN_LogicalIDEndsWithquerystringNo
IN_LogicalIDContainsquerystringNo
IN_LogicalIDLikequerystringNo
IN_LogicalIDBetweenquerystring[]No
IN_LogicalIDInquerystring[]No
SafetyMinQuantity1querydecimal?No
SafetyMinQuantity1GreaterThanOrEqualToquerydecimal?No
SafetyMinQuantity1GreaterThanquerydecimal?No
SafetyMinQuantity1LessThanquerydecimal?No
SafetyMinQuantity1LessThanOrEqualToquerydecimal?No
SafetyMinQuantity1NotEqualToquerydecimal?No
SafetyMinQuantity1BetweenqueryNullable<Decimal>[]No
SafetyMinQuantity1InqueryNullable<Decimal>[]No
SafetyMinQuantity2querydecimal?No
SafetyMinQuantity2GreaterThanOrEqualToquerydecimal?No
SafetyMinQuantity2GreaterThanquerydecimal?No
SafetyMinQuantity2LessThanquerydecimal?No
SafetyMinQuantity2LessThanOrEqualToquerydecimal?No
SafetyMinQuantity2NotEqualToquerydecimal?No
SafetyMinQuantity2BetweenqueryNullable<Decimal>[]No
SafetyMinQuantity2InqueryNullable<Decimal>[]No
SafetyMinQuantity3querydecimal?No
SafetyMinQuantity3GreaterThanOrEqualToquerydecimal?No
SafetyMinQuantity3GreaterThanquerydecimal?No
SafetyMinQuantity3LessThanquerydecimal?No
SafetyMinQuantity3LessThanOrEqualToquerydecimal?No
SafetyMinQuantity3NotEqualToquerydecimal?No
SafetyMinQuantity3BetweenqueryNullable<Decimal>[]No
SafetyMinQuantity3InqueryNullable<Decimal>[]No
SafetyMinQuantity4querydecimal?No
SafetyMinQuantity4GreaterThanOrEqualToquerydecimal?No
SafetyMinQuantity4GreaterThanquerydecimal?No
SafetyMinQuantity4LessThanquerydecimal?No
SafetyMinQuantity4LessThanOrEqualToquerydecimal?No
SafetyMinQuantity4NotEqualToquerydecimal?No
SafetyMinQuantity4BetweenqueryNullable<Decimal>[]No
SafetyMinQuantity4InqueryNullable<Decimal>[]No
SafetyMinQuantity5querydecimal?No
SafetyMinQuantity5GreaterThanOrEqualToquerydecimal?No
SafetyMinQuantity5GreaterThanquerydecimal?No
SafetyMinQuantity5LessThanquerydecimal?No
SafetyMinQuantity5LessThanOrEqualToquerydecimal?No
SafetyMinQuantity5NotEqualToquerydecimal?No
SafetyMinQuantity5BetweenqueryNullable<Decimal>[]No
SafetyMinQuantity5InqueryNullable<Decimal>[]No
SafetyMinQuantity6querydecimal?No
SafetyMinQuantity6GreaterThanOrEqualToquerydecimal?No
SafetyMinQuantity6GreaterThanquerydecimal?No
SafetyMinQuantity6LessThanquerydecimal?No
SafetyMinQuantity6LessThanOrEqualToquerydecimal?No
SafetyMinQuantity6NotEqualToquerydecimal?No
SafetyMinQuantity6BetweenqueryNullable<Decimal>[]No
SafetyMinQuantity6InqueryNullable<Decimal>[]No
SafetyMinQuantity7querydecimal?No
SafetyMinQuantity7GreaterThanOrEqualToquerydecimal?No
SafetyMinQuantity7GreaterThanquerydecimal?No
SafetyMinQuantity7LessThanquerydecimal?No
SafetyMinQuantity7LessThanOrEqualToquerydecimal?No
SafetyMinQuantity7NotEqualToquerydecimal?No
SafetyMinQuantity7BetweenqueryNullable<Decimal>[]No
SafetyMinQuantity7InqueryNullable<Decimal>[]No
SafetyMinQuantity8querydecimal?No
SafetyMinQuantity8GreaterThanOrEqualToquerydecimal?No
SafetyMinQuantity8GreaterThanquerydecimal?No
SafetyMinQuantity8LessThanquerydecimal?No
SafetyMinQuantity8LessThanOrEqualToquerydecimal?No
SafetyMinQuantity8NotEqualToquerydecimal?No
SafetyMinQuantity8BetweenqueryNullable<Decimal>[]No
SafetyMinQuantity8InqueryNullable<Decimal>[]No
SafetyMinQuantity9querydecimal?No
SafetyMinQuantity9GreaterThanOrEqualToquerydecimal?No
SafetyMinQuantity9GreaterThanquerydecimal?No
SafetyMinQuantity9LessThanquerydecimal?No
SafetyMinQuantity9LessThanOrEqualToquerydecimal?No
SafetyMinQuantity9NotEqualToquerydecimal?No
SafetyMinQuantity9BetweenqueryNullable<Decimal>[]No
SafetyMinQuantity9InqueryNullable<Decimal>[]No
SafetyMinQuantity10querydecimal?No
SafetyMinQuantity10GreaterThanOrEqualToquerydecimal?No
SafetyMinQuantity10GreaterThanquerydecimal?No
SafetyMinQuantity10LessThanquerydecimal?No
SafetyMinQuantity10LessThanOrEqualToquerydecimal?No
SafetyMinQuantity10NotEqualToquerydecimal?No
SafetyMinQuantity10BetweenqueryNullable<Decimal>[]No
SafetyMinQuantity10InqueryNullable<Decimal>[]No
SafetyMinQuantity11querydecimal?No
SafetyMinQuantity11GreaterThanOrEqualToquerydecimal?No
SafetyMinQuantity11GreaterThanquerydecimal?No
SafetyMinQuantity11LessThanquerydecimal?No
SafetyMinQuantity11LessThanOrEqualToquerydecimal?No
SafetyMinQuantity11NotEqualToquerydecimal?No
SafetyMinQuantity11BetweenqueryNullable<Decimal>[]No
SafetyMinQuantity11InqueryNullable<Decimal>[]No
SafetyMinQuantity12querydecimal?No
SafetyMinQuantity12GreaterThanOrEqualToquerydecimal?No
SafetyMinQuantity12GreaterThanquerydecimal?No
SafetyMinQuantity12LessThanquerydecimal?No
SafetyMinQuantity12LessThanOrEqualToquerydecimal?No
SafetyMinQuantity12NotEqualToquerydecimal?No
SafetyMinQuantity12BetweenqueryNullable<Decimal>[]No
SafetyMinQuantity12InqueryNullable<Decimal>[]No
SafetyMaxQuantity1querydecimal?No
SafetyMaxQuantity1GreaterThanOrEqualToquerydecimal?No
SafetyMaxQuantity1GreaterThanquerydecimal?No
SafetyMaxQuantity1LessThanquerydecimal?No
SafetyMaxQuantity1LessThanOrEqualToquerydecimal?No
SafetyMaxQuantity1NotEqualToquerydecimal?No
SafetyMaxQuantity1BetweenqueryNullable<Decimal>[]No
SafetyMaxQuantity1InqueryNullable<Decimal>[]No
SafetyMaxQuantity2querydecimal?No
SafetyMaxQuantity2GreaterThanOrEqualToquerydecimal?No
SafetyMaxQuantity2GreaterThanquerydecimal?No
SafetyMaxQuantity2LessThanquerydecimal?No
SafetyMaxQuantity2LessThanOrEqualToquerydecimal?No
SafetyMaxQuantity2NotEqualToquerydecimal?No
SafetyMaxQuantity2BetweenqueryNullable<Decimal>[]No
SafetyMaxQuantity2InqueryNullable<Decimal>[]No
SafetyMaxQuantity3querydecimal?No
SafetyMaxQuantity3GreaterThanOrEqualToquerydecimal?No
SafetyMaxQuantity3GreaterThanquerydecimal?No
SafetyMaxQuantity3LessThanquerydecimal?No
SafetyMaxQuantity3LessThanOrEqualToquerydecimal?No
SafetyMaxQuantity3NotEqualToquerydecimal?No
SafetyMaxQuantity3BetweenqueryNullable<Decimal>[]No
SafetyMaxQuantity3InqueryNullable<Decimal>[]No
SafetyMaxQuantity4querydecimal?No
SafetyMaxQuantity4GreaterThanOrEqualToquerydecimal?No
SafetyMaxQuantity4GreaterThanquerydecimal?No
SafetyMaxQuantity4LessThanquerydecimal?No
SafetyMaxQuantity4LessThanOrEqualToquerydecimal?No
SafetyMaxQuantity4NotEqualToquerydecimal?No
SafetyMaxQuantity4BetweenqueryNullable<Decimal>[]No
SafetyMaxQuantity4InqueryNullable<Decimal>[]No
SafetyMaxQuantity5querydecimal?No
SafetyMaxQuantity5GreaterThanOrEqualToquerydecimal?No
SafetyMaxQuantity5GreaterThanquerydecimal?No
SafetyMaxQuantity5LessThanquerydecimal?No
SafetyMaxQuantity5LessThanOrEqualToquerydecimal?No
SafetyMaxQuantity5NotEqualToquerydecimal?No
SafetyMaxQuantity5BetweenqueryNullable<Decimal>[]No
SafetyMaxQuantity5InqueryNullable<Decimal>[]No
SafetyMaxQuantity6querydecimal?No
SafetyMaxQuantity6GreaterThanOrEqualToquerydecimal?No
SafetyMaxQuantity6GreaterThanquerydecimal?No
SafetyMaxQuantity6LessThanquerydecimal?No
SafetyMaxQuantity6LessThanOrEqualToquerydecimal?No
SafetyMaxQuantity6NotEqualToquerydecimal?No
SafetyMaxQuantity6BetweenqueryNullable<Decimal>[]No
SafetyMaxQuantity6InqueryNullable<Decimal>[]No
SafetyMaxQuantity7querydecimal?No
SafetyMaxQuantity7GreaterThanOrEqualToquerydecimal?No
SafetyMaxQuantity7GreaterThanquerydecimal?No
SafetyMaxQuantity7LessThanquerydecimal?No
SafetyMaxQuantity7LessThanOrEqualToquerydecimal?No
SafetyMaxQuantity7NotEqualToquerydecimal?No
SafetyMaxQuantity7BetweenqueryNullable<Decimal>[]No
SafetyMaxQuantity7InqueryNullable<Decimal>[]No
SafetyMaxQuantity8querydecimal?No
SafetyMaxQuantity8GreaterThanOrEqualToquerydecimal?No
SafetyMaxQuantity8GreaterThanquerydecimal?No
SafetyMaxQuantity8LessThanquerydecimal?No
SafetyMaxQuantity8LessThanOrEqualToquerydecimal?No
SafetyMaxQuantity8NotEqualToquerydecimal?No
SafetyMaxQuantity8BetweenqueryNullable<Decimal>[]No
SafetyMaxQuantity8InqueryNullable<Decimal>[]No
SafetyMaxQuantity9querydecimal?No
SafetyMaxQuantity9GreaterThanOrEqualToquerydecimal?No
SafetyMaxQuantity9GreaterThanquerydecimal?No
SafetyMaxQuantity9LessThanquerydecimal?No
SafetyMaxQuantity9LessThanOrEqualToquerydecimal?No
SafetyMaxQuantity9NotEqualToquerydecimal?No
SafetyMaxQuantity9BetweenqueryNullable<Decimal>[]No
SafetyMaxQuantity9InqueryNullable<Decimal>[]No
SafetyMaxQuantity10querydecimal?No
SafetyMaxQuantity10GreaterThanOrEqualToquerydecimal?No
SafetyMaxQuantity10GreaterThanquerydecimal?No
SafetyMaxQuantity10LessThanquerydecimal?No
SafetyMaxQuantity10LessThanOrEqualToquerydecimal?No
SafetyMaxQuantity10NotEqualToquerydecimal?No
SafetyMaxQuantity10BetweenqueryNullable<Decimal>[]No
SafetyMaxQuantity10InqueryNullable<Decimal>[]No
SafetyMaxQuantity11querydecimal?No
SafetyMaxQuantity11GreaterThanOrEqualToquerydecimal?No
SafetyMaxQuantity11GreaterThanquerydecimal?No
SafetyMaxQuantity11LessThanquerydecimal?No
SafetyMaxQuantity11LessThanOrEqualToquerydecimal?No
SafetyMaxQuantity11NotEqualToquerydecimal?No
SafetyMaxQuantity11BetweenqueryNullable<Decimal>[]No
SafetyMaxQuantity11InqueryNullable<Decimal>[]No
SafetyMaxQuantity12querydecimal?No
SafetyMaxQuantity12GreaterThanOrEqualToquerydecimal?No
SafetyMaxQuantity12GreaterThanquerydecimal?No
SafetyMaxQuantity12LessThanquerydecimal?No
SafetyMaxQuantity12LessThanOrEqualToquerydecimal?No
SafetyMaxQuantity12NotEqualToquerydecimal?No
SafetyMaxQuantity12BetweenqueryNullable<Decimal>[]No
SafetyMaxQuantity12InqueryNullable<Decimal>[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
IN_OrderLevels Parameters:
NameParameterData TypeRequiredDescription
InventoryLevelsIDformstringNo
InventoryIDformstringNo
Quantity1formdecimalNo
Quantity2formdecimalNo
Quantity3formdecimalNo
Quantity4formdecimalNo
Quantity5formdecimalNo
Quantity6formdecimalNo
Quantity7formdecimalNo
Quantity8formdecimalNo
Quantity9formdecimalNo
Quantity10formdecimalNo
Quantity11formdecimalNo
Quantity12formdecimalNo
Quantity13formdecimalNo
Quantity14formdecimalNo
Quantity15formdecimalNo
Quantity16formdecimalNo
Quantity17formdecimalNo
Quantity18formdecimalNo
Quantity19formdecimalNo
Quantity20formdecimalNo
Quantity21formdecimalNo
Quantity22formdecimalNo
Quantity23formdecimalNo
Quantity24formdecimalNo
IN_LogicalIDformstringNo
SafetyMinQuantity1formdecimal?No
SafetyMinQuantity2formdecimal?No
SafetyMinQuantity3formdecimal?No
SafetyMinQuantity4formdecimal?No
SafetyMinQuantity5formdecimal?No
SafetyMinQuantity6formdecimal?No
SafetyMinQuantity7formdecimal?No
SafetyMinQuantity8formdecimal?No
SafetyMinQuantity9formdecimal?No
SafetyMinQuantity10formdecimal?No
SafetyMinQuantity11formdecimal?No
SafetyMinQuantity12formdecimal?No
SafetyMaxQuantity1formdecimal?No
SafetyMaxQuantity2formdecimal?No
SafetyMaxQuantity3formdecimal?No
SafetyMaxQuantity4formdecimal?No
SafetyMaxQuantity5formdecimal?No
SafetyMaxQuantity6formdecimal?No
SafetyMaxQuantity7formdecimal?No
SafetyMaxQuantity8formdecimal?No
SafetyMaxQuantity9formdecimal?No
SafetyMaxQuantity10formdecimal?No
SafetyMaxQuantity11formdecimal?No
SafetyMaxQuantity12formdecimal?No
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/IN_OrderLevelsQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: text/csv
Content-Type: text/csv
Content-Length: length

{"InventoryLevelsID":"String","InventoryLevelsIDStartsWith":"String","InventoryLevelsIDEndsWith":"String","InventoryLevelsIDContains":"String","InventoryLevelsIDLike":"String","InventoryLevelsIDBetween":["String"],"InventoryLevelsIDIn":["String"],"InventoryID":"String","InventoryIDStartsWith":"String","InventoryIDEndsWith":"String","InventoryIDContains":"String","InventoryIDLike":"String","InventoryIDBetween":["String"],"InventoryIDIn":["String"],"Quantity1":0,"Quantity1GreaterThanOrEqualTo":0,"Quantity1GreaterThan":0,"Quantity1LessThan":0,"Quantity1LessThanOrEqualTo":0,"Quantity1NotEqualTo":0,"Quantity1Between":[0],"Quantity1In":[0],"Quantity2":0,"Quantity2GreaterThanOrEqualTo":0,"Quantity2GreaterThan":0,"Quantity2LessThan":0,"Quantity2LessThanOrEqualTo":0,"Quantity2NotEqualTo":0,"Quantity2Between":[0],"Quantity2In":[0],"Quantity3":0,"Quantity3GreaterThanOrEqualTo":0,"Quantity3GreaterThan":0,"Quantity3LessThan":0,"Quantity3LessThanOrEqualTo":0,"Quantity3NotEqualTo":0,"Quantity3Between":[0],"Quantity3In":[0],"Quantity4":0,"Quantity4GreaterThanOrEqualTo":0,"Quantity4GreaterThan":0,"Quantity4LessThan":0,"Quantity4LessThanOrEqualTo":0,"Quantity4NotEqualTo":0,"Quantity4Between":[0],"Quantity4In":[0],"Quantity5":0,"Quantity5GreaterThanOrEqualTo":0,"Quantity5GreaterThan":0,"Quantity5LessThan":0,"Quantity5LessThanOrEqualTo":0,"Quantity5NotEqualTo":0,"Quantity5Between":[0],"Quantity5In":[0],"Quantity6":0,"Quantity6GreaterThanOrEqualTo":0,"Quantity6GreaterThan":0,"Quantity6LessThan":0,"Quantity6LessThanOrEqualTo":0,"Quantity6NotEqualTo":0,"Quantity6Between":[0],"Quantity6In":[0],"Quantity7":0,"Quantity7GreaterThanOrEqualTo":0,"Quantity7GreaterThan":0,"Quantity7LessThan":0,"Quantity7LessThanOrEqualTo":0,"Quantity7NotEqualTo":0,"Quantity7Between":[0],"Quantity7In":[0],"Quantity8":0,"Quantity8GreaterThanOrEqualTo":0,"Quantity8GreaterThan":0,"Quantity8LessThan":0,"Quantity8LessThanOrEqualTo":0,"Quantity8NotEqualTo":0,"Quantity8Between":[0],"Quantity8In":[0],"Quantity9":0,"Quantity9GreaterThanOrEqualTo":0,"Quantity9GreaterThan":0,"Quantity9LessThan":0,"Quantity9LessThanOrEqualTo":0,"Quantity9NotEqualTo":0,"Quantity9Between":[0],"Quantity9In":[0],"Quantity10":0,"Quantity10GreaterThanOrEqualTo":0,"Quantity10GreaterThan":0,"Quantity10LessThan":0,"Quantity10LessThanOrEqualTo":0,"Quantity10NotEqualTo":0,"Quantity10Between":[0],"Quantity10In":[0],"Quantity11":0,"Quantity11GreaterThanOrEqualTo":0,"Quantity11GreaterThan":0,"Quantity11LessThan":0,"Quantity11LessThanOrEqualTo":0,"Quantity11NotEqualTo":0,"Quantity11Between":[0],"Quantity11In":[0],"Quantity12":0,"Quantity12GreaterThanOrEqualTo":0,"Quantity12GreaterThan":0,"Quantity12LessThan":0,"Quantity12LessThanOrEqualTo":0,"Quantity12NotEqualTo":0,"Quantity12Between":[0],"Quantity12In":[0],"Quantity13":0,"Quantity13GreaterThanOrEqualTo":0,"Quantity13GreaterThan":0,"Quantity13LessThan":0,"Quantity13LessThanOrEqualTo":0,"Quantity13NotEqualTo":0,"Quantity13Between":[0],"Quantity13In":[0],"Quantity14":0,"Quantity14GreaterThanOrEqualTo":0,"Quantity14GreaterThan":0,"Quantity14LessThan":0,"Quantity14LessThanOrEqualTo":0,"Quantity14NotEqualTo":0,"Quantity14Between":[0],"Quantity14In":[0],"Quantity15":0,"Quantity15GreaterThanOrEqualTo":0,"Quantity15GreaterThan":0,"Quantity15LessThan":0,"Quantity15LessThanOrEqualTo":0,"Quantity15NotEqualTo":0,"Quantity15Between":[0],"Quantity15In":[0],"Quantity16":0,"Quantity16GreaterThanOrEqualTo":0,"Quantity16GreaterThan":0,"Quantity16LessThan":0,"Quantity16LessThanOrEqualTo":0,"Quantity16NotEqualTo":0,"Quantity16Between":[0],"Quantity16In":[0],"Quantity17":0,"Quantity17GreaterThanOrEqualTo":0,"Quantity17GreaterThan":0,"Quantity17LessThan":0,"Quantity17LessThanOrEqualTo":0,"Quantity17NotEqualTo":0,"Quantity17Between":[0],"Quantity17In":[0],"Quantity18":0,"Quantity18GreaterThanOrEqualTo":0,"Quantity18GreaterThan":0,"Quantity18LessThan":0,"Quantity18LessThanOrEqualTo":0,"Quantity18NotEqualTo":0,"Quantity18Between":[0],"Quantity18In":[0],"Quantity19":0,"Quantity19GreaterThanOrEqualTo":0,"Quantity19GreaterThan":0,"Quantity19LessThan":0,"Quantity19LessThanOrEqualTo":0,"Quantity19NotEqualTo":0,"Quantity19Between":[0],"Quantity19In":[0],"Quantity20":0,"Quantity20GreaterThanOrEqualTo":0,"Quantity20GreaterThan":0,"Quantity20LessThan":0,"Quantity20LessThanOrEqualTo":0,"Quantity20NotEqualTo":0,"Quantity20Between":[0],"Quantity20In":[0],"Quantity21":0,"Quantity21GreaterThanOrEqualTo":0,"Quantity21GreaterThan":0,"Quantity21LessThan":0,"Quantity21LessThanOrEqualTo":0,"Quantity21NotEqualTo":0,"Quantity21Between":[0],"Quantity21In":[0],"Quantity22":0,"Quantity22GreaterThanOrEqualTo":0,"Quantity22GreaterThan":0,"Quantity22LessThan":0,"Quantity22LessThanOrEqualTo":0,"Quantity22NotEqualTo":0,"Quantity22Between":[0],"Quantity22In":[0],"Quantity23":0,"Quantity23GreaterThanOrEqualTo":0,"Quantity23GreaterThan":0,"Quantity23LessThan":0,"Quantity23LessThanOrEqualTo":0,"Quantity23NotEqualTo":0,"Quantity23Between":[0],"Quantity23In":[0],"Quantity24":0,"Quantity24GreaterThanOrEqualTo":0,"Quantity24GreaterThan":0,"Quantity24LessThan":0,"Quantity24LessThanOrEqualTo":0,"Quantity24NotEqualTo":0,"Quantity24Between":[0],"Quantity24In":[0],"IN_LogicalID":"String","IN_LogicalIDStartsWith":"String","IN_LogicalIDEndsWith":"String","IN_LogicalIDContains":"String","IN_LogicalIDLike":"String","IN_LogicalIDBetween":["String"],"IN_LogicalIDIn":["String"],"SafetyMinQuantity1":0,"SafetyMinQuantity1GreaterThanOrEqualTo":0,"SafetyMinQuantity1GreaterThan":0,"SafetyMinQuantity1LessThan":0,"SafetyMinQuantity1LessThanOrEqualTo":0,"SafetyMinQuantity1NotEqualTo":0,"SafetyMinQuantity1Between":[0],"SafetyMinQuantity1In":[0],"SafetyMinQuantity2":0,"SafetyMinQuantity2GreaterThanOrEqualTo":0,"SafetyMinQuantity2GreaterThan":0,"SafetyMinQuantity2LessThan":0,"SafetyMinQuantity2LessThanOrEqualTo":0,"SafetyMinQuantity2NotEqualTo":0,"SafetyMinQuantity2Between":[0],"SafetyMinQuantity2In":[0],"SafetyMinQuantity3":0,"SafetyMinQuantity3GreaterThanOrEqualTo":0,"SafetyMinQuantity3GreaterThan":0,"SafetyMinQuantity3LessThan":0,"SafetyMinQuantity3LessThanOrEqualTo":0,"SafetyMinQuantity3NotEqualTo":0,"SafetyMinQuantity3Between":[0],"SafetyMinQuantity3In":[0],"SafetyMinQuantity4":0,"SafetyMinQuantity4GreaterThanOrEqualTo":0,"SafetyMinQuantity4GreaterThan":0,"SafetyMinQuantity4LessThan":0,"SafetyMinQuantity4LessThanOrEqualTo":0,"SafetyMinQuantity4NotEqualTo":0,"SafetyMinQuantity4Between":[0],"SafetyMinQuantity4In":[0],"SafetyMinQuantity5":0,"SafetyMinQuantity5GreaterThanOrEqualTo":0,"SafetyMinQuantity5GreaterThan":0,"SafetyMinQuantity5LessThan":0,"SafetyMinQuantity5LessThanOrEqualTo":0,"SafetyMinQuantity5NotEqualTo":0,"SafetyMinQuantity5Between":[0],"SafetyMinQuantity5In":[0],"SafetyMinQuantity6":0,"SafetyMinQuantity6GreaterThanOrEqualTo":0,"SafetyMinQuantity6GreaterThan":0,"SafetyMinQuantity6LessThan":0,"SafetyMinQuantity6LessThanOrEqualTo":0,"SafetyMinQuantity6NotEqualTo":0,"SafetyMinQuantity6Between":[0],"SafetyMinQuantity6In":[0],"SafetyMinQuantity7":0,"SafetyMinQuantity7GreaterThanOrEqualTo":0,"SafetyMinQuantity7GreaterThan":0,"SafetyMinQuantity7LessThan":0,"SafetyMinQuantity7LessThanOrEqualTo":0,"SafetyMinQuantity7NotEqualTo":0,"SafetyMinQuantity7Between":[0],"SafetyMinQuantity7In":[0],"SafetyMinQuantity8":0,"SafetyMinQuantity8GreaterThanOrEqualTo":0,"SafetyMinQuantity8GreaterThan":0,"SafetyMinQuantity8LessThan":0,"SafetyMinQuantity8LessThanOrEqualTo":0,"SafetyMinQuantity8NotEqualTo":0,"SafetyMinQuantity8Between":[0],"SafetyMinQuantity8In":[0],"SafetyMinQuantity9":0,"SafetyMinQuantity9GreaterThanOrEqualTo":0,"SafetyMinQuantity9GreaterThan":0,"SafetyMinQuantity9LessThan":0,"SafetyMinQuantity9LessThanOrEqualTo":0,"SafetyMinQuantity9NotEqualTo":0,"SafetyMinQuantity9Between":[0],"SafetyMinQuantity9In":[0],"SafetyMinQuantity10":0,"SafetyMinQuantity10GreaterThanOrEqualTo":0,"SafetyMinQuantity10GreaterThan":0,"SafetyMinQuantity10LessThan":0,"SafetyMinQuantity10LessThanOrEqualTo":0,"SafetyMinQuantity10NotEqualTo":0,"SafetyMinQuantity10Between":[0],"SafetyMinQuantity10In":[0],"SafetyMinQuantity11":0,"SafetyMinQuantity11GreaterThanOrEqualTo":0,"SafetyMinQuantity11GreaterThan":0,"SafetyMinQuantity11LessThan":0,"SafetyMinQuantity11LessThanOrEqualTo":0,"SafetyMinQuantity11NotEqualTo":0,"SafetyMinQuantity11Between":[0],"SafetyMinQuantity11In":[0],"SafetyMinQuantity12":0,"SafetyMinQuantity12GreaterThanOrEqualTo":0,"SafetyMinQuantity12GreaterThan":0,"SafetyMinQuantity12LessThan":0,"SafetyMinQuantity12LessThanOrEqualTo":0,"SafetyMinQuantity12NotEqualTo":0,"SafetyMinQuantity12Between":[0],"SafetyMinQuantity12In":[0],"SafetyMaxQuantity1":0,"SafetyMaxQuantity1GreaterThanOrEqualTo":0,"SafetyMaxQuantity1GreaterThan":0,"SafetyMaxQuantity1LessThan":0,"SafetyMaxQuantity1LessThanOrEqualTo":0,"SafetyMaxQuantity1NotEqualTo":0,"SafetyMaxQuantity1Between":[0],"SafetyMaxQuantity1In":[0],"SafetyMaxQuantity2":0,"SafetyMaxQuantity2GreaterThanOrEqualTo":0,"SafetyMaxQuantity2GreaterThan":0,"SafetyMaxQuantity2LessThan":0,"SafetyMaxQuantity2LessThanOrEqualTo":0,"SafetyMaxQuantity2NotEqualTo":0,"SafetyMaxQuantity2Between":[0],"SafetyMaxQuantity2In":[0],"SafetyMaxQuantity3":0,"SafetyMaxQuantity3GreaterThanOrEqualTo":0,"SafetyMaxQuantity3GreaterThan":0,"SafetyMaxQuantity3LessThan":0,"SafetyMaxQuantity3LessThanOrEqualTo":0,"SafetyMaxQuantity3NotEqualTo":0,"SafetyMaxQuantity3Between":[0],"SafetyMaxQuantity3In":[0],"SafetyMaxQuantity4":0,"SafetyMaxQuantity4GreaterThanOrEqualTo":0,"SafetyMaxQuantity4GreaterThan":0,"SafetyMaxQuantity4LessThan":0,"SafetyMaxQuantity4LessThanOrEqualTo":0,"SafetyMaxQuantity4NotEqualTo":0,"SafetyMaxQuantity4Between":[0],"SafetyMaxQuantity4In":[0],"SafetyMaxQuantity5":0,"SafetyMaxQuantity5GreaterThanOrEqualTo":0,"SafetyMaxQuantity5GreaterThan":0,"SafetyMaxQuantity5LessThan":0,"SafetyMaxQuantity5LessThanOrEqualTo":0,"SafetyMaxQuantity5NotEqualTo":0,"SafetyMaxQuantity5Between":[0],"SafetyMaxQuantity5In":[0],"SafetyMaxQuantity6":0,"SafetyMaxQuantity6GreaterThanOrEqualTo":0,"SafetyMaxQuantity6GreaterThan":0,"SafetyMaxQuantity6LessThan":0,"SafetyMaxQuantity6LessThanOrEqualTo":0,"SafetyMaxQuantity6NotEqualTo":0,"SafetyMaxQuantity6Between":[0],"SafetyMaxQuantity6In":[0],"SafetyMaxQuantity7":0,"SafetyMaxQuantity7GreaterThanOrEqualTo":0,"SafetyMaxQuantity7GreaterThan":0,"SafetyMaxQuantity7LessThan":0,"SafetyMaxQuantity7LessThanOrEqualTo":0,"SafetyMaxQuantity7NotEqualTo":0,"SafetyMaxQuantity7Between":[0],"SafetyMaxQuantity7In":[0],"SafetyMaxQuantity8":0,"SafetyMaxQuantity8GreaterThanOrEqualTo":0,"SafetyMaxQuantity8GreaterThan":0,"SafetyMaxQuantity8LessThan":0,"SafetyMaxQuantity8LessThanOrEqualTo":0,"SafetyMaxQuantity8NotEqualTo":0,"SafetyMaxQuantity8Between":[0],"SafetyMaxQuantity8In":[0],"SafetyMaxQuantity9":0,"SafetyMaxQuantity9GreaterThanOrEqualTo":0,"SafetyMaxQuantity9GreaterThan":0,"SafetyMaxQuantity9LessThan":0,"SafetyMaxQuantity9LessThanOrEqualTo":0,"SafetyMaxQuantity9NotEqualTo":0,"SafetyMaxQuantity9Between":[0],"SafetyMaxQuantity9In":[0],"SafetyMaxQuantity10":0,"SafetyMaxQuantity10GreaterThanOrEqualTo":0,"SafetyMaxQuantity10GreaterThan":0,"SafetyMaxQuantity10LessThan":0,"SafetyMaxQuantity10LessThanOrEqualTo":0,"SafetyMaxQuantity10NotEqualTo":0,"SafetyMaxQuantity10Between":[0],"SafetyMaxQuantity10In":[0],"SafetyMaxQuantity11":0,"SafetyMaxQuantity11GreaterThanOrEqualTo":0,"SafetyMaxQuantity11GreaterThan":0,"SafetyMaxQuantity11LessThan":0,"SafetyMaxQuantity11LessThanOrEqualTo":0,"SafetyMaxQuantity11NotEqualTo":0,"SafetyMaxQuantity11Between":[0],"SafetyMaxQuantity11In":[0],"SafetyMaxQuantity12":0,"SafetyMaxQuantity12GreaterThanOrEqualTo":0,"SafetyMaxQuantity12GreaterThan":0,"SafetyMaxQuantity12LessThan":0,"SafetyMaxQuantity12LessThanOrEqualTo":0,"SafetyMaxQuantity12NotEqualTo":0,"SafetyMaxQuantity12Between":[0],"SafetyMaxQuantity12In":[0],"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":[{"InventoryLevelsID":"String","InventoryID":"String","IN_LogicalID":"String","SafetyMinQuantity1":0,"SafetyMinQuantity2":0,"SafetyMinQuantity3":0,"SafetyMinQuantity4":0,"SafetyMinQuantity5":0,"SafetyMinQuantity6":0,"SafetyMinQuantity7":0,"SafetyMinQuantity8":0,"SafetyMinQuantity9":0,"SafetyMinQuantity10":0,"SafetyMinQuantity11":0,"SafetyMinQuantity12":0,"SafetyMaxQuantity1":0,"SafetyMaxQuantity2":0,"SafetyMaxQuantity3":0,"SafetyMaxQuantity4":0,"SafetyMaxQuantity5":0,"SafetyMaxQuantity6":0,"SafetyMaxQuantity7":0,"SafetyMaxQuantity8":0,"SafetyMaxQuantity9":0,"SafetyMaxQuantity10":0,"SafetyMaxQuantity11":0,"SafetyMaxQuantity12":0}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}