Azure Logic Apps-How To Export SQL Data into HTML

This article shows how logic apps can be used to show a SQL data in a HTML table.

Image credit — https://www.captivateiq.com/blog/export-payout-data-with-customizable-templates

👉 Test Setup

In my Azure SQL Database, I created a table called medium_tbl. The data from this table is shown below:

Through the steps mentioned below, I will copy this data out of Azure DB and paste it into a HTML table. The HTML table can then be sent to any recipient through an email or posted in a Teams group or can serve any other use case one might have.

Step 1: Set Trigger And Get Data From Azure Database

(Logic app-Get rows from SQL table)

In the above screenshots, I put the schedule for every day. Next, I connected logic apps to my Azure Database and located the table whose data needs to be retrieved.
If I click ‘Add new parameter’, I can see that there are other options to help me filter out the data that is being retrieved. For this article, I would extract everything out of the table.

Step 2: Create a JSON Message From SQL Data