| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| ClassificationID | query | string | No | |
| ClassificationIDStartsWith | query | string | No | |
| ClassificationIDEndsWith | query | string | No | |
| ClassificationIDContains | query | string | No | |
| ClassificationIDLike | query | string | No | |
| ClassificationIDBetween | query | string[] | No | |
| ClassificationIDIn | 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 | |
| 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 | |
| WIPExpectedAsset | query | string | No | |
| WIPExpectedAssetStartsWith | query | string | No | |
| WIPExpectedAssetEndsWith | query | string | No | |
| WIPExpectedAssetContains | query | string | No | |
| WIPExpectedAssetLike | query | string | No | |
| WIPExpectedAssetBetween | query | string[] | No | |
| WIPExpectedAssetIn | query | string[] | No | |
| WIPExpectedLiability | query | string | No | |
| WIPExpectedLiabilityStartsWith | query | string | No | |
| WIPExpectedLiabilityEndsWith | query | string | No | |
| WIPExpectedLiabilityContains | query | string | No | |
| WIPExpectedLiabilityLike | query | string | No | |
| WIPExpectedLiabilityBetween | query | string[] | No | |
| WIPExpectedLiabilityIn | query | string[] | No | |
| WIPDeliveredAsett | query | string | No | |
| WIPDeliveredAsettStartsWith | query | string | No | |
| WIPDeliveredAsettEndsWith | query | string | No | |
| WIPDeliveredAsettContains | query | string | No | |
| WIPDeliveredAsettLike | query | string | No | |
| WIPDeliveredAsettBetween | query | string[] | No | |
| WIPDeliveredAsettIn | query | string[] | No | |
| WIPDeliveredLiability | query | string | No | |
| WIPDeliveredLiabilityStartsWith | query | string | No | |
| WIPDeliveredLiabilityEndsWith | query | string | No | |
| WIPDeliveredLiabilityContains | query | string | No | |
| WIPDeliveredLiabilityLike | query | string | No | |
| WIPDeliveredLiabilityBetween | query | string[] | No | |
| WIPDeliveredLiabilityIn | query | string[] | No | |
| WorkInProgress | query | string | No | |
| WorkInProgressStartsWith | query | string | No | |
| WorkInProgressEndsWith | query | string | No | |
| WorkInProgressContains | query | string | No | |
| WorkInProgressLike | query | string | No | |
| WorkInProgressBetween | query | string[] | No | |
| WorkInProgressIn | query | string[] | No | |
| JobRevenue | query | string | No | |
| JobRevenueStartsWith | query | string | No | |
| JobRevenueEndsWith | query | string | No | |
| JobRevenueContains | query | string | No | |
| JobRevenueLike | query | string | No | |
| JobRevenueBetween | query | string[] | No | |
| JobRevenueIn | query | string[] | No | |
| JobCostOfGoods | query | string | No | |
| JobCostOfGoodsStartsWith | query | string | No | |
| JobCostOfGoodsEndsWith | query | string | No | |
| JobCostOfGoodsContains | query | string | No | |
| JobCostOfGoodsLike | query | string | No | |
| JobCostOfGoodsBetween | query | string[] | No | |
| JobCostOfGoodsIn | query | string[] | No | |
| Wages | query | string | No | |
| WagesStartsWith | query | string | No | |
| WagesEndsWith | query | string | No | |
| WagesContains | query | string | No | |
| WagesLike | query | string | No | |
| WagesBetween | query | string[] | No | |
| WagesIn | query | string[] | No | |
| Resources | query | string | No | |
| ResourcesStartsWith | query | string | No | |
| ResourcesEndsWith | query | string | No | |
| ResourcesContains | query | string | No | |
| ResourcesLike | query | string | No | |
| ResourcesBetween | query | string[] | No | |
| ResourcesIn | query | string[] | No | |
| WriteOn | query | string | No | |
| WriteOnStartsWith | query | string | No | |
| WriteOnEndsWith | query | string | No | |
| WriteOnContains | query | string | No | |
| WriteOnLike | query | string | No | |
| WriteOnBetween | query | string[] | No | |
| WriteOnIn | query | string[] | No | |
| WriteOff | query | string | No | |
| WriteOffStartsWith | query | string | No | |
| WriteOffEndsWith | query | string | No | |
| WriteOffContains | query | string | No | |
| WriteOffLike | query | string | No | |
| WriteOffBetween | query | string[] | No | |
| WriteOffIn | query | string[] | 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 | |
| RowHash | query | byte[] | 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 |
|---|---|---|---|---|
| ClassificationID | form | string | No | |
| Description | form | string | No | |
| LastSavedDateTime | form | DateTime | No | |
| WIPExpectedAsset | form | string | No | |
| WIPExpectedLiability | form | string | No | |
| WIPDeliveredAsett | form | string | No | |
| WIPDeliveredLiability | form | string | No | |
| WorkInProgress | form | string | No | |
| JobRevenue | form | string | No | |
| JobCostOfGoods | form | string | No | |
| Wages | form | string | No | |
| Resources | form | string | No | |
| WriteOn | form | string | No | |
| WriteOff | form | string | No | |
| ItemNo | form | int | No | |
| RowHash | form | byte[] | 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/JB_ClassificationQuery HTTP/1.1
Host: localhost
Accept: text/csv
Content-Type: text/csv
Content-Length: length
{"ClassificationID":"String","ClassificationIDStartsWith":"String","ClassificationIDEndsWith":"String","ClassificationIDContains":"String","ClassificationIDLike":"String","ClassificationIDBetween":["String"],"ClassificationIDIn":["String"],"Description":"String","DescriptionStartsWith":"String","DescriptionEndsWith":"String","DescriptionContains":"String","DescriptionLike":"String","DescriptionBetween":["String"],"DescriptionIn":["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"],"WIPExpectedAsset":"String","WIPExpectedAssetStartsWith":"String","WIPExpectedAssetEndsWith":"String","WIPExpectedAssetContains":"String","WIPExpectedAssetLike":"String","WIPExpectedAssetBetween":["String"],"WIPExpectedAssetIn":["String"],"WIPExpectedLiability":"String","WIPExpectedLiabilityStartsWith":"String","WIPExpectedLiabilityEndsWith":"String","WIPExpectedLiabilityContains":"String","WIPExpectedLiabilityLike":"String","WIPExpectedLiabilityBetween":["String"],"WIPExpectedLiabilityIn":["String"],"WIPDeliveredAsett":"String","WIPDeliveredAsettStartsWith":"String","WIPDeliveredAsettEndsWith":"String","WIPDeliveredAsettContains":"String","WIPDeliveredAsettLike":"String","WIPDeliveredAsettBetween":["String"],"WIPDeliveredAsettIn":["String"],"WIPDeliveredLiability":"String","WIPDeliveredLiabilityStartsWith":"String","WIPDeliveredLiabilityEndsWith":"String","WIPDeliveredLiabilityContains":"String","WIPDeliveredLiabilityLike":"String","WIPDeliveredLiabilityBetween":["String"],"WIPDeliveredLiabilityIn":["String"],"WorkInProgress":"String","WorkInProgressStartsWith":"String","WorkInProgressEndsWith":"String","WorkInProgressContains":"String","WorkInProgressLike":"String","WorkInProgressBetween":["String"],"WorkInProgressIn":["String"],"JobRevenue":"String","JobRevenueStartsWith":"String","JobRevenueEndsWith":"String","JobRevenueContains":"String","JobRevenueLike":"String","JobRevenueBetween":["String"],"JobRevenueIn":["String"],"JobCostOfGoods":"String","JobCostOfGoodsStartsWith":"String","JobCostOfGoodsEndsWith":"String","JobCostOfGoodsContains":"String","JobCostOfGoodsLike":"String","JobCostOfGoodsBetween":["String"],"JobCostOfGoodsIn":["String"],"Wages":"String","WagesStartsWith":"String","WagesEndsWith":"String","WagesContains":"String","WagesLike":"String","WagesBetween":["String"],"WagesIn":["String"],"Resources":"String","ResourcesStartsWith":"String","ResourcesEndsWith":"String","ResourcesContains":"String","ResourcesLike":"String","ResourcesBetween":["String"],"ResourcesIn":["String"],"WriteOn":"String","WriteOnStartsWith":"String","WriteOnEndsWith":"String","WriteOnContains":"String","WriteOnLike":"String","WriteOnBetween":["String"],"WriteOnIn":["String"],"WriteOff":"String","WriteOffStartsWith":"String","WriteOffEndsWith":"String","WriteOffContains":"String","WriteOffLike":"String","WriteOffBetween":["String"],"WriteOffIn":["String"],"ItemNo":0,"ItemNoGreaterThanOrEqualTo":0,"ItemNoGreaterThan":0,"ItemNoLessThan":0,"ItemNoLessThanOrEqualTo":0,"ItemNoNotEqualTo":0,"ItemNoBetween":[0],"ItemNoIn":[0],"RowHash":"AA==","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":[{"ClassificationID":"String","Description":"String","WIPExpectedAsset":"String","WIPExpectedLiability":"String","WIPDeliveredAsett":"String","WIPDeliveredLiability":"String","WorkInProgress":"String","JobRevenue":"String","JobCostOfGoods":"String","Wages":"String","Resources":"String","WriteOn":"String","WriteOff":"String","RowHash":"AA=="}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}