| 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 | |
| Descrizione | query | string | No | |
| DescrizioneStartsWith | query | string | No | |
| DescrizioneEndsWith | query | string | No | |
| DescrizioneContains | query | string | No | |
| DescrizioneLike | query | string | No | |
| DescrizioneBetween | query | string[] | No | |
| DescrizioneIn | query | string[] | No | |
| TipoInizioScadenza | query | int? | No | |
| TipoInizioScadenzaGreaterThanOrEqualTo | query | int? | No | |
| TipoInizioScadenzaGreaterThan | query | int? | No | |
| TipoInizioScadenzaLessThan | query | int? | No | |
| TipoInizioScadenzaLessThanOrEqualTo | query | int? | No | |
| TipoInizioScadenzaNotEqualTo | query | int? | No | |
| TipoInizioScadenzaBetween | query | int[] | No | |
| TipoInizioScadenzaIn | query | int[] | No | |
| g1 | query | int? | No | |
| g1GreaterThanOrEqualTo | query | int? | No | |
| g1GreaterThan | query | int? | No | |
| g1LessThan | query | int? | No | |
| g1LessThanOrEqualTo | query | int? | No | |
| g1NotEqualTo | query | int? | No | |
| g1Between | query | int[] | No | |
| g1In | query | int[] | No | |
| p1 | query | decimal? | No | |
| p1GreaterThanOrEqualTo | query | decimal? | No | |
| p1GreaterThan | query | decimal? | No | |
| p1LessThan | query | decimal? | No | |
| p1LessThanOrEqualTo | query | decimal? | No | |
| p1NotEqualTo | query | decimal? | No | |
| p1Between | query | decimal[] | No | |
| p1In | query | decimal[] | No | |
| g2 | query | int? | No | |
| g2GreaterThanOrEqualTo | query | int? | No | |
| g2GreaterThan | query | int? | No | |
| g2LessThan | query | int? | No | |
| g2LessThanOrEqualTo | query | int? | No | |
| g2NotEqualTo | query | int? | No | |
| g2Between | query | int[] | No | |
| g2In | query | int[] | No | |
| p2 | query | decimal? | No | |
| p2GreaterThanOrEqualTo | query | decimal? | No | |
| p2GreaterThan | query | decimal? | No | |
| p2LessThan | query | decimal? | No | |
| p2LessThanOrEqualTo | query | decimal? | No | |
| p2NotEqualTo | query | decimal? | No | |
| p2Between | query | decimal[] | No | |
| p2In | query | decimal[] | No | |
| g3 | query | int? | No | |
| g3GreaterThanOrEqualTo | query | int? | No | |
| g3GreaterThan | query | int? | No | |
| g3LessThan | query | int? | No | |
| g3LessThanOrEqualTo | query | int? | No | |
| g3NotEqualTo | query | int? | No | |
| g3Between | query | int[] | No | |
| g3In | query | int[] | No | |
| p3 | query | decimal? | No | |
| p3GreaterThanOrEqualTo | query | decimal? | No | |
| p3GreaterThan | query | decimal? | No | |
| p3LessThan | query | decimal? | No | |
| p3LessThanOrEqualTo | query | decimal? | No | |
| p3NotEqualTo | query | decimal? | No | |
| p3Between | query | decimal[] | No | |
| p3In | query | decimal[] | No | |
| g4 | query | int? | No | |
| g4GreaterThanOrEqualTo | query | int? | No | |
| g4GreaterThan | query | int? | No | |
| g4LessThan | query | int? | No | |
| g4LessThanOrEqualTo | query | int? | No | |
| g4NotEqualTo | query | int? | No | |
| g4Between | query | int[] | No | |
| g4In | query | int[] | No | |
| p4 | query | decimal? | No | |
| p4GreaterThanOrEqualTo | query | decimal? | No | |
| p4GreaterThan | query | decimal? | No | |
| p4LessThan | query | decimal? | No | |
| p4LessThanOrEqualTo | query | decimal? | No | |
| p4NotEqualTo | query | decimal? | No | |
| p4Between | query | decimal[] | No | |
| p4In | query | decimal[] | No | |
| g5 | query | int? | No | |
| g5GreaterThanOrEqualTo | query | int? | No | |
| g5GreaterThan | query | int? | No | |
| g5LessThan | query | int? | No | |
| g5LessThanOrEqualTo | query | int? | No | |
| g5NotEqualTo | query | int? | No | |
| g5Between | query | int[] | No | |
| g5In | query | int[] | No | |
| p5 | query | decimal? | No | |
| p5GreaterThanOrEqualTo | query | decimal? | No | |
| p5GreaterThan | query | decimal? | No | |
| p5LessThan | query | decimal? | No | |
| p5LessThanOrEqualTo | query | decimal? | No | |
| p5NotEqualTo | query | decimal? | No | |
| p5Between | query | decimal[] | No | |
| p5In | query | decimal[] | No | |
| g6 | query | int? | No | |
| g6GreaterThanOrEqualTo | query | int? | No | |
| g6GreaterThan | query | int? | No | |
| g6LessThan | query | int? | No | |
| g6LessThanOrEqualTo | query | int? | No | |
| g6NotEqualTo | query | int? | No | |
| g6Between | query | int[] | No | |
| g6In | query | int[] | No | |
| p6 | query | decimal? | No | |
| p6GreaterThanOrEqualTo | query | decimal? | No | |
| p6GreaterThan | query | decimal? | No | |
| p6LessThan | query | decimal? | No | |
| p6LessThanOrEqualTo | query | decimal? | No | |
| p6NotEqualTo | query | decimal? | No | |
| p6Between | query | decimal[] | No | |
| p6In | query | decimal[] | 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 | |
| isPredefinito | 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 | |
| Descrizione | form | string | No | |
| TipoInizioScadenza | form | int | No | |
| g1 | form | int | No | |
| p1 | form | decimal | No | |
| g2 | form | int | No | |
| p2 | form | decimal | No | |
| g3 | form | int | No | |
| p3 | form | decimal | No | |
| g4 | form | int | No | |
| p4 | form | decimal | No | |
| g5 | form | int | No | |
| p5 | form | decimal | No | |
| g6 | form | int | No | |
| p6 | form | decimal | No | |
| OrdineVista | form | int | No | |
| isPredefinito | 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/TipoScadenzaPagamentoQuery 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],"descrizione":"String","descrizioneStartsWith":"String","descrizioneEndsWith":"String","descrizioneContains":"String","descrizioneLike":"String","descrizioneBetween":["String"],"descrizioneIn":["String"],"tipoInizioScadenza":0,"tipoInizioScadenzaGreaterThanOrEqualTo":0,"tipoInizioScadenzaGreaterThan":0,"tipoInizioScadenzaLessThan":0,"tipoInizioScadenzaLessThanOrEqualTo":0,"tipoInizioScadenzaNotEqualTo":0,"tipoInizioScadenzaBetween":[0],"tipoInizioScadenzaIn":[0],"g1":0,"g1GreaterThanOrEqualTo":0,"g1GreaterThan":0,"g1LessThan":0,"g1LessThanOrEqualTo":0,"g1NotEqualTo":0,"g1Between":[0],"g1In":[0],"p1":0,"p1GreaterThanOrEqualTo":0,"p1GreaterThan":0,"p1LessThan":0,"p1LessThanOrEqualTo":0,"p1NotEqualTo":0,"p1Between":[0],"p1In":[0],"g2":0,"g2GreaterThanOrEqualTo":0,"g2GreaterThan":0,"g2LessThan":0,"g2LessThanOrEqualTo":0,"g2NotEqualTo":0,"g2Between":[0],"g2In":[0],"p2":0,"p2GreaterThanOrEqualTo":0,"p2GreaterThan":0,"p2LessThan":0,"p2LessThanOrEqualTo":0,"p2NotEqualTo":0,"p2Between":[0],"p2In":[0],"g3":0,"g3GreaterThanOrEqualTo":0,"g3GreaterThan":0,"g3LessThan":0,"g3LessThanOrEqualTo":0,"g3NotEqualTo":0,"g3Between":[0],"g3In":[0],"p3":0,"p3GreaterThanOrEqualTo":0,"p3GreaterThan":0,"p3LessThan":0,"p3LessThanOrEqualTo":0,"p3NotEqualTo":0,"p3Between":[0],"p3In":[0],"g4":0,"g4GreaterThanOrEqualTo":0,"g4GreaterThan":0,"g4LessThan":0,"g4LessThanOrEqualTo":0,"g4NotEqualTo":0,"g4Between":[0],"g4In":[0],"p4":0,"p4GreaterThanOrEqualTo":0,"p4GreaterThan":0,"p4LessThan":0,"p4LessThanOrEqualTo":0,"p4NotEqualTo":0,"p4Between":[0],"p4In":[0],"g5":0,"g5GreaterThanOrEqualTo":0,"g5GreaterThan":0,"g5LessThan":0,"g5LessThanOrEqualTo":0,"g5NotEqualTo":0,"g5Between":[0],"g5In":[0],"p5":0,"p5GreaterThanOrEqualTo":0,"p5GreaterThan":0,"p5LessThan":0,"p5LessThanOrEqualTo":0,"p5NotEqualTo":0,"p5Between":[0],"p5In":[0],"g6":0,"g6GreaterThanOrEqualTo":0,"g6GreaterThan":0,"g6LessThan":0,"g6LessThanOrEqualTo":0,"g6NotEqualTo":0,"g6Between":[0],"g6In":[0],"p6":0,"p6GreaterThanOrEqualTo":0,"p6GreaterThan":0,"p6LessThan":0,"p6LessThanOrEqualTo":0,"p6NotEqualTo":0,"p6Between":[0],"p6In":[0],"ordineVista":0,"ordineVistaGreaterThanOrEqualTo":0,"ordineVistaGreaterThan":0,"ordineVistaLessThan":0,"ordineVistaLessThanOrEqualTo":0,"ordineVistaNotEqualTo":0,"ordineVistaBetween":[0],"ordineVistaIn":[0],"isPredefinito":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,"descrizione":"String","tipoInizioScadenza":0,"g1":0,"p1":0,"g2":0,"p2":0,"g3":0,"p3":0,"g4":0,"p4":0,"g5":0,"p5":0,"g6":0,"p6":0,"ordineVista":0,"isPredefinito":false}],"meta":{"String":"String"},"responseStatus":{"errorCode":"String","message":"String","stackTrace":"String","errors":[{"errorCode":"String","fieldName":"String","message":"String","meta":{"String":"String"}}],"meta":{"String":"String"}}}