Forum Discussion

ionutbarna's avatar
ionutbarna
New Contributor II
4 years ago

Flatten multilevel/nested JSON Objects and Arrays

Hello there, Is there a way to flatten a nested JSON (multiple objects inside objects/arrays) without using a Script Snap? Take this input for example: { "msg":"Hello, World", "num":1, ...
ppankaj88's avatar
ppankaj88
New Contributor II
6 years ago
Copy LinkReport

Hi,

Is it possible to share sample code which I can use while parsing.

Thanks,
Pankaj

alchemiz's avatar
alchemiz
Contributor III
6 years ago
Copy LinkReport

Hi Pankaj,

The file that you attached was simply an invalid xml, it was missing a closing tag for node TravelITerinary once I corrected the file and you should be able to parse it using the XML parser

Thanks,
EmEm

  • hemangjalali's avatar
    hemangjalali
    New Contributor II
    2 years ago
    Copy Link

    Wow! That's a powerful snap! Worked like a charm for my use case.
    Thank you for the suggestion.

    • Michael's avatar
      Michael
      Employee
      2 years ago
      Copy Link

      Indeed it is! This snap can flatten structures, split columns, mask data, rename columns, handle nulls, and more, much faster than relying on python or expressions.