# Airbyte

> Run and watch your Airbyte data pipelines: start, cancel and list sync jobs, and create, update and delete sources, destinations and connections.

App · 20 actions. Web page: https://docs.lodol.com/docs/integrations/airbyte

## Actions

### Cancel job

Cancel a job that is still running.

**Inputs**

- Job ID (`job_id`, number, required): The job's number, from 'List jobs' or 'Start sync'. At least 1.

**Outputs**

- `job` (object): The job

**Example output**

```json
{
  "job": {
    "bytesSynced": 52428800,
    "connectionId": "9e8d7c6b-5a49-4382-9170-6f5e4d3c2b1a",
    "duration": "PT4M31S",
    "jobId": 1234567,
    "jobType": "sync",
    "lastUpdatedAt": "2026-11-10T12:04:31Z",
    "rowsSynced": 120000,
    "startTime": "2026-11-10T12:00:00Z",
    "status": "cancelled"
  }
}
```

### Create connection

Connect a source to a destination, syncing every stream Airbyte finds in the source, manually or on a cron schedule.

**Inputs**

- Source (`source_id`, text, required): The source. Pick one, or give its id from an earlier step.
- Destination (`destination_id`, text, required): The destination. Pick one, or give its id from an earlier step.
- Name (`name`, text): The connection's name. Airbyte names it after the source and destination if left empty.
- Schedule (`schedule_type`, text): Manual, or on the cron schedule given. One of: `manual` (Manual: only when started), `cron` (On a cron schedule).
- Cron expression (`cron_expression`, text): A Quartz cron expression in UTC, such as 0 0 12 * * ? for every day at noon. Giving one makes the schedule a cron schedule.
- Status (`status`, text): Active connections sync on their schedule; inactive ones are paused. One of: `active`, `inactive` (Inactive (paused)).
- Destination namespace (`namespace_definition`, text): Which schema or dataset the tables are written to. One of: `destination` (Destination default (default)), `source` (Same as the source), `custom_format` (Custom format).
- Custom namespace (`namespace_format`, text): The schema name to write to, for a custom format, such as airbyte_sales. ${SOURCE_NAMESPACE} stands for the source's.
- Table prefix (`prefix`, text): Text put before each table's name in the destination, such as raw_.
- When the source adds fields (`schema_changes`, text): What Airbyte does when the source gains new columns or streams. One of: `ignore` (Ignore: keep syncing as set up (default)), `propagate_columns` (Add new columns), `propagate_fully` (Add new columns and streams), `disable_connection` (Pause the connection).

**Outputs**

- `connection` (object): The connection

**Example output**

```json
{
  "connection": {
    "configurations": {
      "streams": [
        {
          "cursorField": [
            "updated_at"
          ],
          "name": "orders",
          "namespace": "public",
          "primaryKey": [
            [
              "id"
            ]
          ],
          "syncMode": "incremental_append"
        }
      ]
    },
    "connectionId": "9e8d7c6b-5a49-4382-9170-6f5e4d3c2b1a",
    "createdAt": 1793000000,
    "destinationId": "4ab5c7d1-2f3e-4a6b-8c9d-0e1f2a3b4c5d",
    "name": "Sales Postgres to Snowflake",
    "namespaceDefinition": "destination",
    "namespaceFormat": "",
    "nonBreakingSchemaUpdatesBehavior": "ignore",
    "prefix": "",
    "schedule": {
      "basicTiming": "",
      "cronExpression": "0 0 12 * * ?",
      "scheduleType": "cron"
    },
    "sourceId": "18dccc91-0ab1-4f72-9ed7-0b8fc27c5826",
    "status": "active",
    "tags": [],
    "workspaceId": "871d9b60-11d1-44cb-8c92-c246d53bf87e"
  }
}
```

### Create destination

Create a destination of an Airbyte connector (a warehouse, a database, a lake) with that connector's settings.

**Inputs**

