Azure logic app PostgreSQL connector

Question

Hi,

I have a standard Logic App that should retrieve data on Postres DB filtering for date (format 2020-01-01T00:00:00Z) and aggregate by a value (sum aggregation).

It should replicate a simple query like:

select a,b,sum(c)

from x

where dt_time between 'date_from' and 'date_to'

group by a,b

I cannot find a way in "PostgreSQL Get Rows connector" to specify group and to correctly handle dates in the filter.

Answer 1

@Manuel Moroni Thanks for reaching out. You are correct the "PostgreSQL" connector in Logic Apps does not have built-in support for the GROUP BY and SUM functions. However, you can still perform these operations by using a SQL query in the "Execute a SQL query" action.

please feel free to leave your feedback at https://feedback.azure.com/d365community/forum/cb47c115-7926-ec11-b6e6-000d3a4f032c

let me know incase of further queries, I would be happy to assist you.