Create Sync | Polytomic Docs

Create a new sync from one or more models to a destination.

All of the functionality described in the product documentation is configurable via the API.

Guides:

Targets (Destinations)

Polytomic refers to a model sync’s destination as the “target object”, or target. Target objects are identified by a connection ID and an object ID. You can retrieve a list of all target objects for a connection using the Get Target Objects endpoint.

The target object in the request specifies information about the sync destination.

1 "target": {
2     "connection_id": "248df4b7-aa70-47b8-a036-33ac447e668d",
3     "object": "Users",
4 },

Some connections support additional configuration for targets. For example, Salesforce connections support optionally specifying the ingestion API to use. The target specific options are passed as configuration; consult the integration guides for details about specific connection configurations.

Creating a new target

Some integrations support creating a new target when creating a model sync. For example, an ad audience or database table.

When creating a new target, object is omitted and create is specified instead. The create property is an object containing integration specific configuration for the new target.

1 "target": {
2     "connection_id": "248df4b7-aa70-47b8-a036-33ac447e668d",
3     "create": {
4         "name": "New audience",
5         "type": "user_audience"
6     }
7 },

The Get Target List endpoint returns information about whether a connection supports target creation.

Create a new sync from one or more models to a destination. All of the functionality described in [the product documentation](https://docs.polytomic.com/docs/sync-destinations) is configurable via the API. Guides: - [Model sync (Reverse ETL) from Snowflake query to Salesforce](https://apidocs.polytomic.com/2024-02-08/guides/code-examples/model-sync-reverse-etl-from-snowflake-query-to-salesforce) - [Joined model sync from Postgres, Airtable, and Stripe to Hubspot](https://apidocs.polytomic.com/2024-02-08/guides/code-examples/joined-model-sync-from-postgres-airtable-and-stripe-to-hubspot) ## Targets (Destinations) Polytomic refers to a model sync's destination as the "target object", or target. Target objects are identified by a connection ID and an object ID. You can retrieve a list of all target objects for a connection using the [Get Target Objects](./targets/list) endpoint. The `target` object in the request specifies information about the sync destination. ```json "target": { "connection_id": "248df4b7-aa70-47b8-a036-33ac447e668d", "object": "Users", }, ``` Some connections support additional configuration for targets. For example, [Salesforce connections](https://apidocs.polytomic.com/2024-02-08/guides/configuring-your-connections/connections/salesforce#target) support optionally specifying the ingestion API to use. The target specific options are passed as `configuration`; consult the [integration guides](https://apidocs.polytomic.com/2024-02-08/guides/configuring-your-connections/overview) for details about specific connection configurations. ### Creating a new target Some integrations support creating a new target when creating a model sync. For example, an ad audience or database table. When creating a new target, `object` is omitted and `create` is specified instead. The `create` property is an object containing integration specific configuration for the new target. ```json "target": { "connection_id": "248df4b7-aa70-47b8-a036-33ac447e668d", "create": { "name": "New audience", "type": "user_audience" } }, ``` The [Get Target List](./targets/list) endpoint returns information about whether a connection supports target creation.

Authentication

AuthorizationBearer

Bearer authentication of the form Bearer <token>, where token is your auth token.

Request

This endpoint expects an object.

fieldslist of objectsRequired

Fields to sync from source to destination.

modeenumRequired

namestringRequired

scheduleobjectRequired

targetobjectRequired

activebooleanOptional

Whether the sync is enabled and scheduled.

encryption_passphrasestringOptional

Passphrase for encrypting the sync data.

filter_logicstringOptional

Logical expression to combine filters.

filterslist of objectsOptional

Filters to apply to the source data.

identityobjectOptional

only_enrich_updatesbooleanOptional

Whether to use enrichment models as a source of possible changes to sync. If true, only changes to the base models will cause a record to sync.

organization_idstringOptionalformat: "uuid"

Organization ID for the sync; read-only with a partner key.

override_fieldslist of objectsOptional

Values to set in the target unconditionally.

overrideslist of objectsOptional

Conditional value replacement for fields.

policieslist of stringsOptional

skip_initial_backfillbooleanOptional

Whether to skip the initial backfill of records; if true only records seen after the sync is enabled will be synced.

sync_all_recordsbooleanOptional

Whether to sync all records from the source, regardless of whether they've changed since the previous execution.

Response

dataobject

Errors

400

Model Sync Create Request Bad Request Error

401

Model Sync Create Request Unauthorized Error

403

Model Sync Create Request Forbidden Error

422

Model Sync Create Request Unprocessable Entity Error

500

Model Sync Create Request Internal Server Error

Create a new sync from one or more models to a destination.

All of the functionality described in the product documentation is configurable via the API.

Guides:

Targets (Destinations)

The target object in the request specifies information about the sync destination.

1 "target": {
2     "connection_id": "248df4b7-aa70-47b8-a036-33ac447e668d",
3     "object": "Users",
4 },

Creating a new target

Some integrations support creating a new target when creating a model sync. For example, an ad audience or database table.

When creating a new target, object is omitted and create is specified instead. The create property is an object containing integration specific configuration for the new target.

1 "target": {
2     "connection_id": "248df4b7-aa70-47b8-a036-33ac447e668d",
3     "create": {
4         "name": "New audience",
5         "type": "user_audience"
6     }
7 },

The Get Target List endpoint returns information about whether a connection supports target creation.

1	import { PolytomicClient } from "polytomic";
2
3	const client = new PolytomicClient({ token: "YOUR_TOKEN", version: "YOUR_VERSION" });
4	await client.modelSync.create({
5	fields: [{
6	target: "name"
7	}],
8	mode: "create",
9	name: "Users Sync",
10	schedule: {},
11	target: {
12	connection_id: "248df4b7-aa70-47b8-a036-33ac447e668d"
13	}
14	});

1	{
2	"data": {
3	"active": true,
4	"created_at": "2024-01-15T09:30:00Z",
5	"created_by": {
6	"id": "12345678-1234-1234-1234-123456789012",
7	"name": "John Doe",
8	"type": "user"
9	},
10	"encryption_passphrase": "encryption_passphrase",
11	"fields": [
12	{
13	"target": "name",
14	"override_value": "fixed_value",
15	"source": {
16	"field": "id",
17	"model_id": "248df4b7-aa70-47b8-a036-33ac447e668d"
18	},
19	"sync_mode": "create"
20	}
21	],
22	"filter_logic": "filter_logic",
23	"filters": [
24	{
25	"function": "Equality",
26	"field": {
27	"field": "id",
28	"model_id": "248df4b7-aa70-47b8-a036-33ac447e668d"
29	},
30	"field_id": "field1",
31	"label": "A"
32	}
33	],
34	"id": "248df4b7-aa70-47b8-a036-33ac447e668d",
35	"identity": {
36	"function": "Equality",
37	"source": {
38	"field": "id",
39	"model_id": "248df4b7-aa70-47b8-a036-33ac447e668d"
40	},
41	"target": "name",
42	"new_field": true,
43	"remote_field_type_id": "string"
44	},
45	"mode": "create",
46	"model_ids": [
47	"model_ids"
48	],
49	"name": "Users Sync",
50	"only_enrich_updates": false,
51	"organization_id": "248df4b7-aa70-47b8-a036-33ac447e668d",
52	"override_fields": [
53	{
54	"target": "name",
55	"override_value": "fixed_value",
56	"source": {
57	"field": "id",
58	"model_id": "248df4b7-aa70-47b8-a036-33ac447e668d"
59	},
60	"sync_mode": "create"
61	}
62	],
63	"overrides": [
64	{
65	"field": {
66	"field": "id",
67	"model_id": "248df4b7-aa70-47b8-a036-33ac447e668d"
68	},
69	"field_id": "field1"
70	}
71	],
72	"policies": [
73	"248df4b7-aa70-47b8-a036-33ac447e668d"
74	],
75	"schedule": {
76	"connection_id": "248df4b7-aa70-47b8-a036-33ac447e668d",
77	"day_of_month": "1",
78	"day_of_week": "monday",
79	"frequency": "manual",
80	"hour": "12",
81	"job_id": 1,
82	"minute": "30",
83	"month": "1",
84	"run_after": {
85	"bulk_sync_ids": [
86	"248df4b7-aa70-47b8-a036-33ac447e668d"
87	],
88	"sync_ids": [
89	"248df4b7-aa70-47b8-a036-33ac447e668d"
90	]
91	},
92	"run_after_success_only": true
93	},
94	"skip_initial_backfill": false,
95	"sync_all_records": false,
96	"target": {
97	"connection_id": "248df4b7-aa70-47b8-a036-33ac447e668d",
98	"configuration": {
99	"key": "value"
100	},
101	"create": {
102	"name": "value"
103	},
104	"filter_logic": "filter_logic",
105	"object": "Users",
106	"new_name": "new_name",
107	"search_values": {
108	"name": "value"
109	}
110	},
111	"updated_at": "2024-01-15T09:30:00Z",
112	"updated_by": {
113	"id": "12345678-1234-1234-1234-123456789012",
114	"name": "John Doe",
115	"type": "user"
116	}
117	}
118	}

Targets (Destinations)

Creating a new target

Authentication

Headers

Request

Response

Errors

Targets (Destinations)

Creating a new target