- Workspace (`workspace_id`, text, required): The workspace to create it in. Pick one, or give its id.
- Name (`name`, text, required): The destination's name in Airbyte.
- Connector (`destination_type`, text, required): The Airbyte connector, by the name in its docs address, such as bigquery, google-sheets or snowflake.
- Settings (`configuration`, object): The connector's settings as keys and values, as Airbyte's docs for that connector list them (host, database, credentials...).

**Outputs**

- `destination` (object): The destination

**Example output**

```json
{
  "destination": {
    "configuration": {
      "database": "RAW",
      "host": "acme.snowflakecomputing.com"
    },
    "createdAt": 1793000000,
    "definitionId": "424892c4-daac-4491-b35d-c6688ba547ba",
    "destinationId": "4ab5c7d1-2f3e-4a6b-8c9d-0e1f2a3b4c5d",
    "destinationType": "snowflake",
    "name": "Analytics Snowflake",
    "workspaceId": "871d9b60-11d1-44cb-8c92-c246d53bf87e"
  }
}
```

### Create source

Create a source of an Airbyte connector (a database, an app, a file store) with that connector's settings.

**Inputs**

- Workspace (`workspace_id`, text, required): The workspace to create it in. Pick one, or give its id.
- Name (`name`, text, required): The source's name in Airbyte.
- Connector (`source_type`, text, required): The Airbyte connector, by the name in its docs address, such as postgres, google-sheets or snowflake.
- Settings (`configuration`, object): The connector's settings as keys and values, as Airbyte's docs for that connector list them (host, database, credentials...).

**Outputs**

- `source` (object): The source

**Example output**

```json
{
  "source": {
    "configuration": {
      "database": "sales",
      "host": "db.example.com",
      "port": 5432
    },
    "createdAt": 1793000000,
    "definitionId": "decd338e-5647-4c0b-adf4-da0e75f5a750",
    "name": "Sales Postgres",
    "sourceId": "18dccc91-0ab1-4f72-9ed7-0b8fc27c5826",
    "sourceType": "postgres",
    "workspaceId": "871d9b60-11d1-44cb-8c92-c246d53bf87e"
  }
}
```

### Delete connection

Delete a connection. Its source and destination are kept.

**Inputs**

- Connection (`airbyte_connection_id`, text, required): The connection. Pick one, or give its id from an earlier step.

**Outputs**

- `connection_id` (text): The connection deleted
- `deleted` (true/false): Always true once deleted

**Example output**

```json
{
  "connection_id": "9e8d7c6b-5a49-4382-9170-6f5e4d3c2b1a",
  "deleted": true
}
```

### Delete destination

Delete a destination. Airbyte deletes the connections that use it too.

**Inputs**

- Destination (`destination_id`, text, required): The destination. Pick one, or give its id from an earlier step.

**Outputs**

- `deleted` (true/false): Always true once deleted
- `destination_id` (text): The destination deleted

**Example output**

```json
{
  "deleted": true,
  "destination_id": "4ab5c7d1-2f3e-4a6b-8c9d-0e1f2a3b4c5d"
}
```

### Delete source

Delete a source. Airbyte deletes the connections that use it too.

**Inputs**

- Source (`source_id`, text, required): The source. Pick one, or give its id from an earlier step.

**Outputs**

- `deleted` (true/false): Always true once deleted
- `source_id` (text): The source deleted

**Example output**

```json
{
  "deleted": true,
  "source_id": "18dccc91-0ab1-4f72-9ed7-0b8fc27c5826"
}
```

### Get connection

Get one connection with its status, schedule and the streams it syncs.

**Inputs**

- Connection (`airbyte_connection_id`, text, required): The connection. Pick one, or give its id from an earlier step.

**Outputs**

- `connection` (object): The connection

**Example output**

