Gemma.WebApi

FileQuery

**Requires Authentication**
Required role:	Admin

**FileQuery** 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
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
DataCreazione	query	DateTime?	No
DataCreazioneGreaterThanOrEqualTo	query	DateTime?	No
DataCreazioneGreaterThan	query	DateTime?	No
DataCreazioneLessThan	query	DateTime?	No
DataCreazioneLessThanOrEqualTo	query	DateTime?	No
DataCreazioneNotEqualTo	query	DateTime?	No
DataCreazioneBetween	query	DateTime[]	No
DataCreazioneIn	query	DateTime[]	No
UtenteCreaId	query	int?	No
UtenteCreaIdGreaterThanOrEqualTo	query	int?	No
UtenteCreaIdGreaterThan	query	int?	No
UtenteCreaIdLessThan	query	int?	No
UtenteCreaIdLessThanOrEqualTo	query	int?	No
UtenteCreaIdNotEqualTo	query	int?	No
UtenteCreaIdBetween	query	int[]	No
UtenteCreaIdIn	query	int[]	No
DataAggiornamento	query	DateTime?	No
DataAggiornamentoGreaterThanOrEqualTo	query	DateTime?	No
DataAggiornamentoGreaterThan	query	DateTime?	No
DataAggiornamentoLessThan	query	DateTime?	No
DataAggiornamentoLessThanOrEqualTo	query	DateTime?	No
DataAggiornamentoNotEqualTo	query	DateTime?	No
DataAggiornamentoBetween	query	DateTime[]	No
DataAggiornamentoIn	query	DateTime[]	No
BinaryData	query	byte[]	No
IsSystemFolder	query	bool?	No
IsFolder	query	bool?	No
FolderId	query	int?	No
FolderIdGreaterThanOrEqualTo	query	int?	No
FolderIdGreaterThan	query	int?	No
FolderIdLessThan	query	int?	No
FolderIdLessThanOrEqualTo	query	int?	No
FolderIdNotEqualTo	query	int?	No
FolderIdBetween	query	int[]	No
FolderIdIn	query	int[]	No
UtenteAggiornaId	query	int?	No
UtenteAggiornaIdGreaterThanOrEqualTo	query	int?	No
UtenteAggiornaIdGreaterThan	query	int?	No
UtenteAggiornaIdLessThan	query	int?	No
UtenteAggiornaIdLessThanOrEqualTo	query	int?	No
UtenteAggiornaIdNotEqualTo	query	int?	No
UtenteAggiornaIdBetween	query	int[]	No
UtenteAggiornaIdIn	query	int[]	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

**File** Parameters:
Name	Parameter	Data Type	Required
Id	form	int	No
Nome	form	string	No
DataCreazione	form	DateTime	No
UtenteCreaId	form	int	No
DataAggiornamento	form	DateTime	No
BinaryData	form	byte[]	No
IsSystemFolder	form	bool	No
IsFolder	form	bool	No
FolderId	form	int	No
UtenteAggiornaId	form	int	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/FileQuery 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"],"dataCreazione":"\/Date(-62135596800000-0000)\/","dataCreazioneGreaterThanOrEqualTo":"\/Date(-62135596800000-0000)\/","dataCreazioneGreaterThan":"\/Date(-62135596800000-0000)\/","dataCreazioneLessThan":"\/Date(-62135596800000-0000)\/","dataCreazioneLessThanOrEqualTo":"\/Date(-62135596800000-0000)\/","dataCreazioneNotEqualTo":"\/Date(-62135596800000-0000)\/","dataCreazioneBetween":["0001-01-01T00:00:00"],"dataCreazioneIn":["0001-01-01T00:00:00"],"utenteCreaId":0,"utenteCreaIdGreaterThanOrEqualTo":0,"utenteCreaIdGreaterThan":0,"utenteCreaIdLessThan":0,"utenteCreaIdLessThanOrEqualTo":0,"utenteCreaIdNotEqualTo":0,"utenteCreaIdBetween":[0],"utenteCreaIdIn":[0],"dataAggiornamento":"\/Date(-62135596800000-0000)\/","dataAggiornamentoGreaterThanOrEqualTo":"\/Date(-62135596800000-0000)\/","dataAggiornamentoGreaterThan":"\/Date(-62135596800000-0000)\/","dataAggiornamentoLessThan":"\/Date(-62135596800000-0000)\/","dataAggiornamentoLessThanOrEqualTo":"\/Date(-62135596800000-0000)\/","dataAggiornamentoNotEqualTo":"\/Date(-62135596800000-0000)\/","dataAggiornamentoBetween":["0001-01-01T00:00:00"],"dataAggiornamentoIn":["0001-01-01T00:00:00"],"binaryData":"AA==","isSystemFolder":false,"isFolder":false,"folderId":0,"folderIdGreaterThanOrEqualTo":0,"folderIdGreaterThan":0,"folderIdLessThan":0,"folderIdLessThanOrEqualTo":0,"folderIdNotEqualTo":0,"folderIdBetween":[0],"folderIdIn":[0],"utenteAggiornaId":0,"utenteAggiornaIdGreaterThanOrEqualTo":0,"utenteAggiornaIdGreaterThan":0,"utenteAggiornaIdLessThan":0,"utenteAggiornaIdLessThanOrEqualTo":0,"utenteAggiornaIdNotEqualTo":0,"utenteAggiornaIdBetween":[0],"utenteAggiornaIdIn":[0],"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","utenteCreaId":0,"binaryData":"AA==","isSystemFolder":false,"isFolder":false,"folderId":0,"utenteAggiornaId":0}],"meta":{"String":"String"},"responseStatus":{"errorCode":"String","message":"String","stackTrace":"String","errors":[{"errorCode":"String","fieldName":"String","message":"String","meta":{"String":"String"}}],"meta":{"String":"String"}}}