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:fd5231ea-441d-4079-8e75-fa92108ddbc4
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90971 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90971,1,'{"status":"ok","response":{"mid":90971,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Whiptail Smashers won by 8 runs","day_remaining_over":"","team_batting":"Calabash Giants","team_bowling":"Whiptail Smashers","live_inning_number":2,"live_score":{"runs":114,"overs":10,"wickets":6,"target":123,"runrate":11.4,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Caleb Thomas","batsman_id":127132,"runs":12,"balls_faced":4,"fours":0,"sixes":1,"strike_rate":"300.00"},{"name":"Cody Lesmond","batsman_id":126998,"runs":0,"balls_faced":1,"fours":0,"sixes":0,"strike_rate":"0.00"}],"bowlers":[{"name":"Tyrel Chicot","bowler_id":99811,"overs":2,"runs_conceded":12,"wickets":2,"maidens":0,"econ":"6.00"},{"name":"Lee John","bowler_id":116171,"overs":2,"runs_conceded":19,"wickets":0,"maidens":0,"econ":"9.50"}],"commentaries":[{"event_id":"12290243","event":"ball","batsman_id":"99764","bowler_id":"116171","over":"5","ball":"6","score":1,"commentary":"Lee John to Sadrack Descartes, 1 run,","noball_dismissal":false,"text":"","timestamp":1751745246,"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":6,"runs":6,"score":"57\/1","bats":[{"runs":2,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":99764},{"runs":42,"balls_faced":23,"fours":5,"sixes":2,"batsman_id":70012}],"bowls":[{"runs_conceded":6,"maidens":0,"wickets":0,"bowler_id":116171,"overs":1},{"runs_conceded":10,"maidens":0,"wickets":1,"bowler_id":107705,"overs":1}],"commentary":"End of over 6 (6 runs), Calabash Giants 57\/1"},{"event_id":"12290248","event":"ball","batsman_id":"99764","bowler_id":"107705","over":"6","ball":"1","score":6,"commentary":"Ryan Goodman to Sadrack Descartes, Six,","noball_dismissal":false,"text":"","timestamp":1751745294,"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":"12290252","event":"ball","batsman_id":"99764","bowler_id":"107705","over":"6","ball":"2","score":6,"commentary":"Ryan Goodman to Sadrack Descartes, Six,","noball_dismissal":false,"text":"","timestamp":1751745319,"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":"12290254","event":"ball","batsman_id":"99764","bowler_id":"107705","over":"6","ball":"3","score":0,"commentary":"Ryan Goodman to Sadrack Descartes, no run,","noball_dismissal":false,"text":"","timestamp":1751745342,"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":"12290257","event":"ball","batsman_id":"99764","bowler_id":"107705","over":"6","ball":"4","score":6,"commentary":"Ryan Goodman to Sadrack Descartes, Six,","noball_dismissal":false,"text":"","timestamp":1751745371,"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":"12290261","event":"ball","batsman_id":"99764","bowler_id":"107705","over":"6","ball":"5","score":6,"commentary":"Ryan Goodman to Sadrack Descartes, Six,","noball_dismissal":false,"text":"","timestamp":1751745401,"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":"12290263","event":"ball","batsman_id":"99764","bowler_id":"107705","over":"6","ball":"6","score":"1nb","commentary":"Ryan Goodman to Sadrack Descartes, 1 no ball,","noball_dismissal":false,"text":"","timestamp":1751745461,"run":1,"noball_run":"1","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":true,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12290267","event":"ball","batsman_id":"99764","bowler_id":"107705","over":"6","ball":"6","score":2,"commentary":"Ryan Goodman to Sadrack Descartes, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751745465,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":7,"runs":27,"score":"84\/1","bats":[{"runs":28,"balls_faced":10,"fours":0,"sixes":4,"batsman_id":99764},{"runs":42,"balls_faced":23,"fours":5,"sixes":2,"batsman_id":70012}],"bowls":[{"runs_conceded":37,"maidens":0,"wickets":1,"bowler_id":107705,"overs":2},{"runs_conceded":6,"maidens":0,"wickets":0,"bowler_id":116171,"overs":1}],"commentary":"End of over 7 (27 runs), Calabash Giants 84\/1"},{"event_id":"12290274","event":"ball","batsman_id":"70012","bowler_id":"107804","over":"7","ball":"1","score":0,"commentary":"Jeandell Cyril to Mervin Wells, no run,","noball_dismissal":false,"text":"","timestamp":1751745539,"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":"12290278","event":"wicket","batsman_id":"70012","bowler_id":"107804","over":"7","ball":"2","score":"w","commentary":"Jeandell Cyril to Mervin Wells, no run, c L John b J Cyril,","noball_dismissal":false,"text":"","timestamp":1751745574,"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":"70012","how_out":"c L John b J Cyril","batsman_runs":"42","batsman_balls":"25"},{"event_id":"12290284","event":"ball","batsman_id":"127133","bowler_id":"107804","over":"7","ball":"3","score":1,"commentary":"Jeandell Cyril to Stephen Abraham, 1 run,","noball_dismissal":false,"text":"","timestamp":1751745683,"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":"12290290","event":"ball","batsman_id":"99764","bowler_id":"107804","over":"7","ball":"4","score":0,"commentary":"Jeandell Cyril to Sadrack Descartes, no run,","noball_dismissal":false,"text":"","timestamp":1751745728,"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":"12290294","event":"wicket","batsman_id":"99764","bowler_id":"107804","over":"7","ball":"5","score":"w","commentary":"Jeandell Cyril to Sadrack Descartes, no run, b J Cyril,","noball_dismissal":false,"text":"","timestamp":1751745761,"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":"99764","how_out":"b J Cyril","batsman_runs":"28","batsman_balls":"12"},{"event_id":"12290301","event":"ball","batsman_id":"127001","bowler_id":"107804","over":"7","ball":"6","score":6,"commentary":"Jeandell Cyril to Magaran Shoulette, Six,","noball_dismissal":false,"text":"","timestamp":1751745839,"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":8,"runs":7,"score":"91\/3","bats":[{"runs":6,"balls_faced":1,"fours":0,"sixes":1,"batsman_id":127001},{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":127133}],"bowls":[{"runs_conceded":13,"maidens":0,"wickets":2,"bowler_id":107804,"overs":2},{"runs_conceded":37,"maidens":0,"wickets":1,"bowler_id":107705,"overs":2}],"commentary":"End of over 8 (7 runs), Calabash Giants 91\/3"},{"event_id":"12290316","event":"wicket","batsman_id":"127133","bowler_id":"116171","over":"8","ball":"1","score":"w","commentary":"Lee John to Stephen Abraham, no run, runout (L John \/ J Goodman),","noball_dismissal":false,"text":"","timestamp":1751746016,"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":"127001","how_out":"runout (L John \/ J Goodman)","batsman_runs":"6","batsman_balls":"1"},{"event_id":"12290319","event":"ball","batsman_id":"127133","bowler_id":"116171","over":"8","ball":"2","score":1,"commentary":"Lee John to Stephen Abraham, 1 run,","noball_dismissal":false,"text":"","timestamp":1751746044,"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":"12290324","event":"ball","batsman_id":"127132","bowler_id":"116171","over":"8","ball":"3","score":6,"commentary":"Lee John to Caleb Thomas, Six,","noball_dismissal":false,"text":"","timestamp":1751746192,"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":"12290325","event":"ball","batsman_id":"127132","bowler_id":"116171","over":"8","ball":"4","score":2,"commentary":"Lee John to Caleb Thomas, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751746197,"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":"12290326","event":"ball","batsman_id":"127132","bowler_id":"116171","over":"8","ball":"5","score":2,"commentary":"Lee John to Caleb Thomas, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751746200,"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":"12290327","event":"ball","batsman_id":"127132","bowler_id":"116171","over":"8","ball":"6","score":2,"commentary":"Lee John to Caleb Thomas, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751746205,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":9,"runs":13,"score":"104\/4","bats":[{"runs":12,"balls_faced":4,"fours":0,"sixes":1,"batsman_id":127132},{"runs":2,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":127133}],"bowls":[{"runs_conceded":19,"maidens":0,"wickets":0,"bowler_id":116171,"overs":2},{"runs_conceded":13,"maidens":0,"wickets":2,"bowler_id":107804,"overs":2}],"commentary":"End of over 9 (13 runs), Calabash Giants 104\/4"},{"event_id":"12290334","event":"ball","batsman_id":"127133","bowler_id":"99811","over":"9","ball":"1","score":0,"commentary":"Tyrel Chicot to Stephen Abraham, no run,","noball_dismissal":false,"text":"","timestamp":1751746308,"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":"12290337","event":"ball","batsman_id":"127133","bowler_id":"99811","over":"9","ball":"2","score":4,"commentary":"Tyrel Chicot to Stephen Abraham, Four,","noball_dismissal":false,"text":"","timestamp":1751746313,"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":"12290341","event":"wicket","batsman_id":"127133","bowler_id":"99811","over":"9","ball":"3","score":"w","commentary":"Tyrel Chicot to Stephen Abraham, no run, c A Venner b T Chicot,","noball_dismissal":false,"text":"","timestamp":1751746380,"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":"127133","how_out":"c A Venner b T Chicot","batsman_runs":"6","batsman_balls":"6"},{"event_id":"12290346","event":"ball","batsman_id":"52175","bowler_id":"99811","over":"9","ball":"4","score":6,"commentary":"Tyrel Chicot to Dornan Edward, Six,","noball_dismissal":false,"text":"","timestamp":1751746462,"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":"12290353","event":"wicket","batsman_id":"52175","bowler_id":"99811","over":"9","ball":"5","score":"w","commentary":"Tyrel Chicot to Dornan Edward, no run, c L Alexander b T Chicot,","noball_dismissal":false,"text":"","timestamp":1751746547,"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":"52175","how_out":"c L Alexander b T Chicot","batsman_runs":"6","batsman_balls":"2"},{"event_id":"12290354","event":"ball","batsman_id":"126998","bowler_id":"99811","over":"9","ball":"6","score":0,"commentary":"Tyrel Chicot to Cody Lesmond, no run,","noball_dismissal":false,"text":"","timestamp":1751747025,"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":10,"runs":10,"score":"114\/6","bats":[{"runs":0,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":126998},{"runs":12,"balls_faced":4,"fours":0,"sixes":1,"batsman_id":127132}],"bowls":[{"runs_conceded":12,"maidens":0,"wickets":2,"bowler_id":99811,"overs":2},{"runs_conceded":19,"maidens":0,"wickets":0,"bowler_id":116171,"overs":2}],"commentary":"End of over 10 (10 runs), Calabash Giants 114\/6"}],"day":"0","session":"0","live_inning":{"iid":199169,"number":2,"name":"Calabash Giants Inning","short_name":"CBG Inning","status":2,"issuperover":"false","result":4,"batting_team_id":129005,"fielding_team_id":129004,"scores":"114\/6","scores_full":"114\/6 (10 ov)","fielder":[{"fielder_id":"116171","fielder_name":"Lee John","catches":1,"runout_thrower":0,"runout_catcher":1,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"127134","fielder_name":"Amari Venner","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"99806","fielder_name":"Jard Goodman","catches":0,"runout_thrower":1,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"138274","fielder_name":"Leon Alexander","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"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":"Dornan Edward","batsman_id":"52175","runs":"6","balls":"2","how_out":"c L Alexander b T Chicot","score_at_dismissal":114,"overs_at_dismissal":"9.5","bowler_id":"99811","dismissal":"caught","number":6},"extra_runs":{"byes":0,"legbyes":2,"wides":1,"noballs":2,"penalty":"0","total":5},"equations":{"runs":114,"wickets":6,"overs":"10","bowlers_used":6,"runrate":"11.40"},"current_partnership":{"runs":0,"balls":1,"overs":0.1,"batsmen":[{"name":"Cody Lesmond","batsman_id":126998,"runs":0,"balls":1},{"name":"Caleb Thomas","batsman_id":127132,"runs":0,"balls":0}]},"did_not_bat":[{"player_id":"150063","name":"Alexus Charles"},{"player_id":"99743","name":"Wayne Prospere"},{"player_id":"138227","name":"Bjorn Fanus"}],"max_over":"10","target":"123","recent_scores":"0,w,6,w,4,0,2,2,2,6,1,w,6,w,0,1,w,0","last_five_overs":"63\/5 12.19","last_ten_overs":"114\/6 10.86"},"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":"122\/6 (10 ov)","scores":"122\/6","overs":"10"},{"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":"114\/6 (10 ov)","scores":"114\/6","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":7.5,"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":7.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":9,"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":8,"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":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":9,"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,"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":"bat","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":"bat","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":6,"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":7.5,"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":8,"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":6.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":"squad","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":8,"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":6,"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":7.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":8.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":8,"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":6.5,"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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","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":"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":"West Indies","role":"wk","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.5,"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":"92f41dbafd317607bd6e7d5e80e3d56a","modified":"2025-07-09 10:38:08","datetime":"2025-07-09 10:38:08","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":90971,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Whiptail Smashers won by 8 runs","day_remaining_over":"","team_batting":"Calabash Giants","team_bowling":"Whiptail Smashers","live_inning_number":2,"live_score":{"runs":114,"overs":10,"wickets":6,"target":123,"runrate":11.4,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Caleb Thomas","batsman_id":127132,"runs":12,"balls_faced":4,"fours":0,"sixes":1,"strike_rate":"300.00"},{"name":"Cody Lesmond","batsman_id":126998,"runs":0,"balls_faced":1,"fours":0,"sixes":0,"strike_rate":"0.00"}],"bowlers":[{"name":"Tyrel Chicot","bowler_id":99811,"overs":2,"runs_conceded":12,"wickets":2,"maidens":0,"econ":"6.00"},{"name":"Lee John","bowler_id":116171,"overs":2,"runs_conceded":19,"wickets":0,"maidens":0,"econ":"9.50"}],"commentaries":[{"event_id":"12290243","event":"ball","batsman_id":"99764","bowler_id":"116171","over":"5","ball":"6","score":1,"commentary":"Lee John to Sadrack Descartes, 1 run,","noball_dismissal":false,"text":"","timestamp":1751745246,"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":6,"runs":6,"score":"57\/1","bats":[{"runs":2,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":99764},{"runs":42,"balls_faced":23,"fours":5,"sixes":2,"batsman_id":70012}],"bowls":[{"runs_conceded":6,"maidens":0,"wickets":0,"bowler_id":116171,"overs":1},{"runs_conceded":10,"maidens":0,"wickets":1,"bowler_id":107705,"overs":1}],"commentary":"End of over 6 (6 runs), Calabash Giants 57\/1"},{"event_id":"12290248","event":"ball","batsman_id":"99764","bowler_id":"107705","over":"6","ball":"1","score":6,"commentary":"Ryan Goodman to Sadrack Descartes, Six,","noball_dismissal":false,"text":"","timestamp":1751745294,"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":"12290252","event":"ball","batsman_id":"99764","bowler_id":"107705","over":"6","ball":"2","score":6,"commentary":"Ryan Goodman to Sadrack Descartes, Six,","noball_dismissal":false,"text":"","timestamp":1751745319,"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":"12290254","event":"ball","batsman_id":"99764","bowler_id":"107705","over":"6","ball":"3","score":0,"commentary":"Ryan Goodman to Sadrack Descartes, no run,","noball_dismissal":false,"text":"","timestamp":1751745342,"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":"12290257","event":"ball","batsman_id":"99764","bowler_id":"107705","over":"6","ball":"4","score":6,"commentary":"Ryan Goodman to Sadrack Descartes, Six,","noball_dismissal":false,"text":"","timestamp":1751745371,"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":"12290261","event":"ball","batsman_id":"99764","bowler_id":"107705","over":"6","ball":"5","score":6,"commentary":"Ryan Goodman to Sadrack Descartes, Six,","noball_dismissal":false,"text":"","timestamp":1751745401,"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":"12290263","event":"ball","batsman_id":"99764","bowler_id":"107705","over":"6","ball":"6","score":"1nb","commentary":"Ryan Goodman to Sadrack Descartes, 1 no ball,","noball_dismissal":false,"text":"","timestamp":1751745461,"run":1,"noball_run":"1","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":true,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12290267","event":"ball","batsman_id":"99764","bowler_id":"107705","over":"6","ball":"6","score":2,"commentary":"Ryan Goodman to Sadrack Descartes, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751745465,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":7,"runs":27,"score":"84\/1","bats":[{"runs":28,"balls_faced":10,"fours":0,"sixes":4,"batsman_id":99764},{"runs":42,"balls_faced":23,"fours":5,"sixes":2,"batsman_id":70012}],"bowls":[{"runs_conceded":37,"maidens":0,"wickets":1,"bowler_id":107705,"overs":2},{"runs_conceded":6,"maidens":0,"wickets":0,"bowler_id":116171,"overs":1}],"commentary":"End of over 7 (27 runs), Calabash Giants 84\/1"},{"event_id":"12290274","event":"ball","batsman_id":"70012","bowler_id":"107804","over":"7","ball":"1","score":0,"commentary":"Jeandell Cyril to Mervin Wells, no run,","noball_dismissal":false,"text":"","timestamp":1751745539,"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":"12290278","event":"wicket","batsman_id":"70012","bowler_id":"107804","over":"7","ball":"2","score":"w","commentary":"Jeandell Cyril to Mervin Wells, no run, c L John b J Cyril,","noball_dismissal":false,"text":"","timestamp":1751745574,"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":"70012","how_out":"c L John b J Cyril","batsman_runs":"42","batsman_balls":"25"},{"event_id":"12290284","event":"ball","batsman_id":"127133","bowler_id":"107804","over":"7","ball":"3","score":1,"commentary":"Jeandell Cyril to Stephen Abraham, 1 run,","noball_dismissal":false,"text":"","timestamp":1751745683,"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":"12290290","event":"ball","batsman_id":"99764","bowler_id":"107804","over":"7","ball":"4","score":0,"commentary":"Jeandell Cyril to Sadrack Descartes, no run,","noball_dismissal":false,"text":"","timestamp":1751745728,"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":"12290294","event":"wicket","batsman_id":"99764","bowler_id":"107804","over":"7","ball":"5","score":"w","commentary":"Jeandell Cyril to Sadrack Descartes, no run, b J Cyril,","noball_dismissal":false,"text":"","timestamp":1751745761,"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":"99764","how_out":"b J Cyril","batsman_runs":"28","batsman_balls":"12"},{"event_id":"12290301","event":"ball","batsman_id":"127001","bowler_id":"107804","over":"7","ball":"6","score":6,"commentary":"Jeandell Cyril to Magaran Shoulette, Six,","noball_dismissal":false,"text":"","timestamp":1751745839,"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":8,"runs":7,"score":"91\/3","bats":[{"runs":6,"balls_faced":1,"fours":0,"sixes":1,"batsman_id":127001},{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":127133}],"bowls":[{"runs_conceded":13,"maidens":0,"wickets":2,"bowler_id":107804,"overs":2},{"runs_conceded":37,"maidens":0,"wickets":1,"bowler_id":107705,"overs":2}],"commentary":"End of over 8 (7 runs), Calabash Giants 91\/3"},{"event_id":"12290316","event":"wicket","batsman_id":"127133","bowler_id":"116171","over":"8","ball":"1","score":"w","commentary":"Lee John to Stephen Abraham, no run, runout (L John \/ J Goodman),","noball_dismissal":false,"text":"","timestamp":1751746016,"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":"127001","how_out":"runout (L John \/ J Goodman)","batsman_runs":"6","batsman_balls":"1"},{"event_id":"12290319","event":"ball","batsman_id":"127133","bowler_id":"116171","over":"8","ball":"2","score":1,"commentary":"Lee John to Stephen Abraham, 1 run,","noball_dismissal":false,"text":"","timestamp":1751746044,"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":"12290324","event":"ball","batsman_id":"127132","bowler_id":"116171","over":"8","ball":"3","score":6,"commentary":"Lee John to Caleb Thomas, Six,","noball_dismissal":false,"text":"","timestamp":1751746192,"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":"12290325","event":"ball","batsman_id":"127132","bowler_id":"116171","over":"8","ball":"4","score":2,"commentary":"Lee John to Caleb Thomas, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751746197,"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":"12290326","event":"ball","batsman_id":"127132","bowler_id":"116171","over":"8","ball":"5","score":2,"commentary":"Lee John to Caleb Thomas, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751746200,"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":"12290327","event":"ball","batsman_id":"127132","bowler_id":"116171","over":"8","ball":"6","score":2,"commentary":"Lee John to Caleb Thomas, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751746205,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":9,"runs":13,"score":"104\/4","bats":[{"runs":12,"balls_faced":4,"fours":0,"sixes":1,"batsman_id":127132},{"runs":2,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":127133}],"bowls":[{"runs_conceded":19,"maidens":0,"wickets":0,"bowler_id":116171,"overs":2},{"runs_conceded":13,"maidens":0,"wickets":2,"bowler_id":107804,"overs":2}],"commentary":"End of over 9 (13 runs), Calabash Giants 104\/4"},{"event_id":"12290334","event":"ball","batsman_id":"127133","bowler_id":"99811","over":"9","ball":"1","score":0,"commentary":"Tyrel Chicot to Stephen Abraham, no run,","noball_dismissal":false,"text":"","timestamp":1751746308,"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":"12290337","event":"ball","batsman_id":"127133","bowler_id":"99811","over":"9","ball":"2","score":4,"commentary":"Tyrel Chicot to Stephen Abraham, Four,","noball_dismissal":false,"text":"","timestamp":1751746313,"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":"12290341","event":"wicket","batsman_id":"127133","bowler_id":"99811","over":"9","ball":"3","score":"w","commentary":"Tyrel Chicot to Stephen Abraham, no run, c A Venner b T Chicot,","noball_dismissal":false,"text":"","timestamp":1751746380,"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":"127133","how_out":"c A Venner b T Chicot","batsman_runs":"6","batsman_balls":"6"},{"event_id":"12290346","event":"ball","batsman_id":"52175","bowler_id":"99811","over":"9","ball":"4","score":6,"commentary":"Tyrel Chicot to Dornan Edward, Six,","noball_dismissal":false,"text":"","timestamp":1751746462,"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":"12290353","event":"wicket","batsman_id":"52175","bowler_id":"99811","over":"9","ball":"5","score":"w","commentary":"Tyrel Chicot to Dornan Edward, no run, c L Alexander b T Chicot,","noball_dismissal":false,"text":"","timestamp":1751746547,"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":"52175","how_out":"c L Alexander b T Chicot","batsman_runs":"6","batsman_balls":"2"},{"event_id":"12290354","event":"ball","batsman_id":"126998","bowler_id":"99811","over":"9","ball":"6","score":0,"commentary":"Tyrel Chicot to Cody Lesmond, no run,","noball_dismissal":false,"text":"","timestamp":1751747025,"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":10,"runs":10,"score":"114\/6","bats":[{"runs":0,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":126998},{"runs":12,"balls_faced":4,"fours":0,"sixes":1,"batsman_id":127132}],"bowls":[{"runs_conceded":12,"maidens":0,"wickets":2,"bowler_id":99811,"overs":2},{"runs_conceded":19,"maidens":0,"wickets":0,"bowler_id":116171,"overs":2}],"commentary":"End of over 10 (10 runs), Calabash Giants 114\/6"}],"day":"0","session":"0","live_inning":{"iid":199169,"number":2,"name":"Calabash Giants Inning","short_name":"CBG Inning","status":2,"issuperover":"false","result":4,"batting_team_id":129005,"fielding_team_id":129004,"scores":"114\/6","scores_full":"114\/6 (10 ov)","fielder":[{"fielder_id":"116171","fielder_name":"Lee John","catches":1,"runout_thrower":0,"runout_catcher":1,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"127134","fielder_name":"Amari Venner","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"99806","fielder_name":"Jard Goodman","catches":0,"runout_thrower":1,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"138274","fielder_name":"Leon Alexander","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"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":"Dornan Edward","batsman_id":"52175","runs":"6","balls":"2","how_out":"c L Alexander b T Chicot","score_at_dismissal":114,"overs_at_dismissal":"9.5","bowler_id":"99811","dismissal":"caught","number":6},"extra_runs":{"byes":0,"legbyes":2,"wides":1,"noballs":2,"penalty":"0","total":5},"equations":{"runs":114,"wickets":6,"overs":"10","bowlers_used":6,"runrate":"11.40"},"current_partnership":{"runs":0,"balls":1,"overs":0.1,"batsmen":[{"name":"Cody Lesmond","batsman_id":126998,"runs":0,"balls":1},{"name":"Caleb Thomas","batsman_id":127132,"runs":0,"balls":0}]},"did_not_bat":[{"player_id":"150063","name":"Alexus Charles"},{"player_id":"99743","name":"Wayne Prospere"},{"player_id":"138227","name":"Bjorn Fanus"}],"max_over":"10","target":"123","recent_scores":"0,w,6,w,4,0,2,2,2,6,1,w,6,w,0,1,w,0","last_five_overs":"63\/5 12.19","last_ten_overs":"114\/6 10.86"},"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":"122\/6 (10 ov)","scores":"122\/6","overs":"10"},{"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":"114\/6 (10 ov)","scores":"114\/6","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":7.5,"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":7.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":9,"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":8,"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":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":9,"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,"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":"bat","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":"bat","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":6,"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":7.5,"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":8,"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":6.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":"squad","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":8,"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":6,"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":7.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":8.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":8,"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":6.5,"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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","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":"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":"West Indies","role":"wk","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.5,"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":"92f41dbafd317607bd6e7d5e80e3d56a","modified":"2025-07-09 10:38:08","datetime":"2025-07-09 10:38:08","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90971 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:fd5231ea-441d-4079-8e75-fa92108ddbc4
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90971 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90971,3,'{"status":"ok","response":{"match_id":90971,"title":"Whiptail Smashers vs Calabash Giants","short_title":"WTS vs CBG","subtitle":"Match 24","match_number":"24","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Whiptail Smashers won by 8 runs","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":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":"122\/6 (10 ov)","scores":"122\/6","overs":"10"},"teamb":{"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":"114\/6 (10 ov)","scores":"114\/6","overs":"10"},"date_start":"2025-07-05 18:30:00","date_end":"2025-07-06 04:30:00","timestamp_start":1751740200,"timestamp_end":1751776200,"date_start_ist":"2025-07-06 00:00:00","date_end_ist":"2025-07-06 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 8 runs","result_type":1,"win_margin":"8 runs","winning_team_id":129004,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-04 01:13:17","verify_time":"2025-07-06 02:09:49","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"scattered clouds","temp":27.59,"humidity":67,"visibility":10000,"wind_speed":"11.61","clouds":44},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Whiptail Smashers elected to bat","winner":129004,"decision":1}},"etag":"80e9dd473cb87a7cab74b4e442c6007b","modified":"2025-07-09 10:38:09","datetime":"2025-07-09 10:38:09","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90971,"title":"Whiptail Smashers vs Calabash Giants","short_title":"WTS vs CBG","subtitle":"Match 24","match_number":"24","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Whiptail Smashers won by 8 runs","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":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":"122\/6 (10 ov)","scores":"122\/6","overs":"10"},"teamb":{"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":"114\/6 (10 ov)","scores":"114\/6","overs":"10"},"date_start":"2025-07-05 18:30:00","date_end":"2025-07-06 04:30:00","timestamp_start":1751740200,"timestamp_end":1751776200,"date_start_ist":"2025-07-06 00:00:00","date_end_ist":"2025-07-06 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 8 runs","result_type":1,"win_margin":"8 runs","winning_team_id":129004,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-04 01:13:17","verify_time":"2025-07-06 02:09:49","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"scattered clouds","temp":27.59,"humidity":67,"visibility":10000,"wind_speed":"11.61","clouds":44},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Whiptail Smashers elected to bat","winner":129004,"decision":1}},"etag":"80e9dd473cb87a7cab74b4e442c6007b","modified":"2025-07-09 10:38:09","datetime":"2025-07-09 10:38:09","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90971 AND DataTypeId = 3 END Live Report & Scorecard of Whiptail Smashers vs Calabash Giants Match 24
Whiptail Smashers vs Calabash Giants, Live Cricket Commentary