```json
{
  "connection": {
    "configurations": {
      "streams": [
        {
          "cursorField": [
            "updated_at"
          ],
          "name": "orders",
          "namespace": "public",
          "primaryKey": [
            [
              "id"
            ]
          ],
          "syncMode": "incremental_append"
        }
      ]
    },
    "connectionId": "9e8d7c6b-5a49-4382-9170-6f5e4d3c2b1a",
    "createdAt": 1793000000,
    "destinationId": "4ab5c7d1-2f3e-4a6b-8c9d-0e1f2a3b4c5d",
    "name": "Sales Postgres to Snowflake",
    "namespaceDefinition": "destination",
    "namespaceFormat": "",
    "nonBreakingSchemaUpdatesBehavior": "ignore",
    "prefix": "",
    "schedule": {
      "basicTiming": "",
      "cronExpression": "0 0 12 * * ?",
      "scheduleType": "cron"
    },
    "sourceId": "18dccc91-0ab1-4f72-9ed7-0b8fc27c5826",
    "status": "active",
    "tags": [],
    "workspaceId": "871d9b60-11d1-44cb-8c92-c246d53bf87e"
  }
}
```

### Get destination

Get one destination with its connector and settings (secrets hidden).

**Inputs**

- Destination (`destination_id`, text, required): The destination. Pick one, or give its id from an earlier step.

**Outputs**

- `destination` (object): The destination

**Example output**

```json
{
  "destination": {
    "configuration": {
      "database": "RAW",
      "host": "acme.snowflakecomputing.com"
    },
    "createdAt": 1793000000,
    "definitionId": "424892c4-daac-4491-b35d-c6688ba547ba",
    "destinationId": "4ab5c7d1-2f3e-4a6b-8c9d-0e1f2a3b4c5d",
    "destinationType": "snowflake",
    "name": "Analytics Snowflake",
    "workspaceId": "871d9b60-11d1-44cb-8c92-c246d53bf87e"
  }
}
```

### Get job

Get one job's status, duration, and the rows and bytes it synced.

**Inputs**

- Job ID (`job_id`, number, required): The job's number, from 'List jobs' or 'Start sync'. At least 1.

**Outputs**

- `job` (object): The job

**Example output**

```json
{
  "job": {
    "bytesSynced": 52428800,
    "connectionId": "9e8d7c6b-5a49-4382-9170-6f5e4d3c2b1a",
    "duration": "PT4M31S",
    "jobId": 1234567,
    "jobType": "sync",
    "lastUpdatedAt": "2026-11-10T12:04:31Z",
    "rowsSynced": 120000,
    "startTime": "2026-11-10T12:00:00Z",
    "status": "succeeded"
  }
}
```

### Get source

Get one source with its connector and settings (secrets hidden).

**Inputs**

- Source (`source_id`, text, required): The source. Pick one, or give its id from an earlier step.

**Outputs**

- `source` (object): The source

**Example output**

```json
{
  "source": {
    "configuration": {
      "database": "sales",
      "host": "db.example.com",
      "port": 5432
    },
    "createdAt": 1793000000,
    "definitionId": "decd338e-5647-4c0b-adf4-da0e75f5a750",
    "name": "Sales Postgres",
    "sourceId": "18dccc91-0ab1-4f72-9ed7-0b8fc27c5826",
    "sourceType": "postgres",
    "workspaceId": "871d9b60-11d1-44cb-8c92-c246d53bf87e"
  }
}
```

### List connections

List connections (a source synced to a destination) with their status and schedule, in one workspace or all.

**Inputs**

- Workspace (`workspace_id`, text): Only this workspace. Leave empty for every workspace you can see.
- Include deleted (`include_deleted`, true/false): Also list ones that were deleted.
- Page size (`limit`, number): How many to return, 1 to 100. Airbyte's default is 20. From 1 to 100.
- Offset (`offset`, number): How many to skip: the 'next_offset' of an earlier page. At least 0.

**Outputs**

- `connections` (list): The connections
- `count` (number): How many on this page
- `has_more` (true/false): True when another page follows
- `next_offset` (number): The offset of the next page, 0 when there is none

**Example output**

