Gemma.WebApi

ArticoloDistintaQuery

**ArticoloDistintaQuery** 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
ArticoloPadreId	query	int?	No
ArticoloPadreIdGreaterThanOrEqualTo	query	int?	No
ArticoloPadreIdGreaterThan	query	int?	No
ArticoloPadreIdLessThan	query	int?	No
ArticoloPadreIdLessThanOrEqualTo	query	int?	No
ArticoloPadreIdNotEqualTo	query	int?	No
ArticoloPadreIdBetween	query	Nullable<Int32>[]	No
ArticoloPadreIdIn	query	Nullable<Int32>[]	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	Nullable<Int32>[]	No
ArticoloIdIn	query	Nullable<Int32>[]	No
Qta	query	decimal?	No
QtaGreaterThanOrEqualTo	query	decimal?	No
QtaGreaterThan	query	decimal?	No
QtaLessThan	query	decimal?	No
QtaLessThanOrEqualTo	query	decimal?	No
QtaNotEqualTo	query	decimal?	No
QtaBetween	query	decimal[]	No
QtaIn	query	decimal[]	No
Configurazioni	query	string	No
ConfigurazioniStartsWith	query	string	No
ConfigurazioniEndsWith	query	string	No
ConfigurazioniContains	query	string	No
ConfigurazioniLike	query	string	No
ConfigurazioniBetween	query	string[]	No
ConfigurazioniIn	query	string[]	No
ItemLine	query	int?	No
ItemLineGreaterThanOrEqualTo	query	int?	No
ItemLineGreaterThan	query	int?	No
ItemLineLessThan	query	int?	No
ItemLineLessThanOrEqualTo	query	int?	No
ItemLineNotEqualTo	query	int?	No
ItemLineBetween	query	int[]	No
ItemLineIn	query	int[]	No
Reference	query	string	No
ReferenceStartsWith	query	string	No
ReferenceEndsWith	query	string	No
ReferenceContains	query	string	No
ReferenceLike	query	string	No
ReferenceBetween	query	string[]	No
ReferenceIn	query	string[]	No
Value	query	string	No
ValueStartsWith	query	string	No
ValueEndsWith	query	string	No
ValueContains	query	string	No
ValueLike	query	string	No
ValueBetween	query	string[]	No
ValueIn	query	string[]	No
Manufacturer	query	string	No
ManufacturerStartsWith	query	string	No
ManufacturerEndsWith	query	string	No
ManufacturerContains	query	string	No
ManufacturerLike	query	string	No
ManufacturerBetween	query	string[]	No
ManufacturerIn	query	string[]	No
PcbFootprint	query	string	No
PcbFootprintStartsWith	query	string	No
PcbFootprintEndsWith	query	string	No
PcbFootprintContains	query	string	No
PcbFootprintLike	query	string	No
PcbFootprintBetween	query	string[]	No
PcbFootprintIn	query	string[]	No
Mounting	query	string	No
MountingStartsWith	query	string	No
MountingEndsWith	query	string	No
MountingContains	query	string	No
MountingLike	query	string	No
MountingBetween	query	string[]	No
MountingIn	query	string[]	No
Smd	query	string	No
SmdStartsWith	query	string	No
SmdEndsWith	query	string	No
SmdContains	query	string	No
SmdLike	query	string	No
SmdBetween	query	string[]	No
SmdIn	query	string[]	No
Section	query	string	No
SectionStartsWith	query	string	No
SectionEndsWith	query	string	No
SectionContains	query	string	No
SectionLike	query	string	No
SectionBetween	query	string[]	No
SectionIn	query	string[]	No
Notes	query	string	No
NotesStartsWith	query	string	No
NotesEndsWith	query	string	No
NotesContains	query	string	No
NotesLike	query	string	No
NotesBetween	query	string[]	No
NotesIn	query	string[]	No
ManufacturerPn	query	string	No
ManufacturerPnStartsWith	query	string	No
ManufacturerPnEndsWith	query	string	No
ManufacturerPnContains	query	string	No
ManufacturerPnLike	query	string	No
ManufacturerPnBetween	query	string[]	No
ManufacturerPnIn	query	string[]	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

**ArticoloDistinta** Parameters:
Name	Parameter	Data Type	Required
Id	form	int	No
ArticoloPadreId	form	int?	No
ArticoloId	form	int?	No
Qta	form	decimal	No
Configurazioni	form	string	No
ItemLine	form	int	No
Reference	form	string	No
Value	form	string	No
Manufacturer	form	string	No
PcbFootprint	form	string	No
Mounting	form	string	No
Smd	form	string	No
Section	form	string	No
Notes	form	string	No
ManufacturerPn	form	string	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 .jsv suffix or ?format=jsv

HTTP + JSV

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

POST /jsv/reply/ArticoloDistintaQuery HTTP/1.1 
Host: gemma.api.kerberos.energy 
Accept: text/jsv
Content-Type: text/jsv
Content-Length: length

