Polling Event Example

1. XML Example

This example XML uses the following values:
Value
Description
Example
Column Name
The name(s) of your source column(s)
"Id" "Name" "Age" "Address" Salary"
dataType
The data type of your source column
"Number" "Text"
isMandatory
Whether the column is mandatory or not
"false"
validateData
Whether the column data needs to be validated or not
"false"

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

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

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

2. Connections UI Example

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

2.1 Schema

Our column parameters are set as follows:
Column Name
Data Type
ID
Number
NAME
Text
AGE
Number
ADDRESS
Text
SALARY
Number