I've website where first step is login page and after login fetching data based on logged in user. E.g. property, bookings, customer etc..
Now from CoPilot studio I need data based on user's question. Question could be in natural language. Find the example of questions.
1) Question: Give me list of all my properties
Answer: It should fetch data from DB/restAPI and give property names in table format 2) Question : Give all bookings data of "Sai Villa" property
Answer: It will give all bookings against that "Sai Villa" property with booking number, booking dates etc.. information in table format
So bottom line is that as per user query it should give dynamic data in table format.
How can we fetch SQL database data as per user questions
Hello,
not sure about what's your question. Would you like to ask if it's possible or how to achieve these functionalities? Nevertheless, it's possible but it depends on the data that you have. You'd need to implement topics/actions to call the API based on the user prompt and then return GPT-generated answer.
In case of any other questions, let me know. If the answer helped you, mark it, so that others can benefit from it.
Best regards,
Artur Stepniak
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.