"Get file from Azure Blob Storage" node
The integration allows you to download files embedded on Azure Blob Storage 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 Azure AD.
- Maximum file size: 5 GB (5 000 000 000 bytes).
Node configuration
- Click Azure Blob Storage > Get file.
- Click Select connection.
- 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 Azure Blob Storage.
- At the bottom of the Select connection dropdown list, click Add connection.
- In the Blob SAS URL, enter the Blob shared access signature (SAS) URL that allows access to a storage account and/or containers and blobs. You can generate it in your Azure AD account.
- Confirm by clicking Apply.
Define the integration settings
In this step, fill in the form that allows you to get data from Azure Blob Storage.
- In the Container field, enter the name of an existing container in your storage.
If this field is already filled out, it means that the URL used in the connection settings contains the name of the container. - In the Blob name field, enter the name of the blob (file) you want to get from the storage. You can use Jinjava to build dynamic file name configuration.
If this field is already filled out, it means that the URL used in the connection settings contains the name of the blob. - 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:
- From the Delimiter dropdown, select the character that separates fields in a row.
- From the Quotation mark dropdown list, select the characters that contain the text.
- From the Escape character dropdown list, select the character which changes the default interpretation of a character or a string followed by the escape character.
- Confirm by clicking Apply.
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:
- 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.
- To feed the workflow with data, as the next node, select Azure Blob Storage > Get file. Fill in the configuration form in the node.
- 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.
- Add the End node. Result: