Forum Discussion

jordanc's avatar
jordanc
New Contributor II
3 years ago
Solved

Using Mapper to flatten my JSON with Array

I’m trying to flatten my object using a Mapper Snap before I export it to CSV. But I have been unable to map the fields coming in from the child records. Attached is a sample JSON file that represent...
  • alchemiz's avatar
    alchemiz
    3 years ago

    Hi guys, you can also use $data.values()

tarena's avatar
tarena
New Contributor III
3 years ago

You can use the following expression to split the Data object into a JSON List of objects. Even though Data is an object, its keys are a list. You can leverage that fact to create a new list using the Map expression. Each row will be the object at a key in the original object.

$data.keys().map(k => $data.get(k))

Now that you have a list, you can use the JSON Split snap to create your document stream and your CSV.

Map JSON Object to List_2022_12_02.slp (5.9 KB)

alchemiz's avatar
alchemiz
Contributor III
3 years ago

Hi guys, you can also use $data.values()