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:4714bafe-1505-419d-9374-4a564601a2a8
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86882 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86882,1,'{"status":"ok","response":{"mid":86882,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Middlesex won by 1 run","day_remaining_over":"","team_batting":"Essex","team_bowling":"Middlesex","live_inning_number":2,"live_score":{"runs":160,"overs":20,"wickets":6,"target":162,"runrate":8,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Charles Allison","batsman_id":134958,"runs":15,"balls_faced":11,"fours":1,"sixes":0,"strike_rate":"136.36"},{"name":"Noah Thain","batsman_id":127517,"runs":6,"balls_faced":3,"fours":0,"sixes":0,"strike_rate":"200.00"}],"bowlers":[{"name":"Tom Helm","bowler_id":49497,"overs":4,"runs_conceded":31,"wickets":2,"maidens":0,"econ":"7.75"},{"name":"Ryan Higgins","bowler_id":49930,"overs":2,"runs_conceded":21,"wickets":0,"maidens":0,"econ":"10.50"}],"commentaries":[{"event_id":"12175181","event":"ball","batsman_id":"134958","bowler_id":"140007","over":"16","ball":"2","score":1,"commentary":"Noah Cornwell to Charles Allison, 1 run,","noball_dismissal":false,"text":"","timestamp":1750363007,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12175182","event":"ball","batsman_id":"108420","bowler_id":"140007","over":"16","ball":"3","score":0,"commentary":"Noah Cornwell to Luc Benkenstein, no run,","noball_dismissal":false,"text":"","timestamp":1750363031,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12175184","event":"ball","batsman_id":"108420","bowler_id":"140007","over":"16","ball":"4","score":1,"commentary":"Noah Cornwell to Luc Benkenstein, 1 run,","noball_dismissal":false,"text":"","timestamp":1750363045,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12175188","event":"ball","batsman_id":"134958","bowler_id":"140007","over":"16","ball":"5","score":"1wd","commentary":"Noah Cornwell to Charles Allison, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750363082,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12175192","event":"ball","batsman_id":"134958","bowler_id":"140007","over":"16","ball":"5","score":0,"commentary":"Noah Cornwell to Charles Allison, no run,","noball_dismissal":false,"text":"","timestamp":1750363137,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12175198","event":"ball","batsman_id":"134958","bowler_id":"140007","over":"16","ball":"6","score":2,"commentary":"Noah Cornwell to Charles Allison, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750363162,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":17,"runs":5,"score":"133\/5","bats":[{"runs":3,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":134958},{"runs":15,"balls_faced":14,"fours":1,"sixes":0,"batsman_id":108420}],"bowls":[{"runs_conceded":26,"maidens":0,"wickets":1,"bowler_id":140007,"overs":3},{"runs_conceded":30,"maidens":0,"wickets":0,"bowler_id":93519,"overs":4}],"commentary":"End of over 17 (5 runs), Essex 133\/5"},{"event_id":"12175203","event":"ball","batsman_id":"108420","bowler_id":"49497","over":"17","ball":"1","score":"1b","commentary":"Tom Helm to Luc Benkenstein, 1 bye,","noball_dismissal":false,"text":"","timestamp":1750363245,"run":1,"noball_run":"0","wide_run":"0","bye_run":"1","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12175206","event":"ball","batsman_id":"134958","bowler_id":"49497","over":"17","ball":"2","score":2,"commentary":"Tom Helm to Charles Allison, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750363281,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12175212","event":"ball","batsman_id":"134958","bowler_id":"49497","over":"17","ball":"3","score":1,"commentary":"Tom Helm to Charles Allison, 1 run,","noball_dismissal":false,"text":"","timestamp":1750363324,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12175216","event":"ball","batsman_id":"108420","bowler_id":"49497","over":"17","ball":"4","score":1,"commentary":"Tom Helm to Luc Benkenstein, 1 run,","noball_dismissal":false,"text":"","timestamp":1750363365,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12175219","event":"ball","batsman_id":"134958","bowler_id":"49497","over":"17","ball":"5","score":0,"commentary":"Tom Helm to Charles Allison, no run,","noball_dismissal":false,"text":"","timestamp":1750363411,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12175221","event":"ball","batsman_id":"134958","bowler_id":"49497","over":"17","ball":"6","score":1,"commentary":"Tom Helm to Charles Allison, 1 run,","noball_dismissal":false,"text":"","timestamp":1750363437,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":18,"runs":6,"score":"139\/5","bats":[{"runs":7,"balls_faced":7,"fours":0,"sixes":0,"batsman_id":134958},{"runs":16,"balls_faced":16,"fours":1,"sixes":0,"batsman_id":108420}],"bowls":[{"runs_conceded":23,"maidens":0,"wickets":1,"bowler_id":49497,"overs":3},{"runs_conceded":26,"maidens":0,"wickets":1,"bowler_id":140007,"overs":3}],"commentary":"End of over 18 (6 runs), Essex 139\/5"},{"event_id":"12175235","event":"ball","batsman_id":"134958","bowler_id":"49930","over":"18","ball":"1","score":"1wd","commentary":"Ryan Higgins to Charles Allison, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750363583,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12175236","event":"ball","batsman_id":"134958","bowler_id":"49930","over":"18","ball":"1","score":"1wd","commentary":"Ryan Higgins to Charles Allison, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750363587,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12175242","event":"ball","batsman_id":"134958","bowler_id":"49930","over":"18","ball":"1","score":4,"commentary":"Ryan Higgins to Charles Allison, Four,","noball_dismissal":false,"text":"","timestamp":1750363601,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12175246","event":"ball","batsman_id":"134958","bowler_id":"49930","over":"18","ball":"2","score":2,"commentary":"Ryan Higgins to Charles Allison, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750363637,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12175250","event":"ball","batsman_id":"134958","bowler_id":"49930","over":"18","ball":"3","score":1,"commentary":"Ryan Higgins to Charles Allison, 1 run,","noball_dismissal":false,"text":"","timestamp":1750363666,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12175256","event":"ball","batsman_id":"108420","bowler_id":"49930","over":"18","ball":"4","score":0,"commentary":"Ryan Higgins to Luc Benkenstein, no run,","noball_dismissal":false,"text":"","timestamp":1750363715,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12175262","event":"ball","batsman_id":"108420","bowler_id":"49930","over":"18","ball":"5","score":0,"commentary":"Ryan Higgins to Luc Benkenstein, no run,","noball_dismissal":false,"text":"","timestamp":1750363797,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12175263","event":"ball","batsman_id":"108420","bowler_id":"49930","over":"18","ball":"6","score":4,"commentary":"Ryan Higgins to Luc Benkenstein, Four,","noball_dismissal":false,"text":"","timestamp":1750363805,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event":"overend","over":19,"runs":13,"score":"152\/5","bats":[{"runs":20,"balls_faced":19,"fours":2,"sixes":0,"batsman_id":108420},{"runs":14,"balls_faced":10,"fours":1,"sixes":0,"batsman_id":134958}],"bowls":[{"runs_conceded":21,"maidens":0,"wickets":0,"bowler_id":49930,"overs":2},{"runs_conceded":23,"maidens":0,"wickets":1,"bowler_id":49497,"overs":3}],"commentary":"End of over 19 (13 runs), Essex 152\/5"},{"event_id":"12175272","event":"ball","batsman_id":"134958","bowler_id":"49497","over":"19","ball":"1","score":1,"commentary":"Tom Helm to Charles Allison, 1 run,","noball_dismissal":false,"text":"","timestamp":1750363848,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12175275","event":"ball","batsman_id":"108420","bowler_id":"49497","over":"19","ball":"2","score":0,"commentary":"Tom Helm to Luc Benkenstein, no run,","noball_dismissal":false,"text":"","timestamp":1750363901,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12175283","event":"ball","batsman_id":"108420","bowler_id":"49497","over":"19","ball":"3","score":"1wd","commentary":"Tom Helm to Luc Benkenstein, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750363957,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12175287","event":"wicket","batsman_id":"108420","bowler_id":"49497","over":"19","ball":"3","score":"w","commentary":"Tom Helm to Luc Benkenstein, no run, c B Geddes b TG Helm,","noball_dismissal":false,"text":"","timestamp":1750364006,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"108420","how_out":"c B Geddes b TG Helm","batsman_runs":"20","batsman_balls":"21"},{"event_id":"12175291","event":"ball","batsman_id":"127517","bowler_id":"49497","over":"19","ball":"4","score":2,"commentary":"Tom Helm to Noah Thain, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750364045,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12175294","event":"ball","batsman_id":"127517","bowler_id":"49497","over":"19","ball":"5","score":2,"commentary":"Tom Helm to Noah Thain, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750364142,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12175295","event":"ball","batsman_id":"127517","bowler_id":"49497","over":"19","ball":"6","score":2,"commentary":"Tom Helm to Noah Thain, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750364165,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":20,"runs":8,"score":"160\/6","bats":[{"runs":6,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":127517},{"runs":15,"balls_faced":11,"fours":1,"sixes":0,"batsman_id":134958}],"bowls":[{"runs_conceded":31,"maidens":0,"wickets":2,"bowler_id":49497,"overs":4},{"runs_conceded":21,"maidens":0,"wickets":0,"bowler_id":49930,"overs":2}],"commentary":"End of over 20 (8 runs), Essex 160\/6"}],"day":"0","session":"0","live_inning":{"iid":198393,"number":2,"name":"Essex Inning","short_name":"ESS Inning","status":2,"issuperover":"false","result":4,"batting_team_id":104950,"fielding_team_id":7044,"scores":"160\/6","scores_full":"160\/6 (20 ov)","fielder":[{"fielder_id":"146171","fielder_name":"Naavya Sharma","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49930","fielder_name":"Ryan Higgins","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"31","fielder_name":"Kane Williamson","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"108382","fielder_name":"Ben Geddes","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Luc Benkenstein","batsman_id":"108420","runs":"20","balls":"21","how_out":"c B Geddes b TG Helm","score_at_dismissal":154,"overs_at_dismissal":"19.3","bowler_id":"49497","dismissal":"caught","number":6},"extra_runs":{"byes":1,"legbyes":1,"wides":11,"noballs":0,"penalty":"0","total":13},"equations":{"runs":160,"wickets":6,"overs":"20","bowlers_used":6,"runrate":"8.00"},"current_partnership":{"runs":6,"balls":3,"overs":0.3,"batsmen":[{"name":"Noah Thain","batsman_id":127517,"runs":6,"balls":3},{"name":"Charles Allison","batsman_id":134958,"runs":0,"balls":0}]},"did_not_bat":[{"player_id":"49087","name":"Simon Harmer"},{"player_id":"61358","name":"Shane Snater"},{"player_id":"1758","name":"Mohammad Amir"}],"max_over":"20","target":"162","recent_scores":"2,2,2,w,1,0,1,4,0,0,1,2,4,1,1,1,0,1","last_five_overs":"38\/2 6.71","last_ten_overs":"71\/4 6.66"},"teams":[{"tid":7044,"title":"Middlesex","abbr":"MID","alt_name":"MID","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/middlesex-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/middlesex-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"161\/10 (19.5 ov)","scores":"161\/10","overs":"19.5"},{"tid":104950,"title":"Essex","abbr":"ESS","alt_name":"ESS","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"160\/6 (20 ov)","scores":"160\/6","overs":"20"}],"players":[{"pid":31,"title":"Kane Williamson","short_name":"K Williamson","first_name":"Kane Williamson","last_name":"","middle_name":"","birthdate":"1990-08-08","birthplace":"Tauranga","country":"nz","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/KaneWillTrain\/","twitter_profile":"https:\/\/twitter.com\/KaneWiliamson","instagram_profile":"https:\/\/www.instagram.com\/kane_s_w\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bat","role_str":""},{"pid":1043,"title":"Max Holden","short_name":"MDE Holden","first_name":"Max Holden","last_name":"","middle_name":"","birthdate":"1997-12-18","birthplace":" Cambridge","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/maxholden_4","instagram_profile":"https:\/\/www.instagram.com\/maxholden4\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":1115,"title":"Josh Little","short_name":"JB Little","first_name":"Josh Little","last_name":"","middle_name":"","birthdate":"1999-11-01","birthplace":"Dublin","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/joshlittle13\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":1758,"title":"Mohammad Amir","short_name":"M Amir","first_name":"Mohammad Amir","last_name":"","middle_name":"","birthdate":"1992-04-13","birthplace":" Gujjar Khan, Punjab","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/iamamirofficial","instagram_profile":"https:\/\/www.instagram.com\/official.mamir\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bowl","role_str":""},{"pid":10592,"title":"Tom Westley","short_name":"TZ Westley","first_name":"Tom Westley","last_name":"","middle_name":"","birthdate":"1989-03-13","birthplace":"Cambridge","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":10602,"title":"Nick Browne","short_name":"NLJ Browne","first_name":"Nick Browne","last_name":"","middle_name":"","birthdate":"1991-03-24","birthplace":"Leytonstone, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","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":"England","role":"squad","role_str":""},{"pid":44058,"title":"Zafar Gohar","short_name":"ZG Gohar","first_name":"Zafar Gohar","last_name":"","middle_name":"","birthdate":"1995-02-01","birthplace":"Lahore, Punjab","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","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":"https:\/\/twitter.com\/iamzafargohar","instagram_profile":"https:\/\/www.instagram.com\/iamzafargohar\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bowl","role_str":""},{"pid":48647,"title":"Matt Critchley","short_name":"MJJ Critchley","first_name":"Matt Critchley","last_name":"","middle_name":"","birthdate":"1996-08-13","birthplace":"Preston, Lancashire","country":"en","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":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/mattcritchley96","instagram_profile":"https:\/\/www.instagram.com\/critch130896\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":49083,"title":"Dean Elgar","short_name":"D Elgar","first_name":"Dean Elgar","last_name":"","middle_name":"","birthdate":"1987-06-11","birthplace":"Welkom, Orange Free state","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":36249,"recent_appearance":1514287800,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BoringDeanElgar","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","role_str":""},{"pid":49087,"title":"Simon Harmer","short_name":"SR Harmer","first_name":"Simon Harmer","last_name":"","middle_name":"","birthdate":"1989-02-10","birthplace":"Pretoria, Transvaal","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Simon_Harmer_","instagram_profile":"https:\/\/www.instagram.com\/simon_harmer\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bowl","role_str":"(C)"},{"pid":49376,"title":"Adam Rossington","short_name":"AM Rossington","first_name":"Adam Rossington","last_name":"","middle_name":"","birthdate":"1993-05-05","birthplace":"Edgware, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper ","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Rossington17","instagram_profile":"https:\/\/www.instagram.com\/rossington17\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49493,"title":"Sam Robson","short_name":"SD Robson","first_name":"Sam Robson","last_name":"","middle_name":"","birthdate":"1989-07-01","birthplace":"Paddington, Sydney, New South Wales","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"https:\/\/www.facebook.com\/samrobson664\/","twitter_profile":"https:\/\/twitter.com\/Samrobsonfans12","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49497,"title":"Tom Helm","short_name":"TG Helm","first_name":"Tom Helm","last_name":"","middle_name":"","birthdate":"1994-05-07","birthplace":"Stoke Mandeville Hospital, Buckinghamshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/TomHelm7","instagram_profile":"https:\/\/www.instagram.com\/helmy__7\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49593,"title":"Jamie Porter","short_name":"JA Porter","first_name":"Jamie Porter","last_name":"","middle_name":"","birthdate":"1993-05-25","birthplace":"Leytonstone, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49783,"title":"Toby Roland-Jones","short_name":"TS Roland-Jones","first_name":"Toby Roland-Jones","last_name":"","middle_name":"","birthdate":"1988-01-29","birthplace":"Ashford, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/tobyrj21","instagram_profile":"https:\/\/www.instagram.com\/tobyrj21\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49930,"title":"Ryan Higgins","short_name":"RF Higgins","first_name":"Ryan Higgins","last_name":"","middle_name":"","birthdate":"1995-01-06","birthplace":"Harare, Zimbabwe","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":51105,"title":"Michael-Kyle Pepper","short_name":"MKS Pepper","first_name":"Michael-Kyle Pepper","last_name":"","middle_name":"","birthdate":"1998-06-25","birthplace":"Harlow, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/michael_pep\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":51346,"title":"Paul Walter","short_name":"PI Walter","first_name":"Paul Walter","last_name":"","middle_name":"","birthdate":"1994-05-28","birthplace":"Basildon, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","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":"England","role":"all","role_str":""},{"pid":53281,"title":"Leus du Plooy","short_name":"JLdu Plooy","first_name":"Leus du Plooy","last_name":"","middle_name":"","birthdate":"1995-01-12","birthplace":"Pretoria, Gauteng,","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":"https:\/\/twitter.com\/leusdup76","instagram_profile":"https:\/\/www.instagram.com\/leusdup76\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":61358,"title":"Shane Snater","short_name":"S Snater","first_name":"Shane Snater","last_name":"","middle_name":"","birthdate":"1996-03-24","birthplace":"Harare, Zimbabwe","country":"nl","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"bowl","role_str":""},{"pid":68691,"title":"Samuel Cook","short_name":"S Cook","first_name":"Samuel Cook","last_name":"","middle_name":"","birthdate":"1997-08-04","birthplace":"Chelmsford, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/samcook09","instagram_profile":"https:\/\/www.instagram.com\/s_cook16\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":90974,"title":"Henry Brookes","short_name":"HJH Brookes","first_name":"Henry Brookes","last_name":"","middle_name":"","birthdate":"1999-08-21","birthplace":"Solihull, Warwickshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BrookesHenry","instagram_profile":"https:\/\/www.instagram.com\/henry.brookes\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":93517,"title":"Jack Davies","short_name":"JLB Davies","first_name":"Jack Davies","last_name":"","middle_name":"","birthdate":"2000-03-30","birthplace":"Reading, Berkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/daviesjlb","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":93519,"title":"Luke Hollman","short_name":"LBK Hollman","first_name":"Luke Hollman","last_name":"","middle_name":"","birthdate":"2000-09-16","birthplace":"Islington, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/lukehollman56\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":94961,"title":"Jordan Cox","short_name":"J Cox","first_name":"Jordan Cox","last_name":"","middle_name":"","birthdate":"2000-10-21","birthplace":"Margate, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/jjordancox\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":95552,"title":"Blake Cullen","short_name":"B Cullen","first_name":"Blake Cullen","last_name":"","middle_name":"","birthdate":"2002-02-19","birthplace":" Isleworth, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":101478,"title":"Joe Benjamin Cracknell","short_name":"JB Cracknell","first_name":"Joe Benjamin Cracknell","last_name":"","middle_name":"","birthdate":"2000-03-16","birthplace":"Enfield, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/joe_cracknell\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":102540,"title":"Stephen Eskinazi","short_name":"S Eskinazi","first_name":"Stephen Eskinazi","last_name":"","middle_name":"","birthdate":"1994-03-28","birthplace":"Johannesburg, Transvaal, South Africa","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/seskinazi","instagram_profile":"https:\/\/www.instagram.com\/seskinazi\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(C)"},{"pid":103358,"title":"Robin Das","short_name":"RJ Das","first_name":"Robin Das","last_name":"","middle_name":"","birthdate":"2002-02-27","birthplace":"Leytonstone","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"https:\/\/www.facebook.com\/robindascricketer","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/robinigblue\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108382,"title":"Ben Geddes","short_name":"B Geddes","first_name":"Ben Geddes","last_name":"","middle_name":"","birthdate":"2001-07-31","birthplace":"Epsom, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":108393,"title":"Jamal Richards","short_name":"J Richards","first_name":"Jamal Richards","last_name":"","middle_name":"","birthdate":"2004-03-03","birthplace":"Edmonton, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108420,"title":"Luc Benkenstein","short_name":"L Benkenstein","first_name":"Luc Benkenstein","last_name":"","middle_name":"","birthdate":"2004-11-02","birthplace":"Durban","country":"en","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":"England","role":"all","role_str":""},{"pid":116661,"title":"Ishaan Kaushal","short_name":"I Kaushal","first_name":"Ishaan Kaushal","last_name":"","middle_name":"","birthdate":"2002-02-09","birthplace":"Hillingdon, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":127503,"title":"Josh De Caires","short_name":"J D caires","first_name":"Josh De Caires","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","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":"England","role":"squad","role_str":""},{"pid":127517,"title":"Noah Thain","short_name":"NRM Thain","first_name":"Noah Thain","last_name":"","middle_name":"","birthdate":"2005-01-13","birthplace":"Hitchinbrooke, Hertfordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":129244,"title":"Nathan Fernandes","short_name":"N Fernandes","first_name":"Nathan Fernandes","last_name":"","middle_name":"","birthdate":"2004-04-26","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":129447,"title":"Mackenzie Jones","short_name":"Mackenzie Jones","first_name":"Mackenzie Jones","last_name":"","middle_name":"","birthdate":"2005-03-06","birthplace":"","country":"sct","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":133782,"title":"Sebastian Morgan","short_name":"SB Morgan","first_name":"Sebastian Morgan","last_name":"","middle_name":"","birthdate":"2007-08-30","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":134958,"title":"Charles Allison","short_name":"CW Allison","first_name":"Charles Allison","last_name":"","middle_name":"","birthdate":"2005-03-02","birthplace":"Colchester, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":140007,"title":"Noah Cornwell","short_name":"N Cornwell","first_name":"Noah Cornwell","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"England","role":"bowl","role_str":""},{"pid":141341,"title":"Simon Fernandes","short_name":"Simon Fernandes","first_name":"Simon Fernandes","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":146167,"title":"Aaryan Sawant","short_name":"A Sawant","first_name":"Aaryan Sawant","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":146171,"title":"Naavya Sharma","short_name":"N Sharma","first_name":"Naavya Sharma","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""}]},"etag":"8d6648cb8b29469c8883ed3c3495a728","modified":"2025-07-09 17:23:08","datetime":"2025-07-09 17:23:08","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":86882,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Middlesex won by 1 run","day_remaining_over":"","team_batting":"Essex","team_bowling":"Middlesex","live_inning_number":2,"live_score":{"runs":160,"overs":20,"wickets":6,"target":162,"runrate":8,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Charles Allison","batsman_id":134958,"runs":15,"balls_faced":11,"fours":1,"sixes":0,"strike_rate":"136.36"},{"name":"Noah Thain","batsman_id":127517,"runs":6,"balls_faced":3,"fours":0,"sixes":0,"strike_rate":"200.00"}],"bowlers":[{"name":"Tom Helm","bowler_id":49497,"overs":4,"runs_conceded":31,"wickets":2,"maidens":0,"econ":"7.75"},{"name":"Ryan Higgins","bowler_id":49930,"overs":2,"runs_conceded":21,"wickets":0,"maidens":0,"econ":"10.50"}],"commentaries":[{"event_id":"12175181","event":"ball","batsman_id":"134958","bowler_id":"140007","over":"16","ball":"2","score":1,"commentary":"Noah Cornwell to Charles Allison, 1 run,","noball_dismissal":false,"text":"","timestamp":1750363007,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12175182","event":"ball","batsman_id":"108420","bowler_id":"140007","over":"16","ball":"3","score":0,"commentary":"Noah Cornwell to Luc Benkenstein, no run,","noball_dismissal":false,"text":"","timestamp":1750363031,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12175184","event":"ball","batsman_id":"108420","bowler_id":"140007","over":"16","ball":"4","score":1,"commentary":"Noah Cornwell to Luc Benkenstein, 1 run,","noball_dismissal":false,"text":"","timestamp":1750363045,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12175188","event":"ball","batsman_id":"134958","bowler_id":"140007","over":"16","ball":"5","score":"1wd","commentary":"Noah Cornwell to Charles Allison, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750363082,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12175192","event":"ball","batsman_id":"134958","bowler_id":"140007","over":"16","ball":"5","score":0,"commentary":"Noah Cornwell to Charles Allison, no run,","noball_dismissal":false,"text":"","timestamp":1750363137,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12175198","event":"ball","batsman_id":"134958","bowler_id":"140007","over":"16","ball":"6","score":2,"commentary":"Noah Cornwell to Charles Allison, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750363162,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":17,"runs":5,"score":"133\/5","bats":[{"runs":3,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":134958},{"runs":15,"balls_faced":14,"fours":1,"sixes":0,"batsman_id":108420}],"bowls":[{"runs_conceded":26,"maidens":0,"wickets":1,"bowler_id":140007,"overs":3},{"runs_conceded":30,"maidens":0,"wickets":0,"bowler_id":93519,"overs":4}],"commentary":"End of over 17 (5 runs), Essex 133\/5"},{"event_id":"12175203","event":"ball","batsman_id":"108420","bowler_id":"49497","over":"17","ball":"1","score":"1b","commentary":"Tom Helm to Luc Benkenstein, 1 bye,","noball_dismissal":false,"text":"","timestamp":1750363245,"run":1,"noball_run":"0","wide_run":"0","bye_run":"1","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12175206","event":"ball","batsman_id":"134958","bowler_id":"49497","over":"17","ball":"2","score":2,"commentary":"Tom Helm to Charles Allison, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750363281,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12175212","event":"ball","batsman_id":"134958","bowler_id":"49497","over":"17","ball":"3","score":1,"commentary":"Tom Helm to Charles Allison, 1 run,","noball_dismissal":false,"text":"","timestamp":1750363324,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12175216","event":"ball","batsman_id":"108420","bowler_id":"49497","over":"17","ball":"4","score":1,"commentary":"Tom Helm to Luc Benkenstein, 1 run,","noball_dismissal":false,"text":"","timestamp":1750363365,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12175219","event":"ball","batsman_id":"134958","bowler_id":"49497","over":"17","ball":"5","score":0,"commentary":"Tom Helm to Charles Allison, no run,","noball_dismissal":false,"text":"","timestamp":1750363411,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12175221","event":"ball","batsman_id":"134958","bowler_id":"49497","over":"17","ball":"6","score":1,"commentary":"Tom Helm to Charles Allison, 1 run,","noball_dismissal":false,"text":"","timestamp":1750363437,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":18,"runs":6,"score":"139\/5","bats":[{"runs":7,"balls_faced":7,"fours":0,"sixes":0,"batsman_id":134958},{"runs":16,"balls_faced":16,"fours":1,"sixes":0,"batsman_id":108420}],"bowls":[{"runs_conceded":23,"maidens":0,"wickets":1,"bowler_id":49497,"overs":3},{"runs_conceded":26,"maidens":0,"wickets":1,"bowler_id":140007,"overs":3}],"commentary":"End of over 18 (6 runs), Essex 139\/5"},{"event_id":"12175235","event":"ball","batsman_id":"134958","bowler_id":"49930","over":"18","ball":"1","score":"1wd","commentary":"Ryan Higgins to Charles Allison, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750363583,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12175236","event":"ball","batsman_id":"134958","bowler_id":"49930","over":"18","ball":"1","score":"1wd","commentary":"Ryan Higgins to Charles Allison, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750363587,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12175242","event":"ball","batsman_id":"134958","bowler_id":"49930","over":"18","ball":"1","score":4,"commentary":"Ryan Higgins to Charles Allison, Four,","noball_dismissal":false,"text":"","timestamp":1750363601,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12175246","event":"ball","batsman_id":"134958","bowler_id":"49930","over":"18","ball":"2","score":2,"commentary":"Ryan Higgins to Charles Allison, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750363637,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12175250","event":"ball","batsman_id":"134958","bowler_id":"49930","over":"18","ball":"3","score":1,"commentary":"Ryan Higgins to Charles Allison, 1 run,","noball_dismissal":false,"text":"","timestamp":1750363666,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12175256","event":"ball","batsman_id":"108420","bowler_id":"49930","over":"18","ball":"4","score":0,"commentary":"Ryan Higgins to Luc Benkenstein, no run,","noball_dismissal":false,"text":"","timestamp":1750363715,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12175262","event":"ball","batsman_id":"108420","bowler_id":"49930","over":"18","ball":"5","score":0,"commentary":"Ryan Higgins to Luc Benkenstein, no run,","noball_dismissal":false,"text":"","timestamp":1750363797,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12175263","event":"ball","batsman_id":"108420","bowler_id":"49930","over":"18","ball":"6","score":4,"commentary":"Ryan Higgins to Luc Benkenstein, Four,","noball_dismissal":false,"text":"","timestamp":1750363805,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event":"overend","over":19,"runs":13,"score":"152\/5","bats":[{"runs":20,"balls_faced":19,"fours":2,"sixes":0,"batsman_id":108420},{"runs":14,"balls_faced":10,"fours":1,"sixes":0,"batsman_id":134958}],"bowls":[{"runs_conceded":21,"maidens":0,"wickets":0,"bowler_id":49930,"overs":2},{"runs_conceded":23,"maidens":0,"wickets":1,"bowler_id":49497,"overs":3}],"commentary":"End of over 19 (13 runs), Essex 152\/5"},{"event_id":"12175272","event":"ball","batsman_id":"134958","bowler_id":"49497","over":"19","ball":"1","score":1,"commentary":"Tom Helm to Charles Allison, 1 run,","noball_dismissal":false,"text":"","timestamp":1750363848,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12175275","event":"ball","batsman_id":"108420","bowler_id":"49497","over":"19","ball":"2","score":0,"commentary":"Tom Helm to Luc Benkenstein, no run,","noball_dismissal":false,"text":"","timestamp":1750363901,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12175283","event":"ball","batsman_id":"108420","bowler_id":"49497","over":"19","ball":"3","score":"1wd","commentary":"Tom Helm to Luc Benkenstein, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750363957,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12175287","event":"wicket","batsman_id":"108420","bowler_id":"49497","over":"19","ball":"3","score":"w","commentary":"Tom Helm to Luc Benkenstein, no run, c B Geddes b TG Helm,","noball_dismissal":false,"text":"","timestamp":1750364006,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"108420","how_out":"c B Geddes b TG Helm","batsman_runs":"20","batsman_balls":"21"},{"event_id":"12175291","event":"ball","batsman_id":"127517","bowler_id":"49497","over":"19","ball":"4","score":2,"commentary":"Tom Helm to Noah Thain, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750364045,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12175294","event":"ball","batsman_id":"127517","bowler_id":"49497","over":"19","ball":"5","score":2,"commentary":"Tom Helm to Noah Thain, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750364142,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12175295","event":"ball","batsman_id":"127517","bowler_id":"49497","over":"19","ball":"6","score":2,"commentary":"Tom Helm to Noah Thain, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750364165,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":20,"runs":8,"score":"160\/6","bats":[{"runs":6,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":127517},{"runs":15,"balls_faced":11,"fours":1,"sixes":0,"batsman_id":134958}],"bowls":[{"runs_conceded":31,"maidens":0,"wickets":2,"bowler_id":49497,"overs":4},{"runs_conceded":21,"maidens":0,"wickets":0,"bowler_id":49930,"overs":2}],"commentary":"End of over 20 (8 runs), Essex 160\/6"}],"day":"0","session":"0","live_inning":{"iid":198393,"number":2,"name":"Essex Inning","short_name":"ESS Inning","status":2,"issuperover":"false","result":4,"batting_team_id":104950,"fielding_team_id":7044,"scores":"160\/6","scores_full":"160\/6 (20 ov)","fielder":[{"fielder_id":"146171","fielder_name":"Naavya Sharma","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"49930","fielder_name":"Ryan Higgins","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"31","fielder_name":"Kane Williamson","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"108382","fielder_name":"Ben Geddes","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Luc Benkenstein","batsman_id":"108420","runs":"20","balls":"21","how_out":"c B Geddes b TG Helm","score_at_dismissal":154,"overs_at_dismissal":"19.3","bowler_id":"49497","dismissal":"caught","number":6},"extra_runs":{"byes":1,"legbyes":1,"wides":11,"noballs":0,"penalty":"0","total":13},"equations":{"runs":160,"wickets":6,"overs":"20","bowlers_used":6,"runrate":"8.00"},"current_partnership":{"runs":6,"balls":3,"overs":0.3,"batsmen":[{"name":"Noah Thain","batsman_id":127517,"runs":6,"balls":3},{"name":"Charles Allison","batsman_id":134958,"runs":0,"balls":0}]},"did_not_bat":[{"player_id":"49087","name":"Simon Harmer"},{"player_id":"61358","name":"Shane Snater"},{"player_id":"1758","name":"Mohammad Amir"}],"max_over":"20","target":"162","recent_scores":"2,2,2,w,1,0,1,4,0,0,1,2,4,1,1,1,0,1","last_five_overs":"38\/2 6.71","last_ten_overs":"71\/4 6.66"},"teams":[{"tid":7044,"title":"Middlesex","abbr":"MID","alt_name":"MID","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/middlesex-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/middlesex-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"161\/10 (19.5 ov)","scores":"161\/10","overs":"19.5"},{"tid":104950,"title":"Essex","abbr":"ESS","alt_name":"ESS","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"160\/6 (20 ov)","scores":"160\/6","overs":"20"}],"players":[{"pid":31,"title":"Kane Williamson","short_name":"K Williamson","first_name":"Kane Williamson","last_name":"","middle_name":"","birthdate":"1990-08-08","birthplace":"Tauranga","country":"nz","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/KaneWillTrain\/","twitter_profile":"https:\/\/twitter.com\/KaneWiliamson","instagram_profile":"https:\/\/www.instagram.com\/kane_s_w\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bat","role_str":""},{"pid":1043,"title":"Max Holden","short_name":"MDE Holden","first_name":"Max Holden","last_name":"","middle_name":"","birthdate":"1997-12-18","birthplace":" Cambridge","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/maxholden_4","instagram_profile":"https:\/\/www.instagram.com\/maxholden4\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":1115,"title":"Josh Little","short_name":"JB Little","first_name":"Josh Little","last_name":"","middle_name":"","birthdate":"1999-11-01","birthplace":"Dublin","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/joshlittle13\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":1758,"title":"Mohammad Amir","short_name":"M Amir","first_name":"Mohammad Amir","last_name":"","middle_name":"","birthdate":"1992-04-13","birthplace":" Gujjar Khan, Punjab","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/iamamirofficial","instagram_profile":"https:\/\/www.instagram.com\/official.mamir\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bowl","role_str":""},{"pid":10592,"title":"Tom Westley","short_name":"TZ Westley","first_name":"Tom Westley","last_name":"","middle_name":"","birthdate":"1989-03-13","birthplace":"Cambridge","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":10602,"title":"Nick Browne","short_name":"NLJ Browne","first_name":"Nick Browne","last_name":"","middle_name":"","birthdate":"1991-03-24","birthplace":"Leytonstone, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","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":"England","role":"squad","role_str":""},{"pid":44058,"title":"Zafar Gohar","short_name":"ZG Gohar","first_name":"Zafar Gohar","last_name":"","middle_name":"","birthdate":"1995-02-01","birthplace":"Lahore, Punjab","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","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":"https:\/\/twitter.com\/iamzafargohar","instagram_profile":"https:\/\/www.instagram.com\/iamzafargohar\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bowl","role_str":""},{"pid":48647,"title":"Matt Critchley","short_name":"MJJ Critchley","first_name":"Matt Critchley","last_name":"","middle_name":"","birthdate":"1996-08-13","birthplace":"Preston, Lancashire","country":"en","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":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/mattcritchley96","instagram_profile":"https:\/\/www.instagram.com\/critch130896\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":49083,"title":"Dean Elgar","short_name":"D Elgar","first_name":"Dean Elgar","last_name":"","middle_name":"","birthdate":"1987-06-11","birthplace":"Welkom, Orange Free state","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":36249,"recent_appearance":1514287800,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BoringDeanElgar","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","role_str":""},{"pid":49087,"title":"Simon Harmer","short_name":"SR Harmer","first_name":"Simon Harmer","last_name":"","middle_name":"","birthdate":"1989-02-10","birthplace":"Pretoria, Transvaal","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Simon_Harmer_","instagram_profile":"https:\/\/www.instagram.com\/simon_harmer\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bowl","role_str":"(C)"},{"pid":49376,"title":"Adam Rossington","short_name":"AM Rossington","first_name":"Adam Rossington","last_name":"","middle_name":"","birthdate":"1993-05-05","birthplace":"Edgware, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper ","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Rossington17","instagram_profile":"https:\/\/www.instagram.com\/rossington17\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49493,"title":"Sam Robson","short_name":"SD Robson","first_name":"Sam Robson","last_name":"","middle_name":"","birthdate":"1989-07-01","birthplace":"Paddington, Sydney, New South Wales","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"https:\/\/www.facebook.com\/samrobson664\/","twitter_profile":"https:\/\/twitter.com\/Samrobsonfans12","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49497,"title":"Tom Helm","short_name":"TG Helm","first_name":"Tom Helm","last_name":"","middle_name":"","birthdate":"1994-05-07","birthplace":"Stoke Mandeville Hospital, Buckinghamshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/TomHelm7","instagram_profile":"https:\/\/www.instagram.com\/helmy__7\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49593,"title":"Jamie Porter","short_name":"JA Porter","first_name":"Jamie Porter","last_name":"","middle_name":"","birthdate":"1993-05-25","birthplace":"Leytonstone, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49783,"title":"Toby Roland-Jones","short_name":"TS Roland-Jones","first_name":"Toby Roland-Jones","last_name":"","middle_name":"","birthdate":"1988-01-29","birthplace":"Ashford, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/tobyrj21","instagram_profile":"https:\/\/www.instagram.com\/tobyrj21\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49930,"title":"Ryan Higgins","short_name":"RF Higgins","first_name":"Ryan Higgins","last_name":"","middle_name":"","birthdate":"1995-01-06","birthplace":"Harare, Zimbabwe","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":51105,"title":"Michael-Kyle Pepper","short_name":"MKS Pepper","first_name":"Michael-Kyle Pepper","last_name":"","middle_name":"","birthdate":"1998-06-25","birthplace":"Harlow, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/michael_pep\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":51346,"title":"Paul Walter","short_name":"PI Walter","first_name":"Paul Walter","last_name":"","middle_name":"","birthdate":"1994-05-28","birthplace":"Basildon, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","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":"England","role":"all","role_str":""},{"pid":53281,"title":"Leus du Plooy","short_name":"JLdu Plooy","first_name":"Leus du Plooy","last_name":"","middle_name":"","birthdate":"1995-01-12","birthplace":"Pretoria, Gauteng,","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":"https:\/\/twitter.com\/leusdup76","instagram_profile":"https:\/\/www.instagram.com\/leusdup76\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":61358,"title":"Shane Snater","short_name":"S Snater","first_name":"Shane Snater","last_name":"","middle_name":"","birthdate":"1996-03-24","birthplace":"Harare, Zimbabwe","country":"nl","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"bowl","role_str":""},{"pid":68691,"title":"Samuel Cook","short_name":"S Cook","first_name":"Samuel Cook","last_name":"","middle_name":"","birthdate":"1997-08-04","birthplace":"Chelmsford, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/samcook09","instagram_profile":"https:\/\/www.instagram.com\/s_cook16\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":90974,"title":"Henry Brookes","short_name":"HJH Brookes","first_name":"Henry Brookes","last_name":"","middle_name":"","birthdate":"1999-08-21","birthplace":"Solihull, Warwickshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BrookesHenry","instagram_profile":"https:\/\/www.instagram.com\/henry.brookes\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":93517,"title":"Jack Davies","short_name":"JLB Davies","first_name":"Jack Davies","last_name":"","middle_name":"","birthdate":"2000-03-30","birthplace":"Reading, Berkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/daviesjlb","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":93519,"title":"Luke Hollman","short_name":"LBK Hollman","first_name":"Luke Hollman","last_name":"","middle_name":"","birthdate":"2000-09-16","birthplace":"Islington, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/lukehollman56\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":94961,"title":"Jordan Cox","short_name":"J Cox","first_name":"Jordan Cox","last_name":"","middle_name":"","birthdate":"2000-10-21","birthplace":"Margate, Kent","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/jjordancox\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":95552,"title":"Blake Cullen","short_name":"B Cullen","first_name":"Blake Cullen","last_name":"","middle_name":"","birthdate":"2002-02-19","birthplace":" Isleworth, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":101478,"title":"Joe Benjamin Cracknell","short_name":"JB Cracknell","first_name":"Joe Benjamin Cracknell","last_name":"","middle_name":"","birthdate":"2000-03-16","birthplace":"Enfield, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/joe_cracknell\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":102540,"title":"Stephen Eskinazi","short_name":"S Eskinazi","first_name":"Stephen Eskinazi","last_name":"","middle_name":"","birthdate":"1994-03-28","birthplace":"Johannesburg, Transvaal, South Africa","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/seskinazi","instagram_profile":"https:\/\/www.instagram.com\/seskinazi\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(C)"},{"pid":103358,"title":"Robin Das","short_name":"RJ Das","first_name":"Robin Das","last_name":"","middle_name":"","birthdate":"2002-02-27","birthplace":"Leytonstone","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"https:\/\/www.facebook.com\/robindascricketer","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/robinigblue\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108382,"title":"Ben Geddes","short_name":"B Geddes","first_name":"Ben Geddes","last_name":"","middle_name":"","birthdate":"2001-07-31","birthplace":"Epsom, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":108393,"title":"Jamal Richards","short_name":"J Richards","first_name":"Jamal Richards","last_name":"","middle_name":"","birthdate":"2004-03-03","birthplace":"Edmonton, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108420,"title":"Luc Benkenstein","short_name":"L Benkenstein","first_name":"Luc Benkenstein","last_name":"","middle_name":"","birthdate":"2004-11-02","birthplace":"Durban","country":"en","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":"England","role":"all","role_str":""},{"pid":116661,"title":"Ishaan Kaushal","short_name":"I Kaushal","first_name":"Ishaan Kaushal","last_name":"","middle_name":"","birthdate":"2002-02-09","birthplace":"Hillingdon, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":127503,"title":"Josh De Caires","short_name":"J D caires","first_name":"Josh De Caires","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","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":"England","role":"squad","role_str":""},{"pid":127517,"title":"Noah Thain","short_name":"NRM Thain","first_name":"Noah Thain","last_name":"","middle_name":"","birthdate":"2005-01-13","birthplace":"Hitchinbrooke, Hertfordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":129244,"title":"Nathan Fernandes","short_name":"N Fernandes","first_name":"Nathan Fernandes","last_name":"","middle_name":"","birthdate":"2004-04-26","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":129447,"title":"Mackenzie Jones","short_name":"Mackenzie Jones","first_name":"Mackenzie Jones","last_name":"","middle_name":"","birthdate":"2005-03-06","birthplace":"","country":"sct","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":133782,"title":"Sebastian Morgan","short_name":"SB Morgan","first_name":"Sebastian Morgan","last_name":"","middle_name":"","birthdate":"2007-08-30","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":134958,"title":"Charles Allison","short_name":"CW Allison","first_name":"Charles Allison","last_name":"","middle_name":"","birthdate":"2005-03-02","birthplace":"Colchester, Essex","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":140007,"title":"Noah Cornwell","short_name":"N Cornwell","first_name":"Noah Cornwell","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"England","role":"bowl","role_str":""},{"pid":141341,"title":"Simon Fernandes","short_name":"Simon Fernandes","first_name":"Simon Fernandes","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":146167,"title":"Aaryan Sawant","short_name":"A Sawant","first_name":"Aaryan Sawant","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":146171,"title":"Naavya Sharma","short_name":"N Sharma","first_name":"Naavya Sharma","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""}]},"etag":"8d6648cb8b29469c8883ed3c3495a728","modified":"2025-07-09 17:23:08","datetime":"2025-07-09 17:23:08","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86882 AND DataTypeId = 1 END
System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'StatusId'.
Invalid column name 'ErrorLog'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Etoz.ConnectData.DataAccess.ExecuteQuery(String query) in c:\inetpub\wwwroot\cricdirect.com\api\v6\App_Code\db\data_access.cs:line 117
ClientConnectionId:4714bafe-1505-419d-9374-4a564601a2a8
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86882 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86882,3,'{"status":"ok","response":{"match_id":86882,"title":"Middlesex vs Essex","short_title":"MID vs ESS","subtitle":"Match 62","match_number":"62","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Middlesex won by 1 run","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129425,"title":"Vitality Blast","abbr":"Vitality Blast","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-09-13","country":"en","total_matches":"133","total_rounds":"2","total_teams":"18"},"teama":{"team_id":7044,"name":"Middlesex","short_name":"MID","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/middlesex-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/middlesex-logo.png","scores_full":"161\/10 (19.5 ov)","scores":"161\/10","overs":"19.5"},"teamb":{"team_id":104950,"name":"Essex","short_name":"ESS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","scores_full":"160\/6 (20 ov)","scores":"160\/6","overs":"20"},"date_start":"2025-06-19 17:15:00","date_end":"2025-06-20 03:15:00","timestamp_start":1750353300,"timestamp_end":1750389300,"date_start_ist":"2025-06-19 22:45:00","date_end_ist":"2025-06-20 08:45:00","venue":{"venue_id":"30","name":"Lord''s","location":"London","country":"England","timezone":""},"umpires":"Paul Pollard (England), Chris Watts (England)","referee":"James Whitaker (England)","equation":"","live":"","result":"MID won by 1 run","result_type":1,"win_margin":"1 run","winning_team_id":7044,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-18 00:50:17","verify_time":"2025-06-20 02:03:07","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"scattered clouds","temp":20.64,"humidity":58,"visibility":10000,"wind_speed":"8.77","clouds":50},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Essex elected to bowl","winner":104950,"decision":2}},"etag":"fc2e9a83dad97fbf561854e369a19c56","modified":"2025-07-09 17:23:09","datetime":"2025-07-09 17:23:09","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":86882,"title":"Middlesex vs Essex","short_title":"MID vs ESS","subtitle":"Match 62","match_number":"62","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Middlesex won by 1 run","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129425,"title":"Vitality Blast","abbr":"Vitality Blast","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-09-13","country":"en","total_matches":"133","total_rounds":"2","total_teams":"18"},"teama":{"team_id":7044,"name":"Middlesex","short_name":"MID","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/middlesex-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/middlesex-logo.png","scores_full":"161\/10 (19.5 ov)","scores":"161\/10","overs":"19.5"},"teamb":{"team_id":104950,"name":"Essex","short_name":"ESS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/essex-logo.png","scores_full":"160\/6 (20 ov)","scores":"160\/6","overs":"20"},"date_start":"2025-06-19 17:15:00","date_end":"2025-06-20 03:15:00","timestamp_start":1750353300,"timestamp_end":1750389300,"date_start_ist":"2025-06-19 22:45:00","date_end_ist":"2025-06-20 08:45:00","venue":{"venue_id":"30","name":"Lord''s","location":"London","country":"England","timezone":""},"umpires":"Paul Pollard (England), Chris Watts (England)","referee":"James Whitaker (England)","equation":"","live":"","result":"MID won by 1 run","result_type":1,"win_margin":"1 run","winning_team_id":7044,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-18 00:50:17","verify_time":"2025-06-20 02:03:07","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"scattered clouds","temp":20.64,"humidity":58,"visibility":10000,"wind_speed":"8.77","clouds":50},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Essex elected to bowl","winner":104950,"decision":2}},"etag":"fc2e9a83dad97fbf561854e369a19c56","modified":"2025-07-09 17:23:09","datetime":"2025-07-09 17:23:09","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86882 AND DataTypeId = 3 END Live Report & Scorecard of Middlesex vs Essex Match 62