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:f67e76e5-5085-44ee-827a-df39ef0d6122
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 88193 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (88193,1,'{"status":"ok","response":{"mid":88193,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Match Drawn","day_remaining_over":"15","team_batting":"Kent","team_bowling":"Northamptonshire","live_inning_number":3,"live_score":{"runs":160,"overs":61,"wickets":8,"target":0,"runrate":2.62,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Tawanda Muyeye","batsman_id":107792,"runs":9,"balls_faced":17,"fours":1,"sixes":0,"strike_rate":"52.94"},{"name":"Joey Evison","batsman_id":95553,"runs":49,"balls_faced":104,"fours":6,"sixes":0,"strike_rate":"47.12"}],"bowlers":[{"name":"Calvin Harrison","bowler_id":50422,"overs":23,"runs_conceded":59,"wickets":3,"maidens":5,"econ":"2.57"},{"name":"Yuzvendra Chahal","bowler_id":654,"overs":30,"runs_conceded":51,"wickets":4,"maidens":6,"econ":"1.70"}],"commentaries":[{"event_id":"12274478","event":"ball","batsman_id":"95553","bowler_id":"50422","over":"56","ball":"5","score":0,"commentary":"Calvin Harrison to Joey Evison, no run,","noball_dismissal":false,"text":"","timestamp":1751474565,"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":"12274486","event":"ball","batsman_id":"95553","bowler_id":"50422","over":"56","ball":"6","score":0,"commentary":"Calvin Harrison to Joey Evison, no run,","noball_dismissal":false,"text":"","timestamp":1751474568,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":57,"runs":3,"score":"140\/8","bats":[{"runs":37,"balls_faced":93,"fours":4,"sixes":0,"batsman_id":95553},{"runs":1,"balls_faced":4,"fours":0,"sixes":0,"batsman_id":107792}],"bowls":[{"runs_conceded":45,"maidens":5,"wickets":3,"bowler_id":50422,"overs":21},{"runs_conceded":42,"maidens":6,"wickets":4,"bowler_id":654,"overs":28}],"commentary":"End of over 57 (3 runs), Kent 140\/8"},{"event_id":"12274490","event":"ball","batsman_id":"107792","bowler_id":"654","over":"57","ball":"1","score":0,"commentary":"Yuzvendra Chahal to Tawanda Muyeye, no run,","noball_dismissal":false,"text":"","timestamp":1751474571,"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":"12274491","event":"ball","batsman_id":"107792","bowler_id":"654","over":"57","ball":"2","score":1,"commentary":"Yuzvendra Chahal to Tawanda Muyeye, 1 run,","noball_dismissal":false,"text":"","timestamp":1751474574,"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":"12274492","event":"ball","batsman_id":"95553","bowler_id":"654","over":"57","ball":"3","score":4,"commentary":"Yuzvendra Chahal to Joey Evison, Four,","noball_dismissal":false,"text":"","timestamp":1751474603,"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":"12274494","event":"ball","batsman_id":"95553","bowler_id":"654","over":"57","ball":"4","score":0,"commentary":"Yuzvendra Chahal to Joey Evison, no run,","noball_dismissal":false,"text":"","timestamp":1751474606,"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":"12274496","event":"ball","batsman_id":"95553","bowler_id":"654","over":"57","ball":"5","score":0,"commentary":"Yuzvendra Chahal to Joey Evison, no run,","noball_dismissal":false,"text":"","timestamp":1751474611,"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":"12274497","event":"ball","batsman_id":"95553","bowler_id":"654","over":"57","ball":"6","score":0,"commentary":"Yuzvendra Chahal to Joey Evison, no run,","noball_dismissal":false,"text":"","timestamp":1751474626,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":58,"runs":5,"score":"145\/8","bats":[{"runs":41,"balls_faced":97,"fours":5,"sixes":0,"batsman_id":95553},{"runs":2,"balls_faced":6,"fours":0,"sixes":0,"batsman_id":107792}],"bowls":[{"runs_conceded":47,"maidens":6,"wickets":4,"bowler_id":654,"overs":29},{"runs_conceded":45,"maidens":5,"wickets":3,"bowler_id":50422,"overs":21}],"commentary":"End of over 58 (5 runs), Kent 145\/8"},{"event_id":"12274504","event":"ball","batsman_id":"107792","bowler_id":"50422","over":"58","ball":"1","score":4,"commentary":"Calvin Harrison to Tawanda Muyeye, Four,","noball_dismissal":false,"text":"","timestamp":1751474730,"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":"12274513","event":"ball","batsman_id":"107792","bowler_id":"50422","over":"58","ball":"2","score":0,"commentary":"Calvin Harrison to Tawanda Muyeye, no run,","noball_dismissal":false,"text":"","timestamp":1751474735,"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":"12274516","event":"ball","batsman_id":"107792","bowler_id":"50422","over":"58","ball":"3","score":0,"commentary":"Calvin Harrison to Tawanda Muyeye, no run,","noball_dismissal":false,"text":"","timestamp":1751474740,"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":"12274517","event":"ball","batsman_id":"107792","bowler_id":"50422","over":"58","ball":"4","score":0,"commentary":"Calvin Harrison to Tawanda Muyeye, no run,","noball_dismissal":false,"text":"","timestamp":1751474744,"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":"12274518","event":"ball","batsman_id":"107792","bowler_id":"50422","over":"58","ball":"5","score":1,"commentary":"Calvin Harrison to Tawanda Muyeye, 1 run,","noball_dismissal":false,"text":"","timestamp":1751474773,"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":"12274523","event":"ball","batsman_id":"95553","bowler_id":"50422","over":"58","ball":"6","score":0,"commentary":"Calvin Harrison to Joey Evison, no run,","noball_dismissal":false,"text":"","timestamp":1751475121,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":59,"runs":5,"score":"150\/8","bats":[{"runs":41,"balls_faced":98,"fours":5,"sixes":0,"batsman_id":95553},{"runs":7,"balls_faced":11,"fours":1,"sixes":0,"batsman_id":107792}],"bowls":[{"runs_conceded":50,"maidens":5,"wickets":3,"bowler_id":50422,"overs":22},{"runs_conceded":47,"maidens":6,"wickets":4,"bowler_id":654,"overs":29}],"commentary":"End of over 59 (5 runs), Kent 150\/8"},{"event_id":"12274557","event":"ball","batsman_id":"107792","bowler_id":"654","over":"59","ball":"1","score":0,"commentary":"Yuzvendra Chahal to Tawanda Muyeye, no run,","noball_dismissal":false,"text":"","timestamp":1751475133,"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":"12274558","event":"ball","batsman_id":"107792","bowler_id":"654","over":"59","ball":"2","score":0,"commentary":"Yuzvendra Chahal to Tawanda Muyeye, no run,","noball_dismissal":false,"text":"","timestamp":1751475136,"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":"12274559","event":"ball","batsman_id":"107792","bowler_id":"654","over":"59","ball":"3","score":0,"commentary":"Yuzvendra Chahal to Tawanda Muyeye, no run,","noball_dismissal":false,"text":"","timestamp":1751475139,"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":"12274561","event":"ball","batsman_id":"107792","bowler_id":"654","over":"59","ball":"4","score":1,"commentary":"Yuzvendra Chahal to Tawanda Muyeye, 1 run,","noball_dismissal":false,"text":"","timestamp":1751475142,"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":"12274562","event":"ball","batsman_id":"95553","bowler_id":"654","over":"59","ball":"5","score":0,"commentary":"Yuzvendra Chahal to Joey Evison, no run,","noball_dismissal":false,"text":"","timestamp":1751475146,"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":"12274563","event":"ball","batsman_id":"95553","bowler_id":"654","over":"59","ball":"6","score":0,"commentary":"Yuzvendra Chahal to Joey Evison, no run,","noball_dismissal":false,"text":"","timestamp":1751475152,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":60,"runs":1,"score":"151\/8","bats":[{"runs":41,"balls_faced":100,"fours":5,"sixes":0,"batsman_id":95553},{"runs":8,"balls_faced":15,"fours":1,"sixes":0,"batsman_id":107792}],"bowls":[{"runs_conceded":48,"maidens":6,"wickets":4,"bowler_id":654,"overs":30},{"runs_conceded":50,"maidens":5,"wickets":3,"bowler_id":50422,"overs":22}],"commentary":"End of over 60 (1 runs), Kent 151\/8"},{"event_id":"12274566","event":"ball","batsman_id":"107792","bowler_id":"50422","over":"60","ball":"1","score":0,"commentary":"Calvin Harrison to Tawanda Muyeye, no run,","noball_dismissal":false,"text":"","timestamp":1751475156,"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":"12274567","event":"ball","batsman_id":"107792","bowler_id":"50422","over":"60","ball":"2","score":1,"commentary":"Calvin Harrison to Tawanda Muyeye, 1 run,","noball_dismissal":false,"text":"","timestamp":1751475160,"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":"12274568","event":"ball","batsman_id":"95553","bowler_id":"50422","over":"60","ball":"3","score":2,"commentary":"Calvin Harrison to Joey Evison, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751475166,"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":"12274569","event":"ball","batsman_id":"95553","bowler_id":"50422","over":"60","ball":"4","score":0,"commentary":"Calvin Harrison to Joey Evison, no run,","noball_dismissal":false,"text":"","timestamp":1751475170,"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":"12274570","event":"ball","batsman_id":"95553","bowler_id":"50422","over":"60","ball":"5","score":4,"commentary":"Calvin Harrison to Joey Evison, Four,","noball_dismissal":false,"text":"","timestamp":1751475173,"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":"12274571","event":"ball","batsman_id":"95553","bowler_id":"50422","over":"60","ball":"6","score":2,"commentary":"Calvin Harrison to Joey Evison, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751475177,"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":61,"runs":9,"score":"160\/8","bats":[{"runs":49,"balls_faced":104,"fours":6,"sixes":0,"batsman_id":95553},{"runs":9,"balls_faced":17,"fours":1,"sixes":0,"batsman_id":107792}],"bowls":[{"runs_conceded":59,"maidens":5,"wickets":3,"bowler_id":50422,"overs":23},{"runs_conceded":48,"maidens":6,"wickets":4,"bowler_id":654,"overs":30}],"commentary":"End of over 61 (9 runs), Kent 160\/8"}],"day":"4","session":"0","live_inning":{"iid":199029,"number":3,"name":"Kent 2nd Inning","short_name":"KEN 2nd Inning","status":2,"issuperover":"false","result":4,"batting_team_id":104948,"fielding_team_id":7038,"scores":"160\/8","scores_full":"160\/8 (61 ov)","fielder":[{"fielder_id":"114663","fielder_name":"Tim Robinson","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"108384","fielder_name":"Justin Broad","catches":3,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"50478","fielder_name":"Lewis McManus","catches":0,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":1,"is_substitute":"false"},{"fielder_id":"654","fielder_name":"Yuzvendra Chahal","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":[],"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Matthew Quinn","batsman_id":"16644","runs":"13","balls":"57","how_out":"c Y Chahal b Calvin Harrison","score_at_dismissal":135,"overs_at_dismissal":"54.4","bowler_id":"50422","dismissal":"caught","number":8},"extra_runs":{"byes":0,"legbyes":1,"wides":0,"noballs":6,"penalty":"0","total":7},"equations":{"runs":160,"wickets":8,"overs":"61","bowlers_used":4,"runrate":"2.62"},"current_partnership":{"runs":25,"balls":38,"overs":6.2,"batsmen":[{"name":"Tawanda Muyeye","batsman_id":107792,"runs":9,"balls":17},{"name":"Joey Evison","batsman_id":95553,"runs":16,"balls":21}]},"did_not_bat":[{"player_id":48416,"name":"Nathan Gilchrist"}],"max_over":"0","target":"0","recent_scores":"2,4,0,2,1,0,0,0,1,0,0,0,0,1,0,0,0,4","last_five_overs":"23\/0 4.60","last_ten_overs":"33\/1 3.30"},"teams":[{"tid":7038,"title":"Northamptonshire","abbr":"NOR","alt_name":"NOR","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/northamptonshire-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/northamptonshire-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"722\/6d (146 ov)","scores":"722\/6d","overs":"146"},{"tid":104948,"title":"Kent","abbr":"KEN","alt_name":"KEN","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Kent.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Kent.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"566\/8d (155.5 ov) & 160\/8 (61 ov)","scores":"566\/8d & 160\/8","overs":"155.5 & 61"}],"players":[{"pid":654,"title":"Yuzvendra Chahal","short_name":"Y Chahal","first_name":"Yuzvendra Chahal","last_name":"","middle_name":"","birthdate":"1990-07-23","birthplace":" Jind, Haryana","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/tossco9.yuzi23\/","twitter_profile":"https:\/\/twitter.com\/yuzi_chahal","instagram_profile":"https:\/\/www.instagram.com\/yuzi_chahal23\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":1046,"title":"George Bartlett","short_name":"GA Bartlett","first_name":"George Bartlett","last_name":"","middle_name":"","birthdate":"1998-03-14","birthplace":"Frimley, Surrey","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":10606,"title":"Jake Ball","short_name":"JT Ball","first_name":"Jake Ball","last_name":"","middle_name":"","birthdate":"1991-03-14","birthplace":"Mansfield, Nottinghamshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":18974,"recent_appearance":1517109600,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/jakeball","instagram_profile":"https:\/\/www.instagram.com\/jakeball\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":10616,"title":"Jack Leaning","short_name":"JA Leaning","first_name":"Jack Leaning","last_name":"","middle_name":"","birthdate":"1993-10-18","birthplace":"Bristol","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"https:\/\/www.facebook.com\/jack.leaning.7\/","twitter_profile":"https:\/\/twitter.com\/JackLeaning1","instagram_profile":"https:\/\/www.instagram.com\/jack_leaning\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":16644,"title":"Matthew Quinn","short_name":"MR Quinn","first_name":"Matthew Quinn","last_name":"","middle_name":"","birthdate":"1993-02-28","birthplace":"Auckland","country":"nz","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CoachQuinn19","instagram_profile":"https:\/\/www.instagram.com\/matthewrquinn\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bowl","role_str":""},{"pid":43395,"title":"Daniel Bell-Drummond","short_name":"DJ Bell-Drummond","first_name":"Daniel Bell-Drummond","last_name":"","middle_name":"","birthdate":"1993-08-04","birthplace":"Lewisham, London","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/deebzz23","instagram_profile":"https:\/\/www.instagram.com\/deebzz23\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"pid":46884,"title":"Ricardo Vasconcelos","short_name":"Rs Vasconcelos","first_name":"Ricardo Vasconcelos","last_name":"","middle_name":"","birthdate":"1997-10-27","birthplace":" Johannesburg, Gauteng","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/ricardo.vasconcelos.169\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/ricardo27vasco\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","role_str":""},{"pid":47546,"title":"Keith Dudgeon","short_name":"KJ Dudgeon","first_name":"Keith Dudgeon","last_name":"","middle_name":"","birthdate":"1995-11-07","birthplace":"","country":"za","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":48416,"title":"Nathan Gilchrist","short_name":"NN Gilchrist","first_name":"Nathan Gilchrist","last_name":"","middle_name":"","birthdate":"2000-06-11","birthplace":"Harare","country":"za","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":7,"facebook_profile":"https:\/\/www.facebook.com\/nathan.gilchrist.94\/","twitter_profile":"https:\/\/twitter.com\/nathgilchrist","instagram_profile":"https:\/\/www.instagram.com\/nathanngilchrist\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bowl","role_str":""},{"pid":48438,"title":"Luke Procter","short_name":"LA Procter","first_name":"Luke Procter","last_name":"","middle_name":"","birthdate":"1988-06-24","birthplace":" Oldham, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left 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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"pid":48523,"title":"Wes Agar","short_name":"WA Agar","first_name":"Wes Agar","last_name":"","middle_name":"","birthdate":"1997-02-05","birthplace":"Malvern, Victoria","country":"au","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/wesagar13\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"bowl","role_str":""},{"pid":49372,"title":"Rob Keogh","short_name":"RI Keogh","first_name":"Rob Keogh","last_name":"","middle_name":"","birthdate":"1991-10-21","birthplace":" Dunstable, United","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49613,"title":"Joe Denly","short_name":"JL Denly","first_name":"Joe Denly","last_name":"","middle_name":"","birthdate":"1986-03-16","birthplace":"Canterbury, Kent","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,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/joed1986","instagram_profile":"https:\/\/www.instagram.com\/joe.denly\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49770,"title":"Saif Zaib","short_name":"SA Zaib","first_name":"Saif Zaib","last_name":"","middle_name":"","birthdate":"1998-05-22","birthplace":" High Wycombe, Buckinghamshire","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":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/zaib_05","instagram_profile":"https:\/\/www.instagram.com\/saif_zaib18\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":49809,"title":"Harry Finch","short_name":"HZ Finch","first_name":"Harry Finch","last_name":"","middle_name":"","birthdate":"1995-02-10","birthplace":"Hastings, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/f1nchy07","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":49814,"title":"Ben Sanderson","short_name":"BW Sanderson","first_name":"Ben Sanderson","last_name":"","middle_name":"","birthdate":"1989-01-03","birthplace":"Sheffield, Yorkshire","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50422,"title":"Calvin Harrison","short_name":"Calvin Harrison","first_name":"Calvin Harrison","last_name":"","middle_name":"","birthdate":"1998-04-29","birthplace":" Durban, KwaZulu-Natal","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","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":"https:\/\/twitter.com\/calvinh_98","instagram_profile":"https:\/\/www.instagram.com\/calvin_harrison_\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":50478,"title":"Lewis McManus","short_name":"LD McManus","first_name":"Lewis McManus","last_name":"","middle_name":"","birthdate":"1994-10-09","birthplace":"Poole Hospital","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lewis_mcmanus","instagram_profile":"https:\/\/www.instagram.com\/lewismcmanus18\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":50774,"title":"Zak Crawley","short_name":"Z Crawley","first_name":"Zak Crawley","last_name":"","middle_name":"","birthdate":"1998-02-03","birthplace":"Bromley, Kent","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":9,"facebook_profile":"https:\/\/www.facebook.com\/CrawleyZak\/","twitter_profile":"https:\/\/twitter.com\/ZakCrawleyFan","instagram_profile":"https:\/\/www.instagram.com\/crawley1993\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":52878,"title":"Liam Guthrie","short_name":"L Guthrie","first_name":"Liam Guthrie","last_name":"","middle_name":"","birthdate":"1997-04-09","birthplace":"","country":"au","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/lguthrie7\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"bowl","role_str":""},{"pid":55883,"title":"Harry Conway","short_name":"H Conway","first_name":"Harry Conway","last_name":"","middle_name":"","birthdate":"1992-09-17","birthplace":"Sydney, New South Wales","country":"au","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":7.5,"facebook_profile":"https:\/\/www.facebook.com\/harry.conway.169\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/harryconway05\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":93459,"title":"Lloyd Pope","short_name":"L Pope","first_name":"Lloyd Pope","last_name":"","middle_name":"","birthdate":"1999-12-01","birthplace":"","country":"au","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":23792,"recent_appearance":1515891600,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/lloydpoonslayer69\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/lloyd_pope24\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":93789,"title":"Matt Parkinson","short_name":"MW Parkinson","first_name":"Matt Parkinson","last_name":"","middle_name":"","birthdate":"1996-10-24","birthplace":"Bolton, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","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":"https:\/\/www.facebook.com\/matt.read.7311\/","twitter_profile":"https:\/\/twitter.com\/mattyparky96","instagram_profile":"https:\/\/www.instagram.com\/77parky\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":95553,"title":"Joey Evison","short_name":"J Evison","first_name":"Joey Evison","last_name":"","middle_name":"","birthdate":"2001-11-14","birthplace":" Peterborough, United Kingdom","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":"https:\/\/twitter.com\/EvisonJoey","instagram_profile":"https:\/\/www.instagram.com\/joeyevison\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":95557,"title":"Dominic Leech","short_name":"D Leech","first_name":"Dominic Leech","last_name":"","middle_name":"","birthdate":"2001-01-10","birthplace":" Middlesbrough, Yorkshire","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":95891,"title":"George Garrett","short_name":"G Garrett","first_name":"George Garrett","last_name":"","middle_name":"","birthdate":"2000-03-04","birthplace":" Harpenden, Hertfordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":96058,"title":"Ben Compton","short_name":"B Compton","first_name":"Ben Compton","last_name":"","middle_name":"","birthdate":"1994-03-29","birthplace":"Durban, Natal","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":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/bcompt4","instagram_profile":"https:\/\/www.instagram.com\/bencompton42\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":107792,"title":"Tawanda Muyeye","short_name":"T Muyeye","first_name":"Tawanda Muyeye","last_name":"","middle_name":"","birthdate":"2001-03-05","birthplace":"Harare, Mashonaland","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":7.5,"facebook_profile":"https:\/\/www.facebook.com\/tawanda.muyeye\/","twitter_profile":"https:\/\/twitter.com\/MuyeyeTawanda","instagram_profile":"https:\/\/www.instagram.com\/tawanda.muyeye\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":108384,"title":"Justin Broad","short_name":"J Broad","first_name":"Justin Broad","last_name":"","middle_name":"","birthdate":"2000-06-30","birthplace":"Cape Town, South Africa","country":"za","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108411,"title":"Gus Miller","short_name":"G Miller","first_name":"Gus Miller","last_name":"","middle_name":"","birthdate":"2002-01-08","birthplace":"Oxford","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108418,"title":"James Sales","short_name":"J Sales","first_name":"James Sales","last_name":"","middle_name":"","birthdate":"2003-02-11","birthplace":"Northampton","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":108444,"title":"Chris Benjamin","short_name":"C Benjamin","first_name":"Chris Benjamin","last_name":"","middle_name":"","birthdate":"1999-04-29","birthplace":"Johannesburg, Gauteng","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/chrisbenj_12","instagram_profile":"https:\/\/www.instagram.com\/chris.benjamin\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":109132,"title":"Jas Singh","short_name":"J Singh","first_name":"Jas Singh","last_name":"","middle_name":"","birthdate":"2002-09-19","birthplace":"Denmark Hill, Kent","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":114663,"title":"Tim Robinson","short_name":"T Robinson","first_name":"Tim Robinson","last_name":"","middle_name":"","birthdate":"2002-04-28","birthplace":"","country":"nz","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bat","role_str":""},{"pid":119031,"title":"Kashif Ali","short_name":"Kashif Ali","first_name":"Kashif Ali","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"pk","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"squad","role_str":""},{"pid":130195,"title":"Jaydn Denly","short_name":"JK Denly","first_name":"Jaydn Denly","last_name":"","middle_name":"","birthdate":"2006-01-05","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":130479,"title":"Raphael Weatherall","short_name":"R Weatherall","first_name":"Raphael Weatherall","last_name":"","middle_name":"","birthdate":"2004-10-24","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":141025,"title":"Ekansh Singh","short_name":"E Singh","first_name":"Ekansh Singh","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":147984,"title":"Grant Stewart","short_name":"Grant Stewart","first_name":"Grant Stewart","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"","primary_team":[],"logo_url":"","playing_role":"","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":null,"role":"squad","role_str":""},{"pid":150295,"title":"Aadi Sharma","short_name":"Aadi Sharma","first_name":"Aadi Sharma","last_name":"","middle_name":"","birthdate":"2006-02-23","birthplace":"Buckinghamshire","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":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"63bf68c3af8ed7b5eafa2587a8b55d0f","modified":"2025-07-15 20:49:58","datetime":"2025-07-15 20:49:58","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":88193,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Match Drawn","day_remaining_over":"15","team_batting":"Kent","team_bowling":"Northamptonshire","live_inning_number":3,"live_score":{"runs":160,"overs":61,"wickets":8,"target":0,"runrate":2.62,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Tawanda Muyeye","batsman_id":107792,"runs":9,"balls_faced":17,"fours":1,"sixes":0,"strike_rate":"52.94"},{"name":"Joey Evison","batsman_id":95553,"runs":49,"balls_faced":104,"fours":6,"sixes":0,"strike_rate":"47.12"}],"bowlers":[{"name":"Calvin Harrison","bowler_id":50422,"overs":23,"runs_conceded":59,"wickets":3,"maidens":5,"econ":"2.57"},{"name":"Yuzvendra Chahal","bowler_id":654,"overs":30,"runs_conceded":51,"wickets":4,"maidens":6,"econ":"1.70"}],"commentaries":[{"event_id":"12274478","event":"ball","batsman_id":"95553","bowler_id":"50422","over":"56","ball":"5","score":0,"commentary":"Calvin Harrison to Joey Evison, no run,","noball_dismissal":false,"text":"","timestamp":1751474565,"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":"12274486","event":"ball","batsman_id":"95553","bowler_id":"50422","over":"56","ball":"6","score":0,"commentary":"Calvin Harrison to Joey Evison, no run,","noball_dismissal":false,"text":"","timestamp":1751474568,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":57,"runs":3,"score":"140\/8","bats":[{"runs":37,"balls_faced":93,"fours":4,"sixes":0,"batsman_id":95553},{"runs":1,"balls_faced":4,"fours":0,"sixes":0,"batsman_id":107792}],"bowls":[{"runs_conceded":45,"maidens":5,"wickets":3,"bowler_id":50422,"overs":21},{"runs_conceded":42,"maidens":6,"wickets":4,"bowler_id":654,"overs":28}],"commentary":"End of over 57 (3 runs), Kent 140\/8"},{"event_id":"12274490","event":"ball","batsman_id":"107792","bowler_id":"654","over":"57","ball":"1","score":0,"commentary":"Yuzvendra Chahal to Tawanda Muyeye, no run,","noball_dismissal":false,"text":"","timestamp":1751474571,"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":"12274491","event":"ball","batsman_id":"107792","bowler_id":"654","over":"57","ball":"2","score":1,"commentary":"Yuzvendra Chahal to Tawanda Muyeye, 1 run,","noball_dismissal":false,"text":"","timestamp":1751474574,"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":"12274492","event":"ball","batsman_id":"95553","bowler_id":"654","over":"57","ball":"3","score":4,"commentary":"Yuzvendra Chahal to Joey Evison, Four,","noball_dismissal":false,"text":"","timestamp":1751474603,"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":"12274494","event":"ball","batsman_id":"95553","bowler_id":"654","over":"57","ball":"4","score":0,"commentary":"Yuzvendra Chahal to Joey Evison, no run,","noball_dismissal":false,"text":"","timestamp":1751474606,"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":"12274496","event":"ball","batsman_id":"95553","bowler_id":"654","over":"57","ball":"5","score":0,"commentary":"Yuzvendra Chahal to Joey Evison, no run,","noball_dismissal":false,"text":"","timestamp":1751474611,"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":"12274497","event":"ball","batsman_id":"95553","bowler_id":"654","over":"57","ball":"6","score":0,"commentary":"Yuzvendra Chahal to Joey Evison, no run,","noball_dismissal":false,"text":"","timestamp":1751474626,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":58,"runs":5,"score":"145\/8","bats":[{"runs":41,"balls_faced":97,"fours":5,"sixes":0,"batsman_id":95553},{"runs":2,"balls_faced":6,"fours":0,"sixes":0,"batsman_id":107792}],"bowls":[{"runs_conceded":47,"maidens":6,"wickets":4,"bowler_id":654,"overs":29},{"runs_conceded":45,"maidens":5,"wickets":3,"bowler_id":50422,"overs":21}],"commentary":"End of over 58 (5 runs), Kent 145\/8"},{"event_id":"12274504","event":"ball","batsman_id":"107792","bowler_id":"50422","over":"58","ball":"1","score":4,"commentary":"Calvin Harrison to Tawanda Muyeye, Four,","noball_dismissal":false,"text":"","timestamp":1751474730,"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":"12274513","event":"ball","batsman_id":"107792","bowler_id":"50422","over":"58","ball":"2","score":0,"commentary":"Calvin Harrison to Tawanda Muyeye, no run,","noball_dismissal":false,"text":"","timestamp":1751474735,"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":"12274516","event":"ball","batsman_id":"107792","bowler_id":"50422","over":"58","ball":"3","score":0,"commentary":"Calvin Harrison to Tawanda Muyeye, no run,","noball_dismissal":false,"text":"","timestamp":1751474740,"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":"12274517","event":"ball","batsman_id":"107792","bowler_id":"50422","over":"58","ball":"4","score":0,"commentary":"Calvin Harrison to Tawanda Muyeye, no run,","noball_dismissal":false,"text":"","timestamp":1751474744,"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":"12274518","event":"ball","batsman_id":"107792","bowler_id":"50422","over":"58","ball":"5","score":1,"commentary":"Calvin Harrison to Tawanda Muyeye, 1 run,","noball_dismissal":false,"text":"","timestamp":1751474773,"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":"12274523","event":"ball","batsman_id":"95553","bowler_id":"50422","over":"58","ball":"6","score":0,"commentary":"Calvin Harrison to Joey Evison, no run,","noball_dismissal":false,"text":"","timestamp":1751475121,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":59,"runs":5,"score":"150\/8","bats":[{"runs":41,"balls_faced":98,"fours":5,"sixes":0,"batsman_id":95553},{"runs":7,"balls_faced":11,"fours":1,"sixes":0,"batsman_id":107792}],"bowls":[{"runs_conceded":50,"maidens":5,"wickets":3,"bowler_id":50422,"overs":22},{"runs_conceded":47,"maidens":6,"wickets":4,"bowler_id":654,"overs":29}],"commentary":"End of over 59 (5 runs), Kent 150\/8"},{"event_id":"12274557","event":"ball","batsman_id":"107792","bowler_id":"654","over":"59","ball":"1","score":0,"commentary":"Yuzvendra Chahal to Tawanda Muyeye, no run,","noball_dismissal":false,"text":"","timestamp":1751475133,"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":"12274558","event":"ball","batsman_id":"107792","bowler_id":"654","over":"59","ball":"2","score":0,"commentary":"Yuzvendra Chahal to Tawanda Muyeye, no run,","noball_dismissal":false,"text":"","timestamp":1751475136,"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":"12274559","event":"ball","batsman_id":"107792","bowler_id":"654","over":"59","ball":"3","score":0,"commentary":"Yuzvendra Chahal to Tawanda Muyeye, no run,","noball_dismissal":false,"text":"","timestamp":1751475139,"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":"12274561","event":"ball","batsman_id":"107792","bowler_id":"654","over":"59","ball":"4","score":1,"commentary":"Yuzvendra Chahal to Tawanda Muyeye, 1 run,","noball_dismissal":false,"text":"","timestamp":1751475142,"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":"12274562","event":"ball","batsman_id":"95553","bowler_id":"654","over":"59","ball":"5","score":0,"commentary":"Yuzvendra Chahal to Joey Evison, no run,","noball_dismissal":false,"text":"","timestamp":1751475146,"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":"12274563","event":"ball","batsman_id":"95553","bowler_id":"654","over":"59","ball":"6","score":0,"commentary":"Yuzvendra Chahal to Joey Evison, no run,","noball_dismissal":false,"text":"","timestamp":1751475152,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":60,"runs":1,"score":"151\/8","bats":[{"runs":41,"balls_faced":100,"fours":5,"sixes":0,"batsman_id":95553},{"runs":8,"balls_faced":15,"fours":1,"sixes":0,"batsman_id":107792}],"bowls":[{"runs_conceded":48,"maidens":6,"wickets":4,"bowler_id":654,"overs":30},{"runs_conceded":50,"maidens":5,"wickets":3,"bowler_id":50422,"overs":22}],"commentary":"End of over 60 (1 runs), Kent 151\/8"},{"event_id":"12274566","event":"ball","batsman_id":"107792","bowler_id":"50422","over":"60","ball":"1","score":0,"commentary":"Calvin Harrison to Tawanda Muyeye, no run,","noball_dismissal":false,"text":"","timestamp":1751475156,"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":"12274567","event":"ball","batsman_id":"107792","bowler_id":"50422","over":"60","ball":"2","score":1,"commentary":"Calvin Harrison to Tawanda Muyeye, 1 run,","noball_dismissal":false,"text":"","timestamp":1751475160,"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":"12274568","event":"ball","batsman_id":"95553","bowler_id":"50422","over":"60","ball":"3","score":2,"commentary":"Calvin Harrison to Joey Evison, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751475166,"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":"12274569","event":"ball","batsman_id":"95553","bowler_id":"50422","over":"60","ball":"4","score":0,"commentary":"Calvin Harrison to Joey Evison, no run,","noball_dismissal":false,"text":"","timestamp":1751475170,"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":"12274570","event":"ball","batsman_id":"95553","bowler_id":"50422","over":"60","ball":"5","score":4,"commentary":"Calvin Harrison to Joey Evison, Four,","noball_dismissal":false,"text":"","timestamp":1751475173,"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":"12274571","event":"ball","batsman_id":"95553","bowler_id":"50422","over":"60","ball":"6","score":2,"commentary":"Calvin Harrison to Joey Evison, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751475177,"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":61,"runs":9,"score":"160\/8","bats":[{"runs":49,"balls_faced":104,"fours":6,"sixes":0,"batsman_id":95553},{"runs":9,"balls_faced":17,"fours":1,"sixes":0,"batsman_id":107792}],"bowls":[{"runs_conceded":59,"maidens":5,"wickets":3,"bowler_id":50422,"overs":23},{"runs_conceded":48,"maidens":6,"wickets":4,"bowler_id":654,"overs":30}],"commentary":"End of over 61 (9 runs), Kent 160\/8"}],"day":"4","session":"0","live_inning":{"iid":199029,"number":3,"name":"Kent 2nd Inning","short_name":"KEN 2nd Inning","status":2,"issuperover":"false","result":4,"batting_team_id":104948,"fielding_team_id":7038,"scores":"160\/8","scores_full":"160\/8 (61 ov)","fielder":[{"fielder_id":"114663","fielder_name":"Tim Robinson","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"108384","fielder_name":"Justin Broad","catches":3,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"50478","fielder_name":"Lewis McManus","catches":0,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":1,"is_substitute":"false"},{"fielder_id":"654","fielder_name":"Yuzvendra Chahal","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":[],"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Matthew Quinn","batsman_id":"16644","runs":"13","balls":"57","how_out":"c Y Chahal b Calvin Harrison","score_at_dismissal":135,"overs_at_dismissal":"54.4","bowler_id":"50422","dismissal":"caught","number":8},"extra_runs":{"byes":0,"legbyes":1,"wides":0,"noballs":6,"penalty":"0","total":7},"equations":{"runs":160,"wickets":8,"overs":"61","bowlers_used":4,"runrate":"2.62"},"current_partnership":{"runs":25,"balls":38,"overs":6.2,"batsmen":[{"name":"Tawanda Muyeye","batsman_id":107792,"runs":9,"balls":17},{"name":"Joey Evison","batsman_id":95553,"runs":16,"balls":21}]},"did_not_bat":[{"player_id":48416,"name":"Nathan Gilchrist"}],"max_over":"0","target":"0","recent_scores":"2,4,0,2,1,0,0,0,1,0,0,0,0,1,0,0,0,4","last_five_overs":"23\/0 4.60","last_ten_overs":"33\/1 3.30"},"teams":[{"tid":7038,"title":"Northamptonshire","abbr":"NOR","alt_name":"NOR","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/northamptonshire-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/northamptonshire-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"722\/6d (146 ov)","scores":"722\/6d","overs":"146"},{"tid":104948,"title":"Kent","abbr":"KEN","alt_name":"KEN","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Kent.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Kent.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"566\/8d (155.5 ov) & 160\/8 (61 ov)","scores":"566\/8d & 160\/8","overs":"155.5 & 61"}],"players":[{"pid":654,"title":"Yuzvendra Chahal","short_name":"Y Chahal","first_name":"Yuzvendra Chahal","last_name":"","middle_name":"","birthdate":"1990-07-23","birthplace":" Jind, Haryana","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/tossco9.yuzi23\/","twitter_profile":"https:\/\/twitter.com\/yuzi_chahal","instagram_profile":"https:\/\/www.instagram.com\/yuzi_chahal23\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":1046,"title":"George Bartlett","short_name":"GA Bartlett","first_name":"George Bartlett","last_name":"","middle_name":"","birthdate":"1998-03-14","birthplace":"Frimley, Surrey","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":10606,"title":"Jake Ball","short_name":"JT Ball","first_name":"Jake Ball","last_name":"","middle_name":"","birthdate":"1991-03-14","birthplace":"Mansfield, Nottinghamshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":18974,"recent_appearance":1517109600,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/jakeball","instagram_profile":"https:\/\/www.instagram.com\/jakeball\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":10616,"title":"Jack Leaning","short_name":"JA Leaning","first_name":"Jack Leaning","last_name":"","middle_name":"","birthdate":"1993-10-18","birthplace":"Bristol","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"https:\/\/www.facebook.com\/jack.leaning.7\/","twitter_profile":"https:\/\/twitter.com\/JackLeaning1","instagram_profile":"https:\/\/www.instagram.com\/jack_leaning\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":16644,"title":"Matthew Quinn","short_name":"MR Quinn","first_name":"Matthew Quinn","last_name":"","middle_name":"","birthdate":"1993-02-28","birthplace":"Auckland","country":"nz","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CoachQuinn19","instagram_profile":"https:\/\/www.instagram.com\/matthewrquinn\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bowl","role_str":""},{"pid":43395,"title":"Daniel Bell-Drummond","short_name":"DJ Bell-Drummond","first_name":"Daniel Bell-Drummond","last_name":"","middle_name":"","birthdate":"1993-08-04","birthplace":"Lewisham, London","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/deebzz23","instagram_profile":"https:\/\/www.instagram.com\/deebzz23\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"pid":46884,"title":"Ricardo Vasconcelos","short_name":"Rs Vasconcelos","first_name":"Ricardo Vasconcelos","last_name":"","middle_name":"","birthdate":"1997-10-27","birthplace":" Johannesburg, Gauteng","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/ricardo.vasconcelos.169\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/ricardo27vasco\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","role_str":""},{"pid":47546,"title":"Keith Dudgeon","short_name":"KJ Dudgeon","first_name":"Keith Dudgeon","last_name":"","middle_name":"","birthdate":"1995-11-07","birthplace":"","country":"za","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":48416,"title":"Nathan Gilchrist","short_name":"NN Gilchrist","first_name":"Nathan Gilchrist","last_name":"","middle_name":"","birthdate":"2000-06-11","birthplace":"Harare","country":"za","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":7,"facebook_profile":"https:\/\/www.facebook.com\/nathan.gilchrist.94\/","twitter_profile":"https:\/\/twitter.com\/nathgilchrist","instagram_profile":"https:\/\/www.instagram.com\/nathanngilchrist\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bowl","role_str":""},{"pid":48438,"title":"Luke Procter","short_name":"LA Procter","first_name":"Luke Procter","last_name":"","middle_name":"","birthdate":"1988-06-24","birthplace":" Oldham, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left 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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":"(C)"},{"pid":48523,"title":"Wes Agar","short_name":"WA Agar","first_name":"Wes Agar","last_name":"","middle_name":"","birthdate":"1997-02-05","birthplace":"Malvern, Victoria","country":"au","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/wesagar13\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"bowl","role_str":""},{"pid":49372,"title":"Rob Keogh","short_name":"RI Keogh","first_name":"Rob Keogh","last_name":"","middle_name":"","birthdate":"1991-10-21","birthplace":" Dunstable, United","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49613,"title":"Joe Denly","short_name":"JL Denly","first_name":"Joe Denly","last_name":"","middle_name":"","birthdate":"1986-03-16","birthplace":"Canterbury, Kent","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,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/joed1986","instagram_profile":"https:\/\/www.instagram.com\/joe.denly\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49770,"title":"Saif Zaib","short_name":"SA Zaib","first_name":"Saif Zaib","last_name":"","middle_name":"","birthdate":"1998-05-22","birthplace":" High Wycombe, Buckinghamshire","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":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/zaib_05","instagram_profile":"https:\/\/www.instagram.com\/saif_zaib18\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":49809,"title":"Harry Finch","short_name":"HZ Finch","first_name":"Harry Finch","last_name":"","middle_name":"","birthdate":"1995-02-10","birthplace":"Hastings, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/f1nchy07","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":49814,"title":"Ben Sanderson","short_name":"BW Sanderson","first_name":"Ben Sanderson","last_name":"","middle_name":"","birthdate":"1989-01-03","birthplace":"Sheffield, Yorkshire","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50422,"title":"Calvin Harrison","short_name":"Calvin Harrison","first_name":"Calvin Harrison","last_name":"","middle_name":"","birthdate":"1998-04-29","birthplace":" Durban, KwaZulu-Natal","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","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":"https:\/\/twitter.com\/calvinh_98","instagram_profile":"https:\/\/www.instagram.com\/calvin_harrison_\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":50478,"title":"Lewis McManus","short_name":"LD McManus","first_name":"Lewis McManus","last_name":"","middle_name":"","birthdate":"1994-10-09","birthplace":"Poole Hospital","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/lewis_mcmanus","instagram_profile":"https:\/\/www.instagram.com\/lewismcmanus18\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":50774,"title":"Zak Crawley","short_name":"Z Crawley","first_name":"Zak Crawley","last_name":"","middle_name":"","birthdate":"1998-02-03","birthplace":"Bromley, Kent","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":9,"facebook_profile":"https:\/\/www.facebook.com\/CrawleyZak\/","twitter_profile":"https:\/\/twitter.com\/ZakCrawleyFan","instagram_profile":"https:\/\/www.instagram.com\/crawley1993\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":52878,"title":"Liam Guthrie","short_name":"L Guthrie","first_name":"Liam Guthrie","last_name":"","middle_name":"","birthdate":"1997-04-09","birthplace":"","country":"au","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/lguthrie7\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"bowl","role_str":""},{"pid":55883,"title":"Harry Conway","short_name":"H Conway","first_name":"Harry Conway","last_name":"","middle_name":"","birthdate":"1992-09-17","birthplace":"Sydney, New South Wales","country":"au","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":7.5,"facebook_profile":"https:\/\/www.facebook.com\/harry.conway.169\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/harryconway05\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":93459,"title":"Lloyd Pope","short_name":"L Pope","first_name":"Lloyd Pope","last_name":"","middle_name":"","birthdate":"1999-12-01","birthplace":"","country":"au","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":23792,"recent_appearance":1515891600,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/lloydpoonslayer69\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/lloyd_pope24\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Australia","role":"squad","role_str":""},{"pid":93789,"title":"Matt Parkinson","short_name":"MW Parkinson","first_name":"Matt Parkinson","last_name":"","middle_name":"","birthdate":"1996-10-24","birthplace":"Bolton, Lancashire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","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":"https:\/\/www.facebook.com\/matt.read.7311\/","twitter_profile":"https:\/\/twitter.com\/mattyparky96","instagram_profile":"https:\/\/www.instagram.com\/77parky\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":95553,"title":"Joey Evison","short_name":"J Evison","first_name":"Joey Evison","last_name":"","middle_name":"","birthdate":"2001-11-14","birthplace":" Peterborough, United Kingdom","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":"https:\/\/twitter.com\/EvisonJoey","instagram_profile":"https:\/\/www.instagram.com\/joeyevison\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":95557,"title":"Dominic Leech","short_name":"D Leech","first_name":"Dominic Leech","last_name":"","middle_name":"","birthdate":"2001-01-10","birthplace":" Middlesbrough, Yorkshire","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":95891,"title":"George Garrett","short_name":"G Garrett","first_name":"George Garrett","last_name":"","middle_name":"","birthdate":"2000-03-04","birthplace":" Harpenden, Hertfordshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":96058,"title":"Ben Compton","short_name":"B Compton","first_name":"Ben Compton","last_name":"","middle_name":"","birthdate":"1994-03-29","birthplace":"Durban, Natal","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":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/bcompt4","instagram_profile":"https:\/\/www.instagram.com\/bencompton42\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":107792,"title":"Tawanda Muyeye","short_name":"T Muyeye","first_name":"Tawanda Muyeye","last_name":"","middle_name":"","birthdate":"2001-03-05","birthplace":"Harare, Mashonaland","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":7.5,"facebook_profile":"https:\/\/www.facebook.com\/tawanda.muyeye\/","twitter_profile":"https:\/\/twitter.com\/MuyeyeTawanda","instagram_profile":"https:\/\/www.instagram.com\/tawanda.muyeye\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":108384,"title":"Justin Broad","short_name":"J Broad","first_name":"Justin Broad","last_name":"","middle_name":"","birthdate":"2000-06-30","birthplace":"Cape Town, South Africa","country":"za","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108411,"title":"Gus Miller","short_name":"G Miller","first_name":"Gus Miller","last_name":"","middle_name":"","birthdate":"2002-01-08","birthplace":"Oxford","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108418,"title":"James Sales","short_name":"J Sales","first_name":"James Sales","last_name":"","middle_name":"","birthdate":"2003-02-11","birthplace":"Northampton","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":108444,"title":"Chris Benjamin","short_name":"C Benjamin","first_name":"Chris Benjamin","last_name":"","middle_name":"","birthdate":"1999-04-29","birthplace":"Johannesburg, Gauteng","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/chrisbenj_12","instagram_profile":"https:\/\/www.instagram.com\/chris.benjamin\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":109132,"title":"Jas Singh","short_name":"J Singh","first_name":"Jas Singh","last_name":"","middle_name":"","birthdate":"2002-09-19","birthplace":"Denmark Hill, Kent","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":114663,"title":"Tim Robinson","short_name":"T Robinson","first_name":"Tim Robinson","last_name":"","middle_name":"","birthdate":"2002-04-28","birthplace":"","country":"nz","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bat","role_str":""},{"pid":119031,"title":"Kashif Ali","short_name":"Kashif Ali","first_name":"Kashif Ali","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"pk","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"squad","role_str":""},{"pid":130195,"title":"Jaydn Denly","short_name":"JK Denly","first_name":"Jaydn Denly","last_name":"","middle_name":"","birthdate":"2006-01-05","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":130479,"title":"Raphael Weatherall","short_name":"R Weatherall","first_name":"Raphael Weatherall","last_name":"","middle_name":"","birthdate":"2004-10-24","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":141025,"title":"Ekansh Singh","short_name":"E Singh","first_name":"Ekansh Singh","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":147984,"title":"Grant Stewart","short_name":"Grant Stewart","first_name":"Grant Stewart","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"","primary_team":[],"logo_url":"","playing_role":"","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":null,"role":"squad","role_str":""},{"pid":150295,"title":"Aadi Sharma","short_name":"Aadi Sharma","first_name":"Aadi Sharma","last_name":"","middle_name":"","birthdate":"2006-02-23","birthplace":"Buckinghamshire","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":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"63bf68c3af8ed7b5eafa2587a8b55d0f","modified":"2025-07-15 20:49:58","datetime":"2025-07-15 20:49:58","api_version":"3.0"}', Modified = GetDate() WHERE Id = 88193 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:f67e76e5-5085-44ee-827a-df39ef0d6122
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 88193 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (88193,3,'{"status":"ok","response":{"match_id":88193,"title":"Kent vs Northamptonshire","short_title":"KEN vs NOR","subtitle":"34th Match","match_number":"34","format":5,"format_str":"First Class","status":2,"status_str":"Completed","status_note":"Match Drawn","verified":"true","pre_squad":"false","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129482,"title":"County Championship Division Two","abbr":"County Championship 2025 DIV-II","type":"tournament","category":"domestic","match_format":"firstclass","season":"2025","status":"live","datestart":"2025-04-04","dateend":"2025-09-27","country":"en","total_matches":"56","total_rounds":"1","total_teams":"8"},"teama":{"team_id":104948,"name":"Kent","short_name":"KEN","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Kent.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Kent.png","scores_full":"566\/8d (155.5 ov) & 160\/8 (61 ov)","scores":"566\/8d & 160\/8","overs":"155.5 & 61"},"teamb":{"team_id":7038,"name":"Northamptonshire","short_name":"NOR","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/northamptonshire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/northamptonshire-logo.png","scores_full":"722\/6d (146 ov)","scores":"722\/6d","overs":"146"},"date_start":"2025-06-29 10:00:00","date_end":"2025-07-04 10:00:00","timestamp_start":1751191200,"timestamp_end":1751623200,"date_start_ist":"2025-06-29 15:30:00","date_end_ist":"2025-07-04 15:30:00","venue":{"venue_id":"50","name":"St Lawrence Ground","location":"Canterbury","country":"England","timezone":""},"umpires":"Rob Bailey (England), Ben Peverall (England)","referee":"Mike Smith (England)","equation":"Match Drawn","live":"","result":"Match Drawn","result_type":3,"win_margin":"","winning_team_id":0,"commentary":1,"wagon":2,"latest_inning_number":3,"presquad_time":"","verify_time":"2025-07-02 22:44:19","match_dls_affected":"false","live_inning_number":3,"day":"4","session":"0","weather":[],"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Kent elected to bat","winner":104948,"decision":1}},"etag":"63bf68c3af8ed7b5eafa2587a8b55d0f","modified":"2025-07-15 20:49:58","datetime":"2025-07-15 20:49:58","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":88193,"title":"Kent vs Northamptonshire","short_title":"KEN vs NOR","subtitle":"34th Match","match_number":"34","format":5,"format_str":"First Class","status":2,"status_str":"Completed","status_note":"Match Drawn","verified":"true","pre_squad":"false","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129482,"title":"County Championship Division Two","abbr":"County Championship 2025 DIV-II","type":"tournament","category":"domestic","match_format":"firstclass","season":"2025","status":"live","datestart":"2025-04-04","dateend":"2025-09-27","country":"en","total_matches":"56","total_rounds":"1","total_teams":"8"},"teama":{"team_id":104948,"name":"Kent","short_name":"KEN","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Kent.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/FC-Kent.png","scores_full":"566\/8d (155.5 ov) & 160\/8 (61 ov)","scores":"566\/8d & 160\/8","overs":"155.5 & 61"},"teamb":{"team_id":7038,"name":"Northamptonshire","short_name":"NOR","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/northamptonshire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/northamptonshire-logo.png","scores_full":"722\/6d (146 ov)","scores":"722\/6d","overs":"146"},"date_start":"2025-06-29 10:00:00","date_end":"2025-07-04 10:00:00","timestamp_start":1751191200,"timestamp_end":1751623200,"date_start_ist":"2025-06-29 15:30:00","date_end_ist":"2025-07-04 15:30:00","venue":{"venue_id":"50","name":"St Lawrence Ground","location":"Canterbury","country":"England","timezone":""},"umpires":"Rob Bailey (England), Ben Peverall (England)","referee":"Mike Smith (England)","equation":"Match Drawn","live":"","result":"Match Drawn","result_type":3,"win_margin":"","winning_team_id":0,"commentary":1,"wagon":2,"latest_inning_number":3,"presquad_time":"","verify_time":"2025-07-02 22:44:19","match_dls_affected":"false","live_inning_number":3,"day":"4","session":"0","weather":[],"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Kent elected to bat","winner":104948,"decision":1}},"etag":"63bf68c3af8ed7b5eafa2587a8b55d0f","modified":"2025-07-15 20:49:58","datetime":"2025-07-15 20:49:58","api_version":"3.0"}', Modified = GetDate() WHERE Id = 88193 AND DataTypeId = 3 END Live Report & Scorecard of Kent vs Northamptonshire 34th Match
Kent vs Northamptonshire, Live Cricket Commentary