Update Data Space with FTPS

Important Note

You need to create an automation FTP user on admin panel. You can find the steps for how to create automation FTP user on this link

Create an Automated Flow to Update Your ‘Master Contact’ Table

1. Under the "Data Space" tab, click on "Automated Flows" to create an automated job for Data Space updates.
   

2. Click “New”, choose "Automated Flow" and fill the details (name, start date, end date) of the automated flow.
   

3. Add a “File Drop Trigger” to listen to an FTP space. Click “Configure” to configure the node and fill out the necessary data as shown below. You can upload files with TXT, CSV or ZIP extension.
   

4.Next, you need to add a data space update node for updating a specific table. Click “Configure” and select a data source to configure this node and press “Continue”

5. Select the Master Contact table as target table on your data space and press continue,
   

6. You can make column mapping on this step;
   

There are 3 Data Table Action Types as shown below

Sample File

If you upload the sample file to the selected folder in the File Drop Trigger, the service receives this file from the FTP and updates your master contact table.

Create an Automated Flow to Update any Table of on your Data Space

1. Under the "Data Space" tab, click on "Automated Flows" to create an automated job for Data Space updates.
   

2. Click “Add” and fill the details (name, start date, end date) of the automated flow.
   

3. Add a “File Drop Trigger” to listen to an FTP space. Click “Configure” to configure the node and fill out the necessary data as shown below. You can upload files with TXT, CSV or ZIP extension.
   

4. Next, you need to add a data space update node for updating a specific table. Click “Configure” and select a data source to configure this node and press “Continue”
   

5. Select a target table on your data space and press continue,
   

6.You can make column mapping on this step;

There are 5 Data Table Action Types as Insert, Update, Insert and Update, Truncate and Insert, Delete

Sample File

If you upload the sample file to the selected folder in the File Drop Trigger, the service receives this file from the FTP and updates your target table.

Create an Automated Flow to Update Your 'Master Device' Table

1. Under the "Data Space" tab, click on "Automated Flows" to create an automated job for Data Space updates.
   

2. Click “Add” and fill the details (name, start date, end date) of the automated flow.
   

3. Add a “File Drop Trigger” to listen to an FTP space. Click “Configure” to configure the node and fill out the necessary data as shown below. You can upload files with TXT, CSV or ZIP extension.
   

4. Next, you need to add a data space update node for updating a specific table. Click “Configure” and select a data source to configure this node and press “Continue”
   

5. Select the Master Device table as target table on your data space and press continue,
   

6. You can make column mapping on this step;
   

There are 5 Data Table Action Types as Insert, Update, Insert and Update, Truncate and Insert, Delete

Mapping for Integration Key

If the integration key is not included in the file, you can select the *Constant Value option to select a specific application defined on your account for this column.

Sample File

If you upload the sample file to the selected folder in the File Drop Trigger, the service receives this file from the FTP and updates your Master Device table.