Logic app returning wrong data from postgresql server

Question

Hi,

I have a logic app that interacts with a postgresql server in azure and am having trouble with data fed through the logic app, the sql database has a simple table: Hostname which is the private key and then tokens,

when the logic app gets all rows from the database it receives all 3xxx items which is the correct number of items but on further inspection 302 of those items seem to be duplicates and have overwritten 302 other items, when I log onto the sql server it self and request all the items there are no duplicates.

after further testing it seems to be always the same items that are duplicate, I have tested creating a new logic app and request the same data and its always the same.

I have another logic app that retrieves a single item via private key(hostname) and tested both requesting an item that is returned duplicate and it returns the single item and then the item that is overwritten by the duplicates and it returns the item(that does not show up in the retrieve all items list)

just for clarification the database looks like this simplified:
hostname1, token1

hostname2, token2

hostname3, token3

hostname4, token4

hostname5, token5

but when I request all items via logic app it returns the data like this

hostname1, token1

hostname1, token1 <- this seems to be item 2 overwritten with a duplicate of item 1

hostname3, token3

hostname3, token3 <- this seems to be item 4 overwritten with a duplicate of item 3

hostname5, token5

further info, I am using a postgresql single server for the db, and the logic app is using PostgreSQL connector and the Get Rows panel to retrieve all rows from the table.