Gemma.WebApi

RmaQuery

**Requires Authentication**
Required role:	Admin

**RmaQuery** 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
Numero	query	int?	No
NumeroGreaterThanOrEqualTo	query	int?	No
NumeroGreaterThan	query	int?	No
NumeroLessThan	query	int?	No
NumeroLessThanOrEqualTo	query	int?	No
NumeroNotEqualTo	query	int?	No
NumeroBetween	query	int[]	No
NumeroIn	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
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
SoggettoId	query	int?	No
SoggettoIdGreaterThanOrEqualTo	query	int?	No
SoggettoIdGreaterThan	query	int?	No
SoggettoIdLessThan	query	int?	No
SoggettoIdLessThanOrEqualTo	query	int?	No
SoggettoIdNotEqualTo	query	int?	No
SoggettoIdBetween	query	int[]	No
SoggettoIdIn	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
GravitaId	query	int?	No
GravitaIdGreaterThanOrEqualTo	query	int?	No
GravitaIdGreaterThan	query	int?	No
GravitaIdLessThan	query	int?	No
GravitaIdLessThanOrEqualTo	query	int?	No
GravitaIdNotEqualTo	query	int?	No
GravitaIdBetween	query	int[]	No
GravitaIdIn	query	int[]	No
DTRitorno	query	string	No
DTRitornoStartsWith	query	string	No
DTRitornoEndsWith	query	string	No
DTRitornoContains	query	string	No
DTRitornoLike	query	string	No
DTRitornoBetween	query	string[]	No
DTRitornoIn	query	string[]	No
CausaleReso	query	string	No
CausaleResoStartsWith	query	string	No
CausaleResoEndsWith	query	string	No
CausaleResoContains	query	string	No
CausaleResoLike	query	string	No
CausaleResoBetween	query	string[]	No
CausaleResoIn	query	string[]	No
IsApprovata	query	bool?	No
DataApprovazione	query	DateTime?	No
DataApprovazioneGreaterThanOrEqualTo	query	DateTime?	No
DataApprovazioneGreaterThan	query	DateTime?	No
DataApprovazioneLessThan	query	DateTime?	No
DataApprovazioneLessThanOrEqualTo	query	DateTime?	No
DataApprovazioneNotEqualTo	query	DateTime?	No
DataApprovazioneBetween	query	DateTime[]	No
DataApprovazioneIn	query	DateTime[]	No
ContattoApprovazioneId	query	int?	No
ContattoApprovazioneIdGreaterThanOrEqualTo	query	int?	No
ContattoApprovazioneIdGreaterThan	query	int?	No
ContattoApprovazioneIdLessThan	query	int?	No
ContattoApprovazioneIdLessThanOrEqualTo	query	int?	No
ContattoApprovazioneIdNotEqualTo	query	int?	No
ContattoApprovazioneIdBetween	query	int[]	No
ContattoApprovazioneIdIn	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
IsChiusa	query	bool?	No
DataChiusura	query	DateTime?	No
DataChiusuraGreaterThanOrEqualTo	query	DateTime?	No
DataChiusuraGreaterThan	query	DateTime?	No
DataChiusuraLessThan	query	DateTime?	No
DataChiusuraLessThanOrEqualTo	query	DateTime?	No
DataChiusuraNotEqualTo	query	DateTime?	No
DataChiusuraBetween	query	DateTime[]	No
DataChiusuraIn	query	DateTime[]	No
FileId	query	int?	No
FileIdGreaterThanOrEqualTo	query	int?	No
FileIdGreaterThan	query	int?	No
FileIdLessThan	query	int?	No
FileIdLessThanOrEqualTo	query	int?	No
FileIdNotEqualTo	query	int?	No
FileIdBetween	query	int[]	No
FileIdIn	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

