Sign in
latestOpenAPI 3.0.02026-08-137192110.1 KB

75294f591cc2

ELT Syncs

Attach ELT sync to an orchestration

Attaches this ELT sync to an Orchestration Workflow, so it runs as part of that workflow's runs instead of on its own schedule.

post/elt_syncs/{id}/orchestration

Path parameters

idstring required
Example:X4ughggABSd3UY

The ID of the ELT sync.

Request body

orchestration_workflow_idstring required

The ID of the Orchestration Workflow to attach this ELT sync to.

Example request

{
  "orchestration_workflow_id": "3LIw2FdxoByya9"
}

Response

account_idstring required

The Id of the Account.

configobject

The configuration for the ELT sync.

created_atstring date-time required

The datetime when the ELT Sync was created.

destination_connection_idstring required

The Id of the Destination Connection.

destination_integration_idstring required

The Id of the Destination Integration.

destination_schema_namestring

The name of the destination schema.

enabledboolean required

Whether the ELT sync is enabled and running on its schedule.

idstring required

The Id of the ELT Sync.

orchestration_workflow_idstring

The Id of the Orchestration Workflow that the sync is attached to.

source_connection_idstring required

The Id of the Source Connection.

source_integration_idstring required

The Id of the Source Integration.

start_datestring date-time

The date from when the sync should synchronize the data.

status'NOT_STARTED' | 'RUNNING' | 'FAILED' | 'PAUSED' required

The status of the sync.

sync_intervalstring cron expression

The cron expression when the sync should run. Provided if sync is not attached to an Orchestration.

updated_atstring date-time required

The datetime when the ELT Sync was last updated.

Example response

{
  "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"
}