first let me apologize. The whole topic of chatbots and databases is a first for me.
I would like to make a chatbot that could provide you with updated data on covid-19. How would I approach this? From my understanding, it is possible to achieve it by connecting a chatbot (MS PVA) to a database (MS SQL Server) using MS Power Automate and On-premise Gateway. The database would have to be updated using a web scraping program (suggestions?) to keep it updated with data obtainable on websites.
Am I missing something? Are there better solutions? Is the SQL database replaceable with datasets using json, xlsx or something integrated in the Microsoft environment? Is this project just too big for me altogether?
The chatbot is something I would like to personally build, but I'd like to know if I'm approaching it from the right direction. I did some research but the amount of information is overwhelming since this is something I have never done. Not even remotely.
I'll be glad for any tips and directions even ones not specific for PVA.