Additional double quotes being added

Questions
1

Describe the problem/error/question

Additional double quotes being added on Edit Fields node.

What is the error message (if any)?

I have the following node, that for some reason it adds an additional double quotes inside my string despite I’m not setting it anywhere.

image
image1055×171 41.5 KB

What I’ve tried:

  • switching from raw to manual mode: same error on both modes
  • deleting this node and adding it again: error persists

For reference, I have another Edit Fields node using raw mode that works fine:

image
image1094×479 39.5 KB

Information on your n8n setup

  • n8n version: 1.54.4 (happened on multiple previous versions)
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Docker (compose)
  • Operating system: Linux EC2 instance
2

Hi @Daniel_Luz

Weird stuff. Can you show what the JSON view shows? The Schema is nice, but is not the raw data.

Question though, you have an example of it working with the raw json mode, but you also say that you tried that and it didn’t work. I am a bit confused about that.

3

Here is the JSON view for both sides:

image
image1806×386 60.7 KB

Question though, you have an example of it working with the raw json mode, but you also say that you tried that and it didn’t work. I am a bit confused about that.

Yeah, that’s what makes it more weird. For this node specifically (Edit Fields, same as the working example), I got the same bug either using raw or manual mode.

But the attached picture pretty much sums it up. Is there anything I’m missing here on this behaviour?

4

if you add a code node before this set node, without changing any of the code does that fix it?

5

I had a similar problem

No response. Couldn’t figure out what was wrong…

6

Have you tried putting a code node after the sql node? Code node just needs to return all.