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:2b8ee29f-1505-4065-9a99-9948745df1af Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90517 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90517,1,'{"status":"ok","response":{"mid":90517,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Zalwad Strikers won by 8 runs","day_remaining_over":"","team_batting":"Dita Gohilwad Titans","team_bowling":"Zalwad Strikers","live_inning_number":2,"live_score":{"runs":199,"overs":20,"wickets":6,"target":208,"runrate":9.95,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Kwinsh Padaliya","batsman_id":149625,"runs":1,"balls_faced":2,"fours":0,"sixes":0,"strike_rate":"50.00"},{"name":"Luckyraj Vaghela","batsman_id":130495,"runs":55,"balls_faced":26,"fours":3,"sixes":4,"strike_rate":"211.54"}],"bowlers":[{"name":"Yuvrajsinh Dodiya","bowler_id":122333,"overs":4,"runs_conceded":46,"wickets":2,"maidens":0,"econ":"11.50"},{"name":"Chirag Jani","bowler_id":53998,"overs":4,"runs_conceded":39,"wickets":2,"maidens":0,"econ":"9.8"}],"commentaries":[{"event_id":"12148556","event":"ball","batsman_id":"130495","bowler_id":"122333","over":"15","ball":"6","score":1,"commentary":"Yuvrajsinh Dodiya to Luckyraj Vaghela, 1 run,","noball_dismissal":false,"text":"","timestamp":1749991434,"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":16,"runs":10,"score":"146\/5","bats":[{"runs":27,"balls_faced":13,"fours":2,"sixes":2,"batsman_id":130495},{"runs":22,"balls_faced":16,"fours":3,"sixes":0,"batsman_id":53997}],"bowls":[{"runs_conceded":27,"maidens":0,"wickets":1,"bowler_id":122333,"overs":3},{"runs_conceded":31,"maidens":0,"wickets":0,"bowler_id":116788,"overs":3}],"commentary":"End of over 16 (10 runs), Dita Gohilwad Titans 146\/5"},{"event_id":"12148563","event":"ball","batsman_id":"130495","bowler_id":"53998","over":"16","ball":"1","score":4,"commentary":"Chirag Jani to Luckyraj Vaghela, Four,","noball_dismissal":false,"text":"","timestamp":1749991476,"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":"12148567","event":"ball","batsman_id":"130495","bowler_id":"53998","over":"16","ball":"2","score":6,"commentary":"Chirag Jani to Luckyraj Vaghela, Six,","noball_dismissal":false,"text":"","timestamp":1749991528,"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":"12148579","event":"ball","batsman_id":"130495","bowler_id":"53998","over":"16","ball":"3","score":1,"commentary":"Chirag Jani to Luckyraj Vaghela, 1 run,","noball_dismissal":false,"text":"","timestamp":1749991611,"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":"12148580","event":"ball","batsman_id":"53997","bowler_id":"53998","over":"16","ball":"4","score":1,"commentary":"Chirag Jani to Divyaraj Chauhan, 1 run,","noball_dismissal":false,"text":"","timestamp":1749991614,"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":"12148584","event":"ball","batsman_id":"130495","bowler_id":"53998","over":"16","ball":"5","score":2,"commentary":"Chirag Jani to Luckyraj Vaghela, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749991666,"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":"12148593","event":"ball","batsman_id":"130495","bowler_id":"53998","over":"16","ball":"6","score":2,"commentary":"Chirag Jani to Luckyraj Vaghela, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749991775,"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":"overend","over":17,"runs":16,"score":"162\/5","bats":[{"runs":42,"balls_faced":18,"fours":3,"sixes":3,"batsman_id":130495},{"runs":23,"balls_faced":17,"fours":3,"sixes":0,"batsman_id":53997}],"bowls":[{"runs_conceded":28,"maidens":0,"wickets":2,"bowler_id":53998,"overs":3},{"runs_conceded":27,"maidens":0,"wickets":1,"bowler_id":122333,"overs":3}],"commentary":"End of over 17 (16 runs), Dita Gohilwad Titans 162\/5"},{"event_id":"12148598","event":"ball","batsman_id":"53997","bowler_id":"116788","over":"17","ball":"1","score":"1nb","commentary":"Ankur Panwar to Divyaraj Chauhan, 1 no ball,","noball_dismissal":false,"text":"","timestamp":1749991844,"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":"12148607","event":"ball","batsman_id":"53997","bowler_id":"116788","over":"17","ball":"1","score":0,"commentary":"Ankur Panwar to Divyaraj Chauhan, no run,","noball_dismissal":false,"text":"","timestamp":1749993441,"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":"12148609","event":"ball","batsman_id":"130495","bowler_id":"116788","over":"17","ball":"2","score":1,"commentary":"Ankur Panwar to Luckyraj Vaghela, 1 run,","noball_dismissal":false,"text":"","timestamp":1749991927,"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":"12148610","event":"ball","batsman_id":"53997","bowler_id":"116788","over":"17","ball":"3","score":1,"commentary":"Ankur Panwar to Divyaraj Chauhan, 1 run,","noball_dismissal":false,"text":"","timestamp":1749991947,"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":"12148615","event":"ball","batsman_id":"130495","bowler_id":"116788","over":"17","ball":"4","score":1,"commentary":"Ankur Panwar to Luckyraj Vaghela, 1 run,","noball_dismissal":false,"text":"","timestamp":1749991978,"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":"12148620","event":"ball","batsman_id":"53997","bowler_id":"116788","over":"17","ball":"5","score":1,"commentary":"Ankur Panwar to Divyaraj Chauhan, 1 run,","noball_dismissal":false,"text":"","timestamp":1749992012,"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":"12148625","event":"ball","batsman_id":"130495","bowler_id":"116788","over":"17","ball":"6","score":1,"commentary":"Ankur Panwar to Luckyraj Vaghela, 1 run,","noball_dismissal":false,"text":"","timestamp":1749992109,"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":6,"score":"168\/5","bats":[{"runs":45,"balls_faced":21,"fours":3,"sixes":3,"batsman_id":130495},{"runs":25,"balls_faced":21,"fours":3,"sixes":0,"batsman_id":53997}],"bowls":[{"runs_conceded":37,"maidens":0,"wickets":0,"bowler_id":116788,"overs":4},{"runs_conceded":28,"maidens":0,"wickets":2,"bowler_id":53998,"overs":3}],"commentary":"End of over 18 (6 runs), Dita Gohilwad Titans 168\/5"},{"event_id":"12148633","event":"ball","batsman_id":"130495","bowler_id":"53998","over":"18","ball":"1","score":2,"commentary":"Chirag Jani to Luckyraj Vaghela, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749992169,"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":"12148634","event":"ball","batsman_id":"130495","bowler_id":"53998","over":"18","ball":"2","score":0,"commentary":"Chirag Jani to Luckyraj Vaghela, no run,","noball_dismissal":false,"text":"","timestamp":1749992183,"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":"12148636","event":"ball","batsman_id":"130495","bowler_id":"53998","over":"18","ball":"3","score":6,"commentary":"Chirag Jani to Luckyraj Vaghela, Six,","noball_dismissal":false,"text":"","timestamp":1749992291,"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":"12148641","event":"ball","batsman_id":"130495","bowler_id":"53998","over":"18","ball":"4","score":2,"commentary":"Chirag Jani to Luckyraj Vaghela, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749992295,"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":"12148644","event":"ball","batsman_id":"130495","bowler_id":"53998","over":"18","ball":"5","score":1,"commentary":"Chirag Jani to Luckyraj Vaghela, 1 run,","noball_dismissal":false,"text":"","timestamp":1749992327,"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":"12148651","event":"ball","batsman_id":"53997","bowler_id":"53998","over":"18","ball":"6","score":1,"commentary":"Chirag Jani to Divyaraj Chauhan, 1 run,","noball_dismissal":false,"text":"","timestamp":1749992379,"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":19,"runs":12,"score":"180\/5","bats":[{"runs":26,"balls_faced":22,"fours":3,"sixes":0,"batsman_id":53997},{"runs":56,"balls_faced":26,"fours":3,"sixes":4,"batsman_id":130495}],"bowls":[{"runs_conceded":40,"maidens":0,"wickets":2,"bowler_id":53998,"overs":4},{"runs_conceded":37,"maidens":0,"wickets":0,"bowler_id":116788,"overs":4}],"commentary":"End of over 19 (12 runs), Dita Gohilwad Titans 180\/5"},{"event_id":"12148668","event":"ball","batsman_id":"53997","bowler_id":"122333","over":"19","ball":"1","score":6,"commentary":"Yuvrajsinh Dodiya to Divyaraj Chauhan, Six,","noball_dismissal":false,"text":"","timestamp":1749992938,"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":"12148669","event":"ball","batsman_id":"53997","bowler_id":"122333","over":"19","ball":"2","score":6,"commentary":"Yuvrajsinh Dodiya to Divyaraj Chauhan, Six,","noball_dismissal":false,"text":"","timestamp":1749992940,"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":"12148670","event":"ball","batsman_id":"53997","bowler_id":"122333","over":"19","ball":"3","score":6,"commentary":"Yuvrajsinh Dodiya to Divyaraj Chauhan, Six,","noball_dismissal":false,"text":"","timestamp":1749992944,"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":"12148691","event":"wicket","batsman_id":"53997","bowler_id":"122333","over":"19","ball":"4","score":"w","commentary":"Yuvrajsinh Dodiya to Divyaraj Chauhan, no run, st N Vaghela b Y Dodiya,","noball_dismissal":false,"text":"","timestamp":1749992968,"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":"53997","how_out":"st N Vaghela b Y Dodiya","batsman_runs":"45","batsman_balls":"26"},{"event_id":"12148692","event":"ball","batsman_id":"149625","bowler_id":"122333","over":"19","ball":"5","score":0,"commentary":"Yuvrajsinh Dodiya to Kwinsh Padaliya, no run,","noball_dismissal":false,"text":"","timestamp":1749992979,"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":"12148695","event":"ball","batsman_id":"149625","bowler_id":"122333","over":"19","ball":"6","score":1,"commentary":"Yuvrajsinh Dodiya to Kwinsh Padaliya, 1 run,","noball_dismissal":false,"text":"","timestamp":1749993056,"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":20,"runs":19,"score":"199\/6","bats":[{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":149625},{"runs":56,"balls_faced":26,"fours":3,"sixes":4,"batsman_id":130495}],"bowls":[{"runs_conceded":46,"maidens":0,"wickets":2,"bowler_id":122333,"overs":4},{"runs_conceded":40,"maidens":0,"wickets":2,"bowler_id":53998,"overs":4}],"commentary":"End of over 20 (19 runs), Dita Gohilwad Titans 199\/6"}],"day":"0","session":"0","live_inning":{"iid":198116,"number":2,"name":"Dita Gohilwad Titans Inning","short_name":"DGT Inning","status":2,"issuperover":"false","result":4,"batting_team_id":113048,"fielding_team_id":113052,"scores":"199\/6","scores_full":"199\/6 (20 ov)","fielder":[{"fielder_id":"53998","fielder_name":"Chirag Jani","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"116929","fielder_name":"Nihar Vaghela","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":1,"is_substitute":"false"},{"fielder_id":"149601","fielder_name":"Dev Dey","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"95182","fielder_name":"Amit Ranjan","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"111810","fielder_name":"Ansh Gosai","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":"Divyaraj Chauhan","batsman_id":"53997","runs":"45","balls":"26","how_out":"st N Vaghela b Y Dodiya","score_at_dismissal":198,"overs_at_dismissal":"19.4","bowler_id":"122333","dismissal":"stumped","number":6},"extra_runs":{"byes":0,"legbyes":0,"wides":5,"noballs":1,"penalty":"0","total":6},"equations":{"runs":199,"wickets":6,"overs":"20","bowlers_used":5,"runrate":"9.95"},"current_partnership":{"runs":1,"balls":2,"overs":0.2,"batsmen":[{"name":"Kwinsh Padaliya","batsman_id":149625,"runs":1,"balls":2},{"name":"Luckyraj Vaghela","batsman_id":130495,"runs":0,"balls":0}]},"did_not_bat":[{"player_id":"120390","name":"Hiten Kanbi"},{"player_id":"130497","name":"Dharmaditya Gohil"},{"player_id":"90414","name":"Vandit Jivrajani"},{"player_id":"116934","name":"Aditya Rathore"}],"max_over":"20","target":"208","recent_scores":"1,0,w,6,6,6,1,1,2,6,0,2,1,1,1,1,1,0","last_five_overs":"63\/1 12.19","last_ten_overs":"113\/3 10.94"},"teams":[{"tid":113048,"title":"Dita Gohilwad Titans","abbr":"DGT","alt_name":"DGT","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Gohilwad-Gladiators.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Gohilwad-Gladiators.png","country":"in","sex":"male","team_owner":"","head_coach":"","scores_full":"199\/6 (20 ov)","scores":"199\/6","overs":"20"},{"tid":113052,"title":"Zalwad Strikers","abbr":"ZWS","alt_name":"ZWS","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Zalwad-Strikers.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Zalwad-Strikers.png","country":"in","sex":"male","team_owner":"","head_coach":"","scores_full":"207\/3 (20 ov)","scores":"207\/3","overs":"20"}],"players":[{"pid":774,"title":"Sheldon Jackson","short_name":"S Jackson","first_name":"Sheldon Jackson","last_name":"","middle_name":"","birthdate":"1986-09-27","birthplace":"Bhavnagar, Saurashtra","country":"in","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper ","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/CircleofCricket.SheldonJackson\/","twitter_profile":"https:\/\/twitter.com\/ShelJackson27","instagram_profile":"https:\/\/www.instagram.com\/sheldonjackson27\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"wk","role_str":"(C)"},{"pid":53997,"title":"Divyaraj Chauhan","short_name":"DM Chauhan","first_name":"Divyaraj Chauhan","last_name":"","middle_name":"","birthdate":"1994-07-01","birthplace":"Jamnagar, Gujarat","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":53998,"title":"Chirag Jani","short_name":"CS Jani","first_name":"Chirag Jani","last_name":"","middle_name":"","birthdate":"1989-11-09","birthplace":" Bhavnagar","country":"in","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/chiragjani09\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":""},{"pid":90414,"title":"Vandit Jivrajani","short_name":"VM Jivrajani","first_name":"Vandit Jivrajani","last_name":"","middle_name":"","birthdate":"1991-09-03","birthplace":"Rajkot, Saurashtra","country":"in","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":90742,"title":"Harvik Desai","short_name":"Harvik Desai","first_name":"Harvik Desai","last_name":"","middle_name":"","birthdate":"1999-10-04","birthplace":" Bhavnagar","country":"in","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/harvik_desai_99\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"wk","role_str":"(WK\/C)"},{"pid":95182,"title":"Amit Ranjan","short_name":"A Ranjan","first_name":"Amit Ranjan","last_name":"","middle_name":"","birthdate":"2000-11-04","birthplace":"","country":"in","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":"India","role":"bat","role_str":""},{"pid":95206,"title":"Prasham Rajdev","short_name":"P Rajdev","first_name":"Prasham Rajdev","last_name":"","middle_name":"","birthdate":"2001-12-09","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":95252,"title":"Hetvik Kotak","short_name":"H Kotak","first_name":"Hetvik Kotak","last_name":"","middle_name":"","birthdate":"2001-10-12","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","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":"India","role":"bat","role_str":""},{"pid":95258,"title":"Prashant Gohel","short_name":"P Gohel","first_name":"Prashant Gohel","last_name":"","middle_name":"","birthdate":"1998-02-16","birthplace":"","country":"in","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":111810,"title":"Ansh Gosai","short_name":"AG Gosai","first_name":"Ansh Gosai","last_name":"","middle_name":"","birthdate":"2004-09-30","birthplace":"Rajkot","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","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":"https:\/\/www.instagram.com\/gosai_ansh_45\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":111865,"title":"Jay Gohil","short_name":"Jay Gohil","first_name":"Jay Gohil","last_name":"","middle_name":"","birthdate":"2000-12-13","birthplace":" Bhavnagar, Gujart","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","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":"India","role":"bat","role_str":""},{"pid":111866,"title":"Aezaz Kothariya","short_name":"AA Kothariya","first_name":"Aezaz Kothariya","last_name":"","middle_name":"","birthdate":"1995-08-02","birthplace":"Bhavnagar, Gujart","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","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":"India","role":"squad","role_str":""},{"pid":116788,"title":"Ankur Panwar","short_name":"A Panwar","first_name":"Ankur Panwar","last_name":"","middle_name":"","birthdate":"1999-09-10","birthplace":"","country":"in","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":116808,"title":"Sonu Batham","short_name":"S Batham","first_name":"Sonu Batham","last_name":"","middle_name":"","birthdate":"1989-11-28","birthplace":"Bhavnagar","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","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":"India","role":"squad","role_str":""},{"pid":116811,"title":"Arjun Rathod","short_name":"A Rathod","first_name":"Arjun Rathod","last_name":"","middle_name":"","birthdate":"1997-12-31","birthplace":"","country":"in","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":116837,"title":"Ruchit Ahir","short_name":"R Ahir","first_name":"Ruchit Ahir","last_name":"","middle_name":"","birthdate":"2000-10-28","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right 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":"India","role":"bat","role_str":""},{"pid":116929,"title":"Nihar Vaghela","short_name":"N Vaghela","first_name":"Nihar Vaghela","last_name":"","middle_name":"","birthdate":"2001-07-19","birthplace":"","country":"in","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":"India","role":"wk","role_str":""},{"pid":116934,"title":"Aditya Rathore","short_name":"A Rathore","first_name":"Aditya Rathore","last_name":"","middle_name":"","birthdate":"2000-03-03","birthplace":"Rajsamand, Rajasthan","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast 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":"India","role":"bowl","role_str":""},{"pid":120390,"title":"Hiten Kanbi","short_name":"H Kanbi","first_name":"Hiten Kanbi","last_name":"","middle_name":"","birthdate":"2004-04-25","birthplace":"","country":"in","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":122333,"title":"Yuvrajsinh Dodiya","short_name":"Y Dodiya","first_name":"Yuvrajsinh Dodiya","last_name":"","middle_name":"","birthdate":"2000-10-03","birthplace":"Junagadh, Gujarat","country":"in","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":"https:\/\/www.instagram.com\/yuvrajsinh_dodiya\/?hl=en","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":130489,"title":"Abhishek Nimavat","short_name":"A Nimavat","first_name":"Abhishek Nimavat","last_name":"","middle_name":"","birthdate":"2004-05-02","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":130495,"title":"Luckyraj Vaghela","short_name":"L Vaghela","first_name":"Luckyraj Vaghela","last_name":"","middle_name":"","birthdate":"2002-04-14","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","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":"India","role":"bat","role_str":""},{"pid":130497,"title":"Dharmaditya Gohil","short_name":"D Gohil","first_name":"Dharmaditya Gohil","last_name":"","middle_name":"","birthdate":"2001-09-25","birthplace":"","country":"in","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":133033,"title":"Samar Gajjar","short_name":"S Gajjar","first_name":"Samar Gajjar","last_name":"","middle_name":"","birthdate":"2003-08-14","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","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":"India","role":"all","role_str":""},{"pid":145165,"title":"Smit Patel","short_name":"S Patel","first_name":"Smit Patel","last_name":"","middle_name":"","birthdate":"2000-05-20","birthplace":"","country":"in","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":"India","role":"bowl","role_str":""},{"pid":149597,"title":"Jayvardhansinh Jadeja","short_name":"J Jadeja","first_name":"Jayvardhansinh Jadeja","last_name":"","middle_name":"","birthdate":"2001-12-19","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":149598,"title":"Namya Khoyani","short_name":"N Khoyani","first_name":"Namya Khoyani","last_name":"","middle_name":"","birthdate":"2003-08-07","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":"(WK)"},{"pid":149599,"title":"Harshvardhan Rana","short_name":"H Rana","first_name":"Harshvardhan Rana","last_name":"","middle_name":"","birthdate":"2003-10-10","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","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":"India","role":"squad","role_str":""},{"pid":149600,"title":"Vaibhav Bambhania","short_name":"V Bambhania","first_name":"Vaibhav Bambhania","last_name":"","middle_name":"","birthdate":"2001-06-29","birthplace":"","country":"in","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":""},{"pid":149601,"title":"Dev Dey","short_name":"D Dey","first_name":"Dev Dey","last_name":"","middle_name":"","birthdate":"2003-10-20","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","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":"India","role":"all","role_str":""},{"pid":149602,"title":"Samir Pathan","short_name":"S Pathan","first_name":"Samir Pathan","last_name":"","middle_name":"","birthdate":"1999-11-02","birthplace":"","country":"in","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":149623,"title":"Kartik Badhana","short_name":"K Badhana","first_name":"Kartik Badhana","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","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":"India","role":"bat","role_str":""},{"pid":149624,"title":"Vatsal Patel","short_name":"V Patel","first_name":"Vatsal Patel","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":149625,"title":"Kwinsh Padaliya","short_name":"K Padaliya","first_name":"Kwinsh Padaliya","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","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":"India","role":"all","role_str":""},{"pid":149626,"title":"Rizwan Dal","short_name":"R Dal","first_name":"Rizwan Dal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":149627,"title":"Atri Raval","short_name":"A Raval","first_name":"Atri Raval","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""}]},"etag":"202e4fd9730cb9ea26ccbf641a1ce347","modified":"2025-08-07 17:44:58","datetime":"2025-08-07 17:44:58","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":90517,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Zalwad Strikers won by 8 runs","day_remaining_over":"","team_batting":"Dita Gohilwad Titans","team_bowling":"Zalwad Strikers","live_inning_number":2,"live_score":{"runs":199,"overs":20,"wickets":6,"target":208,"runrate":9.95,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Kwinsh Padaliya","batsman_id":149625,"runs":1,"balls_faced":2,"fours":0,"sixes":0,"strike_rate":"50.00"},{"name":"Luckyraj Vaghela","batsman_id":130495,"runs":55,"balls_faced":26,"fours":3,"sixes":4,"strike_rate":"211.54"}],"bowlers":[{"name":"Yuvrajsinh Dodiya","bowler_id":122333,"overs":4,"runs_conceded":46,"wickets":2,"maidens":0,"econ":"11.50"},{"name":"Chirag Jani","bowler_id":53998,"overs":4,"runs_conceded":39,"wickets":2,"maidens":0,"econ":"9.8"}],"commentaries":[{"event_id":"12148556","event":"ball","batsman_id":"130495","bowler_id":"122333","over":"15","ball":"6","score":1,"commentary":"Yuvrajsinh Dodiya to Luckyraj Vaghela, 1 run,","noball_dismissal":false,"text":"","timestamp":1749991434,"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":16,"runs":10,"score":"146\/5","bats":[{"runs":27,"balls_faced":13,"fours":2,"sixes":2,"batsman_id":130495},{"runs":22,"balls_faced":16,"fours":3,"sixes":0,"batsman_id":53997}],"bowls":[{"runs_conceded":27,"maidens":0,"wickets":1,"bowler_id":122333,"overs":3},{"runs_conceded":31,"maidens":0,"wickets":0,"bowler_id":116788,"overs":3}],"commentary":"End of over 16 (10 runs), Dita Gohilwad Titans 146\/5"},{"event_id":"12148563","event":"ball","batsman_id":"130495","bowler_id":"53998","over":"16","ball":"1","score":4,"commentary":"Chirag Jani to Luckyraj Vaghela, Four,","noball_dismissal":false,"text":"","timestamp":1749991476,"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":"12148567","event":"ball","batsman_id":"130495","bowler_id":"53998","over":"16","ball":"2","score":6,"commentary":"Chirag Jani to Luckyraj Vaghela, Six,","noball_dismissal":false,"text":"","timestamp":1749991528,"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":"12148579","event":"ball","batsman_id":"130495","bowler_id":"53998","over":"16","ball":"3","score":1,"commentary":"Chirag Jani to Luckyraj Vaghela, 1 run,","noball_dismissal":false,"text":"","timestamp":1749991611,"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":"12148580","event":"ball","batsman_id":"53997","bowler_id":"53998","over":"16","ball":"4","score":1,"commentary":"Chirag Jani to Divyaraj Chauhan, 1 run,","noball_dismissal":false,"text":"","timestamp":1749991614,"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":"12148584","event":"ball","batsman_id":"130495","bowler_id":"53998","over":"16","ball":"5","score":2,"commentary":"Chirag Jani to Luckyraj Vaghela, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749991666,"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":"12148593","event":"ball","batsman_id":"130495","bowler_id":"53998","over":"16","ball":"6","score":2,"commentary":"Chirag Jani to Luckyraj Vaghela, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749991775,"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":"overend","over":17,"runs":16,"score":"162\/5","bats":[{"runs":42,"balls_faced":18,"fours":3,"sixes":3,"batsman_id":130495},{"runs":23,"balls_faced":17,"fours":3,"sixes":0,"batsman_id":53997}],"bowls":[{"runs_conceded":28,"maidens":0,"wickets":2,"bowler_id":53998,"overs":3},{"runs_conceded":27,"maidens":0,"wickets":1,"bowler_id":122333,"overs":3}],"commentary":"End of over 17 (16 runs), Dita Gohilwad Titans 162\/5"},{"event_id":"12148598","event":"ball","batsman_id":"53997","bowler_id":"116788","over":"17","ball":"1","score":"1nb","commentary":"Ankur Panwar to Divyaraj Chauhan, 1 no ball,","noball_dismissal":false,"text":"","timestamp":1749991844,"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":"12148607","event":"ball","batsman_id":"53997","bowler_id":"116788","over":"17","ball":"1","score":0,"commentary":"Ankur Panwar to Divyaraj Chauhan, no run,","noball_dismissal":false,"text":"","timestamp":1749993441,"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":"12148609","event":"ball","batsman_id":"130495","bowler_id":"116788","over":"17","ball":"2","score":1,"commentary":"Ankur Panwar to Luckyraj Vaghela, 1 run,","noball_dismissal":false,"text":"","timestamp":1749991927,"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":"12148610","event":"ball","batsman_id":"53997","bowler_id":"116788","over":"17","ball":"3","score":1,"commentary":"Ankur Panwar to Divyaraj Chauhan, 1 run,","noball_dismissal":false,"text":"","timestamp":1749991947,"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":"12148615","event":"ball","batsman_id":"130495","bowler_id":"116788","over":"17","ball":"4","score":1,"commentary":"Ankur Panwar to Luckyraj Vaghela, 1 run,","noball_dismissal":false,"text":"","timestamp":1749991978,"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":"12148620","event":"ball","batsman_id":"53997","bowler_id":"116788","over":"17","ball":"5","score":1,"commentary":"Ankur Panwar to Divyaraj Chauhan, 1 run,","noball_dismissal":false,"text":"","timestamp":1749992012,"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":"12148625","event":"ball","batsman_id":"130495","bowler_id":"116788","over":"17","ball":"6","score":1,"commentary":"Ankur Panwar to Luckyraj Vaghela, 1 run,","noball_dismissal":false,"text":"","timestamp":1749992109,"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":6,"score":"168\/5","bats":[{"runs":45,"balls_faced":21,"fours":3,"sixes":3,"batsman_id":130495},{"runs":25,"balls_faced":21,"fours":3,"sixes":0,"batsman_id":53997}],"bowls":[{"runs_conceded":37,"maidens":0,"wickets":0,"bowler_id":116788,"overs":4},{"runs_conceded":28,"maidens":0,"wickets":2,"bowler_id":53998,"overs":3}],"commentary":"End of over 18 (6 runs), Dita Gohilwad Titans 168\/5"},{"event_id":"12148633","event":"ball","batsman_id":"130495","bowler_id":"53998","over":"18","ball":"1","score":2,"commentary":"Chirag Jani to Luckyraj Vaghela, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749992169,"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":"12148634","event":"ball","batsman_id":"130495","bowler_id":"53998","over":"18","ball":"2","score":0,"commentary":"Chirag Jani to Luckyraj Vaghela, no run,","noball_dismissal":false,"text":"","timestamp":1749992183,"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":"12148636","event":"ball","batsman_id":"130495","bowler_id":"53998","over":"18","ball":"3","score":6,"commentary":"Chirag Jani to Luckyraj Vaghela, Six,","noball_dismissal":false,"text":"","timestamp":1749992291,"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":"12148641","event":"ball","batsman_id":"130495","bowler_id":"53998","over":"18","ball":"4","score":2,"commentary":"Chirag Jani to Luckyraj Vaghela, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749992295,"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":"12148644","event":"ball","batsman_id":"130495","bowler_id":"53998","over":"18","ball":"5","score":1,"commentary":"Chirag Jani to Luckyraj Vaghela, 1 run,","noball_dismissal":false,"text":"","timestamp":1749992327,"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":"12148651","event":"ball","batsman_id":"53997","bowler_id":"53998","over":"18","ball":"6","score":1,"commentary":"Chirag Jani to Divyaraj Chauhan, 1 run,","noball_dismissal":false,"text":"","timestamp":1749992379,"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":19,"runs":12,"score":"180\/5","bats":[{"runs":26,"balls_faced":22,"fours":3,"sixes":0,"batsman_id":53997},{"runs":56,"balls_faced":26,"fours":3,"sixes":4,"batsman_id":130495}],"bowls":[{"runs_conceded":40,"maidens":0,"wickets":2,"bowler_id":53998,"overs":4},{"runs_conceded":37,"maidens":0,"wickets":0,"bowler_id":116788,"overs":4}],"commentary":"End of over 19 (12 runs), Dita Gohilwad Titans 180\/5"},{"event_id":"12148668","event":"ball","batsman_id":"53997","bowler_id":"122333","over":"19","ball":"1","score":6,"commentary":"Yuvrajsinh Dodiya to Divyaraj Chauhan, Six,","noball_dismissal":false,"text":"","timestamp":1749992938,"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":"12148669","event":"ball","batsman_id":"53997","bowler_id":"122333","over":"19","ball":"2","score":6,"commentary":"Yuvrajsinh Dodiya to Divyaraj Chauhan, Six,","noball_dismissal":false,"text":"","timestamp":1749992940,"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":"12148670","event":"ball","batsman_id":"53997","bowler_id":"122333","over":"19","ball":"3","score":6,"commentary":"Yuvrajsinh Dodiya to Divyaraj Chauhan, Six,","noball_dismissal":false,"text":"","timestamp":1749992944,"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":"12148691","event":"wicket","batsman_id":"53997","bowler_id":"122333","over":"19","ball":"4","score":"w","commentary":"Yuvrajsinh Dodiya to Divyaraj Chauhan, no run, st N Vaghela b Y Dodiya,","noball_dismissal":false,"text":"","timestamp":1749992968,"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":"53997","how_out":"st N Vaghela b Y Dodiya","batsman_runs":"45","batsman_balls":"26"},{"event_id":"12148692","event":"ball","batsman_id":"149625","bowler_id":"122333","over":"19","ball":"5","score":0,"commentary":"Yuvrajsinh Dodiya to Kwinsh Padaliya, no run,","noball_dismissal":false,"text":"","timestamp":1749992979,"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":"12148695","event":"ball","batsman_id":"149625","bowler_id":"122333","over":"19","ball":"6","score":1,"commentary":"Yuvrajsinh Dodiya to Kwinsh Padaliya, 1 run,","noball_dismissal":false,"text":"","timestamp":1749993056,"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":20,"runs":19,"score":"199\/6","bats":[{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":149625},{"runs":56,"balls_faced":26,"fours":3,"sixes":4,"batsman_id":130495}],"bowls":[{"runs_conceded":46,"maidens":0,"wickets":2,"bowler_id":122333,"overs":4},{"runs_conceded":40,"maidens":0,"wickets":2,"bowler_id":53998,"overs":4}],"commentary":"End of over 20 (19 runs), Dita Gohilwad Titans 199\/6"}],"day":"0","session":"0","live_inning":{"iid":198116,"number":2,"name":"Dita Gohilwad Titans Inning","short_name":"DGT Inning","status":2,"issuperover":"false","result":4,"batting_team_id":113048,"fielding_team_id":113052,"scores":"199\/6","scores_full":"199\/6 (20 ov)","fielder":[{"fielder_id":"53998","fielder_name":"Chirag Jani","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"116929","fielder_name":"Nihar Vaghela","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":1,"is_substitute":"false"},{"fielder_id":"149601","fielder_name":"Dev Dey","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"95182","fielder_name":"Amit Ranjan","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"111810","fielder_name":"Ansh Gosai","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":"Divyaraj Chauhan","batsman_id":"53997","runs":"45","balls":"26","how_out":"st N Vaghela b Y Dodiya","score_at_dismissal":198,"overs_at_dismissal":"19.4","bowler_id":"122333","dismissal":"stumped","number":6},"extra_runs":{"byes":0,"legbyes":0,"wides":5,"noballs":1,"penalty":"0","total":6},"equations":{"runs":199,"wickets":6,"overs":"20","bowlers_used":5,"runrate":"9.95"},"current_partnership":{"runs":1,"balls":2,"overs":0.2,"batsmen":[{"name":"Kwinsh Padaliya","batsman_id":149625,"runs":1,"balls":2},{"name":"Luckyraj Vaghela","batsman_id":130495,"runs":0,"balls":0}]},"did_not_bat":[{"player_id":"120390","name":"Hiten Kanbi"},{"player_id":"130497","name":"Dharmaditya Gohil"},{"player_id":"90414","name":"Vandit Jivrajani"},{"player_id":"116934","name":"Aditya Rathore"}],"max_over":"20","target":"208","recent_scores":"1,0,w,6,6,6,1,1,2,6,0,2,1,1,1,1,1,0","last_five_overs":"63\/1 12.19","last_ten_overs":"113\/3 10.94"},"teams":[{"tid":113048,"title":"Dita Gohilwad Titans","abbr":"DGT","alt_name":"DGT","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Gohilwad-Gladiators.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Gohilwad-Gladiators.png","country":"in","sex":"male","team_owner":"","head_coach":"","scores_full":"199\/6 (20 ov)","scores":"199\/6","overs":"20"},{"tid":113052,"title":"Zalwad Strikers","abbr":"ZWS","alt_name":"ZWS","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Zalwad-Strikers.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Zalwad-Strikers.png","country":"in","sex":"male","team_owner":"","head_coach":"","scores_full":"207\/3 (20 ov)","scores":"207\/3","overs":"20"}],"players":[{"pid":774,"title":"Sheldon Jackson","short_name":"S Jackson","first_name":"Sheldon Jackson","last_name":"","middle_name":"","birthdate":"1986-09-27","birthplace":"Bhavnagar, Saurashtra","country":"in","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper ","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/CircleofCricket.SheldonJackson\/","twitter_profile":"https:\/\/twitter.com\/ShelJackson27","instagram_profile":"https:\/\/www.instagram.com\/sheldonjackson27\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"wk","role_str":"(C)"},{"pid":53997,"title":"Divyaraj Chauhan","short_name":"DM Chauhan","first_name":"Divyaraj Chauhan","last_name":"","middle_name":"","birthdate":"1994-07-01","birthplace":"Jamnagar, Gujarat","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":53998,"title":"Chirag Jani","short_name":"CS Jani","first_name":"Chirag Jani","last_name":"","middle_name":"","birthdate":"1989-11-09","birthplace":" Bhavnagar","country":"in","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/chiragjani09\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":""},{"pid":90414,"title":"Vandit Jivrajani","short_name":"VM Jivrajani","first_name":"Vandit Jivrajani","last_name":"","middle_name":"","birthdate":"1991-09-03","birthplace":"Rajkot, Saurashtra","country":"in","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":90742,"title":"Harvik Desai","short_name":"Harvik Desai","first_name":"Harvik Desai","last_name":"","middle_name":"","birthdate":"1999-10-04","birthplace":" Bhavnagar","country":"in","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/harvik_desai_99\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"wk","role_str":"(WK\/C)"},{"pid":95182,"title":"Amit Ranjan","short_name":"A Ranjan","first_name":"Amit Ranjan","last_name":"","middle_name":"","birthdate":"2000-11-04","birthplace":"","country":"in","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":"India","role":"bat","role_str":""},{"pid":95206,"title":"Prasham Rajdev","short_name":"P Rajdev","first_name":"Prasham Rajdev","last_name":"","middle_name":"","birthdate":"2001-12-09","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":95252,"title":"Hetvik Kotak","short_name":"H Kotak","first_name":"Hetvik Kotak","last_name":"","middle_name":"","birthdate":"2001-10-12","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","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":"India","role":"bat","role_str":""},{"pid":95258,"title":"Prashant Gohel","short_name":"P Gohel","first_name":"Prashant Gohel","last_name":"","middle_name":"","birthdate":"1998-02-16","birthplace":"","country":"in","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":111810,"title":"Ansh Gosai","short_name":"AG Gosai","first_name":"Ansh Gosai","last_name":"","middle_name":"","birthdate":"2004-09-30","birthplace":"Rajkot","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","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":"https:\/\/www.instagram.com\/gosai_ansh_45\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":111865,"title":"Jay Gohil","short_name":"Jay Gohil","first_name":"Jay Gohil","last_name":"","middle_name":"","birthdate":"2000-12-13","birthplace":" Bhavnagar, Gujart","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","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":"India","role":"bat","role_str":""},{"pid":111866,"title":"Aezaz Kothariya","short_name":"AA Kothariya","first_name":"Aezaz Kothariya","last_name":"","middle_name":"","birthdate":"1995-08-02","birthplace":"Bhavnagar, Gujart","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","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":"India","role":"squad","role_str":""},{"pid":116788,"title":"Ankur Panwar","short_name":"A Panwar","first_name":"Ankur Panwar","last_name":"","middle_name":"","birthdate":"1999-09-10","birthplace":"","country":"in","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":116808,"title":"Sonu Batham","short_name":"S Batham","first_name":"Sonu Batham","last_name":"","middle_name":"","birthdate":"1989-11-28","birthplace":"Bhavnagar","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","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":"India","role":"squad","role_str":""},{"pid":116811,"title":"Arjun Rathod","short_name":"A Rathod","first_name":"Arjun Rathod","last_name":"","middle_name":"","birthdate":"1997-12-31","birthplace":"","country":"in","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":116837,"title":"Ruchit Ahir","short_name":"R Ahir","first_name":"Ruchit Ahir","last_name":"","middle_name":"","birthdate":"2000-10-28","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right 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":"India","role":"bat","role_str":""},{"pid":116929,"title":"Nihar Vaghela","short_name":"N Vaghela","first_name":"Nihar Vaghela","last_name":"","middle_name":"","birthdate":"2001-07-19","birthplace":"","country":"in","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":"India","role":"wk","role_str":""},{"pid":116934,"title":"Aditya Rathore","short_name":"A Rathore","first_name":"Aditya Rathore","last_name":"","middle_name":"","birthdate":"2000-03-03","birthplace":"Rajsamand, Rajasthan","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast 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":"India","role":"bowl","role_str":""},{"pid":120390,"title":"Hiten Kanbi","short_name":"H Kanbi","first_name":"Hiten Kanbi","last_name":"","middle_name":"","birthdate":"2004-04-25","birthplace":"","country":"in","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":122333,"title":"Yuvrajsinh Dodiya","short_name":"Y Dodiya","first_name":"Yuvrajsinh Dodiya","last_name":"","middle_name":"","birthdate":"2000-10-03","birthplace":"Junagadh, Gujarat","country":"in","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":"https:\/\/www.instagram.com\/yuvrajsinh_dodiya\/?hl=en","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":130489,"title":"Abhishek Nimavat","short_name":"A Nimavat","first_name":"Abhishek Nimavat","last_name":"","middle_name":"","birthdate":"2004-05-02","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":130495,"title":"Luckyraj Vaghela","short_name":"L Vaghela","first_name":"Luckyraj Vaghela","last_name":"","middle_name":"","birthdate":"2002-04-14","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","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":"India","role":"bat","role_str":""},{"pid":130497,"title":"Dharmaditya Gohil","short_name":"D Gohil","first_name":"Dharmaditya Gohil","last_name":"","middle_name":"","birthdate":"2001-09-25","birthplace":"","country":"in","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":133033,"title":"Samar Gajjar","short_name":"S Gajjar","first_name":"Samar Gajjar","last_name":"","middle_name":"","birthdate":"2003-08-14","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","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":"India","role":"all","role_str":""},{"pid":145165,"title":"Smit Patel","short_name":"S Patel","first_name":"Smit Patel","last_name":"","middle_name":"","birthdate":"2000-05-20","birthplace":"","country":"in","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":"India","role":"bowl","role_str":""},{"pid":149597,"title":"Jayvardhansinh Jadeja","short_name":"J Jadeja","first_name":"Jayvardhansinh Jadeja","last_name":"","middle_name":"","birthdate":"2001-12-19","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":149598,"title":"Namya Khoyani","short_name":"N Khoyani","first_name":"Namya Khoyani","last_name":"","middle_name":"","birthdate":"2003-08-07","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":"(WK)"},{"pid":149599,"title":"Harshvardhan Rana","short_name":"H Rana","first_name":"Harshvardhan Rana","last_name":"","middle_name":"","birthdate":"2003-10-10","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","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":"India","role":"squad","role_str":""},{"pid":149600,"title":"Vaibhav Bambhania","short_name":"V Bambhania","first_name":"Vaibhav Bambhania","last_name":"","middle_name":"","birthdate":"2001-06-29","birthplace":"","country":"in","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":""},{"pid":149601,"title":"Dev Dey","short_name":"D Dey","first_name":"Dev Dey","last_name":"","middle_name":"","birthdate":"2003-10-20","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","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":"India","role":"all","role_str":""},{"pid":149602,"title":"Samir Pathan","short_name":"S Pathan","first_name":"Samir Pathan","last_name":"","middle_name":"","birthdate":"1999-11-02","birthplace":"","country":"in","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":149623,"title":"Kartik Badhana","short_name":"K Badhana","first_name":"Kartik Badhana","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","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":"India","role":"bat","role_str":""},{"pid":149624,"title":"Vatsal Patel","short_name":"V Patel","first_name":"Vatsal Patel","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":149625,"title":"Kwinsh Padaliya","short_name":"K Padaliya","first_name":"Kwinsh Padaliya","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","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":"India","role":"all","role_str":""},{"pid":149626,"title":"Rizwan Dal","short_name":"R Dal","first_name":"Rizwan Dal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":149627,"title":"Atri Raval","short_name":"A Raval","first_name":"Atri Raval","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""}]},"etag":"202e4fd9730cb9ea26ccbf641a1ce347","modified":"2025-08-07 17:44:58","datetime":"2025-08-07 17:44:58","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90517 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:2b8ee29f-1505-4065-9a99-9948745df1af Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90517 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90517,3,'{"status":"ok","response":{"match_id":90517,"title":"Dita Gohilwad Titans vs Zalawad Strikers","short_title":"DGT vs ZWS","subtitle":"Match 14","match_number":"14","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Zalwad Strikers won by 8 runs","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129616,"title":"Saurashtra Pro T20 League","abbr":"SPT20","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-06-07","dateend":"2025-06-20","country":"in","total_matches":"21","total_rounds":"1","total_teams":"5"},"teama":{"team_id":113048,"name":"Dita Gohilwad Titans","short_name":"DGT","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Gohilwad-Gladiators.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Gohilwad-Gladiators.png","scores_full":"199\/6 (20 ov)","scores":"199\/6","overs":"20"},"teamb":{"team_id":113052,"name":"Zalwad Strikers","short_name":"ZWS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Zalwad-Strikers.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Zalwad-Strikers.png","scores_full":"207\/3 (20 ov)","scores":"207\/3","overs":"20"},"date_start":"2025-06-15 09:30:00","date_end":"2025-06-15 19:30:00","timestamp_start":1749979800,"timestamp_end":1750015800,"date_start_ist":"2025-06-15 15:00:00","date_end_ist":"2025-06-16 01:00:00","venue":{"venue_id":"21","name":"Niranjan Shah Stadium, Khandheri","location":"Rajkot","country":"India","timezone":""},"umpires":"Bhavesh Patel (India), Neel Khakhar (India), Darshit Joshi (India, TV)","referee":"Altaf Merchant (India)","equation":"","live":"","result":"ZWS won by 8 runs","result_type":2,"win_margin":"8 runs","winning_team_id":113052,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-13 01:09:47","verify_time":"2025-06-15 19:01:20","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"broken clouds","temp":34,"humidity":51,"visibility":10000,"wind_speed":"6.60","clouds":81},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Zalwad Strikers elected to bat","winner":113052,"decision":1}},"etag":"3b31fc401dfd015f798d330aac24fe1e","modified":"2025-08-07 17:44:59","datetime":"2025-08-07 17:44:59","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90517,"title":"Dita Gohilwad Titans vs Zalawad Strikers","short_title":"DGT vs ZWS","subtitle":"Match 14","match_number":"14","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Zalwad Strikers won by 8 runs","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129616,"title":"Saurashtra Pro T20 League","abbr":"SPT20","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-06-07","dateend":"2025-06-20","country":"in","total_matches":"21","total_rounds":"1","total_teams":"5"},"teama":{"team_id":113048,"name":"Dita Gohilwad Titans","short_name":"DGT","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Gohilwad-Gladiators.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Gohilwad-Gladiators.png","scores_full":"199\/6 (20 ov)","scores":"199\/6","overs":"20"},"teamb":{"team_id":113052,"name":"Zalwad Strikers","short_name":"ZWS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Zalwad-Strikers.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Zalwad-Strikers.png","scores_full":"207\/3 (20 ov)","scores":"207\/3","overs":"20"},"date_start":"2025-06-15 09:30:00","date_end":"2025-06-15 19:30:00","timestamp_start":1749979800,"timestamp_end":1750015800,"date_start_ist":"2025-06-15 15:00:00","date_end_ist":"2025-06-16 01:00:00","venue":{"venue_id":"21","name":"Niranjan Shah Stadium, Khandheri","location":"Rajkot","country":"India","timezone":""},"umpires":"Bhavesh Patel (India), Neel Khakhar (India), Darshit Joshi (India, TV)","referee":"Altaf Merchant (India)","equation":"","live":"","result":"ZWS won by 8 runs","result_type":2,"win_margin":"8 runs","winning_team_id":113052,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-13 01:09:47","verify_time":"2025-06-15 19:01:20","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"broken clouds","temp":34,"humidity":51,"visibility":10000,"wind_speed":"6.60","clouds":81},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Zalwad Strikers elected to bat","winner":113052,"decision":1}},"etag":"3b31fc401dfd015f798d330aac24fe1e","modified":"2025-08-07 17:44:59","datetime":"2025-08-07 17:44:59","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90517 AND DataTypeId = 3 END
Live Report & Scorecard of Dita Gohilwad Titans vs Zalawad Strikers Match 14