Fetch data from SQL database and show that in dashboard

Dashboard
1

I am all new to this NODE RED and to this world of automation. :slightly_smiling_face:

I would like to know how to fetch data from SQL database and show that in my frontend created using template node (usinh html). Currently, I have a form in the frontend which has input field and when i type something in the form and click on submit, the data will be automatically transferred to SQL database. Now all I have to do is, showing this input value which is transferred to the sql again in the frontend as a separate thing and it should be just visible in frontend. How do I achieve the task of fetching data from SQL database and post in the dashboard ?

2

Welcome to the forum @Subiksha

Start with how to fetch the data. What sort of SQL database is it?

3

Hi ! Thanks for your response. :blush:
It am ms sql database.

4

I think the usual node to use with MSSQL server is node-red-contrib-mssql-plus. Give that a go and see if you are able to connect and query the db.

5

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.