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>"
  }
}

Path Parameters

projectUuid · string · required

Body

application/json

sql · string · required

valuesColumns · object[] · required

Show child attributes

limit · number<double>

sortOnlyColumns · object[]

Metrics/table calculations needed for sort anchor CTEs but not for display. These are merged into valuesColumns for SQL generation in PivotQueryBuilder, but excluded from pivotDetails so they don't appear as chart series.

Show child attributes

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