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:14a6c37a-9333-4649-9cd8-c0dfcf72a4ae Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86864 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86864,1,'{"status":"ok","response":{"mid":86864,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Match Tie (DLS Method)","day_remaining_over":"","team_batting":"Middlesex","team_bowling":"Hampshire","live_inning_number":2,"live_score":{"runs":75,"overs":6,"wickets":1,"target":76,"runrate":12.5,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Ben Geddes","batsman_id":108382,"runs":10,"balls_faced":5,"fours":1,"sixes":0,"strike_rate":"200.00"},{"name":"Kane Williamson","batsman_id":31,"runs":23,"balls_faced":13,"fours":3,"sixes":1,"strike_rate":"176.92"}],"bowlers":[{"name":"Scott Currie","bowler_id":96605,"overs":2,"runs_conceded":19,"wickets":1,"maidens":0,"econ":"9.50"},{"name":"Liam Dawson","bowler_id":1945,"overs":1,"runs_conceded":17,"wickets":0,"maidens":0,"econ":"17.00"}],"commentaries":[{"event_id":"12138129","event":"ball","batsman_id":"1043","bowler_id":"32166","over":"1","ball":"5","score":6,"commentary":"James Fuller to Max Holden, Six,","noball_dismissal":false,"text":"","timestamp":1749848920,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12138130","event":"ball","batsman_id":"1043","bowler_id":"32166","over":"1","ball":"6","score":4,"commentary":"James Fuller to Max Holden, Four,","noball_dismissal":false,"text":"","timestamp":1749848923,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event":"overend","over":2,"runs":19,"score":"20\/0","bats":[{"runs":18,"balls_faced":9,"fours":3,"sixes":1,"batsman_id":1043},{"runs":0,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":31}],"bowls":[{"runs_conceded":18,"maidens":0,"wickets":0,"bowler_id":32166,"overs":1},{"runs_conceded":0,"maidens":1,"wickets":0,"bowler_id":49478,"overs":1}],"commentary":"End of over 2 (19 runs), Middlesex 20\/0"},{"event_id":"12138131","event":"ball","batsman_id":"31","bowler_id":"49478","over":"2","ball":"1","score":4,"commentary":"Chris Wood to Kane Williamson, Four,","noball_dismissal":false,"text":"","timestamp":1749848926,"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":"12138132","event":"ball","batsman_id":"31","bowler_id":"49478","over":"2","ball":"2","score":"1lb","commentary":"Chris Wood to Kane Williamson, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1749848928,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"1","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12138133","event":"ball","batsman_id":"1043","bowler_id":"49478","over":"2","ball":"3","score":4,"commentary":"Chris Wood to Max Holden, Four,","noball_dismissal":false,"text":"","timestamp":1749849001,"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":"12138134","event":"ball","batsman_id":"1043","bowler_id":"49478","over":"2","ball":"4","score":2,"commentary":"Chris Wood to Max Holden, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749849008,"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":"12138135","event":"ball","batsman_id":"1043","bowler_id":"49478","over":"2","ball":"5","score":6,"commentary":"Chris Wood to Max Holden, Six,","noball_dismissal":false,"text":"","timestamp":1749849067,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12138138","event":"ball","batsman_id":"1043","bowler_id":"49478","over":"2","ball":"6","score":1,"commentary":"Chris Wood to Max Holden, 1 run,","noball_dismissal":false,"text":"","timestamp":1749849129,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":3,"runs":18,"score":"38\/0","bats":[{"runs":31,"balls_faced":13,"fours":4,"sixes":2,"batsman_id":1043},{"runs":4,"balls_faced":5,"fours":1,"sixes":0,"batsman_id":31}],"bowls":[{"runs_conceded":17,"maidens":1,"wickets":0,"bowler_id":49478,"overs":2},{"runs_conceded":18,"maidens":0,"wickets":0,"bowler_id":32166,"overs":1}],"commentary":"End of over 3 (18 runs), Middlesex 38\/0"},{"event_id":"12138141","event":"ball","batsman_id":"1043","bowler_id":"96605","over":"3","ball":"1","score":0,"commentary":"Scott Currie to Max Holden, no run,","noball_dismissal":false,"text":"","timestamp":1749849136,"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":"12138142","event":"ball","batsman_id":"1043","bowler_id":"96605","over":"3","ball":"2","score":1,"commentary":"Scott Currie to Max Holden, 1 run,","noball_dismissal":false,"text":"","timestamp":1749849196,"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":"12138145","event":"ball","batsman_id":"31","bowler_id":"96605","over":"3","ball":"3","score":1,"commentary":"Scott Currie to Kane Williamson, 1 run,","noball_dismissal":false,"text":"","timestamp":1749849251,"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":"12138146","event":"ball","batsman_id":"1043","bowler_id":"96605","over":"3","ball":"4","score":2,"commentary":"Scott Currie to Max Holden, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749849254,"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":"12138149","event":"ball","batsman_id":"1043","bowler_id":"96605","over":"3","ball":"5","score":4,"commentary":"Scott Currie to Max Holden, Four,","noball_dismissal":false,"text":"","timestamp":1749849337,"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":"12138150","event":"wicket","batsman_id":"1043","bowler_id":"96605","over":"3","ball":"6","score":"w","commentary":"Scott Currie to Max Holden, no run, c CP Wood b S Currie,","noball_dismissal":false,"text":"","timestamp":1749849438,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"1043","how_out":"c CP Wood b S Currie","batsman_runs":"38","batsman_balls":"18"},{"event":"overend","over":4,"runs":8,"score":"46\/1","bats":[{"runs":38,"balls_faced":18,"fours":5,"sixes":2,"batsman_id":1043},{"runs":5,"balls_faced":6,"fours":1,"sixes":0,"batsman_id":31}],"bowls":[{"runs_conceded":8,"maidens":0,"wickets":1,"bowler_id":96605,"overs":1},{"runs_conceded":17,"maidens":1,"wickets":0,"bowler_id":49478,"overs":2}],"commentary":"End of over 4 (8 runs), Middlesex 46\/1"},{"event_id":"12138155","event":"ball","batsman_id":"31","bowler_id":"1945","over":"4","ball":"1","score":4,"commentary":"Liam Dawson to Kane Williamson, Four,","noball_dismissal":false,"text":"","timestamp":1749849487,"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":"12138158","event":"ball","batsman_id":"31","bowler_id":"1945","over":"4","ball":"2","score":2,"commentary":"Liam Dawson to Kane Williamson, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749849490,"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":"12138159","event":"ball","batsman_id":"31","bowler_id":"1945","over":"4","ball":"3","score":4,"commentary":"Liam Dawson to Kane Williamson, Four,","noball_dismissal":false,"text":"","timestamp":1749849493,"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":"12138166","event":"ball","batsman_id":"31","bowler_id":"1945","over":"4","ball":"4","score":0,"commentary":"Liam Dawson to Kane Williamson, no run,","noball_dismissal":false,"text":"","timestamp":1749849832,"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":"12138167","event":"ball","batsman_id":"31","bowler_id":"1945","over":"4","ball":"5","score":6,"commentary":"Liam Dawson to Kane Williamson, Six,","noball_dismissal":false,"text":"","timestamp":1749849835,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12138169","event":"ball","batsman_id":"31","bowler_id":"1945","over":"4","ball":"6","score":1,"commentary":"Liam Dawson to Kane Williamson, 1 run,","noball_dismissal":false,"text":"","timestamp":1749849838,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":5,"runs":17,"score":"63\/1","bats":[{"runs":22,"balls_faced":12,"fours":3,"sixes":1,"batsman_id":31},{"runs":0,"balls_faced":0,"fours":0,"sixes":0,"batsman_id":108382}],"bowls":[{"runs_conceded":17,"maidens":0,"wickets":0,"bowler_id":1945,"overs":1},{"runs_conceded":8,"maidens":0,"wickets":1,"bowler_id":96605,"overs":1}],"commentary":"End of over 5 (17 runs), Middlesex 63\/1"},{"event_id":"12138170","event":"ball","batsman_id":"31","bowler_id":"96605","over":"5","ball":"1","score":1,"commentary":"Scott Currie to Kane Williamson, 1 run,","noball_dismissal":false,"text":"","timestamp":1749849840,"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":"12138171","event":"ball","batsman_id":"108382","bowler_id":"96605","over":"5","ball":"2","score":2,"commentary":"Scott Currie to Ben Geddes, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749849848,"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":"12138172","event":"ball","batsman_id":"108382","bowler_id":"96605","over":"5","ball":"3","score":2,"commentary":"Scott Currie to Ben Geddes, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749849851,"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":"12138173","event":"ball","batsman_id":"108382","bowler_id":"96605","over":"5","ball":"4","score":2,"commentary":"Scott Currie to Ben Geddes, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749849853,"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":"12138176","event":"ball","batsman_id":"108382","bowler_id":"96605","over":"5","ball":"5","score":4,"commentary":"Scott Currie to Ben Geddes, Four,","noball_dismissal":false,"text":"","timestamp":1749850089,"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":"12138183","event":"ball","batsman_id":"108382","bowler_id":"96605","over":"5","ball":"6","score":"1b","commentary":"Scott Currie to Ben Geddes, 1 bye,","noball_dismissal":false,"text":"","timestamp":1749850092,"run":1,"noball_run":"0","wide_run":"0","bye_run":"1","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":6,"runs":12,"score":"75\/1","bats":[{"runs":10,"balls_faced":5,"fours":1,"sixes":0,"batsman_id":108382},{"runs":23,"balls_faced":13,"fours":3,"sixes":1,"batsman_id":31}],"bowls":[{"runs_conceded":19,"maidens":0,"wickets":1,"bowler_id":96605,"overs":2},{"runs_conceded":17,"maidens":0,"wickets":0,"bowler_id":1945,"overs":1}],"commentary":"End of over 6 (12 runs), Middlesex 75\/1"}],"day":"0","session":"0","live_inning":{"iid":198013,"number":2,"name":"Middlesex Inning","short_name":"MID Inning","status":2,"issuperover":"false","result":4,"batting_team_id":7044,"fielding_team_id":7047,"scores":"75\/1","scores_full":"75\/1 (6 ov)","fielder":[{"fielder_id":"49478","fielder_name":"Chris Wood","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":"Max Holden","batsman_id":"1043","runs":"38","balls":"18","how_out":"c CP Wood b S Currie","score_at_dismissal":46,"overs_at_dismissal":"3.6","bowler_id":"96605","dismissal":"caught","number":1},"extra_runs":{"byes":1,"legbyes":3,"wides":0,"noballs":0,"penalty":"0","total":4},"equations":{"runs":75,"wickets":1,"overs":"6","bowlers_used":4,"runrate":"12.50"},"current_partnership":{"runs":29,"balls":12,"overs":2,"batsmen":[{"name":"Kane Williamson","batsman_id":31,"runs":18,"balls":7},{"name":"Ben Geddes","batsman_id":108382,"runs":10,"balls":5}]},"did_not_bat":[{"player_id":"102540","name":"Stephen Eskinazi"},{"player_id":"53281","name":"Leus du Plooy"},{"player_id":"49930","name":"Ryan Higgins"},{"player_id":"93517","name":"Jack Davies"},{"player_id":"93519","name":"Luke Hollman"},{"player_id":"44058","name":"Zafar Gohar"},{"player_id":"49497","name":"Tom Helm"},{"player_id":"140007","name":"Noah Cornwell"}],"max_over":"6","target":"76","recent_scores":"1,4,2,2,2,1,1,6,0,4,2,4,w,4,2,1,1,0","last_five_overs":"74\/1 14.80","last_ten_overs":"75\/1 12.50"},"teams":[{"tid":7044,"title":"Middlesex","abbr":"MID","alt_name":"MID","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/middlesex-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/middlesex-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"75\/1 (6 ov)","scores":"75\/1","overs":"6"},{"tid":7047,"title":"Hampshire","abbr":"HAM","alt_name":"HAM","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/hampshire-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/hampshire-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"63\/1 (6 ov)","scores":"63\/1","overs":"6"}],"players":[{"pid":31,"title":"Kane Williamson","short_name":"K Williamson","first_name":"Kane Williamson","last_name":"","middle_name":"","birthdate":"1990-08-08","birthplace":"Tauranga","country":"nz","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/KaneWillTrain\/","twitter_profile":"https:\/\/twitter.com\/KaneWiliamson","instagram_profile":"https:\/\/www.instagram.com\/kane_s_w\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bat","role_str":""},{"pid":432,"title":"Kyle Abbott","short_name":"K Abbott","first_name":"Kyle Abbott","last_name":"","middle_name":"","birthdate":"1987-06-18","birthplace":"Empangeni, KwaZulu-Natal","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":1043,"title":"Max Holden","short_name":"MDE Holden","first_name":"Max Holden","last_name":"","middle_name":"","birthdate":"1997-12-18","birthplace":" Cambridge","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/maxholden_4","instagram_profile":"https:\/\/www.instagram.com\/maxholden4\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":1115,"title":"Josh Little","short_name":"JB Little","first_name":"Josh Little","last_name":"","middle_name":"","birthdate":"1999-11-01","birthplace":"Dublin","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/joshlittle13\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":1945,"title":"Liam Dawson","short_name":"L Dawson","first_name":"Liam Dawson","last_name":"","middle_name":"","birthdate":"1990-03-01","birthplace":"Swindon, Wiltshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right 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":"https:\/\/www.instagram.com\/daws128\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":1949,"title":"James Vince","short_name":"J Vince","first_name":"James Vince","last_name":"","middle_name":"","birthdate":"1991-03-14","birthplace":"Cuckfield, Sussex","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":9,"facebook_profile":"https:\/\/www.facebook.com\/vincey14\/","twitter_profile":"https:\/\/twitter.com\/vincey14","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"pid":32166,"title":"James Fuller","short_name":"JK Fuller","first_name":"James Fuller","last_name":"","middle_name":"","birthdate":"1990-01-24","birthplace":"Cape Town, Cape Province","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/James_Fuller246","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":44058,"title":"Zafar Gohar","short_name":"ZG Gohar","first_name":"Zafar Gohar","last_name":"","middle_name":"","birthdate":"1995-02-01","birthplace":"Lahore, Punjab","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/iamzafargohar","instagram_profile":"https:\/\/www.instagram.com\/iamzafargohar\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bowl","role_str":""},{"pid":46147,"title":"Bjorn Fortuin","short_name":"BC Fortuin","first_name":"Bjorn Fortuin","last_name":"","middle_name":"","birthdate":"1994-10-21","birthplace":"Paarl","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/bjorn_fortuin","instagram_profile":"https:\/\/www.instagram.com\/bjornfortuin\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":49334,"title":"Ben Brown","short_name":"BC Brown","first_name":"Ben Brown","last_name":"","middle_name":"","birthdate":"1988-11-23","birthplace":"Crawley, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper ","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Ben_Brown26","instagram_profile":"https:\/\/www.instagram.com\/benbrown26\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49343,"title":"Nick Gubbins","short_name":"NRT Gubbins","first_name":"Nick Gubbins","last_name":"","middle_name":"","birthdate":"1993-12-31","birthplace":"Richmond, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49478,"title":"Chris Wood","short_name":"CP Wood","first_name":"Chris Wood","last_name":"","middle_name":"","birthdate":"1990-06-27","birthplace":"Basingstoke, Hampshire","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":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CWoody27","instagram_profile":"https:\/\/www.instagram.com\/cwood25\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49493,"title":"Sam Robson","short_name":"SD Robson","first_name":"Sam Robson","last_name":"","middle_name":"","birthdate":"1989-07-01","birthplace":"Paddington, Sydney, New South Wales","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"https:\/\/www.facebook.com\/samrobson664\/","twitter_profile":"https:\/\/twitter.com\/Samrobsonfans12","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49497,"title":"Tom Helm","short_name":"TG Helm","first_name":"Tom Helm","last_name":"","middle_name":"","birthdate":"1994-05-07","birthplace":"Stoke Mandeville Hospital, Buckinghamshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/TomHelm7","instagram_profile":"https:\/\/www.instagram.com\/helmy__7\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49524,"title":"Benny Howell","short_name":"BAC Howell","first_name":"Benny Howell","last_name":"","middle_name":"","birthdate":"1988-10-05","birthplace":"Bordeaux, France","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":8,"facebook_profile":"https:\/\/www.facebook.com\/BennyHowellOfficial\/","twitter_profile":"https:\/\/twitter.com\/bennytweets_","instagram_profile":"https:\/\/www.instagram.com\/bennycam13\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":49536,"title":"Mark Stoneman","short_name":"MD Stoneman","first_name":"Mark Stoneman","last_name":"","middle_name":"","birthdate":"1987-06-26","birthplace":"Newcastle upon Tyne, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":18968,"recent_appearance":1514244600,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/mark23stone","instagram_profile":"https:\/\/www.instagram.com\/mark23stone\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49783,"title":"Toby Roland-Jones","short_name":"TS Roland-Jones","first_name":"Toby Roland-Jones","last_name":"","middle_name":"","birthdate":"1988-01-29","birthplace":"Ashford, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/tobyrj21","instagram_profile":"https:\/\/www.instagram.com\/tobyrj21\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49930,"title":"Ryan Higgins","short_name":"RF Higgins","first_name":"Ryan Higgins","last_name":"","middle_name":"","birthdate":"1995-01-06","birthplace":"Harare, Zimbabwe","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":50481,"title":"Felix Organ","short_name":"FS Organ","first_name":"Felix Organ","last_name":"","middle_name":"","birthdate":"1999-06-02","birthplace":"Sydney","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":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50484,"title":"Brad Wheal","short_name":"BTJ Wheal","first_name":"Brad Wheal","last_name":"","middle_name":"","birthdate":"1996-08-28","birthplace":"Durban, KwaZulu-Natal","country":"sct","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/brad.wheal\/","twitter_profile":"https:\/\/twitter.com\/BradWheal","instagram_profile":"https:\/\/www.instagram.com\/bradwheal\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":51285,"title":"Joe Weatherley","short_name":"JJ Weatherley","first_name":"Joe Weatherley","last_name":"","middle_name":"","birthdate":"1997-01-19","birthplace":"Winchester, Hampshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Joe_Weatherley","instagram_profile":"https:\/\/www.instagram.com\/jjweatherley\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":53281,"title":"Leus du Plooy","short_name":"JLdu Plooy","first_name":"Leus du Plooy","last_name":"","middle_name":"","birthdate":"1995-01-12","birthplace":"Pretoria, Gauteng,","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/leusdup76","instagram_profile":"https:\/\/www.instagram.com\/leusdup76\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","role_str":""},{"pid":90974,"title":"Henry Brookes","short_name":"HJH Brookes","first_name":"Henry Brookes","last_name":"","middle_name":"","birthdate":"1999-08-21","birthplace":"Solihull, Warwickshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BrookesHenry","instagram_profile":"https:\/\/www.instagram.com\/henry.brookes\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":93517,"title":"Jack Davies","short_name":"JLB Davies","first_name":"Jack Davies","last_name":"","middle_name":"","birthdate":"2000-03-30","birthplace":"Reading, Berkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/daviesjlb","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":93519,"title":"Luke Hollman","short_name":"LBK Hollman","first_name":"Luke Hollman","last_name":"","middle_name":"","birthdate":"2000-09-16","birthplace":"Islington, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/lukehollman56\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":95552,"title":"Blake Cullen","short_name":"B Cullen","first_name":"Blake Cullen","last_name":"","middle_name":"","birthdate":"2002-02-19","birthplace":" Isleworth, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":96605,"title":"Scott Currie","short_name":"S Currie","first_name":"Scott Currie","last_name":"","middle_name":"","birthdate":"2001-05-02","birthplace":"Poole, Dorset","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":101478,"title":"Joe Benjamin Cracknell","short_name":"JB Cracknell","first_name":"Joe Benjamin Cracknell","last_name":"","middle_name":"","birthdate":"2000-03-16","birthplace":"Enfield, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/joe_cracknell\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":102540,"title":"Stephen Eskinazi","short_name":"S Eskinazi","first_name":"Stephen Eskinazi","last_name":"","middle_name":"","birthdate":"1994-03-28","birthplace":"Johannesburg, Transvaal, South Africa","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/seskinazi","instagram_profile":"https:\/\/www.instagram.com\/seskinazi\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(C)"},{"pid":108376,"title":"Tom Prest","short_name":"T Prest","first_name":"Tom Prest","last_name":"","middle_name":"","birthdate":"2003-03-24","birthplace":"Wimborne, Dorset","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":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108377,"title":"Toby Albert","short_name":"T Albert","first_name":"Toby Albert","last_name":"","middle_name":"","birthdate":"2001-11-12","birthplace":"Basingstoke, Hampshire","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":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":108378,"title":"Fletcha Middleton","short_name":"F Middleton","first_name":"Fletcha Middleton","last_name":"","middle_name":"","birthdate":"2002-01-31","birthplace":"Winchester, Hampshire","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108381,"title":"John Turner","short_name":"J Turner","first_name":"John Turner","last_name":"","middle_name":"","birthdate":"2001-04-10","birthplace":"Johannesburg, Gauteng","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":108382,"title":"Ben Geddes","short_name":"B Geddes","first_name":"Ben Geddes","last_name":"","middle_name":"","birthdate":"2001-07-31","birthplace":"Epsom, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":108409,"title":"Sonny Baker","short_name":"S Baker","first_name":"Sonny Baker","last_name":"","middle_name":"","birthdate":"2003-03-13","birthplace":"Torbay, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/sonnybaker\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":109051,"title":"Ali Orr","short_name":"AGH Orr","first_name":"Ali Orr","last_name":"","middle_name":"","birthdate":"2001-04-06","birthplace":"Eastbourne, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/alastairorr\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":110871,"title":"Dewald Brevis","short_name":"D Brevis","first_name":"Dewald Brevis","last_name":"","middle_name":"","birthdate":"2003-04-29","birthplace":"Johannesburg","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/Brevis17\/","twitter_profile":"https:\/\/twitter.com\/BrevisDewald","instagram_profile":"https:\/\/www.instagram.com\/dewald_brevis_17\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","role_str":""},{"pid":116661,"title":"Ishaan Kaushal","short_name":"I Kaushal","first_name":"Ishaan Kaushal","last_name":"","middle_name":"","birthdate":"2002-02-09","birthplace":"Hillingdon, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":127503,"title":"Josh De Caires","short_name":"J D caires","first_name":"Josh De Caires","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":128989,"title":"Lhuan dre Pretorius","short_name":"Ld Pretorius","first_name":"Lhuan dre Pretorius","last_name":"","middle_name":"","birthdate":"2006-03-27","birthplace":"Potchefstroom","country":"za","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"wk","role_str":"(WK)"},{"pid":129244,"title":"Nathan Fernandes","short_name":"N Fernandes","first_name":"Nathan Fernandes","last_name":"","middle_name":"","birthdate":"2004-04-26","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":133782,"title":"Sebastian Morgan","short_name":"SB Morgan","first_name":"Sebastian Morgan","last_name":"","middle_name":"","birthdate":"2007-08-30","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":140007,"title":"Noah Cornwell","short_name":"N Cornwell","first_name":"Noah Cornwell","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":146167,"title":"Aaryan Sawant","short_name":"A Sawant","first_name":"Aaryan Sawant","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":146171,"title":"Naavya Sharma","short_name":"N Sharma","first_name":"Naavya Sharma","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"37bc25d310565220e537dd7f0dedf213","modified":"2025-07-30 02:06:01","datetime":"2025-07-30 02:06:01","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":86864,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Match Tie (DLS Method)","day_remaining_over":"","team_batting":"Middlesex","team_bowling":"Hampshire","live_inning_number":2,"live_score":{"runs":75,"overs":6,"wickets":1,"target":76,"runrate":12.5,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Ben Geddes","batsman_id":108382,"runs":10,"balls_faced":5,"fours":1,"sixes":0,"strike_rate":"200.00"},{"name":"Kane Williamson","batsman_id":31,"runs":23,"balls_faced":13,"fours":3,"sixes":1,"strike_rate":"176.92"}],"bowlers":[{"name":"Scott Currie","bowler_id":96605,"overs":2,"runs_conceded":19,"wickets":1,"maidens":0,"econ":"9.50"},{"name":"Liam Dawson","bowler_id":1945,"overs":1,"runs_conceded":17,"wickets":0,"maidens":0,"econ":"17.00"}],"commentaries":[{"event_id":"12138129","event":"ball","batsman_id":"1043","bowler_id":"32166","over":"1","ball":"5","score":6,"commentary":"James Fuller to Max Holden, Six,","noball_dismissal":false,"text":"","timestamp":1749848920,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12138130","event":"ball","batsman_id":"1043","bowler_id":"32166","over":"1","ball":"6","score":4,"commentary":"James Fuller to Max Holden, Four,","noball_dismissal":false,"text":"","timestamp":1749848923,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event":"overend","over":2,"runs":19,"score":"20\/0","bats":[{"runs":18,"balls_faced":9,"fours":3,"sixes":1,"batsman_id":1043},{"runs":0,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":31}],"bowls":[{"runs_conceded":18,"maidens":0,"wickets":0,"bowler_id":32166,"overs":1},{"runs_conceded":0,"maidens":1,"wickets":0,"bowler_id":49478,"overs":1}],"commentary":"End of over 2 (19 runs), Middlesex 20\/0"},{"event_id":"12138131","event":"ball","batsman_id":"31","bowler_id":"49478","over":"2","ball":"1","score":4,"commentary":"Chris Wood to Kane Williamson, Four,","noball_dismissal":false,"text":"","timestamp":1749848926,"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":"12138132","event":"ball","batsman_id":"31","bowler_id":"49478","over":"2","ball":"2","score":"1lb","commentary":"Chris Wood to Kane Williamson, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1749848928,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"1","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12138133","event":"ball","batsman_id":"1043","bowler_id":"49478","over":"2","ball":"3","score":4,"commentary":"Chris Wood to Max Holden, Four,","noball_dismissal":false,"text":"","timestamp":1749849001,"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":"12138134","event":"ball","batsman_id":"1043","bowler_id":"49478","over":"2","ball":"4","score":2,"commentary":"Chris Wood to Max Holden, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749849008,"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":"12138135","event":"ball","batsman_id":"1043","bowler_id":"49478","over":"2","ball":"5","score":6,"commentary":"Chris Wood to Max Holden, Six,","noball_dismissal":false,"text":"","timestamp":1749849067,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12138138","event":"ball","batsman_id":"1043","bowler_id":"49478","over":"2","ball":"6","score":1,"commentary":"Chris Wood to Max Holden, 1 run,","noball_dismissal":false,"text":"","timestamp":1749849129,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":3,"runs":18,"score":"38\/0","bats":[{"runs":31,"balls_faced":13,"fours":4,"sixes":2,"batsman_id":1043},{"runs":4,"balls_faced":5,"fours":1,"sixes":0,"batsman_id":31}],"bowls":[{"runs_conceded":17,"maidens":1,"wickets":0,"bowler_id":49478,"overs":2},{"runs_conceded":18,"maidens":0,"wickets":0,"bowler_id":32166,"overs":1}],"commentary":"End of over 3 (18 runs), Middlesex 38\/0"},{"event_id":"12138141","event":"ball","batsman_id":"1043","bowler_id":"96605","over":"3","ball":"1","score":0,"commentary":"Scott Currie to Max Holden, no run,","noball_dismissal":false,"text":"","timestamp":1749849136,"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":"12138142","event":"ball","batsman_id":"1043","bowler_id":"96605","over":"3","ball":"2","score":1,"commentary":"Scott Currie to Max Holden, 1 run,","noball_dismissal":false,"text":"","timestamp":1749849196,"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":"12138145","event":"ball","batsman_id":"31","bowler_id":"96605","over":"3","ball":"3","score":1,"commentary":"Scott Currie to Kane Williamson, 1 run,","noball_dismissal":false,"text":"","timestamp":1749849251,"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":"12138146","event":"ball","batsman_id":"1043","bowler_id":"96605","over":"3","ball":"4","score":2,"commentary":"Scott Currie to Max Holden, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749849254,"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":"12138149","event":"ball","batsman_id":"1043","bowler_id":"96605","over":"3","ball":"5","score":4,"commentary":"Scott Currie to Max Holden, Four,","noball_dismissal":false,"text":"","timestamp":1749849337,"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":"12138150","event":"wicket","batsman_id":"1043","bowler_id":"96605","over":"3","ball":"6","score":"w","commentary":"Scott Currie to Max Holden, no run, c CP Wood b S Currie,","noball_dismissal":false,"text":"","timestamp":1749849438,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"1043","how_out":"c CP Wood b S Currie","batsman_runs":"38","batsman_balls":"18"},{"event":"overend","over":4,"runs":8,"score":"46\/1","bats":[{"runs":38,"balls_faced":18,"fours":5,"sixes":2,"batsman_id":1043},{"runs":5,"balls_faced":6,"fours":1,"sixes":0,"batsman_id":31}],"bowls":[{"runs_conceded":8,"maidens":0,"wickets":1,"bowler_id":96605,"overs":1},{"runs_conceded":17,"maidens":1,"wickets":0,"bowler_id":49478,"overs":2}],"commentary":"End of over 4 (8 runs), Middlesex 46\/1"},{"event_id":"12138155","event":"ball","batsman_id":"31","bowler_id":"1945","over":"4","ball":"1","score":4,"commentary":"Liam Dawson to Kane Williamson, Four,","noball_dismissal":false,"text":"","timestamp":1749849487,"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":"12138158","event":"ball","batsman_id":"31","bowler_id":"1945","over":"4","ball":"2","score":2,"commentary":"Liam Dawson to Kane Williamson, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749849490,"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":"12138159","event":"ball","batsman_id":"31","bowler_id":"1945","over":"4","ball":"3","score":4,"commentary":"Liam Dawson to Kane Williamson, Four,","noball_dismissal":false,"text":"","timestamp":1749849493,"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":"12138166","event":"ball","batsman_id":"31","bowler_id":"1945","over":"4","ball":"4","score":0,"commentary":"Liam Dawson to Kane Williamson, no run,","noball_dismissal":false,"text":"","timestamp":1749849832,"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":"12138167","event":"ball","batsman_id":"31","bowler_id":"1945","over":"4","ball":"5","score":6,"commentary":"Liam Dawson to Kane Williamson, Six,","noball_dismissal":false,"text":"","timestamp":1749849835,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12138169","event":"ball","batsman_id":"31","bowler_id":"1945","over":"4","ball":"6","score":1,"commentary":"Liam Dawson to Kane Williamson, 1 run,","noball_dismissal":false,"text":"","timestamp":1749849838,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":5,"runs":17,"score":"63\/1","bats":[{"runs":22,"balls_faced":12,"fours":3,"sixes":1,"batsman_id":31},{"runs":0,"balls_faced":0,"fours":0,"sixes":0,"batsman_id":108382}],"bowls":[{"runs_conceded":17,"maidens":0,"wickets":0,"bowler_id":1945,"overs":1},{"runs_conceded":8,"maidens":0,"wickets":1,"bowler_id":96605,"overs":1}],"commentary":"End of over 5 (17 runs), Middlesex 63\/1"},{"event_id":"12138170","event":"ball","batsman_id":"31","bowler_id":"96605","over":"5","ball":"1","score":1,"commentary":"Scott Currie to Kane Williamson, 1 run,","noball_dismissal":false,"text":"","timestamp":1749849840,"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":"12138171","event":"ball","batsman_id":"108382","bowler_id":"96605","over":"5","ball":"2","score":2,"commentary":"Scott Currie to Ben Geddes, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749849848,"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":"12138172","event":"ball","batsman_id":"108382","bowler_id":"96605","over":"5","ball":"3","score":2,"commentary":"Scott Currie to Ben Geddes, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749849851,"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":"12138173","event":"ball","batsman_id":"108382","bowler_id":"96605","over":"5","ball":"4","score":2,"commentary":"Scott Currie to Ben Geddes, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749849853,"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":"12138176","event":"ball","batsman_id":"108382","bowler_id":"96605","over":"5","ball":"5","score":4,"commentary":"Scott Currie to Ben Geddes, Four,","noball_dismissal":false,"text":"","timestamp":1749850089,"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":"12138183","event":"ball","batsman_id":"108382","bowler_id":"96605","over":"5","ball":"6","score":"1b","commentary":"Scott Currie to Ben Geddes, 1 bye,","noball_dismissal":false,"text":"","timestamp":1749850092,"run":1,"noball_run":"0","wide_run":"0","bye_run":"1","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":6,"runs":12,"score":"75\/1","bats":[{"runs":10,"balls_faced":5,"fours":1,"sixes":0,"batsman_id":108382},{"runs":23,"balls_faced":13,"fours":3,"sixes":1,"batsman_id":31}],"bowls":[{"runs_conceded":19,"maidens":0,"wickets":1,"bowler_id":96605,"overs":2},{"runs_conceded":17,"maidens":0,"wickets":0,"bowler_id":1945,"overs":1}],"commentary":"End of over 6 (12 runs), Middlesex 75\/1"}],"day":"0","session":"0","live_inning":{"iid":198013,"number":2,"name":"Middlesex Inning","short_name":"MID Inning","status":2,"issuperover":"false","result":4,"batting_team_id":7044,"fielding_team_id":7047,"scores":"75\/1","scores_full":"75\/1 (6 ov)","fielder":[{"fielder_id":"49478","fielder_name":"Chris Wood","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":"Max Holden","batsman_id":"1043","runs":"38","balls":"18","how_out":"c CP Wood b S Currie","score_at_dismissal":46,"overs_at_dismissal":"3.6","bowler_id":"96605","dismissal":"caught","number":1},"extra_runs":{"byes":1,"legbyes":3,"wides":0,"noballs":0,"penalty":"0","total":4},"equations":{"runs":75,"wickets":1,"overs":"6","bowlers_used":4,"runrate":"12.50"},"current_partnership":{"runs":29,"balls":12,"overs":2,"batsmen":[{"name":"Kane Williamson","batsman_id":31,"runs":18,"balls":7},{"name":"Ben Geddes","batsman_id":108382,"runs":10,"balls":5}]},"did_not_bat":[{"player_id":"102540","name":"Stephen Eskinazi"},{"player_id":"53281","name":"Leus du Plooy"},{"player_id":"49930","name":"Ryan Higgins"},{"player_id":"93517","name":"Jack Davies"},{"player_id":"93519","name":"Luke Hollman"},{"player_id":"44058","name":"Zafar Gohar"},{"player_id":"49497","name":"Tom Helm"},{"player_id":"140007","name":"Noah Cornwell"}],"max_over":"6","target":"76","recent_scores":"1,4,2,2,2,1,1,6,0,4,2,4,w,4,2,1,1,0","last_five_overs":"74\/1 14.80","last_ten_overs":"75\/1 12.50"},"teams":[{"tid":7044,"title":"Middlesex","abbr":"MID","alt_name":"MID","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/middlesex-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/middlesex-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"75\/1 (6 ov)","scores":"75\/1","overs":"6"},{"tid":7047,"title":"Hampshire","abbr":"HAM","alt_name":"HAM","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/hampshire-logo.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/hampshire-logo.png","country":"en","sex":"male","team_owner":"","head_coach":"","scores_full":"63\/1 (6 ov)","scores":"63\/1","overs":"6"}],"players":[{"pid":31,"title":"Kane Williamson","short_name":"K Williamson","first_name":"Kane Williamson","last_name":"","middle_name":"","birthdate":"1990-08-08","birthplace":"Tauranga","country":"nz","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/KaneWillTrain\/","twitter_profile":"https:\/\/twitter.com\/KaneWiliamson","instagram_profile":"https:\/\/www.instagram.com\/kane_s_w\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bat","role_str":""},{"pid":432,"title":"Kyle Abbott","short_name":"K Abbott","first_name":"Kyle Abbott","last_name":"","middle_name":"","birthdate":"1987-06-18","birthplace":"Empangeni, KwaZulu-Natal","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":1043,"title":"Max Holden","short_name":"MDE Holden","first_name":"Max Holden","last_name":"","middle_name":"","birthdate":"1997-12-18","birthplace":" Cambridge","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/maxholden_4","instagram_profile":"https:\/\/www.instagram.com\/maxholden4\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":1115,"title":"Josh Little","short_name":"JB Little","first_name":"Josh Little","last_name":"","middle_name":"","birthdate":"1999-11-01","birthplace":"Dublin","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/joshlittle13\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":1945,"title":"Liam Dawson","short_name":"L Dawson","first_name":"Liam Dawson","last_name":"","middle_name":"","birthdate":"1990-03-01","birthplace":"Swindon, Wiltshire","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right 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":"https:\/\/www.instagram.com\/daws128\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":1949,"title":"James Vince","short_name":"J Vince","first_name":"James Vince","last_name":"","middle_name":"","birthdate":"1991-03-14","birthplace":"Cuckfield, Sussex","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":9,"facebook_profile":"https:\/\/www.facebook.com\/vincey14\/","twitter_profile":"https:\/\/twitter.com\/vincey14","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":"(C)"},{"pid":32166,"title":"James Fuller","short_name":"JK Fuller","first_name":"James Fuller","last_name":"","middle_name":"","birthdate":"1990-01-24","birthplace":"Cape Town, Cape Province","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/James_Fuller246","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":44058,"title":"Zafar Gohar","short_name":"ZG Gohar","first_name":"Zafar Gohar","last_name":"","middle_name":"","birthdate":"1995-02-01","birthplace":"Lahore, Punjab","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/iamzafargohar","instagram_profile":"https:\/\/www.instagram.com\/iamzafargohar\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bowl","role_str":""},{"pid":46147,"title":"Bjorn Fortuin","short_name":"BC Fortuin","first_name":"Bjorn Fortuin","last_name":"","middle_name":"","birthdate":"1994-10-21","birthplace":"Paarl","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/bjorn_fortuin","instagram_profile":"https:\/\/www.instagram.com\/bjornfortuin\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":49334,"title":"Ben Brown","short_name":"BC Brown","first_name":"Ben Brown","last_name":"","middle_name":"","birthdate":"1988-11-23","birthplace":"Crawley, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper ","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Ben_Brown26","instagram_profile":"https:\/\/www.instagram.com\/benbrown26\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49343,"title":"Nick Gubbins","short_name":"NRT Gubbins","first_name":"Nick Gubbins","last_name":"","middle_name":"","birthdate":"1993-12-31","birthplace":"Richmond, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49478,"title":"Chris Wood","short_name":"CP Wood","first_name":"Chris Wood","last_name":"","middle_name":"","birthdate":"1990-06-27","birthplace":"Basingstoke, Hampshire","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":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/CWoody27","instagram_profile":"https:\/\/www.instagram.com\/cwood25\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49493,"title":"Sam Robson","short_name":"SD Robson","first_name":"Sam Robson","last_name":"","middle_name":"","birthdate":"1989-07-01","birthplace":"Paddington, Sydney, New South Wales","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"https:\/\/www.facebook.com\/samrobson664\/","twitter_profile":"https:\/\/twitter.com\/Samrobsonfans12","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49497,"title":"Tom Helm","short_name":"TG Helm","first_name":"Tom Helm","last_name":"","middle_name":"","birthdate":"1994-05-07","birthplace":"Stoke Mandeville Hospital, Buckinghamshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/TomHelm7","instagram_profile":"https:\/\/www.instagram.com\/helmy__7\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":49524,"title":"Benny Howell","short_name":"BAC Howell","first_name":"Benny Howell","last_name":"","middle_name":"","birthdate":"1988-10-05","birthplace":"Bordeaux, France","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":8,"facebook_profile":"https:\/\/www.facebook.com\/BennyHowellOfficial\/","twitter_profile":"https:\/\/twitter.com\/bennytweets_","instagram_profile":"https:\/\/www.instagram.com\/bennycam13\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":49536,"title":"Mark Stoneman","short_name":"MD Stoneman","first_name":"Mark Stoneman","last_name":"","middle_name":"","birthdate":"1987-06-26","birthplace":"Newcastle upon Tyne, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":18968,"recent_appearance":1514244600,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/mark23stone","instagram_profile":"https:\/\/www.instagram.com\/mark23stone\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49783,"title":"Toby Roland-Jones","short_name":"TS Roland-Jones","first_name":"Toby Roland-Jones","last_name":"","middle_name":"","birthdate":"1988-01-29","birthplace":"Ashford, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/tobyrj21","instagram_profile":"https:\/\/www.instagram.com\/tobyrj21\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":49930,"title":"Ryan Higgins","short_name":"RF Higgins","first_name":"Ryan Higgins","last_name":"","middle_name":"","birthdate":"1995-01-06","birthplace":"Harare, Zimbabwe","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":50481,"title":"Felix Organ","short_name":"FS Organ","first_name":"Felix Organ","last_name":"","middle_name":"","birthdate":"1999-06-02","birthplace":"Sydney","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":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":50484,"title":"Brad Wheal","short_name":"BTJ Wheal","first_name":"Brad Wheal","last_name":"","middle_name":"","birthdate":"1996-08-28","birthplace":"Durban, KwaZulu-Natal","country":"sct","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/brad.wheal\/","twitter_profile":"https:\/\/twitter.com\/BradWheal","instagram_profile":"https:\/\/www.instagram.com\/bradwheal\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":51285,"title":"Joe Weatherley","short_name":"JJ Weatherley","first_name":"Joe Weatherley","last_name":"","middle_name":"","birthdate":"1997-01-19","birthplace":"Winchester, Hampshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Joe_Weatherley","instagram_profile":"https:\/\/www.instagram.com\/jjweatherley\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":53281,"title":"Leus du Plooy","short_name":"JLdu Plooy","first_name":"Leus du Plooy","last_name":"","middle_name":"","birthdate":"1995-01-12","birthplace":"Pretoria, Gauteng,","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/leusdup76","instagram_profile":"https:\/\/www.instagram.com\/leusdup76\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","role_str":""},{"pid":90974,"title":"Henry Brookes","short_name":"HJH Brookes","first_name":"Henry Brookes","last_name":"","middle_name":"","birthdate":"1999-08-21","birthplace":"Solihull, Warwickshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/BrookesHenry","instagram_profile":"https:\/\/www.instagram.com\/henry.brookes\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":93517,"title":"Jack Davies","short_name":"JLB Davies","first_name":"Jack Davies","last_name":"","middle_name":"","birthdate":"2000-03-30","birthplace":"Reading, Berkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/daviesjlb","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(WK)"},{"pid":93519,"title":"Luke Hollman","short_name":"LBK Hollman","first_name":"Luke Hollman","last_name":"","middle_name":"","birthdate":"2000-09-16","birthplace":"Islington, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/lukehollman56\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":95552,"title":"Blake Cullen","short_name":"B Cullen","first_name":"Blake Cullen","last_name":"","middle_name":"","birthdate":"2002-02-19","birthplace":" Isleworth, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":96605,"title":"Scott Currie","short_name":"S Currie","first_name":"Scott Currie","last_name":"","middle_name":"","birthdate":"2001-05-02","birthplace":"Poole, Dorset","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"all","role_str":""},{"pid":101478,"title":"Joe Benjamin Cracknell","short_name":"JB Cracknell","first_name":"Joe Benjamin Cracknell","last_name":"","middle_name":"","birthdate":"2000-03-16","birthplace":"Enfield, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/joe_cracknell\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":102540,"title":"Stephen Eskinazi","short_name":"S Eskinazi","first_name":"Stephen Eskinazi","last_name":"","middle_name":"","birthdate":"1994-03-28","birthplace":"Johannesburg, Transvaal, South Africa","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/seskinazi","instagram_profile":"https:\/\/www.instagram.com\/seskinazi\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":"(C)"},{"pid":108376,"title":"Tom Prest","short_name":"T Prest","first_name":"Tom Prest","last_name":"","middle_name":"","birthdate":"2003-03-24","birthplace":"Wimborne, Dorset","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":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108377,"title":"Toby Albert","short_name":"T Albert","first_name":"Toby Albert","last_name":"","middle_name":"","birthdate":"2001-11-12","birthplace":"Basingstoke, Hampshire","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":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"wk","role_str":""},{"pid":108378,"title":"Fletcha Middleton","short_name":"F Middleton","first_name":"Fletcha Middleton","last_name":"","middle_name":"","birthdate":"2002-01-31","birthplace":"Winchester, Hampshire","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":108381,"title":"John Turner","short_name":"J Turner","first_name":"John Turner","last_name":"","middle_name":"","birthdate":"2001-04-10","birthplace":"Johannesburg, Gauteng","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":108382,"title":"Ben Geddes","short_name":"B Geddes","first_name":"Ben Geddes","last_name":"","middle_name":"","birthdate":"2001-07-31","birthplace":"Epsom, Surrey","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":108409,"title":"Sonny Baker","short_name":"S Baker","first_name":"Sonny Baker","last_name":"","middle_name":"","birthdate":"2003-03-13","birthplace":"Torbay, Devon","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/sonnybaker\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":109051,"title":"Ali Orr","short_name":"AGH Orr","first_name":"Ali Orr","last_name":"","middle_name":"","birthdate":"2001-04-06","birthplace":"Eastbourne, Sussex","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/alastairorr\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":110871,"title":"Dewald Brevis","short_name":"D Brevis","first_name":"Dewald Brevis","last_name":"","middle_name":"","birthdate":"2003-04-29","birthplace":"Johannesburg","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/Brevis17\/","twitter_profile":"https:\/\/twitter.com\/BrevisDewald","instagram_profile":"https:\/\/www.instagram.com\/dewald_brevis_17\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bat","role_str":""},{"pid":116661,"title":"Ishaan Kaushal","short_name":"I Kaushal","first_name":"Ishaan Kaushal","last_name":"","middle_name":"","birthdate":"2002-02-09","birthplace":"Hillingdon, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":127503,"title":"Josh De Caires","short_name":"J D caires","first_name":"Josh De Caires","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":128989,"title":"Lhuan dre Pretorius","short_name":"Ld Pretorius","first_name":"Lhuan dre Pretorius","last_name":"","middle_name":"","birthdate":"2006-03-27","birthplace":"Potchefstroom","country":"za","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"wk","role_str":"(WK)"},{"pid":129244,"title":"Nathan Fernandes","short_name":"N Fernandes","first_name":"Nathan Fernandes","last_name":"","middle_name":"","birthdate":"2004-04-26","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":133782,"title":"Sebastian Morgan","short_name":"SB Morgan","first_name":"Sebastian Morgan","last_name":"","middle_name":"","birthdate":"2007-08-30","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":140007,"title":"Noah Cornwell","short_name":"N Cornwell","first_name":"Noah Cornwell","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bowl","role_str":""},{"pid":146167,"title":"Aaryan Sawant","short_name":"A Sawant","first_name":"Aaryan Sawant","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""},{"pid":146171,"title":"Naavya Sharma","short_name":"N Sharma","first_name":"Naavya Sharma","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"squad","role_str":""}]},"etag":"37bc25d310565220e537dd7f0dedf213","modified":"2025-07-30 02:06:01","datetime":"2025-07-30 02:06:01","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86864 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:b55ed4d0-93c8-44bd-8626-fde2313158a0 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 86864 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (86864,3,'{"status":"ok","response":{"match_id":86864,"title":"Hampshire vs Middlesex","short_title":"HAM vs MID","subtitle":"Match 44","match_number":"44","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Match Tie (DLS Method)","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129425,"title":"Vitality Blast","abbr":"Vitality Blast","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-09-13","country":"en","total_matches":"133","total_rounds":"2","total_teams":"18"},"teama":{"team_id":7047,"name":"Hampshire","short_name":"HAM","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/hampshire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/hampshire-logo.png","scores_full":"63\/1 (6 ov)","scores":"63\/1","overs":"6"},"teamb":{"team_id":7044,"name":"Middlesex","short_name":"MID","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/middlesex-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/middlesex-logo.png","scores_full":"75\/1 (6 ov)","scores":"75\/1","overs":"6"},"date_start":"2025-06-13 18:00:00","date_end":"2025-06-14 04:00:00","timestamp_start":1749837600,"timestamp_end":1749873600,"date_start_ist":"2025-06-13 23:30:00","date_end_ist":"2025-06-14 09:30:00","venue":{"venue_id":"9","name":"The Rose Bowl","location":"Southampton","country":"England","timezone":""},"umpires":" Nigel Llong (England), Mark Newell (England)","referee":"Dean Cosker (England)","equation":"Match Tie (DLS Method)","live":"","result":"Match Tie (DLS Method)","result_type":5,"win_margin":"","winning_team_id":0,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-12 21:53:51","verify_time":"2025-06-14 03:07:50","match_dls_affected":"true","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":18.62,"humidity":88,"visibility":10000,"wind_speed":"4.70","clouds":100},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Middlesex elected to bowl","winner":7044,"decision":2}},"etag":"cffaf752614974b33ada0fd402076fba","modified":"2025-07-30 13:30:10","datetime":"2025-07-30 13:30:10","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":86864,"title":"Hampshire vs Middlesex","short_title":"HAM vs MID","subtitle":"Match 44","match_number":"44","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Match Tie (DLS Method)","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129425,"title":"Vitality Blast","abbr":"Vitality Blast","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-05-29","dateend":"2025-09-13","country":"en","total_matches":"133","total_rounds":"2","total_teams":"18"},"teama":{"team_id":7047,"name":"Hampshire","short_name":"HAM","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/hampshire-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/hampshire-logo.png","scores_full":"63\/1 (6 ov)","scores":"63\/1","overs":"6"},"teamb":{"team_id":7044,"name":"Middlesex","short_name":"MID","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/middlesex-logo.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/middlesex-logo.png","scores_full":"75\/1 (6 ov)","scores":"75\/1","overs":"6"},"date_start":"2025-06-13 18:00:00","date_end":"2025-06-14 04:00:00","timestamp_start":1749837600,"timestamp_end":1749873600,"date_start_ist":"2025-06-13 23:30:00","date_end_ist":"2025-06-14 09:30:00","venue":{"venue_id":"9","name":"The Rose Bowl","location":"Southampton","country":"England","timezone":""},"umpires":" Nigel Llong (England), Mark Newell (England)","referee":"Dean Cosker (England)","equation":"Match Tie (DLS Method)","live":"","result":"Match Tie (DLS Method)","result_type":5,"win_margin":"","winning_team_id":0,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-12 21:53:51","verify_time":"2025-06-14 03:07:50","match_dls_affected":"true","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":18.62,"humidity":88,"visibility":10000,"wind_speed":"4.70","clouds":100},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Middlesex elected to bowl","winner":7044,"decision":2}},"etag":"cffaf752614974b33ada0fd402076fba","modified":"2025-07-30 13:30:10","datetime":"2025-07-30 13:30:10","api_version":"3.0"}', Modified = GetDate() WHERE Id = 86864 AND DataTypeId = 3 END
Live Report & Scorecard of Hampshire vs Middlesex Match 44