Description Usage Arguments Value
Get details about a query
1 | queries_get(id)
|
id |
integer required. The query ID. |
A list containing the following elements:
id |
integer, The query ID. |
database |
integer, The database ID. |
sql |
string, The SQL to execute. |
credential |
integer, The credential ID. |
resultRows |
array, A preview of rows returned by the query. |
resultColumns |
array, A preview of columns returned by the query. |
scriptId |
integer, The ID of the script associated with this query. |
exception |
string, Deprecated and not used. |
error |
string, The error message for this run, if present. |
createdAt |
string, |
updatedAt |
string, |
finishedAt |
string, The end time of the last run. |
state |
string, The state of the last run. |
lastRunId |
integer, The ID of the last run. |
hidden |
boolean, The hidden status of the item. |
name |
string, The name of the query. |
author |
list, A list containing the following elements:
|
startedAt |
string, The start time of the last run. |
reportId |
integer, The ID of the report associated with this query. |
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.