Search queries that are not hidden
search_list_queries(
search_string = NULL,
database_id = NULL,
credential_id = NULL,
author_id = NULL,
archived = NULL,
state = NULL,
started_before = NULL,
started_after = NULL,
limit = NULL,
page_num = NULL,
order = NULL,
order_dir = NULL
)An array containing the following fields:
integer, The query ID.
integer, The database ID.
integer, The credential ID.
string, The SQL executed by the query.
integer, The author of the query.
boolean, The archival status of the requested item(s).
string,
string,
list, A list containing the following elements:
id integer,
state string, The state of the run. One of queued, running, succeeded, failed, and cancelled.
startedAt string, The time that the run started.
finishedAt string, The time that the run completed.
error string, The error message for this run, if present.
string optional. Space delimited search terms for searching queries by their SQL. Supports wild card characters "?" for any single character, and "*" for zero or more characters.
integer optional. The database ID.
integer optional. The credential ID.
integer optional. The author of the query.
boolean optional. The archival status of the requested item(s). Defaults to false.
array optional. The state of the last run. One or more of queued, running, succeeded, failed, and cancelled.
string optional. An upper bound for the start date of the last run.
string optional. A lower bound for the start date of the last run.
integer optional. Number of results to return. Defaults to 10. Maximum allowed is 50.
integer optional. Page number of the results to return. Defaults to the first page, 1.
string optional. The field on which to order the result set. Defaults to last_run_started_at. Must be one of: last_run_started_at.
string optional. Direction in which to sort, either asc (ascending) or desc (descending) defaulting to desc.