# Execute Sql from the url returning CSV

`GetByQueryCsv`

`GET /api/Sql/csv/{query}`

- [OpenAPI fragment](https://www.lusid.com/docs/api/luminesce/endpoints/sql-execution/GetByQueryCsv.json)
- [Rendered page](https://www.lusid.com/docs/api/luminesce/endpoints/sql-execution/GetByQueryCsv)


Returns data from a simple single-line query execution which is specified on the url.
e.g. select ^ from Sys.Field order by 1, 2, returned in the format of the method name.

The following error codes are to be anticipated with standard Problem Detail reports:
400 BadRequest - something failed with the execution or parsing of your query
401 Unauthorized
403 Forbidden


[< Sql Execution](https://www.lusid.com/docs/api/luminesce/endpoints/sql-execution/llms.txt)