Parsing Multi-Level JSON Arrays

Questions
1

I’m trying to remove unwanted elements from my JSON. At the first level, I can use the “Parse JSON” module with the correct data structure, and it works without any issues.

The problem arises when I try to remove specific keys from a nested array—in my case, the “addresses” array. I’m unsure how to remove certain keys from objects within that inner array.

Please take a look at my input JSON (attached) and the output I’m expecting.
input.json (1.7 KB)
output.json (492 Bytes)

2

Hey Nicolas,

you need to rebuild the array without the needed keys. So you can use an Iterator module followed by either an Array Aggregator or an Aggregate to JSON module to restructure the array with only the elements you need.

3

OK, I found my way!

image
image5632×4034 1.19 MB

1 Like