Run SQL pivot query

Run a SQL pivot query

POST /api/v1/projects/{projectUuid}/sqlRunner/runPivotQuery

Error

A valid request URL is required to generate request examples

200

{
  "results": {
    "jobId": "<string>"
  },
  "status": "ok"
}

Path Parameters

projectUuid · string · required

Body

application/json

sql · string · required

valuesColumns · object[] · required

Show child attributes

limit · number<double>

metricsAsRows · boolean

When true, metrics are displayed as rows instead of columns. This affects column limit calculation - when metrics are rows, we don't need to divide the column limit by the number of metrics. Defaults to false for backward compatibility (SQL runner behavior).

sortBy · object[]

Show child attributes

groupByColumns · object[]

Show child attributes

indexColumn · object

object

object[]

Show child attributes

savedSqlUuid · string

Response

200

application/json

Success

results · object · required

Show child attributes

status · enum<string> · required

Available options: ok