What is the best way to pass query parameters to Postgres DB using OpenRPA

OpenRPA
1

Hi Allen,

I have connected my OpenRPA workflow to Postgres DB using database scope activity and query it using execute query activity. Now I want to execute query with parameter.

ex: select * from books where ISBN = ‘001235’;

I want to pass ISBN as parameter from my C# code. How can I achieve this please advice.

Thanks & Regards,
Pramodh Ramanayaka.

2

Use Execute Query select command type Text and set query to the query you want.
So in your case either "select * from books where ISBN = ‘001235’" or if want to use a variable
"select * from books where ISBN = ‘" & ISBN & "’"

3

Hi Allen,

It is working.
Thank you very much.

Regards,
Pramodh Ramanayaka.