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:5fa39316-7e4d-450f-be8f-542d46600b1a Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90844 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90844,1,'{"status":"ok","response":{"mid":90844,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Leinster Lightning won by 9 wickets","day_remaining_over":"","team_batting":"Leinster Lightning","team_bowling":"Northern Knights","live_inning_number":2,"live_score":{"runs":127,"overs":12.3,"wickets":1,"target":124,"runrate":10.16,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Tim Tector","batsman_id":102512,"runs":81,"balls_faced":43,"fours":8,"sixes":6,"strike_rate":"188.37"},{"name":"Harry Tector","batsman_id":1113,"runs":34,"balls_faced":20,"fours":3,"sixes":2,"strike_rate":"170.00"}],"bowlers":[{"name":"Cian Robertson","bowler_id":110545,"overs":3.3,"runs_conceded":18,"wickets":0,"maidens":0,"econ":"5.14"},{"name":"Matthew Humphreys","bowler_id":108029,"overs":4,"runs_conceded":37,"wickets":1,"maidens":0,"econ":"9.25"}],"commentaries":[{"event_id":"12267284","event":"ball","batsman_id":"102512","bowler_id":"110545","over":"8","ball":"2","score":4,"commentary":"Cian Robertson to Tim Tector, Four,","noball_dismissal":false,"text":"","timestamp":1751389416,"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":"12267293","event":"ball","batsman_id":"102512","bowler_id":"110545","over":"8","ball":"3","score":"1wd","commentary":"Cian Robertson to Tim Tector, 1 wide,","noball_dismissal":false,"text":"","timestamp":1751389467,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12267297","event":"ball","batsman_id":"102512","bowler_id":"110545","over":"8","ball":"3","score":"2lb","commentary":"Cian Robertson to Tim Tector, 2 leg bye,","noball_dismissal":false,"text":"","timestamp":1751389488,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"2","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12267306","event":"ball","batsman_id":"102512","bowler_id":"110545","over":"8","ball":"4","score":0,"commentary":"Cian Robertson to Tim Tector, no run,","noball_dismissal":false,"text":"","timestamp":1751389531,"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":"12267310","event":"ball","batsman_id":"102512","bowler_id":"110545","over":"8","ball":"5","score":1,"commentary":"Cian Robertson to Tim Tector, 1 run,","noball_dismissal":false,"text":"","timestamp":1751389535,"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":"12267314","event":"ball","batsman_id":"1113","bowler_id":"110545","over":"8","ball":"6","score":1,"commentary":"Cian Robertson to Harry Tector, 1 run,","noball_dismissal":false,"text":"","timestamp":1751389539,"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":9,"runs":10,"score":"85\/1","bats":[{"runs":14,"balls_faced":10,"fours":2,"sixes":0,"batsman_id":1113},{"runs":59,"balls_faced":32,"fours":5,"sixes":5,"batsman_id":102512}],"bowls":[{"runs_conceded":10,"maidens":0,"wickets":0,"bowler_id":110545,"overs":2},{"runs_conceded":20,"maidens":0,"wickets":1,"bowler_id":108029,"overs":3}],"commentary":"End of over 9 (10 runs), Leinster Lightning 85\/1"},{"event_id":"12267325","event":"ball","batsman_id":"1113","bowler_id":"47601","over":"9","ball":"1","score":1,"commentary":"Ruhan Pretorius to Harry Tector, 1 run,","noball_dismissal":false,"text":"","timestamp":1751389767,"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":"12267326","event":"ball","batsman_id":"102512","bowler_id":"47601","over":"9","ball":"2","score":1,"commentary":"Ruhan Pretorius to Tim Tector, 1 run,","noball_dismissal":false,"text":"","timestamp":1751389774,"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":"12267329","event":"ball","batsman_id":"1113","bowler_id":"47601","over":"9","ball":"3","score":1,"commentary":"Ruhan Pretorius to Harry Tector, 1 run,","noball_dismissal":false,"text":"","timestamp":1751389780,"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":"12267339","event":"ball","batsman_id":"102512","bowler_id":"47601","over":"9","ball":"4","score":4,"commentary":"Ruhan Pretorius to Tim Tector, Four,","noball_dismissal":false,"text":"","timestamp":1751389787,"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":"12267356","event":"ball","batsman_id":"102512","bowler_id":"47601","over":"9","ball":"5","score":4,"commentary":"Ruhan Pretorius to Tim Tector, Four,","noball_dismissal":false,"text":"","timestamp":1751389800,"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":"12267382","event":"ball","batsman_id":"102512","bowler_id":"47601","over":"9","ball":"6","score":6,"commentary":"Ruhan Pretorius to Tim Tector, Six,","noball_dismissal":false,"text":"","timestamp":1751389807,"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":"overend","over":10,"runs":17,"score":"102\/1","bats":[{"runs":74,"balls_faced":36,"fours":7,"sixes":6,"batsman_id":102512},{"runs":16,"balls_faced":12,"fours":2,"sixes":0,"batsman_id":1113}],"bowls":[{"runs_conceded":28,"maidens":0,"wickets":0,"bowler_id":47601,"overs":2},{"runs_conceded":10,"maidens":0,"wickets":0,"bowler_id":110545,"overs":2}],"commentary":"End of over 10 (17 runs), Leinster Lightning 102\/1"},{"event_id":"12267390","event":"ball","batsman_id":"1113","bowler_id":"110545","over":"10","ball":"1","score":0,"commentary":"Cian Robertson to Harry Tector, no run,","noball_dismissal":false,"text":"","timestamp":1751389858,"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":"12267396","event":"ball","batsman_id":"1113","bowler_id":"110545","over":"10","ball":"2","score":1,"commentary":"Cian Robertson to Harry Tector, 1 run,","noball_dismissal":false,"text":"","timestamp":1751389862,"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":"12267406","event":"ball","batsman_id":"102512","bowler_id":"110545","over":"10","ball":"3","score":0,"commentary":"Cian Robertson to Tim Tector, no run,","noball_dismissal":false,"text":"","timestamp":1751389897,"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":"12267414","event":"ball","batsman_id":"102512","bowler_id":"110545","over":"10","ball":"4","score":1,"commentary":"Cian Robertson to Tim Tector, 1 run,","noball_dismissal":false,"text":"","timestamp":1751389900,"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":"12267418","event":"ball","batsman_id":"1113","bowler_id":"110545","over":"10","ball":"5","score":1,"commentary":"Cian Robertson to Harry Tector, 1 run,","noball_dismissal":false,"text":"","timestamp":1751389932,"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":"12267422","event":"ball","batsman_id":"102512","bowler_id":"110545","over":"10","ball":"6","score":1,"commentary":"Cian Robertson to Tim Tector, 1 run,","noball_dismissal":false,"text":"","timestamp":1751389945,"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":11,"runs":4,"score":"106\/1","bats":[{"runs":76,"balls_faced":39,"fours":7,"sixes":6,"batsman_id":102512},{"runs":18,"balls_faced":15,"fours":2,"sixes":0,"batsman_id":1113}],"bowls":[{"runs_conceded":14,"maidens":0,"wickets":0,"bowler_id":110545,"overs":3},{"runs_conceded":28,"maidens":0,"wickets":0,"bowler_id":47601,"overs":2}],"commentary":"End of over 11 (4 runs), Leinster Lightning 106\/1"},{"event_id":"12267437","event":"ball","batsman_id":"102512","bowler_id":"108029","over":"11","ball":"1","score":1,"commentary":"Matthew Humphreys to Tim Tector, 1 run,","noball_dismissal":false,"text":"","timestamp":1751390026,"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":"12267448","event":"ball","batsman_id":"1113","bowler_id":"108029","over":"11","ball":"2","score":6,"commentary":"Matthew Humphreys to Harry Tector, Six,","noball_dismissal":false,"text":"","timestamp":1751390052,"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":"12267456","event":"ball","batsman_id":"1113","bowler_id":"108029","over":"11","ball":"3","score":0,"commentary":"Matthew Humphreys to Harry Tector, no run,","noball_dismissal":false,"text":"","timestamp":1751390088,"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":"12267463","event":"ball","batsman_id":"1113","bowler_id":"108029","over":"11","ball":"4","score":6,"commentary":"Matthew Humphreys to Harry Tector, Six,","noball_dismissal":false,"text":"","timestamp":1751390112,"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":"12267476","event":"ball","batsman_id":"1113","bowler_id":"108029","over":"11","ball":"5","score":0,"commentary":"Matthew Humphreys to Harry Tector, no run,","noball_dismissal":false,"text":"","timestamp":1751390140,"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":"12267488","event":"ball","batsman_id":"1113","bowler_id":"108029","over":"11","ball":"6","score":4,"commentary":"Matthew Humphreys to Harry Tector, Four,","noball_dismissal":false,"text":"","timestamp":1751390195,"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":12,"runs":17,"score":"123\/1","bats":[{"runs":34,"balls_faced":20,"fours":3,"sixes":2,"batsman_id":1113},{"runs":77,"balls_faced":40,"fours":7,"sixes":6,"batsman_id":102512}],"bowls":[{"runs_conceded":37,"maidens":0,"wickets":1,"bowler_id":108029,"overs":4},{"runs_conceded":14,"maidens":0,"wickets":0,"bowler_id":110545,"overs":3}],"commentary":"End of over 12 (17 runs), Leinster Lightning 123\/1"},{"event_id":"12267499","event":"ball","batsman_id":"102512","bowler_id":"110545","over":"12","ball":"1","score":0,"commentary":"Cian Robertson to Tim Tector, no run,","noball_dismissal":false,"text":"","timestamp":1751390228,"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":"12267503","event":"ball","batsman_id":"102512","bowler_id":"110545","over":"12","ball":"2","score":0,"commentary":"Cian Robertson to Tim Tector, no run,","noball_dismissal":false,"text":"","timestamp":1751390247,"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":"12267508","event":"ball","batsman_id":"102512","bowler_id":"110545","over":"12","ball":"3","score":4,"commentary":"Cian Robertson to Tim Tector, Four,","noball_dismissal":false,"text":"","timestamp":1751390264,"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}],"day":"0","session":"0","live_inning":{"iid":198997,"number":2,"name":"Leinster Lightning Inning","short_name":"LL Inning","status":2,"issuperover":"false","result":3,"batting_team_id":113541,"fielding_team_id":113540,"scores":"127\/1","scores_full":"127\/1 (12.3 ov)","fielder":[{"fielder_id":"110545","fielder_name":"Cian Robertson","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":"Chris Defreitas","batsman_id":"129746","runs":"7","balls":"12","how_out":"c Cian Robertson b M Humphreys","score_at_dismissal":53,"overs_at_dismissal":"4.6","bowler_id":"108029","dismissal":"caught","number":1},"extra_runs":{"byes":0,"legbyes":4,"wides":1,"noballs":0,"penalty":"0","total":5},"equations":{"runs":127,"wickets":1,"overs":"12.3","bowlers_used":5,"runrate":"10.16"},"current_partnership":{"runs":74,"balls":45,"overs":7.3,"batsmen":[{"name":"Tim Tector","batsman_id":102512,"runs":37,"balls":25},{"name":"Harry Tector","batsman_id":1113,"runs":34,"balls":20}]},"did_not_bat":[{"player_id":"1111","name":"Lorcan Tucker"},{"player_id":"107700","name":"Seamus Lynch"},{"player_id":"108815","name":"Gavin Hoey"},{"player_id":"231","name":"George Dockrell"},{"player_id":"50495","name":"Barry McCarthy"},{"player_id":"1115","name":"Josh Little"},{"player_id":"47254","name":"David Delany"},{"player_id":"149992","name":"Matt Hollard"}],"max_over":"20","target":"124","recent_scores":"4,0,0,4,0,6,0,6,1,1,1,1,0,1,0,6,4,4","last_five_overs":"54\/0 10.45","last_ten_overs":"97\/1 9.54"},"teams":[{"tid":113540,"title":"Northern Knights","abbr":"NK","alt_name":"Northern Knights","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-KNIG@2x55.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-KNIG@2x55.png","country":"ie","sex":"male","team_owner":"","head_coach":"","scores_full":"123\/10 (18.4 ov)","scores":"123\/10","overs":"18.4"},{"tid":113541,"title":"Leinster Lightning","abbr":"LL","alt_name":"Leinster Lightning","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-LLG@2x.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-LLG@2x.png","country":"ie","sex":"male","team_owner":"","head_coach":"","scores_full":"127\/1 (12.3 ov)","scores":"127\/1","overs":"12.3"}],"players":[{"pid":205,"title":"Paul Stirling","short_name":"P Stirling","first_name":"Paul Stirling","last_name":"","middle_name":"","birthdate":"1990-09-03","birthplace":"Belfast","country":"ie","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":"","twitter_profile":"https:\/\/twitter.com\/stirlo90","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bat","role_str":""},{"pid":231,"title":"George Dockrell","short_name":"G Dockrell","first_name":"George Dockrell","last_name":"","middle_name":"","birthdate":"1992-07-22","birthplace":"Dublin","country":"ie","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,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/georgedockrell","instagram_profile":"https:\/\/www.instagram.com\/dockrellg\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Ireland","role":"all","role_str":""},{"pid":1111,"title":"Lorcan Tucker","short_name":"LJ Tucker","first_name":"Lorcan Tucker","last_name":"","middle_name":"","birthdate":"1996-09-10","birthplace":"Dublin","country":"ie","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\/lorcan_tucker","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"wk","role_str":"(WK\/C)"},{"pid":1113,"title":"Harry Tector","short_name":"HT Tector","first_name":"Harry Tector","last_name":"","middle_name":"","birthdate":"1999-12-06","birthplace":"Dublin","country":"ie","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":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/harry_tector","instagram_profile":"https:\/\/www.instagram.com\/harrytector\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Ireland","role":"all","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bowl","role_str":""},{"pid":45644,"title":"Cade Carmichael","short_name":"C Carmichael","first_name":"Cade Carmichael","last_name":"","middle_name":"","birthdate":"2002-08-03","birthplace":"","country":"ie","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":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bat","role_str":""},{"pid":47254,"title":"David Delany","short_name":"DC Delany","first_name":"David Delany","last_name":"","middle_name":"","birthdate":"1997-12-28","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bowl","role_str":""},{"pid":47601,"title":"Ruhan Pretorius","short_name":"R Pretorius","first_name":"Ruhan Pretorius","last_name":"","middle_name":"","birthdate":"1991-03-02","birthplace":"","country":"za","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"all","role_str":""},{"pid":50495,"title":"Barry McCarthy","short_name":"BJ McCarthy","first_name":"Barry McCarthy","last_name":"","middle_name":"","birthdate":"1992-09-13","birthplace":"Dublin, Ireland","country":"ie","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":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/barrymccarthy2","instagram_profile":"https:\/\/www.instagram.com\/barrymccarthy2\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bowl","role_str":""},{"pid":50724,"title":"Mark Adair","short_name":"MR Adair","first_name":"Mark Adair","last_name":"","middle_name":"","birthdate":"1996-03-27","birthplace":"Holywood, Northern Ireland","country":"ie","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":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/MarkkAdairr","instagram_profile":"https:\/\/www.instagram.com\/markadair32\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":56993,"title":"Nasir Totakhil","short_name":"Nasir Totakhil","first_name":"Nasir Totakhil","last_name":"","middle_name":"","birthdate":"2000-03-15","birthplace":"","country":"af","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":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Afghanistan","role":"squad","role_str":""},{"pid":62503,"title":"James McCollum","short_name":"JA McCollum","first_name":"James McCollum","last_name":"","middle_name":"","birthdate":"1995-08-01","birthplace":"Lisburn, United Kingdom","country":"ie","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/JMccollum95","instagram_profile":"https:\/\/www.instagram.com\/james_mccollum07\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":83434,"title":"Sean Davey","short_name":"SB Davey","first_name":"Sean Davey","last_name":"","middle_name":"","birthdate":"1993-04-08","birthplace":"","country":"nz","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":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"all","role_str":""},{"pid":84894,"title":"Ross Adair","short_name":"GR Adair","first_name":"Ross Adair","last_name":"","middle_name":"","birthdate":"1994-04-21","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/GRAdair11","instagram_profile":"https:\/\/www.instagram.com\/radair438\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bat","role_str":""},{"pid":93614,"title":"Neil Rock","short_name":"N Rock","first_name":"Neil Rock","last_name":"","middle_name":"","birthdate":"2000-09-24","birthplace":"Dublin, Ireland","country":"ie","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":23793,"recent_appearance":1515879000,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/pebsrock015","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"wk","role_str":"(WK\/C)"},{"pid":93615,"title":"Morgan Topping","short_name":"M Topping","first_name":"Morgan Topping","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":23793,"recent_appearance":1515879000,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bat","role_str":""},{"pid":94845,"title":"Abidullah Taniwal","short_name":"A Taniwal","first_name":"Abidullah Taniwal","last_name":"","middle_name":"","birthdate":"2002-01-23","birthplace":"","country":"af","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Afghanistan","role":"squad","role_str":""},{"pid":95830,"title":"Fionn Hand","short_name":"F Hand","first_name":"Fionn Hand","last_name":"","middle_name":"","birthdate":"1998-07-01","birthplace":"Dublin","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/HandFionn","instagram_profile":"https:\/\/www.instagram.com\/fionn.hand7\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":96768,"title":"Benjamin Calitz","short_name":"B Calitz","first_name":"Benjamin Calitz","last_name":"","middle_name":"","birthdate":"2002-07-06","birthplace":"","country":"ca","primary_team":[],"logo_url":"","playing_role":"wk","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":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Canada","role":"wk","role_str":""},{"pid":102512,"title":"Tim Tector","short_name":"T Tector","first_name":"Tim Tector","last_name":"","middle_name":"","birthdate":"2003-03-07","birthplace":"","country":"ie","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":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bat","role_str":""},{"pid":102525,"title":"Matthew Foster","short_name":"M Foster","first_name":"Matthew Foster","last_name":"","middle_name":"","birthdate":"2000-01-15","birthplace":"Belfast, United Kingdom","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left 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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":107700,"title":"Seamus Lynch","short_name":"S Lynch","first_name":"Seamus Lynch","last_name":"","middle_name":"","birthdate":"2001-01-01","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"wk","role_str":""},{"pid":108029,"title":"Matthew Humphreys","short_name":"M Humphreys","first_name":"Matthew Humphreys","last_name":"","middle_name":"","birthdate":"2002-09-28","birthplace":"","country":"ie","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bowl","role_str":""},{"pid":108815,"title":"Gavin Hoey","short_name":"G Hoey","first_name":"Gavin Hoey","last_name":"","middle_name":"","birthdate":"2001-11-05","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Ireland","role":"all","role_str":""},{"pid":110544,"title":"Thomas Mayes","short_name":"T Mayes","first_name":"Thomas Mayes","last_name":"","middle_name":"","birthdate":"2001-01-04","birthplace":"South Africa","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bowl","role_str":""},{"pid":110545,"title":"Cian Robertson","short_name":"Cian Robertson","first_name":"Cian Robertson","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bowl","role_str":""},{"pid":113238,"title":"Reuben Wilson","short_name":"RB Wilson","first_name":"Reuben Wilson","last_name":"","middle_name":"","birthdate":"2006-09-17","birthplace":"Dublin","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":118983,"title":"Carson McCullough","short_name":"C McCullough","first_name":"Carson McCullough","last_name":"","middle_name":"","birthdate":"2005-02-28","birthplace":"Belfast, NI","country":"ie","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":124979,"title":"Adam Kennedy","short_name":"A Kennedy","first_name":"Adam Kennedy","last_name":"","middle_name":"","birthdate":"2003-10-22","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":127148,"title":"Adam Rosslee","short_name":"A Rosslee","first_name":"Adam Rosslee","last_name":"","middle_name":"","birthdate":"2003-09-12","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":127842,"title":"Harry Dyer","short_name":"H Dyer","first_name":"Harry Dyer","last_name":"","middle_name":"","birthdate":"2006-03-15","birthplace":"Belfast","country":"ie","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":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":129473,"title":"Jordan Neill","short_name":"JE Neill","first_name":"Jordan Neill","last_name":"","middle_name":"","birthdate":"2005-09-03","birthplace":"Cape Town","country":"ie","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":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":129474,"title":"Macdara Cosgrave","short_name":"MC Cosgrave","first_name":"Macdara Cosgrave","last_name":"","middle_name":"","birthdate":"2005-11-10","birthplace":"London","country":"ie","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":129746,"title":"Chris Defreitas","short_name":"CH Defreitas","first_name":"Chris Defreitas","last_name":"","middle_name":"","birthdate":"2002-02-06","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bat","role_str":""},{"pid":130424,"title":"Dylan Lues","short_name":"D Lues","first_name":"Dylan Lues","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":135154,"title":"Adam Leckey","short_name":"A Leckey","first_name":"Adam Leckey","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":141984,"title":"Jai Moondra","short_name":"J Moondra","first_name":"Jai Moondra","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":143051,"title":"Melvin Deveraj","short_name":"M Deveraj","first_name":"Melvin Deveraj","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":143168,"title":"Matthew Halliday","short_name":"Matthew Halliday","first_name":"Matthew Halliday","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":144217,"title":"Daniel Murray","short_name":"D Murray","first_name":"Daniel Murray","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":149977,"title":"Cameron Rowe","short_name":"CM Rowe","first_name":"Cameron Rowe","last_name":"","middle_name":"","birthdate":"2001-05-06","birthplace":"","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":149978,"title":"Mark Tonge","short_name":"MR Tonge","first_name":"Mark Tonge","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":149990,"title":"Younis Ahmadzai","short_name":"Y Ahmadzai","first_name":"Younis Ahmadzai","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"af","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Afghanistan","role":"squad","role_str":""},{"pid":149991,"title":"Jordan Hollard","short_name":"Jordan Hollard","first_name":"Jordan Hollard","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"za","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":149992,"title":"Matt Hollard","short_name":"M Hollard","first_name":"Matt Hollard","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bowl","role_str":""}]},"etag":"6428eb31aeed2578fa308ad2810ca388","modified":"2025-07-15 23:34:47","datetime":"2025-07-15 23:34:47","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":90844,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Leinster Lightning won by 9 wickets","day_remaining_over":"","team_batting":"Leinster Lightning","team_bowling":"Northern Knights","live_inning_number":2,"live_score":{"runs":127,"overs":12.3,"wickets":1,"target":124,"runrate":10.16,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Tim Tector","batsman_id":102512,"runs":81,"balls_faced":43,"fours":8,"sixes":6,"strike_rate":"188.37"},{"name":"Harry Tector","batsman_id":1113,"runs":34,"balls_faced":20,"fours":3,"sixes":2,"strike_rate":"170.00"}],"bowlers":[{"name":"Cian Robertson","bowler_id":110545,"overs":3.3,"runs_conceded":18,"wickets":0,"maidens":0,"econ":"5.14"},{"name":"Matthew Humphreys","bowler_id":108029,"overs":4,"runs_conceded":37,"wickets":1,"maidens":0,"econ":"9.25"}],"commentaries":[{"event_id":"12267284","event":"ball","batsman_id":"102512","bowler_id":"110545","over":"8","ball":"2","score":4,"commentary":"Cian Robertson to Tim Tector, Four,","noball_dismissal":false,"text":"","timestamp":1751389416,"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":"12267293","event":"ball","batsman_id":"102512","bowler_id":"110545","over":"8","ball":"3","score":"1wd","commentary":"Cian Robertson to Tim Tector, 1 wide,","noball_dismissal":false,"text":"","timestamp":1751389467,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12267297","event":"ball","batsman_id":"102512","bowler_id":"110545","over":"8","ball":"3","score":"2lb","commentary":"Cian Robertson to Tim Tector, 2 leg bye,","noball_dismissal":false,"text":"","timestamp":1751389488,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"2","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12267306","event":"ball","batsman_id":"102512","bowler_id":"110545","over":"8","ball":"4","score":0,"commentary":"Cian Robertson to Tim Tector, no run,","noball_dismissal":false,"text":"","timestamp":1751389531,"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":"12267310","event":"ball","batsman_id":"102512","bowler_id":"110545","over":"8","ball":"5","score":1,"commentary":"Cian Robertson to Tim Tector, 1 run,","noball_dismissal":false,"text":"","timestamp":1751389535,"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":"12267314","event":"ball","batsman_id":"1113","bowler_id":"110545","over":"8","ball":"6","score":1,"commentary":"Cian Robertson to Harry Tector, 1 run,","noball_dismissal":false,"text":"","timestamp":1751389539,"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":9,"runs":10,"score":"85\/1","bats":[{"runs":14,"balls_faced":10,"fours":2,"sixes":0,"batsman_id":1113},{"runs":59,"balls_faced":32,"fours":5,"sixes":5,"batsman_id":102512}],"bowls":[{"runs_conceded":10,"maidens":0,"wickets":0,"bowler_id":110545,"overs":2},{"runs_conceded":20,"maidens":0,"wickets":1,"bowler_id":108029,"overs":3}],"commentary":"End of over 9 (10 runs), Leinster Lightning 85\/1"},{"event_id":"12267325","event":"ball","batsman_id":"1113","bowler_id":"47601","over":"9","ball":"1","score":1,"commentary":"Ruhan Pretorius to Harry Tector, 1 run,","noball_dismissal":false,"text":"","timestamp":1751389767,"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":"12267326","event":"ball","batsman_id":"102512","bowler_id":"47601","over":"9","ball":"2","score":1,"commentary":"Ruhan Pretorius to Tim Tector, 1 run,","noball_dismissal":false,"text":"","timestamp":1751389774,"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":"12267329","event":"ball","batsman_id":"1113","bowler_id":"47601","over":"9","ball":"3","score":1,"commentary":"Ruhan Pretorius to Harry Tector, 1 run,","noball_dismissal":false,"text":"","timestamp":1751389780,"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":"12267339","event":"ball","batsman_id":"102512","bowler_id":"47601","over":"9","ball":"4","score":4,"commentary":"Ruhan Pretorius to Tim Tector, Four,","noball_dismissal":false,"text":"","timestamp":1751389787,"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":"12267356","event":"ball","batsman_id":"102512","bowler_id":"47601","over":"9","ball":"5","score":4,"commentary":"Ruhan Pretorius to Tim Tector, Four,","noball_dismissal":false,"text":"","timestamp":1751389800,"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":"12267382","event":"ball","batsman_id":"102512","bowler_id":"47601","over":"9","ball":"6","score":6,"commentary":"Ruhan Pretorius to Tim Tector, Six,","noball_dismissal":false,"text":"","timestamp":1751389807,"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":"overend","over":10,"runs":17,"score":"102\/1","bats":[{"runs":74,"balls_faced":36,"fours":7,"sixes":6,"batsman_id":102512},{"runs":16,"balls_faced":12,"fours":2,"sixes":0,"batsman_id":1113}],"bowls":[{"runs_conceded":28,"maidens":0,"wickets":0,"bowler_id":47601,"overs":2},{"runs_conceded":10,"maidens":0,"wickets":0,"bowler_id":110545,"overs":2}],"commentary":"End of over 10 (17 runs), Leinster Lightning 102\/1"},{"event_id":"12267390","event":"ball","batsman_id":"1113","bowler_id":"110545","over":"10","ball":"1","score":0,"commentary":"Cian Robertson to Harry Tector, no run,","noball_dismissal":false,"text":"","timestamp":1751389858,"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":"12267396","event":"ball","batsman_id":"1113","bowler_id":"110545","over":"10","ball":"2","score":1,"commentary":"Cian Robertson to Harry Tector, 1 run,","noball_dismissal":false,"text":"","timestamp":1751389862,"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":"12267406","event":"ball","batsman_id":"102512","bowler_id":"110545","over":"10","ball":"3","score":0,"commentary":"Cian Robertson to Tim Tector, no run,","noball_dismissal":false,"text":"","timestamp":1751389897,"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":"12267414","event":"ball","batsman_id":"102512","bowler_id":"110545","over":"10","ball":"4","score":1,"commentary":"Cian Robertson to Tim Tector, 1 run,","noball_dismissal":false,"text":"","timestamp":1751389900,"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":"12267418","event":"ball","batsman_id":"1113","bowler_id":"110545","over":"10","ball":"5","score":1,"commentary":"Cian Robertson to Harry Tector, 1 run,","noball_dismissal":false,"text":"","timestamp":1751389932,"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":"12267422","event":"ball","batsman_id":"102512","bowler_id":"110545","over":"10","ball":"6","score":1,"commentary":"Cian Robertson to Tim Tector, 1 run,","noball_dismissal":false,"text":"","timestamp":1751389945,"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":11,"runs":4,"score":"106\/1","bats":[{"runs":76,"balls_faced":39,"fours":7,"sixes":6,"batsman_id":102512},{"runs":18,"balls_faced":15,"fours":2,"sixes":0,"batsman_id":1113}],"bowls":[{"runs_conceded":14,"maidens":0,"wickets":0,"bowler_id":110545,"overs":3},{"runs_conceded":28,"maidens":0,"wickets":0,"bowler_id":47601,"overs":2}],"commentary":"End of over 11 (4 runs), Leinster Lightning 106\/1"},{"event_id":"12267437","event":"ball","batsman_id":"102512","bowler_id":"108029","over":"11","ball":"1","score":1,"commentary":"Matthew Humphreys to Tim Tector, 1 run,","noball_dismissal":false,"text":"","timestamp":1751390026,"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":"12267448","event":"ball","batsman_id":"1113","bowler_id":"108029","over":"11","ball":"2","score":6,"commentary":"Matthew Humphreys to Harry Tector, Six,","noball_dismissal":false,"text":"","timestamp":1751390052,"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":"12267456","event":"ball","batsman_id":"1113","bowler_id":"108029","over":"11","ball":"3","score":0,"commentary":"Matthew Humphreys to Harry Tector, no run,","noball_dismissal":false,"text":"","timestamp":1751390088,"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":"12267463","event":"ball","batsman_id":"1113","bowler_id":"108029","over":"11","ball":"4","score":6,"commentary":"Matthew Humphreys to Harry Tector, Six,","noball_dismissal":false,"text":"","timestamp":1751390112,"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":"12267476","event":"ball","batsman_id":"1113","bowler_id":"108029","over":"11","ball":"5","score":0,"commentary":"Matthew Humphreys to Harry Tector, no run,","noball_dismissal":false,"text":"","timestamp":1751390140,"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":"12267488","event":"ball","batsman_id":"1113","bowler_id":"108029","over":"11","ball":"6","score":4,"commentary":"Matthew Humphreys to Harry Tector, Four,","noball_dismissal":false,"text":"","timestamp":1751390195,"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":12,"runs":17,"score":"123\/1","bats":[{"runs":34,"balls_faced":20,"fours":3,"sixes":2,"batsman_id":1113},{"runs":77,"balls_faced":40,"fours":7,"sixes":6,"batsman_id":102512}],"bowls":[{"runs_conceded":37,"maidens":0,"wickets":1,"bowler_id":108029,"overs":4},{"runs_conceded":14,"maidens":0,"wickets":0,"bowler_id":110545,"overs":3}],"commentary":"End of over 12 (17 runs), Leinster Lightning 123\/1"},{"event_id":"12267499","event":"ball","batsman_id":"102512","bowler_id":"110545","over":"12","ball":"1","score":0,"commentary":"Cian Robertson to Tim Tector, no run,","noball_dismissal":false,"text":"","timestamp":1751390228,"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":"12267503","event":"ball","batsman_id":"102512","bowler_id":"110545","over":"12","ball":"2","score":0,"commentary":"Cian Robertson to Tim Tector, no run,","noball_dismissal":false,"text":"","timestamp":1751390247,"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":"12267508","event":"ball","batsman_id":"102512","bowler_id":"110545","over":"12","ball":"3","score":4,"commentary":"Cian Robertson to Tim Tector, Four,","noball_dismissal":false,"text":"","timestamp":1751390264,"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}],"day":"0","session":"0","live_inning":{"iid":198997,"number":2,"name":"Leinster Lightning Inning","short_name":"LL Inning","status":2,"issuperover":"false","result":3,"batting_team_id":113541,"fielding_team_id":113540,"scores":"127\/1","scores_full":"127\/1 (12.3 ov)","fielder":[{"fielder_id":"110545","fielder_name":"Cian Robertson","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":"Chris Defreitas","batsman_id":"129746","runs":"7","balls":"12","how_out":"c Cian Robertson b M Humphreys","score_at_dismissal":53,"overs_at_dismissal":"4.6","bowler_id":"108029","dismissal":"caught","number":1},"extra_runs":{"byes":0,"legbyes":4,"wides":1,"noballs":0,"penalty":"0","total":5},"equations":{"runs":127,"wickets":1,"overs":"12.3","bowlers_used":5,"runrate":"10.16"},"current_partnership":{"runs":74,"balls":45,"overs":7.3,"batsmen":[{"name":"Tim Tector","batsman_id":102512,"runs":37,"balls":25},{"name":"Harry Tector","batsman_id":1113,"runs":34,"balls":20}]},"did_not_bat":[{"player_id":"1111","name":"Lorcan Tucker"},{"player_id":"107700","name":"Seamus Lynch"},{"player_id":"108815","name":"Gavin Hoey"},{"player_id":"231","name":"George Dockrell"},{"player_id":"50495","name":"Barry McCarthy"},{"player_id":"1115","name":"Josh Little"},{"player_id":"47254","name":"David Delany"},{"player_id":"149992","name":"Matt Hollard"}],"max_over":"20","target":"124","recent_scores":"4,0,0,4,0,6,0,6,1,1,1,1,0,1,0,6,4,4","last_five_overs":"54\/0 10.45","last_ten_overs":"97\/1 9.54"},"teams":[{"tid":113540,"title":"Northern Knights","abbr":"NK","alt_name":"Northern Knights","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-KNIG@2x55.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-KNIG@2x55.png","country":"ie","sex":"male","team_owner":"","head_coach":"","scores_full":"123\/10 (18.4 ov)","scores":"123\/10","overs":"18.4"},{"tid":113541,"title":"Leinster Lightning","abbr":"LL","alt_name":"Leinster Lightning","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-LLG@2x.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-LLG@2x.png","country":"ie","sex":"male","team_owner":"","head_coach":"","scores_full":"127\/1 (12.3 ov)","scores":"127\/1","overs":"12.3"}],"players":[{"pid":205,"title":"Paul Stirling","short_name":"P Stirling","first_name":"Paul Stirling","last_name":"","middle_name":"","birthdate":"1990-09-03","birthplace":"Belfast","country":"ie","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":"","twitter_profile":"https:\/\/twitter.com\/stirlo90","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bat","role_str":""},{"pid":231,"title":"George Dockrell","short_name":"G Dockrell","first_name":"George Dockrell","last_name":"","middle_name":"","birthdate":"1992-07-22","birthplace":"Dublin","country":"ie","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,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/georgedockrell","instagram_profile":"https:\/\/www.instagram.com\/dockrellg\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Ireland","role":"all","role_str":""},{"pid":1111,"title":"Lorcan Tucker","short_name":"LJ Tucker","first_name":"Lorcan Tucker","last_name":"","middle_name":"","birthdate":"1996-09-10","birthplace":"Dublin","country":"ie","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\/lorcan_tucker","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"wk","role_str":"(WK\/C)"},{"pid":1113,"title":"Harry Tector","short_name":"HT Tector","first_name":"Harry Tector","last_name":"","middle_name":"","birthdate":"1999-12-06","birthplace":"Dublin","country":"ie","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":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/harry_tector","instagram_profile":"https:\/\/www.instagram.com\/harrytector\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Ireland","role":"all","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bowl","role_str":""},{"pid":45644,"title":"Cade Carmichael","short_name":"C Carmichael","first_name":"Cade Carmichael","last_name":"","middle_name":"","birthdate":"2002-08-03","birthplace":"","country":"ie","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":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bat","role_str":""},{"pid":47254,"title":"David Delany","short_name":"DC Delany","first_name":"David Delany","last_name":"","middle_name":"","birthdate":"1997-12-28","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bowl","role_str":""},{"pid":47601,"title":"Ruhan Pretorius","short_name":"R Pretorius","first_name":"Ruhan Pretorius","last_name":"","middle_name":"","birthdate":"1991-03-02","birthplace":"","country":"za","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"all","role_str":""},{"pid":50495,"title":"Barry McCarthy","short_name":"BJ McCarthy","first_name":"Barry McCarthy","last_name":"","middle_name":"","birthdate":"1992-09-13","birthplace":"Dublin, Ireland","country":"ie","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":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/barrymccarthy2","instagram_profile":"https:\/\/www.instagram.com\/barrymccarthy2\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bowl","role_str":""},{"pid":50724,"title":"Mark Adair","short_name":"MR Adair","first_name":"Mark Adair","last_name":"","middle_name":"","birthdate":"1996-03-27","birthplace":"Holywood, Northern Ireland","country":"ie","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":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/MarkkAdairr","instagram_profile":"https:\/\/www.instagram.com\/markadair32\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":56993,"title":"Nasir Totakhil","short_name":"Nasir Totakhil","first_name":"Nasir Totakhil","last_name":"","middle_name":"","birthdate":"2000-03-15","birthplace":"","country":"af","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":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Afghanistan","role":"squad","role_str":""},{"pid":62503,"title":"James McCollum","short_name":"JA McCollum","first_name":"James McCollum","last_name":"","middle_name":"","birthdate":"1995-08-01","birthplace":"Lisburn, United Kingdom","country":"ie","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/JMccollum95","instagram_profile":"https:\/\/www.instagram.com\/james_mccollum07\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":83434,"title":"Sean Davey","short_name":"SB Davey","first_name":"Sean Davey","last_name":"","middle_name":"","birthdate":"1993-04-08","birthplace":"","country":"nz","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":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"all","role_str":""},{"pid":84894,"title":"Ross Adair","short_name":"GR Adair","first_name":"Ross Adair","last_name":"","middle_name":"","birthdate":"1994-04-21","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/GRAdair11","instagram_profile":"https:\/\/www.instagram.com\/radair438\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bat","role_str":""},{"pid":93614,"title":"Neil Rock","short_name":"N Rock","first_name":"Neil Rock","last_name":"","middle_name":"","birthdate":"2000-09-24","birthplace":"Dublin, Ireland","country":"ie","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":23793,"recent_appearance":1515879000,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/pebsrock015","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"wk","role_str":"(WK\/C)"},{"pid":93615,"title":"Morgan Topping","short_name":"M Topping","first_name":"Morgan Topping","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":23793,"recent_appearance":1515879000,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bat","role_str":""},{"pid":94845,"title":"Abidullah Taniwal","short_name":"A Taniwal","first_name":"Abidullah Taniwal","last_name":"","middle_name":"","birthdate":"2002-01-23","birthplace":"","country":"af","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Afghanistan","role":"squad","role_str":""},{"pid":95830,"title":"Fionn Hand","short_name":"F Hand","first_name":"Fionn Hand","last_name":"","middle_name":"","birthdate":"1998-07-01","birthplace":"Dublin","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/HandFionn","instagram_profile":"https:\/\/www.instagram.com\/fionn.hand7\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":96768,"title":"Benjamin Calitz","short_name":"B Calitz","first_name":"Benjamin Calitz","last_name":"","middle_name":"","birthdate":"2002-07-06","birthplace":"","country":"ca","primary_team":[],"logo_url":"","playing_role":"wk","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":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Canada","role":"wk","role_str":""},{"pid":102512,"title":"Tim Tector","short_name":"T Tector","first_name":"Tim Tector","last_name":"","middle_name":"","birthdate":"2003-03-07","birthplace":"","country":"ie","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":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bat","role_str":""},{"pid":102525,"title":"Matthew Foster","short_name":"M Foster","first_name":"Matthew Foster","last_name":"","middle_name":"","birthdate":"2000-01-15","birthplace":"Belfast, United Kingdom","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left 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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":107700,"title":"Seamus Lynch","short_name":"S Lynch","first_name":"Seamus Lynch","last_name":"","middle_name":"","birthdate":"2001-01-01","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"wk","role_str":""},{"pid":108029,"title":"Matthew Humphreys","short_name":"M Humphreys","first_name":"Matthew Humphreys","last_name":"","middle_name":"","birthdate":"2002-09-28","birthplace":"","country":"ie","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bowl","role_str":""},{"pid":108815,"title":"Gavin Hoey","short_name":"G Hoey","first_name":"Gavin Hoey","last_name":"","middle_name":"","birthdate":"2001-11-05","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Ireland","role":"all","role_str":""},{"pid":110544,"title":"Thomas Mayes","short_name":"T Mayes","first_name":"Thomas Mayes","last_name":"","middle_name":"","birthdate":"2001-01-04","birthplace":"South Africa","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bowl","role_str":""},{"pid":110545,"title":"Cian Robertson","short_name":"Cian Robertson","first_name":"Cian Robertson","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bowl","role_str":""},{"pid":113238,"title":"Reuben Wilson","short_name":"RB Wilson","first_name":"Reuben Wilson","last_name":"","middle_name":"","birthdate":"2006-09-17","birthplace":"Dublin","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":118983,"title":"Carson McCullough","short_name":"C McCullough","first_name":"Carson McCullough","last_name":"","middle_name":"","birthdate":"2005-02-28","birthplace":"Belfast, NI","country":"ie","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":124979,"title":"Adam Kennedy","short_name":"A Kennedy","first_name":"Adam Kennedy","last_name":"","middle_name":"","birthdate":"2003-10-22","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":127148,"title":"Adam Rosslee","short_name":"A Rosslee","first_name":"Adam Rosslee","last_name":"","middle_name":"","birthdate":"2003-09-12","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":127842,"title":"Harry Dyer","short_name":"H Dyer","first_name":"Harry Dyer","last_name":"","middle_name":"","birthdate":"2006-03-15","birthplace":"Belfast","country":"ie","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":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":129473,"title":"Jordan Neill","short_name":"JE Neill","first_name":"Jordan Neill","last_name":"","middle_name":"","birthdate":"2005-09-03","birthplace":"Cape Town","country":"ie","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":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":129474,"title":"Macdara Cosgrave","short_name":"MC Cosgrave","first_name":"Macdara Cosgrave","last_name":"","middle_name":"","birthdate":"2005-11-10","birthplace":"London","country":"ie","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":129746,"title":"Chris Defreitas","short_name":"CH Defreitas","first_name":"Chris Defreitas","last_name":"","middle_name":"","birthdate":"2002-02-06","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bat","role_str":""},{"pid":130424,"title":"Dylan Lues","short_name":"D Lues","first_name":"Dylan Lues","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":135154,"title":"Adam Leckey","short_name":"A Leckey","first_name":"Adam Leckey","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":141984,"title":"Jai Moondra","short_name":"J Moondra","first_name":"Jai Moondra","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":143051,"title":"Melvin Deveraj","short_name":"M Deveraj","first_name":"Melvin Deveraj","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":143168,"title":"Matthew Halliday","short_name":"Matthew Halliday","first_name":"Matthew Halliday","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":144217,"title":"Daniel Murray","short_name":"D Murray","first_name":"Daniel Murray","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":149977,"title":"Cameron Rowe","short_name":"CM Rowe","first_name":"Cameron Rowe","last_name":"","middle_name":"","birthdate":"2001-05-06","birthplace":"","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":149978,"title":"Mark Tonge","short_name":"MR Tonge","first_name":"Mark Tonge","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":149990,"title":"Younis Ahmadzai","short_name":"Y Ahmadzai","first_name":"Younis Ahmadzai","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"af","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Afghanistan","role":"squad","role_str":""},{"pid":149991,"title":"Jordan Hollard","short_name":"Jordan Hollard","first_name":"Jordan Hollard","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"za","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"squad","role_str":""},{"pid":149992,"title":"Matt Hollard","short_name":"M Hollard","first_name":"Matt Hollard","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"bowl","role_str":""}]},"etag":"6428eb31aeed2578fa308ad2810ca388","modified":"2025-07-15 23:34:47","datetime":"2025-07-15 23:34:47","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90844 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:5fa39316-7e4d-450f-be8f-542d46600b1a Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90844 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90844,3,'{"status":"ok","response":{"match_id":90844,"title":"Northern Knights vs Leinster Lightning","short_title":"NK vs LL","subtitle":"Match 14","match_number":"14","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Leinster Lightning won by 9 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129638,"title":"Ireland Inter-Provincial T20 Trophy","abbr":"Ireland 20 Over Trophy","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-06-17","dateend":"2025-09-13","country":"ie","total_matches":"24","total_rounds":"1","total_teams":"4"},"teama":{"team_id":113540,"name":"Northern Knights","short_name":"NK","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-KNIG@2x55.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-KNIG@2x55.png","scores_full":"123\/10 (18.4 ov)","scores":"123\/10","overs":"18.4"},"teamb":{"team_id":113541,"name":"Leinster Lightning","short_name":"LL","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-LLG@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-LLG@2x.png","scores_full":"127\/1 (12.3 ov)","scores":"127\/1","overs":"12.3"},"date_start":"2025-07-01 14:45:00","date_end":"2025-07-02 00:45:00","timestamp_start":1751381100,"timestamp_end":1751417100,"date_start_ist":"2025-07-01 20:15:00","date_end_ist":"2025-07-02 06:15:00","venue":{"venue_id":"97","name":"Bready Cricket Club, Magheramason","location":"Bready","country":"Ireland","timezone":""},"umpires":"Roly Black (Ireland), Jonathan Kennedy (Ireland), Mark Hawthorne (Ireland, TV)","referee":"Graham McCrea (Ireland)","equation":"","live":"","result":"LL won by 9 wickets","result_type":2,"win_margin":"9 wickets","winning_team_id":113541,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-01 02:31:56","verify_time":"2025-07-01 22:57:32","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"few clouds","temp":20.12,"humidity":77,"visibility":10000,"wind_speed":"7.65","clouds":21},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Northern Knights elected to bat","winner":113540,"decision":1}},"etag":"6428eb31aeed2578fa308ad2810ca388","modified":"2025-07-15 23:34:47","datetime":"2025-07-15 23:34:47","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90844,"title":"Northern Knights vs Leinster Lightning","short_title":"NK vs LL","subtitle":"Match 14","match_number":"14","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Leinster Lightning won by 9 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129638,"title":"Ireland Inter-Provincial T20 Trophy","abbr":"Ireland 20 Over Trophy","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-06-17","dateend":"2025-09-13","country":"ie","total_matches":"24","total_rounds":"1","total_teams":"4"},"teama":{"team_id":113540,"name":"Northern Knights","short_name":"NK","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-KNIG@2x55.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-KNIG@2x55.png","scores_full":"123\/10 (18.4 ov)","scores":"123\/10","overs":"18.4"},"teamb":{"team_id":113541,"name":"Leinster Lightning","short_name":"LL","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-LLG@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-LLG@2x.png","scores_full":"127\/1 (12.3 ov)","scores":"127\/1","overs":"12.3"},"date_start":"2025-07-01 14:45:00","date_end":"2025-07-02 00:45:00","timestamp_start":1751381100,"timestamp_end":1751417100,"date_start_ist":"2025-07-01 20:15:00","date_end_ist":"2025-07-02 06:15:00","venue":{"venue_id":"97","name":"Bready Cricket Club, Magheramason","location":"Bready","country":"Ireland","timezone":""},"umpires":"Roly Black (Ireland), Jonathan Kennedy (Ireland), Mark Hawthorne (Ireland, TV)","referee":"Graham McCrea (Ireland)","equation":"","live":"","result":"LL won by 9 wickets","result_type":2,"win_margin":"9 wickets","winning_team_id":113541,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-01 02:31:56","verify_time":"2025-07-01 22:57:32","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"few clouds","temp":20.12,"humidity":77,"visibility":10000,"wind_speed":"7.65","clouds":21},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Northern Knights elected to bat","winner":113540,"decision":1}},"etag":"6428eb31aeed2578fa308ad2810ca388","modified":"2025-07-15 23:34:47","datetime":"2025-07-15 23:34:47","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90844 AND DataTypeId = 3 END
Live Report & Scorecard of Northern Knights vs Leinster Lightning Match 14
CricDirect Cricket News, Results and Stats
 

