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:81c216bd-caea-493d-9e21-8bf2dcf06f0d Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90942 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90942,1,'{"status":"ok","response":{"mid":90942,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Whiptail Smashers won by 9 wickets","day_remaining_over":"","team_batting":"Whiptail Smashers","team_bowling":"Calabash Giants","live_inning_number":2,"live_score":{"runs":110,"overs":8.1,"wickets":1,"target":105,"runrate":13.47,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Tyrel Chicot","batsman_id":99811,"runs":11,"balls_faced":3,"fours":1,"sixes":1,"strike_rate":"366.67"},{"name":"Kimani Melius","batsman_id":93587,"runs":74,"balls_faced":30,"fours":8,"sixes":5,"strike_rate":"246.67"}],"bowlers":[{"name":"Alexus Charles","bowler_id":150063,"overs":1.1,"runs_conceded":16,"wickets":1,"maidens":0,"econ":"13.71"},{"name":"Bjorn Fanus","bowler_id":138227,"overs":1,"runs_conceded":10,"wickets":0,"maidens":0,"econ":"10.00"}],"commentaries":[{"event":"overend","over":4,"runs":23,"score":"63\/0","bats":[{"runs":42,"balls_faced":17,"fours":3,"sixes":4,"batsman_id":93587},{"runs":19,"balls_faced":7,"fours":1,"sixes":2,"batsman_id":99806}],"bowls":[{"runs_conceded":23,"maidens":0,"wickets":0,"bowler_id":127132,"overs":1},{"runs_conceded":13,"maidens":0,"wickets":0,"bowler_id":99764,"overs":1}],"commentary":"End of over 4 (23 runs), Whiptail Smashers 63\/0"},{"event_id":"12238193","event":"ball","batsman_id":"99806","bowler_id":"52175","over":"4","ball":"1","score":0,"commentary":"Dornan Edward to Jard Goodman, no run,","noball_dismissal":false,"text":"","timestamp":1751055186,"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":"12238195","event":"ball","batsman_id":"99806","bowler_id":"52175","over":"4","ball":"2","score":0,"commentary":"Dornan Edward to Jard Goodman, no run,","noball_dismissal":false,"text":"","timestamp":1751055200,"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":"12238196","event":"ball","batsman_id":"99806","bowler_id":"52175","over":"4","ball":"3","score":0,"commentary":"Dornan Edward to Jard Goodman, no run,","noball_dismissal":false,"text":"","timestamp":1751055204,"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":"12238198","event":"ball","batsman_id":"99806","bowler_id":"52175","over":"4","ball":"4","score":0,"commentary":"Dornan Edward to Jard Goodman, no run,","noball_dismissal":false,"text":"","timestamp":1751055248,"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":"12238202","event":"ball","batsman_id":"99806","bowler_id":"52175","over":"4","ball":"5","score":0,"commentary":"Dornan Edward to Jard Goodman, no run,","noball_dismissal":false,"text":"","timestamp":1751055261,"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":"12238204","event":"ball","batsman_id":"99806","bowler_id":"52175","over":"4","ball":"6","score":0,"commentary":"Dornan Edward to Jard Goodman, no run,","noball_dismissal":false,"text":"","timestamp":1751055277,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":5,"runs":0,"score":"63\/0","bats":[{"runs":19,"balls_faced":13,"fours":1,"sixes":2,"batsman_id":99806},{"runs":42,"balls_faced":17,"fours":3,"sixes":4,"batsman_id":93587}],"bowls":[{"runs_conceded":0,"maidens":1,"wickets":0,"bowler_id":52175,"overs":1},{"runs_conceded":23,"maidens":0,"wickets":0,"bowler_id":127132,"overs":1}],"commentary":"End of over 5 (0 runs), Whiptail Smashers 63\/0"},{"event_id":"12238206","event":"ball","batsman_id":"93587","bowler_id":"150063","over":"5","ball":"1","score":4,"commentary":"Alexus Charles to Kimani Melius, Four,","noball_dismissal":false,"text":"","timestamp":1751055370,"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":"12238209","event":"ball","batsman_id":"93587","bowler_id":"150063","over":"5","ball":"2","score":1,"commentary":"Alexus Charles to Kimani Melius, 1 run,","noball_dismissal":false,"text":"","timestamp":1751055433,"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":"12238217","event":"ball","batsman_id":"99806","bowler_id":"150063","over":"5","ball":"3","score":1,"commentary":"Alexus Charles to Jard Goodman, 1 run,","noball_dismissal":false,"text":"","timestamp":1751055491,"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":"12238219","event":"ball","batsman_id":"93587","bowler_id":"150063","over":"5","ball":"4","score":1,"commentary":"Alexus Charles to Kimani Melius, 1 run,","noball_dismissal":false,"text":"","timestamp":1751055495,"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":"12238221","event":"ball","batsman_id":"99806","bowler_id":"150063","over":"5","ball":"5","score":2,"commentary":"Alexus Charles to Jard Goodman, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751055528,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12238225","event":"ball","batsman_id":"99806","bowler_id":"150063","over":"5","ball":"6","score":"1wd","commentary":"Alexus Charles to Jard Goodman, 1 wide,","noball_dismissal":false,"text":"","timestamp":1751055564,"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":"12238226","event":"wicket","batsman_id":"99806","bowler_id":"150063","over":"5","ball":"6","score":"w","commentary":"Alexus Charles to Jard Goodman, no run, b AX Charles,","noball_dismissal":false,"text":"","timestamp":1751055595,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"99806","how_out":"b AX Charles","batsman_runs":"22","batsman_balls":"16"},{"event":"overend","over":6,"runs":10,"score":"73\/1","bats":[{"runs":22,"balls_faced":16,"fours":1,"sixes":2,"batsman_id":99806},{"runs":48,"balls_faced":20,"fours":4,"sixes":4,"batsman_id":93587}],"bowls":[{"runs_conceded":10,"maidens":0,"wickets":1,"bowler_id":150063,"overs":1},{"runs_conceded":0,"maidens":1,"wickets":0,"bowler_id":52175,"overs":1}],"commentary":"End of over 6 (10 runs), Whiptail Smashers 73\/1"},{"event_id":"12238232","event":"ball","batsman_id":"93587","bowler_id":"52175","over":"6","ball":"1","score":4,"commentary":"Dornan Edward to Kimani Melius, Four,","noball_dismissal":false,"text":"","timestamp":1751055735,"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":"12238234","event":"ball","batsman_id":"93587","bowler_id":"52175","over":"6","ball":"2","score":2,"commentary":"Dornan Edward to Kimani Melius, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751055755,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12238235","event":"ball","batsman_id":"93587","bowler_id":"52175","over":"6","ball":"3","score":6,"commentary":"Dornan Edward to Kimani Melius, Six,","noball_dismissal":false,"text":"","timestamp":1751055788,"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":"12238238","event":"ball","batsman_id":"93587","bowler_id":"52175","over":"6","ball":"4","score":4,"commentary":"Dornan Edward to Kimani Melius, Four,","noball_dismissal":false,"text":"","timestamp":1751055909,"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":"12238239","event":"ball","batsman_id":"93587","bowler_id":"52175","over":"6","ball":"5","score":1,"commentary":"Dornan Edward to Kimani Melius, 1 run,","noball_dismissal":false,"text":"","timestamp":1751055913,"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":"12238240","event":"ball","batsman_id":"99811","bowler_id":"52175","over":"6","ball":"6","score":4,"commentary":"Dornan Edward to Tyrel Chicot, Four,","noball_dismissal":false,"text":"","timestamp":1751055947,"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":7,"runs":21,"score":"94\/1","bats":[{"runs":4,"balls_faced":1,"fours":1,"sixes":0,"batsman_id":99811},{"runs":65,"balls_faced":25,"fours":6,"sixes":5,"batsman_id":93587}],"bowls":[{"runs_conceded":21,"maidens":1,"wickets":0,"bowler_id":52175,"overs":2},{"runs_conceded":10,"maidens":0,"wickets":1,"bowler_id":150063,"overs":1}],"commentary":"End of over 7 (21 runs), Whiptail Smashers 94\/1"},{"event_id":"12238242","event":"ball","batsman_id":"93587","bowler_id":"138227","over":"7","ball":"1","score":0,"commentary":"Bjorn Fanus to Kimani Melius, no run,","noball_dismissal":false,"text":"","timestamp":1751056059,"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":"12238243","event":"ball","batsman_id":"93587","bowler_id":"138227","over":"7","ball":"2","score":4,"commentary":"Bjorn Fanus to Kimani Melius, Four,","noball_dismissal":false,"text":"","timestamp":1751056099,"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":"12238244","event":"ball","batsman_id":"93587","bowler_id":"138227","over":"7","ball":"3","score":4,"commentary":"Bjorn Fanus to Kimani Melius, Four,","noball_dismissal":false,"text":"","timestamp":1751056128,"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":"12238245","event":"ball","batsman_id":"93587","bowler_id":"138227","over":"7","ball":"4","score":1,"commentary":"Bjorn Fanus to Kimani Melius, 1 run,","noball_dismissal":false,"text":"","timestamp":1751056183,"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":"12238247","event":"ball","batsman_id":"99811","bowler_id":"138227","over":"7","ball":"5","score":1,"commentary":"Bjorn Fanus to Tyrel Chicot, 1 run,","noball_dismissal":false,"text":"","timestamp":1751056223,"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":"12238250","event":"ball","batsman_id":"93587","bowler_id":"138227","over":"7","ball":"6","score":0,"commentary":"Bjorn Fanus to Kimani Melius, no run,","noball_dismissal":false,"text":"","timestamp":1751056266,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":8,"runs":10,"score":"104\/1","bats":[{"runs":74,"balls_faced":30,"fours":8,"sixes":5,"batsman_id":93587},{"runs":5,"balls_faced":2,"fours":1,"sixes":0,"batsman_id":99811}],"bowls":[{"runs_conceded":10,"maidens":0,"wickets":0,"bowler_id":138227,"overs":1},{"runs_conceded":21,"maidens":1,"wickets":0,"bowler_id":52175,"overs":2}],"commentary":"End of over 8 (10 runs), Whiptail Smashers 104\/1"},{"event_id":"12238253","event":"ball","batsman_id":"99811","bowler_id":"150063","over":"8","ball":"1","score":6,"commentary":"Alexus Charles to Tyrel Chicot, Six,","noball_dismissal":false,"text":"","timestamp":1751056337,"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}],"day":"0","session":"0","live_inning":{"iid":198842,"number":2,"name":"Whiptail Smashers Inning","short_name":"WTS Inning","status":2,"issuperover":"false","result":3,"batting_team_id":129004,"fielding_team_id":129005,"scores":"110\/1","scores_full":"110\/1 (8.1 ov)","fielder":[],"powerplay":{"p1":{"startover":"0.1","endover":"3"}},"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":"Jard Goodman","batsman_id":"99806","runs":"22","balls":"16","how_out":"b AX Charles","score_at_dismissal":73,"overs_at_dismissal":"5.6","bowler_id":"150063","dismissal":"bowled","number":1},"extra_runs":{"byes":0,"legbyes":0,"wides":3,"noballs":0,"penalty":"0","total":3},"equations":{"runs":110,"wickets":1,"overs":"8.1","bowlers_used":7,"runrate":"13.47"},"current_partnership":{"runs":37,"balls":13,"overs":2.1,"batsmen":[{"name":"Kimani Melius","batsman_id":93587,"runs":26,"balls":10},{"name":"Tyrel Chicot","batsman_id":99811,"runs":11,"balls":3}]},"did_not_bat":[{"player_id":"127134","name":"Amari Venner"},{"player_id":"116169","name":"Rene Montoute"},{"player_id":"116171","name":"Lee John"},{"player_id":"138275","name":"Ashton Alexander"},{"player_id":"107775","name":"Shawnil Edward"},{"player_id":"107705","name":"Ryan Goodman"},{"player_id":"107804","name":"Jeandell Cyril"},{"player_id":"138229","name":"Trent Belfon"}],"max_over":"10","target":"105","recent_scores":"6,0,1,1,4,4,0,4,1,4,6,2,4,w,1,2,1,1","last_five_overs":"64\/1 12.00","last_ten_overs":"110\/1 12.69"},"teams":[{"tid":129004,"title":"Whiptail Smashers","abbr":"WTS","alt_name":"Whiptail Smashers","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Whiptail-Smashers.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Whiptail-Smashers.png","country":"wi","sex":"male","team_owner":"","head_coach":"","scores_full":"110\/1 (8.1 ov)","scores":"110\/1","overs":"8.1"},{"tid":129005,"title":"Calabash Giants","abbr":"CBG","alt_name":"Calabash Giants","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Calabash-Giants.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Calabash-Giants.png","country":"wi","sex":"male","team_owner":"","head_coach":"","scores_full":"104\/7 (10 ov)","scores":"104\/7","overs":"10"}],"players":[{"pid":52175,"title":"Dornan Edward","short_name":"DC Edward","first_name":"Dornan Edward","last_name":"","middle_name":"","birthdate":"1996-10-28","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":70012,"title":"Mervin Wells","short_name":"M Wells","first_name":"Mervin Wells","last_name":"","middle_name":"","birthdate":"1987-01-16","birthplace":"","country":"wi","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":93587,"title":"Kimani Melius","short_name":"KS Melius","first_name":"Kimani Melius","last_name":"","middle_name":"","birthdate":"2001-01-17","birthplace":"St. Lucia","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":23789,"recent_appearance":1515805200,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":"(C)"},{"pid":99743,"title":"Wayne Prospere","short_name":"W Prospere","first_name":"Wayne Prospere","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","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":"West Indies","role":"bowl","role_str":""},{"pid":99764,"title":"Sadrack Descartes","short_name":"S Descartes","first_name":"Sadrack Descartes","last_name":"","middle_name":"","birthdate":"1997-10-19","birthplace":"Cheshire","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left 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":"West Indies","role":"all","role_str":"(C)"},{"pid":99794,"title":"Tyler Sookwa","short_name":"T Sookwa","first_name":"Tyler Sookwa","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","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":"West Indies","role":"squad","role_str":""},{"pid":99806,"title":"Jard Goodman","short_name":"J Goodman","first_name":"Jard Goodman","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":99811,"title":"Tyrel Chicot","short_name":"T Chicot","first_name":"Tyrel Chicot","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":99815,"title":"Simeon Gerson","short_name":"S Gerson","first_name":"Simeon Gerson","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","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":"West Indies","role":"squad","role_str":""},{"pid":99821,"title":"David Naitram","short_name":"D Naitram","first_name":"David Naitram","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","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":"West Indies","role":"all","role_str":""},{"pid":107705,"title":"Ryan Goodman","short_name":"R Goodman","first_name":"Ryan Goodman","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":107712,"title":"Kurt Edward","short_name":"K Edward","first_name":"Kurt Edward","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":107775,"title":"Shawnil Edward","short_name":"S Edward","first_name":"Shawnil Edward","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm 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":"West Indies","role":"all","role_str":""},{"pid":107804,"title":"Jeandell Cyril","short_name":"J Cyril","first_name":"Jeandell Cyril","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","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":"West Indies","role":"bowl","role_str":""},{"pid":115903,"title":"Josan James","short_name":"J James","first_name":"Josan James","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","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":"West Indies","role":"squad","role_str":""},{"pid":116169,"title":"Rene Montoute","short_name":"R Montoute","first_name":"Rene Montoute","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":116171,"title":"Lee John","short_name":"L John","first_name":"Lee John","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":116173,"title":"Ted Jonas","short_name":"T Jonas","first_name":"Ted Jonas","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":116188,"title":"Marklin Sylvester","short_name":"M Sylvester","first_name":"Marklin Sylvester","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":126998,"title":"Cody Lesmond","short_name":"Cody Lesmond","first_name":"Cody Lesmond","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":127001,"title":"Magaran Shoulette","short_name":"M Shoulette","first_name":"Magaran Shoulette","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":127132,"title":"Caleb Thomas","short_name":"C Thomas","first_name":"Caleb Thomas","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","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":"West Indies","role":"all","role_str":""},{"pid":127133,"title":"Stephen Abraham","short_name":"S Abraham","first_name":"Stephen Abraham","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(WK)"},{"pid":127134,"title":"Amari Venner","short_name":"A Venner","first_name":"Amari Venner","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","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":"West Indies","role":"all","role_str":""},{"pid":138227,"title":"Bjorn Fanus","short_name":"B Fanus","first_name":"Bjorn Fanus","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":138229,"title":"Trent Belfon","short_name":"T Belfon","first_name":"Trent Belfon","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","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":"West Indies","role":"bowl","role_str":""},{"pid":138274,"title":"Leon Alexander","short_name":"L Alexander","first_name":"Leon Alexander","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","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":"West Indies","role":"squad","role_str":""},{"pid":138275,"title":"Ashton Alexander","short_name":"A Alexander","first_name":"Ashton Alexander","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","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":"West Indies","role":"all","role_str":"(WK)"},{"pid":150061,"title":"Kanil Nelson","short_name":"KN Nelson","first_name":"Kanil Nelson","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":150063,"title":"Alexus Charles","short_name":"AX Charles","first_name":"Alexus Charles","last_name":"","middle_name":"","birthdate":"2006-05-31","birthplace":"","country":"wi","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":"West Indies","role":"all","role_str":""},{"pid":150064,"title":"Denzie JnPaul","short_name":"DZ JnPaul","first_name":"Denzie JnPaul","last_name":"","middle_name":"","birthdate":"2007-11-18","birthplace":"","country":"wi","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":"West Indies","role":"squad","role_str":""}]},"etag":"86aa4ee0b29e580f38286b6f06d49e55","modified":"2025-07-30 01:15:52","datetime":"2025-07-30 01:15:52","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":90942,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Whiptail Smashers won by 9 wickets","day_remaining_over":"","team_batting":"Whiptail Smashers","team_bowling":"Calabash Giants","live_inning_number":2,"live_score":{"runs":110,"overs":8.1,"wickets":1,"target":105,"runrate":13.47,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Tyrel Chicot","batsman_id":99811,"runs":11,"balls_faced":3,"fours":1,"sixes":1,"strike_rate":"366.67"},{"name":"Kimani Melius","batsman_id":93587,"runs":74,"balls_faced":30,"fours":8,"sixes":5,"strike_rate":"246.67"}],"bowlers":[{"name":"Alexus Charles","bowler_id":150063,"overs":1.1,"runs_conceded":16,"wickets":1,"maidens":0,"econ":"13.71"},{"name":"Bjorn Fanus","bowler_id":138227,"overs":1,"runs_conceded":10,"wickets":0,"maidens":0,"econ":"10.00"}],"commentaries":[{"event":"overend","over":4,"runs":23,"score":"63\/0","bats":[{"runs":42,"balls_faced":17,"fours":3,"sixes":4,"batsman_id":93587},{"runs":19,"balls_faced":7,"fours":1,"sixes":2,"batsman_id":99806}],"bowls":[{"runs_conceded":23,"maidens":0,"wickets":0,"bowler_id":127132,"overs":1},{"runs_conceded":13,"maidens":0,"wickets":0,"bowler_id":99764,"overs":1}],"commentary":"End of over 4 (23 runs), Whiptail Smashers 63\/0"},{"event_id":"12238193","event":"ball","batsman_id":"99806","bowler_id":"52175","over":"4","ball":"1","score":0,"commentary":"Dornan Edward to Jard Goodman, no run,","noball_dismissal":false,"text":"","timestamp":1751055186,"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":"12238195","event":"ball","batsman_id":"99806","bowler_id":"52175","over":"4","ball":"2","score":0,"commentary":"Dornan Edward to Jard Goodman, no run,","noball_dismissal":false,"text":"","timestamp":1751055200,"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":"12238196","event":"ball","batsman_id":"99806","bowler_id":"52175","over":"4","ball":"3","score":0,"commentary":"Dornan Edward to Jard Goodman, no run,","noball_dismissal":false,"text":"","timestamp":1751055204,"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":"12238198","event":"ball","batsman_id":"99806","bowler_id":"52175","over":"4","ball":"4","score":0,"commentary":"Dornan Edward to Jard Goodman, no run,","noball_dismissal":false,"text":"","timestamp":1751055248,"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":"12238202","event":"ball","batsman_id":"99806","bowler_id":"52175","over":"4","ball":"5","score":0,"commentary":"Dornan Edward to Jard Goodman, no run,","noball_dismissal":false,"text":"","timestamp":1751055261,"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":"12238204","event":"ball","batsman_id":"99806","bowler_id":"52175","over":"4","ball":"6","score":0,"commentary":"Dornan Edward to Jard Goodman, no run,","noball_dismissal":false,"text":"","timestamp":1751055277,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":5,"runs":0,"score":"63\/0","bats":[{"runs":19,"balls_faced":13,"fours":1,"sixes":2,"batsman_id":99806},{"runs":42,"balls_faced":17,"fours":3,"sixes":4,"batsman_id":93587}],"bowls":[{"runs_conceded":0,"maidens":1,"wickets":0,"bowler_id":52175,"overs":1},{"runs_conceded":23,"maidens":0,"wickets":0,"bowler_id":127132,"overs":1}],"commentary":"End of over 5 (0 runs), Whiptail Smashers 63\/0"},{"event_id":"12238206","event":"ball","batsman_id":"93587","bowler_id":"150063","over":"5","ball":"1","score":4,"commentary":"Alexus Charles to Kimani Melius, Four,","noball_dismissal":false,"text":"","timestamp":1751055370,"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":"12238209","event":"ball","batsman_id":"93587","bowler_id":"150063","over":"5","ball":"2","score":1,"commentary":"Alexus Charles to Kimani Melius, 1 run,","noball_dismissal":false,"text":"","timestamp":1751055433,"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":"12238217","event":"ball","batsman_id":"99806","bowler_id":"150063","over":"5","ball":"3","score":1,"commentary":"Alexus Charles to Jard Goodman, 1 run,","noball_dismissal":false,"text":"","timestamp":1751055491,"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":"12238219","event":"ball","batsman_id":"93587","bowler_id":"150063","over":"5","ball":"4","score":1,"commentary":"Alexus Charles to Kimani Melius, 1 run,","noball_dismissal":false,"text":"","timestamp":1751055495,"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":"12238221","event":"ball","batsman_id":"99806","bowler_id":"150063","over":"5","ball":"5","score":2,"commentary":"Alexus Charles to Jard Goodman, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751055528,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12238225","event":"ball","batsman_id":"99806","bowler_id":"150063","over":"5","ball":"6","score":"1wd","commentary":"Alexus Charles to Jard Goodman, 1 wide,","noball_dismissal":false,"text":"","timestamp":1751055564,"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":"12238226","event":"wicket","batsman_id":"99806","bowler_id":"150063","over":"5","ball":"6","score":"w","commentary":"Alexus Charles to Jard Goodman, no run, b AX Charles,","noball_dismissal":false,"text":"","timestamp":1751055595,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"99806","how_out":"b AX Charles","batsman_runs":"22","batsman_balls":"16"},{"event":"overend","over":6,"runs":10,"score":"73\/1","bats":[{"runs":22,"balls_faced":16,"fours":1,"sixes":2,"batsman_id":99806},{"runs":48,"balls_faced":20,"fours":4,"sixes":4,"batsman_id":93587}],"bowls":[{"runs_conceded":10,"maidens":0,"wickets":1,"bowler_id":150063,"overs":1},{"runs_conceded":0,"maidens":1,"wickets":0,"bowler_id":52175,"overs":1}],"commentary":"End of over 6 (10 runs), Whiptail Smashers 73\/1"},{"event_id":"12238232","event":"ball","batsman_id":"93587","bowler_id":"52175","over":"6","ball":"1","score":4,"commentary":"Dornan Edward to Kimani Melius, Four,","noball_dismissal":false,"text":"","timestamp":1751055735,"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":"12238234","event":"ball","batsman_id":"93587","bowler_id":"52175","over":"6","ball":"2","score":2,"commentary":"Dornan Edward to Kimani Melius, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751055755,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12238235","event":"ball","batsman_id":"93587","bowler_id":"52175","over":"6","ball":"3","score":6,"commentary":"Dornan Edward to Kimani Melius, Six,","noball_dismissal":false,"text":"","timestamp":1751055788,"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":"12238238","event":"ball","batsman_id":"93587","bowler_id":"52175","over":"6","ball":"4","score":4,"commentary":"Dornan Edward to Kimani Melius, Four,","noball_dismissal":false,"text":"","timestamp":1751055909,"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":"12238239","event":"ball","batsman_id":"93587","bowler_id":"52175","over":"6","ball":"5","score":1,"commentary":"Dornan Edward to Kimani Melius, 1 run,","noball_dismissal":false,"text":"","timestamp":1751055913,"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":"12238240","event":"ball","batsman_id":"99811","bowler_id":"52175","over":"6","ball":"6","score":4,"commentary":"Dornan Edward to Tyrel Chicot, Four,","noball_dismissal":false,"text":"","timestamp":1751055947,"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":7,"runs":21,"score":"94\/1","bats":[{"runs":4,"balls_faced":1,"fours":1,"sixes":0,"batsman_id":99811},{"runs":65,"balls_faced":25,"fours":6,"sixes":5,"batsman_id":93587}],"bowls":[{"runs_conceded":21,"maidens":1,"wickets":0,"bowler_id":52175,"overs":2},{"runs_conceded":10,"maidens":0,"wickets":1,"bowler_id":150063,"overs":1}],"commentary":"End of over 7 (21 runs), Whiptail Smashers 94\/1"},{"event_id":"12238242","event":"ball","batsman_id":"93587","bowler_id":"138227","over":"7","ball":"1","score":0,"commentary":"Bjorn Fanus to Kimani Melius, no run,","noball_dismissal":false,"text":"","timestamp":1751056059,"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":"12238243","event":"ball","batsman_id":"93587","bowler_id":"138227","over":"7","ball":"2","score":4,"commentary":"Bjorn Fanus to Kimani Melius, Four,","noball_dismissal":false,"text":"","timestamp":1751056099,"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":"12238244","event":"ball","batsman_id":"93587","bowler_id":"138227","over":"7","ball":"3","score":4,"commentary":"Bjorn Fanus to Kimani Melius, Four,","noball_dismissal":false,"text":"","timestamp":1751056128,"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":"12238245","event":"ball","batsman_id":"93587","bowler_id":"138227","over":"7","ball":"4","score":1,"commentary":"Bjorn Fanus to Kimani Melius, 1 run,","noball_dismissal":false,"text":"","timestamp":1751056183,"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":"12238247","event":"ball","batsman_id":"99811","bowler_id":"138227","over":"7","ball":"5","score":1,"commentary":"Bjorn Fanus to Tyrel Chicot, 1 run,","noball_dismissal":false,"text":"","timestamp":1751056223,"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":"12238250","event":"ball","batsman_id":"93587","bowler_id":"138227","over":"7","ball":"6","score":0,"commentary":"Bjorn Fanus to Kimani Melius, no run,","noball_dismissal":false,"text":"","timestamp":1751056266,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":8,"runs":10,"score":"104\/1","bats":[{"runs":74,"balls_faced":30,"fours":8,"sixes":5,"batsman_id":93587},{"runs":5,"balls_faced":2,"fours":1,"sixes":0,"batsman_id":99811}],"bowls":[{"runs_conceded":10,"maidens":0,"wickets":0,"bowler_id":138227,"overs":1},{"runs_conceded":21,"maidens":1,"wickets":0,"bowler_id":52175,"overs":2}],"commentary":"End of over 8 (10 runs), Whiptail Smashers 104\/1"},{"event_id":"12238253","event":"ball","batsman_id":"99811","bowler_id":"150063","over":"8","ball":"1","score":6,"commentary":"Alexus Charles to Tyrel Chicot, Six,","noball_dismissal":false,"text":"","timestamp":1751056337,"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}],"day":"0","session":"0","live_inning":{"iid":198842,"number":2,"name":"Whiptail Smashers Inning","short_name":"WTS Inning","status":2,"issuperover":"false","result":3,"batting_team_id":129004,"fielding_team_id":129005,"scores":"110\/1","scores_full":"110\/1 (8.1 ov)","fielder":[],"powerplay":{"p1":{"startover":"0.1","endover":"3"}},"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":"Jard Goodman","batsman_id":"99806","runs":"22","balls":"16","how_out":"b AX Charles","score_at_dismissal":73,"overs_at_dismissal":"5.6","bowler_id":"150063","dismissal":"bowled","number":1},"extra_runs":{"byes":0,"legbyes":0,"wides":3,"noballs":0,"penalty":"0","total":3},"equations":{"runs":110,"wickets":1,"overs":"8.1","bowlers_used":7,"runrate":"13.47"},"current_partnership":{"runs":37,"balls":13,"overs":2.1,"batsmen":[{"name":"Kimani Melius","batsman_id":93587,"runs":26,"balls":10},{"name":"Tyrel Chicot","batsman_id":99811,"runs":11,"balls":3}]},"did_not_bat":[{"player_id":"127134","name":"Amari Venner"},{"player_id":"116169","name":"Rene Montoute"},{"player_id":"116171","name":"Lee John"},{"player_id":"138275","name":"Ashton Alexander"},{"player_id":"107775","name":"Shawnil Edward"},{"player_id":"107705","name":"Ryan Goodman"},{"player_id":"107804","name":"Jeandell Cyril"},{"player_id":"138229","name":"Trent Belfon"}],"max_over":"10","target":"105","recent_scores":"6,0,1,1,4,4,0,4,1,4,6,2,4,w,1,2,1,1","last_five_overs":"64\/1 12.00","last_ten_overs":"110\/1 12.69"},"teams":[{"tid":129004,"title":"Whiptail Smashers","abbr":"WTS","alt_name":"Whiptail Smashers","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Whiptail-Smashers.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Whiptail-Smashers.png","country":"wi","sex":"male","team_owner":"","head_coach":"","scores_full":"110\/1 (8.1 ov)","scores":"110\/1","overs":"8.1"},{"tid":129005,"title":"Calabash Giants","abbr":"CBG","alt_name":"Calabash Giants","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Calabash-Giants.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Calabash-Giants.png","country":"wi","sex":"male","team_owner":"","head_coach":"","scores_full":"104\/7 (10 ov)","scores":"104\/7","overs":"10"}],"players":[{"pid":52175,"title":"Dornan Edward","short_name":"DC Edward","first_name":"Dornan Edward","last_name":"","middle_name":"","birthdate":"1996-10-28","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":70012,"title":"Mervin Wells","short_name":"M Wells","first_name":"Mervin Wells","last_name":"","middle_name":"","birthdate":"1987-01-16","birthplace":"","country":"wi","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":93587,"title":"Kimani Melius","short_name":"KS Melius","first_name":"Kimani Melius","last_name":"","middle_name":"","birthdate":"2001-01-17","birthplace":"St. Lucia","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":23789,"recent_appearance":1515805200,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":"(C)"},{"pid":99743,"title":"Wayne Prospere","short_name":"W Prospere","first_name":"Wayne Prospere","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","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":"West Indies","role":"bowl","role_str":""},{"pid":99764,"title":"Sadrack Descartes","short_name":"S Descartes","first_name":"Sadrack Descartes","last_name":"","middle_name":"","birthdate":"1997-10-19","birthplace":"Cheshire","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left 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":"West Indies","role":"all","role_str":"(C)"},{"pid":99794,"title":"Tyler Sookwa","short_name":"T Sookwa","first_name":"Tyler Sookwa","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","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":"West Indies","role":"squad","role_str":""},{"pid":99806,"title":"Jard Goodman","short_name":"J Goodman","first_name":"Jard Goodman","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":99811,"title":"Tyrel Chicot","short_name":"T Chicot","first_name":"Tyrel Chicot","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":99815,"title":"Simeon Gerson","short_name":"S Gerson","first_name":"Simeon Gerson","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","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":"West Indies","role":"squad","role_str":""},{"pid":99821,"title":"David Naitram","short_name":"D Naitram","first_name":"David Naitram","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","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":"West Indies","role":"all","role_str":""},{"pid":107705,"title":"Ryan Goodman","short_name":"R Goodman","first_name":"Ryan Goodman","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":107712,"title":"Kurt Edward","short_name":"K Edward","first_name":"Kurt Edward","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":107775,"title":"Shawnil Edward","short_name":"S Edward","first_name":"Shawnil Edward","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm 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":"West Indies","role":"all","role_str":""},{"pid":107804,"title":"Jeandell Cyril","short_name":"J Cyril","first_name":"Jeandell Cyril","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","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":"West Indies","role":"bowl","role_str":""},{"pid":115903,"title":"Josan James","short_name":"J James","first_name":"Josan James","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","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":"West Indies","role":"squad","role_str":""},{"pid":116169,"title":"Rene Montoute","short_name":"R Montoute","first_name":"Rene Montoute","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":116171,"title":"Lee John","short_name":"L John","first_name":"Lee John","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":116173,"title":"Ted Jonas","short_name":"T Jonas","first_name":"Ted Jonas","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":116188,"title":"Marklin Sylvester","short_name":"M Sylvester","first_name":"Marklin Sylvester","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":126998,"title":"Cody Lesmond","short_name":"Cody Lesmond","first_name":"Cody Lesmond","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":127001,"title":"Magaran Shoulette","short_name":"M Shoulette","first_name":"Magaran Shoulette","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":127132,"title":"Caleb Thomas","short_name":"C Thomas","first_name":"Caleb Thomas","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","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":"West Indies","role":"all","role_str":""},{"pid":127133,"title":"Stephen Abraham","short_name":"S Abraham","first_name":"Stephen Abraham","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(WK)"},{"pid":127134,"title":"Amari Venner","short_name":"A Venner","first_name":"Amari Venner","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","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":"West Indies","role":"all","role_str":""},{"pid":138227,"title":"Bjorn Fanus","short_name":"B Fanus","first_name":"Bjorn Fanus","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":138229,"title":"Trent Belfon","short_name":"T Belfon","first_name":"Trent Belfon","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","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":"West Indies","role":"bowl","role_str":""},{"pid":138274,"title":"Leon Alexander","short_name":"L Alexander","first_name":"Leon Alexander","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","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":"West Indies","role":"squad","role_str":""},{"pid":138275,"title":"Ashton Alexander","short_name":"A Alexander","first_name":"Ashton Alexander","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","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":"West Indies","role":"all","role_str":"(WK)"},{"pid":150061,"title":"Kanil Nelson","short_name":"KN Nelson","first_name":"Kanil Nelson","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":150063,"title":"Alexus Charles","short_name":"AX Charles","first_name":"Alexus Charles","last_name":"","middle_name":"","birthdate":"2006-05-31","birthplace":"","country":"wi","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":"West Indies","role":"all","role_str":""},{"pid":150064,"title":"Denzie JnPaul","short_name":"DZ JnPaul","first_name":"Denzie JnPaul","last_name":"","middle_name":"","birthdate":"2007-11-18","birthplace":"","country":"wi","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":"West Indies","role":"squad","role_str":""}]},"etag":"86aa4ee0b29e580f38286b6f06d49e55","modified":"2025-07-30 01:15:52","datetime":"2025-07-30 01:15:52","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90942 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:81c216bd-caea-493d-9e21-8bf2dcf06f0d Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90942 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90942,3,'{"status":"ok","response":{"match_id":90942,"title":"Calabash Giants vs Whiptail Smashers","short_title":"CBG vs WTS","subtitle":"Match 8","match_number":"8","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Whiptail Smashers won by 9 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129646,"title":"St. Lucia T10 Blast","abbr":"Lucia T10","type":"tournament","category":"domestic","match_format":"t10","season":"2025","status":"live","datestart":"2025-06-24","dateend":"2025-07-08","country":"na","total_matches":"30","total_rounds":"1","total_teams":"6"},"teama":{"team_id":129005,"name":"Calabash Giants","short_name":"CBG","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Calabash-Giants.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Calabash-Giants.png","scores_full":"104\/7 (10 ov)","scores":"104\/7","overs":"10"},"teamb":{"team_id":129004,"name":"Whiptail Smashers","short_name":"WTS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Whiptail-Smashers.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Whiptail-Smashers.png","scores_full":"110\/1 (8.1 ov)","scores":"110\/1","overs":"8.1"},"date_start":"2025-06-27 18:30:00","date_end":"2025-06-28 04:30:00","timestamp_start":1751049000,"timestamp_end":1751085000,"date_start_ist":"2025-06-28 00:00:00","date_end_ist":"2025-06-28 10:00:00","venue":{"venue_id":"85","name":"Daren Sammy National Cricket Stadium, St Lucia","location":"Gros Islet","country":"West Indies","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"WTS won by 9 wickets","result_type":2,"win_margin":"9 wickets","winning_team_id":129004,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-26 00:18:19","verify_time":"2025-06-28 02:21:36","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"scattered clouds","temp":27.55,"humidity":77,"visibility":10000,"wind_speed":"15.57","clouds":31},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Calabash Giants elected to bat","winner":129005,"decision":1}},"etag":"de271c290c9c505381504eab642fc215","modified":"2025-07-30 01:15:53","datetime":"2025-07-30 01:15:53","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90942,"title":"Calabash Giants vs Whiptail Smashers","short_title":"CBG vs WTS","subtitle":"Match 8","match_number":"8","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Whiptail Smashers won by 9 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129646,"title":"St. Lucia T10 Blast","abbr":"Lucia T10","type":"tournament","category":"domestic","match_format":"t10","season":"2025","status":"live","datestart":"2025-06-24","dateend":"2025-07-08","country":"na","total_matches":"30","total_rounds":"1","total_teams":"6"},"teama":{"team_id":129005,"name":"Calabash Giants","short_name":"CBG","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Calabash-Giants.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Calabash-Giants.png","scores_full":"104\/7 (10 ov)","scores":"104\/7","overs":"10"},"teamb":{"team_id":129004,"name":"Whiptail Smashers","short_name":"WTS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Whiptail-Smashers.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Whiptail-Smashers.png","scores_full":"110\/1 (8.1 ov)","scores":"110\/1","overs":"8.1"},"date_start":"2025-06-27 18:30:00","date_end":"2025-06-28 04:30:00","timestamp_start":1751049000,"timestamp_end":1751085000,"date_start_ist":"2025-06-28 00:00:00","date_end_ist":"2025-06-28 10:00:00","venue":{"venue_id":"85","name":"Daren Sammy National Cricket Stadium, St Lucia","location":"Gros Islet","country":"West Indies","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"WTS won by 9 wickets","result_type":2,"win_margin":"9 wickets","winning_team_id":129004,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-26 00:18:19","verify_time":"2025-06-28 02:21:36","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"scattered clouds","temp":27.55,"humidity":77,"visibility":10000,"wind_speed":"15.57","clouds":31},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Calabash Giants elected to bat","winner":129005,"decision":1}},"etag":"de271c290c9c505381504eab642fc215","modified":"2025-07-30 01:15:53","datetime":"2025-07-30 01:15:53","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90942 AND DataTypeId = 3 END
Live Report & Scorecard of Calabash Giants vs Whiptail Smashers Match 8