Azure logic app PostgreSQL connector

Manuel Moroni 20 Reputation points
2023-10-23T13:07:40.59+00:00

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.

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
    2023-10-31T03:13:36.6233333+00:00

    @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.


0 additional answers

Sort by: Most helpful