Struggling with getting data
-
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
- The topic ‘Struggling with getting data’ is closed to new replies.