Azure logic app psql select count rows

Question

Hi,

My logic app works when I do "get rows" action for postgresql it returns all 12 rows in my user table. Is it possible to do a where clause so I don't have to select all rows.

SELECT * FROM public."User_table"
WHERE username = 'testuser' and password = 'xyz123'

Answer 1

@Liam O'Dowd Postgresql connector action Get rows does have the Filter Query parameter which you can leverage for your requirement.