| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| INAssemblyID | query | string | No | |
| INAssemblyIDStartsWith | query | string | No | |
| INAssemblyIDEndsWith | query | string | No | |
| INAssemblyIDContains | query | string | No | |
| INAssemblyIDLike | query | string | No | |
| INAssemblyIDBetween | query | string[] | No | |
| INAssemblyIDIn | query | string[] | No | |
| LastSavedDateTime | query | DateTime? | No | |
| LastSavedDateTimeGreaterThanOrEqualTo | query | DateTime? | No | |
| LastSavedDateTimeGreaterThan | query | DateTime? | No | |
| LastSavedDateTimeLessThan | query | DateTime? | No | |
| LastSavedDateTimeLessThanOrEqualTo | query | DateTime? | No | |
| LastSavedDateTimeNotEqualTo | query | DateTime? | No | |
| LastSavedDateTimeBetween | query | DateTime[] | No | |
| LastSavedDateTimeIn | query | DateTime[] | 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 | |
| AssemblyNo | query | string | No | |
| AssemblyNoStartsWith | query | string | No | |
| AssemblyNoEndsWith | query | string | No | |
| AssemblyNoContains | query | string | No | |
| AssemblyNoLike | query | string | No | |
| AssemblyNoBetween | query | string[] | No | |
| AssemblyNoIn | query | string[] | No | |
| AssemblyInitDate | query | DateTime? | No | |
| AssemblyInitDateGreaterThanOrEqualTo | query | DateTime? | No | |
| AssemblyInitDateGreaterThan | query | DateTime? | No | |
| AssemblyInitDateLessThan | query | DateTime? | No | |
| AssemblyInitDateLessThanOrEqualTo | query | DateTime? | No | |
| AssemblyInitDateNotEqualTo | query | DateTime? | No | |
| AssemblyInitDateBetween | query | DateTime[] | No | |
| AssemblyInitDateIn | query | DateTime[] | No | |
| AssemblyLastDate | query | DateTime? | No | |
| AssemblyLastDateGreaterThanOrEqualTo | query | DateTime? | No | |
| AssemblyLastDateGreaterThan | query | DateTime? | No | |
| AssemblyLastDateLessThan | query | DateTime? | No | |
| AssemblyLastDateLessThanOrEqualTo | query | DateTime? | No | |
| AssemblyLastDateNotEqualTo | query | DateTime? | No | |
| AssemblyLastDateBetween | query | DateTime[] | No | |
| AssemblyLastDateIn | query | DateTime[] | No | |
| QtyRequired | query | decimal? | No | |
| QtyRequiredGreaterThanOrEqualTo | query | decimal? | No | |
| QtyRequiredGreaterThan | query | decimal? | No | |
| QtyRequiredLessThan | query | decimal? | No | |
| QtyRequiredLessThanOrEqualTo | query | decimal? | No | |
| QtyRequiredNotEqualTo | query | decimal? | No | |
| QtyRequiredBetween | query | decimal[] | No | |
| QtyRequiredIn | query | decimal[] | No | |
| AssemblyType | query | short? | No | |
| AssemblyTypeGreaterThanOrEqualTo | query | short? | No | |
| AssemblyTypeGreaterThan | query | short? | No | |
| AssemblyTypeLessThan | query | short? | No | |
| AssemblyTypeLessThanOrEqualTo | query | short? | No | |
| AssemblyTypeNotEqualTo | query | short? | No | |
| AssemblyTypeBetween | query | short[] | No | |
| AssemblyTypeIn | query | short[] | No | |
| Status | query | short? | No | |
| StatusGreaterThanOrEqualTo | query | short? | No | |
| StatusGreaterThan | query | short? | No | |
| StatusLessThan | query | short? | No | |
| StatusLessThanOrEqualTo | query | short? | No | |
| StatusNotEqualTo | query | short? | No | |
| StatusBetween | query | short[] | No | |
| StatusIn | query | short[] | No | |
| CurrentHistoryNo | query | short? | No | |
| CurrentHistoryNoGreaterThanOrEqualTo | query | short? | No | |
| CurrentHistoryNoGreaterThan | query | short? | No | |
| CurrentHistoryNoLessThan | query | short? | No | |
| CurrentHistoryNoLessThanOrEqualTo | query | short? | No | |
| CurrentHistoryNoNotEqualTo | query | short? | No | |
| CurrentHistoryNoBetween | query | short[] | No | |
| CurrentHistoryNoIn | query | short[] | 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 | |
| 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 | |
| AssemblyTotal | query | decimal? | No | |
| AssemblyTotalGreaterThanOrEqualTo | query | decimal? | No | |
| AssemblyTotalGreaterThan | query | decimal? | No | |
| AssemblyTotalLessThan | query | decimal? | No | |
| AssemblyTotalLessThanOrEqualTo | query | decimal? | No | |
| AssemblyTotalNotEqualTo | query | decimal? | No | |
| AssemblyTotalBetween | query | decimal[] | No | |
| AssemblyTotalIn | query | decimal[] | No | |
| UpdateSell | query | bool? | No | |
| SellPriceMode | query | short? | No | |
| SellPriceModeGreaterThanOrEqualTo | query | short? | No | |
| SellPriceModeGreaterThan | query | short? | No | |
| SellPriceModeLessThan | query | short? | No | |
| SellPriceModeLessThanOrEqualTo | query | short? | No | |
| SellPriceModeNotEqualTo | query | short? | No | |
| SellPriceModeBetween | query | short[] | No | |
| SellPriceModeIn | query | short[] | No | |
| SellPriceAmount | query | decimal? | No | |
| SellPriceAmountGreaterThanOrEqualTo | query | decimal? | No | |
| SellPriceAmountGreaterThan | query | decimal? | No | |
| SellPriceAmountLessThan | query | decimal? | No | |
| SellPriceAmountLessThanOrEqualTo | query | decimal? | No | |
| SellPriceAmountNotEqualTo | query | decimal? | No | |
| SellPriceAmountBetween | query | decimal[] | No | |
| SellPriceAmountIn | query | decimal[] | No | |
| NewPrice | query | decimal? | No | |
| NewPriceGreaterThanOrEqualTo | query | decimal? | No | |
| NewPriceGreaterThan | query | decimal? | No | |
| NewPriceLessThan | query | decimal? | No | |
| NewPriceLessThanOrEqualTo | query | decimal? | No | |
| NewPriceNotEqualTo | query | decimal? | No | |
| NewPriceBetween | query | decimal[] | No | |
| NewPriceIn | query | decimal[] | No | |
| CalcSell | query | decimal? | No | |
| CalcSellGreaterThanOrEqualTo | query | decimal? | No | |
| CalcSellGreaterThan | query | decimal? | No | |
| CalcSellLessThan | query | decimal? | No | |
| CalcSellLessThanOrEqualTo | query | decimal? | No | |
| CalcSellNotEqualTo | query | decimal? | No | |
| CalcSellBetween | query | decimal[] | No | |
| CalcSellIn | query | decimal[] | 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 |
|---|---|---|---|---|
| INAssemblyID | form | string | No | |
| LastSavedDateTime | form | DateTime | No | |
| InventoryID | form | string | No | |
| AssemblyNo | form | string | No | |
| AssemblyInitDate | form | DateTime | No | |
| AssemblyLastDate | form | DateTime | No | |
| QtyRequired | form | decimal | No | |
| AssemblyType | form | short | No | |
| Status | form | short | No | |
| CurrentHistoryNo | form | short | No | |
| IN_LogicalID | form | string | No | |
| PartNo | form | string | No | |
| Description | form | string | No | |
| AssemblyTotal | form | decimal | No | |
| UpdateSell | form | bool | No | |
| SellPriceMode | form | short | No | |
| SellPriceAmount | form | decimal | No | |
| NewPrice | form | decimal | No | |
| CalcSell | form | decimal | 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 .csv suffix or ?format=csv
The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.
POST /csv/reply/IN_AssemblyQuery HTTP/1.1
Host: api.jiwa.com.au
Accept: text/csv
Content-Type: text/csv
Content-Length: length
{"INAssemblyID":"String","INAssemblyIDStartsWith":"String","INAssemblyIDEndsWith":"String","INAssemblyIDContains":"String","INAssemblyIDLike":"String","INAssemblyIDBetween":["String"],"INAssemblyIDIn":["String"],"LastSavedDateTime":"0001-01-01T00:00:00.0000000","LastSavedDateTimeGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","LastSavedDateTimeGreaterThan":"0001-01-01T00:00:00.0000000","LastSavedDateTimeLessThan":"0001-01-01T00:00:00.0000000","LastSavedDateTimeLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","LastSavedDateTimeNotEqualTo":"0001-01-01T00:00:00.0000000","LastSavedDateTimeBetween":["0001-01-01T00:00:00.0000000"],"LastSavedDateTimeIn":["0001-01-01T00:00:00.0000000"],"InventoryID":"String","InventoryIDStartsWith":"String","InventoryIDEndsWith":"String","InventoryIDContains":"String","InventoryIDLike":"String","InventoryIDBetween":["String"],"InventoryIDIn":["String"],"AssemblyNo":"String","AssemblyNoStartsWith":"String","AssemblyNoEndsWith":"String","AssemblyNoContains":"String","AssemblyNoLike":"String","AssemblyNoBetween":["String"],"AssemblyNoIn":["String"],"AssemblyInitDate":"0001-01-01T00:00:00.0000000","AssemblyInitDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","AssemblyInitDateGreaterThan":"0001-01-01T00:00:00.0000000","AssemblyInitDateLessThan":"0001-01-01T00:00:00.0000000","AssemblyInitDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","AssemblyInitDateNotEqualTo":"0001-01-01T00:00:00.0000000","AssemblyInitDateBetween":["0001-01-01T00:00:00.0000000"],"AssemblyInitDateIn":["0001-01-01T00:00:00.0000000"],"AssemblyLastDate":"0001-01-01T00:00:00.0000000","AssemblyLastDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","AssemblyLastDateGreaterThan":"0001-01-01T00:00:00.0000000","AssemblyLastDateLessThan":"0001-01-01T00:00:00.0000000","AssemblyLastDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","AssemblyLastDateNotEqualTo":"0001-01-01T00:00:00.0000000","AssemblyLastDateBetween":["0001-01-01T00:00:00.0000000"],"AssemblyLastDateIn":["0001-01-01T00:00:00.0000000"],"QtyRequired":0,"QtyRequiredGreaterThanOrEqualTo":0,"QtyRequiredGreaterThan":0,"QtyRequiredLessThan":0,"QtyRequiredLessThanOrEqualTo":0,"QtyRequiredNotEqualTo":0,"QtyRequiredBetween":[0],"QtyRequiredIn":[0],"AssemblyType":0,"AssemblyTypeGreaterThanOrEqualTo":0,"AssemblyTypeGreaterThan":0,"AssemblyTypeLessThan":0,"AssemblyTypeLessThanOrEqualTo":0,"AssemblyTypeNotEqualTo":0,"AssemblyTypeBetween":[0],"AssemblyTypeIn":[0],"Status":0,"StatusGreaterThanOrEqualTo":0,"StatusGreaterThan":0,"StatusLessThan":0,"StatusLessThanOrEqualTo":0,"StatusNotEqualTo":0,"StatusBetween":[0],"StatusIn":[0],"CurrentHistoryNo":0,"CurrentHistoryNoGreaterThanOrEqualTo":0,"CurrentHistoryNoGreaterThan":0,"CurrentHistoryNoLessThan":0,"CurrentHistoryNoLessThanOrEqualTo":0,"CurrentHistoryNoNotEqualTo":0,"CurrentHistoryNoBetween":[0],"CurrentHistoryNoIn":[0],"IN_LogicalID":"String","IN_LogicalIDStartsWith":"String","IN_LogicalIDEndsWith":"String","IN_LogicalIDContains":"String","IN_LogicalIDLike":"String","IN_LogicalIDBetween":["String"],"IN_LogicalIDIn":["String"],"PartNo":"String","PartNoStartsWith":"String","PartNoEndsWith":"String","PartNoContains":"String","PartNoLike":"String","PartNoBetween":["String"],"PartNoIn":["String"],"Description":"String","DescriptionStartsWith":"String","DescriptionEndsWith":"String","DescriptionContains":"String","DescriptionLike":"String","DescriptionBetween":["String"],"DescriptionIn":["String"],"AssemblyTotal":0,"AssemblyTotalGreaterThanOrEqualTo":0,"AssemblyTotalGreaterThan":0,"AssemblyTotalLessThan":0,"AssemblyTotalLessThanOrEqualTo":0,"AssemblyTotalNotEqualTo":0,"AssemblyTotalBetween":[0],"AssemblyTotalIn":[0],"UpdateSell":false,"SellPriceMode":0,"SellPriceModeGreaterThanOrEqualTo":0,"SellPriceModeGreaterThan":0,"SellPriceModeLessThan":0,"SellPriceModeLessThanOrEqualTo":0,"SellPriceModeNotEqualTo":0,"SellPriceModeBetween":[0],"SellPriceModeIn":[0],"SellPriceAmount":0,"SellPriceAmountGreaterThanOrEqualTo":0,"SellPriceAmountGreaterThan":0,"SellPriceAmountLessThan":0,"SellPriceAmountLessThanOrEqualTo":0,"SellPriceAmountNotEqualTo":0,"SellPriceAmountBetween":[0],"SellPriceAmountIn":[0],"NewPrice":0,"NewPriceGreaterThanOrEqualTo":0,"NewPriceGreaterThan":0,"NewPriceLessThan":0,"NewPriceLessThanOrEqualTo":0,"NewPriceNotEqualTo":0,"NewPriceBetween":[0],"NewPriceIn":[0],"CalcSell":0,"CalcSellGreaterThanOrEqualTo":0,"CalcSellGreaterThan":0,"CalcSellLessThan":0,"CalcSellLessThanOrEqualTo":0,"CalcSellNotEqualTo":0,"CalcSellBetween":[0],"CalcSellIn":[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":[{"INAssemblyID":"String","InventoryID":"String","AssemblyNo":"String","IN_LogicalID":"String","PartNo":"String","Description":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}