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>
Last modified 1yr ago