scripts_list_sql_runs {civis}

List runs for the given sql

Description

List runs for the given sql

Usage

scripts_list_sql_runs(
  id,
  limit = NULL,
  page_num = NULL,
  order = NULL,
  order_dir = NULL
)

Arguments

id

integer required. The ID of the sql.

limit

integer optional. Number of results to return. Defaults to 20. Maximum allowed is 100.

page_num

integer optional. Page number of the results to return. Defaults to the first page, 1.

order

string optional. The field on which to order the result set. Defaults to id. Must be one of: id.

order_dir

string optional. Direction in which to sort, either asc (ascending) or desc (descending) defaulting to desc.

Value

An array containing the following fields:

id

integer, The ID of the run.

sqlId

integer, The ID of the sql.

state

string, The state of the run, one of 'queued' 'running' 'succeeded' 'failed' or 'cancelled'.

isCancelRequested

boolean, True if run cancel requested, else false.

createdAt

string, The time the run was created.

startedAt

string, The time the run started at.

finishedAt

string, The time the run completed.

error

string, The error, if any, returned by the run.

output

array, An array containing the following fields:

• outputName string, The name of the output file.

• fileId integer, The unique ID of the output file.

• path string, The temporary link to download this output file, valid for 36 hours.

outputCachedOn

string, The time that the output was originally exported, if a cache entry was used by the run.