List runs for the given sql

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 this run.

sqlId

integer, The ID of this sql.

state

string, The state of this run.

isCancelRequested

boolean, True if run cancel requested, else false.

startedAt

string, The time the last run started.

finishedAt

string, The time that this run finished.

error

string, The error message for this run, if present.

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.