{
	id: 0,
	idGreaterThanOrEqualTo: 0,
	idGreaterThan: 0,
	idLessThan: 0,
	idLessThanOrEqualTo: 0,
	idNotEqualTo: 0,
	idBetween: 
	[
		0
	],
	idIn: 
	[
		0
	],
	articoloPadreId: 0,
	articoloPadreIdGreaterThanOrEqualTo: 0,
	articoloPadreIdGreaterThan: 0,
	articoloPadreIdLessThan: 0,
	articoloPadreIdLessThanOrEqualTo: 0,
	articoloPadreIdNotEqualTo: 0,
	articoloPadreIdBetween: 
	[
		0
	],
	articoloPadreIdIn: 
	[
		0
	],
	articoloId: 0,
	articoloIdGreaterThanOrEqualTo: 0,
	articoloIdGreaterThan: 0,
	articoloIdLessThan: 0,
	articoloIdLessThanOrEqualTo: 0,
	articoloIdNotEqualTo: 0,
	articoloIdBetween: 
	[
		0
	],
	articoloIdIn: 
	[
		0
	],
	qta: 0,
	qtaGreaterThanOrEqualTo: 0,
	qtaGreaterThan: 0,
	qtaLessThan: 0,
	qtaLessThanOrEqualTo: 0,
	qtaNotEqualTo: 0,
	qtaBetween: 
	[
		0
	],
	qtaIn: 
	[
		0
	],
	configurazioni: String,
	configurazioniStartsWith: String,
	configurazioniEndsWith: String,
	configurazioniContains: String,
	configurazioniLike: String,
	configurazioniBetween: 
	[
		String
	],
	configurazioniIn: 
	[
		String
	],
	itemLine: 0,
	itemLineGreaterThanOrEqualTo: 0,
	itemLineGreaterThan: 0,
	itemLineLessThan: 0,
	itemLineLessThanOrEqualTo: 0,
	itemLineNotEqualTo: 0,
	itemLineBetween: 
	[
		0
	],
	itemLineIn: 
	[
		0
	],
	reference: String,
	referenceStartsWith: String,
	referenceEndsWith: String,
	referenceContains: String,
	referenceLike: String,
	referenceBetween: 
	[
		String
	],
	referenceIn: 
	[
		String
	],
	value: String,
	valueStartsWith: String,
	valueEndsWith: String,
	valueContains: String,
	valueLike: String,
	valueBetween: 
	[
		String
	],
	valueIn: 
	[
		String
	],
	manufacturer: String,
	manufacturerStartsWith: String,
	manufacturerEndsWith: String,
	manufacturerContains: String,
	manufacturerLike: String,
	manufacturerBetween: 
	[
		String
	],
	manufacturerIn: 
	[
		String
	],
	pcbFootprint: String,
	pcbFootprintStartsWith: String,
	pcbFootprintEndsWith: String,
	pcbFootprintContains: String,
	pcbFootprintLike: String,
	pcbFootprintBetween: 
	[
		String
	],
	pcbFootprintIn: 
	[
		String
	],
	mounting: String,
	mountingStartsWith: String,
	mountingEndsWith: String,
	mountingContains: String,
	mountingLike: String,
	mountingBetween: 
	[
		String
	],
	mountingIn: 
	[
		String
	],
	smd: String,
	smdStartsWith: String,
	smdEndsWith: String,
	smdContains: String,
	smdLike: String,
	smdBetween: 
	[
		String
	],
	smdIn: 
	[
		String
	],
	section: String,
	sectionStartsWith: String,
	sectionEndsWith: String,
	sectionContains: String,
	sectionLike: String,
	sectionBetween: 
	[
		String
	],
	sectionIn: 
	[
		String
	],
	notes: String,
	notesStartsWith: String,
	notesEndsWith: String,
	notesContains: String,
	notesLike: String,
	notesBetween: 
	[
		String
	],
	notesIn: 
	[
		String
	],
	manufacturerPn: String,
	manufacturerPnStartsWith: String,
	manufacturerPnEndsWith: String,
	manufacturerPnContains: String,
	manufacturerPnLike: String,
	manufacturerPnBetween: 
	[
		String
	],
	manufacturerPnIn: 
	[
		String
	],
	skip: 0,
	take: 0,
	orderBy: String,
	orderByDesc: String,
	include: String,
	fields: String,
	meta: 
	{
		String: String
	}
}

HTTP/1.1 200 OK
Content-Type: text/jsv
Content-Length: length

{
	offset: 0,
	total: 0,
	results: 
	[
		{
			id: 0,
			articoloPadreId: 0,
			articoloId: 0,
			qta: 0,
			configurazioni: String,
			itemLine: 0,
			reference: String,
			value: String,
			manufacturer: String,
			pcbFootprint: String,
			mounting: String,
			smd: String,
			section: String,
			notes: String,
			manufacturerPn: String
		}
	],
	meta: 
	{
		String: String
	},
	responseStatus: 
	{
		errorCode: String,
		message: String,
		stackTrace: String,
		errors: 
		[
			{
				errorCode: String,
				fieldName: String,
				message: String,
				meta: 
				{
					String: String
				}
			}
		],
		meta: 
		{
			String: String
		}
	}
}