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:23ee9bb0-6125-4216-84e4-b6be0b19288a
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90974 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90974,1,'{"status":"ok","response":{"mid":90974,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Iyanola Heritage won by 6 wickets (DLS method)","day_remaining_over":"","team_batting":"Iyanola Heritage","team_bowling":"Whiptail Smashers","live_inning_number":2,"live_score":{"runs":72,"overs":7.2,"wickets":4,"target":69,"runrate":9.82,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Jamaal James","batsman_id":99793,"runs":10,"balls_faced":5,"fours":2,"sixes":0,"strike_rate":"200.00"},{"name":"Vernillius Gabriel","batsman_id":99808,"runs":0,"balls_faced":2,"fours":0,"sixes":0,"strike_rate":"0.00"}],"bowlers":[{"name":"Ryan Goodman","bowler_id":107705,"overs":0.2,"runs_conceded":4,"wickets":0,"maidens":0,"econ":"12.00"},{"name":"Lee John","bowler_id":116171,"overs":2,"runs_conceded":17,"wickets":1,"maidens":0,"econ":"8.50"}],"commentaries":[{"event_id":"12303195","event":"ball","batsman_id":"138224","bowler_id":"107775","over":"3","ball":"1","score":"1lb","commentary":"Shawnil Edward to Dominic Auguste, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1751909621,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"1","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12303196","event":"ball","batsman_id":"107727","bowler_id":"107775","over":"3","ball":"2","score":4,"commentary":"Shawnil Edward to Ephron Charles, Four,","noball_dismissal":false,"text":"","timestamp":1751909657,"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":"12303197","event":"ball","batsman_id":"107727","bowler_id":"107775","over":"3","ball":"3","score":0,"commentary":"Shawnil Edward to Ephron Charles, no run,","noball_dismissal":false,"text":"","timestamp":1751909692,"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":"12303198","event":"wicket","batsman_id":"107727","bowler_id":"107775","over":"3","ball":"4","score":"w","commentary":"Shawnil Edward to Ephron Charles, no run, c L John b S Edward,","noball_dismissal":false,"text":"","timestamp":1751909750,"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":"107727","how_out":"c L John b S Edward","batsman_runs":"19","batsman_balls":"11"},{"event_id":"12303204","event":"ball","batsman_id":"92689","bowler_id":"107775","over":"3","ball":"5","score":0,"commentary":"Shawnil Edward to Xavier Gabriel, no run,","noball_dismissal":false,"text":"","timestamp":1751909854,"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":"12303205","event":"ball","batsman_id":"92689","bowler_id":"107775","over":"3","ball":"6","score":4,"commentary":"Shawnil Edward to Xavier Gabriel, Four,","noball_dismissal":false,"text":"","timestamp":1751909859,"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":4,"runs":9,"score":"37\/2","bats":[{"runs":4,"balls_faced":2,"fours":1,"sixes":0,"batsman_id":92689},{"runs":10,"balls_faced":10,"fours":2,"sixes":0,"batsman_id":138224}],"bowls":[{"runs_conceded":8,"maidens":0,"wickets":1,"bowler_id":107775,"overs":1},{"runs_conceded":13,"maidens":0,"wickets":0,"bowler_id":107804,"overs":1}],"commentary":"End of over 4 (9 runs), Iyanola Heritage 37\/2"},{"event_id":"12303207","event":"ball","batsman_id":"138224","bowler_id":"99811","over":"4","ball":"1","score":1,"commentary":"Tyrel Chicot to Dominic Auguste, 1 run,","noball_dismissal":false,"text":"","timestamp":1751909952,"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":"12303208","event":"ball","batsman_id":"92689","bowler_id":"99811","over":"4","ball":"2","score":2,"commentary":"Tyrel Chicot to Xavier Gabriel, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751910021,"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":"12303209","event":"ball","batsman_id":"92689","bowler_id":"99811","over":"4","ball":"3","score":4,"commentary":"Tyrel Chicot to Xavier Gabriel, Four,","noball_dismissal":false,"text":"","timestamp":1751910058,"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":"12303212","event":"ball","batsman_id":"92689","bowler_id":"99811","over":"4","ball":"4","score":2,"commentary":"Tyrel Chicot to Xavier Gabriel, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751910100,"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":"12303217","event":"ball","batsman_id":"92689","bowler_id":"99811","over":"4","ball":"5","score":1,"commentary":"Tyrel Chicot to Xavier Gabriel, 1 run,","noball_dismissal":false,"text":"","timestamp":1751910252,"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":"12303218","event":"ball","batsman_id":"138224","bowler_id":"99811","over":"4","ball":"6","score":2,"commentary":"Tyrel Chicot to Dominic Auguste, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751910260,"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":5,"runs":12,"score":"49\/2","bats":[{"runs":13,"balls_faced":12,"fours":2,"sixes":0,"batsman_id":138224},{"runs":13,"balls_faced":6,"fours":2,"sixes":0,"batsman_id":92689}],"bowls":[{"runs_conceded":17,"maidens":0,"wickets":0,"bowler_id":99811,"overs":2},{"runs_conceded":8,"maidens":0,"wickets":1,"bowler_id":107775,"overs":1}],"commentary":"End of over 5 (12 runs), Iyanola Heritage 49\/2"},{"event_id":"12303223","event":"wicket","batsman_id":"92689","bowler_id":"107775","over":"5","ball":"1","score":"w","commentary":"Shawnil Edward to Xavier Gabriel, no run, b S Edward,","noball_dismissal":false,"text":"","timestamp":1751910361,"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":"92689","how_out":"b S Edward","batsman_runs":"13","batsman_balls":"7"},{"event_id":"12303228","event":"ball","batsman_id":"99793","bowler_id":"107775","over":"5","ball":"2","score":4,"commentary":"Shawnil Edward to Jamaal James, Four,","noball_dismissal":false,"text":"","timestamp":1751910508,"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":"12303229","event":"ball","batsman_id":"99793","bowler_id":"107775","over":"5","ball":"3","score":1,"commentary":"Shawnil Edward to Jamaal James, 1 run,","noball_dismissal":false,"text":"","timestamp":1751910511,"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":"12303232","event":"ball","batsman_id":"138224","bowler_id":"107775","over":"5","ball":"4","score":0,"commentary":"Shawnil Edward to Dominic Auguste, no run,","noball_dismissal":false,"text":"","timestamp":1751910585,"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":"12303233","event":"ball","batsman_id":"138224","bowler_id":"107775","over":"5","ball":"5","score":4,"commentary":"Shawnil Edward to Dominic Auguste, Four,","noball_dismissal":false,"text":"","timestamp":1751910589,"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":"12303237","event":"ball","batsman_id":"138224","bowler_id":"107775","over":"5","ball":"6","score":1,"commentary":"Shawnil Edward to Dominic Auguste, 1 run,","noball_dismissal":false,"text":"","timestamp":1751910671,"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":10,"score":"59\/3","bats":[{"runs":18,"balls_faced":15,"fours":3,"sixes":0,"batsman_id":138224},{"runs":5,"balls_faced":2,"fours":1,"sixes":0,"batsman_id":99793}],"bowls":[{"runs_conceded":18,"maidens":0,"wickets":2,"bowler_id":107775,"overs":2},{"runs_conceded":17,"maidens":0,"wickets":0,"bowler_id":99811,"overs":2}],"commentary":"End of over 6 (10 runs), Iyanola Heritage 59\/3"},{"event_id":"12303243","event":"ball","batsman_id":"138224","bowler_id":"116171","over":"6","ball":"1","score":1,"commentary":"Lee John to Dominic Auguste, 1 run,","noball_dismissal":false,"text":"","timestamp":1751911001,"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":"12303245","event":"ball","batsman_id":"99793","bowler_id":"116171","over":"6","ball":"2","score":1,"commentary":"Lee John to Jamaal James, 1 run,","noball_dismissal":false,"text":"","timestamp":1751911013,"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":"12303248","event":"ball","batsman_id":"138224","bowler_id":"116171","over":"6","ball":"3","score":6,"commentary":"Lee John to Dominic Auguste, Six,","noball_dismissal":false,"text":"","timestamp":1751911017,"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":"12303269","event":"wicket","batsman_id":"138224","bowler_id":"116171","over":"6","ball":"4","score":"w","commentary":"Lee John to Dominic Auguste, no run, runout (A Alexander),","noball_dismissal":false,"text":"","timestamp":1751912001,"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":"138224","how_out":"runout (A Alexander)","batsman_runs":"25","batsman_balls":"18"},{"event_id":"12303271","event":"ball","batsman_id":"99808","bowler_id":"116171","over":"6","ball":"5","score":0,"commentary":"Lee John to Vernillius Gabriel, no run,","noball_dismissal":false,"text":"","timestamp":1751912045,"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":"12303280","event":"ball","batsman_id":"99808","bowler_id":"116171","over":"6","ball":"6","score":"1wd","commentary":"Lee John to Vernillius Gabriel, 1 wide,","noball_dismissal":false,"text":"","timestamp":1751912080,"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":"12303281","event":"ball","batsman_id":"99808","bowler_id":"116171","over":"6","ball":"6","score":0,"commentary":"Lee John to Vernillius Gabriel, no run,","noball_dismissal":false,"text":"","timestamp":1751912083,"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":7,"runs":9,"score":"68\/4","bats":[{"runs":0,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":99808},{"runs":6,"balls_faced":3,"fours":1,"sixes":0,"batsman_id":99793}],"bowls":[{"runs_conceded":17,"maidens":0,"wickets":1,"bowler_id":116171,"overs":2},{"runs_conceded":18,"maidens":0,"wickets":2,"bowler_id":107775,"overs":2}],"commentary":"End of over 7 (9 runs), Iyanola Heritage 68\/4"},{"event_id":"12303282","event":"ball","batsman_id":"99793","bowler_id":"107705","over":"7","ball":"1","score":0,"commentary":"Ryan Goodman to Jamaal James, no run,","noball_dismissal":false,"text":"","timestamp":1751912086,"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":"12303283","event":"ball","batsman_id":"99793","bowler_id":"107705","over":"7","ball":"2","score":4,"commentary":"Ryan Goodman to Jamaal James, Four,","noball_dismissal":false,"text":"","timestamp":1751912089,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false}],"day":"0","session":"0","live_inning":{"iid":199278,"number":2,"name":"Iyanola Heritage Inning","short_name":"IYH Inning","status":2,"issuperover":"false","result":3,"batting_team_id":129001,"fielding_team_id":129004,"scores":"72\/4","scores_full":"72\/4 (7.2 ov)","fielder":[{"fielder_id":"107705","fielder_name":"Ryan Goodman","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"116171","fielder_name":"Lee John","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"138275","fielder_name":"Ashton Alexander","catches":0,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":1,"stumping":0,"is_substitute":"false"}],"powerplay":[],"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Dominic Auguste","batsman_id":"138224","runs":"25","balls":"18","how_out":"runout (A Alexander)","score_at_dismissal":67,"overs_at_dismissal":"6.4","bowler_id":"0","dismissal":"runout","number":4},"extra_runs":{"byes":1,"legbyes":2,"wides":2,"noballs":0,"penalty":"0","total":5},"equations":{"runs":72,"wickets":4,"overs":"7.2","bowlers_used":5,"runrate":"9.82"},"current_partnership":{"runs":5,"balls":4,"overs":0.4,"batsmen":[{"name":"Vernillius Gabriel","batsman_id":99808,"runs":0,"balls":2},{"name":"Jamaal James","batsman_id":99793,"runs":4,"balls":2}]},"did_not_bat":[{"player_id":"116125","name":"Jaylan Chandler"},{"player_id":"107721","name":"Wendell Inglis"},{"player_id":"100052","name":"Aaron Joseph"},{"player_id":"138230","name":"Zinakki Louis"},{"player_id":"107772","name":"Jamal Lesmond"}],"max_over":"8","target":"69","recent_scores":"4,0,0,1,0,w,6,1,1,1,4,0,1,4,w,2,1,2","last_five_overs":"56\/3 10.84","last_ten_overs":"72\/4 9.39"},"teams":[{"tid":129001,"title":"Iyanola Heritage","abbr":"IYH","alt_name":"Iyanola Heritage","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Iyanola-Heritage.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Iyanola-Heritage.png","country":"wi","sex":"male","team_owner":"","head_coach":"","scores_full":"72\/4 (7.2 ov)","scores":"72\/4","overs":"7.2"},{"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":"66\/4 (8 ov)","scores":"66\/4","overs":"8"}],"players":[{"pid":482,"title":"Johnson Charles","short_name":"J Charles","first_name":"Johnson Charles","last_name":"","middle_name":"","birthdate":"1989-01-14","birthplace":"St Lucia","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/realjcharles\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":92689,"title":"Xavier Gabriel","short_name":"Xavier Gabriel","first_name":"Xavier Gabriel","last_name":"","middle_name":"","birthdate":"1985-12-18","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":"(C)"},{"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":99793,"title":"Jamaal James","short_name":"J James","first_name":"Jamaal James","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":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":99808,"title":"Vernillius Gabriel","short_name":"V Gabriel","first_name":"Vernillius Gabriel","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":100044,"title":"Collinus Callendar","short_name":"C Callendar","first_name":"Collinus Callendar","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":"squad","role_str":""},{"pid":100052,"title":"Aaron Joseph","short_name":"A Joseph","first_name":"Aaron Joseph","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":107703,"title":"Bolton Sayers","short_name":"B Sayers","first_name":"Bolton Sayers","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":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":107721,"title":"Wendell Inglis","short_name":"W Inglis","first_name":"Wendell Inglis","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":107726,"title":"Dwight Thomas","short_name":"D Thomas","first_name":"Dwight Thomas","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":107727,"title":"Ephron Charles","short_name":"E Charles","first_name":"Ephron Charles","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":107772,"title":"Jamal Lesmond","short_name":"J Lesmond","first_name":"Jamal Lesmond","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","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":116125,"title":"Jaylan Chandler","short_name":"J Chandler","first_name":"Jaylan Chandler","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":116162,"title":"Kensley Paul","short_name":"K Paul","first_name":"Kensley Paul","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":"bat","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":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":138224,"title":"Dominic Auguste","short_name":"D Auguste","first_name":"Dominic Auguste","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":""},{"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":138230,"title":"Zinakki Louis","short_name":"Z Louis","first_name":"Zinakki Louis","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":150058,"title":"Aiden Scholer","short_name":"AD Scholer","first_name":"Aiden Scholer","last_name":"","middle_name":"","birthdate":"2009-10-13","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"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":""}]},"etag":"359ecded414f43f23bdccbaaec7c5165","modified":"2025-07-09 07:35:20","datetime":"2025-07-09 07:35:20","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":90974,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Iyanola Heritage won by 6 wickets (DLS method)","day_remaining_over":"","team_batting":"Iyanola Heritage","team_bowling":"Whiptail Smashers","live_inning_number":2,"live_score":{"runs":72,"overs":7.2,"wickets":4,"target":69,"runrate":9.82,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Jamaal James","batsman_id":99793,"runs":10,"balls_faced":5,"fours":2,"sixes":0,"strike_rate":"200.00"},{"name":"Vernillius Gabriel","batsman_id":99808,"runs":0,"balls_faced":2,"fours":0,"sixes":0,"strike_rate":"0.00"}],"bowlers":[{"name":"Ryan Goodman","bowler_id":107705,"overs":0.2,"runs_conceded":4,"wickets":0,"maidens":0,"econ":"12.00"},{"name":"Lee John","bowler_id":116171,"overs":2,"runs_conceded":17,"wickets":1,"maidens":0,"econ":"8.50"}],"commentaries":[{"event_id":"12303195","event":"ball","batsman_id":"138224","bowler_id":"107775","over":"3","ball":"1","score":"1lb","commentary":"Shawnil Edward to Dominic Auguste, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1751909621,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"1","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12303196","event":"ball","batsman_id":"107727","bowler_id":"107775","over":"3","ball":"2","score":4,"commentary":"Shawnil Edward to Ephron Charles, Four,","noball_dismissal":false,"text":"","timestamp":1751909657,"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":"12303197","event":"ball","batsman_id":"107727","bowler_id":"107775","over":"3","ball":"3","score":0,"commentary":"Shawnil Edward to Ephron Charles, no run,","noball_dismissal":false,"text":"","timestamp":1751909692,"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":"12303198","event":"wicket","batsman_id":"107727","bowler_id":"107775","over":"3","ball":"4","score":"w","commentary":"Shawnil Edward to Ephron Charles, no run, c L John b S Edward,","noball_dismissal":false,"text":"","timestamp":1751909750,"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":"107727","how_out":"c L John b S Edward","batsman_runs":"19","batsman_balls":"11"},{"event_id":"12303204","event":"ball","batsman_id":"92689","bowler_id":"107775","over":"3","ball":"5","score":0,"commentary":"Shawnil Edward to Xavier Gabriel, no run,","noball_dismissal":false,"text":"","timestamp":1751909854,"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":"12303205","event":"ball","batsman_id":"92689","bowler_id":"107775","over":"3","ball":"6","score":4,"commentary":"Shawnil Edward to Xavier Gabriel, Four,","noball_dismissal":false,"text":"","timestamp":1751909859,"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":4,"runs":9,"score":"37\/2","bats":[{"runs":4,"balls_faced":2,"fours":1,"sixes":0,"batsman_id":92689},{"runs":10,"balls_faced":10,"fours":2,"sixes":0,"batsman_id":138224}],"bowls":[{"runs_conceded":8,"maidens":0,"wickets":1,"bowler_id":107775,"overs":1},{"runs_conceded":13,"maidens":0,"wickets":0,"bowler_id":107804,"overs":1}],"commentary":"End of over 4 (9 runs), Iyanola Heritage 37\/2"},{"event_id":"12303207","event":"ball","batsman_id":"138224","bowler_id":"99811","over":"4","ball":"1","score":1,"commentary":"Tyrel Chicot to Dominic Auguste, 1 run,","noball_dismissal":false,"text":"","timestamp":1751909952,"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":"12303208","event":"ball","batsman_id":"92689","bowler_id":"99811","over":"4","ball":"2","score":2,"commentary":"Tyrel Chicot to Xavier Gabriel, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751910021,"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":"12303209","event":"ball","batsman_id":"92689","bowler_id":"99811","over":"4","ball":"3","score":4,"commentary":"Tyrel Chicot to Xavier Gabriel, Four,","noball_dismissal":false,"text":"","timestamp":1751910058,"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":"12303212","event":"ball","batsman_id":"92689","bowler_id":"99811","over":"4","ball":"4","score":2,"commentary":"Tyrel Chicot to Xavier Gabriel, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751910100,"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":"12303217","event":"ball","batsman_id":"92689","bowler_id":"99811","over":"4","ball":"5","score":1,"commentary":"Tyrel Chicot to Xavier Gabriel, 1 run,","noball_dismissal":false,"text":"","timestamp":1751910252,"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":"12303218","event":"ball","batsman_id":"138224","bowler_id":"99811","over":"4","ball":"6","score":2,"commentary":"Tyrel Chicot to Dominic Auguste, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751910260,"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":5,"runs":12,"score":"49\/2","bats":[{"runs":13,"balls_faced":12,"fours":2,"sixes":0,"batsman_id":138224},{"runs":13,"balls_faced":6,"fours":2,"sixes":0,"batsman_id":92689}],"bowls":[{"runs_conceded":17,"maidens":0,"wickets":0,"bowler_id":99811,"overs":2},{"runs_conceded":8,"maidens":0,"wickets":1,"bowler_id":107775,"overs":1}],"commentary":"End of over 5 (12 runs), Iyanola Heritage 49\/2"},{"event_id":"12303223","event":"wicket","batsman_id":"92689","bowler_id":"107775","over":"5","ball":"1","score":"w","commentary":"Shawnil Edward to Xavier Gabriel, no run, b S Edward,","noball_dismissal":false,"text":"","timestamp":1751910361,"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":"92689","how_out":"b S Edward","batsman_runs":"13","batsman_balls":"7"},{"event_id":"12303228","event":"ball","batsman_id":"99793","bowler_id":"107775","over":"5","ball":"2","score":4,"commentary":"Shawnil Edward to Jamaal James, Four,","noball_dismissal":false,"text":"","timestamp":1751910508,"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":"12303229","event":"ball","batsman_id":"99793","bowler_id":"107775","over":"5","ball":"3","score":1,"commentary":"Shawnil Edward to Jamaal James, 1 run,","noball_dismissal":false,"text":"","timestamp":1751910511,"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":"12303232","event":"ball","batsman_id":"138224","bowler_id":"107775","over":"5","ball":"4","score":0,"commentary":"Shawnil Edward to Dominic Auguste, no run,","noball_dismissal":false,"text":"","timestamp":1751910585,"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":"12303233","event":"ball","batsman_id":"138224","bowler_id":"107775","over":"5","ball":"5","score":4,"commentary":"Shawnil Edward to Dominic Auguste, Four,","noball_dismissal":false,"text":"","timestamp":1751910589,"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":"12303237","event":"ball","batsman_id":"138224","bowler_id":"107775","over":"5","ball":"6","score":1,"commentary":"Shawnil Edward to Dominic Auguste, 1 run,","noball_dismissal":false,"text":"","timestamp":1751910671,"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":10,"score":"59\/3","bats":[{"runs":18,"balls_faced":15,"fours":3,"sixes":0,"batsman_id":138224},{"runs":5,"balls_faced":2,"fours":1,"sixes":0,"batsman_id":99793}],"bowls":[{"runs_conceded":18,"maidens":0,"wickets":2,"bowler_id":107775,"overs":2},{"runs_conceded":17,"maidens":0,"wickets":0,"bowler_id":99811,"overs":2}],"commentary":"End of over 6 (10 runs), Iyanola Heritage 59\/3"},{"event_id":"12303243","event":"ball","batsman_id":"138224","bowler_id":"116171","over":"6","ball":"1","score":1,"commentary":"Lee John to Dominic Auguste, 1 run,","noball_dismissal":false,"text":"","timestamp":1751911001,"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":"12303245","event":"ball","batsman_id":"99793","bowler_id":"116171","over":"6","ball":"2","score":1,"commentary":"Lee John to Jamaal James, 1 run,","noball_dismissal":false,"text":"","timestamp":1751911013,"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":"12303248","event":"ball","batsman_id":"138224","bowler_id":"116171","over":"6","ball":"3","score":6,"commentary":"Lee John to Dominic Auguste, Six,","noball_dismissal":false,"text":"","timestamp":1751911017,"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":"12303269","event":"wicket","batsman_id":"138224","bowler_id":"116171","over":"6","ball":"4","score":"w","commentary":"Lee John to Dominic Auguste, no run, runout (A Alexander),","noball_dismissal":false,"text":"","timestamp":1751912001,"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":"138224","how_out":"runout (A Alexander)","batsman_runs":"25","batsman_balls":"18"},{"event_id":"12303271","event":"ball","batsman_id":"99808","bowler_id":"116171","over":"6","ball":"5","score":0,"commentary":"Lee John to Vernillius Gabriel, no run,","noball_dismissal":false,"text":"","timestamp":1751912045,"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":"12303280","event":"ball","batsman_id":"99808","bowler_id":"116171","over":"6","ball":"6","score":"1wd","commentary":"Lee John to Vernillius Gabriel, 1 wide,","noball_dismissal":false,"text":"","timestamp":1751912080,"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":"12303281","event":"ball","batsman_id":"99808","bowler_id":"116171","over":"6","ball":"6","score":0,"commentary":"Lee John to Vernillius Gabriel, no run,","noball_dismissal":false,"text":"","timestamp":1751912083,"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":7,"runs":9,"score":"68\/4","bats":[{"runs":0,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":99808},{"runs":6,"balls_faced":3,"fours":1,"sixes":0,"batsman_id":99793}],"bowls":[{"runs_conceded":17,"maidens":0,"wickets":1,"bowler_id":116171,"overs":2},{"runs_conceded":18,"maidens":0,"wickets":2,"bowler_id":107775,"overs":2}],"commentary":"End of over 7 (9 runs), Iyanola Heritage 68\/4"},{"event_id":"12303282","event":"ball","batsman_id":"99793","bowler_id":"107705","over":"7","ball":"1","score":0,"commentary":"Ryan Goodman to Jamaal James, no run,","noball_dismissal":false,"text":"","timestamp":1751912086,"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":"12303283","event":"ball","batsman_id":"99793","bowler_id":"107705","over":"7","ball":"2","score":4,"commentary":"Ryan Goodman to Jamaal James, Four,","noball_dismissal":false,"text":"","timestamp":1751912089,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false}],"day":"0","session":"0","live_inning":{"iid":199278,"number":2,"name":"Iyanola Heritage Inning","short_name":"IYH Inning","status":2,"issuperover":"false","result":3,"batting_team_id":129001,"fielding_team_id":129004,"scores":"72\/4","scores_full":"72\/4 (7.2 ov)","fielder":[{"fielder_id":"107705","fielder_name":"Ryan Goodman","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"116171","fielder_name":"Lee John","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"138275","fielder_name":"Ashton Alexander","catches":0,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":1,"stumping":0,"is_substitute":"false"}],"powerplay":[],"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Dominic Auguste","batsman_id":"138224","runs":"25","balls":"18","how_out":"runout (A Alexander)","score_at_dismissal":67,"overs_at_dismissal":"6.4","bowler_id":"0","dismissal":"runout","number":4},"extra_runs":{"byes":1,"legbyes":2,"wides":2,"noballs":0,"penalty":"0","total":5},"equations":{"runs":72,"wickets":4,"overs":"7.2","bowlers_used":5,"runrate":"9.82"},"current_partnership":{"runs":5,"balls":4,"overs":0.4,"batsmen":[{"name":"Vernillius Gabriel","batsman_id":99808,"runs":0,"balls":2},{"name":"Jamaal James","batsman_id":99793,"runs":4,"balls":2}]},"did_not_bat":[{"player_id":"116125","name":"Jaylan Chandler"},{"player_id":"107721","name":"Wendell Inglis"},{"player_id":"100052","name":"Aaron Joseph"},{"player_id":"138230","name":"Zinakki Louis"},{"player_id":"107772","name":"Jamal Lesmond"}],"max_over":"8","target":"69","recent_scores":"4,0,0,1,0,w,6,1,1,1,4,0,1,4,w,2,1,2","last_five_overs":"56\/3 10.84","last_ten_overs":"72\/4 9.39"},"teams":[{"tid":129001,"title":"Iyanola Heritage","abbr":"IYH","alt_name":"Iyanola Heritage","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Iyanola-Heritage.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Iyanola-Heritage.png","country":"wi","sex":"male","team_owner":"","head_coach":"","scores_full":"72\/4 (7.2 ov)","scores":"72\/4","overs":"7.2"},{"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":"66\/4 (8 ov)","scores":"66\/4","overs":"8"}],"players":[{"pid":482,"title":"Johnson Charles","short_name":"J Charles","first_name":"Johnson Charles","last_name":"","middle_name":"","birthdate":"1989-01-14","birthplace":"St Lucia","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/realjcharles\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":92689,"title":"Xavier Gabriel","short_name":"Xavier Gabriel","first_name":"Xavier Gabriel","last_name":"","middle_name":"","birthdate":"1985-12-18","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":"(C)"},{"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":99793,"title":"Jamaal James","short_name":"J James","first_name":"Jamaal James","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":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":99808,"title":"Vernillius Gabriel","short_name":"V Gabriel","first_name":"Vernillius Gabriel","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":100044,"title":"Collinus Callendar","short_name":"C Callendar","first_name":"Collinus Callendar","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":"squad","role_str":""},{"pid":100052,"title":"Aaron Joseph","short_name":"A Joseph","first_name":"Aaron Joseph","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":107703,"title":"Bolton Sayers","short_name":"B Sayers","first_name":"Bolton Sayers","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":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":107721,"title":"Wendell Inglis","short_name":"W Inglis","first_name":"Wendell Inglis","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":107726,"title":"Dwight Thomas","short_name":"D Thomas","first_name":"Dwight Thomas","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":107727,"title":"Ephron Charles","short_name":"E Charles","first_name":"Ephron Charles","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":107772,"title":"Jamal Lesmond","short_name":"J Lesmond","first_name":"Jamal Lesmond","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","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":116125,"title":"Jaylan Chandler","short_name":"J Chandler","first_name":"Jaylan Chandler","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":116162,"title":"Kensley Paul","short_name":"K Paul","first_name":"Kensley Paul","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":"bat","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":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":138224,"title":"Dominic Auguste","short_name":"D Auguste","first_name":"Dominic Auguste","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":""},{"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":138230,"title":"Zinakki Louis","short_name":"Z Louis","first_name":"Zinakki Louis","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":150058,"title":"Aiden Scholer","short_name":"AD Scholer","first_name":"Aiden Scholer","last_name":"","middle_name":"","birthdate":"2009-10-13","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"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":""}]},"etag":"359ecded414f43f23bdccbaaec7c5165","modified":"2025-07-09 07:35:20","datetime":"2025-07-09 07:35:20","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90974 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:b522a7f6-022b-427f-9921-4d959ba201f5
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90974 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90974,3,'{"status":"ok","response":{"match_id":90974,"title":"Whiptail Smashers vs Iyanola Heritage","short_title":"WTS vs IYH","subtitle":"Match 27","match_number":"27","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Iyanola Heritage won by 6 wickets (DLS method)","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":"31","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":"66\/4 (8 ov)","scores":"66\/4","overs":"8"},"teamb":{"team_id":129001,"name":"Iyanola Heritage","short_name":"IYH","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Iyanola-Heritage.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Iyanola-Heritage.png","scores_full":"72\/4 (7.2 ov)","scores":"72\/4","overs":"7.2"},"date_start":"2025-07-07 16:00:00","date_end":"2025-07-08 02:00:00","timestamp_start":1751904000,"timestamp_end":1751940000,"date_start_ist":"2025-07-07 21:30:00","date_end_ist":"2025-07-08 07:30:00","venue":{"venue_id":"85","name":"Daren Sammy National Cricket Stadium, St Lucia","location":"Gros Islet","country":"West Indies","timezone":""},"umpires":"L Louisy (West Indies), Renee Napoleon (West Indies), A Augustin (West Indies, TV)","referee":"Patrick Felix (West Indies)","equation":"","live":"","result":"IYH won by 6 wickets (DLS method)","result_type":2,"win_margin":"6 wickets (DLS method)","winning_team_id":129001,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-07 05:53:44","verify_time":"2025-07-07 23:57:06","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clear","weather_desc":"clear sky","temp":28.12,"humidity":71,"visibility":10000,"wind_speed":"17.98","clouds":9},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Iyanola Heritage elected to bowl","winner":129001,"decision":2}},"etag":"5b7e9ac077d5eaae7bdc79298ca6eb3c","modified":"2025-07-09 07:35:21","datetime":"2025-07-09 07:35:21","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90974,"title":"Whiptail Smashers vs Iyanola Heritage","short_title":"WTS vs IYH","subtitle":"Match 27","match_number":"27","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Iyanola Heritage won by 6 wickets (DLS method)","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":"31","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":"66\/4 (8 ov)","scores":"66\/4","overs":"8"},"teamb":{"team_id":129001,"name":"Iyanola Heritage","short_name":"IYH","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Iyanola-Heritage.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Iyanola-Heritage.png","scores_full":"72\/4 (7.2 ov)","scores":"72\/4","overs":"7.2"},"date_start":"2025-07-07 16:00:00","date_end":"2025-07-08 02:00:00","timestamp_start":1751904000,"timestamp_end":1751940000,"date_start_ist":"2025-07-07 21:30:00","date_end_ist":"2025-07-08 07:30:00","venue":{"venue_id":"85","name":"Daren Sammy National Cricket Stadium, St Lucia","location":"Gros Islet","country":"West Indies","timezone":""},"umpires":"L Louisy (West Indies), Renee Napoleon (West Indies), A Augustin (West Indies, TV)","referee":"Patrick Felix (West Indies)","equation":"","live":"","result":"IYH won by 6 wickets (DLS method)","result_type":2,"win_margin":"6 wickets (DLS method)","winning_team_id":129001,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-07 05:53:44","verify_time":"2025-07-07 23:57:06","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clear","weather_desc":"clear sky","temp":28.12,"humidity":71,"visibility":10000,"wind_speed":"17.98","clouds":9},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Iyanola Heritage elected to bowl","winner":129001,"decision":2}},"etag":"5b7e9ac077d5eaae7bdc79298ca6eb3c","modified":"2025-07-09 07:35:21","datetime":"2025-07-09 07:35:21","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90974 AND DataTypeId = 3 END Live Report & Scorecard of Whiptail Smashers vs Iyanola Heritage Match 27
Whiptail Smashers vs Iyanola Heritage, Live Cricket Commentary