**Rma** Parameters:
Name	Parameter	Data Type	Required
Id	form	int	No
Numero	form	int	No
Data	form	DateTime	No
DataCreazione	form	DateTime	No
SoggettoId	form	int	No
ContattoId	form	int	No
GravitaId	form	int	No
DTRitorno	form	string	No
CausaleReso	form	string	No
IsApprovata	form	bool	No
DataApprovazione	form	DateTime	No
ContattoApprovazioneId	form	int	No
Note	form	string	No
IsChiusa	form	bool	No
DataChiusura	form	DateTime	No
FileId	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/RmaQuery 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],"numero":0,"numeroGreaterThanOrEqualTo":0,"numeroGreaterThan":0,"numeroLessThan":0,"numeroLessThanOrEqualTo":0,"numeroNotEqualTo":0,"numeroBetween":[0],"numeroIn":[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"],"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"],"soggettoId":0,"soggettoIdGreaterThanOrEqualTo":0,"soggettoIdGreaterThan":0,"soggettoIdLessThan":0,"soggettoIdLessThanOrEqualTo":0,"soggettoIdNotEqualTo":0,"soggettoIdBetween":[0],"soggettoIdIn":[0],"contattoId":0,"contattoIdGreaterThanOrEqualTo":0,"contattoIdGreaterThan":0,"contattoIdLessThan":0,"contattoIdLessThanOrEqualTo":0,"contattoIdNotEqualTo":0,"contattoIdBetween":[0],"contattoIdIn":[0],"gravitaId":0,"gravitaIdGreaterThanOrEqualTo":0,"gravitaIdGreaterThan":0,"gravitaIdLessThan":0,"gravitaIdLessThanOrEqualTo":0,"gravitaIdNotEqualTo":0,"gravitaIdBetween":[0],"gravitaIdIn":[0],"dtRitorno":"String","dtRitornoStartsWith":"String","dtRitornoEndsWith":"String","dtRitornoContains":"String","dtRitornoLike":"String","dtRitornoBetween":["String"],"dtRitornoIn":["String"],"causaleReso":"String","causaleResoStartsWith":"String","causaleResoEndsWith":"String","causaleResoContains":"String","causaleResoLike":"String","causaleResoBetween":["String"],"causaleResoIn":["String"],"isApprovata":false,"dataApprovazione":"\/Date(-62135596800000-0000)\/","dataApprovazioneGreaterThanOrEqualTo":"\/Date(-62135596800000-0000)\/","dataApprovazioneGreaterThan":"\/Date(-62135596800000-0000)\/","dataApprovazioneLessThan":"\/Date(-62135596800000-0000)\/","dataApprovazioneLessThanOrEqualTo":"\/Date(-62135596800000-0000)\/","dataApprovazioneNotEqualTo":"\/Date(-62135596800000-0000)\/","dataApprovazioneBetween":["0001-01-01T00:00:00"],"dataApprovazioneIn":["0001-01-01T00:00:00"],"contattoApprovazioneId":0,"contattoApprovazioneIdGreaterThanOrEqualTo":0,"contattoApprovazioneIdGreaterThan":0,"contattoApprovazioneIdLessThan":0,"contattoApprovazioneIdLessThanOrEqualTo":0,"contattoApprovazioneIdNotEqualTo":0,"contattoApprovazioneIdBetween":[0],"contattoApprovazioneIdIn":[0],"note":"String","noteStartsWith":"String","noteEndsWith":"String","noteContains":"String","noteLike":"String","noteBetween":["String"],"noteIn":["String"],"isChiusa":false,"dataChiusura":"\/Date(-62135596800000-0000)\/","dataChiusuraGreaterThanOrEqualTo":"\/Date(-62135596800000-0000)\/","dataChiusuraGreaterThan":"\/Date(-62135596800000-0000)\/","dataChiusuraLessThan":"\/Date(-62135596800000-0000)\/","dataChiusuraLessThanOrEqualTo":"\/Date(-62135596800000-0000)\/","dataChiusuraNotEqualTo":"\/Date(-62135596800000-0000)\/","dataChiusuraBetween":["0001-01-01T00:00:00"],"dataChiusuraIn":["0001-01-01T00:00:00"],"fileId":0,"fileIdGreaterThanOrEqualTo":0,"fileIdGreaterThan":0,"fileIdLessThan":0,"fileIdLessThanOrEqualTo":0,"fileIdNotEqualTo":0,"fileIdBetween":[0],"fileIdIn":[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,"numero":0,"soggettoId":0,"contattoId":0,"gravitaId":0,"dtRitorno":"String","causaleReso":"String","isApprovata":false,"contattoApprovazioneId":0,"note":"String","isChiusa":false,"fileId":0}],"meta":{"String":"String"},"responseStatus":{"errorCode":"String","message":"String","stackTrace":"String","errors":[{"errorCode":"String","fieldName":"String","message":"String","meta":{"String":"String"}}],"meta":{"String":"String"}}}