JSON data type difference

Questions
, ,
1

I’m tying to get JSON data as string.

I found such difference between types of data. I have to get data as shown in “2” output but I don’t know exactly how much data is coming so I have to input an array, but service i using only allows JSON as string. So i need this array in string format like output “2”. How can i do that without writing all data in advance?

image
image2534×902 159 KB

Input

image
image371×622 7.9 KB

Set node settings:

image
image693×648 22.9 KB

Output

image
image884×722 14.7 KB

Information on your n8n setup

  • n8n version: 0.227.1
  • Database: SQLite
  • n8n EXECUTIONS_PROCESS setting: main
  • Running n8n via Docker Compose
  • Operating system: Ubuntu
2

Hey @Eventurum,

What are you expecting the output to look like?

3

Hi @Jon!
I’m expecting the output to look like “2” but without necessity to write all JSON by myself because the number of items in input is different with every execution. In fact I need to get rid of Array:[{…}] in the beginning of the result of item “1”

image
image1339×564 15.1 KB

4

Hey @Eventurum,

Try {{ JSON.stringify( $json.lineItems ) }} and see if that sorts it.

5

It worked but still it has square brackets and extra spacing :frowning:

image
image1585×352 26 KB

6

Actually, I’ve used {{ JSON.stringify($json.lineItems).slice(1, -1) }} and it helped! Thanks a lot!