Query from API

[runa-danishdin]

Hi Team,

I am confused by the documentation regarding running a query from API
https://docs.lightdash.com/api/v1/#tag/Exploring/operation/postRunQuery

Say I have a Lightdash and there is a table called products.
From the UI, I run the SQL command
"Select codes from products"
Which returns 1 column with all of the product codes.

How do I run this from the API?

[owlas]

Hey @runa-danishdin you can run a raw sql query by posting to this endpoint, this was missing from the documentation, which I've fixed on this PR: #6296

POST /api/v1/projects/{projectUuid}/sqlQuery

{
  "sql": "select codes from products"
}

[owlas]

Hey @runa-danishdin this is fixed now btw: #6296