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:84fc3a07-2713-41d9-abad-7743112d1f7e Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90281 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90281,1,'{"status":"ok","response":{"mid":90281,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Portugal won by 8 wickets","day_remaining_over":"","team_batting":"Portugal","team_bowling":"Malta","live_inning_number":2,"live_score":{"runs":121,"overs":14.1,"wickets":2,"target":121,"runrate":8.54,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Sharn Gomes","batsman_id":59325,"runs":67,"balls_faced":41,"fours":5,"sixes":2,"strike_rate":"163.41"},{"name":"Natim Hassam","batsman_id":146507,"runs":21,"balls_faced":23,"fours":2,"sixes":0,"strike_rate":"91.30"}],"bowlers":[{"name":"Priyan Pushparajan","bowler_id":123727,"overs":2.1,"runs_conceded":10,"wickets":0,"maidens":0,"econ":"4.62"},{"name":"Varun Prasath","bowler_id":123746,"overs":4,"runs_conceded":34,"wickets":0,"maidens":0,"econ":"8.50"}],"commentaries":[{"event_id":"12045608","event":"ball","batsman_id":"146507","bowler_id":"123746","over":"9","ball":"6","score":1,"commentary":"Varun Prasath to Natim Hassam, 1 run,","noball_dismissal":false,"text":"","timestamp":1748614516,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":10,"runs":5,"score":"92\/2","bats":[{"runs":8,"balls_faced":7,"fours":1,"sixes":0,"batsman_id":146507},{"runs":51,"balls_faced":32,"fours":3,"sixes":2,"batsman_id":59325}],"bowls":[{"runs_conceded":15,"maidens":0,"wickets":0,"bowler_id":123746,"overs":2},{"runs_conceded":19,"maidens":0,"wickets":1,"bowler_id":105570,"overs":2}],"commentary":"End of over 10 (5 runs), Portugal 92\/2"},{"event_id":"12045655","event":"ball","batsman_id":"146507","bowler_id":"123727","over":"10","ball":"1","score":0,"commentary":"Priyan Pushparajan to Natim Hassam, no run,","noball_dismissal":false,"text":"","timestamp":1748614728,"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":"12045656","event":"ball","batsman_id":"146507","bowler_id":"123727","over":"10","ball":"2","score":2,"commentary":"Priyan Pushparajan to Natim Hassam, 2 runs,","noball_dismissal":false,"text":"","timestamp":1748614731,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12045658","event":"ball","batsman_id":"146507","bowler_id":"123727","over":"10","ball":"3","score":0,"commentary":"Priyan Pushparajan to Natim Hassam, no run,","noball_dismissal":false,"text":"","timestamp":1748614734,"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":"12045662","event":"ball","batsman_id":"146507","bowler_id":"123727","over":"10","ball":"4","score":1,"commentary":"Priyan Pushparajan to Natim Hassam, 1 run,","noball_dismissal":false,"text":"","timestamp":1748614750,"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":"12045679","event":"ball","batsman_id":"59325","bowler_id":"123727","over":"10","ball":"5","score":4,"commentary":"Priyan Pushparajan to Sharn Gomes, Four,","noball_dismissal":false,"text":"","timestamp":1748614828,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12045681","event":"ball","batsman_id":"59325","bowler_id":"123727","over":"10","ball":"6","score":0,"commentary":"Priyan Pushparajan to Sharn Gomes, no run,","noball_dismissal":false,"text":"","timestamp":1748614831,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":11,"runs":7,"score":"99\/2","bats":[{"runs":55,"balls_faced":34,"fours":4,"sixes":2,"batsman_id":59325},{"runs":11,"balls_faced":11,"fours":1,"sixes":0,"batsman_id":146507}],"bowls":[{"runs_conceded":7,"maidens":0,"wickets":0,"bowler_id":123727,"overs":1},{"runs_conceded":15,"maidens":0,"wickets":0,"bowler_id":123746,"overs":2}],"commentary":"End of over 11 (7 runs), Portugal 99\/2"},{"event_id":"12045698","event":"ball","batsman_id":"146507","bowler_id":"123746","over":"11","ball":"1","score":1,"commentary":"Varun Prasath to Natim Hassam, 1 run,","noball_dismissal":false,"text":"","timestamp":1748614916,"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":"12045706","event":"ball","batsman_id":"59325","bowler_id":"123746","over":"11","ball":"2","score":1,"commentary":"Varun Prasath to Sharn Gomes, 1 run,","noball_dismissal":false,"text":"","timestamp":1748614943,"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":"12045708","event":"ball","batsman_id":"146507","bowler_id":"123746","over":"11","ball":"3","score":1,"commentary":"Varun Prasath to Natim Hassam, 1 run,","noball_dismissal":false,"text":"","timestamp":1748614945,"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":"12045716","event":"ball","batsman_id":"59325","bowler_id":"123746","over":"11","ball":"4","score":2,"commentary":"Varun Prasath to Sharn Gomes, 2 runs,","noball_dismissal":false,"text":"","timestamp":1748614996,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12045720","event":"ball","batsman_id":"59325","bowler_id":"123746","over":"11","ball":"5","score":1,"commentary":"Varun Prasath to Sharn Gomes, 1 run,","noball_dismissal":false,"text":"","timestamp":1748615007,"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":"12045729","event":"ball","batsman_id":"146507","bowler_id":"123746","over":"11","ball":"6","score":1,"commentary":"Varun Prasath to Natim Hassam, 1 run,","noball_dismissal":false,"text":"","timestamp":1748615034,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":12,"runs":7,"score":"106\/2","bats":[{"runs":14,"balls_faced":14,"fours":1,"sixes":0,"batsman_id":146507},{"runs":59,"balls_faced":37,"fours":4,"sixes":2,"batsman_id":59325}],"bowls":[{"runs_conceded":22,"maidens":0,"wickets":0,"bowler_id":123746,"overs":3},{"runs_conceded":7,"maidens":0,"wickets":0,"bowler_id":123727,"overs":1}],"commentary":"End of over 12 (7 runs), Portugal 106\/2"},{"event_id":"12045738","event":"ball","batsman_id":"146507","bowler_id":"123727","over":"12","ball":"1","score":0,"commentary":"Priyan Pushparajan to Natim Hassam, no run,","noball_dismissal":false,"text":"","timestamp":1748615090,"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":"12045747","event":"ball","batsman_id":"146507","bowler_id":"123727","over":"12","ball":"2","score":0,"commentary":"Priyan Pushparajan to Natim Hassam, no run,","noball_dismissal":false,"text":"","timestamp":1748615130,"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":"12045752","event":"ball","batsman_id":"146507","bowler_id":"123727","over":"12","ball":"3","score":0,"commentary":"Priyan Pushparajan to Natim Hassam, no run,","noball_dismissal":false,"text":"","timestamp":1748615133,"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":"12045757","event":"ball","batsman_id":"146507","bowler_id":"123727","over":"12","ball":"4","score":1,"commentary":"Priyan Pushparajan to Natim Hassam, 1 run,","noball_dismissal":false,"text":"","timestamp":1748615172,"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":"12045762","event":"ball","batsman_id":"59325","bowler_id":"123727","over":"12","ball":"5","score":1,"commentary":"Priyan Pushparajan to Sharn Gomes, 1 run,","noball_dismissal":false,"text":"","timestamp":1748615204,"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":"12045778","event":"ball","batsman_id":"146507","bowler_id":"123727","over":"12","ball":"6","score":0,"commentary":"Priyan Pushparajan to Natim Hassam, no run,","noball_dismissal":false,"text":"","timestamp":1748615274,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":13,"runs":2,"score":"108\/2","bats":[{"runs":15,"balls_faced":19,"fours":1,"sixes":0,"batsman_id":146507},{"runs":60,"balls_faced":38,"fours":4,"sixes":2,"batsman_id":59325}],"bowls":[{"runs_conceded":9,"maidens":0,"wickets":0,"bowler_id":123727,"overs":2},{"runs_conceded":22,"maidens":0,"wickets":0,"bowler_id":123746,"overs":3}],"commentary":"End of over 13 (2 runs), Portugal 108\/2"},{"event_id":"12045787","event":"ball","batsman_id":"59325","bowler_id":"123746","over":"13","ball":"1","score":1,"commentary":"Varun Prasath to Sharn Gomes, 1 run,","noball_dismissal":false,"text":"","timestamp":1748615317,"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":"12045790","event":"ball","batsman_id":"146507","bowler_id":"123746","over":"13","ball":"2","score":4,"commentary":"Varun Prasath to Natim Hassam, Four,","noball_dismissal":false,"text":"","timestamp":1748615321,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12045793","event":"ball","batsman_id":"146507","bowler_id":"123746","over":"13","ball":"3","score":0,"commentary":"Varun Prasath to Natim Hassam, no run,","noball_dismissal":false,"text":"","timestamp":1748615341,"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":"12045795","event":"ball","batsman_id":"146507","bowler_id":"123746","over":"13","ball":"4","score":1,"commentary":"Varun Prasath to Natim Hassam, 1 run,","noball_dismissal":false,"text":"","timestamp":1748615346,"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":"12045805","event":"ball","batsman_id":"59325","bowler_id":"123746","over":"13","ball":"5","score":4,"commentary":"Varun Prasath to Sharn Gomes, Four,","noball_dismissal":false,"text":"","timestamp":1748615400,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12045811","event":"ball","batsman_id":"59325","bowler_id":"123746","over":"13","ball":"6","score":2,"commentary":"Varun Prasath to Sharn Gomes, 2 runs,","noball_dismissal":false,"text":"","timestamp":1748615425,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":14,"runs":12,"score":"120\/2","bats":[{"runs":67,"balls_faced":41,"fours":5,"sixes":2,"batsman_id":59325},{"runs":20,"balls_faced":22,"fours":2,"sixes":0,"batsman_id":146507}],"bowls":[{"runs_conceded":34,"maidens":0,"wickets":0,"bowler_id":123746,"overs":4},{"runs_conceded":9,"maidens":0,"wickets":0,"bowler_id":123727,"overs":2}],"commentary":"End of over 14 (12 runs), Portugal 120\/2"},{"event_id":"12045822","event":"ball","batsman_id":"146507","bowler_id":"123727","over":"14","ball":"1","score":1,"commentary":"Priyan Pushparajan to Natim Hassam, 1 run,","noball_dismissal":false,"text":"","timestamp":1748615471,"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}],"day":"0","session":"0","live_inning":{"iid":197173,"number":2,"name":"Portugal Inning","short_name":"PORT Inning","status":2,"issuperover":"false","result":3,"batting_team_id":69725,"fielding_team_id":69724,"scores":"121\/2","scores_full":"121\/2 (14.1 ov)","fielder":[{"fielder_id":"108634","fielder_name":"Shrijay Patel","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Chad Potgieter","batsman_id":"149122","runs":"20","balls":"16","how_out":"c S Patel b J Singh","score_at_dismissal":61,"overs_at_dismissal":"6.4","bowler_id":"105570","dismissal":"caught","number":2},"extra_runs":{"byes":1,"legbyes":0,"wides":4,"noballs":0,"penalty":"0","total":5},"equations":{"runs":121,"wickets":2,"overs":"14.1","bowlers_used":5,"runrate":"8.54"},"current_partnership":{"runs":60,"balls":45,"overs":7.3,"batsmen":[{"name":"Natim Hassam","batsman_id":146507,"runs":21,"balls":23},{"name":"Sharn Gomes","batsman_id":59325,"runs":37,"balls":22}]},"did_not_bat":[{"player_id":"144221","name":"Carlos Nunes"},{"player_id":"147639","name":"Hardeep Singh Khuttan"},{"player_id":"146505","name":"Rahulkumar Hashu"},{"player_id":"103302","name":"Mohammad Siraj Nipo"},{"player_id":"147765","name":"Upen Shantu"},{"player_id":"132855","name":"Juan Henri"},{"player_id":"96348","name":"Francoise Stoman"}],"max_over":"20","target":"121","recent_scores":"1,2,4,1,0,4,1,0,1,1,0,0,0,1,1,2,1,1","last_five_overs":"34\/0 6.58","last_ten_overs":"83\/1 7.90"},"teams":[{"tid":69724,"title":"Malta","abbr":"MAL","alt_name":"Malta","type":"country","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Malta.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Malta.png","country":"cnteu","sex":"male","team_owner":"","head_coach":"","scores_full":"120\/10 (17.2 ov)","scores":"120\/10","overs":"17.2"},{"tid":69725,"title":"Portugal","abbr":"PORT","alt_name":"Portugal","type":"country","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Proutgal.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Proutgal.png","country":"pt","sex":"male","team_owner":"","head_coach":"","scores_full":"121\/2 (14.1 ov)","scores":"121\/2","overs":"14.1"}],"players":[{"pid":59325,"title":"Sharn Gomes","short_name":"SP Gomes","first_name":"Sharn Gomes","last_name":"","middle_name":"","birthdate":"1988-08-06","birthplace":"","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","role_str":""},{"pid":96348,"title":"Francoise Stoman","short_name":"F Stoman","first_name":"Francoise Stoman","last_name":"","middle_name":"","birthdate":"2000-03-23","birthplace":"","country":"pt","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":"Portugal","role":"bowl","role_str":""},{"pid":103302,"title":"Mohammad Siraj Nipo","short_name":"MS Nipo","first_name":"Mohammad Siraj Nipo","last_name":"","middle_name":"","birthdate":"1998-04-10","birthplace":"","country":"pt","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":"Portugal","role":"bowl","role_str":""},{"pid":104425,"title":"David Marks","short_name":"D Marks","first_name":"David Marks","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"bowl","role_str":""},{"pid":104590,"title":"Darshit Patankar","short_name":"D Patankar","first_name":"Darshit Patankar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","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":"International","role":"squad","role_str":""},{"pid":105570,"title":"Jaswinder Singh","short_name":"J Singh","first_name":"Jaswinder Singh","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"es","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Spain","role":"bowl","role_str":""},{"pid":108634,"title":"Shrijay Patel","short_name":"S Patel","first_name":"Shrijay Patel","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","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":"International","role":"bat","role_str":""},{"pid":108660,"title":"Imran Ameer","short_name":"I Ameer","first_name":"Imran Ameer","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","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":"International","role":"bat","role_str":""},{"pid":112175,"title":"Rockey Dianish","short_name":"R Dianish","first_name":"Rockey Dianish","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"wk","role_str":""},{"pid":113263,"title":"Mehboob Ali","short_name":"M Ali","first_name":"Mehboob Ali","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"all","role_str":""},{"pid":123716,"title":"Chanjal Sudarsanan","short_name":"Chanjal Sudarsanan","first_name":"Chanjal Sudarsanan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"","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":null,"role":"wk","role_str":"(WK)"},{"pid":123727,"title":"Priyan Pushparajan","short_name":"Priyan Pushparajan","first_name":"Priyan Pushparajan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":null,"role":"all","role_str":"(C)"},{"pid":123740,"title":"Jamsheed Kunnanchirakkal","short_name":"J Kunnanchirakkal","first_name":"Jamsheed Kunnanchirakkal","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":123746,"title":"Varun Prasath","short_name":"V Prasath","first_name":"Varun Prasath","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","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":"International","role":"all","role_str":""},{"pid":124287,"title":"Jalpesh Vijay","short_name":"J Vijay","first_name":"Jalpesh Vijay","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"pt","primary_team":[],"logo_url":"","playing_role":"wk","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":"Portugal","role":"squad","role_str":""},{"pid":124996,"title":"Miguel Machado","short_name":"M Machado","first_name":"Miguel Machado","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"pt","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":"Portugal","role":"squad","role_str":""},{"pid":129021,"title":"Waseem Abbas","short_name":"W Abbas","first_name":"Waseem Abbas","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"squad","role_str":""},{"pid":130393,"title":"Eldhose Mathew","short_name":"E Mathew","first_name":"Eldhose Mathew","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","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":"International","role":"all","role_str":""},{"pid":132855,"title":"Juan Henri","short_name":"J Henri","first_name":"Juan Henri","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"pt","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":"Portugal","role":"bowl","role_str":""},{"pid":141026,"title":"Jeremy Martins","short_name":"J Martins","first_name":"Jeremy Martins","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"pt","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Portugal","role":"squad","role_str":""},{"pid":144220,"title":"Dhavalkumar Norotam","short_name":"D Norotam","first_name":"Dhavalkumar Norotam","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"pt","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":"Portugal","role":"bat","role_str":""},{"pid":144221,"title":"Carlos Nunes","short_name":"C Nunes","first_name":"Carlos Nunes","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"pt","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":"Portugal","role":"all","role_str":"(WK\/C)"},{"pid":144535,"title":"Amar Sharma","short_name":"A Sharma","first_name":"Amar Sharma","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"mt","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":"Malta","role":"squad","role_str":""},{"pid":146505,"title":"Rahulkumar Hashu","short_name":"R Hashu","first_name":"Rahulkumar Hashu","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"pt","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":"Portugal","role":"all","role_str":""},{"pid":146507,"title":"Natim Hassam","short_name":"N Hassam","first_name":"Natim Hassam","last_name":"","middle_name":"","birthdate":"1996-04-03","birthplace":"","country":"pt","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":"Portugal","role":"bowl","role_str":""},{"pid":147639,"title":"Hardeep Singh Khuttan","short_name":"H Singh Khuttan","first_name":"Hardeep Singh Khuttan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"pt","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":"Portugal","role":"bat","role_str":""},{"pid":147679,"title":"Sherman Vaz","short_name":"S Vaz","first_name":"Sherman Vaz","last_name":"","middle_name":"","birthdate":"1993-04-16","birthplace":"","country":"pt","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Portugal","role":"squad","role_str":""},{"pid":147765,"title":"Upen Shantu","short_name":"U Shantu","first_name":"Upen Shantu","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"pt","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast","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":"Portugal","role":"bowl","role_str":""},{"pid":149122,"title":"Chad Potgieter","short_name":"C Potgieter","first_name":"Chad Potgieter","last_name":"","middle_name":"","birthdate":"1999-03-19","birthplace":"","country":"pt","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":"Portugal","role":"bat","role_str":""}]},"etag":"89a493f2cb5b9c417122cc4e9eb9ed94","modified":"2025-06-29 00:01:20","datetime":"2025-06-29 00:01:20","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":90281,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Portugal won by 8 wickets","day_remaining_over":"","team_batting":"Portugal","team_bowling":"Malta","live_inning_number":2,"live_score":{"runs":121,"overs":14.1,"wickets":2,"target":121,"runrate":8.54,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Sharn Gomes","batsman_id":59325,"runs":67,"balls_faced":41,"fours":5,"sixes":2,"strike_rate":"163.41"},{"name":"Natim Hassam","batsman_id":146507,"runs":21,"balls_faced":23,"fours":2,"sixes":0,"strike_rate":"91.30"}],"bowlers":[{"name":"Priyan Pushparajan","bowler_id":123727,"overs":2.1,"runs_conceded":10,"wickets":0,"maidens":0,"econ":"4.62"},{"name":"Varun Prasath","bowler_id":123746,"overs":4,"runs_conceded":34,"wickets":0,"maidens":0,"econ":"8.50"}],"commentaries":[{"event_id":"12045608","event":"ball","batsman_id":"146507","bowler_id":"123746","over":"9","ball":"6","score":1,"commentary":"Varun Prasath to Natim Hassam, 1 run,","noball_dismissal":false,"text":"","timestamp":1748614516,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":10,"runs":5,"score":"92\/2","bats":[{"runs":8,"balls_faced":7,"fours":1,"sixes":0,"batsman_id":146507},{"runs":51,"balls_faced":32,"fours":3,"sixes":2,"batsman_id":59325}],"bowls":[{"runs_conceded":15,"maidens":0,"wickets":0,"bowler_id":123746,"overs":2},{"runs_conceded":19,"maidens":0,"wickets":1,"bowler_id":105570,"overs":2}],"commentary":"End of over 10 (5 runs), Portugal 92\/2"},{"event_id":"12045655","event":"ball","batsman_id":"146507","bowler_id":"123727","over":"10","ball":"1","score":0,"commentary":"Priyan Pushparajan to Natim Hassam, no run,","noball_dismissal":false,"text":"","timestamp":1748614728,"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":"12045656","event":"ball","batsman_id":"146507","bowler_id":"123727","over":"10","ball":"2","score":2,"commentary":"Priyan Pushparajan to Natim Hassam, 2 runs,","noball_dismissal":false,"text":"","timestamp":1748614731,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12045658","event":"ball","batsman_id":"146507","bowler_id":"123727","over":"10","ball":"3","score":0,"commentary":"Priyan Pushparajan to Natim Hassam, no run,","noball_dismissal":false,"text":"","timestamp":1748614734,"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":"12045662","event":"ball","batsman_id":"146507","bowler_id":"123727","over":"10","ball":"4","score":1,"commentary":"Priyan Pushparajan to Natim Hassam, 1 run,","noball_dismissal":false,"text":"","timestamp":1748614750,"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":"12045679","event":"ball","batsman_id":"59325","bowler_id":"123727","over":"10","ball":"5","score":4,"commentary":"Priyan Pushparajan to Sharn Gomes, Four,","noball_dismissal":false,"text":"","timestamp":1748614828,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12045681","event":"ball","batsman_id":"59325","bowler_id":"123727","over":"10","ball":"6","score":0,"commentary":"Priyan Pushparajan to Sharn Gomes, no run,","noball_dismissal":false,"text":"","timestamp":1748614831,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":11,"runs":7,"score":"99\/2","bats":[{"runs":55,"balls_faced":34,"fours":4,"sixes":2,"batsman_id":59325},{"runs":11,"balls_faced":11,"fours":1,"sixes":0,"batsman_id":146507}],"bowls":[{"runs_conceded":7,"maidens":0,"wickets":0,"bowler_id":123727,"overs":1},{"runs_conceded":15,"maidens":0,"wickets":0,"bowler_id":123746,"overs":2}],"commentary":"End of over 11 (7 runs), Portugal 99\/2"},{"event_id":"12045698","event":"ball","batsman_id":"146507","bowler_id":"123746","over":"11","ball":"1","score":1,"commentary":"Varun Prasath to Natim Hassam, 1 run,","noball_dismissal":false,"text":"","timestamp":1748614916,"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":"12045706","event":"ball","batsman_id":"59325","bowler_id":"123746","over":"11","ball":"2","score":1,"commentary":"Varun Prasath to Sharn Gomes, 1 run,","noball_dismissal":false,"text":"","timestamp":1748614943,"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":"12045708","event":"ball","batsman_id":"146507","bowler_id":"123746","over":"11","ball":"3","score":1,"commentary":"Varun Prasath to Natim Hassam, 1 run,","noball_dismissal":false,"text":"","timestamp":1748614945,"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":"12045716","event":"ball","batsman_id":"59325","bowler_id":"123746","over":"11","ball":"4","score":2,"commentary":"Varun Prasath to Sharn Gomes, 2 runs,","noball_dismissal":false,"text":"","timestamp":1748614996,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12045720","event":"ball","batsman_id":"59325","bowler_id":"123746","over":"11","ball":"5","score":1,"commentary":"Varun Prasath to Sharn Gomes, 1 run,","noball_dismissal":false,"text":"","timestamp":1748615007,"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":"12045729","event":"ball","batsman_id":"146507","bowler_id":"123746","over":"11","ball":"6","score":1,"commentary":"Varun Prasath to Natim Hassam, 1 run,","noball_dismissal":false,"text":"","timestamp":1748615034,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":12,"runs":7,"score":"106\/2","bats":[{"runs":14,"balls_faced":14,"fours":1,"sixes":0,"batsman_id":146507},{"runs":59,"balls_faced":37,"fours":4,"sixes":2,"batsman_id":59325}],"bowls":[{"runs_conceded":22,"maidens":0,"wickets":0,"bowler_id":123746,"overs":3},{"runs_conceded":7,"maidens":0,"wickets":0,"bowler_id":123727,"overs":1}],"commentary":"End of over 12 (7 runs), Portugal 106\/2"},{"event_id":"12045738","event":"ball","batsman_id":"146507","bowler_id":"123727","over":"12","ball":"1","score":0,"commentary":"Priyan Pushparajan to Natim Hassam, no run,","noball_dismissal":false,"text":"","timestamp":1748615090,"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":"12045747","event":"ball","batsman_id":"146507","bowler_id":"123727","over":"12","ball":"2","score":0,"commentary":"Priyan Pushparajan to Natim Hassam, no run,","noball_dismissal":false,"text":"","timestamp":1748615130,"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":"12045752","event":"ball","batsman_id":"146507","bowler_id":"123727","over":"12","ball":"3","score":0,"commentary":"Priyan Pushparajan to Natim Hassam, no run,","noball_dismissal":false,"text":"","timestamp":1748615133,"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":"12045757","event":"ball","batsman_id":"146507","bowler_id":"123727","over":"12","ball":"4","score":1,"commentary":"Priyan Pushparajan to Natim Hassam, 1 run,","noball_dismissal":false,"text":"","timestamp":1748615172,"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":"12045762","event":"ball","batsman_id":"59325","bowler_id":"123727","over":"12","ball":"5","score":1,"commentary":"Priyan Pushparajan to Sharn Gomes, 1 run,","noball_dismissal":false,"text":"","timestamp":1748615204,"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":"12045778","event":"ball","batsman_id":"146507","bowler_id":"123727","over":"12","ball":"6","score":0,"commentary":"Priyan Pushparajan to Natim Hassam, no run,","noball_dismissal":false,"text":"","timestamp":1748615274,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":13,"runs":2,"score":"108\/2","bats":[{"runs":15,"balls_faced":19,"fours":1,"sixes":0,"batsman_id":146507},{"runs":60,"balls_faced":38,"fours":4,"sixes":2,"batsman_id":59325}],"bowls":[{"runs_conceded":9,"maidens":0,"wickets":0,"bowler_id":123727,"overs":2},{"runs_conceded":22,"maidens":0,"wickets":0,"bowler_id":123746,"overs":3}],"commentary":"End of over 13 (2 runs), Portugal 108\/2"},{"event_id":"12045787","event":"ball","batsman_id":"59325","bowler_id":"123746","over":"13","ball":"1","score":1,"commentary":"Varun Prasath to Sharn Gomes, 1 run,","noball_dismissal":false,"text":"","timestamp":1748615317,"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":"12045790","event":"ball","batsman_id":"146507","bowler_id":"123746","over":"13","ball":"2","score":4,"commentary":"Varun Prasath to Natim Hassam, Four,","noball_dismissal":false,"text":"","timestamp":1748615321,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12045793","event":"ball","batsman_id":"146507","bowler_id":"123746","over":"13","ball":"3","score":0,"commentary":"Varun Prasath to Natim Hassam, no run,","noball_dismissal":false,"text":"","timestamp":1748615341,"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":"12045795","event":"ball","batsman_id":"146507","bowler_id":"123746","over":"13","ball":"4","score":1,"commentary":"Varun Prasath to Natim Hassam, 1 run,","noball_dismissal":false,"text":"","timestamp":1748615346,"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":"12045805","event":"ball","batsman_id":"59325","bowler_id":"123746","over":"13","ball":"5","score":4,"commentary":"Varun Prasath to Sharn Gomes, Four,","noball_dismissal":false,"text":"","timestamp":1748615400,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12045811","event":"ball","batsman_id":"59325","bowler_id":"123746","over":"13","ball":"6","score":2,"commentary":"Varun Prasath to Sharn Gomes, 2 runs,","noball_dismissal":false,"text":"","timestamp":1748615425,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":14,"runs":12,"score":"120\/2","bats":[{"runs":67,"balls_faced":41,"fours":5,"sixes":2,"batsman_id":59325},{"runs":20,"balls_faced":22,"fours":2,"sixes":0,"batsman_id":146507}],"bowls":[{"runs_conceded":34,"maidens":0,"wickets":0,"bowler_id":123746,"overs":4},{"runs_conceded":9,"maidens":0,"wickets":0,"bowler_id":123727,"overs":2}],"commentary":"End of over 14 (12 runs), Portugal 120\/2"},{"event_id":"12045822","event":"ball","batsman_id":"146507","bowler_id":"123727","over":"14","ball":"1","score":1,"commentary":"Priyan Pushparajan to Natim Hassam, 1 run,","noball_dismissal":false,"text":"","timestamp":1748615471,"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}],"day":"0","session":"0","live_inning":{"iid":197173,"number":2,"name":"Portugal Inning","short_name":"PORT Inning","status":2,"issuperover":"false","result":3,"batting_team_id":69725,"fielding_team_id":69724,"scores":"121\/2","scores_full":"121\/2 (14.1 ov)","fielder":[{"fielder_id":"108634","fielder_name":"Shrijay Patel","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Chad Potgieter","batsman_id":"149122","runs":"20","balls":"16","how_out":"c S Patel b J Singh","score_at_dismissal":61,"overs_at_dismissal":"6.4","bowler_id":"105570","dismissal":"caught","number":2},"extra_runs":{"byes":1,"legbyes":0,"wides":4,"noballs":0,"penalty":"0","total":5},"equations":{"runs":121,"wickets":2,"overs":"14.1","bowlers_used":5,"runrate":"8.54"},"current_partnership":{"runs":60,"balls":45,"overs":7.3,"batsmen":[{"name":"Natim Hassam","batsman_id":146507,"runs":21,"balls":23},{"name":"Sharn Gomes","batsman_id":59325,"runs":37,"balls":22}]},"did_not_bat":[{"player_id":"144221","name":"Carlos Nunes"},{"player_id":"147639","name":"Hardeep Singh Khuttan"},{"player_id":"146505","name":"Rahulkumar Hashu"},{"player_id":"103302","name":"Mohammad Siraj Nipo"},{"player_id":"147765","name":"Upen Shantu"},{"player_id":"132855","name":"Juan Henri"},{"player_id":"96348","name":"Francoise Stoman"}],"max_over":"20","target":"121","recent_scores":"1,2,4,1,0,4,1,0,1,1,0,0,0,1,1,2,1,1","last_five_overs":"34\/0 6.58","last_ten_overs":"83\/1 7.90"},"teams":[{"tid":69724,"title":"Malta","abbr":"MAL","alt_name":"Malta","type":"country","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Malta.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Malta.png","country":"cnteu","sex":"male","team_owner":"","head_coach":"","scores_full":"120\/10 (17.2 ov)","scores":"120\/10","overs":"17.2"},{"tid":69725,"title":"Portugal","abbr":"PORT","alt_name":"Portugal","type":"country","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Proutgal.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Proutgal.png","country":"pt","sex":"male","team_owner":"","head_coach":"","scores_full":"121\/2 (14.1 ov)","scores":"121\/2","overs":"14.1"}],"players":[{"pid":59325,"title":"Sharn Gomes","short_name":"SP Gomes","first_name":"Sharn Gomes","last_name":"","middle_name":"","birthdate":"1988-08-06","birthplace":"","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","role_str":""},{"pid":96348,"title":"Francoise Stoman","short_name":"F Stoman","first_name":"Francoise Stoman","last_name":"","middle_name":"","birthdate":"2000-03-23","birthplace":"","country":"pt","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":"Portugal","role":"bowl","role_str":""},{"pid":103302,"title":"Mohammad Siraj Nipo","short_name":"MS Nipo","first_name":"Mohammad Siraj Nipo","last_name":"","middle_name":"","birthdate":"1998-04-10","birthplace":"","country":"pt","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":"Portugal","role":"bowl","role_str":""},{"pid":104425,"title":"David Marks","short_name":"D Marks","first_name":"David Marks","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"bowl","role_str":""},{"pid":104590,"title":"Darshit Patankar","short_name":"D Patankar","first_name":"Darshit Patankar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","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":"International","role":"squad","role_str":""},{"pid":105570,"title":"Jaswinder Singh","short_name":"J Singh","first_name":"Jaswinder Singh","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"es","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Spain","role":"bowl","role_str":""},{"pid":108634,"title":"Shrijay Patel","short_name":"S Patel","first_name":"Shrijay Patel","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","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":"International","role":"bat","role_str":""},{"pid":108660,"title":"Imran Ameer","short_name":"I Ameer","first_name":"Imran Ameer","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","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":"International","role":"bat","role_str":""},{"pid":112175,"title":"Rockey Dianish","short_name":"R Dianish","first_name":"Rockey Dianish","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"wk","role_str":""},{"pid":113263,"title":"Mehboob Ali","short_name":"M Ali","first_name":"Mehboob Ali","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"all","role_str":""},{"pid":123716,"title":"Chanjal Sudarsanan","short_name":"Chanjal Sudarsanan","first_name":"Chanjal Sudarsanan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"","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":null,"role":"wk","role_str":"(WK)"},{"pid":123727,"title":"Priyan Pushparajan","short_name":"Priyan Pushparajan","first_name":"Priyan Pushparajan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":null,"role":"all","role_str":"(C)"},{"pid":123740,"title":"Jamsheed Kunnanchirakkal","short_name":"J Kunnanchirakkal","first_name":"Jamsheed Kunnanchirakkal","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":123746,"title":"Varun Prasath","short_name":"V Prasath","first_name":"Varun Prasath","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","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":"International","role":"all","role_str":""},{"pid":124287,"title":"Jalpesh Vijay","short_name":"J Vijay","first_name":"Jalpesh Vijay","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"pt","primary_team":[],"logo_url":"","playing_role":"wk","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":"Portugal","role":"squad","role_str":""},{"pid":124996,"title":"Miguel Machado","short_name":"M Machado","first_name":"Miguel Machado","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"pt","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":"Portugal","role":"squad","role_str":""},{"pid":129021,"title":"Waseem Abbas","short_name":"W Abbas","first_name":"Waseem Abbas","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"squad","role_str":""},{"pid":130393,"title":"Eldhose Mathew","short_name":"E Mathew","first_name":"Eldhose Mathew","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","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":"International","role":"all","role_str":""},{"pid":132855,"title":"Juan Henri","short_name":"J Henri","first_name":"Juan Henri","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"pt","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":"Portugal","role":"bowl","role_str":""},{"pid":141026,"title":"Jeremy Martins","short_name":"J Martins","first_name":"Jeremy Martins","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"pt","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Portugal","role":"squad","role_str":""},{"pid":144220,"title":"Dhavalkumar Norotam","short_name":"D Norotam","first_name":"Dhavalkumar Norotam","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"pt","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":"Portugal","role":"bat","role_str":""},{"pid":144221,"title":"Carlos Nunes","short_name":"C Nunes","first_name":"Carlos Nunes","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"pt","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":"Portugal","role":"all","role_str":"(WK\/C)"},{"pid":144535,"title":"Amar Sharma","short_name":"A Sharma","first_name":"Amar Sharma","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"mt","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":"Malta","role":"squad","role_str":""},{"pid":146505,"title":"Rahulkumar Hashu","short_name":"R Hashu","first_name":"Rahulkumar Hashu","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"pt","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":"Portugal","role":"all","role_str":""},{"pid":146507,"title":"Natim Hassam","short_name":"N Hassam","first_name":"Natim Hassam","last_name":"","middle_name":"","birthdate":"1996-04-03","birthplace":"","country":"pt","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":"Portugal","role":"bowl","role_str":""},{"pid":147639,"title":"Hardeep Singh Khuttan","short_name":"H Singh Khuttan","first_name":"Hardeep Singh Khuttan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"pt","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":"Portugal","role":"bat","role_str":""},{"pid":147679,"title":"Sherman Vaz","short_name":"S Vaz","first_name":"Sherman Vaz","last_name":"","middle_name":"","birthdate":"1993-04-16","birthplace":"","country":"pt","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Portugal","role":"squad","role_str":""},{"pid":147765,"title":"Upen Shantu","short_name":"U Shantu","first_name":"Upen Shantu","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"pt","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast","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":"Portugal","role":"bowl","role_str":""},{"pid":149122,"title":"Chad Potgieter","short_name":"C Potgieter","first_name":"Chad Potgieter","last_name":"","middle_name":"","birthdate":"1999-03-19","birthplace":"","country":"pt","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":"Portugal","role":"bat","role_str":""}]},"etag":"89a493f2cb5b9c417122cc4e9eb9ed94","modified":"2025-06-29 00:01:20","datetime":"2025-06-29 00:01:20","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90281 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:ecaa2f7d-44bf-45cd-991d-767fda22091c Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90281 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90281,3,'{"status":"ok","response":{"match_id":90281,"title":"Malta vs Portugal","short_title":"MAL vs PORT","subtitle":"Match 2","match_number":"2","format":3,"format_str":"T20I","status":2,"status_str":"Completed","status_note":"Portugal won by 8 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129604,"title":"ECN Mdina Cup T20I","abbr":"ECN Mdina Cup T20I","type":"tournament","category":"domestic","match_format":"t20i","season":"2025","status":"live","datestart":"2025-05-30","dateend":"2025-06-01","country":"int","total_matches":"7","total_rounds":"1","total_teams":"3"},"teama":{"team_id":69724,"name":"Malta","short_name":"MAL","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Malta.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Malta.png","scores_full":"120\/10 (17.2 ov)","scores":"120\/10","overs":"17.2"},"teamb":{"team_id":69725,"name":"Portugal","short_name":"PORT","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Proutgal.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Proutgal.png","scores_full":"121\/2 (14.1 ov)","scores":"121\/2","overs":"14.1"},"date_start":"2025-05-30 11:45:00","date_end":"2025-05-30 21:45:00","timestamp_start":1748605500,"timestamp_end":1748641500,"date_start_ist":"2025-05-30 17:15:00","date_end_ist":"2025-05-31 03:15:00","venue":{"venue_id":"1213712","name":"Stars Arena Hofstade","location":"Zemst","country":"Belgium","timezone":""},"umpires":"Vinay Malhotra (Germany), Ramraj Venkataramanan (India), Abdul Rehman (Belgium,TV )","referee":"Aniruddha Godbole (Belgium )","equation":"","live":"","result":"PORT won by 8 wickets","result_type":2,"win_margin":"8 wickets","winning_team_id":69725,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-05-28 17:00:47","verify_time":"2025-05-30 20:22:57","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":[],"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Portugal elected to bowl","winner":69725,"decision":2}},"etag":"206c9b3cfe29ff531358f27e0c79225b","modified":"2025-06-29 00:01:21","datetime":"2025-06-29 00:01:21","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90281,"title":"Malta vs Portugal","short_title":"MAL vs PORT","subtitle":"Match 2","match_number":"2","format":3,"format_str":"T20I","status":2,"status_str":"Completed","status_note":"Portugal won by 8 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129604,"title":"ECN Mdina Cup T20I","abbr":"ECN Mdina Cup T20I","type":"tournament","category":"domestic","match_format":"t20i","season":"2025","status":"live","datestart":"2025-05-30","dateend":"2025-06-01","country":"int","total_matches":"7","total_rounds":"1","total_teams":"3"},"teama":{"team_id":69724,"name":"Malta","short_name":"MAL","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Malta.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Malta.png","scores_full":"120\/10 (17.2 ov)","scores":"120\/10","overs":"17.2"},"teamb":{"team_id":69725,"name":"Portugal","short_name":"PORT","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Proutgal.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Proutgal.png","scores_full":"121\/2 (14.1 ov)","scores":"121\/2","overs":"14.1"},"date_start":"2025-05-30 11:45:00","date_end":"2025-05-30 21:45:00","timestamp_start":1748605500,"timestamp_end":1748641500,"date_start_ist":"2025-05-30 17:15:00","date_end_ist":"2025-05-31 03:15:00","venue":{"venue_id":"1213712","name":"Stars Arena Hofstade","location":"Zemst","country":"Belgium","timezone":""},"umpires":"Vinay Malhotra (Germany), Ramraj Venkataramanan (India), Abdul Rehman (Belgium,TV )","referee":"Aniruddha Godbole (Belgium )","equation":"","live":"","result":"PORT won by 8 wickets","result_type":2,"win_margin":"8 wickets","winning_team_id":69725,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-05-28 17:00:47","verify_time":"2025-05-30 20:22:57","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":[],"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Portugal elected to bowl","winner":69725,"decision":2}},"etag":"206c9b3cfe29ff531358f27e0c79225b","modified":"2025-06-29 00:01:21","datetime":"2025-06-29 00:01:21","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90281 AND DataTypeId = 3 END
Live Report & Scorecard of Malta vs Portugal Match 2