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; 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