This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 41%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMG%3C/text%3E%3C/svg%3E)
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
Greetings!
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 49%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW%3C/text%3E%3C/svg%3E)
Hello, I am experiencing a similar problem with SQL Server. In my database i have a column of type NUMERIC(38) and the results of Get Rows v2 and the final digits is rounded to zero
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 87%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
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.
If you need more information like screenshots or something similar please let me know and I will be happy to provide you.
If you need more information like screenshots or something similar please let me know and I will be happy to provide you with more information.
Thanks, @Maximiliano Gibert ! While we investigate, could you share a screenshot of run history showing raw input? Postgres connector requires NPGSQL ADO.NET which lists type mapping here: https://www.npgsql.org/doc/types/basic.html#read-mappings
Based on the mapping, bigint seems to be the type that should be set on the Postgres side because it maps to a type of long in .NET which puts a value of 5910035000000682003 within its range of up to 9223372036854775807.
Sorry for the delay. This is the Raw input of the get rows module.
The data type in Postgres DB is "bigint".
its okey the screenshot that I sent?
Thank you
This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
@Maximiliano Gibert Sorry for the late reply. Feel free to reach out to me for offline support by sending an email to azcommunity@microsoft.com with "attn:murnun" in the subject line.