Path Parameters
Body
application/json
API
Reference
- GETGet apiv1projects sqlrunnertables
- GETGet apiv1projects sqlrunnerfields
- POSTPost apiv1projects sqlrunnerrun
- POSTPost apiv1projects sqlrunnerrunpivotquery
- GETGet apiv1projects sqlrunnerresults
- GETGet apiv1projects sqlrunnersaved
- DELDelete apiv1projects sqlrunnersaved
- PATCHPatch apiv1projects sqlrunnersaved
- GETGet apiv1projects sqlrunnersavedslug
- GETGet apiv1projects sqlrunnersavedslug results job
- GETGet apiv1projects sqlrunnersaved results job
- POSTPost apiv1projects sqlrunnersaved
- POSTPost apiv1projects sqlrunnerrefresh catalog
- POSTPost apiv1projects sqlrunnervirtual view
- PUTPut apiv1projects sqlrunnervirtual view
- DELDelete apiv1projects sqlrunnervirtual view
- POSTPost apiv1projects sqlrunnerpreview
- POSTPost apiv1projects sqlrunnerpull request
- GET
cURL
Copy
Ask AI
curl --request POST \
--url http://api/v1/projects/{projectUuid}/sqlRunner/runPivotQuery \
--header 'Content-Type: application/json' \
--data '
{
"limit": 123,
"sql": "<string>",
"sortBy": [
{
"direction": "ASC",
"reference": "<string>"
}
],
"groupByColumns": [
{
"reference": "<string>"
}
],
"valuesColumns": [
{
"aggregation": "sum",
"reference": "<string>"
}
],
"indexColumn": {
"type": "time",
"reference": "<string>"
},
"savedSqlUuid": "<string>"
}
'Copy
Ask AI
{
"results": {
"jobId": "<string>"
},
"status": "ok"
}SQL runner
Post apiv1projects sqlrunnerrunpivotquery
POST
/
api
/
v1
/
projects
/
{projectUuid}
/
sqlRunner
/
runPivotQuery
cURL
Copy
Ask AI
curl --request POST \
--url http://api/v1/projects/{projectUuid}/sqlRunner/runPivotQuery \
--header 'Content-Type: application/json' \
--data '
{
"limit": 123,
"sql": "<string>",
"sortBy": [
{
"direction": "ASC",
"reference": "<string>"
}
],
"groupByColumns": [
{
"reference": "<string>"
}
],
"valuesColumns": [
{
"aggregation": "sum",
"reference": "<string>"
}
],
"indexColumn": {
"type": "time",
"reference": "<string>"
},
"savedSqlUuid": "<string>"
}
'Copy
Ask AI
{
"results": {
"jobId": "<string>"
},
"status": "ok"
}⌘I