How can we fetch SQL database data as per user questions

Like (0) Share

Report

Posted on 10 Dec 2024 13:39:30 by Jignesh Patel

101

Hello,

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.

Thanks

Categories:

General

All responses (1)

Answers (0)

Suggested answer

Artur Stepniak 1,521 Super User 2025 Season 1 on 11 Dec 2024 at 08:23:29

Like (0)

Report

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