| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| INAssemblyLineID | query | string | No | |
| INAssemblyLineIDStartsWith | query | string | No | |
| INAssemblyLineIDEndsWith | query | string | No | |
| INAssemblyLineIDContains | query | string | No | |
| INAssemblyLineIDLike | query | string | No | |
| INAssemblyLineIDBetween | query | string[] | No | |
| INAssemblyLineIDIn | query | string[] | No | |
| INAssemblyHistoryID | query | string | No | |
| INAssemblyHistoryIDStartsWith | query | string | No | |
| INAssemblyHistoryIDEndsWith | query | string | No | |
| INAssemblyHistoryIDContains | query | string | No | |
| INAssemblyHistoryIDLike | query | string | No | |
| INAssemblyHistoryIDBetween | query | string[] | No | |
| INAssemblyHistoryIDIn | query | string[] | No | |
| LineNum | query | short? | No | |
| LineNumGreaterThanOrEqualTo | query | short? | No | |
| LineNumGreaterThan | query | short? | No | |
| LineNumLessThan | query | short? | No | |
| LineNumLessThanOrEqualTo | query | short? | No | |
| LineNumNotEqualTo | query | short? | No | |
| LineNumBetween | query | Nullable<Int16>[] | No | |
| LineNumIn | query | Nullable<Int16>[] | No | |
| ComponentID | query | string | No | |
| ComponentIDStartsWith | query | string | No | |
| ComponentIDEndsWith | query | string | No | |
| ComponentIDContains | query | string | No | |
| ComponentIDLike | query | string | No | |
| ComponentIDBetween | query | string[] | No | |
| ComponentIDIn | 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 | |
| DecimalPlaces | query | short? | No | |
| DecimalPlacesGreaterThanOrEqualTo | query | short? | No | |
| DecimalPlacesGreaterThan | query | short? | No | |
| DecimalPlacesLessThan | query | short? | No | |
| DecimalPlacesLessThanOrEqualTo | query | short? | No | |
| DecimalPlacesNotEqualTo | query | short? | No | |
| DecimalPlacesBetween | query | short[] | No | |
| DecimalPlacesIn | query | short[] | No | |
| CostPrice | query | decimal? | No | |
| CostPriceGreaterThanOrEqualTo | query | decimal? | No | |
| CostPriceGreaterThan | query | decimal? | No | |
| CostPriceLessThan | query | decimal? | No | |
| CostPriceLessThanOrEqualTo | query | decimal? | No | |
| CostPriceNotEqualTo | query | decimal? | No | |
| CostPriceBetween | query | decimal[] | No | |
| CostPriceIn | query | decimal[] | No | |
| QtyNeeded | query | decimal? | No | |
| QtyNeededGreaterThanOrEqualTo | query | decimal? | No | |
| QtyNeededGreaterThan | query | decimal? | No | |
| QtyNeededLessThan | query | decimal? | No | |
| QtyNeededLessThanOrEqualTo | query | decimal? | No | |
| QtyNeededNotEqualTo | query | decimal? | No | |
| QtyNeededBetween | query | decimal[] | No | |
| QtyNeededIn | query | decimal[] | 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 | |
| QtyAvailable | query | decimal? | No | |
| QtyAvailableGreaterThanOrEqualTo | query | decimal? | No | |
| QtyAvailableGreaterThan | query | decimal? | No | |
| QtyAvailableLessThan | query | decimal? | No | |
| QtyAvailableLessThanOrEqualTo | query | decimal? | No | |
| QtyAvailableNotEqualTo | query | decimal? | No | |
| QtyAvailableBetween | query | decimal[] | No | |
| QtyAvailableIn | query | decimal[] | No | |
| QtyOutstanding | query | decimal? | No | |
| QtyOutstandingGreaterThanOrEqualTo | query | decimal? | No | |
| QtyOutstandingGreaterThan | query | decimal? | No | |
| QtyOutstandingLessThan | query | decimal? | No | |
| QtyOutstandingLessThanOrEqualTo | query | decimal? | No | |
| QtyOutstandingNotEqualTo | query | decimal? | No | |
| QtyOutstandingBetween | query | decimal[] | No | |
| QtyOutstandingIn | query | decimal[] | No | |
| ThisAssemble | query | decimal? | No | |
| ThisAssembleGreaterThanOrEqualTo | query | decimal? | No | |
| ThisAssembleGreaterThan | query | decimal? | No | |
| ThisAssembleLessThan | query | decimal? | No | |
| ThisAssembleLessThanOrEqualTo | query | decimal? | No | |
| ThisAssembleNotEqualTo | query | decimal? | No | |
| ThisAssembleBetween | query | decimal[] | No | |
| ThisAssembleIn | query | decimal[] | No | |
| PrevAssemble | query | decimal? | No | |
| PrevAssembleGreaterThanOrEqualTo | query | decimal? | No | |
| PrevAssembleGreaterThan | query | decimal? | No | |
| PrevAssembleLessThan | query | decimal? | No | |
| PrevAssembleLessThanOrEqualTo | query | decimal? | No | |
| PrevAssembleNotEqualTo | query | decimal? | No | |
| PrevAssembleBetween | query | decimal[] | No | |
| PrevAssembleIn | 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 |
|---|---|---|---|---|
| INAssemblyLineID | form | string | No | |
| INAssemblyHistoryID | form | string | No | |
| LineNum | form | short? | No | |
| ComponentID | form | string | No | |
| PartNo | form | string | No | |
| Description | form | string | No | |
| DecimalPlaces | form | short | No | |
| CostPrice | form | decimal | No | |
| QtyNeeded | form | decimal | No | |
| QtyRequired | form | decimal | No | |
| QtyAvailable | form | decimal | No | |
| QtyOutstanding | form | decimal | No | |
| ThisAssemble | form | decimal | No | |
| PrevAssemble | 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_AssemblyLinesQuery HTTP/1.1
Host: localhost
Accept: text/csv
Content-Type: text/csv
Content-Length: length
{"INAssemblyLineID":"String","INAssemblyLineIDStartsWith":"String","INAssemblyLineIDEndsWith":"String","INAssemblyLineIDContains":"String","INAssemblyLineIDLike":"String","INAssemblyLineIDBetween":["String"],"INAssemblyLineIDIn":["String"],"INAssemblyHistoryID":"String","INAssemblyHistoryIDStartsWith":"String","INAssemblyHistoryIDEndsWith":"String","INAssemblyHistoryIDContains":"String","INAssemblyHistoryIDLike":"String","INAssemblyHistoryIDBetween":["String"],"INAssemblyHistoryIDIn":["String"],"LineNum":0,"LineNumGreaterThanOrEqualTo":0,"LineNumGreaterThan":0,"LineNumLessThan":0,"LineNumLessThanOrEqualTo":0,"LineNumNotEqualTo":0,"LineNumBetween":[0],"LineNumIn":[0],"ComponentID":"String","ComponentIDStartsWith":"String","ComponentIDEndsWith":"String","ComponentIDContains":"String","ComponentIDLike":"String","ComponentIDBetween":["String"],"ComponentIDIn":["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"],"DecimalPlaces":0,"DecimalPlacesGreaterThanOrEqualTo":0,"DecimalPlacesGreaterThan":0,"DecimalPlacesLessThan":0,"DecimalPlacesLessThanOrEqualTo":0,"DecimalPlacesNotEqualTo":0,"DecimalPlacesBetween":[0],"DecimalPlacesIn":[0],"CostPrice":0,"CostPriceGreaterThanOrEqualTo":0,"CostPriceGreaterThan":0,"CostPriceLessThan":0,"CostPriceLessThanOrEqualTo":0,"CostPriceNotEqualTo":0,"CostPriceBetween":[0],"CostPriceIn":[0],"QtyNeeded":0,"QtyNeededGreaterThanOrEqualTo":0,"QtyNeededGreaterThan":0,"QtyNeededLessThan":0,"QtyNeededLessThanOrEqualTo":0,"QtyNeededNotEqualTo":0,"QtyNeededBetween":[0],"QtyNeededIn":[0],"QtyRequired":0,"QtyRequiredGreaterThanOrEqualTo":0,"QtyRequiredGreaterThan":0,"QtyRequiredLessThan":0,"QtyRequiredLessThanOrEqualTo":0,"QtyRequiredNotEqualTo":0,"QtyRequiredBetween":[0],"QtyRequiredIn":[0],"QtyAvailable":0,"QtyAvailableGreaterThanOrEqualTo":0,"QtyAvailableGreaterThan":0,"QtyAvailableLessThan":0,"QtyAvailableLessThanOrEqualTo":0,"QtyAvailableNotEqualTo":0,"QtyAvailableBetween":[0],"QtyAvailableIn":[0],"QtyOutstanding":0,"QtyOutstandingGreaterThanOrEqualTo":0,"QtyOutstandingGreaterThan":0,"QtyOutstandingLessThan":0,"QtyOutstandingLessThanOrEqualTo":0,"QtyOutstandingNotEqualTo":0,"QtyOutstandingBetween":[0],"QtyOutstandingIn":[0],"ThisAssemble":0,"ThisAssembleGreaterThanOrEqualTo":0,"ThisAssembleGreaterThan":0,"ThisAssembleLessThan":0,"ThisAssembleLessThanOrEqualTo":0,"ThisAssembleNotEqualTo":0,"ThisAssembleBetween":[0],"ThisAssembleIn":[0],"PrevAssemble":0,"PrevAssembleGreaterThanOrEqualTo":0,"PrevAssembleGreaterThan":0,"PrevAssembleLessThan":0,"PrevAssembleLessThanOrEqualTo":0,"PrevAssembleNotEqualTo":0,"PrevAssembleBetween":[0],"PrevAssembleIn":[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":[{"INAssemblyLineID":"String","INAssemblyHistoryID":"String","LineNum":0,"ComponentID":"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"}}}