Extracting list of items from database

Like (0) Share

Report

Posted on 24 Nov 2023 18:57:33 by pasccout

I want to create a topic that gives users the ability to get a list of rows from a database (in our case, postgres).

I am able to use the connector and it does the select on the database and returns something (either record or table).

I want to parse the results and display one of the fields in a list return to the user (name column). I've tried all sorts of things like ParseJSON but that wants a string but the source is a table.

Has anybody done this type of selection from a database? Would be great if our users could ask for the list of items from the DB from Copilot.

Categories:

General

I have the same question (0)

All responses (4)

Answers (0)

fernandosilva Super User 2024 Season 1 on 27 Nov 2023 at 15:29:12

Like (0)

Report

Re: Extracting list of items from database

Yes, you can use the HTTP connector. Make sure you have a body and place in it.
use, Compose and ParseJson and then send the response you want back to PVA.
That doesn't require Postgres or any other library for the outer world.
Simply using the connectors available, you can get all the data and pass it with a form, table, list, etc.

Cheers,

Fernando

Was this reply helpful? Yes No
Pstork1 67,987 Most Valuable Professional on 24 Nov 2023 at 19:35:03

Like (0)

Report

Re: Extracting list of items from database

I misunderstood your question. I thought you were trying to access information in a DB for a bot. That is the process I described. I don't have any experience at this point using Postgres.

Was this reply helpful? Yes No
pasccout 4 on 24 Nov 2023 at 19:09:59

Like (0)

Report

Re: Extracting list of items from database

Thanks. So using the plug-in preview of Postgres directly within Copilot is not supported?

Was this reply helpful? Yes No
Pstork1 67,987 Most Valuable Professional on 24 Nov 2023 at 19:06:20

Like (0)

Report

Re: Extracting list of items from database

Yes, I've done it. Basically you use a Flow to retrieve the filtered set of records and then use an Apply to each loop on the results to built out a table as a string using the Markdown language. You return that string and display it as a message in the bot. Here's an article on the markdown syntax you use. Use Markdown language to format Power Automate approvals - Power Automate | Microsoft Learn

There is no way to return a data set as a data set to the bot.

Was this reply helpful? Yes No