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:cf152bad-1d9d-491a-9ea4-30863436a2a1 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90281 AND DataTypeId = 2) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90281,2,'{"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":"","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},"current_over":"","previous_over":"","man_of_the_match":{"pid":59325,"name":"Sharn Gomes","thumb_url":""},"man_of_the_series":"","is_followon":0,"team_batting_first":"","team_batting_second":"","last_five_overs":"","innings":[{"iid":197168,"number":1,"name":"Malta Inning","short_name":"MAL Inning","status":2,"issuperover":"false","result":1,"batting_team_id":69724,"fielding_team_id":69725,"scores":"120\/10","scores_full":"120\/10 (17.2 ov)","batsmen":[{"name":"Rockey Dianish","batsman_id":"112175","batting":"false","position":"","role":"wk","role_str":"","runs":"2","balls_faced":"5","fours":"0","sixes":"0","run0":"3","run1":"2","run2":"0","run3":"0","run5":"0","how_out":"c C Nunes b U Shantu","dismissal":"caught","strike_rate":"40.00","bowler_id":"147765","first_fielder_id":"144221","second_fielder_id":"","third_fielder_id":""},{"name":"Mehboob Ali","batsman_id":"113263","batting":"false","position":"","role":"all","role_str":"","runs":"19","balls_faced":"12","fours":"1","sixes":"2","run0":"7","run1":"1","run2":"1","run3":"0","run5":"0","how_out":"c C Potgieter b J Henri","dismissal":"caught","strike_rate":"158.33","bowler_id":"132855","first_fielder_id":"149122","second_fielder_id":"","third_fielder_id":""},{"name":"Priyan Pushparajan","batsman_id":"123727","batting":"false","position":"","role":"all","role_str":"(C)","runs":"12","balls_faced":"7","fours":"1","sixes":"1","run0":"3","run1":"2","run2":"0","run3":"0","run5":"0","how_out":"c SP Gomes b J Henri","dismissal":"caught","strike_rate":"171.43","bowler_id":"132855","first_fielder_id":"59325","second_fielder_id":"","third_fielder_id":""},{"name":"Varun Prasath","batsman_id":"123746","batting":"false","position":"","role":"all","role_str":"","runs":"12","balls_faced":"8","fours":"1","sixes":"1","run0":"4","run1":"2","run2":"0","run3":"0","run5":"0","how_out":"c J Henri b U Shantu","dismissal":"caught","strike_rate":"150.00","bowler_id":"147765","first_fielder_id":"132855","second_fielder_id":"","third_fielder_id":""},{"name":"Chanjal Sudarsanan","batsman_id":"123716","batting":"false","position":"","role":"wk","role_str":"(WK)","runs":"6","balls_faced":"12","fours":"0","sixes":"0","run0":"7","run1":"4","run2":"1","run3":"0","run5":"0","how_out":"c C Nunes b R Hashu","dismissal":"caught","strike_rate":"50.00","bowler_id":"146505","first_fielder_id":"144221","second_fielder_id":"","third_fielder_id":""},{"name":"Eldhose Mathew","batsman_id":"130393","batting":"false","position":"","role":"all","role_str":"","runs":"8","balls_faced":"15","fours":"1","sixes":"0","run0":"10","run1":"4","run2":"0","run3":"0","run5":"0","how_out":"b R Hashu","dismissal":"bowled","strike_rate":"53.33","bowler_id":"146505","first_fielder_id":"146505","second_fielder_id":"","third_fielder_id":""},{"name":"Imran Ameer","batsman_id":"108660","batting":"false","position":"","role":"bat","role_str":"","runs":"7","balls_faced":"9","fours":"1","sixes":"0","run0":"6","run1":"1","run2":"1","run3":"0","run5":"0","how_out":"b F Stoman","dismissal":"bowled","strike_rate":"77.78","bowler_id":"96348","first_fielder_id":"","second_fielder_id":"","third_fielder_id":""},{"name":"Jaswinder Singh","batsman_id":"105570","batting":"false","position":"","role":"bowl","role_str":"","runs":"5","balls_faced":"12","fours":"0","sixes":"0","run0":"8","run1":"3","run2":"1","run3":"0","run5":"0","how_out":"c C Nunes b MS Nipo","dismissal":"caught","strike_rate":"41.67","bowler_id":"103302","first_fielder_id":"144221","second_fielder_id":"","third_fielder_id":""},{"name":"Jamsheed Kunnanchirakkal","batsman_id":"123740","batting":"false","position":"","role":"bat","role_str":"","runs":"0","balls_faced":"1","fours":"0","sixes":"0","run0":"1","run1":"0","run2":"0","run3":"0","run5":"0","how_out":"c SP Gomes b R Hashu","dismissal":"caught","strike_rate":"0.00","bowler_id":"146505","first_fielder_id":"59325","second_fielder_id":"","third_fielder_id":""},{"name":"Shrijay Patel","batsman_id":"108634","batting":"true","position":"non striker","role":"bat","role_str":"","runs":"31","balls_faced":"17","fours":"2","sixes":"3","run0":"8","run1":"3","run2":"1","run3":"0","run5":"0","how_out":"runout (D Norotam)","dismissal":"runout","strike_rate":"182.35","bowler_id":"0","first_fielder_id":"144220","second_fielder_id":"","third_fielder_id":""},{"name":"David Marks","batsman_id":"104425","batting":"true","position":"striker","role":"bowl","role_str":"","runs":"8","balls_faced":"7","fours":"1","sixes":"0","run0":"3","run1":"2","run2":"1","run3":"0","run5":"0","how_out":"Not out","dismissal":"","strike_rate":"114.29","bowler_id":"0","first_fielder_id":"","second_fielder_id":"","third_fielder_id":""}],"bowlers":[{"name":"Upen Shantu","bowler_id":"147765","bowling":"false","position":"","overs":"4","maidens":"0","runs_conceded":"23","wickets":"2","noballs":"0","wides":"1","econ":"5.75","run0":"14","bowledcount":"0","lbwcount":"0"},{"name":"Juan Henri","bowler_id":"132855","bowling":"false","position":"","overs":"4","maidens":"0","runs_conceded":"35","wickets":"2","noballs":"0","wides":"2","econ":"8.75","run0":"12","bowledcount":"0","lbwcount":"0"},{"name":"Francoise Stoman","bowler_id":"96348","bowling":"false","position":"","overs":"4","maidens":"0","runs_conceded":"24","wickets":"1","noballs":"1","wides":"2","econ":"6.00","run0":"17","bowledcount":"1","lbwcount":"0"},{"name":"Rahulkumar Hashu","bowler_id":"146505","bowling":"false","position":"last bowler","overs":"3","maidens":"0","runs_conceded":"16","wickets":"3","noballs":"0","wides":"1","econ":"5.33","run0":"10","bowledcount":"1","lbwcount":"0"},{"name":"Mohammad Siraj Nipo","bowler_id":"103302","bowling":"false","position":"","overs":"2","maidens":"0","runs_conceded":"18","wickets":"1","noballs":"0","wides":"0","econ":"9.00","run0":"6","bowledcount":"0","lbwcount":"0"},{"name":"Hardeep Singh Khuttan","bowler_id":"147639","bowling":"true","position":"active bowler","overs":"0.2","maidens":"0","runs_conceded":"1","wickets":"0","noballs":"0","wides":"0","econ":"3.00","run0":"1","bowledcount":"0","lbwcount":"0"}],"fielder":[{"fielder_id":"144221","fielder_name":"Carlos Nunes","catches":3,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"149122","fielder_name":"Chad Potgieter","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"59325","fielder_name":"Sharn Gomes","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"132855","fielder_name":"Juan Henri","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"146505","fielder_name":"Rahulkumar Hashu","catches":0,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"144220","fielder_name":"Dhavalkumar Norotam","catches":0,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":1,"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"}},"fows":[{"name":"Rockey Dianish","batsman_id":"112175","runs":"2","balls":"5","how_out":"c C Nunes b U Shantu","score_at_dismissal":17,"overs_at_dismissal":"2.2","bowler_id":"147765","dismissal":"caught","number":1},{"name":"Mehboob Ali","batsman_id":"113263","runs":"19","balls":"12","how_out":"c C Potgieter b J Henri","score_at_dismissal":28,"overs_at_dismissal":"3.1","bowler_id":"132855","dismissal":"caught","number":2},{"name":"Varun Prasath","batsman_id":"123746","runs":"12","balls":"8","how_out":"c J Henri b U Shantu","score_at_dismissal":41,"overs_at_dismissal":"4.5","bowler_id":"147765","dismissal":"caught","number":3},{"name":"Priyan Pushparajan","batsman_id":"123727","runs":"12","balls":"7","how_out":"c SP Gomes b J Henri","score_at_dismissal":47,"overs_at_dismissal":"5.3","bowler_id":"132855","dismissal":"caught","number":4},{"name":"Eldhose Mathew","batsman_id":"130393","runs":"8","balls":"15","how_out":"b R Hashu","score_at_dismissal":62,"overs_at_dismissal":"9.2","bowler_id":"146505","dismissal":"bowled","number":5},{"name":"Imran Ameer","batsman_id":"108660","runs":"7","balls":"9","how_out":"b F Stoman","score_at_dismissal":69,"overs_at_dismissal":"10.6","bowler_id":"96348","dismissal":"bowled","number":6},{"name":"Chanjal Sudarsanan","batsman_id":"123716","runs":"6","balls":"12","how_out":"c C Nunes b R Hashu","score_at_dismissal":71,"overs_at_dismissal":"11.4","bowler_id":"146505","dismissal":"caught","number":7},{"name":"Jamsheed Kunnanchirakkal","batsman_id":"123740","runs":"0","balls":"1","how_out":"c SP Gomes b R Hashu","score_at_dismissal":71,"overs_at_dismissal":"11.5","bowler_id":"146505","dismissal":"caught","number":8},{"name":"Jaswinder Singh","batsman_id":"105570","runs":"5","balls":"12","how_out":"c C Nunes b MS Nipo","score_at_dismissal":95,"overs_at_dismissal":"15.1","bowler_id":"103302","dismissal":"caught","number":9},{"name":"Shrijay Patel","batsman_id":"108634","runs":"31","balls":"17","how_out":"runout (D Norotam)","score_at_dismissal":120,"overs_at_dismissal":"17.2","bowler_id":"0","dismissal":"runout","number":10}],"last_wicket":{"name":"Shrijay Patel","batsman_id":"108634","runs":"31","balls":"17","how_out":"runout (D Norotam)","score_at_dismissal":120,"overs_at_dismissal":"17.2","bowler_id":"0","dismissal":"runout","number":10},"extra_runs":{"byes":0,"legbyes":3,"wides":6,"noballs":1,"penalty":"0","total":10},"equations":{"runs":120,"wickets":10,"overs":"17.2","bowlers_used":6,"runrate":"6.92"},"current_partnership":{"runs":25,"balls":13,"overs":2.1,"batsmen":[{"name":"David Marks","batsman_id":104425,"runs":8,"balls":7},{"name":"Shrijay Patel","batsman_id":108634,"runs":16,"balls":6}]},"did_not_bat":[],"max_over":"20","target":"0"},{"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)","batsmen":[{"name":"Dhavalkumar Norotam","batsman_id":"144220","batting":"false","position":"","role":"bat","role_str":"","runs":"8","balls_faced":"5","fours":"1","sixes":"0","run0":"1","run1":"2","run2":"1","run3":"0","run5":"0","how_out":"c S Patel b D Marks","dismissal":"caught","strike_rate":"160.00","bowler_id":"104425","first_fielder_id":"108634","second_fielder_id":"","third_fielder_id":""},{"name":"Sharn Gomes","batsman_id":"59325","batting":"true","position":"non striker","role":"bat","role_str":"","runs":"67","balls_faced":"41","fours":"5","sixes":"2","run0":"7","run1":"19","run2":"8","run3":"0","run5":"0","how_out":"Not out","dismissal":"","strike_rate":"163.41","bowler_id":"0","first_fielder_id":"","second_fielder_id":"","third_fielder_id":""},{"name":"Chad Potgieter","batsman_id":"149122","batting":"false","position":"","role":"bat","role_str":"","runs":"20","balls_faced":"16","fours":"2","sixes":"1","run0":"7","run1":"6","run2":"0","run3":"0","run5":"0","how_out":"c S Patel b J Singh","dismissal":"caught","strike_rate":"125.00","bowler_id":"105570","first_fielder_id":"108634","second_fielder_id":"","third_fielder_id":""},{"name":"Natim Hassam","batsman_id":"146507","batting":"true","position":"striker","role":"bowl","role_str":"","runs":"21","balls_faced":"23","fours":"2","sixes":"0","run0":"9","run1":"11","run2":"1","run3":"0","run5":"0","how_out":"Not out","dismissal":"","strike_rate":"91.30","bowler_id":"0","first_fielder_id":"","second_fielder_id":"","third_fielder_id":""}],"bowlers":[{"name":"Mehboob Ali","bowler_id":"113263","bowling":"false","position":"","overs":"3","maidens":"0","runs_conceded":"32","wickets":"0","noballs":"0","wides":"2","econ":"10.67","run0":"4","bowledcount":"0","lbwcount":"0"},{"name":"David Marks","bowler_id":"104425","bowling":"false","position":"","overs":"3","maidens":"0","runs_conceded":"25","wickets":"1","noballs":"0","wides":"0","econ":"8.33","run0":"5","bowledcount":"0","lbwcount":"0"},{"name":"Jaswinder Singh","bowler_id":"105570","bowling":"false","position":"","overs":"2","maidens":"0","runs_conceded":"19","wickets":"1","noballs":"0","wides":"1","econ":"9.50","run0":"4","bowledcount":"0","lbwcount":"0"},{"name":"Varun Prasath","bowler_id":"123746","bowling":"false","position":"last bowler","overs":"4","maidens":"0","runs_conceded":"34","wickets":"0","noballs":"0","wides":"1","econ":"8.50","run0":"4","bowledcount":"0","lbwcount":"0"},{"name":"Priyan Pushparajan","bowler_id":"123727","bowling":"true","position":"active bowler","overs":"2.1","maidens":"0","runs_conceded":"10","wickets":"0","noballs":"0","wides":"0","econ":"4.62","run0":"7","bowledcount":"0","lbwcount":"0"}],"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"}},"fows":[{"name":"Dhavalkumar Norotam","batsman_id":"144220","runs":"8","balls":"5","how_out":"c S Patel b D Marks","score_at_dismissal":10,"overs_at_dismissal":"1.1","bowler_id":"104425","dismissal":"caught","number":1},{"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}],"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"}],"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":""}],"pre_match_odds":[],"day_remaining_over":"","match_notes":[["Malta inning 1","Powerplay 1 (0.1 - 6) Run 48, wicket 4","Malta: 50 runs in 6.2 overs.","Malta: 100 runs in 15.5 overs.","Innings Break: Malta - 120\/10 overs 17.2 (balls 104)."],["Portugal inning 2","Portugal: 50 runs in 4.6 overs.","Powerplay 1 (0.1 - 6) Run 57, wicket 1","50 run partnership of 30 balls,Sharn Gomes 28(16) runs, Chad Potgieter 20(14) runs.","Sharn Gomes 50 runs in 31 balls (4 x 3, 6 X 2).","Portugal: 100 runs in 11.1 overs.","50 run partnership of 40 balls,Natim Hassam 19(20) runs, Sharn Gomes 31(20) runs."]]},"etag":"34463875c39f284075b5c01e8a36e5a7","modified":"2025-06-28 20:44:47","datetime":"2025-06-28 20:44:47","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":"","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},"current_over":"","previous_over":"","man_of_the_match":{"pid":59325,"name":"Sharn Gomes","thumb_url":""},"man_of_the_series":"","is_followon":0,"team_batting_first":"","team_batting_second":"","last_five_overs":"","innings":[{"iid":197168,"number":1,"name":"Malta Inning","short_name":"MAL Inning","status":2,"issuperover":"false","result":1,"batting_team_id":69724,"fielding_team_id":69725,"scores":"120\/10","scores_full":"120\/10 (17.2 ov)","batsmen":[{"name":"Rockey Dianish","batsman_id":"112175","batting":"false","position":"","role":"wk","role_str":"","runs":"2","balls_faced":"5","fours":"0","sixes":"0","run0":"3","run1":"2","run2":"0","run3":"0","run5":"0","how_out":"c C Nunes b U Shantu","dismissal":"caught","strike_rate":"40.00","bowler_id":"147765","first_fielder_id":"144221","second_fielder_id":"","third_fielder_id":""},{"name":"Mehboob Ali","batsman_id":"113263","batting":"false","position":"","role":"all","role_str":"","runs":"19","balls_faced":"12","fours":"1","sixes":"2","run0":"7","run1":"1","run2":"1","run3":"0","run5":"0","how_out":"c C Potgieter b J Henri","dismissal":"caught","strike_rate":"158.33","bowler_id":"132855","first_fielder_id":"149122","second_fielder_id":"","third_fielder_id":""},{"name":"Priyan Pushparajan","batsman_id":"123727","batting":"false","position":"","role":"all","role_str":"(C)","runs":"12","balls_faced":"7","fours":"1","sixes":"1","run0":"3","run1":"2","run2":"0","run3":"0","run5":"0","how_out":"c SP Gomes b J Henri","dismissal":"caught","strike_rate":"171.43","bowler_id":"132855","first_fielder_id":"59325","second_fielder_id":"","third_fielder_id":""},{"name":"Varun Prasath","batsman_id":"123746","batting":"false","position":"","role":"all","role_str":"","runs":"12","balls_faced":"8","fours":"1","sixes":"1","run0":"4","run1":"2","run2":"0","run3":"0","run5":"0","how_out":"c J Henri b U Shantu","dismissal":"caught","strike_rate":"150.00","bowler_id":"147765","first_fielder_id":"132855","second_fielder_id":"","third_fielder_id":""},{"name":"Chanjal Sudarsanan","batsman_id":"123716","batting":"false","position":"","role":"wk","role_str":"(WK)","runs":"6","balls_faced":"12","fours":"0","sixes":"0","run0":"7","run1":"4","run2":"1","run3":"0","run5":"0","how_out":"c C Nunes b R Hashu","dismissal":"caught","strike_rate":"50.00","bowler_id":"146505","first_fielder_id":"144221","second_fielder_id":"","third_fielder_id":""},{"name":"Eldhose Mathew","batsman_id":"130393","batting":"false","position":"","role":"all","role_str":"","runs":"8","balls_faced":"15","fours":"1","sixes":"0","run0":"10","run1":"4","run2":"0","run3":"0","run5":"0","how_out":"b R Hashu","dismissal":"bowled","strike_rate":"53.33","bowler_id":"146505","first_fielder_id":"146505","second_fielder_id":"","third_fielder_id":""},{"name":"Imran Ameer","batsman_id":"108660","batting":"false","position":"","role":"bat","role_str":"","runs":"7","balls_faced":"9","fours":"1","sixes":"0","run0":"6","run1":"1","run2":"1","run3":"0","run5":"0","how_out":"b F Stoman","dismissal":"bowled","strike_rate":"77.78","bowler_id":"96348","first_fielder_id":"","second_fielder_id":"","third_fielder_id":""},{"name":"Jaswinder Singh","batsman_id":"105570","batting":"false","position":"","role":"bowl","role_str":"","runs":"5","balls_faced":"12","fours":"0","sixes":"0","run0":"8","run1":"3","run2":"1","run3":"0","run5":"0","how_out":"c C Nunes b MS Nipo","dismissal":"caught","strike_rate":"41.67","bowler_id":"103302","first_fielder_id":"144221","second_fielder_id":"","third_fielder_id":""},{"name":"Jamsheed Kunnanchirakkal","batsman_id":"123740","batting":"false","position":"","role":"bat","role_str":"","runs":"0","balls_faced":"1","fours":"0","sixes":"0","run0":"1","run1":"0","run2":"0","run3":"0","run5":"0","how_out":"c SP Gomes b R Hashu","dismissal":"caught","strike_rate":"0.00","bowler_id":"146505","first_fielder_id":"59325","second_fielder_id":"","third_fielder_id":""},{"name":"Shrijay Patel","batsman_id":"108634","batting":"true","position":"non striker","role":"bat","role_str":"","runs":"31","balls_faced":"17","fours":"2","sixes":"3","run0":"8","run1":"3","run2":"1","run3":"0","run5":"0","how_out":"runout (D Norotam)","dismissal":"runout","strike_rate":"182.35","bowler_id":"0","first_fielder_id":"144220","second_fielder_id":"","third_fielder_id":""},{"name":"David Marks","batsman_id":"104425","batting":"true","position":"striker","role":"bowl","role_str":"","runs":"8","balls_faced":"7","fours":"1","sixes":"0","run0":"3","run1":"2","run2":"1","run3":"0","run5":"0","how_out":"Not out","dismissal":"","strike_rate":"114.29","bowler_id":"0","first_fielder_id":"","second_fielder_id":"","third_fielder_id":""}],"bowlers":[{"name":"Upen Shantu","bowler_id":"147765","bowling":"false","position":"","overs":"4","maidens":"0","runs_conceded":"23","wickets":"2","noballs":"0","wides":"1","econ":"5.75","run0":"14","bowledcount":"0","lbwcount":"0"},{"name":"Juan Henri","bowler_id":"132855","bowling":"false","position":"","overs":"4","maidens":"0","runs_conceded":"35","wickets":"2","noballs":"0","wides":"2","econ":"8.75","run0":"12","bowledcount":"0","lbwcount":"0"},{"name":"Francoise Stoman","bowler_id":"96348","bowling":"false","position":"","overs":"4","maidens":"0","runs_conceded":"24","wickets":"1","noballs":"1","wides":"2","econ":"6.00","run0":"17","bowledcount":"1","lbwcount":"0"},{"name":"Rahulkumar Hashu","bowler_id":"146505","bowling":"false","position":"last bowler","overs":"3","maidens":"0","runs_conceded":"16","wickets":"3","noballs":"0","wides":"1","econ":"5.33","run0":"10","bowledcount":"1","lbwcount":"0"},{"name":"Mohammad Siraj Nipo","bowler_id":"103302","bowling":"false","position":"","overs":"2","maidens":"0","runs_conceded":"18","wickets":"1","noballs":"0","wides":"0","econ":"9.00","run0":"6","bowledcount":"0","lbwcount":"0"},{"name":"Hardeep Singh Khuttan","bowler_id":"147639","bowling":"true","position":"active bowler","overs":"0.2","maidens":"0","runs_conceded":"1","wickets":"0","noballs":"0","wides":"0","econ":"3.00","run0":"1","bowledcount":"0","lbwcount":"0"}],"fielder":[{"fielder_id":"144221","fielder_name":"Carlos Nunes","catches":3,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"149122","fielder_name":"Chad Potgieter","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"59325","fielder_name":"Sharn Gomes","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"132855","fielder_name":"Juan Henri","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"146505","fielder_name":"Rahulkumar Hashu","catches":0,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"144220","fielder_name":"Dhavalkumar Norotam","catches":0,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":1,"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"}},"fows":[{"name":"Rockey Dianish","batsman_id":"112175","runs":"2","balls":"5","how_out":"c C Nunes b U Shantu","score_at_dismissal":17,"overs_at_dismissal":"2.2","bowler_id":"147765","dismissal":"caught","number":1},{"name":"Mehboob Ali","batsman_id":"113263","runs":"19","balls":"12","how_out":"c C Potgieter b J Henri","score_at_dismissal":28,"overs_at_dismissal":"3.1","bowler_id":"132855","dismissal":"caught","number":2},{"name":"Varun Prasath","batsman_id":"123746","runs":"12","balls":"8","how_out":"c J Henri b U Shantu","score_at_dismissal":41,"overs_at_dismissal":"4.5","bowler_id":"147765","dismissal":"caught","number":3},{"name":"Priyan Pushparajan","batsman_id":"123727","runs":"12","balls":"7","how_out":"c SP Gomes b J Henri","score_at_dismissal":47,"overs_at_dismissal":"5.3","bowler_id":"132855","dismissal":"caught","number":4},{"name":"Eldhose Mathew","batsman_id":"130393","runs":"8","balls":"15","how_out":"b R Hashu","score_at_dismissal":62,"overs_at_dismissal":"9.2","bowler_id":"146505","dismissal":"bowled","number":5},{"name":"Imran Ameer","batsman_id":"108660","runs":"7","balls":"9","how_out":"b F Stoman","score_at_dismissal":69,"overs_at_dismissal":"10.6","bowler_id":"96348","dismissal":"bowled","number":6},{"name":"Chanjal Sudarsanan","batsman_id":"123716","runs":"6","balls":"12","how_out":"c C Nunes b R Hashu","score_at_dismissal":71,"overs_at_dismissal":"11.4","bowler_id":"146505","dismissal":"caught","number":7},{"name":"Jamsheed Kunnanchirakkal","batsman_id":"123740","runs":"0","balls":"1","how_out":"c SP Gomes b R Hashu","score_at_dismissal":71,"overs_at_dismissal":"11.5","bowler_id":"146505","dismissal":"caught","number":8},{"name":"Jaswinder Singh","batsman_id":"105570","runs":"5","balls":"12","how_out":"c C Nunes b MS Nipo","score_at_dismissal":95,"overs_at_dismissal":"15.1","bowler_id":"103302","dismissal":"caught","number":9},{"name":"Shrijay Patel","batsman_id":"108634","runs":"31","balls":"17","how_out":"runout (D Norotam)","score_at_dismissal":120,"overs_at_dismissal":"17.2","bowler_id":"0","dismissal":"runout","number":10}],"last_wicket":{"name":"Shrijay Patel","batsman_id":"108634","runs":"31","balls":"17","how_out":"runout (D Norotam)","score_at_dismissal":120,"overs_at_dismissal":"17.2","bowler_id":"0","dismissal":"runout","number":10},"extra_runs":{"byes":0,"legbyes":3,"wides":6,"noballs":1,"penalty":"0","total":10},"equations":{"runs":120,"wickets":10,"overs":"17.2","bowlers_used":6,"runrate":"6.92"},"current_partnership":{"runs":25,"balls":13,"overs":2.1,"batsmen":[{"name":"David Marks","batsman_id":104425,"runs":8,"balls":7},{"name":"Shrijay Patel","batsman_id":108634,"runs":16,"balls":6}]},"did_not_bat":[],"max_over":"20","target":"0"},{"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)","batsmen":[{"name":"Dhavalkumar Norotam","batsman_id":"144220","batting":"false","position":"","role":"bat","role_str":"","runs":"8","balls_faced":"5","fours":"1","sixes":"0","run0":"1","run1":"2","run2":"1","run3":"0","run5":"0","how_out":"c S Patel b D Marks","dismissal":"caught","strike_rate":"160.00","bowler_id":"104425","first_fielder_id":"108634","second_fielder_id":"","third_fielder_id":""},{"name":"Sharn Gomes","batsman_id":"59325","batting":"true","position":"non striker","role":"bat","role_str":"","runs":"67","balls_faced":"41","fours":"5","sixes":"2","run0":"7","run1":"19","run2":"8","run3":"0","run5":"0","how_out":"Not out","dismissal":"","strike_rate":"163.41","bowler_id":"0","first_fielder_id":"","second_fielder_id":"","third_fielder_id":""},{"name":"Chad Potgieter","batsman_id":"149122","batting":"false","position":"","role":"bat","role_str":"","runs":"20","balls_faced":"16","fours":"2","sixes":"1","run0":"7","run1":"6","run2":"0","run3":"0","run5":"0","how_out":"c S Patel b J Singh","dismissal":"caught","strike_rate":"125.00","bowler_id":"105570","first_fielder_id":"108634","second_fielder_id":"","third_fielder_id":""},{"name":"Natim Hassam","batsman_id":"146507","batting":"true","position":"striker","role":"bowl","role_str":"","runs":"21","balls_faced":"23","fours":"2","sixes":"0","run0":"9","run1":"11","run2":"1","run3":"0","run5":"0","how_out":"Not out","dismissal":"","strike_rate":"91.30","bowler_id":"0","first_fielder_id":"","second_fielder_id":"","third_fielder_id":""}],"bowlers":[{"name":"Mehboob Ali","bowler_id":"113263","bowling":"false","position":"","overs":"3","maidens":"0","runs_conceded":"32","wickets":"0","noballs":"0","wides":"2","econ":"10.67","run0":"4","bowledcount":"0","lbwcount":"0"},{"name":"David Marks","bowler_id":"104425","bowling":"false","position":"","overs":"3","maidens":"0","runs_conceded":"25","wickets":"1","noballs":"0","wides":"0","econ":"8.33","run0":"5","bowledcount":"0","lbwcount":"0"},{"name":"Jaswinder Singh","bowler_id":"105570","bowling":"false","position":"","overs":"2","maidens":"0","runs_conceded":"19","wickets":"1","noballs":"0","wides":"1","econ":"9.50","run0":"4","bowledcount":"0","lbwcount":"0"},{"name":"Varun Prasath","bowler_id":"123746","bowling":"false","position":"last bowler","overs":"4","maidens":"0","runs_conceded":"34","wickets":"0","noballs":"0","wides":"1","econ":"8.50","run0":"4","bowledcount":"0","lbwcount":"0"},{"name":"Priyan Pushparajan","bowler_id":"123727","bowling":"true","position":"active bowler","overs":"2.1","maidens":"0","runs_conceded":"10","wickets":"0","noballs":"0","wides":"0","econ":"4.62","run0":"7","bowledcount":"0","lbwcount":"0"}],"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"}},"fows":[{"name":"Dhavalkumar Norotam","batsman_id":"144220","runs":"8","balls":"5","how_out":"c S Patel b D Marks","score_at_dismissal":10,"overs_at_dismissal":"1.1","bowler_id":"104425","dismissal":"caught","number":1},{"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}],"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"}],"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":""}],"pre_match_odds":[],"day_remaining_over":"","match_notes":[["Malta inning 1","Powerplay 1 (0.1 - 6) Run 48, wicket 4","Malta: 50 runs in 6.2 overs.","Malta: 100 runs in 15.5 overs.","Innings Break: Malta - 120\/10 overs 17.2 (balls 104)."],["Portugal inning 2","Portugal: 50 runs in 4.6 overs.","Powerplay 1 (0.1 - 6) Run 57, wicket 1","50 run partnership of 30 balls,Sharn Gomes 28(16) runs, Chad Potgieter 20(14) runs.","Sharn Gomes 50 runs in 31 balls (4 x 3, 6 X 2).","Portugal: 100 runs in 11.1 overs.","50 run partnership of 40 balls,Natim Hassam 19(20) runs, Sharn Gomes 31(20) runs."]]},"etag":"34463875c39f284075b5c01e8a36e5a7","modified":"2025-06-28 20:44:47","datetime":"2025-06-28 20:44:47","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90281 AND DataTypeId = 2 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:cf152bad-1d9d-491a-9ea4-30863436a2a1 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90281 AND DataTypeId = 8) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90281,8,'{"status":"ok","response":{"teama":{"team_id":69724,"squads":[{"player_id":"123727","substitute":"false","out":"false","in":"false","role_str":"(C)","role":"all","playing11":"true","name":"Priyan Pushparajan"},{"player_id":"123716","substitute":"false","out":"false","in":"false","role_str":"(WK)","role":"wk","playing11":"true","name":"Chanjal Sudarsanan"},{"player_id":"112175","substitute":"false","out":"false","in":"false","role_str":"","role":"wk","playing11":"true","name":"Rockey Dianish"},{"player_id":"108634","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Shrijay Patel"},{"player_id":"108660","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Imran Ameer"},{"player_id":"123740","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Jamsheed Kunnanchirakkal"},{"player_id":"113263","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"Mehboob Ali"},{"player_id":"123746","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"Varun Prasath"},{"player_id":"130393","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"Eldhose Mathew"},{"player_id":"105570","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Jaswinder Singh"},{"player_id":"104425","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"David Marks"},{"player_id":"104590","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"false","name":"Darshit Patankar"},{"player_id":"144535","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"false","name":"Amar Sharma"},{"player_id":"129021","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"false","name":"Waseem Abbas"}]},"teamb":{"team_id":69725,"squads":[{"player_id":"144221","substitute":"false","out":"false","in":"false","role_str":"(WK\/C)","role":"all","playing11":"true","name":"Carlos Nunes"},{"player_id":"59325","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Sharn Gomes"},{"player_id":"144220","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Dhavalkumar Norotam"},{"player_id":"147639","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Hardeep Singh Khuttan"},{"player_id":"149122","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Chad Potgieter"},{"player_id":"146505","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"Rahulkumar Hashu"},{"player_id":"103302","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Mohammad Siraj Nipo"},{"player_id":"147765","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Upen Shantu"},{"player_id":"132855","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Juan Henri"},{"player_id":"96348","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Francoise Stoman"},{"player_id":"146507","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Natim Hassam"},{"player_id":"147679","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"false","name":"Sherman Vaz"},{"player_id":"124287","substitute":"false","out":"false","in":"false","role_str":"","role":"wk","playing11":"false","name":"Jalpesh Vijay"},{"player_id":"124996","substitute":"false","out":"false","in":"false","role_str":"","role":"wk","playing11":"false","name":"Miguel Machado"},{"player_id":"141026","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"false","name":"Jeremy Martins"}]},"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":""},{"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":""}],"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":"","nationality":"South Africa"},{"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":"","nationality":"Portugal"},{"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":"","nationality":"Portugal"},{"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":"","nationality":"International"},{"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":"","nationality":"International"},{"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":"","nationality":"Spain"},{"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":"","nationality":"International"},{"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":"","nationality":"International"},{"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":"","nationality":"International"},{"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":"","nationality":"International"},{"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":"","nationality":null},{"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":"","nationality":null},{"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":"","nationality":"India"},{"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":"","nationality":"International"},{"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":"","nationality":"Portugal"},{"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":"","nationality":"Portugal"},{"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":"","nationality":"International"},{"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":"","nationality":"International"},{"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":"","nationality":"Portugal"},{"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":"","nationality":"Portugal"},{"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":"","nationality":"Portugal"},{"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":"","nationality":"Portugal"},{"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":"","nationality":"Malta"},{"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":"","nationality":"Portugal"},{"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":"","nationality":"Portugal"},{"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":"","nationality":"Portugal"},{"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":"","nationality":"Portugal"},{"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":"","nationality":"Portugal"},{"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":"","nationality":"Portugal"}]},"etag":"34463875c39f284075b5c01e8a36e5a7","modified":"2025-06-28 20:44:47","datetime":"2025-06-28 20:44:47","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"teama":{"team_id":69724,"squads":[{"player_id":"123727","substitute":"false","out":"false","in":"false","role_str":"(C)","role":"all","playing11":"true","name":"Priyan Pushparajan"},{"player_id":"123716","substitute":"false","out":"false","in":"false","role_str":"(WK)","role":"wk","playing11":"true","name":"Chanjal Sudarsanan"},{"player_id":"112175","substitute":"false","out":"false","in":"false","role_str":"","role":"wk","playing11":"true","name":"Rockey Dianish"},{"player_id":"108634","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Shrijay Patel"},{"player_id":"108660","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Imran Ameer"},{"player_id":"123740","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Jamsheed Kunnanchirakkal"},{"player_id":"113263","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"Mehboob Ali"},{"player_id":"123746","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"Varun Prasath"},{"player_id":"130393","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"Eldhose Mathew"},{"player_id":"105570","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Jaswinder Singh"},{"player_id":"104425","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"David Marks"},{"player_id":"104590","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"false","name":"Darshit Patankar"},{"player_id":"144535","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"false","name":"Amar Sharma"},{"player_id":"129021","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"false","name":"Waseem Abbas"}]},"teamb":{"team_id":69725,"squads":[{"player_id":"144221","substitute":"false","out":"false","in":"false","role_str":"(WK\/C)","role":"all","playing11":"true","name":"Carlos Nunes"},{"player_id":"59325","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Sharn Gomes"},{"player_id":"144220","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Dhavalkumar Norotam"},{"player_id":"147639","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Hardeep Singh Khuttan"},{"player_id":"149122","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Chad Potgieter"},{"player_id":"146505","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"Rahulkumar Hashu"},{"player_id":"103302","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Mohammad Siraj Nipo"},{"player_id":"147765","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Upen Shantu"},{"player_id":"132855","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Juan Henri"},{"player_id":"96348","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Francoise Stoman"},{"player_id":"146507","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Natim Hassam"},{"player_id":"147679","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"false","name":"Sherman Vaz"},{"player_id":"124287","substitute":"false","out":"false","in":"false","role_str":"","role":"wk","playing11":"false","name":"Jalpesh Vijay"},{"player_id":"124996","substitute":"false","out":"false","in":"false","role_str":"","role":"wk","playing11":"false","name":"Miguel Machado"},{"player_id":"141026","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"false","name":"Jeremy Martins"}]},"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":""},{"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":""}],"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":"","nationality":"South Africa"},{"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":"","nationality":"Portugal"},{"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":"","nationality":"Portugal"},{"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":"","nationality":"International"},{"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":"","nationality":"International"},{"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":"","nationality":"Spain"},{"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":"","nationality":"International"},{"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":"","nationality":"International"},{"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":"","nationality":"International"},{"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":"","nationality":"International"},{"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":"","nationality":null},{"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":"","nationality":null},{"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":"","nationality":"India"},{"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":"","nationality":"International"},{"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":"","nationality":"Portugal"},{"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":"","nationality":"Portugal"},{"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":"","nationality":"International"},{"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":"","nationality":"International"},{"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":"","nationality":"Portugal"},{"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":"","nationality":"Portugal"},{"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":"","nationality":"Portugal"},{"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":"","nationality":"Portugal"},{"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":"","nationality":"Malta"},{"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":"","nationality":"Portugal"},{"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":"","nationality":"Portugal"},{"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":"","nationality":"Portugal"},{"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":"","nationality":"Portugal"},{"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":"","nationality":"Portugal"},{"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":"","nationality":"Portugal"}]},"etag":"34463875c39f284075b5c01e8a36e5a7","modified":"2025-06-28 20:44:47","datetime":"2025-06-28 20:44:47","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90281 AND DataTypeId = 8 END
Playing XI for Malta vs Portugal Match 2 2025