latestOpenAPI 3.0.02026-08-137192110.1 KB

75294f591cc2

ELT Syncs

List ELT Syncs

List all ELT Syncs in pages sorted by their creation date.

get/elt_syncs

Query parameters

starting_afterstring
Example:ewK8sDoLNI4CFR

The cursor to use in pagination. Use the value of the next_cursor field from the response of a previous list request.

limitinteger

The number of items to return in a single page.

connection_idstring
Example:SrcCon_12345

Filter ELT Syncs by the associated Source Connection ID.

Response

has_moreboolean required

Indicates whether there are more items to be fetched in the subsequent pages.

next_cursorstring

The cursor to use in pagination. Use this value as starting_after to get the next page.

Example response

{
  "has_more": true,
  "next_cursor": "VeN1GjhVIq1D9h",
  "data": [
    {
      "account_id": "acc_789",
      "config": {
        "sourceSettings": {}
      },
      "created_at": "2020-01-01T00:00:00.000Z",
      "destination_connection_id": "conn_456",
      "destination_integration_id": "bigquery",
      "destination_schema_name": "my_schema",
      "enabled": true,
      "id": "OoORhGXUVjsqFG",
      "orchestration_workflow_id": "3LIw2FdxoByya9",
      "source_connection_id": "conn_123",
      "source_integration_id": "excel",
      "source_streams": [
        {
          "id": "SCTVdLAcyDTgNx",
          "elt_sync_id": "3LIw2FdxoByya9",
          "name": "users",
          "incremental_primary_key_name": [
            "id"
          ],
          "incremental_pointer_id": "updated_at",
          "created_at": "2020-01-01T00:00:00.000Z",
          "updated_at": "2020-01-01T00:00:00.000Z",
          "excluded_substreams": [
            "substream1",
            "substream2"
          ],
          "sync_interval": "0 0 * * *"
        }
      ],
      "start_date": "2020-01-01T00:00:00.000Z",
      "status": "RUNNING",
      "sync_interval": "0 0 * * *",
      "updated_at": "2020-01-01T00:00:00.000Z"
    }
  ]
}