Azure logic app PostgreSQL connector

Manuel Moroni 20 Reputation points


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.

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,887 questions
Azure Database for PostgreSQL
{count} votes

Accepted answer
  1. JananiRamesh-MSFT 21,966 Reputation points

    @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

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

0 additional answers

Sort by: Most helpful