XML Config Reference

‚Äč

<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>