Hi, this is my first post here in Make Community. Could you guys help me with something?
I am trying to convert a JSON file, coming from an API call, in a CSV file. I am unable to process the complex fields, which are JSON lists.
{
"results": [
{
"goal_name": "Goal Test Homer and Marge",
"responsible": [
{
"key": "homer@email.com",
"user": {
"id": 123,
"first_name": "Homer",
"last_name": "Simpson",
"username": "homer@email.com",
"email": "homer@email.com"
},
"weight": "1.0000"
},
{
"key": "marge@email.com",
"user": {
"id": 456,
"first_name": "Marge",
"last_name": "Simpson",
"username": "marge@email.com",
"email": "marge@email.com"
},
"weight": "1.0000"
}
]
},
{
"goal_name": "Goal Test Bart and Lisa",
"responsible": [
{
"key": "bart@email.com",
"user": {
"id": 321,
"first_name": "Bart",
"last_name": "Simpson",
"username": "bart@email.com",
"email": "bart@email.com"
},
"weight": "1.0000"
},
{
"key": "lisa@email.com",
"user": {
"id": 654,
"first_name": "Lisa",
"last_name": "Simpson",
"username": "lisa@email.com",
"email": "lisa@email.com"
},
"weight": "1.0000"
}
]
}
]
}
I have in my CSV 2 columns. One is the goal name (that I have already managed to solve) and the other, called responsible, I need write all first and last names of the objects in list, separeted by comma. In this example I gave, it would be:
| goal_name | responsible |
|---|---|
| Goal Test Homer and Marge | Homer Simpson, Marge Simpson |
| Goal Test Bart and Lisa | Bart Simpson, Lisa Simpson |
This is my scenario. Please, someone to help me?
