Counted and summed figures over a whole allowed table, computed by the database

post/datasources/{id}/aggregate

Counted and summed figures over a whole allowed table, computed by the database: one to five measures, up to three groupings, a time grain, conditions. A personal column may be counted, not grouped by or shown; a restricted one is used nowhere.

Before you call

Credential: Authorization: Bearer $KEY
Scope: hosting:read
Sdk: hosting.dataSource.aggregate
Cli: hosting data source aggregate

Parameters

idstring (uuid)required
In the path

Request bodyapplication/json, required

tablestringrequired
measureslist of objectrequired
- fnstringrequired
- columnstring

Responses

200application/json
Success
object
400application/json
The request was malformed
- errorstringrequired
- messagestring
401application/json
No valid credential
- errorstringrequired
- messagestring
403application/json
The credential lacks the scope, origin or address
- errorstringrequired
- messagestring
429application/json
Over the key's rate limit; see Retry-After
- errorstringrequired
- messagestring

Example request

curl -X POST 'https://api.rivier.ai/datasources/{id}/aggregate' \
  -H 'Authorization: Bearer $KEY' \
  -H 'Content-Type: application/json' \
  -d '{
  "table": "string",
  "measures": [
    {
      "fn": "string"
    }
  ]
}'

$KEY stands for your own key. No key is shown or kept on this site.

This page as Markdown