Gemma.WebApi

ArticoloNewsQuery

**Requires Authentication**
Required role:	Admin

**ArticoloNewsQuery** Parameters:
Name	Parameter	Data Type	Required
NewsId	query	int?	No
NewsIdGreaterThanOrEqualTo	query	int?	No
NewsIdGreaterThan	query	int?	No
NewsIdLessThan	query	int?	No
NewsIdLessThanOrEqualTo	query	int?	No
NewsIdNotEqualTo	query	int?	No
NewsIdBetween	query	int[]	No
NewsIdIn	query	int[]	No
ArticoloId	query	int?	No
ArticoloIdGreaterThanOrEqualTo	query	int?	No
ArticoloIdGreaterThan	query	int?	No
ArticoloIdLessThan	query	int?	No
ArticoloIdLessThanOrEqualTo	query	int?	No
ArticoloIdNotEqualTo	query	int?	No
ArticoloIdBetween	query	int[]	No
ArticoloIdIn	query	int[]	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
DescrizioneCnId	query	int?	No
DescrizioneCnIdGreaterThanOrEqualTo	query	int?	No
DescrizioneCnIdGreaterThan	query	int?	No
DescrizioneCnIdLessThan	query	int?	No
DescrizioneCnIdLessThanOrEqualTo	query	int?	No
DescrizioneCnIdNotEqualTo	query	int?	No
DescrizioneCnIdBetween	query	int[]	No
DescrizioneCnIdIn	query	int[]	No
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

**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

**ArticoloNews** Parameters:
Name	Parameter	Data Type	Required
NewsId	form	int	No
ArticoloId	form	int	No
OrdineVista	form	int	No
DescrizioneCnId	form	int	No
Id	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/ArticoloNewsQuery HTTP/1.1 
Host: gemma.api.kerberos.energy 
Accept: text/csv
Content-Type: text/csv
Content-Length: length

{"newsId":0,"newsIdGreaterThanOrEqualTo":0,"newsIdGreaterThan":0,"newsIdLessThan":0,"newsIdLessThanOrEqualTo":0,"newsIdNotEqualTo":0,"newsIdBetween":[0],"newsIdIn":[0],"articoloId":0,"articoloIdGreaterThanOrEqualTo":0,"articoloIdGreaterThan":0,"articoloIdLessThan":0,"articoloIdLessThanOrEqualTo":0,"articoloIdNotEqualTo":0,"articoloIdBetween":[0],"articoloIdIn":[0],"ordineVista":0,"ordineVistaGreaterThanOrEqualTo":0,"ordineVistaGreaterThan":0,"ordineVistaLessThan":0,"ordineVistaLessThanOrEqualTo":0,"ordineVistaNotEqualTo":0,"ordineVistaBetween":[0],"ordineVistaIn":[0],"descrizioneCnId":0,"descrizioneCnIdGreaterThanOrEqualTo":0,"descrizioneCnIdGreaterThan":0,"descrizioneCnIdLessThan":0,"descrizioneCnIdLessThanOrEqualTo":0,"descrizioneCnIdNotEqualTo":0,"descrizioneCnIdBetween":[0],"descrizioneCnIdIn":[0],"id":0,"idGreaterThanOrEqualTo":0,"idGreaterThan":0,"idLessThan":0,"idLessThanOrEqualTo":0,"idNotEqualTo":0,"idBetween":[0],"idIn":[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":[{"newsId":0,"articoloId":0,"ordineVista":0,"descrizioneCnId":0,"id":0}],"meta":{"String":"String"},"responseStatus":{"errorCode":"String","message":"String","stackTrace":"String","errors":[{"errorCode":"String","fieldName":"String","message":"String","meta":{"String":"String"}}],"meta":{"String":"String"}}}