From the Azure Logic App that we created above, expand the When a HTTP request is received activity and copy the HTTP POST URL.

Give it a name and move on to the Settings.

(The purpose of the Web activity is to kick off our Azure Logic App, which will follow)

Create a new pipeline and give it a name.ДЇrom the General activity folder, drag and drop the Web activity onto the canvas.

Click on Author and Monitor to access the Data Factory development environment.

Create a new Azure Data Factory Instance.

If you save and run the Logic App at this point, you should see the corresponding csv version of the original xlsx file in blob storage. Additionally, use a replace function for the Blob name that replaces the xlsx extension with csv in the file Name from the Create blob activity in step 9 and provide the OutputContent output from the previous step for the Blob content. In this case, the same Folder path was specified as in the Create blob activity in step 9.

Use the Create blob activity to create a new blob after the file has been converted.

Provide the File Content from the previous Get blob content step as the input for this activity. You can do numerous iterations up to a certain file size using this tool (See their site for further details). Navigate to their site, sign up, and provide an access key that can be entered into their activity during configuration.

Cloudmersive makes a fantastic, simple activity for converting an XLSX Spreadsheet to CSV, called Convert Excel XLSX Spreadsheet to CSV (Still in Preview).

Grab the content of each blob that was created in the previous step using the Get blob content Use the Id for the required Blob input from the previous Create blob step.

If you save and run the Logic App at this point, the file should be visible in the storage container. Additionally, the Blob name should be the DisplayName from the List folder activity and the Blob content should be the File Content from the Get file content step.

A blob will be created for each of the files identified in the previous Get file content step 7 using the Create blob Provide the Folder path, which in this case is вЂњ/activeвЂќ.I would additionally recommend creating a new container for your files to be stored. If a storage account has not been created yet, do this now.Verify that the SharePoint Body is the selected output from the previous steps. Once you click out of the File Identifier box, it automatically converts to a For each activity with a Get file content activity inside of it. Provide the site address and use the SharePoint based dynamic item Id for the File Identifier. The easiest way to do this is to add a new SharePoint step called Get file content.

We will need a For each activity to handle each file listed in the previous step.This activity will return a listing of all items in the specified folder. Since we have to handle the connection and credentials to SharePoint, we need to start with a SharePoint activity called List folder.Select the When an HTTP request is received The URL will automatically be generated once you add the activity.

After itвЂ™s done deploying, click the Logic app designer from the toolbar on the left to enter the designer environment.The PSA and Azure SQL DB instances were already created (including tables for the data in the database). The following steps convert the XLSX documents to CSV, transform the values, and copy them to Azure SQL DB using a daily Azure Data Factory V2 trigger. The file will be dropped out to our team SharePoint environment for document storage. The BI Team at RSM had a need for an automated process to export Microsoft Dynamics 365 вЂ“ PSA data to Azure SQL Database for dashboard and report development.

Ems sql manager copy all excel