```json
{
  "connections": [
    {
      "configurations": {
        "streams": [
          {
            "cursorField": [
              "updated_at"
            ],
            "name": "orders",
            "namespace": "public",
            "primaryKey": [
              [
                "id"
              ]
            ],
            "syncMode": "incremental_append"
          }
        ]
      },
      "connectionId": "9e8d7c6b-5a49-4382-9170-6f5e4d3c2b1a",
      "createdAt": 1793000000,
      "destinationId": "4ab5c7d1-2f3e-4a6b-8c9d-0e1f2a3b4c5d",
      "name": "Sales Postgres to Snowflake",
      "namespaceDefinition": "destination",
      "namespaceFormat": "",
      "nonBreakingSchemaUpdatesBehavior": "ignore",
      "prefix": "",
      "schedule": {
        "basicTiming": "",
        "cronExpression": "0 0 12 * * ?",
        "scheduleType": "cron"
      },
      "sourceId": "18dccc91-0ab1-4f72-9ed7-0b8fc27c5826",
      "status": "active",
      "tags": [],
      "workspaceId": "871d9b60-11d1-44cb-8c92-c246d53bf87e"
    }
  ],
  "count": 1,
  "has_more": false,
  "next_offset": 0
}
```

### List destinations

List destinations (where data is copied to), in one workspace or all.

**Inputs**

- Workspace (`workspace_id`, text): Only this workspace. Leave empty for every workspace you can see.
- Include deleted (`include_deleted`, true/false): Also list ones that were deleted.
- Page size (`limit`, number): How many to return, 1 to 100. Airbyte's default is 20. From 1 to 100.
- Offset (`offset`, number): How many to skip: the 'next_offset' of an earlier page. At least 0.

**Outputs**

- `count` (number): How many on this page
- `destinations` (list): The destinations
- `has_more` (true/false): True when another page follows
- `next_offset` (number): The offset of the next page, 0 when there is none

**Example output**

```json
{
  "count": 1,
  "destinations": [
    {
      "configuration": {
        "database": "RAW",
        "host": "acme.snowflakecomputing.com"
      },
      "createdAt": 1793000000,
      "definitionId": "424892c4-daac-4491-b35d-c6688ba547ba",
      "destinationId": "4ab5c7d1-2f3e-4a6b-8c9d-0e1f2a3b4c5d",
      "destinationType": "snowflake",
      "name": "Analytics Snowflake",
      "workspaceId": "871d9b60-11d1-44cb-8c92-c246d53bf87e"
    }
  ],
  "has_more": false,
  "next_offset": 0
}
```

### List jobs

List sync jobs with their status, duration and rows synced, filtered by connection, workspace, status, type or time.

**Inputs**

- Connection (`airbyte_connection_id`, text): Only jobs of this connection.
- Workspace (`workspace_id`, text): Only this workspace. Leave empty for every workspace you can see.
- Status (`status`, text): Only jobs in this status. One of: `pending`, `running`, `incomplete` (Incomplete (an attempt failed, retrying)), `failed`, `succeeded`, `cancelled`.
- Type (`job_type`, text): Only jobs of this type. One of: `sync`, `refresh`, `clear`, `reset` (Reset (older name for clear)).
- Started after (`created_after`, date and time): Only jobs started at or after this time.
- Started before (`created_before`, date and time): Only jobs started at or before this time.
- Updated after (`updated_after`, date and time): Only jobs that changed (such as finished) after this time.
- Order (`order_by`, text): How to sort the jobs. Defaults to newest first. One of: `createdAt|DESC` (Newest first (default)), `createdAt|ASC` (Oldest first), `updatedAt|DESC` (Most recently updated first).
- Page size (`limit`, number): How many to return, 1 to 100. Airbyte's default is 20. From 1 to 100.
- Offset (`offset`, number): How many to skip: the 'next_offset' of an earlier page. At least 0.

**Outputs**

- `count` (number): How many on this page
- `has_more` (true/false): True when another page follows
- `jobs` (list): The jobs
- `next_offset` (number): The offset of the next page, 0 when there is none

**Example output**

