Response from a Postgres Get Rows in Logic Apps

Maximiliano Gibert 20 Reputation points

This is the value I have in my database : "5910035000000682003"
And the answer I get when I use the "Get rows" module in Logic Apps is : "5910035000000682000"

The data type of my field in Postgres is "numeric". I had the same problem when a changed the data type to a bigint.

The last value is rounded to zero, I can't find an answer as to why this is happening.

If someone could help me I would appreciate it very much.

Thank you very much in advance


Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,398 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. MikeUrnun 6,691 Reputation points

    Hello @Maximiliano Gibert Thanks for reaching out. AFAIK, there isn't such a "rounding down" behavior in any of the database connectors but I will check with the owning team internally & report back.