"Get file from Amazon S3 Bucket" node

The integration allows you to download files embedded on Amazon S3 bucket to Synerise. You can use this connection in various scenarios such as importing transactions, event data, customer information (such as marketing agreements).

Prerequisites

You must have an account on AWS.

Node configuration

1. Click Amazon S3 Bucket > Get file.
2. Click Select connection.
3. From the dropdown list, select the connection.
   • If no connections are available or you want to create a new one, see Create a connection.
   • If you selected an existing connection, proceed to defining the integration settings.

Create a connection

To allow the data exchange, establish a connection between Synerise and Amazon S3 Bucket.

1. At the bottom of the Select connection dropdown list, click Add connection.
2. In the Access key field, enter an access key identifier which you can find in the AWS panel.
3. In the Secret key field, enter the secret key which you can find in the AWS panel.
4. Confirm by clicking Apply.

Define the integration settings

In this step, fill in the form that allows you to get data from Amazon S3 Bucket.

1. In the Region field, enter the region of your bucket.
2. In the Bucket field, enter the name of an existing container in your storage.
3. In the Path to directory field, enter the path to the existing bucket from which the file will be downloaded.
4. In the File name field, enter the name of the file you want to get from the storage. You can use Jinjava to build dynamic file name configuration.
5. From the File format dropdown list, select the format in which the file will be delivered. If you select the CSV [*.csv] option, follow the instructions below:
   1. From the Delimiter dropdown, select the character that splits the column.
   2. From the Quotation mark dropdown list, select the characters that contain the text.
   3. From the Escape character dropdown lists, select the character that changes the default interpretation of a character or a string followed by the escape character.
6. Confirm by clicking Apply.

Example of use

As an example of use, you can create a workflow that is triggered one time in order to import the customer database (email addresses and newsletter agreements) to Synerise.

In the configuration of the workflow:

1. Start the workflow with the Scheduled Run node. In the configuration of the node, set the Run trigger to one time. Select the Immediately tab.
2. To feed the workflow with data, as the next node, select Amazon S3 > Get file. Fill in the configuration form in the node.
3. To import data to Synerise, select Synerise > Import profiles. Make sure the data in the retrieved file meet the requirements defined in the Import profile node. If you need to adjust your data, you can use Data Transformation node to transform values in your file.
4. Add the End node. Result: