IMimprovado
Extracts

Migrate a wide report extract

Migrates a wide report extract with changed dimensions to a new extract with a new data table. The new extract is linked to the source extract and the source extract is paused; its data and data table remain queryable. Every omitted template_settings field is pre-filled from the source extract, so only the settings being changed need to be passed. template_id and account are resolved from the source extract when omitted; a data table title is generated when data_table_title is empty.

post/api/v3/extracts/migrate-wide

Request

Request body

migrated_from_extraction_idinteger required

ID of the source wide report extract being migrated.

template_idinteger

Template ID. Resolved from the source extract when omitted.

accountinteger

Account ID. Resolved from the source extract when omitted.

data_table_titlestring

Title of the new data table. Generated automatically when empty.

Example request

{
  "migrated_from_extraction_id": 1443619,
  "template_id": 421,
  "account": 2330268667,
  "template_settings": {
    "fields": [
      "date",
      "campaign.name",
      "metrics.clicks"
    ],
    "scheduling": [
      {
        "scheduling": {
          "value": {
            "days": 1,
            "hours": 1,
            "minutes": 1,
            "interval": "day",
            "timezone": "UTC",
            "lookback_window": {
              "name": "default"
            }
          }
        }
      }
    ]
  }
}

Response

The newly created extract detail

idinteger

Extract ID

titlestring

Extract title

connection_idinteger

Connection ID

account_idinteger

Account ID

account_namestring

Account name

account_entity_idinteger

Internal Improvado account entity ID.

account_embedded_idinteger nullable

Embedded account ID. Null if the account is not linked to an embedded account.

created_atstring

Extract creation date

last_syncstring

Last sync date

statusstring

Extract status

error_textstring

Error text

schedules_limitinteger

Schedules limit

sync_historical_datastring nullable

Start date for historical data backfill (ISO date format, e.g. "2025-02-25"). Null if not set.

Example response

{
  "extract": {
    "value": {
      "id": 1,
      "title": "Extract 1",
      "connection_id": 1,
      "account_id": 1,
      "account_name": "Account 1",
      "account_entity_id": 1001,
      "account_embedded_id": 5001,
      "template": {
        "id": 1,
        "title": "Extract Template 1",
        "datasource_name": "google_sheets",
        "data_class": "table",
        "is_wide_template": false
      },
      "data_table": {
        "id": 1,
        "name": "table_1",
        "title": "Table 1"
      },
      "fields": [
        {
          "title": "Field 1",
          "name": "field_1",
          "user_kind": "string",
          "user_type": "string",
          "selected": true,
          "can_edit": true,
          "sql_name": "field_1",
          "format": "string",
          "is_dynamic": false
        }
      ],
      "created_at": "2021-01-01T00:00:00Z",
      "last_sync": "2021-01-01T00:00:00Z",
      "status": "active",
      "error_text": "Error text",
      "schedules_limit": 1,
      "scheduling": [
        {
          "days": 1,
          "hours": 1,
          "minutes": 1,
          "interval": "daily",
          "timezone": "UTC",
          "lookback_window": {
            "name": "1 day"
          }
        }
      ],
      "additional_params": [
        {
          "type": "string",
          "name": "param_1",
          "required": true,
          "title": "Param 1",
          "description": "Param 1 description",
          "params": {},
          "initial_value": "value"
        }
      ],
      "sync_historical_data": "2025-02-25"
    }
  }
}

Changes

No recorded changes to this operation across all 1 revision of this API.