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:8724da77-db48-4db6-b5fe-523755734b1b Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90508 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90508,1,'{"status":"ok","response":{"mid":90508,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Zalwad Strikers won by 16 runs","day_remaining_over":"","team_batting":"Dita Gohilwad Titans","team_bowling":"Zalwad Strikers","live_inning_number":2,"live_score":{"runs":117,"overs":18.5,"wickets":10,"target":134,"runrate":6.21,"required_runrate":14.57},"commentary":1,"wagon":2,"batsmen":[{"name":"Dharmaditya Gohil","batsman_id":130497,"runs":0,"balls_faced":2,"fours":0,"sixes":0,"strike_rate":"0.00"},{"name":"Kartik Badhana","batsman_id":149623,"runs":8,"balls_faced":6,"fours":1,"sixes":0,"strike_rate":"133.33"}],"bowlers":[{"name":"Chirag Jani","bowler_id":53998,"overs":3.5,"runs_conceded":25,"wickets":1,"maidens":0,"econ":"6.52"},{"name":"Ankur Panwar","bowler_id":116788,"overs":3,"runs_conceded":20,"wickets":5,"maidens":0,"econ":"6.67"}],"commentaries":[{"event_id":"12108442","event":"ball","batsman_id":"133033","bowler_id":"145165","over":"14","ball":"3","score":1,"commentary":"Smit Patel to Samar Gajjar, 1 run,","noball_dismissal":false,"text":"","timestamp":1749488504,"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":"12108443","event":"ball","batsman_id":"130495","bowler_id":"145165","over":"14","ball":"4","score":1,"commentary":"Smit Patel to Luckyraj Vaghela, 1 run,","noball_dismissal":false,"text":"","timestamp":1749488506,"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":"12108445","event":"ball","batsman_id":"133033","bowler_id":"145165","over":"14","ball":"5","score":1,"commentary":"Smit Patel to Samar Gajjar, 1 run,","noball_dismissal":false,"text":"","timestamp":1749488508,"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":"12108446","event":"ball","batsman_id":"130495","bowler_id":"145165","over":"14","ball":"6","score":1,"commentary":"Smit Patel to Luckyraj Vaghela, 1 run,","noball_dismissal":false,"text":"","timestamp":1749488511,"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":5,"score":"93\/4","bats":[{"runs":3,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":130495},{"runs":4,"balls_faced":7,"fours":0,"sixes":0,"batsman_id":133033}],"bowls":[{"runs_conceded":15,"maidens":0,"wickets":2,"bowler_id":145165,"overs":4},{"runs_conceded":8,"maidens":0,"wickets":0,"bowler_id":122333,"overs":1}],"commentary":"End of over 15 (5 runs), Dita Gohilwad Titans 93\/4"},{"event_id":"12108456","event":"ball","batsman_id":"130495","bowler_id":"149601","over":"15","ball":"1","score":0,"commentary":"Dev Dey to Luckyraj Vaghela, no run,","noball_dismissal":false,"text":"","timestamp":1749488515,"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":"12108457","event":"ball","batsman_id":"130495","bowler_id":"149601","over":"15","ball":"2","score":1,"commentary":"Dev Dey to Luckyraj Vaghela, 1 run,","noball_dismissal":false,"text":"","timestamp":1749488518,"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":"12108465","event":"ball","batsman_id":"133033","bowler_id":"149601","over":"15","ball":"3","score":4,"commentary":"Dev Dey to Samar Gajjar, Four,","noball_dismissal":false,"text":"","timestamp":1749488554,"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":"12108469","event":"ball","batsman_id":"133033","bowler_id":"149601","over":"15","ball":"4","score":1,"commentary":"Dev Dey to Samar Gajjar, 1 run,","noball_dismissal":false,"text":"","timestamp":1749488596,"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":"12108470","event":"ball","batsman_id":"130495","bowler_id":"149601","over":"15","ball":"5","score":2,"commentary":"Dev Dey to Luckyraj Vaghela, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749488600,"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":"12108474","event":"wicket","batsman_id":"130495","bowler_id":"149601","over":"15","ball":"6","score":"w","commentary":"Dev Dey to Luckyraj Vaghela, no run, c A Ranjan b D Dey,","noball_dismissal":false,"text":"","timestamp":1749488751,"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":"130495","how_out":"c A Ranjan b D Dey","batsman_runs":"6","batsman_balls":"7"},{"event":"overend","over":16,"runs":8,"score":"101\/5","bats":[{"runs":6,"balls_faced":7,"fours":0,"sixes":0,"batsman_id":130495},{"runs":9,"balls_faced":9,"fours":1,"sixes":0,"batsman_id":133033}],"bowls":[{"runs_conceded":24,"maidens":0,"wickets":2,"bowler_id":149601,"overs":4},{"runs_conceded":15,"maidens":0,"wickets":2,"bowler_id":145165,"overs":4}],"commentary":"End of over 16 (8 runs), Dita Gohilwad Titans 101\/5"},{"event_id":"12108494","event":"ball","batsman_id":"133033","bowler_id":"53998","over":"16","ball":"1","score":1,"commentary":"Chirag Jani to Samar Gajjar, 1 run,","noball_dismissal":false,"text":"","timestamp":1749488848,"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":"12108495","event":"ball","batsman_id":"149623","bowler_id":"53998","over":"16","ball":"2","score":1,"commentary":"Chirag Jani to Kartik Badhana, 1 run,","noball_dismissal":false,"text":"","timestamp":1749488851,"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":"12108497","event":"ball","batsman_id":"133033","bowler_id":"53998","over":"16","ball":"3","score":4,"commentary":"Chirag Jani to Samar Gajjar, Four,","noball_dismissal":false,"text":"","timestamp":1749488854,"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":"12108505","event":"ball","batsman_id":"133033","bowler_id":"53998","over":"16","ball":"4","score":2,"commentary":"Chirag Jani to Samar Gajjar, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749488954,"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":"12108506","event":"ball","batsman_id":"133033","bowler_id":"53998","over":"16","ball":"5","score":1,"commentary":"Chirag Jani to Samar Gajjar, 1 run,","noball_dismissal":false,"text":"","timestamp":1749488958,"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":"12108512","event":"ball","batsman_id":"149623","bowler_id":"53998","over":"16","ball":"6","score":1,"commentary":"Chirag Jani to Kartik Badhana, 1 run,","noball_dismissal":false,"text":"","timestamp":1749489001,"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":10,"score":"111\/5","bats":[{"runs":2,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":149623},{"runs":17,"balls_faced":13,"fours":2,"sixes":0,"batsman_id":133033}],"bowls":[{"runs_conceded":20,"maidens":0,"wickets":0,"bowler_id":53998,"overs":3},{"runs_conceded":24,"maidens":0,"wickets":2,"bowler_id":149601,"overs":4}],"commentary":"End of over 17 (10 runs), Dita Gohilwad Titans 111\/5"},{"event_id":"12108521","event":"ball","batsman_id":"149623","bowler_id":"116788","over":"17","ball":"1","score":1,"commentary":"Ankur Panwar to Kartik Badhana, 1 run,","noball_dismissal":false,"text":"","timestamp":1749489074,"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":"12108527","event":"wicket","batsman_id":"133033","bowler_id":"116788","over":"17","ball":"2","score":"w","commentary":"Ankur Panwar to Samar Gajjar, no run, c AG Gosai b A Panwar,","noball_dismissal":false,"text":"","timestamp":1749489169,"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":"133033","how_out":"c AG Gosai b A Panwar","batsman_runs":"17","batsman_balls":"14"},{"event_id":"12108541","event":"wicket","batsman_id":"149625","bowler_id":"116788","over":"17","ball":"3","score":"w","commentary":"Ankur Panwar to Kwinsh Padaliya, no run, c N Vaghela b A Panwar,","noball_dismissal":false,"text":"","timestamp":1749489264,"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":"149625","how_out":"c N Vaghela b A Panwar","batsman_runs":"0","batsman_balls":"1"},{"event_id":"12108550","event":"ball","batsman_id":"116934","bowler_id":"116788","over":"17","ball":"4","score":0,"commentary":"Ankur Panwar to Aditya Rathore, no run,","noball_dismissal":false,"text":"","timestamp":1749489358,"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":"12108555","event":"wicket","batsman_id":"116934","bowler_id":"116788","over":"17","ball":"5","score":"w","commentary":"Ankur Panwar to Aditya Rathore, no run, c S Patel b A Panwar,","noball_dismissal":false,"text":"","timestamp":1749489435,"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":"116934","how_out":"c S Patel b A Panwar","batsman_runs":"0","batsman_balls":"2"},{"event_id":"12108572","event":"wicket","batsman_id":"120390","bowler_id":"116788","over":"17","ball":"6","score":"w","commentary":"Ankur Panwar to Hiten Kanbi, no run, b A Panwar,","noball_dismissal":false,"text":"","timestamp":1749489517,"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":"120390","how_out":"b A Panwar","batsman_runs":"0","batsman_balls":"1"},{"event":"overend","over":18,"runs":1,"score":"112\/9","bats":[{"runs":0,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":120390},{"runs":3,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":149623}],"bowls":[{"runs_conceded":20,"maidens":0,"wickets":5,"bowler_id":116788,"overs":3},{"runs_conceded":20,"maidens":0,"wickets":0,"bowler_id":53998,"overs":3}],"commentary":"End of over 18 (1 runs), Dita Gohilwad Titans 112\/9"},{"event_id":"12108588","event":"ball","batsman_id":"149623","bowler_id":"53998","over":"18","ball":"1","score":4,"commentary":"Chirag Jani to Kartik Badhana, Four,","noball_dismissal":false,"text":"","timestamp":1749489713,"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":"12108589","event":"ball","batsman_id":"149623","bowler_id":"53998","over":"18","ball":"2","score":0,"commentary":"Chirag Jani to Kartik Badhana, no run,","noball_dismissal":false,"text":"","timestamp":1749489716,"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":"12108593","event":"ball","batsman_id":"149623","bowler_id":"53998","over":"18","ball":"3","score":1,"commentary":"Chirag Jani to Kartik Badhana, 1 run,","noball_dismissal":false,"text":"","timestamp":1749489741,"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":"12108599","event":"ball","batsman_id":"130497","bowler_id":"53998","over":"18","ball":"4","score":0,"commentary":"Chirag Jani to Dharmaditya Gohil, no run,","noball_dismissal":false,"text":"","timestamp":1749489892,"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":"12108600","event":"wicket","batsman_id":"130497","bowler_id":"53998","over":"18","ball":"5","score":"w","commentary":"Chirag Jani to Dharmaditya Gohil, no run, c Y Dodiya b CS Jani,","noball_dismissal":false,"text":"","timestamp":1749489981,"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":"130497","how_out":"c Y Dodiya b CS Jani","batsman_runs":"0","batsman_balls":"2"}],"day":"0","session":"0","live_inning":{"iid":197735,"number":2,"name":"Dita Gohilwad Titans Inning","short_name":"DGT Inning","status":2,"issuperover":"false","result":1,"batting_team_id":113048,"fielding_team_id":113052,"scores":"117\/10","scores_full":"117\/10 (18.5 ov)","fielder":[{"fielder_id":"95182","fielder_name":"Amit Ranjan","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"149599","fielder_name":"Harshvardhan Rana","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"},{"fielder_id":"116929","fielder_name":"Nihar Vaghela","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"145165","fielder_name":"Smit Patel","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"122333","fielder_name":"Yuvrajsinh Dodiya","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":"Dharmaditya Gohil","batsman_id":"130497","runs":"0","balls":"2","how_out":"c Y Dodiya b CS Jani","score_at_dismissal":117,"overs_at_dismissal":"18.5","bowler_id":"53998","dismissal":"caught","number":10},"extra_runs":{"byes":0,"legbyes":0,"wides":1,"noballs":0,"penalty":"0","total":1},"equations":{"runs":117,"wickets":10,"overs":"18.5","bowlers_used":6,"runrate":"6.21"},"current_partnership":{"runs":5,"balls":5,"overs":0.5,"batsmen":[{"name":"Kartik Badhana","batsman_id":149623,"runs":5,"balls":3},{"name":"Dharmaditya Gohil","batsman_id":130497,"runs":0,"balls":2}]},"did_not_bat":[{"player_id":"90414","name":"Vandit Jivrajani"}],"max_over":"20","target":"134","recent_scores":"w,0,1,0,4,w,w,0,w,w,1,1,1,2,4,1,1,w","last_five_overs":"30\/7 6.00","last_ten_overs":"73\/8 7.30"},"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":"117\/10 (18.5 ov)","scores":"117\/10","overs":"18.5"},{"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":"133\/7 (20 ov)","scores":"133\/7","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.5,"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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","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":8.5,"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":8,"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.5,"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":8,"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":6,"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":8.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":"bowl","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":8.5,"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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","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.5,"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.5,"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":7,"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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"wk","role_str":"(WK)"},{"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":6.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":7.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":7.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":6,"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":7.5,"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":6,"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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","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":6.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":6,"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":"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":"India","role":"bowl","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":6.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":6,"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":6,"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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""}]},"etag":"8f595e43bfb640ca1d44d34276bb2acf","modified":"2025-07-04 21:21:13","datetime":"2025-07-04 21:21:13","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":90508,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Zalwad Strikers won by 16 runs","day_remaining_over":"","team_batting":"Dita Gohilwad Titans","team_bowling":"Zalwad Strikers","live_inning_number":2,"live_score":{"runs":117,"overs":18.5,"wickets":10,"target":134,"runrate":6.21,"required_runrate":14.57},"commentary":1,"wagon":2,"batsmen":[{"name":"Dharmaditya Gohil","batsman_id":130497,"runs":0,"balls_faced":2,"fours":0,"sixes":0,"strike_rate":"0.00"},{"name":"Kartik Badhana","batsman_id":149623,"runs":8,"balls_faced":6,"fours":1,"sixes":0,"strike_rate":"133.33"}],"bowlers":[{"name":"Chirag Jani","bowler_id":53998,"overs":3.5,"runs_conceded":25,"wickets":1,"maidens":0,"econ":"6.52"},{"name":"Ankur Panwar","bowler_id":116788,"overs":3,"runs_conceded":20,"wickets":5,"maidens":0,"econ":"6.67"}],"commentaries":[{"event_id":"12108442","event":"ball","batsman_id":"133033","bowler_id":"145165","over":"14","ball":"3","score":1,"commentary":"Smit Patel to Samar Gajjar, 1 run,","noball_dismissal":false,"text":"","timestamp":1749488504,"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":"12108443","event":"ball","batsman_id":"130495","bowler_id":"145165","over":"14","ball":"4","score":1,"commentary":"Smit Patel to Luckyraj Vaghela, 1 run,","noball_dismissal":false,"text":"","timestamp":1749488506,"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":"12108445","event":"ball","batsman_id":"133033","bowler_id":"145165","over":"14","ball":"5","score":1,"commentary":"Smit Patel to Samar Gajjar, 1 run,","noball_dismissal":false,"text":"","timestamp":1749488508,"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":"12108446","event":"ball","batsman_id":"130495","bowler_id":"145165","over":"14","ball":"6","score":1,"commentary":"Smit Patel to Luckyraj Vaghela, 1 run,","noball_dismissal":false,"text":"","timestamp":1749488511,"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":5,"score":"93\/4","bats":[{"runs":3,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":130495},{"runs":4,"balls_faced":7,"fours":0,"sixes":0,"batsman_id":133033}],"bowls":[{"runs_conceded":15,"maidens":0,"wickets":2,"bowler_id":145165,"overs":4},{"runs_conceded":8,"maidens":0,"wickets":0,"bowler_id":122333,"overs":1}],"commentary":"End of over 15 (5 runs), Dita Gohilwad Titans 93\/4"},{"event_id":"12108456","event":"ball","batsman_id":"130495","bowler_id":"149601","over":"15","ball":"1","score":0,"commentary":"Dev Dey to Luckyraj Vaghela, no run,","noball_dismissal":false,"text":"","timestamp":1749488515,"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":"12108457","event":"ball","batsman_id":"130495","bowler_id":"149601","over":"15","ball":"2","score":1,"commentary":"Dev Dey to Luckyraj Vaghela, 1 run,","noball_dismissal":false,"text":"","timestamp":1749488518,"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":"12108465","event":"ball","batsman_id":"133033","bowler_id":"149601","over":"15","ball":"3","score":4,"commentary":"Dev Dey to Samar Gajjar, Four,","noball_dismissal":false,"text":"","timestamp":1749488554,"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":"12108469","event":"ball","batsman_id":"133033","bowler_id":"149601","over":"15","ball":"4","score":1,"commentary":"Dev Dey to Samar Gajjar, 1 run,","noball_dismissal":false,"text":"","timestamp":1749488596,"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":"12108470","event":"ball","batsman_id":"130495","bowler_id":"149601","over":"15","ball":"5","score":2,"commentary":"Dev Dey to Luckyraj Vaghela, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749488600,"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":"12108474","event":"wicket","batsman_id":"130495","bowler_id":"149601","over":"15","ball":"6","score":"w","commentary":"Dev Dey to Luckyraj Vaghela, no run, c A Ranjan b D Dey,","noball_dismissal":false,"text":"","timestamp":1749488751,"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":"130495","how_out":"c A Ranjan b D Dey","batsman_runs":"6","batsman_balls":"7"},{"event":"overend","over":16,"runs":8,"score":"101\/5","bats":[{"runs":6,"balls_faced":7,"fours":0,"sixes":0,"batsman_id":130495},{"runs":9,"balls_faced":9,"fours":1,"sixes":0,"batsman_id":133033}],"bowls":[{"runs_conceded":24,"maidens":0,"wickets":2,"bowler_id":149601,"overs":4},{"runs_conceded":15,"maidens":0,"wickets":2,"bowler_id":145165,"overs":4}],"commentary":"End of over 16 (8 runs), Dita Gohilwad Titans 101\/5"},{"event_id":"12108494","event":"ball","batsman_id":"133033","bowler_id":"53998","over":"16","ball":"1","score":1,"commentary":"Chirag Jani to Samar Gajjar, 1 run,","noball_dismissal":false,"text":"","timestamp":1749488848,"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":"12108495","event":"ball","batsman_id":"149623","bowler_id":"53998","over":"16","ball":"2","score":1,"commentary":"Chirag Jani to Kartik Badhana, 1 run,","noball_dismissal":false,"text":"","timestamp":1749488851,"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":"12108497","event":"ball","batsman_id":"133033","bowler_id":"53998","over":"16","ball":"3","score":4,"commentary":"Chirag Jani to Samar Gajjar, Four,","noball_dismissal":false,"text":"","timestamp":1749488854,"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":"12108505","event":"ball","batsman_id":"133033","bowler_id":"53998","over":"16","ball":"4","score":2,"commentary":"Chirag Jani to Samar Gajjar, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749488954,"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":"12108506","event":"ball","batsman_id":"133033","bowler_id":"53998","over":"16","ball":"5","score":1,"commentary":"Chirag Jani to Samar Gajjar, 1 run,","noball_dismissal":false,"text":"","timestamp":1749488958,"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":"12108512","event":"ball","batsman_id":"149623","bowler_id":"53998","over":"16","ball":"6","score":1,"commentary":"Chirag Jani to Kartik Badhana, 1 run,","noball_dismissal":false,"text":"","timestamp":1749489001,"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":10,"score":"111\/5","bats":[{"runs":2,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":149623},{"runs":17,"balls_faced":13,"fours":2,"sixes":0,"batsman_id":133033}],"bowls":[{"runs_conceded":20,"maidens":0,"wickets":0,"bowler_id":53998,"overs":3},{"runs_conceded":24,"maidens":0,"wickets":2,"bowler_id":149601,"overs":4}],"commentary":"End of over 17 (10 runs), Dita Gohilwad Titans 111\/5"},{"event_id":"12108521","event":"ball","batsman_id":"149623","bowler_id":"116788","over":"17","ball":"1","score":1,"commentary":"Ankur Panwar to Kartik Badhana, 1 run,","noball_dismissal":false,"text":"","timestamp":1749489074,"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":"12108527","event":"wicket","batsman_id":"133033","bowler_id":"116788","over":"17","ball":"2","score":"w","commentary":"Ankur Panwar to Samar Gajjar, no run, c AG Gosai b A Panwar,","noball_dismissal":false,"text":"","timestamp":1749489169,"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":"133033","how_out":"c AG Gosai b A Panwar","batsman_runs":"17","batsman_balls":"14"},{"event_id":"12108541","event":"wicket","batsman_id":"149625","bowler_id":"116788","over":"17","ball":"3","score":"w","commentary":"Ankur Panwar to Kwinsh Padaliya, no run, c N Vaghela b A Panwar,","noball_dismissal":false,"text":"","timestamp":1749489264,"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":"149625","how_out":"c N Vaghela b A Panwar","batsman_runs":"0","batsman_balls":"1"},{"event_id":"12108550","event":"ball","batsman_id":"116934","bowler_id":"116788","over":"17","ball":"4","score":0,"commentary":"Ankur Panwar to Aditya Rathore, no run,","noball_dismissal":false,"text":"","timestamp":1749489358,"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":"12108555","event":"wicket","batsman_id":"116934","bowler_id":"116788","over":"17","ball":"5","score":"w","commentary":"Ankur Panwar to Aditya Rathore, no run, c S Patel b A Panwar,","noball_dismissal":false,"text":"","timestamp":1749489435,"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":"116934","how_out":"c S Patel b A Panwar","batsman_runs":"0","batsman_balls":"2"},{"event_id":"12108572","event":"wicket","batsman_id":"120390","bowler_id":"116788","over":"17","ball":"6","score":"w","commentary":"Ankur Panwar to Hiten Kanbi, no run, b A Panwar,","noball_dismissal":false,"text":"","timestamp":1749489517,"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":"120390","how_out":"b A Panwar","batsman_runs":"0","batsman_balls":"1"},{"event":"overend","over":18,"runs":1,"score":"112\/9","bats":[{"runs":0,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":120390},{"runs":3,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":149623}],"bowls":[{"runs_conceded":20,"maidens":0,"wickets":5,"bowler_id":116788,"overs":3},{"runs_conceded":20,"maidens":0,"wickets":0,"bowler_id":53998,"overs":3}],"commentary":"End of over 18 (1 runs), Dita Gohilwad Titans 112\/9"},{"event_id":"12108588","event":"ball","batsman_id":"149623","bowler_id":"53998","over":"18","ball":"1","score":4,"commentary":"Chirag Jani to Kartik Badhana, Four,","noball_dismissal":false,"text":"","timestamp":1749489713,"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":"12108589","event":"ball","batsman_id":"149623","bowler_id":"53998","over":"18","ball":"2","score":0,"commentary":"Chirag Jani to Kartik Badhana, no run,","noball_dismissal":false,"text":"","timestamp":1749489716,"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":"12108593","event":"ball","batsman_id":"149623","bowler_id":"53998","over":"18","ball":"3","score":1,"commentary":"Chirag Jani to Kartik Badhana, 1 run,","noball_dismissal":false,"text":"","timestamp":1749489741,"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":"12108599","event":"ball","batsman_id":"130497","bowler_id":"53998","over":"18","ball":"4","score":0,"commentary":"Chirag Jani to Dharmaditya Gohil, no run,","noball_dismissal":false,"text":"","timestamp":1749489892,"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":"12108600","event":"wicket","batsman_id":"130497","bowler_id":"53998","over":"18","ball":"5","score":"w","commentary":"Chirag Jani to Dharmaditya Gohil, no run, c Y Dodiya b CS Jani,","noball_dismissal":false,"text":"","timestamp":1749489981,"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":"130497","how_out":"c Y Dodiya b CS Jani","batsman_runs":"0","batsman_balls":"2"}],"day":"0","session":"0","live_inning":{"iid":197735,"number":2,"name":"Dita Gohilwad Titans Inning","short_name":"DGT Inning","status":2,"issuperover":"false","result":1,"batting_team_id":113048,"fielding_team_id":113052,"scores":"117\/10","scores_full":"117\/10 (18.5 ov)","fielder":[{"fielder_id":"95182","fielder_name":"Amit Ranjan","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"149599","fielder_name":"Harshvardhan Rana","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"},{"fielder_id":"116929","fielder_name":"Nihar Vaghela","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"145165","fielder_name":"Smit Patel","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"122333","fielder_name":"Yuvrajsinh Dodiya","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":"Dharmaditya Gohil","batsman_id":"130497","runs":"0","balls":"2","how_out":"c Y Dodiya b CS Jani","score_at_dismissal":117,"overs_at_dismissal":"18.5","bowler_id":"53998","dismissal":"caught","number":10},"extra_runs":{"byes":0,"legbyes":0,"wides":1,"noballs":0,"penalty":"0","total":1},"equations":{"runs":117,"wickets":10,"overs":"18.5","bowlers_used":6,"runrate":"6.21"},"current_partnership":{"runs":5,"balls":5,"overs":0.5,"batsmen":[{"name":"Kartik Badhana","batsman_id":149623,"runs":5,"balls":3},{"name":"Dharmaditya Gohil","batsman_id":130497,"runs":0,"balls":2}]},"did_not_bat":[{"player_id":"90414","name":"Vandit Jivrajani"}],"max_over":"20","target":"134","recent_scores":"w,0,1,0,4,w,w,0,w,w,1,1,1,2,4,1,1,w","last_five_overs":"30\/7 6.00","last_ten_overs":"73\/8 7.30"},"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":"117\/10 (18.5 ov)","scores":"117\/10","overs":"18.5"},{"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":"133\/7 (20 ov)","scores":"133\/7","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.5,"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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","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":8.5,"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":8,"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.5,"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":8,"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":6,"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":8.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":"bowl","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":8.5,"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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","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.5,"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.5,"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":7,"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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"wk","role_str":"(WK)"},{"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":6.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":7.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":7.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":6,"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":7.5,"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":6,"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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","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":6.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":6,"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":"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":"India","role":"bowl","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":6.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":6,"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":6,"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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""}]},"etag":"8f595e43bfb640ca1d44d34276bb2acf","modified":"2025-07-04 21:21:13","datetime":"2025-07-04 21:21:13","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90508 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:8724da77-db48-4db6-b5fe-523755734b1b Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90508 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90508,3,'{"status":"ok","response":{"match_id":90508,"title":"Zalawad Strikers vs Dita Gohilwad Titans","short_title":"ZWS vs DGT","subtitle":"Match 5","match_number":"5","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Zalwad Strikers won by 16 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":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":"133\/7 (20 ov)","scores":"133\/7","overs":"20"},"teamb":{"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":"117\/10 (18.5 ov)","scores":"117\/10","overs":"18.5"},"date_start":"2025-06-09 14:00:00","date_end":"2025-06-10 00:00:00","timestamp_start":1749477600,"timestamp_end":1749513600,"date_start_ist":"2025-06-09 19:30:00","date_end_ist":"2025-06-10 05:30:00","venue":{"venue_id":"21","name":"Niranjan Shah Stadium, Khandheri","location":"Rajkot","country":"India","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"ZWS won by 16 runs","result_type":1,"win_margin":"16 runs","winning_team_id":113052,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-08 19:48:58","verify_time":"2025-06-09 23:14:57","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clear","weather_desc":"clear sky","temp":30.35,"humidity":58,"visibility":10000,"wind_speed":"15.46","clouds":0},"pitch":{"pitch_condition":"Spinning Pitch","batting_condition":"Average","pace_bowling_condition":"Swing Favourable","spine_bowling_condition":"Average"},"toss":{"text":"Zalwad Strikers elected to bat","winner":113052,"decision":1}},"etag":"b413257c2dfefdb8301df605149fd4b3","modified":"2025-07-04 21:21:14","datetime":"2025-07-04 21:21:14","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90508,"title":"Zalawad Strikers vs Dita Gohilwad Titans","short_title":"ZWS vs DGT","subtitle":"Match 5","match_number":"5","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Zalwad Strikers won by 16 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":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":"133\/7 (20 ov)","scores":"133\/7","overs":"20"},"teamb":{"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":"117\/10 (18.5 ov)","scores":"117\/10","overs":"18.5"},"date_start":"2025-06-09 14:00:00","date_end":"2025-06-10 00:00:00","timestamp_start":1749477600,"timestamp_end":1749513600,"date_start_ist":"2025-06-09 19:30:00","date_end_ist":"2025-06-10 05:30:00","venue":{"venue_id":"21","name":"Niranjan Shah Stadium, Khandheri","location":"Rajkot","country":"India","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"ZWS won by 16 runs","result_type":1,"win_margin":"16 runs","winning_team_id":113052,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-08 19:48:58","verify_time":"2025-06-09 23:14:57","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clear","weather_desc":"clear sky","temp":30.35,"humidity":58,"visibility":10000,"wind_speed":"15.46","clouds":0},"pitch":{"pitch_condition":"Spinning Pitch","batting_condition":"Average","pace_bowling_condition":"Swing Favourable","spine_bowling_condition":"Average"},"toss":{"text":"Zalwad Strikers elected to bat","winner":113052,"decision":1}},"etag":"b413257c2dfefdb8301df605149fd4b3","modified":"2025-07-04 21:21:14","datetime":"2025-07-04 21:21:14","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90508 AND DataTypeId = 3 END
Live Report & Scorecard of Zalawad Strikers vs Dita Gohilwad Titans Match 5