The data change on output Postgresql module

I have Issue with Postgresql node

On out put I am getting random data.

hi @David_Semenenko

Can you share the workflow and provide some sample of data? Remove any sensitive information ofc.

1 Like

Hi @barn4k
Yes pls.
Workflow

JSON

{
  "form_id": "24280706068194715",
  "Ad_Project": "18830",
  "Ad_Language": "6850",
  "source_detail": "",
  "marker": "abudhabi | Ramadan"
}

Hi @David_Semenenko, I suspect the problem could be with n8n trying to convert your string 24280706068194715 into a number here. The maximum value of an integer in JavaScript is 9007199254740991, so any number above this being processed as a number is likely to cause trouble.

So instead of the Insert operation, perhaps you want to use Execute Query instead of the Insert operation to specify exactly how to process the incoming data?

Like so for example:

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.