Delimited File Data Source XML Example

<BatchDataSyncConfig name="Contact Import" version="1.0.0" xmlns="http://www.cinchy.co">
<Parameters>
<Parameter name="filepath" />
</Parameters>
<DelimitedDataSource
delimiter=","
textQualifier="&quot;"
headerRowsToIgnore="1"
path="@filepath" encoding="UTF8">
<Schema>
<Column name="First Name" dataType="Text" />
<Column name="Last Name" dataType="Text" />
<Column name="Email Address" dataType="Text"/>
<Column name="Title" dataType="Text"/>
<Column name="Company" dataType="Text"/>
<CalculatedColumn name="Full Name" formula="CONCAT(First Name,' ',Last Name)" dataType="Text" />
</Schema>
<Filter/>
</DelimitedDataSource>
<CinchyTableTarget model="" domain="Sandbox" table="People" suppressDuplicateErrors="false">
<ColumnMappings>
<ColumnMapping sourceColumn="Full Name" targetColumn="Name" />
<ColumnMapping sourceColumn="Title" targetColumn="Title" />
<ColumnMapping sourceColumn="Company" targetColumn="Company" />
</ColumnMappings>
<SyncKey>
<SyncKeyColumnReference name="Name" />
</SyncKey>
<NewRecordBehaviour type="INSERT" />
<ChangedRecordBehavior type="UPDATE" />
<DroppedRecordBehaviour type="DELETE"/>
</CinchyTableTarget>
</BatchDataSyncConfig>