| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| 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 |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| 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 |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| 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 |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| 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
The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.
POST /csv/reply/ArticoloDistintaQuery 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],"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/csv
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"}}}