Gemma.WebApi

NotaQuery

**Requires Authentication**
Required role:	Admin

**NotaQuery** 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
Data	query	DateTime?	No
DataGreaterThanOrEqualTo	query	DateTime?	No
DataGreaterThan	query	DateTime?	No
DataLessThan	query	DateTime?	No
DataLessThanOrEqualTo	query	DateTime?	No
DataNotEqualTo	query	DateTime?	No
DataBetween	query	DateTime[]	No
DataIn	query	DateTime[]	No
UtenteId	query	int?	No
UtenteIdGreaterThanOrEqualTo	query	int?	No
UtenteIdGreaterThan	query	int?	No
UtenteIdLessThan	query	int?	No
UtenteIdLessThanOrEqualTo	query	int?	No
UtenteIdNotEqualTo	query	int?	No
UtenteIdBetween	query	int[]	No
UtenteIdIn	query	int[]	No
ContattoId	query	int?	No
ContattoIdGreaterThanOrEqualTo	query	int?	No
ContattoIdGreaterThan	query	int?	No
ContattoIdLessThan	query	int?	No
ContattoIdLessThanOrEqualTo	query	int?	No
ContattoIdNotEqualTo	query	int?	No
ContattoIdBetween	query	int[]	No
ContattoIdIn	query	int[]	No
Tabella	query	string	No
TabellaStartsWith	query	string	No
TabellaEndsWith	query	string	No
TabellaContains	query	string	No
TabellaLike	query	string	No
TabellaBetween	query	string[]	No
TabellaIn	query	string[]	No
RiferimentoId	query	int?	No
RiferimentoIdGreaterThanOrEqualTo	query	int?	No
RiferimentoIdGreaterThan	query	int?	No
RiferimentoIdLessThan	query	int?	No
RiferimentoIdLessThanOrEqualTo	query	int?	No
RiferimentoIdNotEqualTo	query	int?	No
RiferimentoIdBetween	query	int[]	No
RiferimentoIdIn	query	int[]	No
NotaTesto	query	string	No
NotaTestoStartsWith	query	string	No
NotaTestoEndsWith	query	string	No
NotaTestoContains	query	string	No
NotaTestoLike	query	string	No
NotaTestoBetween	query	string[]	No
NotaTestoIn	query	string[]	No
IsPerVerbale	query	bool?	No
TagNotifiche	query	string	No
TagNotificheStartsWith	query	string	No
TagNotificheEndsWith	query	string	No
TagNotificheContains	query	string	No
TagNotificheLike	query	string	No
TagNotificheBetween	query	string[]	No
TagNotificheIn	query	string[]	No
TestoVerbaleId	query	int?	No
TestoVerbaleIdGreaterThanOrEqualTo	query	int?	No
TestoVerbaleIdGreaterThan	query	int?	No
TestoVerbaleIdLessThan	query	int?	No
TestoVerbaleIdLessThanOrEqualTo	query	int?	No
TestoVerbaleIdNotEqualTo	query	int?	No
TestoVerbaleIdBetween	query	int[]	No
TestoVerbaleIdIn	query	int[]	No
IsNotaAutomatica	query	bool?	No
IsEvidenziata	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

**Nota** Parameters:
Name	Parameter	Data Type	Required
Id	form	int	No
Data	form	DateTime	No
UtenteId	form	int	No
ContattoId	form	int	No
Tabella	form	string	No
RiferimentoId	form	int	No
NotaTesto	form	string	No
IsPerVerbale	form	bool	No
TagNotifiche	form	string	No
TestoVerbaleId	form	int	No
IsNotaAutomatica	form	bool	No
IsEvidenziata	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/NotaQuery 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],"data":"\/Date(-62135596800000-0000)\/","dataGreaterThanOrEqualTo":"\/Date(-62135596800000-0000)\/","dataGreaterThan":"\/Date(-62135596800000-0000)\/","dataLessThan":"\/Date(-62135596800000-0000)\/","dataLessThanOrEqualTo":"\/Date(-62135596800000-0000)\/","dataNotEqualTo":"\/Date(-62135596800000-0000)\/","dataBetween":["0001-01-01T00:00:00"],"dataIn":["0001-01-01T00:00:00"],"utenteId":0,"utenteIdGreaterThanOrEqualTo":0,"utenteIdGreaterThan":0,"utenteIdLessThan":0,"utenteIdLessThanOrEqualTo":0,"utenteIdNotEqualTo":0,"utenteIdBetween":[0],"utenteIdIn":[0],"contattoId":0,"contattoIdGreaterThanOrEqualTo":0,"contattoIdGreaterThan":0,"contattoIdLessThan":0,"contattoIdLessThanOrEqualTo":0,"contattoIdNotEqualTo":0,"contattoIdBetween":[0],"contattoIdIn":[0],"tabella":"String","tabellaStartsWith":"String","tabellaEndsWith":"String","tabellaContains":"String","tabellaLike":"String","tabellaBetween":["String"],"tabellaIn":["String"],"riferimentoId":0,"riferimentoIdGreaterThanOrEqualTo":0,"riferimentoIdGreaterThan":0,"riferimentoIdLessThan":0,"riferimentoIdLessThanOrEqualTo":0,"riferimentoIdNotEqualTo":0,"riferimentoIdBetween":[0],"riferimentoIdIn":[0],"notaTesto":"String","notaTestoStartsWith":"String","notaTestoEndsWith":"String","notaTestoContains":"String","notaTestoLike":"String","notaTestoBetween":["String"],"notaTestoIn":["String"],"isPerVerbale":false,"tagNotifiche":"String","tagNotificheStartsWith":"String","tagNotificheEndsWith":"String","tagNotificheContains":"String","tagNotificheLike":"String","tagNotificheBetween":["String"],"tagNotificheIn":["String"],"testoVerbaleId":0,"testoVerbaleIdGreaterThanOrEqualTo":0,"testoVerbaleIdGreaterThan":0,"testoVerbaleIdLessThan":0,"testoVerbaleIdLessThanOrEqualTo":0,"testoVerbaleIdNotEqualTo":0,"testoVerbaleIdBetween":[0],"testoVerbaleIdIn":[0],"isNotaAutomatica":false,"isEvidenziata":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,"utenteId":0,"contattoId":0,"tabella":"String","riferimentoId":0,"notaTesto":"String","isPerVerbale":false,"tagNotifiche":"String","testoVerbaleId":0,"isNotaAutomatica":false,"isEvidenziata":false}],"meta":{"String":"String"},"responseStatus":{"errorCode":"String","message":"String","stackTrace":"String","errors":[{"errorCode":"String","fieldName":"String","message":"String","meta":{"String":"String"}}],"meta":{"String":"String"}}}