Northern Knights vs Leinster Lightning, Match 14, Ireland Inter-Provincial T20 Trophy

Northern Knights
NK
123/10 (18.4 ov)
Leinster Lightning
LL
127/1 (12.3 ov)
Leinster Lightning won by 9 wickets
BATTERS R B 4S 6S SR
Tim Tector * 81 43 8 6 188.37
Harry Tector 34 20 3 2 170.00
BOWLERS O M R W ECON
Cian Robertson * 3.3 0 18 0 5.14
Matthew Humphreys 4 0 37 1 9.25
Current Partnership: 74 run (7.3 ov) | Last Wicket: Chris Defreitas 7 (12) | Fall of Wicket: 53/1 (4.6 ov)
CRR: 10.16
Recent: 446611111644

Northern Knights vs Leinster Lightning, Live Cricket Commentary

4
12.3
Cian Robertson to Tim Tector, Four,
0
12.2
Cian Robertson to Tim Tector, no run,
0
12.1
Cian Robertson to Tim Tector, no run,
End of over 12 (17 runs)
Harry Tector 34 (20)
Tim Tector 77 (40)
Leinster Lightning 123/1
Matthew Humphreys 4-0-37-1
Cian Robertson 3-0-14-0
4
11.6
Matthew Humphreys to Harry Tector, Four,
0
11.5
Matthew Humphreys to Harry Tector, no run,
6
11.4
Matthew Humphreys to Harry Tector, Six,
0
11.3
Matthew Humphreys to Harry Tector, no run,
6
11.2
Matthew Humphreys to Harry Tector, Six,
1
11.1
Matthew Humphreys to Tim Tector, 1 run,
End of over 11 (4 runs)
Tim Tector 76 (39)
Harry Tector 18 (15)
Leinster Lightning 106/1
Cian Robertson 3-0-14-0
Ruhan Pretorius 2-0-28-0
1
10.6
Cian Robertson to Tim Tector, 1 run,
1
10.5
Cian Robertson to Harry Tector, 1 run,
1
10.4
Cian Robertson to Tim Tector, 1 run,
0
10.3
Cian Robertson to Tim Tector, no run,
1
10.2
Cian Robertson to Harry Tector, 1 run,
0
10.1
Cian Robertson to Harry Tector, no run,
End of over 10 (17 runs)
Tim Tector 74 (36)
Harry Tector 16 (12)
Leinster Lightning 102/1
Ruhan Pretorius 2-0-28-0
Cian Robertson 2-0-10-0
6
9.6
Ruhan Pretorius to Tim Tector, Six,
4
9.5
Ruhan Pretorius to Tim Tector, Four,
4
9.4
Ruhan Pretorius to Tim Tector, Four,
1
9.3
Ruhan Pretorius to Harry Tector, 1 run,
1
9.2
Ruhan Pretorius to Tim Tector, 1 run,
1
9.1
Ruhan Pretorius to Harry Tector, 1 run,
End of over 9 (10 runs)
Harry Tector 14 (10)
Tim Tector 59 (32)
Leinster Lightning 85/1
Cian Robertson 2-0-10-0
Matthew Humphreys 3-0-20-1
1
8.6
Cian Robertson to Harry Tector, 1 run,
1
8.5
Cian Robertson to Tim Tector, 1 run,
0
8.4
Cian Robertson to Tim Tector, no run,
2lb
8.3
Cian Robertson to Tim Tector, 2 leg bye,
1wd
8.3
Cian Robertson to Tim Tector, 1 wide,
4
8.2
Cian Robertson to Tim Tector, Four,
Match Details
Date
Tuesday, July 1, 2025 15:45
Venue
Bready Cricket Club, Magheramason, Bready
Toss
Northern Knights elected to bat
Umpires
    Roly Black (Ireland)
    Jonathan Kennedy (Ireland)
    Mark Hawthorne (Ireland
    TV)
Match Referee
    Graham McCrea (Ireland)
× Close