| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| InvoiceLineID | query | string | No | |
| InvoiceLineIDStartsWith | query | string | No | |
| InvoiceLineIDEndsWith | query | string | No | |
| InvoiceLineIDContains | query | string | No | |
| InvoiceLineIDLike | query | string | No | |
| InvoiceLineIDBetween | query | string[] | No | |
| InvoiceLineIDIn | query | string[] | No | |
| InvoiceNo | query | string | No | |
| InvoiceNoStartsWith | query | string | No | |
| InvoiceNoEndsWith | query | string | No | |
| InvoiceNoContains | query | string | No | |
| InvoiceNoLike | query | string | No | |
| InvoiceNoBetween | query | string[] | No | |
| InvoiceNoIn | query | string[] | No | |
| StaffID | query | string | No | |
| StaffIDStartsWith | query | string | No | |
| StaffIDEndsWith | query | string | No | |
| StaffIDContains | query | string | No | |
| StaffIDLike | query | string | No | |
| StaffIDBetween | query | string[] | No | |
| StaffIDIn | query | string[] | 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 | |
| IN_PhysicalID | query | string | No | |
| IN_PhysicalIDStartsWith | query | string | No | |
| IN_PhysicalIDEndsWith | query | string | No | |
| IN_PhysicalIDContains | query | string | No | |
| IN_PhysicalIDLike | query | string | No | |
| IN_PhysicalIDBetween | query | string[] | No | |
| IN_PhysicalIDIn | query | string[] | No | |
| BranchID | query | string | No | |
| BranchIDStartsWith | query | string | No | |
| BranchIDEndsWith | query | string | No | |
| BranchIDContains | query | string | No | |
| BranchIDLike | query | string | No | |
| BranchIDBetween | query | string[] | No | |
| BranchIDIn | 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 | |
| PartDescription | query | string | No | |
| PartDescriptionStartsWith | query | string | No | |
| PartDescriptionEndsWith | query | string | No | |
| PartDescriptionContains | query | string | No | |
| PartDescriptionLike | query | string | No | |
| PartDescriptionBetween | query | string[] | No | |
| PartDescriptionIn | 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 | |
| LineTotalIncGST | query | decimal? | No | |
| LineTotalIncGSTGreaterThanOrEqualTo | query | decimal? | No | |
| LineTotalIncGSTGreaterThan | query | decimal? | No | |
| LineTotalIncGSTLessThan | query | decimal? | No | |
| LineTotalIncGSTLessThanOrEqualTo | query | decimal? | No | |
| LineTotalIncGSTNotEqualTo | query | decimal? | No | |
| LineTotalIncGSTBetween | query | Nullable<Decimal>[] | No | |
| LineTotalIncGSTIn | query | Nullable<Decimal>[] | No | |
| LineTaxTotal | query | decimal? | No | |
| LineTaxTotalGreaterThanOrEqualTo | query | decimal? | No | |
| LineTaxTotalGreaterThan | query | decimal? | No | |
| LineTaxTotalLessThan | query | decimal? | No | |
| LineTaxTotalLessThanOrEqualTo | query | decimal? | No | |
| LineTaxTotalNotEqualTo | query | decimal? | No | |
| LineTaxTotalBetween | query | Nullable<Decimal>[] | No | |
| LineTaxTotalIn | query | Nullable<Decimal>[] | No | |
| LineTotalExGST | query | decimal? | No | |
| LineTotalExGSTGreaterThanOrEqualTo | query | decimal? | No | |
| LineTotalExGSTGreaterThan | query | decimal? | No | |
| LineTotalExGSTLessThan | query | decimal? | No | |
| LineTotalExGSTLessThanOrEqualTo | query | decimal? | No | |
| LineTotalExGSTNotEqualTo | query | decimal? | No | |
| LineTotalExGSTBetween | query | Nullable<Decimal>[] | No | |
| LineTotalExGSTIn | query | Nullable<Decimal>[] | No | |
| LineCost | query | decimal? | No | |
| LineCostGreaterThanOrEqualTo | query | decimal? | No | |
| LineCostGreaterThan | query | decimal? | No | |
| LineCostLessThan | query | decimal? | No | |
| LineCostLessThanOrEqualTo | query | decimal? | No | |
| LineCostNotEqualTo | query | decimal? | No | |
| LineCostBetween | query | Nullable<Decimal>[] | No | |
| LineCostIn | query | Nullable<Decimal>[] | No | |
| LineProfit | query | decimal? | No | |
| LineProfitGreaterThanOrEqualTo | query | decimal? | No | |
| LineProfitGreaterThan | query | decimal? | No | |
| LineProfitLessThan | query | decimal? | No | |
| LineProfitLessThanOrEqualTo | query | decimal? | No | |
| LineProfitNotEqualTo | query | decimal? | No | |
| LineProfitBetween | query | Nullable<Decimal>[] | No | |
| LineProfitIn | query | Nullable<Decimal>[] | No | |
| ClassificationDescription | query | string | No | |
| ClassificationDescriptionStartsWith | query | string | No | |
| ClassificationDescriptionEndsWith | query | string | No | |
| ClassificationDescriptionContains | query | string | No | |
| ClassificationDescriptionLike | query | string | No | |
| ClassificationDescriptionBetween | query | string[] | No | |
| ClassificationDescriptionIn | query | string[] | No | |
| Category1DescriptionAtTimeOfSale | query | string | No | |
| Category1DescriptionAtTimeOfSaleStartsWith | query | string | No | |
| Category1DescriptionAtTimeOfSaleEndsWith | query | string | No | |
| Category1DescriptionAtTimeOfSaleContains | query | string | No | |
| Category1DescriptionAtTimeOfSaleLike | query | string | No | |
| Category1DescriptionAtTimeOfSaleBetween | query | string[] | No | |
| Category1DescriptionAtTimeOfSaleIn | query | string[] | No | |
| Category2DescriptionAtTimeOfSale | query | string | No | |
| Category2DescriptionAtTimeOfSaleStartsWith | query | string | No | |
| Category2DescriptionAtTimeOfSaleEndsWith | query | string | No | |
| Category2DescriptionAtTimeOfSaleContains | query | string | No | |
| Category2DescriptionAtTimeOfSaleLike | query | string | No | |
| Category2DescriptionAtTimeOfSaleBetween | query | string[] | No | |
| Category2DescriptionAtTimeOfSaleIn | query | string[] | No | |
| Category3DescriptionAtTimeOfSale | query | string | No | |
| Category3DescriptionAtTimeOfSaleStartsWith | query | string | No | |
| Category3DescriptionAtTimeOfSaleEndsWith | query | string | No | |
| Category3DescriptionAtTimeOfSaleContains | query | string | No | |
| Category3DescriptionAtTimeOfSaleLike | query | string | No | |
| Category3DescriptionAtTimeOfSaleBetween | query | string[] | No | |
| Category3DescriptionAtTimeOfSaleIn | query | string[] | No | |
| DebtorID | query | string | No | |
| DebtorIDStartsWith | query | string | No | |
| DebtorIDEndsWith | query | string | No | |
| DebtorIDContains | query | string | No | |
| DebtorIDLike | query | string | No | |
| DebtorIDBetween | query | string[] | No | |
| DebtorIDIn | query | string[] | No | |
| DebtorClassificationID | query | string | No | |
| DebtorClassificationIDStartsWith | query | string | No | |
| DebtorClassificationIDEndsWith | query | string | No | |
| DebtorClassificationIDContains | query | string | No | |
| DebtorClassificationIDLike | query | string | No | |
| DebtorClassificationIDBetween | query | string[] | No | |
| DebtorClassificationIDIn | query | string[] | No | |
| ProcessDate | query | DateTime? | No | |
| ProcessDateGreaterThanOrEqualTo | query | DateTime? | No | |
| ProcessDateGreaterThan | query | DateTime? | No | |
| ProcessDateLessThan | query | DateTime? | No | |
| ProcessDateLessThanOrEqualTo | query | DateTime? | No | |
| ProcessDateNotEqualTo | query | DateTime? | No | |
| ProcessDateBetween | query | Nullable<DateTime>[] | No | |
| ProcessDateIn | query | Nullable<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 |
| 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 |
|---|---|---|---|---|
| InvoiceLineID | form | string | No | |
| InvoiceNo | form | string | No | |
| StaffID | form | string | No | |
| IN_LogicalID | form | string | No | |
| IN_PhysicalID | form | string | No | |
| BranchID | form | string | No | |
| PartNo | form | string | No | |
| PartDescription | form | string | No | |
| Quantity | form | decimal? | No | |
| LineTotalIncGST | form | decimal? | No | |
| LineTaxTotal | form | decimal? | No | |
| LineTotalExGST | form | decimal? | No | |
| LineCost | form | decimal? | No | |
| LineProfit | form | decimal? | No | |
| ClassificationDescription | form | string | No | |
| Category1DescriptionAtTimeOfSale | form | string | No | |
| Category2DescriptionAtTimeOfSale | form | string | No | |
| Category3DescriptionAtTimeOfSale | form | string | No | |
| DebtorID | form | string | No | |
| DebtorClassificationID | form | string | No | |
| ProcessDate | form | DateTime? | No | |
| InventoryID | 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/v_SalesInformationQuery HTTP/1.1
Host: localhost
Accept: text/csv
Content-Type: text/csv
Content-Length: length
{"InvoiceLineID":"String","InvoiceLineIDStartsWith":"String","InvoiceLineIDEndsWith":"String","InvoiceLineIDContains":"String","InvoiceLineIDLike":"String","InvoiceLineIDBetween":["String"],"InvoiceLineIDIn":["String"],"InvoiceNo":"String","InvoiceNoStartsWith":"String","InvoiceNoEndsWith":"String","InvoiceNoContains":"String","InvoiceNoLike":"String","InvoiceNoBetween":["String"],"InvoiceNoIn":["String"],"StaffID":"String","StaffIDStartsWith":"String","StaffIDEndsWith":"String","StaffIDContains":"String","StaffIDLike":"String","StaffIDBetween":["String"],"StaffIDIn":["String"],"IN_LogicalID":"String","IN_LogicalIDStartsWith":"String","IN_LogicalIDEndsWith":"String","IN_LogicalIDContains":"String","IN_LogicalIDLike":"String","IN_LogicalIDBetween":["String"],"IN_LogicalIDIn":["String"],"IN_PhysicalID":"String","IN_PhysicalIDStartsWith":"String","IN_PhysicalIDEndsWith":"String","IN_PhysicalIDContains":"String","IN_PhysicalIDLike":"String","IN_PhysicalIDBetween":["String"],"IN_PhysicalIDIn":["String"],"BranchID":"String","BranchIDStartsWith":"String","BranchIDEndsWith":"String","BranchIDContains":"String","BranchIDLike":"String","BranchIDBetween":["String"],"BranchIDIn":["String"],"PartNo":"String","PartNoStartsWith":"String","PartNoEndsWith":"String","PartNoContains":"String","PartNoLike":"String","PartNoBetween":["String"],"PartNoIn":["String"],"PartDescription":"String","PartDescriptionStartsWith":"String","PartDescriptionEndsWith":"String","PartDescriptionContains":"String","PartDescriptionLike":"String","PartDescriptionBetween":["String"],"PartDescriptionIn":["String"],"Quantity":0,"QuantityGreaterThanOrEqualTo":0,"QuantityGreaterThan":0,"QuantityLessThan":0,"QuantityLessThanOrEqualTo":0,"QuantityNotEqualTo":0,"QuantityBetween":[0],"QuantityIn":[0],"LineTotalIncGST":0,"LineTotalIncGSTGreaterThanOrEqualTo":0,"LineTotalIncGSTGreaterThan":0,"LineTotalIncGSTLessThan":0,"LineTotalIncGSTLessThanOrEqualTo":0,"LineTotalIncGSTNotEqualTo":0,"LineTotalIncGSTBetween":[0],"LineTotalIncGSTIn":[0],"LineTaxTotal":0,"LineTaxTotalGreaterThanOrEqualTo":0,"LineTaxTotalGreaterThan":0,"LineTaxTotalLessThan":0,"LineTaxTotalLessThanOrEqualTo":0,"LineTaxTotalNotEqualTo":0,"LineTaxTotalBetween":[0],"LineTaxTotalIn":[0],"LineTotalExGST":0,"LineTotalExGSTGreaterThanOrEqualTo":0,"LineTotalExGSTGreaterThan":0,"LineTotalExGSTLessThan":0,"LineTotalExGSTLessThanOrEqualTo":0,"LineTotalExGSTNotEqualTo":0,"LineTotalExGSTBetween":[0],"LineTotalExGSTIn":[0],"LineCost":0,"LineCostGreaterThanOrEqualTo":0,"LineCostGreaterThan":0,"LineCostLessThan":0,"LineCostLessThanOrEqualTo":0,"LineCostNotEqualTo":0,"LineCostBetween":[0],"LineCostIn":[0],"LineProfit":0,"LineProfitGreaterThanOrEqualTo":0,"LineProfitGreaterThan":0,"LineProfitLessThan":0,"LineProfitLessThanOrEqualTo":0,"LineProfitNotEqualTo":0,"LineProfitBetween":[0],"LineProfitIn":[0],"ClassificationDescription":"String","ClassificationDescriptionStartsWith":"String","ClassificationDescriptionEndsWith":"String","ClassificationDescriptionContains":"String","ClassificationDescriptionLike":"String","ClassificationDescriptionBetween":["String"],"ClassificationDescriptionIn":["String"],"Category1DescriptionAtTimeOfSale":"String","Category1DescriptionAtTimeOfSaleStartsWith":"String","Category1DescriptionAtTimeOfSaleEndsWith":"String","Category1DescriptionAtTimeOfSaleContains":"String","Category1DescriptionAtTimeOfSaleLike":"String","Category1DescriptionAtTimeOfSaleBetween":["String"],"Category1DescriptionAtTimeOfSaleIn":["String"],"Category2DescriptionAtTimeOfSale":"String","Category2DescriptionAtTimeOfSaleStartsWith":"String","Category2DescriptionAtTimeOfSaleEndsWith":"String","Category2DescriptionAtTimeOfSaleContains":"String","Category2DescriptionAtTimeOfSaleLike":"String","Category2DescriptionAtTimeOfSaleBetween":["String"],"Category2DescriptionAtTimeOfSaleIn":["String"],"Category3DescriptionAtTimeOfSale":"String","Category3DescriptionAtTimeOfSaleStartsWith":"String","Category3DescriptionAtTimeOfSaleEndsWith":"String","Category3DescriptionAtTimeOfSaleContains":"String","Category3DescriptionAtTimeOfSaleLike":"String","Category3DescriptionAtTimeOfSaleBetween":["String"],"Category3DescriptionAtTimeOfSaleIn":["String"],"DebtorID":"String","DebtorIDStartsWith":"String","DebtorIDEndsWith":"String","DebtorIDContains":"String","DebtorIDLike":"String","DebtorIDBetween":["String"],"DebtorIDIn":["String"],"DebtorClassificationID":"String","DebtorClassificationIDStartsWith":"String","DebtorClassificationIDEndsWith":"String","DebtorClassificationIDContains":"String","DebtorClassificationIDLike":"String","DebtorClassificationIDBetween":["String"],"DebtorClassificationIDIn":["String"],"ProcessDate":"0001-01-01T00:00:00.0000000","ProcessDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","ProcessDateGreaterThan":"0001-01-01T00:00:00.0000000","ProcessDateLessThan":"0001-01-01T00:00:00.0000000","ProcessDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","ProcessDateNotEqualTo":"0001-01-01T00:00:00.0000000","ProcessDateBetween":["0001-01-01T00:00:00.0000000"],"ProcessDateIn":["0001-01-01T00:00:00.0000000"],"InventoryID":"String","InventoryIDStartsWith":"String","InventoryIDEndsWith":"String","InventoryIDContains":"String","InventoryIDLike":"String","InventoryIDBetween":["String"],"InventoryIDIn":["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":[{"InvoiceLineID":"String","InvoiceNo":"String","StaffID":"String","IN_LogicalID":"String","IN_PhysicalID":"String","BranchID":"String","PartNo":"String","PartDescription":"String","Quantity":0,"LineTotalIncGST":0,"LineTaxTotal":0,"LineTotalExGST":0,"LineCost":0,"LineProfit":0,"ClassificationDescription":"String","Category1DescriptionAtTimeOfSale":"String","Category2DescriptionAtTimeOfSale":"String","Category3DescriptionAtTimeOfSale":"String","DebtorID":"String","DebtorClassificationID":"String","ProcessDate":"0001-01-01T00:00:00.0000000","InventoryID":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}