| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| FullInvNo | query | string | No | |
| FullInvNoStartsWith | query | string | No | |
| FullInvNoEndsWith | query | string | No | |
| FullInvNoContains | query | string | No | |
| FullInvNoLike | query | string | No | |
| FullInvNoBetween | query | string[] | No | |
| FullInvNoIn | query | string[] | No | |
| Date | query | string | No | |
| DateStartsWith | query | string | No | |
| DateEndsWith | query | string | No | |
| DateContains | query | string | No | |
| DateLike | query | string | No | |
| DateBetween | query | string[] | No | |
| DateIn | query | string[] | No | |
| orderno | query | string | No | |
| ordernoStartsWith | query | string | No | |
| ordernoEndsWith | query | string | No | |
| ordernoContains | query | string | No | |
| ordernoLike | query | string | No | |
| ordernoBetween | query | string[] | No | |
| ordernoIn | query | string[] | No | |
| Accountno | query | string | No | |
| AccountnoStartsWith | query | string | No | |
| AccountnoEndsWith | query | string | No | |
| AccountnoContains | query | string | No | |
| AccountnoLike | query | string | No | |
| AccountnoBetween | query | string[] | No | |
| AccountnoIn | query | string[] | No | |
| QtyOrd | query | string | No | |
| QtyOrdStartsWith | query | string | No | |
| QtyOrdEndsWith | query | string | No | |
| QtyOrdContains | query | string | No | |
| QtyOrdLike | query | string | No | |
| QtyOrdBetween | query | string[] | No | |
| QtyOrdIn | query | string[] | No | |
| 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 | |
| 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 | |
| InvoiceHistoryID | query | string | No | |
| InvoiceHistoryIDStartsWith | query | string | No | |
| InvoiceHistoryIDEndsWith | query | string | No | |
| InvoiceHistoryIDContains | query | string | No | |
| InvoiceHistoryIDLike | query | string | No | |
| InvoiceHistoryIDBetween | query | string[] | No | |
| InvoiceHistoryIDIn | 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 |
|---|---|---|---|---|
| FullInvNo | form | string | No | |
| Date | form | string | No | |
| orderno | form | string | No | |
| Accountno | form | string | No | |
| QtyOrd | form | string | No | |
| InvoiceLineID | form | string | No | |
| InventoryID | form | string | No | |
| InvoiceHistoryID | 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_Inv_SalesQuery HTTP/1.1
Host: localhost
Accept: text/csv
Content-Type: text/csv
Content-Length: length
{"FullInvNo":"String","FullInvNoStartsWith":"String","FullInvNoEndsWith":"String","FullInvNoContains":"String","FullInvNoLike":"String","FullInvNoBetween":["String"],"FullInvNoIn":["String"],"Date":"String","DateStartsWith":"String","DateEndsWith":"String","DateContains":"String","DateLike":"String","DateBetween":["String"],"DateIn":["String"],"orderno":"String","ordernoStartsWith":"String","ordernoEndsWith":"String","ordernoContains":"String","ordernoLike":"String","ordernoBetween":["String"],"ordernoIn":["String"],"Accountno":"String","AccountnoStartsWith":"String","AccountnoEndsWith":"String","AccountnoContains":"String","AccountnoLike":"String","AccountnoBetween":["String"],"AccountnoIn":["String"],"QtyOrd":"String","QtyOrdStartsWith":"String","QtyOrdEndsWith":"String","QtyOrdContains":"String","QtyOrdLike":"String","QtyOrdBetween":["String"],"QtyOrdIn":["String"],"InvoiceLineID":"String","InvoiceLineIDStartsWith":"String","InvoiceLineIDEndsWith":"String","InvoiceLineIDContains":"String","InvoiceLineIDLike":"String","InvoiceLineIDBetween":["String"],"InvoiceLineIDIn":["String"],"InventoryID":"String","InventoryIDStartsWith":"String","InventoryIDEndsWith":"String","InventoryIDContains":"String","InventoryIDLike":"String","InventoryIDBetween":["String"],"InventoryIDIn":["String"],"InvoiceHistoryID":"String","InvoiceHistoryIDStartsWith":"String","InvoiceHistoryIDEndsWith":"String","InvoiceHistoryIDContains":"String","InvoiceHistoryIDLike":"String","InvoiceHistoryIDBetween":["String"],"InvoiceHistoryIDIn":["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":[{"FullInvNo":"String","Date":"String","orderno":"String","Accountno":"String","QtyOrd":"String","InvoiceLineID":"String","InventoryID":"String","InvoiceHistoryID":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}