| Column Name | Column Data Type |
|---|
farm_id Required Input Column
The farm ID of the task. | VARCHAR |
item_offset Required Input Column
Defines how far into the scrollable list to start the return of results. | BIGINT |
queue_ids Required Input Column
The queue IDs to include in the search. | VARCHAR[] |
Show child fields- queue_ids[]
|
filter_expressions Input Column
The filter expression, AND or OR, to use when searching among a group of search strings in a resource. You can use two groupings per search each within parenthesis (). | STRUCT(
"filters" STRUCT(
"date_time_filter" STRUCT(
"name" VARCHAR,
"operator" VARCHAR,
"date_time" TIMESTAMP_S
),
"parameter_filter" STRUCT(
"name" VARCHAR,
"operator" VARCHAR,
"value" VARCHAR
),
"search_term_filter" STRUCT(
"search_term" VARCHAR
),
"string_filter" STRUCT(
"name" VARCHAR,
"operator" VARCHAR,
"value" VARCHAR
)
)[],
"operator" VARCHAR
) |
Show child fields- filter_expressions.filters[]
Show child fields- filter_expressions.filters[].date_time_filter
Filters based on date and time. Show child fields- filter_expressions.filters[].date_time_filter.date_time
The date and time. - filter_expressions.filters[].date_time_filter.name
The name of the date-time field to filter on. - filter_expressions.filters[].date_time_filter.operator
The type of comparison to use to filter the results.
- filter_expressions.filters[].parameter_filter
Filters by parameter. Show child fields- filter_expressions.filters[].parameter_filter.name
The name of the parameter to filter on. - filter_expressions.filters[].parameter_filter.operator
The type of comparison to use to filter results. - filter_expressions.filters[].parameter_filter.value
The parameter's value.
- filter_expressions.filters[].search_term_filter
Filters by a specified search term. Show child fields- filter_expressions.filters[].search_term_filter.search_term
The term to search for.
- filter_expressions.filters[].string_filter
Filters by a string. Show child fields- filter_expressions.filters[].string_filter.name
The field name to search. - filter_expressions.filters[].string_filter.operator
The type of comparison to use for this search. - filter_expressions.filters[].string_filter.value
The string to search for.
- filter_expressions.operator
The operators to include in the search.
|
job_id Input Column
The job ID for the task search. | VARCHAR |
page_size Input Column
Specifies the number of items per page for the resource. | BIGINT |
sort_expressions Input Column
The search terms for a resource. | STRUCT(
"user_jobs_first" STRUCT(
"user_identity_id" VARCHAR
),
"field_sort" STRUCT(
"sort_order" VARCHAR,
"name" VARCHAR
),
"parameter_sort" STRUCT(
"sort_order" VARCHAR,
"name" VARCHAR
)
)[] |
Show child fields- sort_expressions[]
Show child fields- sort_expressions[].field_sort
Options for sorting by a field. Show child fields- sort_expressions[].field_sort.name
The name of the field. - sort_expressions[].field_sort.sort_order
The sort order for the field.
- sort_expressions[].parameter_sort
Options for sorting by a parameter. Show child fields- sort_expressions[].parameter_sort.name
The parameter name to sort by. - sort_expressions[].parameter_sort.sort_order
The sort order for the parameter.
- sort_expressions[].user_jobs_first
Options for sorting a particular user's jobs first. Show child fields- sort_expressions[].user_jobs_first.user_identity_id
The user's ID.
|
_aws_profile Input Column
The AWS profile defines the AWS identity used. It can be defined via credentials or by assuming a IAM role. | STRUCT(
"type" VARCHAR,
"name" VARCHAR,
"account_id" VARCHAR,
"via_profile_name" VARCHAR,
"assumed_role_arn" VARCHAR,
"organization" STRUCT(
"account_name" VARCHAR,
"id" VARCHAR,
"tags" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[],
"master_account" STRUCT(
"id" VARCHAR,
"email" VARCHAR
),
"parents" STRUCT(
"type" VARCHAR,
"id" VARCHAR,
"name" VARCHAR,
"tags" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[]
)[]
)
) |
Show child fields- _aws_profile.account_id
The AWS account id - _aws_profile.assumed_role_arn
The ARN of the assumed role - _aws_profile.name
The unique name of the profile. - _aws_profile.organization
Information about this profile's membership in the AWS organization. Show child fields- _aws_profile.organization.account_name
The name of account speciifed by the organization - _aws_profile.organization.id
The organization id - _aws_profile.organization.master_account
Show child fields- _aws_profile.organization.master_account.email
The organization master account email address - _aws_profile.organization.master_account.id
The organization master account id
- _aws_profile.organization.parents[]
Show child fields- _aws_profile.organization.parents[].id
The id of the parent - _aws_profile.organization.parents[].name
The name of the parent - _aws_profile.organization.parents[].tags[]
Show child fields- _aws_profile.organization.parents[].tags[].key
- _aws_profile.organization.parents[].tags[].value
- _aws_profile.organization.parents[].type
The type of parent can be an organization unit or a root
- _aws_profile.organization.tags[]
Show child fields- _aws_profile.organization.tags[].key
- _aws_profile.organization.tags[].value
- _aws_profile.type
The type of profile, either 'credentials' or 'assumed_role' - _aws_profile.via_profile_name
This IAM role for this profile is assumed by first utilizing another profile with this name to obtain credentials.
|
next_item_offset
The next incremental starting point after the defined itemOffset. | BIGINT |
tasks
Tasks in the search. | STRUCT(
"task_id" VARCHAR,
"step_id" VARCHAR,
"job_id" VARCHAR,
"queue_id" VARCHAR,
"run_status" VARCHAR,
"target_run_status" VARCHAR,
"parameters" MAP(VARCHAR, STRUCT(
"int" VARCHAR,
"float" VARCHAR,
"string" VARCHAR,
"path" VARCHAR
)),
"failure_retry_count" BIGINT,
"started_at" TIMESTAMP_S,
"ended_at" TIMESTAMP_S
)[] |
Show child fields- tasks[]
Show child fields- tasks[].ended_at
The date and time the resource ended running. - tasks[].failure_retry_count
The number of times that the task failed and was retried. - tasks[].job_id
The job ID. - tasks[].parameters
The parameters to search for. - tasks[].queue_id
The queue ID. - tasks[].run_status
The run status of the task. - tasks[].started_at
The date and time the resource started running. - tasks[].step_id
The step ID. - tasks[].target_run_status
The run status that the task is being updated to. - tasks[].task_id
The task ID.
|
total_results
The total number of results in the search. | BIGINT |