```json
{
  "count": 1,
  "has_more": false,
  "jobs": [
    {
      "bytesSynced": 52428800,
      "connectionId": "9e8d7c6b-5a49-4382-9170-6f5e4d3c2b1a",
      "duration": "PT4M31S",
      "jobId": 1234567,
      "jobType": "sync",
      "lastUpdatedAt": "2026-11-10T12:04:31Z",
      "rowsSynced": 120000,
      "startTime": "2026-11-10T12:00:00Z",
      "status": "succeeded"
    }
  ],
  "next_offset": 0
}
```

### List sources

List sources (where data is copied from), in one workspace or all.

**Inputs**

- Workspace (`workspace_id`, text): Only this workspace. Leave empty for every workspace you can see.
- Include deleted (`include_deleted`, true/false): Also list ones that were deleted.
- Page size (`limit`, number): How many to return, 1 to 100. Airbyte's default is 20. From 1 to 100.
- Offset (`offset`, number): How many to skip: the 'next_offset' of an earlier page. At least 0.

**Outputs**

- `count` (number): How many on this page
- `has_more` (true/false): True when another page follows
- `next_offset` (number): The offset of the next page, 0 when there is none
- `sources` (list): The sources

**Example output**

```json
{
  "count": 1,
  "has_more": false,
  "next_offset": 0,
  "sources": [
    {
      "configuration": {
        "database": "sales",
        "host": "db.example.com",
        "port": 5432
      },
      "createdAt": 1793000000,
      "definitionId": "decd338e-5647-4c0b-adf4-da0e75f5a750",
      "name": "Sales Postgres",
      "sourceId": "18dccc91-0ab1-4f72-9ed7-0b8fc27c5826",
      "sourceType": "postgres",
      "workspaceId": "871d9b60-11d1-44cb-8c92-c246d53bf87e"
    }
  ]
}
```

### List workspaces

List the Airbyte workspaces you can reach, with their ids.

**Inputs**

- Include deleted (`include_deleted`, true/false): Also list ones that were deleted.
- Page size (`limit`, number): How many to return, 1 to 100. Airbyte's default is 20. From 1 to 100.
- Offset (`offset`, number): How many to skip: the 'next_offset' of an earlier page. At least 0.

**Outputs**

- `count` (number): How many on this page
- `has_more` (true/false): True when another page follows
- `next_offset` (number): The offset of the next page, 0 when there is none
- `workspaces` (list): The workspaces

**Example output**

```json
{
  "count": 1,
  "has_more": false,
  "next_offset": 0,
  "workspaces": [
    {
      "dataResidency": "auto",
      "name": "Acme Data",
      "notifications": {},
      "workspaceId": "871d9b60-11d1-44cb-8c92-c246d53bf87e"
    }
  ]
}
```

### Start sync

Start a sync of a connection now, or a refresh (copy everything again) or clear (delete its synced data in the destination). Airbyte runs one job per connection at a time.

**Inputs**

- Connection (`airbyte_connection_id`, text, required): The connection. Pick one, or give its id from an earlier step.
- Job (`job_type`, text): What to run. Defaults to a sync. One of: `sync` (Sync: copy new data (default)), `refresh` (Refresh: copy all data again), `clear` (Clear: delete the synced data in the destination). Default: `sync`.

**Outputs**

- `job` (object): The job

**Example output**

```json
{
  "job": {
    "bytesSynced": 52428800,
    "connectionId": "9e8d7c6b-5a49-4382-9170-6f5e4d3c2b1a",
    "duration": "",
    "jobId": 1234567,
    "jobType": "sync",
    "lastUpdatedAt": "2026-11-10T12:04:31Z",
    "rowsSynced": 120000,
    "startTime": "2026-11-10T12:00:00Z",
    "status": "running"
  }
}
```

### Update connection

Rename, pause or resume a connection, or change its schedule, table prefix or what happens on schema changes.

**Inputs**

