| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| RecID | query | string | No | |
| RecIDStartsWith | query | string | No | |
| RecIDEndsWith | query | string | No | |
| RecIDContains | query | string | No | |
| RecIDLike | query | string | No | |
| RecIDBetween | query | string[] | No | |
| RecIDIn | query | string[] | No | |
| IN_Creditor_RecID | query | string | No | |
| IN_Creditor_RecIDStartsWith | query | string | No | |
| IN_Creditor_RecIDEndsWith | query | string | No | |
| IN_Creditor_RecIDContains | query | string | No | |
| IN_Creditor_RecIDLike | query | string | No | |
| IN_Creditor_RecIDBetween | query | string[] | No | |
| IN_Creditor_RecIDIn | 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 | |
| WarehouseID | query | string | No | |
| WarehouseIDStartsWith | query | string | No | |
| WarehouseIDEndsWith | query | string | No | |
| WarehouseIDContains | query | string | No | |
| WarehouseIDLike | query | string | No | |
| WarehouseIDBetween | query | string[] | No | |
| WarehouseIDIn | query | string[] | No | |
| FreightInID | query | string | No | |
| FreightInIDStartsWith | query | string | No | |
| FreightInIDEndsWith | query | string | No | |
| FreightInIDContains | query | string | No | |
| FreightInIDLike | query | string | No | |
| FreightInIDBetween | query | string[] | No | |
| FreightInIDIn | query | string[] | No | |
| OrderUnits | query | decimal? | No | |
| OrderUnitsGreaterThanOrEqualTo | query | decimal? | No | |
| OrderUnitsGreaterThan | query | decimal? | No | |
| OrderUnitsLessThan | query | decimal? | No | |
| OrderUnitsLessThanOrEqualTo | query | decimal? | No | |
| OrderUnitsNotEqualTo | query | decimal? | No | |
| OrderUnitsBetween | query | Nullable<Decimal>[] | No | |
| OrderUnitsIn | query | Nullable<Decimal>[] | No | |
| DeliveryDays | query | short? | No | |
| DeliveryDaysGreaterThanOrEqualTo | query | short? | No | |
| DeliveryDaysGreaterThan | query | short? | No | |
| DeliveryDaysLessThan | query | short? | No | |
| DeliveryDaysLessThanOrEqualTo | query | short? | No | |
| DeliveryDaysNotEqualTo | query | short? | No | |
| DeliveryDaysBetween | query | Nullable<Int16>[] | No | |
| DeliveryDaysIn | query | Nullable<Int16>[] | No | |
| SuppliersCost | query | decimal? | No | |
| SuppliersCostGreaterThanOrEqualTo | query | decimal? | No | |
| SuppliersCostGreaterThan | query | decimal? | No | |
| SuppliersCostLessThan | query | decimal? | No | |
| SuppliersCostLessThanOrEqualTo | query | decimal? | No | |
| SuppliersCostNotEqualTo | query | decimal? | No | |
| SuppliersCostBetween | query | Nullable<Decimal>[] | No | |
| SuppliersCostIn | query | Nullable<Decimal>[] | No | |
| HomeSuppliersCost | query | decimal? | No | |
| HomeSuppliersCostGreaterThanOrEqualTo | query | decimal? | No | |
| HomeSuppliersCostGreaterThan | query | decimal? | No | |
| HomeSuppliersCostLessThan | query | decimal? | No | |
| HomeSuppliersCostLessThanOrEqualTo | query | decimal? | No | |
| HomeSuppliersCostNotEqualTo | query | decimal? | No | |
| HomeSuppliersCostBetween | query | Nullable<Decimal>[] | No | |
| HomeSuppliersCostIn | query | Nullable<Decimal>[] | No | |
| DutyID | query | string | No | |
| DutyIDStartsWith | query | string | No | |
| DutyIDEndsWith | query | string | No | |
| DutyIDContains | query | string | No | |
| DutyIDLike | query | string | No | |
| DutyIDBetween | query | string[] | No | |
| DutyIDIn | query | string[] | No | |
| SupplierSOH | query | decimal? | No | |
| SupplierSOHGreaterThanOrEqualTo | query | decimal? | No | |
| SupplierSOHGreaterThan | query | decimal? | No | |
| SupplierSOHLessThan | query | decimal? | No | |
| SupplierSOHLessThanOrEqualTo | query | decimal? | No | |
| SupplierSOHNotEqualTo | query | decimal? | No | |
| SupplierSOHBetween | query | Nullable<Decimal>[] | No | |
| SupplierSOHIn | query | Nullable<Decimal>[] | No | |
| SuppliersCost2 | query | decimal? | No | |
| SuppliersCost2GreaterThanOrEqualTo | query | decimal? | No | |
| SuppliersCost2GreaterThan | query | decimal? | No | |
| SuppliersCost2LessThan | query | decimal? | No | |
| SuppliersCost2LessThanOrEqualTo | query | decimal? | No | |
| SuppliersCost2NotEqualTo | query | decimal? | No | |
| SuppliersCost2Between | query | Nullable<Decimal>[] | No | |
| SuppliersCost2In | query | Nullable<Decimal>[] | No | |
| HomeSuppliersCost2 | query | decimal? | No | |
| HomeSuppliersCost2GreaterThanOrEqualTo | query | decimal? | No | |
| HomeSuppliersCost2GreaterThan | query | decimal? | No | |
| HomeSuppliersCost2LessThan | query | decimal? | No | |
| HomeSuppliersCost2LessThanOrEqualTo | query | decimal? | No | |
| HomeSuppliersCost2NotEqualTo | query | decimal? | No | |
| HomeSuppliersCost2Between | query | Nullable<Decimal>[] | No | |
| HomeSuppliersCost2In | query | Nullable<Decimal>[] | No | |
| SpareFloat1 | query | decimal? | No | |
| SpareFloat1GreaterThanOrEqualTo | query | decimal? | No | |
| SpareFloat1GreaterThan | query | decimal? | No | |
| SpareFloat1LessThan | query | decimal? | No | |
| SpareFloat1LessThanOrEqualTo | query | decimal? | No | |
| SpareFloat1NotEqualTo | query | decimal? | No | |
| SpareFloat1Between | query | Nullable<Decimal>[] | No | |
| SpareFloat1In | query | Nullable<Decimal>[] | No | |
| SpareFloat2 | query | decimal? | No | |
| SpareFloat2GreaterThanOrEqualTo | query | decimal? | No | |
| SpareFloat2GreaterThan | query | decimal? | No | |
| SpareFloat2LessThan | query | decimal? | No | |
| SpareFloat2LessThanOrEqualTo | query | decimal? | No | |
| SpareFloat2NotEqualTo | query | decimal? | No | |
| SpareFloat2Between | query | Nullable<Decimal>[] | No | |
| SpareFloat2In | query | Nullable<Decimal>[] | No | |
| SpareFloat3 | query | decimal? | No | |
| SpareFloat3GreaterThanOrEqualTo | query | decimal? | No | |
| SpareFloat3GreaterThan | query | decimal? | No | |
| SpareFloat3LessThan | query | decimal? | No | |
| SpareFloat3LessThanOrEqualTo | query | decimal? | No | |
| SpareFloat3NotEqualTo | query | decimal? | No | |
| SpareFloat3Between | query | Nullable<Decimal>[] | No | |
| SpareFloat3In | query | Nullable<Decimal>[] | No | |
| SpareString1 | query | string | No | |
| SpareString1StartsWith | query | string | No | |
| SpareString1EndsWith | query | string | No | |
| SpareString1Contains | query | string | No | |
| SpareString1Like | query | string | No | |
| SpareString1Between | query | string[] | No | |
| SpareString1In | query | string[] | No | |
| SpareString2 | query | string | No | |
| SpareString2StartsWith | query | string | No | |
| SpareString2EndsWith | query | string | No | |
| SpareString2Contains | query | string | No | |
| SpareString2Like | query | string | No | |
| SpareString2Between | query | string[] | No | |
| SpareString2In | query | string[] | No | |
| SpareString3 | query | string | No | |
| SpareString3StartsWith | query | string | No | |
| SpareString3EndsWith | query | string | No | |
| SpareString3Contains | query | string | No | |
| SpareString3Like | query | string | No | |
| SpareString3Between | query | string[] | No | |
| SpareString3In | query | string[] | No | |
| SpareDate1 | query | DateTime? | No | |
| SpareDate1GreaterThanOrEqualTo | query | DateTime? | No | |
| SpareDate1GreaterThan | query | DateTime? | No | |
| SpareDate1LessThan | query | DateTime? | No | |
| SpareDate1LessThanOrEqualTo | query | DateTime? | No | |
| SpareDate1NotEqualTo | query | DateTime? | No | |
| SpareDate1Between | query | Nullable<DateTime>[] | No | |
| SpareDate1In | query | Nullable<DateTime>[] | No | |
| SpareDate2 | query | DateTime? | No | |
| SpareDate2GreaterThanOrEqualTo | query | DateTime? | No | |
| SpareDate2GreaterThan | query | DateTime? | No | |
| SpareDate2LessThan | query | DateTime? | No | |
| SpareDate2LessThanOrEqualTo | query | DateTime? | No | |
| SpareDate2NotEqualTo | query | DateTime? | No | |
| SpareDate2Between | query | Nullable<DateTime>[] | No | |
| SpareDate2In | query | Nullable<DateTime>[] | No | |
| SpareDate3 | query | DateTime? | No | |
| SpareDate3GreaterThanOrEqualTo | query | DateTime? | No | |
| SpareDate3GreaterThan | query | DateTime? | No | |
| SpareDate3LessThan | query | DateTime? | No | |
| SpareDate3LessThanOrEqualTo | query | DateTime? | No | |
| SpareDate3NotEqualTo | query | DateTime? | No | |
| SpareDate3Between | query | Nullable<DateTime>[] | No | |
| SpareDate3In | query | Nullable<DateTime>[] | No | |
| DefaultSupplierWarehouse | query | bool? | No | |
| ItemNo | query | int? | No | |
| ItemNoGreaterThanOrEqualTo | query | int? | No | |
| ItemNoGreaterThan | query | int? | No | |
| ItemNoLessThan | query | int? | No | |
| ItemNoLessThanOrEqualTo | query | int? | No | |
| ItemNoNotEqualTo | query | int? | No | |
| ItemNoBetween | query | int[] | No | |
| ItemNoIn | query | int[] | No | |
| IN_UnitOfMeasure_RecID | query | Guid? | No | |
| IN_UnitOfMeasure_RecIDIn | query | Nullable<Guid>[] | No |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| 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 |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| RecID | form | string | No | |
| IN_Creditor_RecID | form | string | No | |
| InventoryID | form | string | No | |
| WarehouseID | form | string | No | |
| FreightInID | form | string | No | |
| OrderUnits | form | decimal? | No | |
| DeliveryDays | form | short? | No | |
| SuppliersCost | form | decimal? | No | |
| HomeSuppliersCost | form | decimal? | No | |
| DutyID | form | string | No | |
| SupplierSOH | form | decimal? | No | |
| SuppliersCost2 | form | decimal? | No | |
| HomeSuppliersCost2 | form | decimal? | No | |
| SpareFloat1 | form | decimal? | No | |
| SpareFloat2 | form | decimal? | No | |
| SpareFloat3 | form | decimal? | No | |
| SpareString1 | form | string | No | |
| SpareString2 | form | string | No | |
| SpareString3 | form | string | No | |
| SpareDate1 | form | DateTime? | No | |
| SpareDate2 | form | DateTime? | No | |
| SpareDate3 | form | DateTime? | No | |
| DefaultSupplierWarehouse | form | bool? | No | |
| ItemNo | form | int | No | |
| IN_UnitOfMeasure_RecID | form | Guid? | No |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| 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
The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.
POST /json/reply/IN_SupplierWarehouseQuery HTTP/1.1
Host: localhost
Accept: application/json
Content-Type: application/json
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: application/json
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"}}}