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:fbc0bab1-b2be-413e-b688-3a2752bb5507 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90774 AND DataTypeId = 2) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90774,2,'{"status":"ok","response":{"match_id":90774,"title":"Pakyong XI vs Black Eagle SAP","short_title":"PAk vs BES","subtitle":"Match 9","match_number":"9","format":6,"format_str":"T20","status":4,"status_str":"Cancelled","status_note":"Match abandoned","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129635,"title":"Sikkim T20 League","abbr":"Sikkim T20 League","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-06-15","dateend":"2025-07-01","country":"in","total_matches":"33","total_rounds":"1","total_teams":"8"},"teama":{"team_id":128290,"name":"Pakyong XI","short_name":"PAk","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/02\/Rectangle-3461-2024-02-17T145638.146.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/02\/Rectangle-3461-2024-02-17T145638.146.png","scores_full":""},"teamb":{"team_id":128286,"name":"Black Eagle SAP","short_name":"BES","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/02\/Rectangle-3461-2024-02-17T150818.842.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/02\/Rectangle-3461-2024-02-17T150818.842.png","scores_full":""},"date_start":"2025-06-19 03:00:00","date_end":"2025-06-19 13:00:00","timestamp_start":1750302000,"timestamp_end":1750338000,"date_start_ist":"2025-06-19 08:30:00","date_end_ist":"2025-06-19 18:30:00","venue":{"venue_id":"1213441","name":"SICA ground","location":"Rangpo","country":"India","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"","result_type":4,"win_margin":"","winning_team_id":0,"commentary":1,"wagon":2,"latest_inning_number":null,"presquad_time":"2025-06-17 12:16:17","verify_time":"2025-06-19 11:57:55","match_dls_affected":"false","live_inning_number":"","day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":23.34,"humidity":99,"visibility":4762,"wind_speed":"2.46","clouds":100},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Slow Spin"},"toss":{"text":"Pakyong XI elected to bowl","winner":128290,"decision":2},"current_over":"","previous_over":"","man_of_the_match":"","man_of_the_series":"","is_followon":0,"team_batting_first":"","team_batting_second":"","last_five_overs":"","innings":[],"players":[{"pid":90763,"title":"Anshuman Singh","short_name":"Anshuman Singh","first_name":"Anshuman Singh","last_name":"","middle_name":"","birthdate":"1999-09-28","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"wk","role_str":"(WK)"},{"pid":93662,"title":"Atharva Kale","short_name":"A Kale","first_name":"Atharva Kale","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":94034,"title":"Padam limboo","short_name":"PB limboo","first_name":"Padam limboo","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":94448,"title":"Tashi Bhalla","short_name":"T Bhalla","first_name":"Tashi Bhalla","last_name":"","middle_name":"","birthdate":"1984-06-30","birthplace":"","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":96433,"title":"Benoy Upreti","short_name":"B Upreti","first_name":"Benoy Upreti","last_name":"","middle_name":"","birthdate":"1986-09-01","birthplace":"","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":""},{"pid":97962,"title":"Yugdeep Saini","short_name":"Y Saini","first_name":"Yugdeep Saini","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":105024,"title":"Hem Chetri","short_name":"H Chetri","first_name":"Hem Chetri","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left 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":111009,"title":"Bhaskar Bharadwaj","short_name":"B Bharadwaj","first_name":"Bhaskar Bharadwaj","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":"(C)"},{"pid":111890,"title":"Akash Luitel","short_name":"A Luitel","first_name":"Akash Luitel","last_name":"","middle_name":"","birthdate":"1998-04-10","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left 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":113922,"title":"Kiran Regmi","short_name":"K Regmi","first_name":"Kiran Regmi","last_name":"","middle_name":"","birthdate":"1991-09-29","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":120866,"title":"Roshan Madhav","short_name":"R Madhav","first_name":"Roshan Madhav","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":133086,"title":"Pranesh Chettri","short_name":"P Chettri","first_name":"Pranesh Chettri","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":136330,"title":"Arnav Gupta","short_name":"A Gupta","first_name":"Arnav Gupta","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"wk","role_str":"(WK)"},{"pid":136335,"title":"Adiv Tamang","short_name":"A Tamang","first_name":"Adiv Tamang","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":136364,"title":"Avinash Rajak","short_name":"A Rajak","first_name":"Avinash Rajak","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"wk","role_str":""},{"pid":136375,"title":"Bishal Gurung","short_name":"B Gurung","first_name":"Bishal Gurung","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":136376,"title":"Avishek Regmi","short_name":"A Regmi","first_name":"Avishek Regmi","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":149833,"title":"Karan Kumar-Ganesh","short_name":"K Kumar-Ganesh","first_name":"Karan Kumar-Ganesh","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":149834,"title":"Rohan Agawne","short_name":"R Agawne","first_name":"Rohan Agawne","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":149835,"title":"Om Saini","short_name":"O Saini","first_name":"Om Saini","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":""},{"pid":149836,"title":"Sahil Chettri","short_name":"S Chettri","first_name":"Sahil Chettri","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":""},{"pid":149837,"title":"Parvin Kuikel","short_name":"P Kuikel","first_name":"Parvin Kuikel","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":149838,"title":"Subodh Kafley","short_name":"S Kafley","first_name":"Subodh Kafley","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":149839,"title":"Roshan Kumar","short_name":"R Kumar","first_name":"Roshan Kumar","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":149840,"title":"Arif Ansari","short_name":"A Ansari","first_name":"Arif Ansari","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":149863,"title":"Tanvir Alam","short_name":"T Alam","first_name":"Tanvir Alam","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"wk","role_str":""},{"pid":149864,"title":"Mandup Bhutia","short_name":"M Bhutia","first_name":"Mandup Bhutia","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":"(C)"},{"pid":149865,"title":"Sajal Thapa","short_name":"S Thapa","first_name":"Sajal Thapa","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":149866,"title":"Md Arif","short_name":"Md Arif","first_name":"Md Arif","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":149867,"title":"Sunil Kumar","short_name":"S Kumar","first_name":"Sunil Kumar","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":""},{"pid":149868,"title":"Purna Bahadur","short_name":"P Bahadur","first_name":"Purna Bahadur","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":""},{"pid":149869,"title":"Md Ronak","short_name":"Md Ronak","first_name":"Md Ronak","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":149870,"title":"Tusya Naman","short_name":"T Naman","first_name":"Tusya Naman","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":149871,"title":"Parichit Rai","short_name":"P Rai","first_name":"Parichit Rai","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":149872,"title":"Elisha Rai","short_name":"E Rai","first_name":"Elisha Rai","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":"squad","role_str":""},{"pid":149873,"title":"Prashant Chettri","short_name":"P Chettri","first_name":"Prashant Chettri","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":149982,"title":"Yowan Lepcha","short_name":"Y Lepcha","first_name":"Yowan Lepcha","last_name":"","middle_name":"","birthdate":"1987-03-02","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""}],"pre_match_odds":[],"day_remaining_over":"","match_notes":[]},"etag":"ea8c759f47e98737929304290834a085","modified":"2025-07-26 04:56:06","datetime":"2025-07-26 04:56:06","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90774,"title":"Pakyong XI vs Black Eagle SAP","short_title":"PAk vs BES","subtitle":"Match 9","match_number":"9","format":6,"format_str":"T20","status":4,"status_str":"Cancelled","status_note":"Match abandoned","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129635,"title":"Sikkim T20 League","abbr":"Sikkim T20 League","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-06-15","dateend":"2025-07-01","country":"in","total_matches":"33","total_rounds":"1","total_teams":"8"},"teama":{"team_id":128290,"name":"Pakyong XI","short_name":"PAk","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/02\/Rectangle-3461-2024-02-17T145638.146.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/02\/Rectangle-3461-2024-02-17T145638.146.png","scores_full":""},"teamb":{"team_id":128286,"name":"Black Eagle SAP","short_name":"BES","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/02\/Rectangle-3461-2024-02-17T150818.842.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/02\/Rectangle-3461-2024-02-17T150818.842.png","scores_full":""},"date_start":"2025-06-19 03:00:00","date_end":"2025-06-19 13:00:00","timestamp_start":1750302000,"timestamp_end":1750338000,"date_start_ist":"2025-06-19 08:30:00","date_end_ist":"2025-06-19 18:30:00","venue":{"venue_id":"1213441","name":"SICA ground","location":"Rangpo","country":"India","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"","result_type":4,"win_margin":"","winning_team_id":0,"commentary":1,"wagon":2,"latest_inning_number":null,"presquad_time":"2025-06-17 12:16:17","verify_time":"2025-06-19 11:57:55","match_dls_affected":"false","live_inning_number":"","day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":23.34,"humidity":99,"visibility":4762,"wind_speed":"2.46","clouds":100},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Slow Spin"},"toss":{"text":"Pakyong XI elected to bowl","winner":128290,"decision":2},"current_over":"","previous_over":"","man_of_the_match":"","man_of_the_series":"","is_followon":0,"team_batting_first":"","team_batting_second":"","last_five_overs":"","innings":[],"players":[{"pid":90763,"title":"Anshuman Singh","short_name":"Anshuman Singh","first_name":"Anshuman Singh","last_name":"","middle_name":"","birthdate":"1999-09-28","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"wk","role_str":"(WK)"},{"pid":93662,"title":"Atharva Kale","short_name":"A Kale","first_name":"Atharva Kale","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":94034,"title":"Padam limboo","short_name":"PB limboo","first_name":"Padam limboo","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":94448,"title":"Tashi Bhalla","short_name":"T Bhalla","first_name":"Tashi Bhalla","last_name":"","middle_name":"","birthdate":"1984-06-30","birthplace":"","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":96433,"title":"Benoy Upreti","short_name":"B Upreti","first_name":"Benoy Upreti","last_name":"","middle_name":"","birthdate":"1986-09-01","birthplace":"","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":""},{"pid":97962,"title":"Yugdeep Saini","short_name":"Y Saini","first_name":"Yugdeep Saini","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":105024,"title":"Hem Chetri","short_name":"H Chetri","first_name":"Hem Chetri","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left 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":111009,"title":"Bhaskar Bharadwaj","short_name":"B Bharadwaj","first_name":"Bhaskar Bharadwaj","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":"(C)"},{"pid":111890,"title":"Akash Luitel","short_name":"A Luitel","first_name":"Akash Luitel","last_name":"","middle_name":"","birthdate":"1998-04-10","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left 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":113922,"title":"Kiran Regmi","short_name":"K Regmi","first_name":"Kiran Regmi","last_name":"","middle_name":"","birthdate":"1991-09-29","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":120866,"title":"Roshan Madhav","short_name":"R Madhav","first_name":"Roshan Madhav","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":133086,"title":"Pranesh Chettri","short_name":"P Chettri","first_name":"Pranesh Chettri","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":136330,"title":"Arnav Gupta","short_name":"A Gupta","first_name":"Arnav Gupta","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"wk","role_str":"(WK)"},{"pid":136335,"title":"Adiv Tamang","short_name":"A Tamang","first_name":"Adiv Tamang","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":136364,"title":"Avinash Rajak","short_name":"A Rajak","first_name":"Avinash Rajak","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"wk","role_str":""},{"pid":136375,"title":"Bishal Gurung","short_name":"B Gurung","first_name":"Bishal Gurung","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":136376,"title":"Avishek Regmi","short_name":"A Regmi","first_name":"Avishek Regmi","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":149833,"title":"Karan Kumar-Ganesh","short_name":"K Kumar-Ganesh","first_name":"Karan Kumar-Ganesh","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":149834,"title":"Rohan Agawne","short_name":"R Agawne","first_name":"Rohan Agawne","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":149835,"title":"Om Saini","short_name":"O Saini","first_name":"Om Saini","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":""},{"pid":149836,"title":"Sahil Chettri","short_name":"S Chettri","first_name":"Sahil Chettri","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":""},{"pid":149837,"title":"Parvin Kuikel","short_name":"P Kuikel","first_name":"Parvin Kuikel","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":149838,"title":"Subodh Kafley","short_name":"S Kafley","first_name":"Subodh Kafley","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":149839,"title":"Roshan Kumar","short_name":"R Kumar","first_name":"Roshan Kumar","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":149840,"title":"Arif Ansari","short_name":"A Ansari","first_name":"Arif Ansari","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":149863,"title":"Tanvir Alam","short_name":"T Alam","first_name":"Tanvir Alam","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"wk","role_str":""},{"pid":149864,"title":"Mandup Bhutia","short_name":"M Bhutia","first_name":"Mandup Bhutia","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":"(C)"},{"pid":149865,"title":"Sajal Thapa","short_name":"S Thapa","first_name":"Sajal Thapa","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":149866,"title":"Md Arif","short_name":"Md Arif","first_name":"Md Arif","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":149867,"title":"Sunil Kumar","short_name":"S Kumar","first_name":"Sunil Kumar","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":""},{"pid":149868,"title":"Purna Bahadur","short_name":"P Bahadur","first_name":"Purna Bahadur","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":""},{"pid":149869,"title":"Md Ronak","short_name":"Md Ronak","first_name":"Md Ronak","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":149870,"title":"Tusya Naman","short_name":"T Naman","first_name":"Tusya Naman","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":149871,"title":"Parichit Rai","short_name":"P Rai","first_name":"Parichit Rai","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":149872,"title":"Elisha Rai","short_name":"E Rai","first_name":"Elisha Rai","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":"squad","role_str":""},{"pid":149873,"title":"Prashant Chettri","short_name":"P Chettri","first_name":"Prashant Chettri","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":149982,"title":"Yowan Lepcha","short_name":"Y Lepcha","first_name":"Yowan Lepcha","last_name":"","middle_name":"","birthdate":"1987-03-02","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""}],"pre_match_odds":[],"day_remaining_over":"","match_notes":[]},"etag":"ea8c759f47e98737929304290834a085","modified":"2025-07-26 04:56:06","datetime":"2025-07-26 04:56:06","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90774 AND DataTypeId = 2 END
Scorecard of Pakyong XI vs Black Eagle SAP Match 9 2025