Hi, I can use some help with getting some data from a JSON source in a Dataset. This is the JSON:
“data”: [
{
“birthdays”: [
{
“birthdate”: “10 oktober”,
“name”: “Henkie Janssen”
},
{
“birthdate”: “12 oktober”,
“name”: “Jan Henkert”
}
]
},
{
“birthdays”: [
{
“birthdate”: “29 oktober”,
“name”: “Willem Karelse”
}
]
},
{
“birthdays”: [
{
“birthdate”: “2 november”,
“name”: “Leo Peters”
}
]
}
]
Unfortunately I can not extract the birthdate and name from the JSON. When I set the dataset data root to ‘data’ and the column remote data path to ‘birthdays.birthdate’ and ‘birthdays.name’ this is the output.
{
“entries”: [
{
“data”: [
{
“birthdays”: [
{
“birthdate”: “10 oktober”,
“name”: “Henkie Janssen”
},
{
“birthdate”: “12 oktober”,
“name”: “Jan Henkert”
}
]
},
{
“birthdays”: [
{
“birthdate”: “29 oktober”,
“name”: “Willem Karelse”
}
]
},
{
“birthdays”: [
{
“birthdate”: “2 november”,
“name”: “Leo Peters”
}
]
}
]
}
],
“number”: 1,
“processed”: [
[
,
,
]
],
“messages”: [
“Processing 1 results into 2 potential columns”,
“Processing Result with Data Root data”,
“DataRoot is an array”,
“Processing 0”,
“Processing 1”,
“Processing 2”,
“Consolidating entries”,
“There are 3 entries in total”
]
}
So no data in the processed part.
When i set the dataset data root to ‘data.birthdays’ or ‘birthdays’ the output is
“No data found at the DataRoot data.birthdays” and “No data found at the DataRoot birthdays”.
How can I extract the data birthdate and name from this JSON?
