list_etl_job_executions

EtlJobsApi.list_etl_job_executions(id, role_id, from_time=None, to_time=None, limit=None, offset=None, sortorder=None, sortby=None, projection_expression=None, _request_timeout=None, _request_auth=None, _content_type=None, _headers=None, _host_index=0)

List root executions for an ETL job

Returns paginated root executions only (rows without ParentExecutionId). Starting, stopping, and running rows are refreshed from Glue before they are returned. Failed runs expose ErrorMessage from Message.

Parameters:

  • id (str) – UUID of the ETL job whose executions are listed. (required)

  • role_id (str) – Amorphic role ID sent for authorization. Missing this header returns AUTH-1001. (required)

  • from_time (str) – Start of the execution time filter. Must be sent together with to_time; sending only one of the pair does not apply a time filter.

  • to_time (str) – End of the execution time filter. Must be sent together with from_time.

  • limit (str) – Number of executions to return in this page. Defaults to 100. Maximum is 1000; values above that return IPV-1050.

  • offset (str) – 1-based page number. offset=1 is the first page. When omitted, the first page is returned. Internally converted with int(offset)-1.

  • sortorder (str) – Sort direction applied to sortby. Use asc for ascending or desc for descending. Defaults to desc.

  • sortby (str) – Execution attribute used for sorting. Only LastModifiedOn and StartedOn are allowed (case-insensitive). Other values return GE-1047. Defaults to LastModifiedOn.

  • projection_expression (str) – Comma-separated attribute names to include on each execution. When omitted, all returned execution fields are included. Example: Id,JobRunState,StartedOn.

  • _request_timeout (int, tuple(int, int), optional) – timeout setting for this request. If one number provided, it will be total request timeout. It can also be a pair (tuple) of (connection, read) timeouts.

  • _request_auth (dict, optional) – set to override the auth_settings for an a single request; this effectively ignores the authentication in the spec for a single request.

  • _content_type (str, Optional) – force content-type for the request.

  • _headers (dict, optional) – set to override the headers for a single request; this effectively ignores the headers in the spec for a single request.

  • _host_index (int, optional) – set to override the host_index for a single request; this effectively ignores the host_index in the spec for a single request.

Return type:

ExecutionStatusesResponse

Returns:

Returns the result object.

Request and Response Examples

HTTP: GET /jobs/{id}/executions

Success (HTTP 200)

Paginated JobExecutions list with count, total_count, and next_available yes/no.

Request / response example

{
  "JobExecutions": [
    {
      "Id": "jr_a1b2c3d4e5f6",
      "JobId": "3fa85f64-5717-4562-b3fc-2c963f66afa6",
      "JobName": "sales_etl_daily",
      "JobRunState": "succeeded",
      "JobBookmarkOption": "disable",
      "MaxCapacity": 2.0,
      "StartedOn": "2026-08-15 09:00:00",
      "LastModifiedOn": "2026-08-15 09:12:00"
    }
  ],
  "count": 1,
  "total_count": 1,
  "next_available": "no"
}

Errors

Documented error codes: GE-1047, IPV-1050, RTE-1001, GE-1008.

HTTP 400

Invalid sortby, limit over 1000, missing job, or insufficient access. Body is {“Message”: “<CODE> - <text>”}.

sortby is not LastModifiedOn or StartedOn

{
  "Message": "GE-1047 - Sorting is not supported for other columns, please use LastModifiedOn, StartedOn"
}

Page size exceeds 1000

{
  "Message": "IPV-1050 - Out of range for items per page, Limit is 1000"
}

HTTP 500

Uncaught backend or metadata inconsistency. Typical Message is “RTE-1001 - {exception}.” or GE-1008.

Request / response example

{
  "Message": "GE-1008 - Could not complete the request. Please try again."
}