• Resolved seank123

    (@seank123)


    I have the following from a JSON feed:

    {
    “result_summary”: [{
    “id”: 3048818,
    “status”: “New”,
    “published”: “Yes”,
    “last_updated”: “17/09/2017”,
    “league_name”: “Derbyshire County Cricket League”,
    “league_id”: “296”,
    “competition_name”: “ECB Premier Division”,
    “competition_id”: “69547”,
    “competition_type”: “League”,
    “match_type”: “Limited Overs”,
    “game_type”: “Standard”,
    “match_date”: “16/09/2017”,
    “match_time”: “12:00”,
    “ground_name”: “Raygar Arena”,
    “ground_id”: “12682”,
    “home_team_name”: “1st XI”,
    “home_team_id”: “7960”,
    “home_club_name”: “Alvaston & Boulton CC”,
    “home_club_id”: “690”,
    “away_team_name”: “1st XI”,
    “away_team_id”: “50478”,
    “away_club_name”: “Cutthorpe CC”,
    “away_club_id”: “143”,
    “umpire_1_name”: “Peter Gibson”,
    “umpire_1_id”: “3218559”,
    “umpire_2_name”: “Adam Hitchcock”,
    “umpire_2_id”: “12683”,
    “umpire_3_id”: “”,
    “referee_id”: “”,
    “scorer_1_id”: “”,
    “scorer_2_id”: “”,
    “toss_won_by_team_id”: “50478”,
    “toss”: “Cutthorpe CC – 1st XI won the toss and elected to bat”,
    “batted_first”: “50478”,
    “no_of_overs”: “”,
    “no_of_innings”: “1”,
    “result”: “W”,
    “result_description”: “Alvaston & Boulton CC – 1st XI – Won bat second 27”,
    “result_applied_to”: “7960”,
    “match_notes”: “<br><b>Cutthorpe innings:</b> A Thompson 100, E Barlow 38, K
    Leatherday 42, L Sadler 33, C Stevenson 3-58<br><b>Alvaston & Boulton innings:</b> C McIlroy
    90, M Gapes 132*, S Stubbings 38*<br><br><br>MoM 3pts: M Gapes<br>MoM 2pts: A
    Thompson<br>MoM 1pt: C McIlroy”,
    “points”: [{
    “team_id”: 7960,
    “game_points”: “27”,
    “penalty_points”: “0.0”,
    “bonus_points_together”: “”,
    “bonus_points_batting”: “0.0”,
    “bonus_points_bowling”: “0.0”,
    “bonus_points_2nd_innings_together”: “”
    }, {
    “team_id”: 50478,
    “game_points”: “0”,
    “penalty_points”: “0.0”,
    “bonus_points_together”: “”,
    “bonus_points_batting”: “5.0”,
    “bonus_points_bowling”: “1.0”,
    “bonus_points_2nd_innings_together”: “”
    }],
    “innings”: [{
    “team_batting_id”: “50478”,
    “innings_number”: 1,
    “extra_byes”: “1”,
    “extra_leg_byes”: “10”,
    “extra_wides”: “9”,
    “extra_no_balls”: “7”,
    “extra_penalty_runs”: “0”,
    “penalties_runs_awarded_in_other_innings”: “0”,
    “total_extras”: “27”,
    “runs”: “287”,
    “wickets”: “7”,
    “overs”: “50.0”,
    “declared”: false,
    “revised_target_runs”: “”,
    “revised_target_overs”: “”
    },
    {
    “team_batting_id”: “7960”,
    “innings_number”: 1,
    “extra_byes”: “0”,
    “extra_leg_byes”: “0”,
    “extra_wides”: “12”,
    “extra_no_balls”: “0”,
    “extra_penalty_runs”: “0”,
    “penalties_runs_awarded_in_other_innings”: “0”,
    “total_extras”: “12”,
    “runs”: “287”,
    “wickets”: “2”,
    “overs”: “46.3”,
    “declared”: false,
    “revised_target_runs”: “”,
    “revised_target_overs”: “”
    }
    ]
    },
    {
    “id”: 3048819,
    .
    .
    .)
    ]
    }

    What I need to do is get the “runs” and “wickets” values – but there are two different ones – “team_batting_id”: “50478” and “team_batting_id”: “7960” under “innings” – is it possible to get these two values into cells in a table? And to populate the rows with further results from the feed?

    Many thanks

Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Struggling with getting data’ is closed to new replies.