# ForePaaS JSON query format

!> This page describes the **ForePaaS Legacy Platform**, which no longer accepts new signups. If you are using OVHcloud Data Platform, see [the Analytics Manager](/en/product/am/index).

The ForePaaS JSON query format uses multiple parameters as input and output to describe a query and its results.

The following articles document each individual query parameters, and illustrate their impact using a simple example of the revenue of a company. The available dataset is given as follows:

![problematique](picts/dataset.png ':size=300')


{Reference: 'data' parameter}(#/en/technical/api-reference/qb/data.md)
{Reference: 'scale' parameter}(#/en/technical/api-reference/qb/scale.md)
{Reference: 'filter' parameter}(#/en/technical/api-reference/qb/filter.md)
{Reference: other parameters}(#/en/technical/api-reference/qb/others.md)

---
## Complete reference of parameters

The JSON configuration for a query takes in the following parameters.
      
| Parameter name | required | example | description |
| --- | --- | --- | --- |
| data.fields | yes | { "income":["sum"],"expense":["sum"]} | Fields to return and their compute mode(s) (can be: select, select\_distinct, sum, min, max, avg, count, count\_distinct)          |
| data.skip | no | 10 | Number of rows to skip |
| data.limit | no | 100 | Number of rows returned |
| data.hints | no | true/false | Total number of lines corresponding to the query (omitting data.limit) |
| filter | no | {  "date": {          "between": ["1420066800,1428962399"]  },  "client\_code": {          "in": ["08KD", "09CC"]  },  "creation\_date": {          "eq": ["2018-01-01"]  }}  | Apply filter(s) on the data to query. Filters can be: in, not\_in, between, not\_between, eq, not\_equal, like, not\_like, is\_null, is\_not\_null, gt (\>), gte (\>=), lt (\<), lte (\<=) |
| scale.fields | no | ["date",["client\_code", "employee\_id"]] | Apply scale (group by) to the query. It can be a computed scale, or more than 1 scale. |
| evol.scale | no | "year" | scale to apply for evolution (weekday;week; month; quarter; semester; year) |
| evol.mode | no | "date""weekday" | date : comparison with same dateweekday : comparison with respecting the same weekday. |
| evol.depth | no | 5 | How much evolutions you want to get back |
| total.all | no | []["client\_code"] | total queries per distinct scales (optional) |
| total.x | no | ["client\_code"] | Total queries for a specific attribute |
| order | no | {   "date":"asc"} | order query output (asc or desc, asc by default) |
| table\_name | no | "prim\_vehicles" | Force to query in a specific table |
| database\_name | no | "data\_prim""data\_mart" | Force to query in a specific layer |