Get Sync Target | Polytomic Docs

curl -G https://app.polytomic.com/api/connections/248df4b7-aa70-47b8-a036-33ac447e668d/modelsync/target/fields \
     -H "X-Polytomic-Version: X-Polytomic-Version" \
     -H "Content-Type: application/json" \
     -u "<username>:<password>" \
     -d target=sales.customers \
     -d refresh=true

{
  "data": {
    "fields": [
      {
        "association": false,
        "createable": true,
        "description": "Unique identifier for the customer",
        "encryptable": false,
        "filterable": true,
        "id": "customer_id",
        "identity_functions": [
          {
            "id": "Equality",
            "label": "Equality"
          }
        ],
        "name": "Customer ID",
        "required": true,
        "source_type": "varchar",
        "supports_identity": true,
        "type": "string",
        "updateable": false
      },
      {
        "association": false,
        "createable": true,
        "description": "Customer's email address",
        "encryptable": true,
        "filterable": true,
        "id": "email",
        "identity_functions": [
          {
            "id": "Equality",
            "label": "Equality"
          }
        ],
        "name": "Email",
        "required": true,
        "source_type": "varchar",
        "supports_identity": true,
        "type": "string",
        "updateable": true
      },
      {
        "association": false,
        "createable": true,
        "description": "Date the customer was created",
        "encryptable": false,
        "filterable": true,
        "id": "created_at",
        "identity_functions": null,
        "name": "Created At",
        "required": false,
        "source_type": "timestamp",
        "supports_identity": false,
        "type": "datetime",
        "updateable": false
      },
      {
        "association": true,
        "createable": true,
        "description": "Reference to the customer's assigned sales representative",
        "encryptable": false,
        "filterable": true,
        "id": "sales_rep_id",
        "identity_functions": null,
        "name": "Sales Rep",
        "required": false,
        "source_type": "int",
        "supports_identity": false,
        "type": "integer",
        "updateable": true
      }
    ],
    "id": "sales.customers",
    "modes": [
      {
        "description": "Create records when they don't exist; don't update existing ones",
        "label": "Create",
        "mode": "create",
        "requires_identity": true,
        "supports_field_sync_mode": false,
        "supports_target_filters": false
      },
      {
        "description": "Update existing records; do not create new ones",
        "label": "Update",
        "mode": "update",
        "requires_identity": true,
        "supports_field_sync_mode": true,
        "supports_target_filters": true
      },
      {
        "description": "Create new records or update existing ones",
        "label": "Upsert",
        "mode": "upsert",
        "requires_identity": true,
        "supports_field_sync_mode": true,
        "supports_target_filters": true
      }
    ],
    "name": "Customers",
    "properties": {
      "does_not_report_operation_counts": false,
      "mappings_not_required": false,
      "new_target_label": "Customer Table Name",
      "optional_target_mappings": false,
      "primary_metadata_object": "customer_metadata",
      "requires_configuration": false,
      "supports_field_creation": true,
      "supports_field_encryption": true,
      "supports_field_type_selection": true,
      "supports_identity_field_creation": true,
      "supports_target_filters": true,
      "target_creator": false,
      "use_field_names_as_labels": false
    },
    "refreshed_at": "2024-06-01T12:00:00Z"
  }
}

Returns the fields, modes, and properties of a target object on a connection.

Pass the target object identifier to retrieve the fields available for mapping on that object. These are the destination fields you can reference when configuring field mappings in a model sync.

📘 To list available target objects and their identifiers, use GET /api/connections/{id}/modelsync/targetobjects.

Fields returned here reflect the connection’s current cached state. If the upstream object schema has changed, trigger a schema refresh with POST /api/connections/{id}/schemas/refresh before calling this endpoint.

Fields for a target that hasn’t been created yet

Some connections support creating a new destination object as part of a model sync — for example, a Facebook Ads custom audience or a LinkedIn Ads contact list. In that case there is no existing target identifier to pass; instead, describe the new target with the same properties returned in the target_creation block of GET /api/connections/{id}/modelsync/targetobjects, and this endpoint will return the fields the new target will expose.

