Sanitized JSON Insert into Postgres

Questions
1

I’m trying to insert a JSONB into my database, which works correctly with the syntax below. However when I try to use the sanitized syntax using $1 it returns error invalid JSON:

image
image1432×964 134 KB

image

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

hello @Nicole_Reiter

How did the sanitized syntax look?

4

Like this:

image
image1240×954 89.1 KB

Also the toggle “replace empty strings with NULL” was not working as expected

5

I suppose you can’t use type definitions ( :: ) in the Query Parameters.

Try to set them on the variables instead, e.g. $10::TIMESTAMPZ