Gemma.WebApi

ListinoQuery

**Requires Authentication**
Required role:	Admin

**ListinoQuery** Parameters:
Name	Parameter	Data Type	Required
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
AziendaId	query	int?	No
AziendaIdGreaterThanOrEqualTo	query	int?	No
AziendaIdGreaterThan	query	int?	No
AziendaIdLessThan	query	int?	No
AziendaIdLessThanOrEqualTo	query	int?	No
AziendaIdNotEqualTo	query	int?	No
AziendaIdBetween	query	Nullable<Int32>[]	No
AziendaIdIn	query	Nullable<Int32>[]	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
IsListinoBase	query	bool?	No
IsPredefinito	query	bool?	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
DataModifica	query	DateTime?	No
DataModificaGreaterThanOrEqualTo	query	DateTime?	No
DataModificaGreaterThan	query	DateTime?	No
DataModificaLessThan	query	DateTime?	No
DataModificaLessThanOrEqualTo	query	DateTime?	No
DataModificaNotEqualTo	query	DateTime?	No
DataModificaBetween	query	DateTime[]	No
DataModificaIn	query	DateTime[]	No
IsNascosto	query	bool?	No

**QueryBase** Parameters:
Name	Parameter	Data Type	Required
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

**Listino** Parameters:
Name	Parameter	Data Type	Required
Id	form	int	No
AziendaId	form	int?	No
Nome	form	string	No
IsListinoBase	form	bool	No
IsPredefinito	form	bool	No
Descrizione	form	string	No
DataModifica	form	DateTime	No
IsNascosto	form	bool	No

**QueryResponse<T>** Parameters:
Name	Parameter	Data Type	Required
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

HTTP + CSV

The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.

POST /csv/reply/ListinoQuery 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],"aziendaId":0,"aziendaIdGreaterThanOrEqualTo":0,"aziendaIdGreaterThan":0,"aziendaIdLessThan":0,"aziendaIdLessThanOrEqualTo":0,"aziendaIdNotEqualTo":0,"aziendaIdBetween":[0],"aziendaIdIn":[0],"nome":"String","nomeStartsWith":"String","nomeEndsWith":"String","nomeContains":"String","nomeLike":"String","nomeBetween":["String"],"nomeIn":["String"],"isListinoBase":false,"isPredefinito":false,"descrizione":"String","descrizioneStartsWith":"String","descrizioneEndsWith":"String","descrizioneContains":"String","descrizioneLike":"String","descrizioneBetween":["String"],"descrizioneIn":["String"],"dataModifica":"\/Date(-62135596800000-0000)\/","dataModificaGreaterThanOrEqualTo":"\/Date(-62135596800000-0000)\/","dataModificaGreaterThan":"\/Date(-62135596800000-0000)\/","dataModificaLessThan":"\/Date(-62135596800000-0000)\/","dataModificaLessThanOrEqualTo":"\/Date(-62135596800000-0000)\/","dataModificaNotEqualTo":"\/Date(-62135596800000-0000)\/","dataModificaBetween":["0001-01-01T00:00:00"],"dataModificaIn":["0001-01-01T00:00:00"],"isNascosto":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,"aziendaId":0,"nome":"String","isListinoBase":false,"isPredefinito":false,"descrizione":"String","isNascosto":false}],"meta":{"String":"String"},"responseStatus":{"errorCode":"String","message":"String","stackTrace":"String","errors":[{"errorCode":"String","fieldName":"String","message":"String","meta":{"String":"String"}}],"meta":{"String":"String"}}}