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()

jordanc's avatar
jordanc
New Contributor II
3 years ago

Thanks @tarena.

The data is coming in from a REST Get. I then run it through a Script Snap in order to do some desired data matching and manipulation. I’m pretty sure I can’t use a Splitter first, due to the way the API returns what I need. So I’m essentially dealing with one document here. Sounds like maybe I need a splitter after the fact instead? I played around with that a tad, but perhaps it’s time to revisit this.

And yes, the data looks just like the attached file, although I removed some things for the sake of brevity and privacy.