Exactly one of target or properties must be supplied. Each input is sent as a separate properties[key]=value query parameter. For a Facebook Ads connection that requires an account and a name:

GET /api/connections/{id}/modelsync/target/fields
  ?properties[account]=act_1234567
  &properties[name]=My%20new%20audience

The response shape is identical to the existing-target form. For backends where the new target’s field set is fixed (most ads platforms), fields contains those fields; for backends where the columns are user-defined (e.g. a SQL database), fields will be empty and the caller defines the columns at mapping time.

When properties is supplied, the refresh parameter is ignored — a not-yet-created target has no cached schema to refresh.

Returns the fields, modes, and properties of a target object on a connection. Pass the target object identifier to retrieve the fields available for mapping on that object. These are the destination fields you can reference when configuring field mappings in a model sync. > 📘 To list available target objects and their identifiers, use > [`GET /api/connections/{id}/modelsync/targetobjects`](../../../../../../api-reference/model-sync/targets/list). Fields returned here reflect the connection's current cached state. If the upstream object schema has changed, trigger a schema refresh with [`POST /api/connections/{id}/schemas/refresh`](../../../../../../api-reference/schemas/refresh) before calling this endpoint. ## Fields for a target that hasn't been created yet Some connections support creating a new destination object as part of a model sync — for example, a Facebook Ads custom audience or a LinkedIn Ads contact list. In that case there is no existing target identifier to pass; instead, describe the new target with the same properties returned in the `target_creation` block of [`GET /api/connections/{id}/modelsync/targetobjects`](../../../../../../api-reference/model-sync/targets/list), and this endpoint will return the fields the new target will expose. Exactly one of `target` or `properties` must be supplied. Each input is sent as a separate `properties[key]=value` query parameter. For a Facebook Ads connection that requires an `account` and a `name`: ``` GET /api/connections/{id}/modelsync/target/fields ?properties[account]=act_1234567 &properties[name]=My%20new%20audience ``` The response shape is identical to the existing-target form. For backends where the new target's field set is fixed (most ads platforms), `fields` contains those fields; for backends where the columns are user-defined (e.g. a SQL database), `fields` will be empty and the caller defines the columns at mapping time. When `properties` is supplied, the `refresh` parameter is ignored — a not-yet-created target has no cached schema to refresh.

Authentication

AuthorizationBasic

This is the Polytomic deployment key (on-premises only)

AuthorizationBearer

This is the Polytomic API key

Path parameters

idstringRequiredformat: "uuid"

Unique identifier of the connection.

Query parameters

targetstringOptional

Identifier of the target object (e.g. schema.table for a database destination, object name for a SaaS destination). Required unless properties is supplied.

refreshbooleanOptional

When true, force a cache refresh of the target's schema before returning its fields. Ignored when properties is supplied.

propertiesmap from strings to lists of stringsOptional

Target-creation property values, supplied as properties[key]=value, matching the target_creation.properties returned by GET /api/connections/{id}/modelsync/targetobjects. When supplied, the response describes the not-yet-created target that would result from these inputs, in the same shape as for an existing target. Exactly one of target or properties must be supplied.

Response

dataobject

Errors

400

Bad Request Error

401

Unauthorized Error

403

Forbidden Error

404

Not Found Error

500

Internal Server Error

Returns the fields, modes, and properties of a target object on a connection.

Pass the target object identifier to retrieve the fields available for mapping on that object. These are the destination fields you can reference when configuring field mappings in a model sync.

📘 To list available target objects and their identifiers, use GET /api/connections/{id}/modelsync/targetobjects.

Fields for a target that hasn’t been created yet

GET /api/connections/{id}/modelsync/target/fields
  ?properties[account]=act_1234567
  &properties[name]=My%20new%20audience

When properties is supplied, the refresh parameter is ignored — a not-yet-created target has no cached schema to refresh.

Fields for a target that hasn’t been created yet

Authentication

Path parameters

Headers

Query parameters

Response

Errors

Fields for a target that hasn’t been created yet