- Connection (`airbyte_connection_id`, text, required): The connection. Pick one, or give its id from an earlier step.
- Name (`name`, text): A new name. Leave empty to keep it.
- Status (`status`, text): Active connections sync on their schedule; inactive ones are paused. One of: `active`, `inactive` (Inactive (paused)).
- Schedule (`schedule_type`, text): Manual, or on the cron schedule given. One of: `manual` (Manual: only when started), `cron` (On a cron schedule).
- Cron expression (`cron_expression`, text): A Quartz cron expression in UTC, such as 0 0 12 * * ? for every day at noon. Giving one makes the schedule a cron schedule.
- Table prefix (`prefix`, text): Text put before each table's name in the destination, such as raw_.
- When the source adds fields (`schema_changes`, text): What Airbyte does when the source gains new columns or streams. One of: `ignore` (Ignore: keep syncing as set up (default)), `propagate_columns` (Add new columns), `propagate_fully` (Add new columns and streams), `disable_connection` (Pause the connection).

**Outputs**

- `connection` (object): The connection

**Example output**

```json
{
  "connection": {
    "configurations": {
      "streams": [
        {
          "cursorField": [
            "updated_at"
          ],
          "name": "orders",
          "namespace": "public",
          "primaryKey": [
            [
              "id"
            ]
          ],
          "syncMode": "incremental_append"
        }
      ]
    },
    "connectionId": "9e8d7c6b-5a49-4382-9170-6f5e4d3c2b1a",
    "createdAt": 1793000000,
    "destinationId": "4ab5c7d1-2f3e-4a6b-8c9d-0e1f2a3b4c5d",
    "name": "Sales Postgres to Snowflake",
    "namespaceDefinition": "destination",
    "namespaceFormat": "",
    "nonBreakingSchemaUpdatesBehavior": "ignore",
    "prefix": "",
    "schedule": {
      "basicTiming": "",
      "cronExpression": "0 0 12 * * ?",
      "scheduleType": "cron"
    },
    "sourceId": "18dccc91-0ab1-4f72-9ed7-0b8fc27c5826",
    "status": "active",
    "tags": [],
    "workspaceId": "871d9b60-11d1-44cb-8c92-c246d53bf87e"
  }
}
```

### Update destination

Rename a destination or change some of its settings, keeping the rest.

**Inputs**

- Destination (`destination_id`, text, required): The destination. Pick one, or give its id from an earlier step.
- Name (`name`, text): A new name. Leave empty to keep it.
- Settings to change (`configuration`, object): Only the settings to change, as keys and values. Leave empty to keep them all.

**Outputs**

- `destination` (object): The destination

**Example output**

```json
{
  "destination": {
    "configuration": {
      "database": "RAW",
      "host": "acme.snowflakecomputing.com"
    },
    "createdAt": 1793000000,
    "definitionId": "424892c4-daac-4491-b35d-c6688ba547ba",
    "destinationId": "4ab5c7d1-2f3e-4a6b-8c9d-0e1f2a3b4c5d",
    "destinationType": "snowflake",
    "name": "Analytics Snowflake",
    "workspaceId": "871d9b60-11d1-44cb-8c92-c246d53bf87e"
  }
}
```

### Update source

Rename a source or change some of its settings, keeping the rest.

**Inputs**

- Source (`source_id`, text, required): The source. Pick one, or give its id from an earlier step.
- Name (`name`, text): A new name. Leave empty to keep it.
- Settings to change (`configuration`, object): Only the settings to change, as keys and values. Leave empty to keep them all.

**Outputs**

- `source` (object): The source

**Example output**

```json
{
  "source": {
    "configuration": {
      "database": "sales",
      "host": "db.example.com",
      "port": 5432
    },
    "createdAt": 1793000000,
    "definitionId": "decd338e-5647-4c0b-adf4-da0e75f5a750",
    "name": "Sales Postgres",
    "sourceId": "18dccc91-0ab1-4f72-9ed7-0b8fc27c5826",
    "sourceType": "postgres",
    "workspaceId": "871d9b60-11d1-44cb-8c92-c246d53bf87e"
  }
}
```
