Connections Experience & XML Config Reference
Below is an example XML script to configure a data sync, from the next page onwards there are also corresponding snippets from the Connections experience.
<BatchDataSyncConfig name="Data Sync Config Name" version="1.0.0" xmlns="http://www.cinchy.co">
<Parameters />
<Datasource>
<Schema>
<Column name="Source Column Name"/>
<CalculatedColumn name="Source Calculated Column Name" formula="CONCAT(a,b)" />
...
</Schema>
<Filter>filter condition</Filter>
</DataSource>
<Target>
<ColumnMappings>
<ColumnMapping sourceColumn="Source Column Name" targetColumn="Target Column Name" />
...
</ColumnMappings>
<Filter>filter condition</Filter>
<PostSyncScripts>
<PostSyncScript name="PostSyncScriptName" timeout="200">
<CQL>update domain.table SET column = value where condition</CQL>
</PostSyncScript>
...
</PostSyncScripts>
<SyncKey>
<SyncKeyColumnReference name="Target Column Name" />
...
</SyncKey>
<NewRecordBehaviour type="INSERT/IGNORE" />
<ChangedRecordBehaviour type="UPDATE/IGNORE" />
<DroppedRecordBehaviour type="DELETE/EXPIRE/IGNORE"/>
</Target>
</BatchDataSyncConfig>
Copy link