Forum Discussion

deeps's avatar
deeps
New Contributor III
2 years ago
Solved

Help to parse Json data into csv

I need help to parse this data into csv format  [ { "id": "12345", "email": "mary@xyz.com", "status": "active", "groups": [ "Software","Hardware" ], "username": "r1234", "domain": "xyz.com"...
  • Aleksandar_A's avatar
    2 years ago

    Hello deeps,

    I'm not sure of how exactly you want your csv to be structured, but you can join the groups array to a string using .join() function in a Mapper Snap, and then you will have a flat structure that you can format as CSV.

     

    Please refer to the attached pipeline, and let me know if this helps you.

    Regards,

    Aleksandar.