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.
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 & "’"