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:fbbbbd83-2388-4e72-95a1-5f4b83af76b1 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90176 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90176,1,'{"status":"ok","response":{"mid":90176,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Germany Women won by 8 wickets","day_remaining_over":"","team_batting":"Germany Women","team_bowling":"Isle of Man Women","live_inning_number":2,"live_score":{"runs":140,"overs":18,"wickets":2,"target":140,"runrate":7.78,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Shravya Kolcharam","batsman_id":117342,"runs":50,"balls_faced":31,"fours":7,"sixes":0,"strike_rate":"161.29"},{"name":"Tina Gough","batsman_id":97005,"runs":6,"balls_faced":7,"fours":0,"sixes":0,"strike_rate":"85.71"}],"bowlers":[{"name":"Alanya Thorpe","bowler_id":121374,"overs":4,"runs_conceded":33,"wickets":0,"maidens":0,"econ":"8.25"},{"name":"Joanne Hicks","bowler_id":121380,"overs":4,"runs_conceded":26,"wickets":0,"maidens":0,"econ":"6.50"}],"commentaries":[{"event_id":"12042587","event":"ball","batsman_id":"96991","bowler_id":"129640","over":"13","ball":"6","score":1,"commentary":"Caitlin Henery to Karthika Vijayaraghavan, 1 run,","noball_dismissal":false,"text":"","timestamp":1748532954,"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":14,"runs":12,"score":"112\/1","bats":[{"runs":39,"balls_faced":45,"fours":3,"sixes":0,"batsman_id":96991},{"runs":30,"balls_faced":17,"fours":4,"sixes":0,"batsman_id":117342}],"bowls":[{"runs_conceded":23,"maidens":0,"wickets":0,"bowler_id":129640,"overs":2},{"runs_conceded":18,"maidens":0,"wickets":0,"bowler_id":121381,"overs":2}],"commentary":"End of over 14 (12 runs), Germany Women 112\/1"},{"event_id":"12042592","event":"ball","batsman_id":"96991","bowler_id":"121372","over":"14","ball":"1","score":0,"commentary":"Lucy Barnett to Karthika Vijayaraghavan, no run,","noball_dismissal":false,"text":"","timestamp":1748533003,"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":"12042603","event":"ball","batsman_id":"96991","bowler_id":"121372","over":"14","ball":"2","score":1,"commentary":"Lucy Barnett to Karthika Vijayaraghavan, 1 run,","noball_dismissal":false,"text":"","timestamp":1748533059,"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":"12042604","event":"ball","batsman_id":"117342","bowler_id":"121372","over":"14","ball":"3","score":1,"commentary":"Lucy Barnett to Shravya Kolcharam, 1 run,","noball_dismissal":false,"text":"","timestamp":1748533064,"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":"12042616","event":"wicket","batsman_id":"96991","bowler_id":"121372","over":"14","ball":"4","score":"w","commentary":"Lucy Barnett to Karthika Vijayaraghavan, no run, c R Webster b L Barnett,","noball_dismissal":false,"text":"","timestamp":1748533168,"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,"wicket_batsman_id":"96991","how_out":"c R Webster b L Barnett","batsman_runs":"40","batsman_balls":"48"},{"event_id":"12042617","event":"ball","batsman_id":"97005","bowler_id":"121372","over":"14","ball":"5","score":0,"commentary":"Lucy Barnett to Tina Gough, no run,","noball_dismissal":false,"text":"","timestamp":1748533191,"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":"12042618","event":"ball","batsman_id":"97005","bowler_id":"121372","over":"14","ball":"6","score":1,"commentary":"Lucy Barnett to Tina Gough, 1 run,","noball_dismissal":false,"text":"","timestamp":1748533205,"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":15,"runs":3,"score":"115\/2","bats":[{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":97005},{"runs":31,"balls_faced":18,"fours":4,"sixes":0,"batsman_id":117342}],"bowls":[{"runs_conceded":12,"maidens":0,"wickets":1,"bowler_id":121372,"overs":3},{"runs_conceded":23,"maidens":0,"wickets":0,"bowler_id":129640,"overs":2}],"commentary":"End of over 15 (3 runs), Germany Women 115\/2"},{"event_id":"12042627","event":"ball","batsman_id":"97005","bowler_id":"121374","over":"15","ball":"1","score":1,"commentary":"Alanya Thorpe to Tina Gough, 1 run,","noball_dismissal":false,"text":"","timestamp":1748533367,"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":"12042630","event":"ball","batsman_id":"117342","bowler_id":"121374","over":"15","ball":"2","score":0,"commentary":"Alanya Thorpe to Shravya Kolcharam, no run,","noball_dismissal":false,"text":"","timestamp":1748533374,"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":"12042631","event":"ball","batsman_id":"117342","bowler_id":"121374","over":"15","ball":"3","score":2,"commentary":"Alanya Thorpe to Shravya Kolcharam, 2 runs,","noball_dismissal":false,"text":"","timestamp":1748533377,"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":"12042634","event":"ball","batsman_id":"117342","bowler_id":"121374","over":"15","ball":"4","score":0,"commentary":"Alanya Thorpe to Shravya Kolcharam, no run,","noball_dismissal":false,"text":"","timestamp":1748533399,"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":"12042635","event":"ball","batsman_id":"117342","bowler_id":"121374","over":"15","ball":"5","score":4,"commentary":"Alanya Thorpe to Shravya Kolcharam, Four,","noball_dismissal":false,"text":"","timestamp":1748533404,"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":"12042644","event":"ball","batsman_id":"117342","bowler_id":"121374","over":"15","ball":"6","score":0,"commentary":"Alanya Thorpe to Shravya Kolcharam, no run,","noball_dismissal":false,"text":"","timestamp":1748533457,"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":16,"runs":7,"score":"122\/2","bats":[{"runs":37,"balls_faced":23,"fours":5,"sixes":0,"batsman_id":117342},{"runs":2,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":97005}],"bowls":[{"runs_conceded":21,"maidens":0,"wickets":0,"bowler_id":121374,"overs":3},{"runs_conceded":12,"maidens":0,"wickets":1,"bowler_id":121372,"overs":3}],"commentary":"End of over 16 (7 runs), Germany Women 122\/2"},{"event_id":"12042666","event":"ball","batsman_id":"97005","bowler_id":"121380","over":"16","ball":"1","score":1,"commentary":"Joanne Hicks to Tina Gough, 1 run,","noball_dismissal":false,"text":"","timestamp":1748533738,"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":"12042668","event":"ball","batsman_id":"117342","bowler_id":"121380","over":"16","ball":"2","score":1,"commentary":"Joanne Hicks to Shravya Kolcharam, 1 run,","noball_dismissal":false,"text":"","timestamp":1748533743,"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":"12042670","event":"ball","batsman_id":"97005","bowler_id":"121380","over":"16","ball":"3","score":1,"commentary":"Joanne Hicks to Tina Gough, 1 run,","noball_dismissal":false,"text":"","timestamp":1748533747,"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":"12042672","event":"ball","batsman_id":"117342","bowler_id":"121380","over":"16","ball":"4","score":1,"commentary":"Joanne Hicks to Shravya Kolcharam, 1 run,","noball_dismissal":false,"text":"","timestamp":1748533750,"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":"12042673","event":"ball","batsman_id":"97005","bowler_id":"121380","over":"16","ball":"5","score":1,"commentary":"Joanne Hicks to Tina Gough, 1 run,","noball_dismissal":false,"text":"","timestamp":1748533754,"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":"12042674","event":"ball","batsman_id":"117342","bowler_id":"121380","over":"16","ball":"6","score":1,"commentary":"Joanne Hicks to Shravya Kolcharam, 1 run,","noball_dismissal":false,"text":"","timestamp":1748533758,"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":17,"runs":6,"score":"128\/2","bats":[{"runs":40,"balls_faced":26,"fours":5,"sixes":0,"batsman_id":117342},{"runs":5,"balls_faced":6,"fours":0,"sixes":0,"batsman_id":97005}],"bowls":[{"runs_conceded":26,"maidens":0,"wickets":0,"bowler_id":121380,"overs":4},{"runs_conceded":21,"maidens":0,"wickets":0,"bowler_id":121374,"overs":3}],"commentary":"End of over 17 (6 runs), Germany Women 128\/2"},{"event_id":"12042678","event":"ball","batsman_id":"117342","bowler_id":"121374","over":"17","ball":"1","score":"1wd","commentary":"Alanya Thorpe to Shravya Kolcharam, 1 wide,","noball_dismissal":false,"text":"","timestamp":1748533793,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12042681","event":"ball","batsman_id":"117342","bowler_id":"121374","over":"17","ball":"1","score":1,"commentary":"Alanya Thorpe to Shravya Kolcharam, 1 run,","noball_dismissal":false,"text":"","timestamp":1748533802,"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":"12042689","event":"ball","batsman_id":"97005","bowler_id":"121374","over":"17","ball":"2","score":1,"commentary":"Alanya Thorpe to Tina Gough, 1 run,","noball_dismissal":false,"text":"","timestamp":1748533872,"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":"12042692","event":"ball","batsman_id":"117342","bowler_id":"121374","over":"17","ball":"3","score":4,"commentary":"Alanya Thorpe to Shravya Kolcharam, Four,","noball_dismissal":false,"text":"","timestamp":1748533878,"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":"12042698","event":"ball","batsman_id":"117342","bowler_id":"121374","over":"17","ball":"4","score":0,"commentary":"Alanya Thorpe to Shravya Kolcharam, no run,","noball_dismissal":false,"text":"","timestamp":1748533893,"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":"12042700","event":"ball","batsman_id":"117342","bowler_id":"121374","over":"17","ball":"5","score":4,"commentary":"Alanya Thorpe to Shravya Kolcharam, Four,","noball_dismissal":false,"text":"","timestamp":1748533912,"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":"12042705","event":"ball","batsman_id":"117342","bowler_id":"121374","over":"17","ball":"6","score":1,"commentary":"Alanya Thorpe to Shravya Kolcharam, 1 run,","noball_dismissal":false,"text":"","timestamp":1748533975,"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":18,"runs":12,"score":"140\/2","bats":[{"runs":50,"balls_faced":31,"fours":7,"sixes":0,"batsman_id":117342},{"runs":6,"balls_faced":7,"fours":0,"sixes":0,"batsman_id":97005}],"bowls":[{"runs_conceded":33,"maidens":0,"wickets":0,"bowler_id":121374,"overs":4},{"runs_conceded":26,"maidens":0,"wickets":0,"bowler_id":121380,"overs":4}],"commentary":"End of over 18 (12 runs), Germany Women 140\/2"}],"day":"0","session":"0","live_inning":{"iid":197147,"number":2,"name":"Germany Women Inning","short_name":"GER-W Inning","status":2,"issuperover":"false","result":3,"batting_team_id":114382,"fielding_team_id":126803,"scores":"140\/2","scores_full":"140\/2 (18 ov)","fielder":[{"fielder_id":"129860","fielder_name":"Rebecca Webster","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"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":{"name":"Karthika Vijayaraghavan","batsman_id":"96991","runs":"40","balls":"48","how_out":"c R Webster b L Barnett","score_at_dismissal":114,"overs_at_dismissal":"14.4","bowler_id":"121372","dismissal":"caught","number":2},"extra_runs":{"byes":1,"legbyes":1,"wides":7,"noballs":1,"penalty":"0","total":10},"equations":{"runs":140,"wickets":2,"overs":"18","bowlers_used":6,"runrate":"7.78"},"current_partnership":{"runs":26,"balls":20,"overs":3.2,"batsmen":[{"name":"Tina Gough","batsman_id":97005,"runs":6,"balls":7},{"name":"Shravya Kolcharam","batsman_id":117342,"runs":19,"balls":13}]},"did_not_bat":[{"player_id":"100069","name":"Sharaanya Sadarangani"},{"player_id":"148662","name":"Nicole Kingsley"},{"player_id":"97001","name":"Janet Ronalds"},{"player_id":"127572","name":"Rameesha Shahid"},{"player_id":"117341","name":"Asmita Kohli"},{"player_id":"127573","name":"Ashwini Balaji"},{"player_id":"148664","name":"Iris Edwards"}],"max_over":"20","target":"140","recent_scores":"1,4,0,4,1,1,1,1,1,1,1,1,1,0,4,0,2,0","last_five_overs":"40\/1 7.50","last_ten_overs":"84\/1 7.75"},"teams":[{"tid":114382,"title":"Germany Women","abbr":"GER-W","alt_name":"Germany Women","type":"country","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Germany.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Germany.png","country":"de","sex":"female","team_owner":"","head_coach":"","scores_full":"140\/2 (18 ov)","scores":"140\/2","overs":"18"},{"tid":126803,"title":"Isle of Man Women","abbr":"IM-W","alt_name":"Isle of Man Women","type":"country","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Rectangle-3348-2023-07-10T121305.632.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Rectangle-3348-2023-07-10T121305.632.png","country":"es","sex":"female","team_owner":"","head_coach":"","scores_full":"139\/5 (20 ov)","scores":"139\/5","overs":"20"}],"players":[{"pid":96990,"title":"Verena Stolle","short_name":"V Stolle","first_name":"Verena Stolle","last_name":"","middle_name":"","birthdate":"1983-02-05","birthplace":"","country":"jp","primary_team":[],"logo_url":"","playing_role":"wk","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":"Japan","role":"squad","role_str":""},{"pid":96991,"title":"Karthika Vijayaraghavan","short_name":"K Vijayaraghavan","first_name":"Karthika Vijayaraghavan","last_name":"","middle_name":"","birthdate":"1988-04-18","birthplace":"","country":"jp","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right 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":"Japan","role":"wk","role_str":"(WK)"},{"pid":96998,"title":"Milena Beresford","short_name":"M Beresford","first_name":"Milena Beresford","last_name":"","middle_name":"","birthdate":"1996-04-13","birthplace":"","country":"jp","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","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":"Japan","role":"squad","role_str":""},{"pid":97000,"title":"Anne Bierwisch","short_name":"A Bierwisch","first_name":"Anne Bierwisch","last_name":"","middle_name":"","birthdate":"1987-12-26","birthplace":"","country":"jp","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Japan","role":"squad","role_str":""},{"pid":97001,"title":"Janet Ronalds","short_name":"J Ronalds","first_name":"Janet Ronalds","last_name":"","middle_name":"","birthdate":"1985-10-30","birthplace":"","country":"jp","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","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":"Japan","role":"all","role_str":""},{"pid":97005,"title":"Tina Gough","short_name":"T Gough","first_name":"Tina Gough","last_name":"","middle_name":"","birthdate":"1994-02-18","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium Fast","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":"Germany","role":"all","role_str":""},{"pid":97014,"title":"Antonia Meyenborg","short_name":"A Meyenborg","first_name":"Antonia Meyenborg","last_name":"","middle_name":"","birthdate":"2002-02-28","birthplace":"","country":"jp","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":"Japan","role":"squad","role_str":""},{"pid":100069,"title":"Sharaanya Sadarangani","short_name":"S Sadarangani","first_name":"Sharaanya Sadarangani","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","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":"International","role":"wk","role_str":""},{"pid":117339,"title":"Wilhelmina Garcia","short_name":"W H -Garcia","first_name":"Wilhelmina Garcia","last_name":"","middle_name":"","birthdate":"2005-01-14","birthplace":"","country":"jp","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Japan","role":"all","role_str":""},{"pid":117341,"title":"Asmita Kohli","short_name":"A Kohli","first_name":"Asmita Kohli","last_name":"","middle_name":"","birthdate":"2000-04-12","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","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":"Germany","role":"bowl","role_str":"(C)"},{"pid":117342,"title":"Shravya Kolcharam","short_name":"S Kolcharam","first_name":"Shravya Kolcharam","last_name":"","middle_name":"","birthdate":"1995-05-19","birthplace":"","country":"jp","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":"Japan","role":"bat","role_str":""},{"pid":121369,"title":"Clare Crowe","short_name":"C Crowe","first_name":"Clare Crowe","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"bat","role_str":""},{"pid":121370,"title":"Kim Carney","short_name":"K Carney","first_name":"Kim Carney","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"bat","role_str":""},{"pid":121371,"title":"Rachel Overman","short_name":"R Overman","first_name":"Rachel Overman","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"bat","role_str":""},{"pid":121372,"title":"Lucy Barnett","short_name":"L Barnett","first_name":"Lucy Barnett","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"all","role_str":""},{"pid":121374,"title":"Alanya Thorpe","short_name":"A Thorpe","first_name":"Alanya Thorpe","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"bowl","role_str":"(C)"},{"pid":121375,"title":"Ellan Cleator","short_name":"E Cleator","first_name":"Ellan Cleator","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"bat","role_str":""},{"pid":121379,"title":"Catherine Perry","short_name":"C Perry","first_name":"Catherine Perry","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","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":"International","role":"bowl","role_str":""},{"pid":121380,"title":"Joanne Hicks","short_name":"J Hicks","first_name":"Joanne Hicks","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","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":"International","role":"bowl","role_str":""},{"pid":121381,"title":"Danielle Murphy","short_name":"D Murphy","first_name":"Danielle Murphy","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","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":"International","role":"bowl","role_str":""},{"pid":127572,"title":"Rameesha Shahid","short_name":"R Shahid","first_name":"Rameesha Shahid","last_name":"","middle_name":"","birthdate":"1990-03-15","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"all","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":"Germany","role":"all","role_str":""},{"pid":127573,"title":"Ashwini Balaji","short_name":"A Balaji","first_name":"Ashwini Balaji","last_name":"","middle_name":"","birthdate":"2004-12-15","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"bowl","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":"Germany","role":"bowl","role_str":""},{"pid":129640,"title":"Caitlin Henery","short_name":"C Henery","first_name":"Caitlin Henery","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"all","role_str":""},{"pid":129860,"title":"Rebecca Webster","short_name":"R Webster","first_name":"Rebecca Webster","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right 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":"International","role":"wk","role_str":"(WK)"},{"pid":141793,"title":"Sam Hassall","short_name":"S Hassall","first_name":"Sam Hassall","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":145392,"title":"Ameya Kanukuntla","short_name":"A Kanukuntla","first_name":"Ameya Kanukuntla","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","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":"Germany","role":"squad","role_str":""},{"pid":148662,"title":"Nicole Kingsley","short_name":"N Kingsley","first_name":"Nicole Kingsley","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","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":"Germany","role":"bat","role_str":""},{"pid":148664,"title":"Iris Edwards","short_name":"I Edwards","first_name":"Iris Edwards","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","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":"Germany","role":"bowl","role_str":""},{"pid":148988,"title":"Aishani Kishore","short_name":"A Kishore","first_name":"Aishani Kishore","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","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":"Germany","role":"squad","role_str":""},{"pid":149029,"title":"Lola Hornby-Wheeler","short_name":"L Hornby-Wheeler","first_name":"Lola Hornby-Wheeler","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","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":"International","role":"squad","role_str":""},{"pid":149030,"title":"Georgina Ford","short_name":"G Ford","first_name":"Georgina Ford","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","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":"International","role":"squad","role_str":""}]},"etag":"7ba57cfb73b6402afe973d40ba3ea50c","modified":"2025-06-27 07:14:48","datetime":"2025-06-27 07:14:48","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":90176,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Germany Women won by 8 wickets","day_remaining_over":"","team_batting":"Germany Women","team_bowling":"Isle of Man Women","live_inning_number":2,"live_score":{"runs":140,"overs":18,"wickets":2,"target":140,"runrate":7.78,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Shravya Kolcharam","batsman_id":117342,"runs":50,"balls_faced":31,"fours":7,"sixes":0,"strike_rate":"161.29"},{"name":"Tina Gough","batsman_id":97005,"runs":6,"balls_faced":7,"fours":0,"sixes":0,"strike_rate":"85.71"}],"bowlers":[{"name":"Alanya Thorpe","bowler_id":121374,"overs":4,"runs_conceded":33,"wickets":0,"maidens":0,"econ":"8.25"},{"name":"Joanne Hicks","bowler_id":121380,"overs":4,"runs_conceded":26,"wickets":0,"maidens":0,"econ":"6.50"}],"commentaries":[{"event_id":"12042587","event":"ball","batsman_id":"96991","bowler_id":"129640","over":"13","ball":"6","score":1,"commentary":"Caitlin Henery to Karthika Vijayaraghavan, 1 run,","noball_dismissal":false,"text":"","timestamp":1748532954,"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":14,"runs":12,"score":"112\/1","bats":[{"runs":39,"balls_faced":45,"fours":3,"sixes":0,"batsman_id":96991},{"runs":30,"balls_faced":17,"fours":4,"sixes":0,"batsman_id":117342}],"bowls":[{"runs_conceded":23,"maidens":0,"wickets":0,"bowler_id":129640,"overs":2},{"runs_conceded":18,"maidens":0,"wickets":0,"bowler_id":121381,"overs":2}],"commentary":"End of over 14 (12 runs), Germany Women 112\/1"},{"event_id":"12042592","event":"ball","batsman_id":"96991","bowler_id":"121372","over":"14","ball":"1","score":0,"commentary":"Lucy Barnett to Karthika Vijayaraghavan, no run,","noball_dismissal":false,"text":"","timestamp":1748533003,"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":"12042603","event":"ball","batsman_id":"96991","bowler_id":"121372","over":"14","ball":"2","score":1,"commentary":"Lucy Barnett to Karthika Vijayaraghavan, 1 run,","noball_dismissal":false,"text":"","timestamp":1748533059,"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":"12042604","event":"ball","batsman_id":"117342","bowler_id":"121372","over":"14","ball":"3","score":1,"commentary":"Lucy Barnett to Shravya Kolcharam, 1 run,","noball_dismissal":false,"text":"","timestamp":1748533064,"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":"12042616","event":"wicket","batsman_id":"96991","bowler_id":"121372","over":"14","ball":"4","score":"w","commentary":"Lucy Barnett to Karthika Vijayaraghavan, no run, c R Webster b L Barnett,","noball_dismissal":false,"text":"","timestamp":1748533168,"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,"wicket_batsman_id":"96991","how_out":"c R Webster b L Barnett","batsman_runs":"40","batsman_balls":"48"},{"event_id":"12042617","event":"ball","batsman_id":"97005","bowler_id":"121372","over":"14","ball":"5","score":0,"commentary":"Lucy Barnett to Tina Gough, no run,","noball_dismissal":false,"text":"","timestamp":1748533191,"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":"12042618","event":"ball","batsman_id":"97005","bowler_id":"121372","over":"14","ball":"6","score":1,"commentary":"Lucy Barnett to Tina Gough, 1 run,","noball_dismissal":false,"text":"","timestamp":1748533205,"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":15,"runs":3,"score":"115\/2","bats":[{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":97005},{"runs":31,"balls_faced":18,"fours":4,"sixes":0,"batsman_id":117342}],"bowls":[{"runs_conceded":12,"maidens":0,"wickets":1,"bowler_id":121372,"overs":3},{"runs_conceded":23,"maidens":0,"wickets":0,"bowler_id":129640,"overs":2}],"commentary":"End of over 15 (3 runs), Germany Women 115\/2"},{"event_id":"12042627","event":"ball","batsman_id":"97005","bowler_id":"121374","over":"15","ball":"1","score":1,"commentary":"Alanya Thorpe to Tina Gough, 1 run,","noball_dismissal":false,"text":"","timestamp":1748533367,"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":"12042630","event":"ball","batsman_id":"117342","bowler_id":"121374","over":"15","ball":"2","score":0,"commentary":"Alanya Thorpe to Shravya Kolcharam, no run,","noball_dismissal":false,"text":"","timestamp":1748533374,"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":"12042631","event":"ball","batsman_id":"117342","bowler_id":"121374","over":"15","ball":"3","score":2,"commentary":"Alanya Thorpe to Shravya Kolcharam, 2 runs,","noball_dismissal":false,"text":"","timestamp":1748533377,"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":"12042634","event":"ball","batsman_id":"117342","bowler_id":"121374","over":"15","ball":"4","score":0,"commentary":"Alanya Thorpe to Shravya Kolcharam, no run,","noball_dismissal":false,"text":"","timestamp":1748533399,"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":"12042635","event":"ball","batsman_id":"117342","bowler_id":"121374","over":"15","ball":"5","score":4,"commentary":"Alanya Thorpe to Shravya Kolcharam, Four,","noball_dismissal":false,"text":"","timestamp":1748533404,"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":"12042644","event":"ball","batsman_id":"117342","bowler_id":"121374","over":"15","ball":"6","score":0,"commentary":"Alanya Thorpe to Shravya Kolcharam, no run,","noball_dismissal":false,"text":"","timestamp":1748533457,"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":16,"runs":7,"score":"122\/2","bats":[{"runs":37,"balls_faced":23,"fours":5,"sixes":0,"batsman_id":117342},{"runs":2,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":97005}],"bowls":[{"runs_conceded":21,"maidens":0,"wickets":0,"bowler_id":121374,"overs":3},{"runs_conceded":12,"maidens":0,"wickets":1,"bowler_id":121372,"overs":3}],"commentary":"End of over 16 (7 runs), Germany Women 122\/2"},{"event_id":"12042666","event":"ball","batsman_id":"97005","bowler_id":"121380","over":"16","ball":"1","score":1,"commentary":"Joanne Hicks to Tina Gough, 1 run,","noball_dismissal":false,"text":"","timestamp":1748533738,"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":"12042668","event":"ball","batsman_id":"117342","bowler_id":"121380","over":"16","ball":"2","score":1,"commentary":"Joanne Hicks to Shravya Kolcharam, 1 run,","noball_dismissal":false,"text":"","timestamp":1748533743,"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":"12042670","event":"ball","batsman_id":"97005","bowler_id":"121380","over":"16","ball":"3","score":1,"commentary":"Joanne Hicks to Tina Gough, 1 run,","noball_dismissal":false,"text":"","timestamp":1748533747,"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":"12042672","event":"ball","batsman_id":"117342","bowler_id":"121380","over":"16","ball":"4","score":1,"commentary":"Joanne Hicks to Shravya Kolcharam, 1 run,","noball_dismissal":false,"text":"","timestamp":1748533750,"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":"12042673","event":"ball","batsman_id":"97005","bowler_id":"121380","over":"16","ball":"5","score":1,"commentary":"Joanne Hicks to Tina Gough, 1 run,","noball_dismissal":false,"text":"","timestamp":1748533754,"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":"12042674","event":"ball","batsman_id":"117342","bowler_id":"121380","over":"16","ball":"6","score":1,"commentary":"Joanne Hicks to Shravya Kolcharam, 1 run,","noball_dismissal":false,"text":"","timestamp":1748533758,"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":17,"runs":6,"score":"128\/2","bats":[{"runs":40,"balls_faced":26,"fours":5,"sixes":0,"batsman_id":117342},{"runs":5,"balls_faced":6,"fours":0,"sixes":0,"batsman_id":97005}],"bowls":[{"runs_conceded":26,"maidens":0,"wickets":0,"bowler_id":121380,"overs":4},{"runs_conceded":21,"maidens":0,"wickets":0,"bowler_id":121374,"overs":3}],"commentary":"End of over 17 (6 runs), Germany Women 128\/2"},{"event_id":"12042678","event":"ball","batsman_id":"117342","bowler_id":"121374","over":"17","ball":"1","score":"1wd","commentary":"Alanya Thorpe to Shravya Kolcharam, 1 wide,","noball_dismissal":false,"text":"","timestamp":1748533793,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12042681","event":"ball","batsman_id":"117342","bowler_id":"121374","over":"17","ball":"1","score":1,"commentary":"Alanya Thorpe to Shravya Kolcharam, 1 run,","noball_dismissal":false,"text":"","timestamp":1748533802,"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":"12042689","event":"ball","batsman_id":"97005","bowler_id":"121374","over":"17","ball":"2","score":1,"commentary":"Alanya Thorpe to Tina Gough, 1 run,","noball_dismissal":false,"text":"","timestamp":1748533872,"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":"12042692","event":"ball","batsman_id":"117342","bowler_id":"121374","over":"17","ball":"3","score":4,"commentary":"Alanya Thorpe to Shravya Kolcharam, Four,","noball_dismissal":false,"text":"","timestamp":1748533878,"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":"12042698","event":"ball","batsman_id":"117342","bowler_id":"121374","over":"17","ball":"4","score":0,"commentary":"Alanya Thorpe to Shravya Kolcharam, no run,","noball_dismissal":false,"text":"","timestamp":1748533893,"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":"12042700","event":"ball","batsman_id":"117342","bowler_id":"121374","over":"17","ball":"5","score":4,"commentary":"Alanya Thorpe to Shravya Kolcharam, Four,","noball_dismissal":false,"text":"","timestamp":1748533912,"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":"12042705","event":"ball","batsman_id":"117342","bowler_id":"121374","over":"17","ball":"6","score":1,"commentary":"Alanya Thorpe to Shravya Kolcharam, 1 run,","noball_dismissal":false,"text":"","timestamp":1748533975,"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":18,"runs":12,"score":"140\/2","bats":[{"runs":50,"balls_faced":31,"fours":7,"sixes":0,"batsman_id":117342},{"runs":6,"balls_faced":7,"fours":0,"sixes":0,"batsman_id":97005}],"bowls":[{"runs_conceded":33,"maidens":0,"wickets":0,"bowler_id":121374,"overs":4},{"runs_conceded":26,"maidens":0,"wickets":0,"bowler_id":121380,"overs":4}],"commentary":"End of over 18 (12 runs), Germany Women 140\/2"}],"day":"0","session":"0","live_inning":{"iid":197147,"number":2,"name":"Germany Women Inning","short_name":"GER-W Inning","status":2,"issuperover":"false","result":3,"batting_team_id":114382,"fielding_team_id":126803,"scores":"140\/2","scores_full":"140\/2 (18 ov)","fielder":[{"fielder_id":"129860","fielder_name":"Rebecca Webster","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"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":{"name":"Karthika Vijayaraghavan","batsman_id":"96991","runs":"40","balls":"48","how_out":"c R Webster b L Barnett","score_at_dismissal":114,"overs_at_dismissal":"14.4","bowler_id":"121372","dismissal":"caught","number":2},"extra_runs":{"byes":1,"legbyes":1,"wides":7,"noballs":1,"penalty":"0","total":10},"equations":{"runs":140,"wickets":2,"overs":"18","bowlers_used":6,"runrate":"7.78"},"current_partnership":{"runs":26,"balls":20,"overs":3.2,"batsmen":[{"name":"Tina Gough","batsman_id":97005,"runs":6,"balls":7},{"name":"Shravya Kolcharam","batsman_id":117342,"runs":19,"balls":13}]},"did_not_bat":[{"player_id":"100069","name":"Sharaanya Sadarangani"},{"player_id":"148662","name":"Nicole Kingsley"},{"player_id":"97001","name":"Janet Ronalds"},{"player_id":"127572","name":"Rameesha Shahid"},{"player_id":"117341","name":"Asmita Kohli"},{"player_id":"127573","name":"Ashwini Balaji"},{"player_id":"148664","name":"Iris Edwards"}],"max_over":"20","target":"140","recent_scores":"1,4,0,4,1,1,1,1,1,1,1,1,1,0,4,0,2,0","last_five_overs":"40\/1 7.50","last_ten_overs":"84\/1 7.75"},"teams":[{"tid":114382,"title":"Germany Women","abbr":"GER-W","alt_name":"Germany Women","type":"country","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Germany.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Germany.png","country":"de","sex":"female","team_owner":"","head_coach":"","scores_full":"140\/2 (18 ov)","scores":"140\/2","overs":"18"},{"tid":126803,"title":"Isle of Man Women","abbr":"IM-W","alt_name":"Isle of Man Women","type":"country","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Rectangle-3348-2023-07-10T121305.632.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Rectangle-3348-2023-07-10T121305.632.png","country":"es","sex":"female","team_owner":"","head_coach":"","scores_full":"139\/5 (20 ov)","scores":"139\/5","overs":"20"}],"players":[{"pid":96990,"title":"Verena Stolle","short_name":"V Stolle","first_name":"Verena Stolle","last_name":"","middle_name":"","birthdate":"1983-02-05","birthplace":"","country":"jp","primary_team":[],"logo_url":"","playing_role":"wk","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":"Japan","role":"squad","role_str":""},{"pid":96991,"title":"Karthika Vijayaraghavan","short_name":"K Vijayaraghavan","first_name":"Karthika Vijayaraghavan","last_name":"","middle_name":"","birthdate":"1988-04-18","birthplace":"","country":"jp","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right 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":"Japan","role":"wk","role_str":"(WK)"},{"pid":96998,"title":"Milena Beresford","short_name":"M Beresford","first_name":"Milena Beresford","last_name":"","middle_name":"","birthdate":"1996-04-13","birthplace":"","country":"jp","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","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":"Japan","role":"squad","role_str":""},{"pid":97000,"title":"Anne Bierwisch","short_name":"A Bierwisch","first_name":"Anne Bierwisch","last_name":"","middle_name":"","birthdate":"1987-12-26","birthplace":"","country":"jp","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Japan","role":"squad","role_str":""},{"pid":97001,"title":"Janet Ronalds","short_name":"J Ronalds","first_name":"Janet Ronalds","last_name":"","middle_name":"","birthdate":"1985-10-30","birthplace":"","country":"jp","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","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":"Japan","role":"all","role_str":""},{"pid":97005,"title":"Tina Gough","short_name":"T Gough","first_name":"Tina Gough","last_name":"","middle_name":"","birthdate":"1994-02-18","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium Fast","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":"Germany","role":"all","role_str":""},{"pid":97014,"title":"Antonia Meyenborg","short_name":"A Meyenborg","first_name":"Antonia Meyenborg","last_name":"","middle_name":"","birthdate":"2002-02-28","birthplace":"","country":"jp","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":"Japan","role":"squad","role_str":""},{"pid":100069,"title":"Sharaanya Sadarangani","short_name":"S Sadarangani","first_name":"Sharaanya Sadarangani","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","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":"International","role":"wk","role_str":""},{"pid":117339,"title":"Wilhelmina Garcia","short_name":"W H -Garcia","first_name":"Wilhelmina Garcia","last_name":"","middle_name":"","birthdate":"2005-01-14","birthplace":"","country":"jp","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Japan","role":"all","role_str":""},{"pid":117341,"title":"Asmita Kohli","short_name":"A Kohli","first_name":"Asmita Kohli","last_name":"","middle_name":"","birthdate":"2000-04-12","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","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":"Germany","role":"bowl","role_str":"(C)"},{"pid":117342,"title":"Shravya Kolcharam","short_name":"S Kolcharam","first_name":"Shravya Kolcharam","last_name":"","middle_name":"","birthdate":"1995-05-19","birthplace":"","country":"jp","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":"Japan","role":"bat","role_str":""},{"pid":121369,"title":"Clare Crowe","short_name":"C Crowe","first_name":"Clare Crowe","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"bat","role_str":""},{"pid":121370,"title":"Kim Carney","short_name":"K Carney","first_name":"Kim Carney","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"bat","role_str":""},{"pid":121371,"title":"Rachel Overman","short_name":"R Overman","first_name":"Rachel Overman","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"bat","role_str":""},{"pid":121372,"title":"Lucy Barnett","short_name":"L Barnett","first_name":"Lucy Barnett","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"all","role_str":""},{"pid":121374,"title":"Alanya Thorpe","short_name":"A Thorpe","first_name":"Alanya Thorpe","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"bowl","role_str":"(C)"},{"pid":121375,"title":"Ellan Cleator","short_name":"E Cleator","first_name":"Ellan Cleator","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"bat","role_str":""},{"pid":121379,"title":"Catherine Perry","short_name":"C Perry","first_name":"Catherine Perry","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","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":"International","role":"bowl","role_str":""},{"pid":121380,"title":"Joanne Hicks","short_name":"J Hicks","first_name":"Joanne Hicks","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","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":"International","role":"bowl","role_str":""},{"pid":121381,"title":"Danielle Murphy","short_name":"D Murphy","first_name":"Danielle Murphy","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","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":"International","role":"bowl","role_str":""},{"pid":127572,"title":"Rameesha Shahid","short_name":"R Shahid","first_name":"Rameesha Shahid","last_name":"","middle_name":"","birthdate":"1990-03-15","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"all","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":"Germany","role":"all","role_str":""},{"pid":127573,"title":"Ashwini Balaji","short_name":"A Balaji","first_name":"Ashwini Balaji","last_name":"","middle_name":"","birthdate":"2004-12-15","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"bowl","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":"Germany","role":"bowl","role_str":""},{"pid":129640,"title":"Caitlin Henery","short_name":"C Henery","first_name":"Caitlin Henery","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"all","role_str":""},{"pid":129860,"title":"Rebecca Webster","short_name":"R Webster","first_name":"Rebecca Webster","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right 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":"International","role":"wk","role_str":"(WK)"},{"pid":141793,"title":"Sam Hassall","short_name":"S Hassall","first_name":"Sam Hassall","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":145392,"title":"Ameya Kanukuntla","short_name":"A Kanukuntla","first_name":"Ameya Kanukuntla","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","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":"Germany","role":"squad","role_str":""},{"pid":148662,"title":"Nicole Kingsley","short_name":"N Kingsley","first_name":"Nicole Kingsley","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","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":"Germany","role":"bat","role_str":""},{"pid":148664,"title":"Iris Edwards","short_name":"I Edwards","first_name":"Iris Edwards","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","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":"Germany","role":"bowl","role_str":""},{"pid":148988,"title":"Aishani Kishore","short_name":"A Kishore","first_name":"Aishani Kishore","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","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":"Germany","role":"squad","role_str":""},{"pid":149029,"title":"Lola Hornby-Wheeler","short_name":"L Hornby-Wheeler","first_name":"Lola Hornby-Wheeler","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","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":"International","role":"squad","role_str":""},{"pid":149030,"title":"Georgina Ford","short_name":"G Ford","first_name":"Georgina Ford","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","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":"International","role":"squad","role_str":""}]},"etag":"7ba57cfb73b6402afe973d40ba3ea50c","modified":"2025-06-27 07:14:48","datetime":"2025-06-27 07:14:48","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90176 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:fbbbbd83-2388-4e72-95a1-5f4b83af76b1 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90176 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90176,3,'{"status":"ok","response":{"match_id":90176,"title":"Isle of Man Women vs Germany Women","short_title":"IM-W vs GER-W","subtitle":"Match 15","match_number":"15","format":8,"format_str":"Women T20","status":2,"status_str":"Completed","status_note":"Germany Women won by 8 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129599,"title":"ICC Womens T20 World Cup Europe Qualifier Division 2","abbr":"ICC Womens T20 World Cup Europe Qualifier ","type":"tournament","category":"women","match_format":"woment20","season":"2025","status":"live","datestart":"2025-05-25","dateend":"2025-05-29","country":"int","total_matches":"15","total_rounds":"1","total_teams":"6"},"teama":{"team_id":126803,"name":"Isle of Man Women","short_name":"IM-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Rectangle-3348-2023-07-10T121305.632.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Rectangle-3348-2023-07-10T121305.632.png","scores_full":"139\/5 (20 ov)","scores":"139\/5","overs":"20"},"teamb":{"team_id":114382,"name":"Germany Women","short_name":"GER-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Germany.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Germany.png","scores_full":"140\/2 (18 ov)","scores":"140\/2","overs":"18"},"date_start":"2025-05-29 13:00:00","date_end":"2025-05-29 23:00:00","timestamp_start":1748523600,"timestamp_end":1748559600,"date_start_ist":"2025-05-29 18:30:00","date_end_ist":"2025-05-30 04:30:00","venue":{"venue_id":"473","name":"Roma Cricket Ground","location":"ROME","country":"ITALY","timezone":""},"umpires":" Mark Jameson (Scotland), Iain McDonald (Scotland)","referee":" David McLean (Scotland)","equation":"","live":"","result":"GER-W won by 8 wickets","result_type":2,"win_margin":"8 wickets","winning_team_id":114382,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-05-26 19:18:44","verify_time":"2025-05-29 21:37:40","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"broken clouds","temp":26.41,"humidity":43,"visibility":10000,"wind_speed":"5.79","clouds":66},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Low Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Germany Women elected to bowl","winner":114382,"decision":2}},"etag":"bb1f7a68466fd4218b14f1e99fb5acf7","modified":"2025-06-27 07:14:49","datetime":"2025-06-27 07:14:49","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90176,"title":"Isle of Man Women vs Germany Women","short_title":"IM-W vs GER-W","subtitle":"Match 15","match_number":"15","format":8,"format_str":"Women T20","status":2,"status_str":"Completed","status_note":"Germany Women won by 8 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129599,"title":"ICC Womens T20 World Cup Europe Qualifier Division 2","abbr":"ICC Womens T20 World Cup Europe Qualifier ","type":"tournament","category":"women","match_format":"woment20","season":"2025","status":"live","datestart":"2025-05-25","dateend":"2025-05-29","country":"int","total_matches":"15","total_rounds":"1","total_teams":"6"},"teama":{"team_id":126803,"name":"Isle of Man Women","short_name":"IM-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Rectangle-3348-2023-07-10T121305.632.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Rectangle-3348-2023-07-10T121305.632.png","scores_full":"139\/5 (20 ov)","scores":"139\/5","overs":"20"},"teamb":{"team_id":114382,"name":"Germany Women","short_name":"GER-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Germany.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Germany.png","scores_full":"140\/2 (18 ov)","scores":"140\/2","overs":"18"},"date_start":"2025-05-29 13:00:00","date_end":"2025-05-29 23:00:00","timestamp_start":1748523600,"timestamp_end":1748559600,"date_start_ist":"2025-05-29 18:30:00","date_end_ist":"2025-05-30 04:30:00","venue":{"venue_id":"473","name":"Roma Cricket Ground","location":"ROME","country":"ITALY","timezone":""},"umpires":" Mark Jameson (Scotland), Iain McDonald (Scotland)","referee":" David McLean (Scotland)","equation":"","live":"","result":"GER-W won by 8 wickets","result_type":2,"win_margin":"8 wickets","winning_team_id":114382,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-05-26 19:18:44","verify_time":"2025-05-29 21:37:40","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"broken clouds","temp":26.41,"humidity":43,"visibility":10000,"wind_speed":"5.79","clouds":66},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Low Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Germany Women elected to bowl","winner":114382,"decision":2}},"etag":"bb1f7a68466fd4218b14f1e99fb5acf7","modified":"2025-06-27 07:14:49","datetime":"2025-06-27 07:14:49","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90176 AND DataTypeId = 3 END
Live Report & Scorecard of Isle of Man Women vs Germany Women Match 15