Skip to content
This repository has been archived by the owner on Feb 2, 2023. It is now read-only.

Flatten JSON not create new rows #245

Open
TheGeneralLedge opened this issue Dec 30, 2022 · 0 comments
Open

Flatten JSON not create new rows #245

TheGeneralLedge opened this issue Dec 30, 2022 · 0 comments

Comments

@TheGeneralLedge
Copy link

I would like to have my nested JSON appear on a single row instead of 2 rows - see example JSON below. At the moment I get two rows based on /result_summary/ID as the Innings Team batting ID is different. I would like to flatten all of this JSON into a single row but cant see which bit of the Code for ImportJSON I need to change to prevent the looping for each innings.

Any help would be much appreciated.

{
"result_summary": [
{
"id": 123456,
"status": "New",
"published": "Yes",
"last_updated": "01/01/2022",
"league_name": "",
"league_id": "",
"ground_name": "Lords",
"ground_id": "AB12345",
"home_team_name": "1st XI",
"home_team_id": "unique-ref",
"points": [],
"innings": [
{
"team_batting_id": "unique-ref",
"innings_number": 1,
"runs": "",
"wickets": "",
"overs": "",
"balls": "",
},
{
"team_batting_id": "unique-ref",
"innings_number": 1,
"runs": "",
"wickets": "",
"overs": "",
"balls": "",

            }
        ]
    },
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant