Connectors

Columns Configuration

Please note that Microsoft is retiring the Exchange Web Services API in 2026. As our connector is based on this API, it means that it will not work from this date. For more information on this retirement please see the Microsoft page here.

You will need to define the columns and their data types that you want to be included in the table and in the attachment.

Once you have configured the initial connection you can use the quick create function from the tools menu which will handle this for you. Just make sure to save the connection to the connection library.

Initial Connection

When setting up your initial connection you can define the column names and types to be included in the table and attachment under the columns tab.

Click onto the ellipsis in the Columns field to open the column collection editor.

Columns Config

To add a column click onto the Add button and then set the Data Type and Name for your column. You can then continue to add columns until you have everything you need listed and click OK to save your changes.

If you miss a column you can always add it later from the connection properties.

Columns Collection Editor

The final thing to do is set the Date Time format. You can change this so that it matches your local time configuration.

DateTime Format

Make sure to click Connect and Create Library Connection to save the connection to the connection library. This will enable you to be able to use the quick start Create Email Dataset function.

Adding Additional Columns

If you missed a column or forgot to add them in your connection you can still access the column collection editor from the connection properties window.

Look for the Columns property and click onto the ellipsis (...) to open the column collection editor.

Add Columns

To add a column click onto the Add button and then set the Data Type and Name for your column. You can then continue to add columns until you have everything you need listed and click OK to save your changes.

Columns Collection Editor

To reveal the columns refresh the connection window by clicking onto the refresh button in the data source toolbar.

Refresh

You can now map the source data to your target columns.