ELT Syncs

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

get/elt_syncs

Request

  • Base URL
    https://connect.weld.app
  • URL
    https://connect.weld.app/elt_syncs
  • Auth
    API key in header x-api-key

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": {}
      },
      "elt_settings": {
        "start_date": "2024-01-01"
      },
      "created_at": "2020-01-01T00:00:00.000Z",
      "destination_connection_id": "conn_456",
      "destination_integration_id": "bigquery",
      "destination_schema_name": "my_schema",
      "enabled": true,
      "identifier_casing": "UPPERCASE",
      "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"
          ],
          "primary_keys": [
            "id"
          ],
          "excluded_columns": [
            "email"
          ],
          "hashed_columns": [
            "phone"
          ],
          "incremental_pointer_id": "updated_at",
          "additional_incremental_pointer_ids": [
            "closed_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 * * *",
          "full_sync_schedule": "0 3 * * 0"
        }
      ],
      "start_date": "2020-01-01T00:00:00.000Z",
      "status": "RUNNING",
      "sync_interval": "0 0 * * *",
      "updated_at": "2020-01-01T00:00:00.000Z"
    }
  ]
}

Changes

    • info

      added the required property //// to the response with the status

    • breaking

      the response property // became nullable for the status

    • info

      added the optional property // to the response with the status

    • info

      added the required property //// to the response with the status

    • info

      added the required property //// to the response with the status

    • info

      added the required property //// to the response with the status