queries_get {civis}

Get details about a query

Description

Get details about a query

Usage

queries_get(id)

Arguments

id

integer required. The query ID.

Value

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,

startedAt

string, The start time of the last run.

finishedAt

string, The end time of the last run.

state

string, The state of the last run. One of queued, running, succeeded, failed, and cancelled.

lastRunId

integer, The ID of the last run.

hidden

boolean, The hidden status of the item.

archived

string, The archival status of the requested item(s).

name

string, The name of the query.

author

list, A list containing the following elements:

• id integer, The ID of this user.

• name string, This user's name.

• username string, This user's username.

• initials string, This user's initials.

• online boolean, Whether this user is online.

reportId

integer, The ID of the report associated with this query.