JiwaAPI

<back to all web services

IN_SupplierWarehouseQuery

Requires Authentication
IN_SupplierWarehouseQuery Parameters:
NameParameterData TypeRequiredDescription
RecIDquerystringNo
RecIDStartsWithquerystringNo
RecIDEndsWithquerystringNo
RecIDContainsquerystringNo
RecIDLikequerystringNo
RecIDBetweenquerystring[]No
RecIDInquerystring[]No
IN_Creditor_RecIDquerystringNo
IN_Creditor_RecIDStartsWithquerystringNo
IN_Creditor_RecIDEndsWithquerystringNo
IN_Creditor_RecIDContainsquerystringNo
IN_Creditor_RecIDLikequerystringNo
IN_Creditor_RecIDBetweenquerystring[]No
IN_Creditor_RecIDInquerystring[]No
InventoryIDquerystringNo
InventoryIDStartsWithquerystringNo
InventoryIDEndsWithquerystringNo
InventoryIDContainsquerystringNo
InventoryIDLikequerystringNo
InventoryIDBetweenquerystring[]No
InventoryIDInquerystring[]No
WarehouseIDquerystringNo
WarehouseIDStartsWithquerystringNo
WarehouseIDEndsWithquerystringNo
WarehouseIDContainsquerystringNo
WarehouseIDLikequerystringNo
WarehouseIDBetweenquerystring[]No
WarehouseIDInquerystring[]No
FreightInIDquerystringNo
FreightInIDStartsWithquerystringNo
FreightInIDEndsWithquerystringNo
FreightInIDContainsquerystringNo
FreightInIDLikequerystringNo
FreightInIDBetweenquerystring[]No
FreightInIDInquerystring[]No
OrderUnitsquerydecimal?No
OrderUnitsGreaterThanOrEqualToquerydecimal?No
OrderUnitsGreaterThanquerydecimal?No
OrderUnitsLessThanquerydecimal?No
OrderUnitsLessThanOrEqualToquerydecimal?No
OrderUnitsNotEqualToquerydecimal?No
OrderUnitsBetweenqueryNullable<Decimal>[]No
OrderUnitsInqueryNullable<Decimal>[]No
DeliveryDaysqueryshort?No
DeliveryDaysGreaterThanOrEqualToqueryshort?No
DeliveryDaysGreaterThanqueryshort?No
DeliveryDaysLessThanqueryshort?No
DeliveryDaysLessThanOrEqualToqueryshort?No
DeliveryDaysNotEqualToqueryshort?No
DeliveryDaysBetweenqueryNullable<Int16>[]No
DeliveryDaysInqueryNullable<Int16>[]No
SuppliersCostquerydecimal?No
SuppliersCostGreaterThanOrEqualToquerydecimal?No
SuppliersCostGreaterThanquerydecimal?No
SuppliersCostLessThanquerydecimal?No
SuppliersCostLessThanOrEqualToquerydecimal?No
SuppliersCostNotEqualToquerydecimal?No
SuppliersCostBetweenqueryNullable<Decimal>[]No
SuppliersCostInqueryNullable<Decimal>[]No
HomeSuppliersCostquerydecimal?No
HomeSuppliersCostGreaterThanOrEqualToquerydecimal?No
HomeSuppliersCostGreaterThanquerydecimal?No
HomeSuppliersCostLessThanquerydecimal?No
HomeSuppliersCostLessThanOrEqualToquerydecimal?No
HomeSuppliersCostNotEqualToquerydecimal?No
HomeSuppliersCostBetweenqueryNullable<Decimal>[]No
HomeSuppliersCostInqueryNullable<Decimal>[]No
DutyIDquerystringNo
DutyIDStartsWithquerystringNo
DutyIDEndsWithquerystringNo
DutyIDContainsquerystringNo
DutyIDLikequerystringNo
DutyIDBetweenquerystring[]No
DutyIDInquerystring[]No
SupplierSOHquerydecimal?No
SupplierSOHGreaterThanOrEqualToquerydecimal?No
SupplierSOHGreaterThanquerydecimal?No
SupplierSOHLessThanquerydecimal?No
SupplierSOHLessThanOrEqualToquerydecimal?No
SupplierSOHNotEqualToquerydecimal?No
SupplierSOHBetweenqueryNullable<Decimal>[]No
SupplierSOHInqueryNullable<Decimal>[]No
SuppliersCost2querydecimal?No
SuppliersCost2GreaterThanOrEqualToquerydecimal?No
SuppliersCost2GreaterThanquerydecimal?No
SuppliersCost2LessThanquerydecimal?No
SuppliersCost2LessThanOrEqualToquerydecimal?No
SuppliersCost2NotEqualToquerydecimal?No
SuppliersCost2BetweenqueryNullable<Decimal>[]No
SuppliersCost2InqueryNullable<Decimal>[]No
HomeSuppliersCost2querydecimal?No
HomeSuppliersCost2GreaterThanOrEqualToquerydecimal?No
HomeSuppliersCost2GreaterThanquerydecimal?No
HomeSuppliersCost2LessThanquerydecimal?No
HomeSuppliersCost2LessThanOrEqualToquerydecimal?No
HomeSuppliersCost2NotEqualToquerydecimal?No
HomeSuppliersCost2BetweenqueryNullable<Decimal>[]No
HomeSuppliersCost2InqueryNullable<Decimal>[]No
SpareFloat1querydecimal?No
SpareFloat1GreaterThanOrEqualToquerydecimal?No
SpareFloat1GreaterThanquerydecimal?No
SpareFloat1LessThanquerydecimal?No
SpareFloat1LessThanOrEqualToquerydecimal?No
SpareFloat1NotEqualToquerydecimal?No
SpareFloat1BetweenqueryNullable<Decimal>[]No
SpareFloat1InqueryNullable<Decimal>[]No
SpareFloat2querydecimal?No
SpareFloat2GreaterThanOrEqualToquerydecimal?No
SpareFloat2GreaterThanquerydecimal?No
SpareFloat2LessThanquerydecimal?No
SpareFloat2LessThanOrEqualToquerydecimal?No
SpareFloat2NotEqualToquerydecimal?No
SpareFloat2BetweenqueryNullable<Decimal>[]No
SpareFloat2InqueryNullable<Decimal>[]No
SpareFloat3querydecimal?No
SpareFloat3GreaterThanOrEqualToquerydecimal?No
SpareFloat3GreaterThanquerydecimal?No
SpareFloat3LessThanquerydecimal?No
SpareFloat3LessThanOrEqualToquerydecimal?No
SpareFloat3NotEqualToquerydecimal?No
SpareFloat3BetweenqueryNullable<Decimal>[]No
SpareFloat3InqueryNullable<Decimal>[]No
SpareString1querystringNo
SpareString1StartsWithquerystringNo
SpareString1EndsWithquerystringNo
SpareString1ContainsquerystringNo
SpareString1LikequerystringNo
SpareString1Betweenquerystring[]No
SpareString1Inquerystring[]No
SpareString2querystringNo
SpareString2StartsWithquerystringNo
SpareString2EndsWithquerystringNo
SpareString2ContainsquerystringNo
SpareString2LikequerystringNo
SpareString2Betweenquerystring[]No
SpareString2Inquerystring[]No
SpareString3querystringNo
SpareString3StartsWithquerystringNo
SpareString3EndsWithquerystringNo
SpareString3ContainsquerystringNo
SpareString3LikequerystringNo
SpareString3Betweenquerystring[]No
SpareString3Inquerystring[]No
SpareDate1queryDateTime?No
SpareDate1GreaterThanOrEqualToqueryDateTime?No
SpareDate1GreaterThanqueryDateTime?No
SpareDate1LessThanqueryDateTime?No
SpareDate1LessThanOrEqualToqueryDateTime?No
SpareDate1NotEqualToqueryDateTime?No
SpareDate1BetweenqueryNullable<DateTime>[]No
SpareDate1InqueryNullable<DateTime>[]No
SpareDate2queryDateTime?No
SpareDate2GreaterThanOrEqualToqueryDateTime?No
SpareDate2GreaterThanqueryDateTime?No
SpareDate2LessThanqueryDateTime?No
SpareDate2LessThanOrEqualToqueryDateTime?No
SpareDate2NotEqualToqueryDateTime?No
SpareDate2BetweenqueryNullable<DateTime>[]No
SpareDate2InqueryNullable<DateTime>[]No
SpareDate3queryDateTime?No
SpareDate3GreaterThanOrEqualToqueryDateTime?No
SpareDate3GreaterThanqueryDateTime?No
SpareDate3LessThanqueryDateTime?No
SpareDate3LessThanOrEqualToqueryDateTime?No
SpareDate3NotEqualToqueryDateTime?No
SpareDate3BetweenqueryNullable<DateTime>[]No
SpareDate3InqueryNullable<DateTime>[]No
DefaultSupplierWarehousequerybool?No
ItemNoqueryint?No
ItemNoGreaterThanOrEqualToqueryint?No
ItemNoGreaterThanqueryint?No
ItemNoLessThanqueryint?No
ItemNoLessThanOrEqualToqueryint?No
ItemNoNotEqualToqueryint?No
ItemNoBetweenqueryint[]No
ItemNoInqueryint[]No
IN_UnitOfMeasure_RecIDqueryGuid?No
IN_UnitOfMeasure_RecIDInqueryNullable<Guid>[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
IN_SupplierWarehouse Parameters:
NameParameterData TypeRequiredDescription
RecIDformstringNo
IN_Creditor_RecIDformstringNo
InventoryIDformstringNo
WarehouseIDformstringNo
FreightInIDformstringNo
OrderUnitsformdecimal?No
DeliveryDaysformshort?No
SuppliersCostformdecimal?No
HomeSuppliersCostformdecimal?No
DutyIDformstringNo
SupplierSOHformdecimal?No
SuppliersCost2formdecimal?No
HomeSuppliersCost2formdecimal?No
SpareFloat1formdecimal?No
SpareFloat2formdecimal?No
SpareFloat3formdecimal?No
SpareString1formstringNo
SpareString2formstringNo
SpareString3formstringNo
SpareDate1formDateTime?No
SpareDate2formDateTime?No
SpareDate3formDateTime?No
DefaultSupplierWarehouseformbool?No
ItemNoformintNo
IN_UnitOfMeasure_RecIDformGuid?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_SupplierWarehouseQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: text/csv
Content-Type: text/csv
Content-Length: length

{"RecID":"String","RecIDStartsWith":"String","RecIDEndsWith":"String","RecIDContains":"String","RecIDLike":"String","RecIDBetween":["String"],"RecIDIn":["String"],"IN_Creditor_RecID":"String","IN_Creditor_RecIDStartsWith":"String","IN_Creditor_RecIDEndsWith":"String","IN_Creditor_RecIDContains":"String","IN_Creditor_RecIDLike":"String","IN_Creditor_RecIDBetween":["String"],"IN_Creditor_RecIDIn":["String"],"InventoryID":"String","InventoryIDStartsWith":"String","InventoryIDEndsWith":"String","InventoryIDContains":"String","InventoryIDLike":"String","InventoryIDBetween":["String"],"InventoryIDIn":["String"],"WarehouseID":"String","WarehouseIDStartsWith":"String","WarehouseIDEndsWith":"String","WarehouseIDContains":"String","WarehouseIDLike":"String","WarehouseIDBetween":["String"],"WarehouseIDIn":["String"],"FreightInID":"String","FreightInIDStartsWith":"String","FreightInIDEndsWith":"String","FreightInIDContains":"String","FreightInIDLike":"String","FreightInIDBetween":["String"],"FreightInIDIn":["String"],"OrderUnits":0,"OrderUnitsGreaterThanOrEqualTo":0,"OrderUnitsGreaterThan":0,"OrderUnitsLessThan":0,"OrderUnitsLessThanOrEqualTo":0,"OrderUnitsNotEqualTo":0,"OrderUnitsBetween":[0],"OrderUnitsIn":[0],"DeliveryDays":0,"DeliveryDaysGreaterThanOrEqualTo":0,"DeliveryDaysGreaterThan":0,"DeliveryDaysLessThan":0,"DeliveryDaysLessThanOrEqualTo":0,"DeliveryDaysNotEqualTo":0,"DeliveryDaysBetween":[0],"DeliveryDaysIn":[0],"SuppliersCost":0,"SuppliersCostGreaterThanOrEqualTo":0,"SuppliersCostGreaterThan":0,"SuppliersCostLessThan":0,"SuppliersCostLessThanOrEqualTo":0,"SuppliersCostNotEqualTo":0,"SuppliersCostBetween":[0],"SuppliersCostIn":[0],"HomeSuppliersCost":0,"HomeSuppliersCostGreaterThanOrEqualTo":0,"HomeSuppliersCostGreaterThan":0,"HomeSuppliersCostLessThan":0,"HomeSuppliersCostLessThanOrEqualTo":0,"HomeSuppliersCostNotEqualTo":0,"HomeSuppliersCostBetween":[0],"HomeSuppliersCostIn":[0],"DutyID":"String","DutyIDStartsWith":"String","DutyIDEndsWith":"String","DutyIDContains":"String","DutyIDLike":"String","DutyIDBetween":["String"],"DutyIDIn":["String"],"SupplierSOH":0,"SupplierSOHGreaterThanOrEqualTo":0,"SupplierSOHGreaterThan":0,"SupplierSOHLessThan":0,"SupplierSOHLessThanOrEqualTo":0,"SupplierSOHNotEqualTo":0,"SupplierSOHBetween":[0],"SupplierSOHIn":[0],"SuppliersCost2":0,"SuppliersCost2GreaterThanOrEqualTo":0,"SuppliersCost2GreaterThan":0,"SuppliersCost2LessThan":0,"SuppliersCost2LessThanOrEqualTo":0,"SuppliersCost2NotEqualTo":0,"SuppliersCost2Between":[0],"SuppliersCost2In":[0],"HomeSuppliersCost2":0,"HomeSuppliersCost2GreaterThanOrEqualTo":0,"HomeSuppliersCost2GreaterThan":0,"HomeSuppliersCost2LessThan":0,"HomeSuppliersCost2LessThanOrEqualTo":0,"HomeSuppliersCost2NotEqualTo":0,"HomeSuppliersCost2Between":[0],"HomeSuppliersCost2In":[0],"SpareFloat1":0,"SpareFloat1GreaterThanOrEqualTo":0,"SpareFloat1GreaterThan":0,"SpareFloat1LessThan":0,"SpareFloat1LessThanOrEqualTo":0,"SpareFloat1NotEqualTo":0,"SpareFloat1Between":[0],"SpareFloat1In":[0],"SpareFloat2":0,"SpareFloat2GreaterThanOrEqualTo":0,"SpareFloat2GreaterThan":0,"SpareFloat2LessThan":0,"SpareFloat2LessThanOrEqualTo":0,"SpareFloat2NotEqualTo":0,"SpareFloat2Between":[0],"SpareFloat2In":[0],"SpareFloat3":0,"SpareFloat3GreaterThanOrEqualTo":0,"SpareFloat3GreaterThan":0,"SpareFloat3LessThan":0,"SpareFloat3LessThanOrEqualTo":0,"SpareFloat3NotEqualTo":0,"SpareFloat3Between":[0],"SpareFloat3In":[0],"SpareString1":"String","SpareString1StartsWith":"String","SpareString1EndsWith":"String","SpareString1Contains":"String","SpareString1Like":"String","SpareString1Between":["String"],"SpareString1In":["String"],"SpareString2":"String","SpareString2StartsWith":"String","SpareString2EndsWith":"String","SpareString2Contains":"String","SpareString2Like":"String","SpareString2Between":["String"],"SpareString2In":["String"],"SpareString3":"String","SpareString3StartsWith":"String","SpareString3EndsWith":"String","SpareString3Contains":"String","SpareString3Like":"String","SpareString3Between":["String"],"SpareString3In":["String"],"SpareDate1":"0001-01-01T00:00:00.0000000","SpareDate1GreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","SpareDate1GreaterThan":"0001-01-01T00:00:00.0000000","SpareDate1LessThan":"0001-01-01T00:00:00.0000000","SpareDate1LessThanOrEqualTo":"0001-01-01T00:00:00.0000000","SpareDate1NotEqualTo":"0001-01-01T00:00:00.0000000","SpareDate1Between":["0001-01-01T00:00:00.0000000"],"SpareDate1In":["0001-01-01T00:00:00.0000000"],"SpareDate2":"0001-01-01T00:00:00.0000000","SpareDate2GreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","SpareDate2GreaterThan":"0001-01-01T00:00:00.0000000","SpareDate2LessThan":"0001-01-01T00:00:00.0000000","SpareDate2LessThanOrEqualTo":"0001-01-01T00:00:00.0000000","SpareDate2NotEqualTo":"0001-01-01T00:00:00.0000000","SpareDate2Between":["0001-01-01T00:00:00.0000000"],"SpareDate2In":["0001-01-01T00:00:00.0000000"],"SpareDate3":"0001-01-01T00:00:00.0000000","SpareDate3GreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","SpareDate3GreaterThan":"0001-01-01T00:00:00.0000000","SpareDate3LessThan":"0001-01-01T00:00:00.0000000","SpareDate3LessThanOrEqualTo":"0001-01-01T00:00:00.0000000","SpareDate3NotEqualTo":"0001-01-01T00:00:00.0000000","SpareDate3Between":["0001-01-01T00:00:00.0000000"],"SpareDate3In":["0001-01-01T00:00:00.0000000"],"DefaultSupplierWarehouse":false,"ItemNo":0,"ItemNoGreaterThanOrEqualTo":0,"ItemNoGreaterThan":0,"ItemNoLessThan":0,"ItemNoLessThanOrEqualTo":0,"ItemNoNotEqualTo":0,"ItemNoBetween":[0],"ItemNoIn":[0],"IN_UnitOfMeasure_RecID":"00000000000000000000000000000000","IN_UnitOfMeasure_RecIDIn":["00000000000000000000000000000000"],"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":[{"RecID":"String","IN_Creditor_RecID":"String","InventoryID":"String","WarehouseID":"String","FreightInID":"String","OrderUnits":0,"DeliveryDays":0,"SuppliersCost":0,"HomeSuppliersCost":0,"DutyID":"String","SupplierSOH":0,"SuppliersCost2":0,"HomeSuppliersCost2":0,"SpareFloat1":0,"SpareFloat2":0,"SpareFloat3":0,"SpareString1":"String","SpareString2":"String","SpareString3":"String","SpareDate1":"0001-01-01T00:00:00.0000000","SpareDate2":"0001-01-01T00:00:00.0000000","SpareDate3":"0001-01-01T00:00:00.0000000","DefaultSupplierWarehouse":false,"IN_UnitOfMeasure_RecID":"00000000000000000000000000000000"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}