| 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 | |
| SM_Tasks_RecID | query | string | No | |
| SM_Tasks_RecIDStartsWith | query | string | No | |
| SM_Tasks_RecIDEndsWith | query | string | No | |
| SM_Tasks_RecIDContains | query | string | No | |
| SM_Tasks_RecIDLike | query | string | No | |
| SM_Tasks_RecIDBetween | query | string[] | No | |
| SM_Tasks_RecIDIn | query | string[] | No | |
| IN_Main_RecID | query | string | No | |
| IN_Main_RecIDStartsWith | query | string | No | |
| IN_Main_RecIDEndsWith | query | string | No | |
| IN_Main_RecIDContains | query | string | No | |
| IN_Main_RecIDLike | query | string | No | |
| IN_Main_RecIDBetween | query | string[] | No | |
| IN_Main_RecIDIn | 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 | |
| Quantity | query | decimal? | No | |
| QuantityGreaterThanOrEqualTo | query | decimal? | No | |
| QuantityGreaterThan | query | decimal? | No | |
| QuantityLessThan | query | decimal? | No | |
| QuantityLessThanOrEqualTo | query | decimal? | No | |
| QuantityNotEqualTo | query | decimal? | No | |
| QuantityBetween | query | Nullable<Decimal>[] | No | |
| QuantityIn | query | Nullable<Decimal>[] | No | |
| ItemPrice | query | decimal? | No | |
| ItemPriceGreaterThanOrEqualTo | query | decimal? | No | |
| ItemPriceGreaterThan | query | decimal? | No | |
| ItemPriceLessThan | query | decimal? | No | |
| ItemPriceLessThanOrEqualTo | query | decimal? | No | |
| ItemPriceNotEqualTo | query | decimal? | No | |
| ItemPriceBetween | query | Nullable<Decimal>[] | No | |
| ItemPriceIn | query | Nullable<Decimal>[] | No | |
| Tax | query | decimal? | No | |
| TaxGreaterThanOrEqualTo | query | decimal? | No | |
| TaxGreaterThan | query | decimal? | No | |
| TaxLessThan | query | decimal? | No | |
| TaxLessThanOrEqualTo | query | decimal? | No | |
| TaxNotEqualTo | query | decimal? | No | |
| TaxBetween | query | Nullable<Decimal>[] | No | |
| TaxIn | query | Nullable<Decimal>[] | 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 | |
| LastSavedStaffID | query | string | No | |
| LastSavedStaffIDStartsWith | query | string | No | |
| LastSavedStaffIDEndsWith | query | string | No | |
| LastSavedStaffIDContains | query | string | No | |
| LastSavedStaffIDLike | query | string | No | |
| LastSavedStaffIDBetween | query | string[] | No | |
| LastSavedStaffIDIn | query | string[] | No | |
| QOReference | query | string | No | |
| QOReferenceStartsWith | query | string | No | |
| QOReferenceEndsWith | query | string | No | |
| QOReferenceContains | query | string | No | |
| QOReferenceLike | query | string | No | |
| QOReferenceBetween | query | string[] | No | |
| QOReferenceIn | 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 | |
| Discount | query | decimal? | No | |
| DiscountGreaterThanOrEqualTo | query | decimal? | No | |
| DiscountGreaterThan | query | decimal? | No | |
| DiscountLessThan | query | decimal? | No | |
| DiscountLessThanOrEqualTo | query | decimal? | No | |
| DiscountNotEqualTo | query | decimal? | No | |
| DiscountBetween | query | Nullable<Decimal>[] | No | |
| DiscountIn | query | Nullable<Decimal>[] | No | |
| DiscountPercentage | query | decimal? | No | |
| DiscountPercentageGreaterThanOrEqualTo | query | decimal? | No | |
| DiscountPercentageGreaterThan | query | decimal? | No | |
| DiscountPercentageLessThan | query | decimal? | No | |
| DiscountPercentageLessThanOrEqualTo | query | decimal? | No | |
| DiscountPercentageNotEqualTo | query | decimal? | No | |
| DiscountPercentageBetween | query | Nullable<Decimal>[] | No | |
| DiscountPercentageIn | query | Nullable<Decimal>[] | No | |
| SellPriceIsIncTax | query | bool? | No | |
| QuantityDecimalPlaces | query | short? | No | |
| QuantityDecimalPlacesGreaterThanOrEqualTo | query | short? | No | |
| QuantityDecimalPlacesGreaterThan | query | short? | No | |
| QuantityDecimalPlacesLessThan | query | short? | No | |
| QuantityDecimalPlacesLessThanOrEqualTo | query | short? | No | |
| QuantityDecimalPlacesNotEqualTo | query | short? | No | |
| QuantityDecimalPlacesBetween | query | Nullable<Int16>[] | No | |
| QuantityDecimalPlacesIn | query | Nullable<Int16>[] | No | |
| Discountable | query | bool? | No | |
| DefaultPrice | query | decimal? | No | |
| DefaultPriceGreaterThanOrEqualTo | query | decimal? | No | |
| DefaultPriceGreaterThan | query | decimal? | No | |
| DefaultPriceLessThan | query | decimal? | No | |
| DefaultPriceLessThanOrEqualTo | query | decimal? | No | |
| DefaultPriceNotEqualTo | query | decimal? | No | |
| DefaultPriceBetween | query | Nullable<Decimal>[] | No | |
| DefaultPriceIn | query | Nullable<Decimal>[] | No | |
| MinimumGP | query | decimal? | No | |
| MinimumGPGreaterThanOrEqualTo | query | decimal? | No | |
| MinimumGPGreaterThan | query | decimal? | No | |
| MinimumGPLessThan | query | decimal? | No | |
| MinimumGPLessThanOrEqualTo | query | decimal? | No | |
| MinimumGPNotEqualTo | query | decimal? | No | |
| MinimumGPBetween | query | Nullable<Decimal>[] | No | |
| MinimumGPIn | query | Nullable<Decimal>[] | No | |
| LastCost | query | decimal? | No | |
| LastCostGreaterThanOrEqualTo | query | decimal? | No | |
| LastCostGreaterThan | query | decimal? | No | |
| LastCostLessThan | query | decimal? | No | |
| LastCostLessThanOrEqualTo | query | decimal? | No | |
| LastCostNotEqualTo | query | decimal? | No | |
| LastCostBetween | query | Nullable<Decimal>[] | No | |
| LastCostIn | query | Nullable<Decimal>[] | No | |
| TaxID | query | string | No | |
| TaxIDStartsWith | query | string | No | |
| TaxIDEndsWith | query | string | No | |
| TaxIDContains | query | string | No | |
| TaxIDLike | query | string | No | |
| TaxIDBetween | query | string[] | No | |
| TaxIDIn | query | string[] | No | |
| TaxRate | query | decimal? | No | |
| TaxRateGreaterThanOrEqualTo | query | decimal? | No | |
| TaxRateGreaterThan | query | decimal? | No | |
| TaxRateLessThan | query | decimal? | No | |
| TaxRateLessThanOrEqualTo | query | decimal? | No | |
| TaxRateNotEqualTo | query | decimal? | No | |
| TaxRateBetween | query | Nullable<Decimal>[] | No | |
| TaxRateIn | query | Nullable<Decimal>[] | No | |
| UserDefinedBit1 | query | bool? | No | |
| UserDefinedBit2 | query | bool? | No | |
| UserDefinedBit3 | query | bool? | No | |
| UserDefinedString1 | query | string | No | |
| UserDefinedString1StartsWith | query | string | No | |
| UserDefinedString1EndsWith | query | string | No | |
| UserDefinedString1Contains | query | string | No | |
| UserDefinedString1Like | query | string | No | |
| UserDefinedString1Between | query | string[] | No | |
| UserDefinedString1In | query | string[] | No | |
| UserDefinedString2 | query | string | No | |
| UserDefinedString2StartsWith | query | string | No | |
| UserDefinedString2EndsWith | query | string | No | |
| UserDefinedString2Contains | query | string | No | |
| UserDefinedString2Like | query | string | No | |
| UserDefinedString2Between | query | string[] | No | |
| UserDefinedString2In | query | string[] | No | |
| UserDefinedString3 | query | string | No | |
| UserDefinedString3StartsWith | query | string | No | |
| UserDefinedString3EndsWith | query | string | No | |
| UserDefinedString3Contains | query | string | No | |
| UserDefinedString3Like | query | string | No | |
| UserDefinedString3Between | query | string[] | No | |
| UserDefinedString3In | query | string[] | No | |
| UserDefinedDate1 | query | DateTime? | No | |
| UserDefinedDate1GreaterThanOrEqualTo | query | DateTime? | No | |
| UserDefinedDate1GreaterThan | query | DateTime? | No | |
| UserDefinedDate1LessThan | query | DateTime? | No | |
| UserDefinedDate1LessThanOrEqualTo | query | DateTime? | No | |
| UserDefinedDate1NotEqualTo | query | DateTime? | No | |
| UserDefinedDate1Between | query | Nullable<DateTime>[] | No | |
| UserDefinedDate1In | query | Nullable<DateTime>[] | No | |
| UserDefinedDate2 | query | DateTime? | No | |
| UserDefinedDate2GreaterThanOrEqualTo | query | DateTime? | No | |
| UserDefinedDate2GreaterThan | query | DateTime? | No | |
| UserDefinedDate2LessThan | query | DateTime? | No | |
| UserDefinedDate2LessThanOrEqualTo | query | DateTime? | No | |
| UserDefinedDate2NotEqualTo | query | DateTime? | No | |
| UserDefinedDate2Between | query | Nullable<DateTime>[] | No | |
| UserDefinedDate2In | query | Nullable<DateTime>[] | No | |
| UserDefinedDate3 | query | DateTime? | No | |
| UserDefinedDate3GreaterThanOrEqualTo | query | DateTime? | No | |
| UserDefinedDate3GreaterThan | query | DateTime? | No | |
| UserDefinedDate3LessThan | query | DateTime? | No | |
| UserDefinedDate3LessThanOrEqualTo | query | DateTime? | No | |
| UserDefinedDate3NotEqualTo | query | DateTime? | No | |
| UserDefinedDate3Between | query | Nullable<DateTime>[] | No | |
| UserDefinedDate3In | query | Nullable<DateTime>[] | No | |
| UserDefinedFloat1 | query | decimal? | No | |
| UserDefinedFloat1GreaterThanOrEqualTo | query | decimal? | No | |
| UserDefinedFloat1GreaterThan | query | decimal? | No | |
| UserDefinedFloat1LessThan | query | decimal? | No | |
| UserDefinedFloat1LessThanOrEqualTo | query | decimal? | No | |
| UserDefinedFloat1NotEqualTo | query | decimal? | No | |
| UserDefinedFloat1Between | query | Nullable<Decimal>[] | No | |
| UserDefinedFloat1In | query | Nullable<Decimal>[] | No | |
| UserDefinedFloat2 | query | decimal? | No | |
| UserDefinedFloat2GreaterThanOrEqualTo | query | decimal? | No | |
| UserDefinedFloat2GreaterThan | query | decimal? | No | |
| UserDefinedFloat2LessThan | query | decimal? | No | |
| UserDefinedFloat2LessThanOrEqualTo | query | decimal? | No | |
| UserDefinedFloat2NotEqualTo | query | decimal? | No | |
| UserDefinedFloat2Between | query | Nullable<Decimal>[] | No | |
| UserDefinedFloat2In | query | Nullable<Decimal>[] | No | |
| UserDefinedFloat3 | query | decimal? | No | |
| UserDefinedFloat3GreaterThanOrEqualTo | query | decimal? | No | |
| UserDefinedFloat3GreaterThan | query | decimal? | No | |
| UserDefinedFloat3LessThan | query | decimal? | No | |
| UserDefinedFloat3LessThanOrEqualTo | query | decimal? | No | |
| UserDefinedFloat3NotEqualTo | query | decimal? | No | |
| UserDefinedFloat3Between | query | Nullable<Decimal>[] | No | |
| UserDefinedFloat3In | query | Nullable<Decimal>[] | No | |
| SO_Lines_RecID | query | string | No | |
| SO_Lines_RecIDStartsWith | query | string | No | |
| SO_Lines_RecIDEndsWith | query | string | No | |
| SO_Lines_RecIDContains | query | string | No | |
| SO_Lines_RecIDLike | query | string | No | |
| SO_Lines_RecIDBetween | query | string[] | No | |
| SO_Lines_RecIDIn | query | string[] | 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 | |
| SM_Tasks_RecID | form | string | No | |
| IN_Main_RecID | form | string | No | |
| PartNo | form | string | No | |
| Description | form | string | No | |
| Quantity | form | decimal? | No | |
| ItemPrice | form | decimal? | No | |
| Tax | form | decimal? | No | |
| LastSavedDateTime | form | DateTime | No | |
| LastSavedStaffID | form | string | No | |
| QOReference | form | string | No | |
| ItemNo | form | int | No | |
| Discount | form | decimal? | No | |
| DiscountPercentage | form | decimal? | No | |
| SellPriceIsIncTax | form | bool? | No | |
| QuantityDecimalPlaces | form | short? | No | |
| Discountable | form | bool? | No | |
| DefaultPrice | form | decimal? | No | |
| MinimumGP | form | decimal? | No | |
| LastCost | form | decimal? | No | |
| TaxID | form | string | No | |
| TaxRate | form | decimal? | No | |
| UserDefinedBit1 | form | bool? | No | |
| UserDefinedBit2 | form | bool? | No | |
| UserDefinedBit3 | form | bool? | No | |
| UserDefinedString1 | form | string | No | |
| UserDefinedString2 | form | string | No | |
| UserDefinedString3 | form | string | No | |
| UserDefinedDate1 | form | DateTime? | No | |
| UserDefinedDate2 | form | DateTime? | No | |
| UserDefinedDate3 | form | DateTime? | No | |
| UserDefinedFloat1 | form | decimal? | No | |
| UserDefinedFloat2 | form | decimal? | No | |
| UserDefinedFloat3 | form | decimal? | No | |
| SO_Lines_RecID | form | string | 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/SM_PartsQuery 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"],"SM_Tasks_RecID":"String","SM_Tasks_RecIDStartsWith":"String","SM_Tasks_RecIDEndsWith":"String","SM_Tasks_RecIDContains":"String","SM_Tasks_RecIDLike":"String","SM_Tasks_RecIDBetween":["String"],"SM_Tasks_RecIDIn":["String"],"IN_Main_RecID":"String","IN_Main_RecIDStartsWith":"String","IN_Main_RecIDEndsWith":"String","IN_Main_RecIDContains":"String","IN_Main_RecIDLike":"String","IN_Main_RecIDBetween":["String"],"IN_Main_RecIDIn":["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"],"Quantity":0,"QuantityGreaterThanOrEqualTo":0,"QuantityGreaterThan":0,"QuantityLessThan":0,"QuantityLessThanOrEqualTo":0,"QuantityNotEqualTo":0,"QuantityBetween":[0],"QuantityIn":[0],"ItemPrice":0,"ItemPriceGreaterThanOrEqualTo":0,"ItemPriceGreaterThan":0,"ItemPriceLessThan":0,"ItemPriceLessThanOrEqualTo":0,"ItemPriceNotEqualTo":0,"ItemPriceBetween":[0],"ItemPriceIn":[0],"Tax":0,"TaxGreaterThanOrEqualTo":0,"TaxGreaterThan":0,"TaxLessThan":0,"TaxLessThanOrEqualTo":0,"TaxNotEqualTo":0,"TaxBetween":[0],"TaxIn":[0],"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"],"LastSavedStaffID":"String","LastSavedStaffIDStartsWith":"String","LastSavedStaffIDEndsWith":"String","LastSavedStaffIDContains":"String","LastSavedStaffIDLike":"String","LastSavedStaffIDBetween":["String"],"LastSavedStaffIDIn":["String"],"QOReference":"String","QOReferenceStartsWith":"String","QOReferenceEndsWith":"String","QOReferenceContains":"String","QOReferenceLike":"String","QOReferenceBetween":["String"],"QOReferenceIn":["String"],"ItemNo":0,"ItemNoGreaterThanOrEqualTo":0,"ItemNoGreaterThan":0,"ItemNoLessThan":0,"ItemNoLessThanOrEqualTo":0,"ItemNoNotEqualTo":0,"ItemNoBetween":[0],"ItemNoIn":[0],"Discount":0,"DiscountGreaterThanOrEqualTo":0,"DiscountGreaterThan":0,"DiscountLessThan":0,"DiscountLessThanOrEqualTo":0,"DiscountNotEqualTo":0,"DiscountBetween":[0],"DiscountIn":[0],"DiscountPercentage":0,"DiscountPercentageGreaterThanOrEqualTo":0,"DiscountPercentageGreaterThan":0,"DiscountPercentageLessThan":0,"DiscountPercentageLessThanOrEqualTo":0,"DiscountPercentageNotEqualTo":0,"DiscountPercentageBetween":[0],"DiscountPercentageIn":[0],"SellPriceIsIncTax":false,"QuantityDecimalPlaces":0,"QuantityDecimalPlacesGreaterThanOrEqualTo":0,"QuantityDecimalPlacesGreaterThan":0,"QuantityDecimalPlacesLessThan":0,"QuantityDecimalPlacesLessThanOrEqualTo":0,"QuantityDecimalPlacesNotEqualTo":0,"QuantityDecimalPlacesBetween":[0],"QuantityDecimalPlacesIn":[0],"Discountable":false,"DefaultPrice":0,"DefaultPriceGreaterThanOrEqualTo":0,"DefaultPriceGreaterThan":0,"DefaultPriceLessThan":0,"DefaultPriceLessThanOrEqualTo":0,"DefaultPriceNotEqualTo":0,"DefaultPriceBetween":[0],"DefaultPriceIn":[0],"MinimumGP":0,"MinimumGPGreaterThanOrEqualTo":0,"MinimumGPGreaterThan":0,"MinimumGPLessThan":0,"MinimumGPLessThanOrEqualTo":0,"MinimumGPNotEqualTo":0,"MinimumGPBetween":[0],"MinimumGPIn":[0],"LastCost":0,"LastCostGreaterThanOrEqualTo":0,"LastCostGreaterThan":0,"LastCostLessThan":0,"LastCostLessThanOrEqualTo":0,"LastCostNotEqualTo":0,"LastCostBetween":[0],"LastCostIn":[0],"TaxID":"String","TaxIDStartsWith":"String","TaxIDEndsWith":"String","TaxIDContains":"String","TaxIDLike":"String","TaxIDBetween":["String"],"TaxIDIn":["String"],"TaxRate":0,"TaxRateGreaterThanOrEqualTo":0,"TaxRateGreaterThan":0,"TaxRateLessThan":0,"TaxRateLessThanOrEqualTo":0,"TaxRateNotEqualTo":0,"TaxRateBetween":[0],"TaxRateIn":[0],"UserDefinedBit1":false,"UserDefinedBit2":false,"UserDefinedBit3":false,"UserDefinedString1":"String","UserDefinedString1StartsWith":"String","UserDefinedString1EndsWith":"String","UserDefinedString1Contains":"String","UserDefinedString1Like":"String","UserDefinedString1Between":["String"],"UserDefinedString1In":["String"],"UserDefinedString2":"String","UserDefinedString2StartsWith":"String","UserDefinedString2EndsWith":"String","UserDefinedString2Contains":"String","UserDefinedString2Like":"String","UserDefinedString2Between":["String"],"UserDefinedString2In":["String"],"UserDefinedString3":"String","UserDefinedString3StartsWith":"String","UserDefinedString3EndsWith":"String","UserDefinedString3Contains":"String","UserDefinedString3Like":"String","UserDefinedString3Between":["String"],"UserDefinedString3In":["String"],"UserDefinedDate1":"0001-01-01T00:00:00.0000000","UserDefinedDate1GreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","UserDefinedDate1GreaterThan":"0001-01-01T00:00:00.0000000","UserDefinedDate1LessThan":"0001-01-01T00:00:00.0000000","UserDefinedDate1LessThanOrEqualTo":"0001-01-01T00:00:00.0000000","UserDefinedDate1NotEqualTo":"0001-01-01T00:00:00.0000000","UserDefinedDate1Between":["0001-01-01T00:00:00.0000000"],"UserDefinedDate1In":["0001-01-01T00:00:00.0000000"],"UserDefinedDate2":"0001-01-01T00:00:00.0000000","UserDefinedDate2GreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","UserDefinedDate2GreaterThan":"0001-01-01T00:00:00.0000000","UserDefinedDate2LessThan":"0001-01-01T00:00:00.0000000","UserDefinedDate2LessThanOrEqualTo":"0001-01-01T00:00:00.0000000","UserDefinedDate2NotEqualTo":"0001-01-01T00:00:00.0000000","UserDefinedDate2Between":["0001-01-01T00:00:00.0000000"],"UserDefinedDate2In":["0001-01-01T00:00:00.0000000"],"UserDefinedDate3":"0001-01-01T00:00:00.0000000","UserDefinedDate3GreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","UserDefinedDate3GreaterThan":"0001-01-01T00:00:00.0000000","UserDefinedDate3LessThan":"0001-01-01T00:00:00.0000000","UserDefinedDate3LessThanOrEqualTo":"0001-01-01T00:00:00.0000000","UserDefinedDate3NotEqualTo":"0001-01-01T00:00:00.0000000","UserDefinedDate3Between":["0001-01-01T00:00:00.0000000"],"UserDefinedDate3In":["0001-01-01T00:00:00.0000000"],"UserDefinedFloat1":0,"UserDefinedFloat1GreaterThanOrEqualTo":0,"UserDefinedFloat1GreaterThan":0,"UserDefinedFloat1LessThan":0,"UserDefinedFloat1LessThanOrEqualTo":0,"UserDefinedFloat1NotEqualTo":0,"UserDefinedFloat1Between":[0],"UserDefinedFloat1In":[0],"UserDefinedFloat2":0,"UserDefinedFloat2GreaterThanOrEqualTo":0,"UserDefinedFloat2GreaterThan":0,"UserDefinedFloat2LessThan":0,"UserDefinedFloat2LessThanOrEqualTo":0,"UserDefinedFloat2NotEqualTo":0,"UserDefinedFloat2Between":[0],"UserDefinedFloat2In":[0],"UserDefinedFloat3":0,"UserDefinedFloat3GreaterThanOrEqualTo":0,"UserDefinedFloat3GreaterThan":0,"UserDefinedFloat3LessThan":0,"UserDefinedFloat3LessThanOrEqualTo":0,"UserDefinedFloat3NotEqualTo":0,"UserDefinedFloat3Between":[0],"UserDefinedFloat3In":[0],"SO_Lines_RecID":"String","SO_Lines_RecIDStartsWith":"String","SO_Lines_RecIDEndsWith":"String","SO_Lines_RecIDContains":"String","SO_Lines_RecIDLike":"String","SO_Lines_RecIDBetween":["String"],"SO_Lines_RecIDIn":["String"],"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","SM_Tasks_RecID":"String","IN_Main_RecID":"String","PartNo":"String","Description":"String","Quantity":0,"ItemPrice":0,"Tax":0,"LastSavedStaffID":"String","QOReference":"String","Discount":0,"DiscountPercentage":0,"SellPriceIsIncTax":false,"QuantityDecimalPlaces":0,"Discountable":false,"DefaultPrice":0,"MinimumGP":0,"LastCost":0,"TaxID":"String","TaxRate":0,"UserDefinedBit1":false,"UserDefinedBit2":false,"UserDefinedBit3":false,"UserDefinedString1":"String","UserDefinedString2":"String","UserDefinedString3":"String","UserDefinedDate1":"0001-01-01T00:00:00.0000000","UserDefinedDate2":"0001-01-01T00:00:00.0000000","UserDefinedDate3":"0001-01-01T00:00:00.0000000","UserDefinedFloat1":0,"UserDefinedFloat2":0,"UserDefinedFloat3":0,"SO_Lines_RecID":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}