Reputation: 145
Receiving Data from our SQL Database hosted in Azure.
Does anyone has an idea how to generate a chart from this data, we could send the user back via the Chatbot? Any suggested Tools?
Thanks.
Upvotes: 0
Views: 404
Reputation: 3050
Based on the basic information provided (I kind of understand the context as I am working on something similar), the simplest way would be to use MS recommend adaptive cards.
If I were you, I would pull the data into some backend service (or directly into the bot code itself, its up to you), format it into an adaptive card which contains your chart, and present it to user.
While you can generate charts anyway you want, the challenge would be, how are you going to show it to the user. My suggestion would be to give a link to location where the chart can be viewed.
another would be to generate an image of the chart, and then link that image to an online chart where it is available to view and interact.
How you would generate and present the chart is really up to you.
But, I dont think there is a direct way to generate and present an interactive chart right there in the chat box.
Upvotes: 0