How to postprocess JSON?

Hello,

From an API I get JSON like this:

{
    "2019-10": [
        {
            "apples": 1,
            "pears": 2,
            "peaches": 3
        }
    ],
    "2019-11": [
        {
            "apples": 4,
            "pears": 5,
            "peaches": 6
        }
    ],
    "2019-12": [
        {
            "apples": 7,
            "pears": 8,
            "peaches": 9
        }
    ]
}

When I make a table from that I get a column for each month string and everything including/between the […] as value. Is there a way to format this to get four columns, one for month, three for the fruits? Or is there a even better way to handle the month strings? Is it somehow possible to use them in graphs as time line?

1 Like

I solved this by using the python data source instead of the JSON data source and reorganizing the data on my own.