Skip to main content

Execute Sql from the body returning CSV

/api/Sql/csv

PutByQueryCsv

For more complex LuminesceSql a PUT will allow for longer and line break delimited Sql, whic will be returned in the format of the method name. e.g.:

@@cutoff = select #2020-02-01#;
@issues = select Id, SortId, Summary, Created, Updated from Dev.Jira.Issue where Project='HC' and Created < @@cutoff and Updated > @@cutoff;

select i.Id, i.SortId, i.Summary, LinkText, LinkedIssueId, LinkedIssueSortId, LinkedIssueSummary
from @issues i
inner join Dev.Jira.Issue.Link li
    on i.Id = li.IssueId

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