System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'StatusId'.
Invalid column name 'ErrorLog'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Etoz.ConnectData.DataAccess.ExecuteQuery(String query) in c:\inetpub\wwwroot\cricdirect.com\api\v6\App_Code\db\data_access.cs:line 117
ClientConnectionId:df2b0711-5486-4766-8de3-b39599fc3c60
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90590 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90590,1,'{"status":"ok","response":{"mid":90590,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Upminster-W won by 10 wickets (DLS method)","day_remaining_over":"","team_batting":"Upminster-W","team_bowling":"Hutton-W","live_inning_number":2,"live_score":{"runs":56,"overs":4,"wickets":0,"target":56,"runrate":14,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Paige Roche","batsman_id":149543,"runs":7,"balls_faced":5,"fours":1,"sixes":0,"strike_rate":"140.00"},{"name":"Sunette Viljoen","batsman_id":122306,"runs":47,"balls_faced":20,"fours":8,"sixes":1,"strike_rate":"235.00"}],"bowlers":[{"name":"Isobel Maddison","bowler_id":149570,"overs":1,"runs_conceded":13,"wickets":0,"maidens":0,"econ":"13.00"},{"name":"Amara Law","bowler_id":149568,"overs":1,"runs_conceded":18,"wickets":0,"maidens":0,"econ":"18.00"}],"commentaries":[{"event_id":"12094582","event":"ball","batsman_id":"122306","bowler_id":"149560","over":"0","ball":"1","score":4,"commentary":"Lauren Pamenter to Sunette Viljoen, Four,","noball_dismissal":false,"text":"","timestamp":1749312444,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12094584","event":"ball","batsman_id":"122306","bowler_id":"149560","over":"0","ball":"2","score":1,"commentary":"Lauren Pamenter to Sunette Viljoen, 1 run,","noball_dismissal":false,"text":"","timestamp":1749312447,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12094585","event":"ball","batsman_id":"149543","bowler_id":"149560","over":"0","ball":"3","score":4,"commentary":"Lauren Pamenter to Paige Roche, Four,","noball_dismissal":false,"text":"","timestamp":1749312450,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12094589","event":"ball","batsman_id":"149543","bowler_id":"149560","over":"0","ball":"4","score":0,"commentary":"Lauren Pamenter to Paige Roche, no run,","noball_dismissal":false,"text":"","timestamp":1749312476,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12094591","event":"ball","batsman_id":"149543","bowler_id":"149560","over":"0","ball":"5","score":1,"commentary":"Lauren Pamenter to Paige Roche, 1 run,","noball_dismissal":false,"text":"","timestamp":1749312490,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12094612","event":"ball","batsman_id":"122306","bowler_id":"149560","over":"0","ball":"6","score":0,"commentary":"Lauren Pamenter to Sunette Viljoen, no run,","noball_dismissal":false,"text":"","timestamp":1749312755,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":1,"runs":10,"score":"10\/0","bats":[{"runs":5,"balls_faced":3,"fours":1,"sixes":0,"batsman_id":122306},{"runs":5,"balls_faced":3,"fours":1,"sixes":0,"batsman_id":149543}],"bowls":[{"runs_conceded":10,"maidens":0,"wickets":0,"bowler_id":149560,"overs":1}],"commentary":"End of over 1 (10 runs), Upminster-W 10\/0"},{"event_id":"12094630","event":"ball","batsman_id":"149543","bowler_id":"107851","over":"1","ball":"1","score":1,"commentary":"Erica Hobson to Paige Roche, 1 run,","noball_dismissal":false,"text":"","timestamp":1749312760,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12094631","event":"ball","batsman_id":"122306","bowler_id":"107851","over":"1","ball":"2","score":0,"commentary":"Erica Hobson to Sunette Viljoen, no run,","noball_dismissal":false,"text":"","timestamp":1749312764,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12094632","event":"ball","batsman_id":"122306","bowler_id":"107851","over":"1","ball":"3","score":4,"commentary":"Erica Hobson to Sunette Viljoen, Four,","noball_dismissal":false,"text":"","timestamp":1749312767,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12094635","event":"ball","batsman_id":"122306","bowler_id":"107851","over":"1","ball":"4","score":4,"commentary":"Erica Hobson to Sunette Viljoen, Four,","noball_dismissal":false,"text":"","timestamp":1749312771,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12094636","event":"ball","batsman_id":"122306","bowler_id":"107851","over":"1","ball":"5","score":4,"commentary":"Erica Hobson to Sunette Viljoen, Four,","noball_dismissal":false,"text":"","timestamp":1749312774,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12094639","event":"ball","batsman_id":"122306","bowler_id":"107851","over":"1","ball":"6","score":1,"commentary":"Erica Hobson to Sunette Viljoen, 1 run,","noball_dismissal":false,"text":"","timestamp":1749312785,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":2,"runs":14,"score":"24\/0","bats":[{"runs":18,"balls_faced":8,"fours":4,"sixes":0,"batsman_id":122306},{"runs":6,"balls_faced":4,"fours":1,"sixes":0,"batsman_id":149543}],"bowls":[{"runs_conceded":14,"maidens":0,"wickets":0,"bowler_id":107851,"overs":1},{"runs_conceded":10,"maidens":0,"wickets":0,"bowler_id":149560,"overs":1}],"commentary":"End of over 2 (14 runs), Upminster-W 24\/0"},{"event_id":"12094658","event":"ball","batsman_id":"122306","bowler_id":"149568","over":"2","ball":"1","score":2,"commentary":"Amara Law to Sunette Viljoen, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749312983,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12094659","event":"ball","batsman_id":"122306","bowler_id":"149568","over":"2","ball":"2","score":6,"commentary":"Amara Law to Sunette Viljoen, Six,","noball_dismissal":false,"text":"","timestamp":1749312988,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12094662","event":"ball","batsman_id":"122306","bowler_id":"149568","over":"2","ball":"3","score":"1nb","commentary":"Amara Law to Sunette Viljoen, 1 no ball,","noball_dismissal":false,"text":"","timestamp":1749312992,"run":1,"noball_run":"1","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":true,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12094665","event":"ball","batsman_id":"122306","bowler_id":"149568","over":"2","ball":"3","score":2,"commentary":"Amara Law to Sunette Viljoen, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749312995,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12094666","event":"ball","batsman_id":"122306","bowler_id":"149568","over":"2","ball":"4","score":2,"commentary":"Amara Law to Sunette Viljoen, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749312999,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12094674","event":"ball","batsman_id":"122306","bowler_id":"149568","over":"2","ball":"5","score":4,"commentary":"Amara Law to Sunette Viljoen, Four,","noball_dismissal":false,"text":"","timestamp":1749313021,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12094678","event":"ball","batsman_id":"122306","bowler_id":"149568","over":"2","ball":"6","score":1,"commentary":"Amara Law to Sunette Viljoen, 1 run,","noball_dismissal":false,"text":"","timestamp":1749313336,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":3,"runs":18,"score":"42\/0","bats":[{"runs":35,"balls_faced":15,"fours":5,"sixes":1,"batsman_id":122306},{"runs":6,"balls_faced":4,"fours":1,"sixes":0,"batsman_id":149543}],"bowls":[{"runs_conceded":18,"maidens":0,"wickets":0,"bowler_id":149568,"overs":1},{"runs_conceded":14,"maidens":0,"wickets":0,"bowler_id":107851,"overs":1}],"commentary":"End of over 3 (18 runs), Upminster-W 42\/0"},{"event_id":"12094715","event":"ball","batsman_id":"122306","bowler_id":"149570","over":"3","ball":"1","score":4,"commentary":"Isobel Maddison to Sunette Viljoen, Four,","noball_dismissal":false,"text":"","timestamp":1749313340,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12094716","event":"ball","batsman_id":"122306","bowler_id":"149570","over":"3","ball":"2","score":0,"commentary":"Isobel Maddison to Sunette Viljoen, no run,","noball_dismissal":false,"text":"","timestamp":1749313344,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12094717","event":"ball","batsman_id":"122306","bowler_id":"149570","over":"3","ball":"3","score":"1lb","commentary":"Isobel Maddison to Sunette Viljoen, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1749313347,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"1","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12094718","event":"ball","batsman_id":"149543","bowler_id":"149570","over":"3","ball":"4","score":1,"commentary":"Isobel Maddison to Paige Roche, 1 run,","noball_dismissal":false,"text":"","timestamp":1749313350,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12094722","event":"ball","batsman_id":"122306","bowler_id":"149570","over":"3","ball":"5","score":4,"commentary":"Isobel Maddison to Sunette Viljoen, Four,","noball_dismissal":false,"text":"","timestamp":1749313354,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12094723","event":"ball","batsman_id":"122306","bowler_id":"149570","over":"3","ball":"6","score":4,"commentary":"Isobel Maddison to Sunette Viljoen, Four,","noball_dismissal":false,"text":"","timestamp":1749313357,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event":"overend","over":4,"runs":14,"score":"56\/0","bats":[{"runs":47,"balls_faced":20,"fours":8,"sixes":1,"batsman_id":122306},{"runs":7,"balls_faced":5,"fours":1,"sixes":0,"batsman_id":149543}],"bowls":[{"runs_conceded":13,"maidens":0,"wickets":0,"bowler_id":149570,"overs":1},{"runs_conceded":18,"maidens":0,"wickets":0,"bowler_id":149568,"overs":1}],"commentary":"End of over 4 (14 runs), Upminster-W 56\/0"}],"day":"0","session":"0","live_inning":{"iid":197621,"number":2,"name":"Upminster-W Inning","short_name":"UPW-W Inning","status":2,"issuperover":"false","result":3,"batting_team_id":128979,"fielding_team_id":128978,"scores":"56\/0","scores_full":"56\/0 (4 ov)","fielder":[],"powerplay":{"p1":{"startover":"0.1","endover":"3"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":[],"extra_runs":{"byes":0,"legbyes":1,"wides":0,"noballs":1,"penalty":"0","total":2},"equations":{"runs":56,"wickets":0,"overs":"4","bowlers_used":4,"runrate":"14.00"},"current_partnership":{"runs":56,"balls":25,"overs":4.1,"batsmen":[{"name":"Sunette Viljoen","batsman_id":122306,"runs":47,"balls":20},{"name":"Paige Roche","batsman_id":149543,"runs":7,"balls":5}]},"did_not_bat":[{"player_id":"149544","name":"Harry Goodey"},{"player_id":"149534","name":"Felicity Russell"},{"player_id":"149546","name":"Zoe Quested"},{"player_id":"149541","name":"Dani Cox"},{"player_id":"149545","name":"Keya Shah"},{"player_id":"149552","name":"Lauren Plumb"},{"player_id":"149549","name":"Lois Gable"},{"player_id":"149551","name":"Maisie Coles"},{"player_id":"149537","name":"Angela Green"}],"max_over":"5","target":"56","recent_scores":"4,4,1,1,0,4,1,4,2,2,1,6,2,1,4,4,4,0","last_five_overs":"56\/0 13.44","last_ten_overs":"56\/0 13.44"},"teams":[{"tid":128978,"title":"Hutton-W","abbr":"HUT-W","alt_name":"Hutton-W","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Hutton-W.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Hutton-W.png","country":"en","sex":"female","team_owner":"","head_coach":"","scores_full":"99\/6 (10 ov)","scores":"99\/6","overs":"10"},{"tid":128979,"title":"Upminster-W","abbr":"UPW-W","alt_name":"Upminster-W","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Upminster-W.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Upminster-W.png","country":"en","sex":"female","team_owner":"","head_coach":"","scores_full":"56\/0 (4 ov)","scores":"56\/0","overs":"4"}],"players":[{"pid":107851,"title":"Erica Hobson","short_name":"E Hobson","first_name":"Erica Hobson","last_name":"","middle_name":"","birthdate":"2003-08-18","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"pid":122306,"title":"Sunette Viljoen","short_name":"S Viljoen","first_name":"Sunette Viljoen","last_name":"","middle_name":"","birthdate":"1983-10-06","birthplace":"","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","role_str":""},{"pid":149534,"title":"Felicity Russell","short_name":"F Russell","first_name":"Felicity Russell","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(C)"},{"pid":149535,"title":"Beth Libby","short_name":"B Libby","first_name":"Beth Libby","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"squad","role_str":""},{"pid":149536,"title":"Georgia Hayes","short_name":"G Hayes","first_name":"Georgia Hayes","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"squad","role_str":""},{"pid":149537,"title":"Angela Green","short_name":"A Green","first_name":"Angela Green","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"bat","role_str":""},{"pid":149538,"title":"Holly Minney","short_name":"H Minney","first_name":"Holly Minney","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":149539,"title":"Jami Armes","short_name":"J Armes","first_name":"Jami Armes","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":149540,"title":"Emma Noller","short_name":"E Noller","first_name":"Emma Noller","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"squad","role_str":""},{"pid":149541,"title":"Dani Cox","short_name":"D Cox","first_name":"Dani Cox","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"bat","role_str":""},{"pid":149542,"title":"Karen Burley","short_name":"K Burley","first_name":"Karen Burley","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"squad","role_str":""},{"pid":149543,"title":"Paige Roche","short_name":"P Roche","first_name":"Paige Roche","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"all","role_str":""},{"pid":149544,"title":"Harry Goodey","short_name":"H Goodey","first_name":"Harry Goodey","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"all","role_str":""},{"pid":149545,"title":"Keya Shah","short_name":"K Shah","first_name":"Keya Shah","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"all","role_str":""},{"pid":149546,"title":"Zoe Quested","short_name":"Z Quested","first_name":"Zoe Quested","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"bowl","role_str":"(WK)"},{"pid":149547,"title":"Toni Woodgate","short_name":"T Woodgate","first_name":"Toni Woodgate","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"squad","role_str":""},{"pid":149548,"title":"Coco Thomas","short_name":"C Thomas","first_name":"Coco Thomas","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"squad","role_str":""},{"pid":149549,"title":"Lois Gable","short_name":"L Gable","first_name":"Lois Gable","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"bowl","role_str":""},{"pid":149550,"title":"Bethany Law","short_name":"B Law","first_name":"Bethany Law","last_name":"","middle_name":"","birthdate":"2006-12-04","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":149551,"title":"Maisie Coles","short_name":"M Coles","first_name":"Maisie Coles","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":149552,"title":"Lauren Plumb","short_name":"L Plumb","first_name":"Lauren Plumb","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"bowl","role_str":""},{"pid":149553,"title":"Scarlett Robinson","short_name":"S Robinson","first_name":"Scarlett Robinson","last_name":"","middle_name":"","birthdate":"2011-05-16","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":149554,"title":"Darcy Sturt","short_name":"D Sturt","first_name":"Darcy Sturt","last_name":"","middle_name":"","birthdate":"2010-10-14","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":149555,"title":"Kashish Patel","short_name":"K Patel","first_name":"Kashish Patel","last_name":"","middle_name":"","birthdate":"2002-12-11","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"squad","role_str":""},{"pid":149557,"title":"Maddie Griffin","short_name":"M Griffin","first_name":"Maddie Griffin","last_name":"","middle_name":"","birthdate":"2005-05-22","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":149559,"title":"Hannah Bratt","short_name":"H Bratt","first_name":"Hannah Bratt","last_name":"","middle_name":"","birthdate":"1998-10-17","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":149560,"title":"Lauren Pamenter","short_name":"L Pamenter","first_name":"Lauren Pamenter","last_name":"","middle_name":"","birthdate":"2001-11-06","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":149561,"title":"Anaya Shankar","short_name":"A Shankar","first_name":"Anaya Shankar","last_name":"","middle_name":"","birthdate":"2011-06-15","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":149562,"title":"Harriet Robinson","short_name":"H Robinson","first_name":"Harriet Robinson","last_name":"","middle_name":"","birthdate":"2009-10-15","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"squad","role_str":""},{"pid":149563,"title":"Chloe Stretton","short_name":"C Stretton","first_name":"Chloe Stretton","last_name":"","middle_name":"","birthdate":"2010-08-30","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":149564,"title":"Abi Little","short_name":"A Little","first_name":"Abi Little","last_name":"","middle_name":"","birthdate":"2007-12-17","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":149566,"title":"Sophia Macklin","short_name":"S Macklin","first_name":"Sophia Macklin","last_name":"","middle_name":"","birthdate":"2011-07-16","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":149568,"title":"Amara Law","short_name":"A Law","first_name":"Amara Law","last_name":"","middle_name":"","birthdate":"2007-12-07","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"bowl","role_str":""},{"pid":149570,"title":"Isobel Maddison","short_name":"I Maddison","first_name":"Isobel Maddison","last_name":"","middle_name":"","birthdate":"2010-04-14","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":149571,"title":"Elena Dale","short_name":"E Dale","first_name":"Elena Dale","last_name":"","middle_name":"","birthdate":"2009-03-13","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":149622,"title":"Rachel Pearce","short_name":"R Pearce","first_name":"Rachel Pearce","last_name":"","middle_name":"","birthdate":"2009-06-01","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""}]},"etag":"db6e3a4266671af7efb98dfd11648390","modified":"2025-07-04 15:52:02","datetime":"2025-07-04 15:52:02","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":90590,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Upminster-W won by 10 wickets (DLS method)","day_remaining_over":"","team_batting":"Upminster-W","team_bowling":"Hutton-W","live_inning_number":2,"live_score":{"runs":56,"overs":4,"wickets":0,"target":56,"runrate":14,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Paige Roche","batsman_id":149543,"runs":7,"balls_faced":5,"fours":1,"sixes":0,"strike_rate":"140.00"},{"name":"Sunette Viljoen","batsman_id":122306,"runs":47,"balls_faced":20,"fours":8,"sixes":1,"strike_rate":"235.00"}],"bowlers":[{"name":"Isobel Maddison","bowler_id":149570,"overs":1,"runs_conceded":13,"wickets":0,"maidens":0,"econ":"13.00"},{"name":"Amara Law","bowler_id":149568,"overs":1,"runs_conceded":18,"wickets":0,"maidens":0,"econ":"18.00"}],"commentaries":[{"event_id":"12094582","event":"ball","batsman_id":"122306","bowler_id":"149560","over":"0","ball":"1","score":4,"commentary":"Lauren Pamenter to Sunette Viljoen, Four,","noball_dismissal":false,"text":"","timestamp":1749312444,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12094584","event":"ball","batsman_id":"122306","bowler_id":"149560","over":"0","ball":"2","score":1,"commentary":"Lauren Pamenter to Sunette Viljoen, 1 run,","noball_dismissal":false,"text":"","timestamp":1749312447,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12094585","event":"ball","batsman_id":"149543","bowler_id":"149560","over":"0","ball":"3","score":4,"commentary":"Lauren Pamenter to Paige Roche, Four,","noball_dismissal":false,"text":"","timestamp":1749312450,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12094589","event":"ball","batsman_id":"149543","bowler_id":"149560","over":"0","ball":"4","score":0,"commentary":"Lauren Pamenter to Paige Roche, no run,","noball_dismissal":false,"text":"","timestamp":1749312476,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12094591","event":"ball","batsman_id":"149543","bowler_id":"149560","over":"0","ball":"5","score":1,"commentary":"Lauren Pamenter to Paige Roche, 1 run,","noball_dismissal":false,"text":"","timestamp":1749312490,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12094612","event":"ball","batsman_id":"122306","bowler_id":"149560","over":"0","ball":"6","score":0,"commentary":"Lauren Pamenter to Sunette Viljoen, no run,","noball_dismissal":false,"text":"","timestamp":1749312755,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":1,"runs":10,"score":"10\/0","bats":[{"runs":5,"balls_faced":3,"fours":1,"sixes":0,"batsman_id":122306},{"runs":5,"balls_faced":3,"fours":1,"sixes":0,"batsman_id":149543}],"bowls":[{"runs_conceded":10,"maidens":0,"wickets":0,"bowler_id":149560,"overs":1}],"commentary":"End of over 1 (10 runs), Upminster-W 10\/0"},{"event_id":"12094630","event":"ball","batsman_id":"149543","bowler_id":"107851","over":"1","ball":"1","score":1,"commentary":"Erica Hobson to Paige Roche, 1 run,","noball_dismissal":false,"text":"","timestamp":1749312760,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12094631","event":"ball","batsman_id":"122306","bowler_id":"107851","over":"1","ball":"2","score":0,"commentary":"Erica Hobson to Sunette Viljoen, no run,","noball_dismissal":false,"text":"","timestamp":1749312764,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12094632","event":"ball","batsman_id":"122306","bowler_id":"107851","over":"1","ball":"3","score":4,"commentary":"Erica Hobson to Sunette Viljoen, Four,","noball_dismissal":false,"text":"","timestamp":1749312767,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12094635","event":"ball","batsman_id":"122306","bowler_id":"107851","over":"1","ball":"4","score":4,"commentary":"Erica Hobson to Sunette Viljoen, Four,","noball_dismissal":false,"text":"","timestamp":1749312771,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12094636","event":"ball","batsman_id":"122306","bowler_id":"107851","over":"1","ball":"5","score":4,"commentary":"Erica Hobson to Sunette Viljoen, Four,","noball_dismissal":false,"text":"","timestamp":1749312774,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12094639","event":"ball","batsman_id":"122306","bowler_id":"107851","over":"1","ball":"6","score":1,"commentary":"Erica Hobson to Sunette Viljoen, 1 run,","noball_dismissal":false,"text":"","timestamp":1749312785,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":2,"runs":14,"score":"24\/0","bats":[{"runs":18,"balls_faced":8,"fours":4,"sixes":0,"batsman_id":122306},{"runs":6,"balls_faced":4,"fours":1,"sixes":0,"batsman_id":149543}],"bowls":[{"runs_conceded":14,"maidens":0,"wickets":0,"bowler_id":107851,"overs":1},{"runs_conceded":10,"maidens":0,"wickets":0,"bowler_id":149560,"overs":1}],"commentary":"End of over 2 (14 runs), Upminster-W 24\/0"},{"event_id":"12094658","event":"ball","batsman_id":"122306","bowler_id":"149568","over":"2","ball":"1","score":2,"commentary":"Amara Law to Sunette Viljoen, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749312983,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12094659","event":"ball","batsman_id":"122306","bowler_id":"149568","over":"2","ball":"2","score":6,"commentary":"Amara Law to Sunette Viljoen, Six,","noball_dismissal":false,"text":"","timestamp":1749312988,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12094662","event":"ball","batsman_id":"122306","bowler_id":"149568","over":"2","ball":"3","score":"1nb","commentary":"Amara Law to Sunette Viljoen, 1 no ball,","noball_dismissal":false,"text":"","timestamp":1749312992,"run":1,"noball_run":"1","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":true,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12094665","event":"ball","batsman_id":"122306","bowler_id":"149568","over":"2","ball":"3","score":2,"commentary":"Amara Law to Sunette Viljoen, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749312995,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12094666","event":"ball","batsman_id":"122306","bowler_id":"149568","over":"2","ball":"4","score":2,"commentary":"Amara Law to Sunette Viljoen, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749312999,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12094674","event":"ball","batsman_id":"122306","bowler_id":"149568","over":"2","ball":"5","score":4,"commentary":"Amara Law to Sunette Viljoen, Four,","noball_dismissal":false,"text":"","timestamp":1749313021,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12094678","event":"ball","batsman_id":"122306","bowler_id":"149568","over":"2","ball":"6","score":1,"commentary":"Amara Law to Sunette Viljoen, 1 run,","noball_dismissal":false,"text":"","timestamp":1749313336,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":3,"runs":18,"score":"42\/0","bats":[{"runs":35,"balls_faced":15,"fours":5,"sixes":1,"batsman_id":122306},{"runs":6,"balls_faced":4,"fours":1,"sixes":0,"batsman_id":149543}],"bowls":[{"runs_conceded":18,"maidens":0,"wickets":0,"bowler_id":149568,"overs":1},{"runs_conceded":14,"maidens":0,"wickets":0,"bowler_id":107851,"overs":1}],"commentary":"End of over 3 (18 runs), Upminster-W 42\/0"},{"event_id":"12094715","event":"ball","batsman_id":"122306","bowler_id":"149570","over":"3","ball":"1","score":4,"commentary":"Isobel Maddison to Sunette Viljoen, Four,","noball_dismissal":false,"text":"","timestamp":1749313340,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12094716","event":"ball","batsman_id":"122306","bowler_id":"149570","over":"3","ball":"2","score":0,"commentary":"Isobel Maddison to Sunette Viljoen, no run,","noball_dismissal":false,"text":"","timestamp":1749313344,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12094717","event":"ball","batsman_id":"122306","bowler_id":"149570","over":"3","ball":"3","score":"1lb","commentary":"Isobel Maddison to Sunette Viljoen, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1749313347,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"1","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12094718","event":"ball","batsman_id":"149543","bowler_id":"149570","over":"3","ball":"4","score":1,"commentary":"Isobel Maddison to Paige Roche, 1 run,","noball_dismissal":false,"text":"","timestamp":1749313350,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12094722","event":"ball","batsman_id":"122306","bowler_id":"149570","over":"3","ball":"5","score":4,"commentary":"Isobel Maddison to Sunette Viljoen, Four,","noball_dismissal":false,"text":"","timestamp":1749313354,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12094723","event":"ball","batsman_id":"122306","bowler_id":"149570","over":"3","ball":"6","score":4,"commentary":"Isobel Maddison to Sunette Viljoen, Four,","noball_dismissal":false,"text":"","timestamp":1749313357,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event":"overend","over":4,"runs":14,"score":"56\/0","bats":[{"runs":47,"balls_faced":20,"fours":8,"sixes":1,"batsman_id":122306},{"runs":7,"balls_faced":5,"fours":1,"sixes":0,"batsman_id":149543}],"bowls":[{"runs_conceded":13,"maidens":0,"wickets":0,"bowler_id":149570,"overs":1},{"runs_conceded":18,"maidens":0,"wickets":0,"bowler_id":149568,"overs":1}],"commentary":"End of over 4 (14 runs), Upminster-W 56\/0"}],"day":"0","session":"0","live_inning":{"iid":197621,"number":2,"name":"Upminster-W Inning","short_name":"UPW-W Inning","status":2,"issuperover":"false","result":3,"batting_team_id":128979,"fielding_team_id":128978,"scores":"56\/0","scores_full":"56\/0 (4 ov)","fielder":[],"powerplay":{"p1":{"startover":"0.1","endover":"3"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":[],"extra_runs":{"byes":0,"legbyes":1,"wides":0,"noballs":1,"penalty":"0","total":2},"equations":{"runs":56,"wickets":0,"overs":"4","bowlers_used":4,"runrate":"14.00"},"current_partnership":{"runs":56,"balls":25,"overs":4.1,"batsmen":[{"name":"Sunette Viljoen","batsman_id":122306,"runs":47,"balls":20},{"name":"Paige Roche","batsman_id":149543,"runs":7,"balls":5}]},"did_not_bat":[{"player_id":"149544","name":"Harry Goodey"},{"player_id":"149534","name":"Felicity Russell"},{"player_id":"149546","name":"Zoe Quested"},{"player_id":"149541","name":"Dani Cox"},{"player_id":"149545","name":"Keya Shah"},{"player_id":"149552","name":"Lauren Plumb"},{"player_id":"149549","name":"Lois Gable"},{"player_id":"149551","name":"Maisie Coles"},{"player_id":"149537","name":"Angela Green"}],"max_over":"5","target":"56","recent_scores":"4,4,1,1,0,4,1,4,2,2,1,6,2,1,4,4,4,0","last_five_overs":"56\/0 13.44","last_ten_overs":"56\/0 13.44"},"teams":[{"tid":128978,"title":"Hutton-W","abbr":"HUT-W","alt_name":"Hutton-W","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Hutton-W.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Hutton-W.png","country":"en","sex":"female","team_owner":"","head_coach":"","scores_full":"99\/6 (10 ov)","scores":"99\/6","overs":"10"},{"tid":128979,"title":"Upminster-W","abbr":"UPW-W","alt_name":"Upminster-W","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Upminster-W.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Upminster-W.png","country":"en","sex":"female","team_owner":"","head_coach":"","scores_full":"56\/0 (4 ov)","scores":"56\/0","overs":"4"}],"players":[{"pid":107851,"title":"Erica Hobson","short_name":"E Hobson","first_name":"Erica Hobson","last_name":"","middle_name":"","birthdate":"2003-08-18","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"pid":122306,"title":"Sunette Viljoen","short_name":"S Viljoen","first_name":"Sunette Viljoen","last_name":"","middle_name":"","birthdate":"1983-10-06","birthplace":"","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","role_str":""},{"pid":149534,"title":"Felicity Russell","short_name":"F Russell","first_name":"Felicity Russell","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(C)"},{"pid":149535,"title":"Beth Libby","short_name":"B Libby","first_name":"Beth Libby","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"squad","role_str":""},{"pid":149536,"title":"Georgia Hayes","short_name":"G Hayes","first_name":"Georgia Hayes","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"squad","role_str":""},{"pid":149537,"title":"Angela Green","short_name":"A Green","first_name":"Angela Green","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"bat","role_str":""},{"pid":149538,"title":"Holly Minney","short_name":"H Minney","first_name":"Holly Minney","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":149539,"title":"Jami Armes","short_name":"J Armes","first_name":"Jami Armes","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":149540,"title":"Emma Noller","short_name":"E Noller","first_name":"Emma Noller","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"squad","role_str":""},{"pid":149541,"title":"Dani Cox","short_name":"D Cox","first_name":"Dani Cox","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"bat","role_str":""},{"pid":149542,"title":"Karen Burley","short_name":"K Burley","first_name":"Karen Burley","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"squad","role_str":""},{"pid":149543,"title":"Paige Roche","short_name":"P Roche","first_name":"Paige Roche","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"all","role_str":""},{"pid":149544,"title":"Harry Goodey","short_name":"H Goodey","first_name":"Harry Goodey","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"all","role_str":""},{"pid":149545,"title":"Keya Shah","short_name":"K Shah","first_name":"Keya Shah","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"all","role_str":""},{"pid":149546,"title":"Zoe Quested","short_name":"Z Quested","first_name":"Zoe Quested","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"bowl","role_str":"(WK)"},{"pid":149547,"title":"Toni Woodgate","short_name":"T Woodgate","first_name":"Toni Woodgate","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"squad","role_str":""},{"pid":149548,"title":"Coco Thomas","short_name":"C Thomas","first_name":"Coco Thomas","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"squad","role_str":""},{"pid":149549,"title":"Lois Gable","short_name":"L Gable","first_name":"Lois Gable","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"bowl","role_str":""},{"pid":149550,"title":"Bethany Law","short_name":"B Law","first_name":"Bethany Law","last_name":"","middle_name":"","birthdate":"2006-12-04","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":149551,"title":"Maisie Coles","short_name":"M Coles","first_name":"Maisie Coles","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":149552,"title":"Lauren Plumb","short_name":"L Plumb","first_name":"Lauren Plumb","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"bowl","role_str":""},{"pid":149553,"title":"Scarlett Robinson","short_name":"S Robinson","first_name":"Scarlett Robinson","last_name":"","middle_name":"","birthdate":"2011-05-16","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":149554,"title":"Darcy Sturt","short_name":"D Sturt","first_name":"Darcy Sturt","last_name":"","middle_name":"","birthdate":"2010-10-14","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":149555,"title":"Kashish Patel","short_name":"K Patel","first_name":"Kashish Patel","last_name":"","middle_name":"","birthdate":"2002-12-11","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"squad","role_str":""},{"pid":149557,"title":"Maddie Griffin","short_name":"M Griffin","first_name":"Maddie Griffin","last_name":"","middle_name":"","birthdate":"2005-05-22","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":149559,"title":"Hannah Bratt","short_name":"H Bratt","first_name":"Hannah Bratt","last_name":"","middle_name":"","birthdate":"1998-10-17","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":149560,"title":"Lauren Pamenter","short_name":"L Pamenter","first_name":"Lauren Pamenter","last_name":"","middle_name":"","birthdate":"2001-11-06","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":149561,"title":"Anaya Shankar","short_name":"A Shankar","first_name":"Anaya Shankar","last_name":"","middle_name":"","birthdate":"2011-06-15","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":149562,"title":"Harriet Robinson","short_name":"H Robinson","first_name":"Harriet Robinson","last_name":"","middle_name":"","birthdate":"2009-10-15","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"squad","role_str":""},{"pid":149563,"title":"Chloe Stretton","short_name":"C Stretton","first_name":"Chloe Stretton","last_name":"","middle_name":"","birthdate":"2010-08-30","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":149564,"title":"Abi Little","short_name":"A Little","first_name":"Abi Little","last_name":"","middle_name":"","birthdate":"2007-12-17","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":149566,"title":"Sophia Macklin","short_name":"S Macklin","first_name":"Sophia Macklin","last_name":"","middle_name":"","birthdate":"2011-07-16","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":149568,"title":"Amara Law","short_name":"A Law","first_name":"Amara Law","last_name":"","middle_name":"","birthdate":"2007-12-07","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"bowl","role_str":""},{"pid":149570,"title":"Isobel Maddison","short_name":"I Maddison","first_name":"Isobel Maddison","last_name":"","middle_name":"","birthdate":"2010-04-14","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":149571,"title":"Elena Dale","short_name":"E Dale","first_name":"Elena Dale","last_name":"","middle_name":"","birthdate":"2009-03-13","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":149622,"title":"Rachel Pearce","short_name":"R Pearce","first_name":"Rachel Pearce","last_name":"","middle_name":"","birthdate":"2009-06-01","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""}]},"etag":"db6e3a4266671af7efb98dfd11648390","modified":"2025-07-04 15:52:02","datetime":"2025-07-04 15:52:02","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90590 AND DataTypeId = 1 END
System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'StatusId'.
Invalid column name 'ErrorLog'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Etoz.ConnectData.DataAccess.ExecuteQuery(String query) in c:\inetpub\wwwroot\cricdirect.com\api\v6\App_Code\db\data_access.cs:line 117
ClientConnectionId:d451ff03-ec38-4e6e-be43-d36a7af8627f
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90590 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90590,3,'{"status":"ok","response":{"match_id":90590,"title":"Upminster-W vs Hutton-W","short_title":"UPW-W vs HUT-W","subtitle":"Match 4","match_number":"4","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Upminster-W won by 10 wickets (DLS method)","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129620,"title":"ECS-W Hornchurch","abbr":"ECS-W Hornchurch","type":"tournament","category":"women","match_format":"t10","season":"2025","status":"live","datestart":"2025-06-07","dateend":"2025-06-14","country":"int","total_matches":"9","total_rounds":"1","total_teams":"3"},"teama":{"team_id":128979,"name":"Upminster-W","short_name":"UPW-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Upminster-W.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Upminster-W.png","scores_full":"56\/0 (4 ov)","scores":"56\/0","overs":"4"},"teamb":{"team_id":128978,"name":"Hutton-W","short_name":"HUT-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Hutton-W.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Hutton-W.png","scores_full":"99\/6 (10 ov)","scores":"99\/6","overs":"10"},"date_start":"2025-06-07 14:45:00","date_end":"2025-06-08 00:45:00","timestamp_start":1749307500,"timestamp_end":1749343500,"date_start_ist":"2025-06-07 20:15:00","date_end_ist":"2025-06-08 06:15:00","venue":{"venue_id":"1213717","name":"Harrow Lodge Park","location":"Hornchurch","country":"England","timezone":""},"umpires":"Rehma Chandaria (England), Mel Juniper (England), Tracey Murphy (England, TV)","referee":" Tyrone Peters (South Africa)","equation":"","live":"","result":"UPW-W won by 10 wickets (DLS method)","result_type":1,"win_margin":"10 wickets (DLS method)","winning_team_id":128979,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-06 14:37:42","verify_time":"2025-06-07 22:08:11","match_dls_affected":"true","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Rain","weather_desc":"light rain","temp":14.56,"humidity":85,"visibility":3644,"wind_speed":"10.71","clouds":100},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Upminster-W elected to bowl","winner":128979,"decision":2}},"etag":"aa07f8fc7797cdc72f57aafb823e41e5","modified":"2025-07-04 15:52:06","datetime":"2025-07-04 15:52:06","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90590,"title":"Upminster-W vs Hutton-W","short_title":"UPW-W vs HUT-W","subtitle":"Match 4","match_number":"4","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Upminster-W won by 10 wickets (DLS method)","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129620,"title":"ECS-W Hornchurch","abbr":"ECS-W Hornchurch","type":"tournament","category":"women","match_format":"t10","season":"2025","status":"live","datestart":"2025-06-07","dateend":"2025-06-14","country":"int","total_matches":"9","total_rounds":"1","total_teams":"3"},"teama":{"team_id":128979,"name":"Upminster-W","short_name":"UPW-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Upminster-W.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Upminster-W.png","scores_full":"56\/0 (4 ov)","scores":"56\/0","overs":"4"},"teamb":{"team_id":128978,"name":"Hutton-W","short_name":"HUT-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Hutton-W.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Hutton-W.png","scores_full":"99\/6 (10 ov)","scores":"99\/6","overs":"10"},"date_start":"2025-06-07 14:45:00","date_end":"2025-06-08 00:45:00","timestamp_start":1749307500,"timestamp_end":1749343500,"date_start_ist":"2025-06-07 20:15:00","date_end_ist":"2025-06-08 06:15:00","venue":{"venue_id":"1213717","name":"Harrow Lodge Park","location":"Hornchurch","country":"England","timezone":""},"umpires":"Rehma Chandaria (England), Mel Juniper (England), Tracey Murphy (England, TV)","referee":" Tyrone Peters (South Africa)","equation":"","live":"","result":"UPW-W won by 10 wickets (DLS method)","result_type":1,"win_margin":"10 wickets (DLS method)","winning_team_id":128979,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-06 14:37:42","verify_time":"2025-06-07 22:08:11","match_dls_affected":"true","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Rain","weather_desc":"light rain","temp":14.56,"humidity":85,"visibility":3644,"wind_speed":"10.71","clouds":100},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Upminster-W elected to bowl","winner":128979,"decision":2}},"etag":"aa07f8fc7797cdc72f57aafb823e41e5","modified":"2025-07-04 15:52:06","datetime":"2025-07-04 15:52:06","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90590 AND DataTypeId = 3 END Live Report & Scorecard of Upminster-W vs Hutton-W Match 4