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:6cd478c8-6a58-4baa-82ec-0b89fe9c21ad Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90668 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90668,1,'{"status":"ok","response":{"mid":90668,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Lexus won by superover","day_remaining_over":"","team_batting":"Lexus","team_bowling":"Thunder Cats","live_inning_number":4,"live_score":{"runs":4,"overs":0.4,"wickets":0,"target":4,"runrate":6,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Sunil Raja Henry","batsman_id":132021,"runs":2,"balls_faced":1,"fours":0,"sixes":0,"strike_rate":"200.00"},{"name":"Mahammad Ajizbhai Kadri","batsman_id":146938,"runs":1,"balls_faced":3,"fours":0,"sixes":0,"strike_rate":"33.33"}],"bowlers":[{"name":"Vishwa Teja","bowler_id":144356,"overs":0.4,"runs_conceded":4,"wickets":0,"maidens":0,"econ":"6.00"}],"commentaries":[{"event_id":"12138238","event":"ball","batsman_id":"146938","bowler_id":"144356","over":"0","ball":"1","score":0,"commentary":"Vishwa Teja to Mahammad Ajizbhai Kadri, no run,","noball_dismissal":false,"text":"","timestamp":1749853328,"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":"12138239","event":"ball","batsman_id":"146938","bowler_id":"144356","over":"0","ball":"2","score":"1wd","commentary":"Vishwa Teja to Mahammad Ajizbhai Kadri, 1 wide,","noball_dismissal":false,"text":"","timestamp":1749853350,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12138240","event":"ball","batsman_id":"146938","bowler_id":"144356","over":"0","ball":"2","score":0,"commentary":"Vishwa Teja to Mahammad Ajizbhai Kadri, no run,","noball_dismissal":false,"text":"","timestamp":1749853375,"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":"12138241","event":"ball","batsman_id":"146938","bowler_id":"144356","over":"0","ball":"3","score":1,"commentary":"Vishwa Teja to Mahammad Ajizbhai Kadri, 1 run,","noball_dismissal":false,"text":"","timestamp":1749853403,"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":"12138242","event":"ball","batsman_id":"132021","bowler_id":"144356","over":"0","ball":"4","score":2,"commentary":"Vishwa Teja to Sunil Raja Henry, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749853436,"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}],"day":"0","session":"0","live_inning":{"iid":198015,"number":4,"name":"Lexus Inning","short_name":"LEX Inning","status":2,"issuperover":"true","result":3,"batting_team_id":128060,"fielding_team_id":128850,"scores":"4\/0","scores_full":"4\/0 (0.4 ov)","fielder":[],"powerplay":[],"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":[],"extra_runs":{"byes":0,"legbyes":0,"wides":1,"noballs":0,"penalty":"0","total":1},"equations":{"runs":4,"wickets":0,"overs":"0.4","bowlers_used":1,"runrate":"6.00"},"current_partnership":{"runs":4,"balls":4,"overs":0.4,"batsmen":[{"name":"Mahammad Ajizbhai Kadri","batsman_id":146938,"runs":1,"balls":3},{"name":"Sunil Raja Henry","batsman_id":132021,"runs":2,"balls":1}]},"did_not_bat":[{"player_id":"132022","name":"Vinu Nair"},{"player_id":"132025","name":"Ansari Farhan Abdul Kadar"},{"player_id":"132023","name":"Julius Cyril"},{"player_id":"132028","name":"Ismail Hanif Banwa"},{"player_id":"120363","name":"Rijil Venugopal"},{"player_id":"132024","name":"Mohamed Shihab"},{"player_id":"135101","name":"Muhammad Usman"},{"player_id":"123673","name":"Sameer Thajudeen"},{"player_id":"132034","name":"Christopher Augustine Patteri"}],"max_over":"1","target":"4","recent_scores":"2,1,0,1,0","last_five_overs":"4\/0 4.80","last_ten_overs":"4\/0 4.80"},"teams":[{"tid":128060,"title":"Lexus","abbr":"LEX","alt_name":"Lexus","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/09\/Rectangle-3460-23.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/09\/Rectangle-3460-23.png","country":"kw","sex":"male","team_owner":"","head_coach":"","scores_full":"189\/4 (20 ov) & 4\/0 (0.4 ov)","scores":"189\/4 & 4\/0","overs":"20 & 0.4"},{"tid":128850,"title":"Thunder Cats","abbr":"THN","alt_name":"Thunder Cats","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/03\/Thunder-Cats.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/03\/Thunder-Cats.png","country":"kw","sex":"male","team_owner":"","head_coach":"","scores_full":"189\/4 (20 ov) & 3\/2 (0.3 ov)","scores":"189\/4 & 3\/2","overs":"20 & 0.3"}],"players":[{"pid":95952,"title":"Abdullah Zaheer","short_name":"A Zaheer","first_name":"Abdullah Zaheer","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","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":"Kuwait","role":"all","role_str":""},{"pid":120363,"title":"Rijil Venugopal","short_name":"R Venugopal","first_name":"Rijil Venugopal","last_name":"","middle_name":"","birthdate":"1988-05-25","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"all","role_str":""},{"pid":123673,"title":"Sameer Thajudeen","short_name":"S Thajudeen","first_name":"Sameer Thajudeen","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"bowl","role_str":""},{"pid":123972,"title":"Jude Saldanha","short_name":"J Saldanha","first_name":"Jude Saldanha","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"wk","role_str":"(WK\/C)"},{"pid":125324,"title":"Nouman Fakhar","short_name":"N Fakhar","first_name":"Nouman Fakhar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"squad","role_str":""},{"pid":126710,"title":"Melrick Serrao","short_name":"M Serrao","first_name":"Melrick Serrao","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"squad","role_str":""},{"pid":127614,"title":"Thinagaran Kathavarayan","short_name":"T Kathavarayan","first_name":"Thinagaran Kathavarayan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"squad","role_str":""},{"pid":127775,"title":"Arpeet Avinash","short_name":"A Avinash","first_name":"Arpeet Avinash","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"bat","role_str":""},{"pid":127776,"title":"Asmeet Avinash","short_name":"A Avinash","first_name":"Asmeet Avinash","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"bat","role_str":""},{"pid":127783,"title":"Shifas Karim","short_name":"S Karim","first_name":"Shifas Karim","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"squad","role_str":""},{"pid":130594,"title":"Sam Mathew","short_name":"S Mathew","first_name":"Sam Mathew","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","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":"Kuwait","role":"squad","role_str":""},{"pid":131516,"title":"Zurain Farhan Ansari","short_name":"ZF Ansari","first_name":"Zurain Farhan Ansari","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","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":"Kuwait","role":"bowl","role_str":""},{"pid":132021,"title":"Sunil Raja Henry","short_name":"SR Henry","first_name":"Sunil Raja Henry","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"bat","role_str":""},{"pid":132022,"title":"Vinu Nair","short_name":"V Nair","first_name":"Vinu Nair","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","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":"Kuwait","role":"wk","role_str":"(WK\/C)"},{"pid":132023,"title":"Julius Cyril","short_name":"J Cyril","first_name":"Julius Cyril","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","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":"Kuwait","role":"bat","role_str":""},{"pid":132024,"title":"Mohamed Shihab","short_name":"M Shihab","first_name":"Mohamed Shihab","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","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":"Kuwait","role":"all","role_str":""},{"pid":132025,"title":"Ansari Farhan Abdul Kadar","short_name":"AFA Kadar","first_name":"Ansari Farhan Abdul Kadar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"bat","role_str":""},{"pid":132027,"title":"Basavant Dalavi","short_name":"B Dalavi","first_name":"Basavant Dalavi","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","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":"Kuwait","role":"squad","role_str":""},{"pid":132028,"title":"Ismail Hanif Banwa","short_name":"IH Banwa","first_name":"Ismail Hanif Banwa","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","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":"Kuwait","role":"all","role_str":""},{"pid":132031,"title":"Hanees Babu Pallackan","short_name":"HB Pallackan","first_name":"Hanees Babu Pallackan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"squad","role_str":""},{"pid":132034,"title":"Christopher Augustine Patteri","short_name":"CA Patteri","first_name":"Christopher Augustine Patteri","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"bowl","role_str":""},{"pid":132036,"title":"Hentry Kennady","short_name":"H Kennady","first_name":"Hentry Kennady","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","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":"Kuwait","role":"squad","role_str":""},{"pid":133107,"title":"Kandarp Tushar","short_name":"K Tushar","first_name":"Kandarp Tushar","last_name":"","middle_name":"","birthdate":"2008-09-23","birthplace":"","country":"kw","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":"Kuwait","role":"squad","role_str":""},{"pid":133510,"title":"Asad Abdul Bandri","short_name":"AA Bandri","first_name":"Asad Abdul Bandri","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"squad","role_str":""},{"pid":135037,"title":"Shaies Ali Taher","short_name":"S Ali Taher","first_name":"Shaies Ali Taher","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"squad","role_str":""},{"pid":135039,"title":"Mohammed Usman Ghani","short_name":"M U Ghani","first_name":"Mohammed Usman Ghani","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"bat","role_str":""},{"pid":135040,"title":"Muhamed Risshan Alisha","short_name":"M R Alisha","first_name":"Muhamed Risshan Alisha","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"wk","role_str":""},{"pid":135042,"title":"Yug Hiteshkumar Patel","short_name":"Y H Patel","first_name":"Yug Hiteshkumar Patel","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"squad","role_str":""},{"pid":135101,"title":"Muhammad Usman","short_name":"M Usman","first_name":"Muhammad Usman","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"bowl","role_str":""},{"pid":139332,"title":"Zain Islam","short_name":"Z Islam","first_name":"Zain Islam","last_name":"","middle_name":"","birthdate":"1990-01-25","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"squad","role_str":""},{"pid":144356,"title":"Vishwa Teja","short_name":"V Teja","first_name":"Vishwa Teja","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"all","role_str":""},{"pid":146011,"title":"Shaizad Momin","short_name":"S Momin","first_name":"Shaizad Momin","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"squad","role_str":""},{"pid":146938,"title":"Mahammad Ajizbhai Kadri","short_name":"M Ajizbhai Kadri","first_name":"Mahammad Ajizbhai Kadri","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","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":"Kuwait","role":"bat","role_str":""},{"pid":147217,"title":"Ashish Guruveer Surabathula","short_name":"A Guruveer Surabathula","first_name":"Ashish Guruveer Surabathula","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"bowl","role_str":""},{"pid":147684,"title":"Gavin David Mendes","short_name":"GD Mendes","first_name":"Gavin David Mendes","last_name":"","middle_name":"","birthdate":"2011-02-11","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"all","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":"Kuwait","role":"squad","role_str":""},{"pid":147768,"title":"Shaikh Ayub Babulal","short_name":"S Ayub Babulal","first_name":"Shaikh Ayub Babulal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","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":"Kuwait","role":"squad","role_str":""},{"pid":147777,"title":"Rayan Aiden","short_name":"R Aiden","first_name":"Rayan Aiden","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"bat","role_str":""},{"pid":149777,"title":"Abdul Rashid Rehan","short_name":"A Rashid Rehan","first_name":"Abdul Rashid Rehan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","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":"Kuwait","role":"squad","role_str":""},{"pid":149805,"title":"Vihaan Jithesh","short_name":"V Jithesh","first_name":"Vihaan Jithesh","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","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":"Kuwait","role":"squad","role_str":""},{"pid":149806,"title":"Usman Iqbal","short_name":"U Iqbal","first_name":"Usman Iqbal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"squad","role_str":""},{"pid":149807,"title":"Shlok Kumar","short_name":"S Kumar","first_name":"Shlok Kumar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","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":"Kuwait","role":"all","role_str":""}]},"etag":"3c3382393257d699c3f5b77d24bb574f","modified":"2025-06-24 11:08:46","datetime":"2025-06-24 11:08:46","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":90668,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Lexus won by superover","day_remaining_over":"","team_batting":"Lexus","team_bowling":"Thunder Cats","live_inning_number":4,"live_score":{"runs":4,"overs":0.4,"wickets":0,"target":4,"runrate":6,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Sunil Raja Henry","batsman_id":132021,"runs":2,"balls_faced":1,"fours":0,"sixes":0,"strike_rate":"200.00"},{"name":"Mahammad Ajizbhai Kadri","batsman_id":146938,"runs":1,"balls_faced":3,"fours":0,"sixes":0,"strike_rate":"33.33"}],"bowlers":[{"name":"Vishwa Teja","bowler_id":144356,"overs":0.4,"runs_conceded":4,"wickets":0,"maidens":0,"econ":"6.00"}],"commentaries":[{"event_id":"12138238","event":"ball","batsman_id":"146938","bowler_id":"144356","over":"0","ball":"1","score":0,"commentary":"Vishwa Teja to Mahammad Ajizbhai Kadri, no run,","noball_dismissal":false,"text":"","timestamp":1749853328,"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":"12138239","event":"ball","batsman_id":"146938","bowler_id":"144356","over":"0","ball":"2","score":"1wd","commentary":"Vishwa Teja to Mahammad Ajizbhai Kadri, 1 wide,","noball_dismissal":false,"text":"","timestamp":1749853350,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12138240","event":"ball","batsman_id":"146938","bowler_id":"144356","over":"0","ball":"2","score":0,"commentary":"Vishwa Teja to Mahammad Ajizbhai Kadri, no run,","noball_dismissal":false,"text":"","timestamp":1749853375,"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":"12138241","event":"ball","batsman_id":"146938","bowler_id":"144356","over":"0","ball":"3","score":1,"commentary":"Vishwa Teja to Mahammad Ajizbhai Kadri, 1 run,","noball_dismissal":false,"text":"","timestamp":1749853403,"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":"12138242","event":"ball","batsman_id":"132021","bowler_id":"144356","over":"0","ball":"4","score":2,"commentary":"Vishwa Teja to Sunil Raja Henry, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749853436,"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}],"day":"0","session":"0","live_inning":{"iid":198015,"number":4,"name":"Lexus Inning","short_name":"LEX Inning","status":2,"issuperover":"true","result":3,"batting_team_id":128060,"fielding_team_id":128850,"scores":"4\/0","scores_full":"4\/0 (0.4 ov)","fielder":[],"powerplay":[],"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":[],"extra_runs":{"byes":0,"legbyes":0,"wides":1,"noballs":0,"penalty":"0","total":1},"equations":{"runs":4,"wickets":0,"overs":"0.4","bowlers_used":1,"runrate":"6.00"},"current_partnership":{"runs":4,"balls":4,"overs":0.4,"batsmen":[{"name":"Mahammad Ajizbhai Kadri","batsman_id":146938,"runs":1,"balls":3},{"name":"Sunil Raja Henry","batsman_id":132021,"runs":2,"balls":1}]},"did_not_bat":[{"player_id":"132022","name":"Vinu Nair"},{"player_id":"132025","name":"Ansari Farhan Abdul Kadar"},{"player_id":"132023","name":"Julius Cyril"},{"player_id":"132028","name":"Ismail Hanif Banwa"},{"player_id":"120363","name":"Rijil Venugopal"},{"player_id":"132024","name":"Mohamed Shihab"},{"player_id":"135101","name":"Muhammad Usman"},{"player_id":"123673","name":"Sameer Thajudeen"},{"player_id":"132034","name":"Christopher Augustine Patteri"}],"max_over":"1","target":"4","recent_scores":"2,1,0,1,0","last_five_overs":"4\/0 4.80","last_ten_overs":"4\/0 4.80"},"teams":[{"tid":128060,"title":"Lexus","abbr":"LEX","alt_name":"Lexus","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/09\/Rectangle-3460-23.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/09\/Rectangle-3460-23.png","country":"kw","sex":"male","team_owner":"","head_coach":"","scores_full":"189\/4 (20 ov) & 4\/0 (0.4 ov)","scores":"189\/4 & 4\/0","overs":"20 & 0.4"},{"tid":128850,"title":"Thunder Cats","abbr":"THN","alt_name":"Thunder Cats","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/03\/Thunder-Cats.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/03\/Thunder-Cats.png","country":"kw","sex":"male","team_owner":"","head_coach":"","scores_full":"189\/4 (20 ov) & 3\/2 (0.3 ov)","scores":"189\/4 & 3\/2","overs":"20 & 0.3"}],"players":[{"pid":95952,"title":"Abdullah Zaheer","short_name":"A Zaheer","first_name":"Abdullah Zaheer","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","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":"Kuwait","role":"all","role_str":""},{"pid":120363,"title":"Rijil Venugopal","short_name":"R Venugopal","first_name":"Rijil Venugopal","last_name":"","middle_name":"","birthdate":"1988-05-25","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"all","role_str":""},{"pid":123673,"title":"Sameer Thajudeen","short_name":"S Thajudeen","first_name":"Sameer Thajudeen","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"bowl","role_str":""},{"pid":123972,"title":"Jude Saldanha","short_name":"J Saldanha","first_name":"Jude Saldanha","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"wk","role_str":"(WK\/C)"},{"pid":125324,"title":"Nouman Fakhar","short_name":"N Fakhar","first_name":"Nouman Fakhar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"squad","role_str":""},{"pid":126710,"title":"Melrick Serrao","short_name":"M Serrao","first_name":"Melrick Serrao","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"squad","role_str":""},{"pid":127614,"title":"Thinagaran Kathavarayan","short_name":"T Kathavarayan","first_name":"Thinagaran Kathavarayan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"squad","role_str":""},{"pid":127775,"title":"Arpeet Avinash","short_name":"A Avinash","first_name":"Arpeet Avinash","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"bat","role_str":""},{"pid":127776,"title":"Asmeet Avinash","short_name":"A Avinash","first_name":"Asmeet Avinash","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"bat","role_str":""},{"pid":127783,"title":"Shifas Karim","short_name":"S Karim","first_name":"Shifas Karim","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"squad","role_str":""},{"pid":130594,"title":"Sam Mathew","short_name":"S Mathew","first_name":"Sam Mathew","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","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":"Kuwait","role":"squad","role_str":""},{"pid":131516,"title":"Zurain Farhan Ansari","short_name":"ZF Ansari","first_name":"Zurain Farhan Ansari","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","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":"Kuwait","role":"bowl","role_str":""},{"pid":132021,"title":"Sunil Raja Henry","short_name":"SR Henry","first_name":"Sunil Raja Henry","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"bat","role_str":""},{"pid":132022,"title":"Vinu Nair","short_name":"V Nair","first_name":"Vinu Nair","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","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":"Kuwait","role":"wk","role_str":"(WK\/C)"},{"pid":132023,"title":"Julius Cyril","short_name":"J Cyril","first_name":"Julius Cyril","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","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":"Kuwait","role":"bat","role_str":""},{"pid":132024,"title":"Mohamed Shihab","short_name":"M Shihab","first_name":"Mohamed Shihab","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","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":"Kuwait","role":"all","role_str":""},{"pid":132025,"title":"Ansari Farhan Abdul Kadar","short_name":"AFA Kadar","first_name":"Ansari Farhan Abdul Kadar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"bat","role_str":""},{"pid":132027,"title":"Basavant Dalavi","short_name":"B Dalavi","first_name":"Basavant Dalavi","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","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":"Kuwait","role":"squad","role_str":""},{"pid":132028,"title":"Ismail Hanif Banwa","short_name":"IH Banwa","first_name":"Ismail Hanif Banwa","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","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":"Kuwait","role":"all","role_str":""},{"pid":132031,"title":"Hanees Babu Pallackan","short_name":"HB Pallackan","first_name":"Hanees Babu Pallackan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"squad","role_str":""},{"pid":132034,"title":"Christopher Augustine Patteri","short_name":"CA Patteri","first_name":"Christopher Augustine Patteri","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"bowl","role_str":""},{"pid":132036,"title":"Hentry Kennady","short_name":"H Kennady","first_name":"Hentry Kennady","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","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":"Kuwait","role":"squad","role_str":""},{"pid":133107,"title":"Kandarp Tushar","short_name":"K Tushar","first_name":"Kandarp Tushar","last_name":"","middle_name":"","birthdate":"2008-09-23","birthplace":"","country":"kw","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":"Kuwait","role":"squad","role_str":""},{"pid":133510,"title":"Asad Abdul Bandri","short_name":"AA Bandri","first_name":"Asad Abdul Bandri","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"squad","role_str":""},{"pid":135037,"title":"Shaies Ali Taher","short_name":"S Ali Taher","first_name":"Shaies Ali Taher","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"squad","role_str":""},{"pid":135039,"title":"Mohammed Usman Ghani","short_name":"M U Ghani","first_name":"Mohammed Usman Ghani","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"bat","role_str":""},{"pid":135040,"title":"Muhamed Risshan Alisha","short_name":"M R Alisha","first_name":"Muhamed Risshan Alisha","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"wk","role_str":""},{"pid":135042,"title":"Yug Hiteshkumar Patel","short_name":"Y H Patel","first_name":"Yug Hiteshkumar Patel","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"squad","role_str":""},{"pid":135101,"title":"Muhammad Usman","short_name":"M Usman","first_name":"Muhammad Usman","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"bowl","role_str":""},{"pid":139332,"title":"Zain Islam","short_name":"Z Islam","first_name":"Zain Islam","last_name":"","middle_name":"","birthdate":"1990-01-25","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"squad","role_str":""},{"pid":144356,"title":"Vishwa Teja","short_name":"V Teja","first_name":"Vishwa Teja","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"all","role_str":""},{"pid":146011,"title":"Shaizad Momin","short_name":"S Momin","first_name":"Shaizad Momin","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"squad","role_str":""},{"pid":146938,"title":"Mahammad Ajizbhai Kadri","short_name":"M Ajizbhai Kadri","first_name":"Mahammad Ajizbhai Kadri","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","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":"Kuwait","role":"bat","role_str":""},{"pid":147217,"title":"Ashish Guruveer Surabathula","short_name":"A Guruveer Surabathula","first_name":"Ashish Guruveer Surabathula","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"bowl","role_str":""},{"pid":147684,"title":"Gavin David Mendes","short_name":"GD Mendes","first_name":"Gavin David Mendes","last_name":"","middle_name":"","birthdate":"2011-02-11","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"all","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":"Kuwait","role":"squad","role_str":""},{"pid":147768,"title":"Shaikh Ayub Babulal","short_name":"S Ayub Babulal","first_name":"Shaikh Ayub Babulal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","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":"Kuwait","role":"squad","role_str":""},{"pid":147777,"title":"Rayan Aiden","short_name":"R Aiden","first_name":"Rayan Aiden","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"bat","role_str":""},{"pid":149777,"title":"Abdul Rashid Rehan","short_name":"A Rashid Rehan","first_name":"Abdul Rashid Rehan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","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":"Kuwait","role":"squad","role_str":""},{"pid":149805,"title":"Vihaan Jithesh","short_name":"V Jithesh","first_name":"Vihaan Jithesh","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","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":"Kuwait","role":"squad","role_str":""},{"pid":149806,"title":"Usman Iqbal","short_name":"U Iqbal","first_name":"Usman Iqbal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Kuwait","role":"squad","role_str":""},{"pid":149807,"title":"Shlok Kumar","short_name":"S Kumar","first_name":"Shlok Kumar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"kw","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":"Kuwait","role":"all","role_str":""}]},"etag":"3c3382393257d699c3f5b77d24bb574f","modified":"2025-06-24 11:08:46","datetime":"2025-06-24 11:08:46","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90668 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:6cd478c8-6a58-4baa-82ec-0b89fe9c21ad Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90668 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90668,3,'{"status":"ok","response":{"match_id":90668,"title":"Thunder Cats vs Lexus","short_title":"THN vs LEX","subtitle":"Match 2","match_number":"2","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Lexus won by superover","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129625,"title":"KCC T20 Challengers B League Edition 3","abbr":"KCC T20 CAL","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-06-13","dateend":"2025-07-04","country":"kw","total_matches":"4","total_rounds":"1","total_teams":"7"},"teama":{"team_id":128850,"name":"Thunder Cats","short_name":"THN","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/03\/Thunder-Cats.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/03\/Thunder-Cats.png","scores_full":"189\/4 (20 ov) & 3\/2 (0.3 ov)","scores":"189\/4 & 3\/2","overs":"20 & 0.3"},"teamb":{"team_id":128060,"name":"Lexus","short_name":"LEX","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/09\/Rectangle-3460-23.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/09\/Rectangle-3460-23.png","scores_full":"189\/4 (20 ov) & 4\/0 (0.4 ov)","scores":"189\/4 & 4\/0","overs":"20 & 0.4"},"date_start":"2025-06-13 19:00:00","date_end":"2025-06-14 05:00:00","timestamp_start":1749841200,"timestamp_end":1749877200,"date_start_ist":"2025-06-14 00:30:00","date_end_ist":"2025-06-14 10:30:00","venue":{"venue_id":"1213372","name":"Sulaibiya Cricket Ground","location":"Kuwait City","country":"Kuwait","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"LEX won by superover","result_type":2,"win_margin":"superover","winning_team_id":128060,"commentary":1,"wagon":2,"latest_inning_number":4,"presquad_time":"2025-06-11 22:24:24","verify_time":"2025-06-14 04:05:49","match_dls_affected":"false","live_inning_number":4,"day":"0","session":"0","weather":{"weather":"Clear","weather_desc":"clear sky","temp":34.45,"humidity":12,"visibility":10000,"wind_speed":"10.63","clouds":0},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Lexus elected to bat","winner":128060,"decision":1}},"etag":"59f968f56a7e6b9c0b1779a3fff55753","modified":"2025-06-24 11:08:47","datetime":"2025-06-24 11:08:47","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90668,"title":"Thunder Cats vs Lexus","short_title":"THN vs LEX","subtitle":"Match 2","match_number":"2","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Lexus won by superover","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129625,"title":"KCC T20 Challengers B League Edition 3","abbr":"KCC T20 CAL","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-06-13","dateend":"2025-07-04","country":"kw","total_matches":"4","total_rounds":"1","total_teams":"7"},"teama":{"team_id":128850,"name":"Thunder Cats","short_name":"THN","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/03\/Thunder-Cats.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/03\/Thunder-Cats.png","scores_full":"189\/4 (20 ov) & 3\/2 (0.3 ov)","scores":"189\/4 & 3\/2","overs":"20 & 0.3"},"teamb":{"team_id":128060,"name":"Lexus","short_name":"LEX","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/09\/Rectangle-3460-23.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/09\/Rectangle-3460-23.png","scores_full":"189\/4 (20 ov) & 4\/0 (0.4 ov)","scores":"189\/4 & 4\/0","overs":"20 & 0.4"},"date_start":"2025-06-13 19:00:00","date_end":"2025-06-14 05:00:00","timestamp_start":1749841200,"timestamp_end":1749877200,"date_start_ist":"2025-06-14 00:30:00","date_end_ist":"2025-06-14 10:30:00","venue":{"venue_id":"1213372","name":"Sulaibiya Cricket Ground","location":"Kuwait City","country":"Kuwait","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"LEX won by superover","result_type":2,"win_margin":"superover","winning_team_id":128060,"commentary":1,"wagon":2,"latest_inning_number":4,"presquad_time":"2025-06-11 22:24:24","verify_time":"2025-06-14 04:05:49","match_dls_affected":"false","live_inning_number":4,"day":"0","session":"0","weather":{"weather":"Clear","weather_desc":"clear sky","temp":34.45,"humidity":12,"visibility":10000,"wind_speed":"10.63","clouds":0},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Lexus elected to bat","winner":128060,"decision":1}},"etag":"59f968f56a7e6b9c0b1779a3fff55753","modified":"2025-06-24 11:08:47","datetime":"2025-06-24 11:08:47","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90668 AND DataTypeId = 3 END
Live Report & Scorecard of Thunder Cats vs Lexus Match 2