| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| JobID | query | string | No | |
| JobIDStartsWith | query | string | No | |
| JobIDEndsWith | query | string | No | |
| JobIDContains | query | string | No | |
| JobIDLike | query | string | No | |
| JobIDBetween | query | string[] | No | |
| JobIDIn | query | string[] | No | |
| JobNo | query | string | No | |
| JobNoStartsWith | query | string | No | |
| JobNoEndsWith | query | string | No | |
| JobNoContains | query | string | No | |
| JobNoLike | query | string | No | |
| JobNoBetween | query | string[] | No | |
| JobNoIn | query | string[] | No | |
| DB_Main_RecID | query | string | No | |
| DB_Main_RecIDStartsWith | query | string | No | |
| DB_Main_RecIDEndsWith | query | string | No | |
| DB_Main_RecIDContains | query | string | No | |
| DB_Main_RecIDLike | query | string | No | |
| DB_Main_RecIDBetween | query | string[] | No | |
| DB_Main_RecIDIn | 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 | |
| Name | query | string | No | |
| NameStartsWith | query | string | No | |
| NameEndsWith | query | string | No | |
| NameContains | query | string | No | |
| NameLike | query | string | No | |
| NameBetween | query | string[] | No | |
| NameIn | query | string[] | No | |
| JobDescription | query | string | No | |
| JobDescriptionStartsWith | query | string | No | |
| JobDescriptionEndsWith | query | string | No | |
| JobDescriptionContains | query | string | No | |
| JobDescriptionLike | query | string | No | |
| JobDescriptionBetween | query | string[] | No | |
| JobDescriptionIn | query | string[] | No | |
| CoordinatorName | query | string | No | |
| CoordinatorNameStartsWith | query | string | No | |
| CoordinatorNameEndsWith | query | string | No | |
| CoordinatorNameContains | query | string | No | |
| CoordinatorNameLike | query | string | No | |
| CoordinatorNameBetween | query | string[] | No | |
| CoordinatorNameIn | query | string[] | No | |
| JobDateLogged | query | DateTime? | No | |
| JobDateLoggedGreaterThanOrEqualTo | query | DateTime? | No | |
| JobDateLoggedGreaterThan | query | DateTime? | No | |
| JobDateLoggedLessThan | query | DateTime? | No | |
| JobDateLoggedLessThanOrEqualTo | query | DateTime? | No | |
| JobDateLoggedNotEqualTo | query | DateTime? | No | |
| JobDateLoggedBetween | query | Nullable<DateTime>[] | No | |
| JobDateLoggedIn | query | Nullable<DateTime>[] | 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 |
|---|---|---|---|---|
| JobID | form | string | No | |
| JobNo | form | string | No | |
| DB_Main_RecID | form | string | No | |
| AccountNo | form | string | No | |
| Name | form | string | No | |
| JobDescription | form | string | No | |
| CoordinatorName | form | string | No | |
| JobDateLogged | form | DateTime? | 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_JobsWithActiveTaskQuery HTTP/1.1
Host: localhost
Accept: text/csv
Content-Type: text/csv
Content-Length: length
{"JobID":"String","JobIDStartsWith":"String","JobIDEndsWith":"String","JobIDContains":"String","JobIDLike":"String","JobIDBetween":["String"],"JobIDIn":["String"],"JobNo":"String","JobNoStartsWith":"String","JobNoEndsWith":"String","JobNoContains":"String","JobNoLike":"String","JobNoBetween":["String"],"JobNoIn":["String"],"DB_Main_RecID":"String","DB_Main_RecIDStartsWith":"String","DB_Main_RecIDEndsWith":"String","DB_Main_RecIDContains":"String","DB_Main_RecIDLike":"String","DB_Main_RecIDBetween":["String"],"DB_Main_RecIDIn":["String"],"AccountNo":"String","AccountNoStartsWith":"String","AccountNoEndsWith":"String","AccountNoContains":"String","AccountNoLike":"String","AccountNoBetween":["String"],"AccountNoIn":["String"],"Name":"String","NameStartsWith":"String","NameEndsWith":"String","NameContains":"String","NameLike":"String","NameBetween":["String"],"NameIn":["String"],"JobDescription":"String","JobDescriptionStartsWith":"String","JobDescriptionEndsWith":"String","JobDescriptionContains":"String","JobDescriptionLike":"String","JobDescriptionBetween":["String"],"JobDescriptionIn":["String"],"CoordinatorName":"String","CoordinatorNameStartsWith":"String","CoordinatorNameEndsWith":"String","CoordinatorNameContains":"String","CoordinatorNameLike":"String","CoordinatorNameBetween":["String"],"CoordinatorNameIn":["String"],"JobDateLogged":"0001-01-01T00:00:00.0000000","JobDateLoggedGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","JobDateLoggedGreaterThan":"0001-01-01T00:00:00.0000000","JobDateLoggedLessThan":"0001-01-01T00:00:00.0000000","JobDateLoggedLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","JobDateLoggedNotEqualTo":"0001-01-01T00:00:00.0000000","JobDateLoggedBetween":["0001-01-01T00:00:00.0000000"],"JobDateLoggedIn":["0001-01-01T00:00:00.0000000"],"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":[{"JobID":"String","JobNo":"String","DB_Main_RecID":"String","AccountNo":"String","Name":"String","JobDescription":"String","CoordinatorName":"String","JobDateLogged":"0001-01-01T00:00:00.0000000"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}