Azure Logic App - Exporting SQL Database Data to CSV or any format

Ajesh Joseph 6 Reputation points
2020-11-27T11:00:01.223+00:00

Requirement is to export data from a SQL Query to CSV files using Azure Logic Apps. 

    Step 1. Query a SQL Server (Azure Mi Instance).   
    Step 2. Retrieve the Data Set

`` Step 3. Convert the Result Set to CSV

43078-image.png

Step 1 - I am able to use the "Execute a SQL Query V2" Action.

Need help on Step 2 and Step 3, what actions i should be using.

Appreciate your help.

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,842 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. JayaC-MSFT 5,526 Reputation points
    2020-12-01T19:12:11.717+00:00

    Hello @Ajesh Joseph , could you please check the flow described in this document : https://community.dynamics.com/ax/b/d365fortechies/posts/logic-app-for-azure-sql-db-to-azure-file-storage-workflow
    Also may consider Create CSV table option.
    Does these help in your case? or do you want something more specific?

    0 comments