| Required role: | Admin |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| Id | query | int? | No | |
| IdGreaterThanOrEqualTo | query | int? | No | |
| IdGreaterThan | query | int? | No | |
| IdLessThan | query | int? | No | |
| IdLessThanOrEqualTo | query | int? | No | |
| IdNotEqualTo | query | int? | No | |
| IdBetween | query | int[] | No | |
| IdIn | query | int[] | No | |
| Nome | query | string | No | |
| NomeStartsWith | query | string | No | |
| NomeEndsWith | query | string | No | |
| NomeContains | query | string | No | |
| NomeLike | query | string | No | |
| NomeBetween | query | string[] | No | |
| NomeIn | query | string[] | No | |
| OrdineVista | query | int? | No | |
| OrdineVistaGreaterThanOrEqualTo | query | int? | No | |
| OrdineVistaGreaterThan | query | int? | No | |
| OrdineVistaLessThan | query | int? | No | |
| OrdineVistaLessThanOrEqualTo | query | int? | No | |
| OrdineVistaNotEqualTo | query | int? | No | |
| OrdineVistaBetween | query | int[] | No | |
| OrdineVistaIn | query | int[] | No | |
| Note | query | string | No | |
| NoteStartsWith | query | string | No | |
| NoteEndsWith | query | string | No | |
| NoteContains | query | string | No | |
| NoteLike | query | string | No | |
| NoteBetween | query | string[] | No | |
| NoteIn | query | string[] | No | |
| DateCreated | query | DateTime? | No | |
| DateCreatedGreaterThanOrEqualTo | query | DateTime? | No | |
| DateCreatedGreaterThan | query | DateTime? | No | |
| DateCreatedLessThan | query | DateTime? | No | |
| DateCreatedLessThanOrEqualTo | query | DateTime? | No | |
| DateCreatedNotEqualTo | query | DateTime? | No | |
| DateCreatedBetween | query | DateTime[] | No | |
| DateCreatedIn | query | DateTime[] | No | |
| EmpCreated | query | string | No | |
| EmpCreatedStartsWith | query | string | No | |
| EmpCreatedEndsWith | query | string | No | |
| EmpCreatedContains | query | string | No | |
| EmpCreatedLike | query | string | No | |
| EmpCreatedBetween | query | string[] | No | |
| EmpCreatedIn | query | string[] | No | |
| DateUpdated | query | DateTime? | No | |
| DateUpdatedGreaterThanOrEqualTo | query | DateTime? | No | |
| DateUpdatedGreaterThan | query | DateTime? | No | |
| DateUpdatedLessThan | query | DateTime? | No | |
| DateUpdatedLessThanOrEqualTo | query | DateTime? | No | |
| DateUpdatedNotEqualTo | query | DateTime? | No | |
| DateUpdatedBetween | query | DateTime[] | No | |
| DateUpdatedIn | query | DateTime[] | No | |
| EmpUpdated | query | string | No | |
| EmpUpdatedStartsWith | query | string | No | |
| EmpUpdatedEndsWith | query | string | No | |
| EmpUpdatedContains | query | string | No | |
| EmpUpdatedLike | query | string | No | |
| EmpUpdatedBetween | query | string[] | No | |
| EmpUpdatedIn | query | string[] | No | |
| RowVersion | query | int? | No | |
| RowVersionGreaterThanOrEqualTo | query | int? | No | |
| RowVersionGreaterThan | query | int? | No | |
| RowVersionLessThan | query | int? | No | |
| RowVersionLessThanOrEqualTo | query | int? | No | |
| RowVersionNotEqualTo | query | int? | No | |
| RowVersionBetween | query | int[] | No | |
| RowVersionIn | query | int[] | No | |
| IsDefault | query | bool? | 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 |
|---|---|---|---|---|
| Id | form | int | No | |
| Nome | form | string | No | |
| OrdineVista | form | int | No | |
| Note | form | string | No | |
| DateCreated | form | DateTime | No | |
| EmpCreated | form | string | No | |
| DateUpdated | form | DateTime | No | |
| EmpUpdated | form | string | No | |
| RowVersion | form | int | No | |
| IsDefault | form | bool | 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/TipoRecapitoQuery HTTP/1.1
Host: gemma.api.kerberos.energy
Accept: text/csv
Content-Type: text/csv
Content-Length: length
{"id":0,"idGreaterThanOrEqualTo":0,"idGreaterThan":0,"idLessThan":0,"idLessThanOrEqualTo":0,"idNotEqualTo":0,"idBetween":[0],"idIn":[0],"nome":"String","nomeStartsWith":"String","nomeEndsWith":"String","nomeContains":"String","nomeLike":"String","nomeBetween":["String"],"nomeIn":["String"],"ordineVista":0,"ordineVistaGreaterThanOrEqualTo":0,"ordineVistaGreaterThan":0,"ordineVistaLessThan":0,"ordineVistaLessThanOrEqualTo":0,"ordineVistaNotEqualTo":0,"ordineVistaBetween":[0],"ordineVistaIn":[0],"note":"String","noteStartsWith":"String","noteEndsWith":"String","noteContains":"String","noteLike":"String","noteBetween":["String"],"noteIn":["String"],"dateCreated":"\/Date(-62135596800000-0000)\/","dateCreatedGreaterThanOrEqualTo":"\/Date(-62135596800000-0000)\/","dateCreatedGreaterThan":"\/Date(-62135596800000-0000)\/","dateCreatedLessThan":"\/Date(-62135596800000-0000)\/","dateCreatedLessThanOrEqualTo":"\/Date(-62135596800000-0000)\/","dateCreatedNotEqualTo":"\/Date(-62135596800000-0000)\/","dateCreatedBetween":["0001-01-01T00:00:00"],"dateCreatedIn":["0001-01-01T00:00:00"],"empCreated":"String","empCreatedStartsWith":"String","empCreatedEndsWith":"String","empCreatedContains":"String","empCreatedLike":"String","empCreatedBetween":["String"],"empCreatedIn":["String"],"dateUpdated":"\/Date(-62135596800000-0000)\/","dateUpdatedGreaterThanOrEqualTo":"\/Date(-62135596800000-0000)\/","dateUpdatedGreaterThan":"\/Date(-62135596800000-0000)\/","dateUpdatedLessThan":"\/Date(-62135596800000-0000)\/","dateUpdatedLessThanOrEqualTo":"\/Date(-62135596800000-0000)\/","dateUpdatedNotEqualTo":"\/Date(-62135596800000-0000)\/","dateUpdatedBetween":["0001-01-01T00:00:00"],"dateUpdatedIn":["0001-01-01T00:00:00"],"empUpdated":"String","empUpdatedStartsWith":"String","empUpdatedEndsWith":"String","empUpdatedContains":"String","empUpdatedLike":"String","empUpdatedBetween":["String"],"empUpdatedIn":["String"],"rowVersion":0,"rowVersionGreaterThanOrEqualTo":0,"rowVersionGreaterThan":0,"rowVersionLessThan":0,"rowVersionLessThanOrEqualTo":0,"rowVersionNotEqualTo":0,"rowVersionBetween":[0],"rowVersionIn":[0],"isDefault":false,"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
{"offset":0,"total":0,"results":[{"id":0,"nome":"String","ordineVista":0,"note":"String","empCreated":"String","empUpdated":"String","rowVersion":0,"isDefault":false}],"meta":{"String":"String"},"responseStatus":{"errorCode":"String","message":"String","stackTrace":"String","errors":[{"errorCode":"String","fieldName":"String","message":"String","meta":{"String":"String"}}],"meta":{"String":"String"}}}