Column Mapping


External Data Connector allows you to map metadata properties between data source and a SharePoint list

1. Column Mapping step will appear as shown below:
 
   
2. External Data Connector can automatically map columns for you if needed. Select Map columns automatically as in source to automate mapping. Column mapping will be done based on the column name.
 
   
3. If the selected list to add items is a new list, new columns will be created in the list if auto-mapping option is selected. You can also select the type of column to be created in the list.
 
   
4. Specify atleast one reference column, to avoid adding duplicate items in the list. External Data Connector will read the reference column value, query them against the list and if the item exists in the list, action specified in the list item settings will be performed (Skip, Update, Overwrite or Add).

Note: If 'Create a new list' option is selected for integration, columns of type single/multiple line of text, Number, Date and time and Yes/No can be created.