Share via

Azure logic app psql select count rows

Liam O'Dowd 26 Reputation points
2022-02-22T02:17:35.457+00:00

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'

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,087 questions
0 comments
Accepted answer
  1. MayankBargali-MSFT 70,136 Reputation points
    2022-02-22T03:45:39.797+00:00

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

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.