To be completed by the original poster:
CMS Version
2.3.7
Player Type
Windows
Player Version
N/A (all)
Issue
I’m having trouble with a remote JSON datasource that an array inside the data root that I’m trying to query. I’ve been unable to get the data out into columns.
I’d like to get all the nodes under the entries arrays under the days node.
I’ve tried a few combinations in the columns like entries.max $.forcasts.weather.days.entries.max and haven’t managed to get it to work.
If I look at the output below it show that this sub-array isn’t being processed at all?
{
“entries”: [
{
“location”: {
“id”: 16,
“name”: “Canberra”,
“region”: “Canberra”,
“state”: “ACT”,
“postcode”: “2600”,
“timeZone”: “Australia/Sydney”,
“lat”: -35.282,
“lng”: 149.1286,
“typeId”: 22
},
“forecasts”: {
“weather”: {
“days”: [
{
“dateTime”: “2020-09-10 00:00:00”,
“entries”: [
{
“dateTime”: “2020-09-10 00:00:00”,
“precisCode”: “partly-cloudy”,
“precis”: “Partly cloudy”,
“precisOverlayCode”: “”,
“night”: false,
“min”: 5,
“max”: 14
}
]
},
{
“dateTime”: “2020-09-11 00:00:00”,
“entries”: [
{
“dateTime”: “2020-09-11 00:00:00”,
“precisCode”: “partly-cloudy”,
“precis”: “Cloud clearing”,
“precisOverlayCode”: “”,
“night”: false,
“min”: 3,
“max”: 17
}
]
},
{
“dateTime”: “2020-09-12 00:00:00”,
“entries”: [
{
“dateTime”: “2020-09-12 00:00:00”,
“precisCode”: “mostly-fine”,
“precis”: “Mostly sunny”,
“precisOverlayCode”: “”,
“night”: false,
“min”: 3,
“max”: 18
}
]
},
{
“dateTime”: “2020-09-13 00:00:00”,
“entries”: [
{
“dateTime”: “2020-09-13 00:00:00”,
“precisCode”: “chance-shower-cloud”,
“precis”: “Shower or two”,
“precisOverlayCode”: “”,
“night”: false,
“min”: 7,
“max”: 17
}
]
},
{
“dateTime”: “2020-09-14 00:00:00”,
“entries”: [
{
“dateTime”: “2020-09-14 00:00:00”,
“precisCode”: “partly-cloudy”,
“precis”: “Cloud clearing”,
“precisOverlayCode”: “”,
“night”: false,
“min”: 6,
“max”: 19
}
]
},
{
“dateTime”: “2020-09-15 00:00:00”,
“entries”: [
{
“dateTime”: “2020-09-15 00:00:00”,
“precisCode”: “partly-cloudy”,
“precis”: “Partly cloudy”,
“precisOverlayCode”: “”,
“night”: false,
“min”: 2,
“max”: 19
}
]
},
{
“dateTime”: “2020-09-16 00:00:00”,
“entries”: [
{
“dateTime”: “2020-09-16 00:00:00”,
“precisCode”: “partly-cloudy”,
“precis”: “Partly cloudy”,
“precisOverlayCode”: “”,
“night”: false,
“min”: 5,
“max”: 19
}
]
}
],
“units”: {
“temperature”: “c”
},
“issueDateTime”: “2020-09-10 07:07:50”
}
}
}
],
“number”: 1,
“processed”: [
[
{
“date”: {
“date”: “2020-09-10 00:00:00.000000”,
“timezone_type”: 3,
“timezone”: “Australia/Sydney”
}
},
{
“date”: {
“date”: “2020-09-11 00:00:00.000000”,
“timezone_type”: 3,
“timezone”: “Australia/Sydney”
}
},
{
“date”: {
“date”: “2020-09-12 00:00:00.000000”,
“timezone_type”: 3,
“timezone”: “Australia/Sydney”
}
},
{
“date”: {
“date”: “2020-09-13 00:00:00.000000”,
“timezone_type”: 3,
“timezone”: “Australia/Sydney”
}
},
{
“date”: {
“date”: “2020-09-14 00:00:00.000000”,
“timezone_type”: 3,
“timezone”: “Australia/Sydney”
}
},
{
“date”: {
“date”: “2020-09-15 00:00:00.000000”,
“timezone_type”: 3,
“timezone”: “Australia/Sydney”
}
},
{
“date”: {
“date”: “2020-09-16 00:00:00.000000”,
“timezone_type”: 3,
“timezone”: “Australia/Sydney”
}
}
]
],
“messages”: [
“Processing 1 results into 4 potential columns”,
“Processing Result with Data Root forecasts.weather.days”,
“DataRoot is an array”,
“Processing 0”,
“Processing 1”,
“Processing 2”,
“Processing 3”,
“Processing 4”,
“Processing 5”,
“Processing 6”,
“Consolidating entries”,
“There are 7 entries in total”
]
}