Azure SQL results written in Web Interface

Question

I have an Azure SQL Database and I would like pull the results from Azure SQL Database into an existing Web Interface which is a Single Page Application in a Web App.

That particular Web App get data from an API call and then the Azure Function takes key words and the output result is loaded into Azure SQL. I wanted the output to be available on same Web App. ]

So when you input data into the Web App I would like the output to appear onto the Web App.

I wanted to know what would be the best way to achieve this.

Answer 1

Thanks for your question @Kman .

This question itself is very broad. There are many ways you can query azure SQL database and write into a web interface. And it depends on which language you are using.

Generally, you can build an API service to connect to your Azure SQL database and display the result to the web interface.

You can quickly create a web app in Azure to do this. But still all the operation including connect to Azure SQL database and querying required data need to implement yourself using the programming language you prefer to use.

Links:
https://learn.microsoft.com/en-us/azure/app-service/overview
https://learn.microsoft.com/en-us/azure/azure-sql/database/single-database-create-quickstart?tabs=azure-portal

If you have any details explanation required on any specific points, let me know. Happy to help.

Or if I have answered your query, then please accept the answer so that it can help others.