Microsoft Dataverse to Azure Blob Storage by COZYROC

This integration seamlessly connects Microsoft Dataverse with Azure Blob Storage, specializing in the transfer of object data from Dataverse to Azure Blob Storage. The integration initiates by extracting relevant information associated with Dataverse objects, such as contact, account, or other entities.

Setup Guide

This integration will establish a connection between Dataverse and Azure Blob Storage. Once the connection is established, the integration will then pull the data from each Dataverse object specified in the Object List parameter. The integration will then generate a CSV file for each object and send all files to the desired Azure Blob Storage container. If the parameter Compression is set to true, all CSV files will be compressed and uploaded to Azure Blob Storage. The uploaded files will be named as Object_currentdate.

To run this integration and connect Dataverse to Azure Blob Storage, you need to configure the parameters that are mentioned below.

Dataverse

• Server Host Required. Specify the correct instance in the server host URL.
• Token File Required. Select the Rest Token file from the drop-down list. Review the KB-Article mentioned here on how to generate the token file.
• Object List Required. This parameter accepts comma-separated values if you want to pull data from multiple Dataverse objects, e.g. account, contact, etc.
• Batch Size Required. The default is set to 200.
• Query Parameter Optional. Multiple query parameters are separated by a new line.
• Compression Optional. The default is set to True.

Azure Blob Storage

• Server Host Required. Specify the storage account name in the server host URL https://[account].blob.core.windows.net.
• Storage Account Required. Specify the storage account name.
• Shared Key Required. Specify the shared key.
• Destination Folder Required. Specify the path to the destination folder ending with a trailing slash.

Note Specify entity logical name for parameter Object List. Multiple entity logical names are comma-separated.