Polling event example config

XML example

This example XML uses the following values:

Value	Description	Example
Column Name	Name(s) of your source column(s)	Id, Name, Age, Address, Salary
dataType	Data type of your source column	Number, Text
isMandatory	Whether the column is mandatory	false
validateData	Whether column data needs validation	false

Blank XML example

<BatchDataSyncConfig name="Data Polling" version="1.0.0" xmlns="http://www.cinchy.co">
    <PollingEventBrokerDataSource>
        <Schema>
            <Column name="" dataType="" isMandatory="" validateData=""/>
            <Column name="" dataType="" isMandatory="" validateData=""/>
        </Schema>
    </PollingEventBrokerDataSource>

Populated XML example

<?xml version="1.0" encoding="utf-16"?>
<BatchDataSyncConfig name="Data Polling" version="1.0.0" xmlns="http://www.cinchy.co">
    <PollingEventBrokerDataSource>
        <Schema>
            <Column name="ID" dataType="Number" isMandatory="false" validateData="false"/>
            <Column name="NAME" dataType="Text" isMandatory="false" validateData="false"/>
            <Column name="AGE" dataType="Number" isMandatory="false" validateData="false"/>
            <Column name="ADDRESS" dataType="Text" isMandatory="false" validateData="false"/>
            <Column name="SALARY" dataType="Number" isMandatory="false" validateData="false"/>
        </Schema>
    </PollingEventBrokerDataSource>

Example with destination

<?xml version="1.0" encoding="UTF-16"?>
<BatchDataSyncConfig xmlns="http://www.cinchy.co" name="Data Polling" version="1.0.0">
  <PollingEventBrokerDataSource>
    <Schema>
      <Column name="ID" dataType="Number" isMandatory="false" validateData="false" />
      <Column name="NAME" dataType="Text" isMandatory="false" validateData="false" />
      <Column name="AGE" dataType="Number" isMandatory="false" validateData="false" />
      <Column name="ADDRESS" dataType="Text" isMandatory="false" validateData="false" />
      <Column name="SALARY" dataType="Number" isMandatory="false" validateData="false" />
    </Schema>
  </PollingEventBrokerDataSource>
  <CinchyTableTarget reconcileData="true" domain="Automation" table="Customer1" suppressDuplicateErrors="true">
    <ColumnMappings>
      <ColumnMapping sourceColumn="ID" targetColumn="Id" />
      <ColumnMapping sourceColumn="NAME" targetColumn="Name" />
      <ColumnMapping sourceColumn="AGE" targetColumn="Age" />
      <ColumnMapping sourceColumn="ADDRESS" targetColumn="Address" />
      <ColumnMapping sourceColumn="SALARY" targetColumn="Salary" />
    </ColumnMappings>
    <SyncKey>
      <SyncKeyColumnReference name="Id" />
    </SyncKey>
    <NewRecordBehaviour type="INSERT" />
    <DroppedRecordBehaviour type="DELETE" />
    <ChangedRecordBehaviour type="UPDATE" />
    <PostSyncScripts />
  </CinchyTableTarget>
</BatchDataSyncConfig>

Connections UI example

This example shows you how to set up a polling event source using the Connections UI.

Schema

Our column parameters are set as follows:

Column Name	Data Type
ID	Number
NAME	Text
AGE	Number
ADDRESS	Text
SALARY	Number