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:039914aa-e8a1-49f6-8771-fc979425e767
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90947 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90947,1,'{"status":"ok","response":{"mid":90947,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Iyanola Heritage won by 5 wickets","day_remaining_over":"","team_batting":"Iyanola Heritage","team_bowling":"Piton Stickers","live_inning_number":2,"live_score":{"runs":95,"overs":8.3,"wickets":5,"target":93,"runrate":11.18,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Jamaal James","batsman_id":99793,"runs":9,"balls_faced":10,"fours":1,"sixes":0,"strike_rate":"90.00"},{"name":"Dwight Thomas","batsman_id":107726,"runs":5,"balls_faced":2,"fours":1,"sixes":0,"strike_rate":"250.00"}],"bowlers":[{"name":"Keon Gaston","bowler_id":99762,"overs":1.3,"runs_conceded":19,"wickets":0,"maidens":0,"econ":"12.67"},{"name":"Yunieski Gustave","bowler_id":150060,"overs":2,"runs_conceded":12,"wickets":3,"maidens":0,"econ":"6.00"}],"commentaries":[{"event_id":"12259695","event":"ball","batsman_id":"116162","bowler_id":"107766","over":"4","ball":"3","score":"1wd","commentary":"Christian Charlery to Kensley Paul, 1 wide,","noball_dismissal":false,"text":"","timestamp":1751304711,"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":"12259696","event":"ball","batsman_id":"116162","bowler_id":"107766","over":"4","ball":"3","score":"4b","commentary":"Christian Charlery to Kensley Paul, 4 bye,","noball_dismissal":false,"text":"","timestamp":1751304730,"run":4,"noball_run":"0","wide_run":"0","bye_run":"4","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12259714","event":"ball","batsman_id":"116162","bowler_id":"107766","over":"4","ball":"4","score":1,"commentary":"Christian Charlery to Kensley Paul, 1 run,","noball_dismissal":false,"text":"","timestamp":1751304775,"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":"12259723","event":"ball","batsman_id":"99808","bowler_id":"107766","over":"4","ball":"5","score":4,"commentary":"Christian Charlery to Vernillius Gabriel, Four,","noball_dismissal":false,"text":"","timestamp":1751304803,"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":"12259738","event":"ball","batsman_id":"99808","bowler_id":"107766","over":"4","ball":"6","score":0,"commentary":"Christian Charlery to Vernillius Gabriel, no run,","noball_dismissal":false,"text":"","timestamp":1751304863,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":5,"runs":11,"score":"65\/2","bats":[{"runs":6,"balls_faced":5,"fours":1,"sixes":0,"batsman_id":99808},{"runs":9,"balls_faced":9,"fours":0,"sixes":1,"batsman_id":116162}],"bowls":[{"runs_conceded":7,"maidens":0,"wickets":0,"bowler_id":107766,"overs":1},{"runs_conceded":8,"maidens":0,"wickets":0,"bowler_id":99744,"overs":1}],"commentary":"End of over 5 (11 runs), Iyanola Heritage 65\/2"},{"event_id":"12259773","event":"ball","batsman_id":"116162","bowler_id":"150060","over":"5","ball":"1","score":4,"commentary":"Yunieski Gustave to Kensley Paul, Four,","noball_dismissal":false,"text":"","timestamp":1751304927,"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":"12259783","event":"wicket","batsman_id":"116162","bowler_id":"150060","over":"5","ball":"2","score":"w","commentary":"Yunieski Gustave to Kensley Paul, no run, c & b YK Gustave,","noball_dismissal":false,"text":"","timestamp":1751304966,"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":"116162","how_out":"c & b YK Gustave","batsman_runs":"13","batsman_balls":"11"},{"event_id":"12259839","event":"ball","batsman_id":"92689","bowler_id":"150060","over":"5","ball":"3","score":0,"commentary":"Yunieski Gustave to Xavier Gabriel, no run,","noball_dismissal":false,"text":"","timestamp":1751305103,"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":"12259844","event":"wicket","batsman_id":"92689","bowler_id":"150060","over":"5","ball":"4","score":"w","commentary":"Yunieski Gustave to Xavier Gabriel, no run, c J Sylvester b YK Gustave,","noball_dismissal":false,"text":"","timestamp":1751305135,"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":"c J Sylvester b YK Gustave","batsman_runs":"0","batsman_balls":"2"},{"event_id":"12259877","event":"ball","batsman_id":"99793","bowler_id":"150060","over":"5","ball":"5","score":1,"commentary":"Yunieski Gustave to Jamaal James, 1 run,","noball_dismissal":false,"text":"","timestamp":1751305191,"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":"12259882","event":"ball","batsman_id":"99808","bowler_id":"150060","over":"5","ball":"6","score":0,"commentary":"Yunieski Gustave to Vernillius Gabriel, no run,","noball_dismissal":false,"text":"","timestamp":1751305246,"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":6,"runs":5,"score":"70\/4","bats":[{"runs":6,"balls_faced":6,"fours":1,"sixes":0,"batsman_id":99808},{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":99793}],"bowls":[{"runs_conceded":5,"maidens":0,"wickets":2,"bowler_id":150060,"overs":1},{"runs_conceded":7,"maidens":0,"wickets":0,"bowler_id":107766,"overs":1}],"commentary":"End of over 6 (5 runs), Iyanola Heritage 70\/4"},{"event_id":"12259893","event":"ball","batsman_id":"99793","bowler_id":"107766","over":"6","ball":"1","score":"1wd","commentary":"Christian Charlery to Jamaal James, 1 wide,","noball_dismissal":false,"text":"","timestamp":1751305632,"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":"12259897","event":"ball","batsman_id":"99793","bowler_id":"107766","over":"6","ball":"1","score":1,"commentary":"Christian Charlery to Jamaal James, 1 run,","noball_dismissal":false,"text":"","timestamp":1751305633,"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":"12259898","event":"ball","batsman_id":"99808","bowler_id":"107766","over":"6","ball":"2","score":6,"commentary":"Christian Charlery to Vernillius Gabriel, Six,","noball_dismissal":false,"text":"","timestamp":1751305633,"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":"12259906","event":"ball","batsman_id":"99808","bowler_id":"107766","over":"6","ball":"3","score":0,"commentary":"Christian Charlery to Vernillius Gabriel, no run,","noball_dismissal":false,"text":"","timestamp":1751305634,"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":"12259908","event":"ball","batsman_id":"99808","bowler_id":"107766","over":"6","ball":"4","score":1,"commentary":"Christian Charlery to Vernillius Gabriel, 1 run,","noball_dismissal":false,"text":"","timestamp":1751305635,"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":"12259914","event":"ball","batsman_id":"99793","bowler_id":"107766","over":"6","ball":"5","score":0,"commentary":"Christian Charlery to Jamaal James, no run,","noball_dismissal":false,"text":"","timestamp":1751305636,"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":"12259915","event":"ball","batsman_id":"99793","bowler_id":"107766","over":"6","ball":"6","score":1,"commentary":"Christian Charlery to Jamaal James, 1 run,","noball_dismissal":false,"text":"","timestamp":1751305637,"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":7,"runs":10,"score":"80\/4","bats":[{"runs":3,"balls_faced":4,"fours":0,"sixes":0,"batsman_id":99793},{"runs":13,"balls_faced":9,"fours":1,"sixes":1,"batsman_id":99808}],"bowls":[{"runs_conceded":17,"maidens":0,"wickets":0,"bowler_id":107766,"overs":2},{"runs_conceded":5,"maidens":0,"wickets":2,"bowler_id":150060,"overs":1}],"commentary":"End of over 7 (10 runs), Iyanola Heritage 80\/4"},{"event_id":"12259930","event":"ball","batsman_id":"99793","bowler_id":"150060","over":"7","ball":"1","score":0,"commentary":"Yunieski Gustave to Jamaal James, no run,","noball_dismissal":false,"text":"","timestamp":1751305740,"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":"12259931","event":"ball","batsman_id":"99793","bowler_id":"150060","over":"7","ball":"2","score":1,"commentary":"Yunieski Gustave to Jamaal James, 1 run,","noball_dismissal":false,"text":"","timestamp":1751305741,"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":"12259932","event":"wicket","batsman_id":"99808","bowler_id":"150060","over":"7","ball":"3","score":"w","commentary":"Yunieski Gustave to Vernillius Gabriel, no run, c V Smith b YK Gustave,","noball_dismissal":false,"text":"","timestamp":1751305761,"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":"99808","how_out":"c V Smith b YK Gustave","batsman_runs":"13","batsman_balls":"10"},{"event_id":"12259936","event":"ball","batsman_id":"107726","bowler_id":"150060","over":"7","ball":"4","score":4,"commentary":"Yunieski Gustave to Dwight Thomas, Four,","noball_dismissal":false,"text":"","timestamp":1751305787,"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":"12259939","event":"ball","batsman_id":"107726","bowler_id":"150060","over":"7","ball":"5","score":1,"commentary":"Yunieski Gustave to Dwight Thomas, 1 run,","noball_dismissal":false,"text":"","timestamp":1751305789,"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":"12259944","event":"ball","batsman_id":"99793","bowler_id":"150060","over":"7","ball":"6","score":1,"commentary":"Yunieski Gustave to Jamaal James, 1 run,","noball_dismissal":false,"text":"","timestamp":1751305820,"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":8,"runs":7,"score":"87\/5","bats":[{"runs":5,"balls_faced":7,"fours":0,"sixes":0,"batsman_id":99793},{"runs":5,"balls_faced":2,"fours":1,"sixes":0,"batsman_id":107726}],"bowls":[{"runs_conceded":12,"maidens":0,"wickets":3,"bowler_id":150060,"overs":2},{"runs_conceded":17,"maidens":0,"wickets":0,"bowler_id":107766,"overs":2}],"commentary":"End of over 8 (7 runs), Iyanola Heritage 87\/5"},{"event_id":"12259951","event":"ball","batsman_id":"99793","bowler_id":"99762","over":"8","ball":"1","score":0,"commentary":"Keon Gaston to Jamaal James, no run,","noball_dismissal":false,"text":"","timestamp":1751305905,"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":"12259955","event":"ball","batsman_id":"99793","bowler_id":"99762","over":"8","ball":"2","score":"4b","commentary":"Keon Gaston to Jamaal James, 4 bye,","noball_dismissal":false,"text":"","timestamp":1751305953,"run":4,"noball_run":"0","wide_run":"0","bye_run":"4","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12259958","event":"ball","batsman_id":"99793","bowler_id":"99762","over":"8","ball":"3","score":4,"commentary":"Keon Gaston to Jamaal James, Four,","noball_dismissal":false,"text":"","timestamp":1751305981,"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":198966,"number":2,"name":"Iyanola Heritage Inning","short_name":"IYH Inning","status":2,"issuperover":"false","result":3,"batting_team_id":129001,"fielding_team_id":129003,"scores":"95\/5","scores_full":"95\/5 (8.3 ov)","fielder":[{"fielder_id":"150060","fielder_name":"Yunieski Gustave","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"99723","fielder_name":"Vince Smith","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"99734","fielder_name":"Julian Sylvester","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":"Vernillius Gabriel","batsman_id":"99808","runs":"13","balls":"10","how_out":"c V Smith b YK Gustave","score_at_dismissal":81,"overs_at_dismissal":"7.3","bowler_id":"150060","dismissal":"caught","number":5},"extra_runs":{"byes":8,"legbyes":4,"wides":2,"noballs":2,"penalty":"0","total":16},"equations":{"runs":95,"wickets":5,"overs":"8.3","bowlers_used":6,"runrate":"11.18"},"current_partnership":{"runs":14,"balls":6,"overs":1,"batsmen":[{"name":"Dwight Thomas","batsman_id":107726,"runs":5,"balls":2},{"name":"Jamaal James","batsman_id":99793,"runs":5,"balls":4}]},"did_not_bat":[{"player_id":"138224","name":"Dominic Auguste"},{"player_id":"107772","name":"Jamal Lesmond"},{"player_id":"100052","name":"Aaron Joseph"},{"player_id":"107727","name":"Ephron Charles"}],"max_over":"10","target":"93","recent_scores":"4,4,0,1,1,4,w,1,0,1,0,1,0,6,1,1,0,1","last_five_overs":"42\/3 7.88","last_ten_overs":"95\/5 10.36"},"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":"95\/5 (8.3 ov)","scores":"95\/5","overs":"8.3"},{"tid":129003,"title":"Piton Stickers","abbr":"PTS","alt_name":"Piton Stickers","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Piton-Stickers.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Piton-Stickers.png","country":"wi","sex":"male","team_owner":"","head_coach":"","scores_full":"92\/6 (10 ov)","scores":"92\/6","overs":"10"}],"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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/realjcharles\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(C)"},{"pid":53757,"title":"Craig Emmanuel","short_name":"CW Emmanuel","first_name":"Craig Emmanuel","last_name":"","middle_name":"","birthdate":"1985-09-09","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":99721,"title":"Jason Simon","short_name":"J Simon","first_name":"Jason Simon","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(WK)"},{"pid":99723,"title":"Vince Smith","short_name":"V Smith","first_name":"Vince Smith","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":99733,"title":"Sky Laffeuille","short_name":"S Laffeuille","first_name":"Sky Laffeuille","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":99734,"title":"Julian Sylvester","short_name":"J Sylvester","first_name":"Julian Sylvester","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":""},{"pid":99736,"title":"Xytus Emmanuel","short_name":"X Emmanuel","first_name":"Xytus Emmanuel","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":99738,"title":"Shani Mesmain","short_name":"S Mesmain","first_name":"Shani Mesmain","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":99744,"title":"Sanjay Pamphile","short_name":"S Pamphile","first_name":"Sanjay Pamphile","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":99762,"title":"Keon Gaston","short_name":"K Gaston","first_name":"Keon Gaston","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":"(C)"},{"pid":99788,"title":"Ackeem Auguste","short_name":"A Auguste","first_name":"Ackeem Auguste","last_name":"","middle_name":"","birthdate":"2003-09-12","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"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":8,"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":"wk","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":"wk","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":8.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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":107672,"title":"Tarrique Edward","short_name":"T Edward","first_name":"Tarrique Edward","last_name":"","middle_name":"","birthdate":"2004-10-17","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":107676,"title":"Kuston Jules","short_name":"K Jules","first_name":"Kuston Jules","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"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":6.5,"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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","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":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","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":107766,"title":"Christian Charlery","short_name":"C Charlery","first_name":"Christian Charlery","last_name":"","middle_name":"","birthdate":"","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"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":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":126997,"title":"Cody Fontinelle","short_name":"C Fontinelle","first_name":"Cody Fontinelle","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":128590,"title":"Jermaine thomas","short_name":"J thomas","first_name":"Jermaine thomas","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":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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(WK)"},{"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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":150059,"title":"Jeanille Williams","short_name":"JN Williams","first_name":"Jeanille Williams","last_name":"","middle_name":"","birthdate":"2009-10-04","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":150060,"title":"Yunieski Gustave","short_name":"YK Gustave","first_name":"Yunieski Gustave","last_name":"","middle_name":"","birthdate":"2006-09-20","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":150249,"title":"Nathaniel Joseph","short_name":"N Joseph","first_name":"Nathaniel Joseph","last_name":"","middle_name":"","birthdate":"2009-01-31","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":""}]},"etag":"6c366c3d5847bbf4c578af267bcf6cd9","modified":"2025-07-08 08:21:35","datetime":"2025-07-08 08:21:35","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":90947,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Iyanola Heritage won by 5 wickets","day_remaining_over":"","team_batting":"Iyanola Heritage","team_bowling":"Piton Stickers","live_inning_number":2,"live_score":{"runs":95,"overs":8.3,"wickets":5,"target":93,"runrate":11.18,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Jamaal James","batsman_id":99793,"runs":9,"balls_faced":10,"fours":1,"sixes":0,"strike_rate":"90.00"},{"name":"Dwight Thomas","batsman_id":107726,"runs":5,"balls_faced":2,"fours":1,"sixes":0,"strike_rate":"250.00"}],"bowlers":[{"name":"Keon Gaston","bowler_id":99762,"overs":1.3,"runs_conceded":19,"wickets":0,"maidens":0,"econ":"12.67"},{"name":"Yunieski Gustave","bowler_id":150060,"overs":2,"runs_conceded":12,"wickets":3,"maidens":0,"econ":"6.00"}],"commentaries":[{"event_id":"12259695","event":"ball","batsman_id":"116162","bowler_id":"107766","over":"4","ball":"3","score":"1wd","commentary":"Christian Charlery to Kensley Paul, 1 wide,","noball_dismissal":false,"text":"","timestamp":1751304711,"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":"12259696","event":"ball","batsman_id":"116162","bowler_id":"107766","over":"4","ball":"3","score":"4b","commentary":"Christian Charlery to Kensley Paul, 4 bye,","noball_dismissal":false,"text":"","timestamp":1751304730,"run":4,"noball_run":"0","wide_run":"0","bye_run":"4","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12259714","event":"ball","batsman_id":"116162","bowler_id":"107766","over":"4","ball":"4","score":1,"commentary":"Christian Charlery to Kensley Paul, 1 run,","noball_dismissal":false,"text":"","timestamp":1751304775,"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":"12259723","event":"ball","batsman_id":"99808","bowler_id":"107766","over":"4","ball":"5","score":4,"commentary":"Christian Charlery to Vernillius Gabriel, Four,","noball_dismissal":false,"text":"","timestamp":1751304803,"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":"12259738","event":"ball","batsman_id":"99808","bowler_id":"107766","over":"4","ball":"6","score":0,"commentary":"Christian Charlery to Vernillius Gabriel, no run,","noball_dismissal":false,"text":"","timestamp":1751304863,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":5,"runs":11,"score":"65\/2","bats":[{"runs":6,"balls_faced":5,"fours":1,"sixes":0,"batsman_id":99808},{"runs":9,"balls_faced":9,"fours":0,"sixes":1,"batsman_id":116162}],"bowls":[{"runs_conceded":7,"maidens":0,"wickets":0,"bowler_id":107766,"overs":1},{"runs_conceded":8,"maidens":0,"wickets":0,"bowler_id":99744,"overs":1}],"commentary":"End of over 5 (11 runs), Iyanola Heritage 65\/2"},{"event_id":"12259773","event":"ball","batsman_id":"116162","bowler_id":"150060","over":"5","ball":"1","score":4,"commentary":"Yunieski Gustave to Kensley Paul, Four,","noball_dismissal":false,"text":"","timestamp":1751304927,"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":"12259783","event":"wicket","batsman_id":"116162","bowler_id":"150060","over":"5","ball":"2","score":"w","commentary":"Yunieski Gustave to Kensley Paul, no run, c & b YK Gustave,","noball_dismissal":false,"text":"","timestamp":1751304966,"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":"116162","how_out":"c & b YK Gustave","batsman_runs":"13","batsman_balls":"11"},{"event_id":"12259839","event":"ball","batsman_id":"92689","bowler_id":"150060","over":"5","ball":"3","score":0,"commentary":"Yunieski Gustave to Xavier Gabriel, no run,","noball_dismissal":false,"text":"","timestamp":1751305103,"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":"12259844","event":"wicket","batsman_id":"92689","bowler_id":"150060","over":"5","ball":"4","score":"w","commentary":"Yunieski Gustave to Xavier Gabriel, no run, c J Sylvester b YK Gustave,","noball_dismissal":false,"text":"","timestamp":1751305135,"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":"c J Sylvester b YK Gustave","batsman_runs":"0","batsman_balls":"2"},{"event_id":"12259877","event":"ball","batsman_id":"99793","bowler_id":"150060","over":"5","ball":"5","score":1,"commentary":"Yunieski Gustave to Jamaal James, 1 run,","noball_dismissal":false,"text":"","timestamp":1751305191,"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":"12259882","event":"ball","batsman_id":"99808","bowler_id":"150060","over":"5","ball":"6","score":0,"commentary":"Yunieski Gustave to Vernillius Gabriel, no run,","noball_dismissal":false,"text":"","timestamp":1751305246,"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":6,"runs":5,"score":"70\/4","bats":[{"runs":6,"balls_faced":6,"fours":1,"sixes":0,"batsman_id":99808},{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":99793}],"bowls":[{"runs_conceded":5,"maidens":0,"wickets":2,"bowler_id":150060,"overs":1},{"runs_conceded":7,"maidens":0,"wickets":0,"bowler_id":107766,"overs":1}],"commentary":"End of over 6 (5 runs), Iyanola Heritage 70\/4"},{"event_id":"12259893","event":"ball","batsman_id":"99793","bowler_id":"107766","over":"6","ball":"1","score":"1wd","commentary":"Christian Charlery to Jamaal James, 1 wide,","noball_dismissal":false,"text":"","timestamp":1751305632,"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":"12259897","event":"ball","batsman_id":"99793","bowler_id":"107766","over":"6","ball":"1","score":1,"commentary":"Christian Charlery to Jamaal James, 1 run,","noball_dismissal":false,"text":"","timestamp":1751305633,"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":"12259898","event":"ball","batsman_id":"99808","bowler_id":"107766","over":"6","ball":"2","score":6,"commentary":"Christian Charlery to Vernillius Gabriel, Six,","noball_dismissal":false,"text":"","timestamp":1751305633,"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":"12259906","event":"ball","batsman_id":"99808","bowler_id":"107766","over":"6","ball":"3","score":0,"commentary":"Christian Charlery to Vernillius Gabriel, no run,","noball_dismissal":false,"text":"","timestamp":1751305634,"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":"12259908","event":"ball","batsman_id":"99808","bowler_id":"107766","over":"6","ball":"4","score":1,"commentary":"Christian Charlery to Vernillius Gabriel, 1 run,","noball_dismissal":false,"text":"","timestamp":1751305635,"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":"12259914","event":"ball","batsman_id":"99793","bowler_id":"107766","over":"6","ball":"5","score":0,"commentary":"Christian Charlery to Jamaal James, no run,","noball_dismissal":false,"text":"","timestamp":1751305636,"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":"12259915","event":"ball","batsman_id":"99793","bowler_id":"107766","over":"6","ball":"6","score":1,"commentary":"Christian Charlery to Jamaal James, 1 run,","noball_dismissal":false,"text":"","timestamp":1751305637,"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":7,"runs":10,"score":"80\/4","bats":[{"runs":3,"balls_faced":4,"fours":0,"sixes":0,"batsman_id":99793},{"runs":13,"balls_faced":9,"fours":1,"sixes":1,"batsman_id":99808}],"bowls":[{"runs_conceded":17,"maidens":0,"wickets":0,"bowler_id":107766,"overs":2},{"runs_conceded":5,"maidens":0,"wickets":2,"bowler_id":150060,"overs":1}],"commentary":"End of over 7 (10 runs), Iyanola Heritage 80\/4"},{"event_id":"12259930","event":"ball","batsman_id":"99793","bowler_id":"150060","over":"7","ball":"1","score":0,"commentary":"Yunieski Gustave to Jamaal James, no run,","noball_dismissal":false,"text":"","timestamp":1751305740,"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":"12259931","event":"ball","batsman_id":"99793","bowler_id":"150060","over":"7","ball":"2","score":1,"commentary":"Yunieski Gustave to Jamaal James, 1 run,","noball_dismissal":false,"text":"","timestamp":1751305741,"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":"12259932","event":"wicket","batsman_id":"99808","bowler_id":"150060","over":"7","ball":"3","score":"w","commentary":"Yunieski Gustave to Vernillius Gabriel, no run, c V Smith b YK Gustave,","noball_dismissal":false,"text":"","timestamp":1751305761,"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":"99808","how_out":"c V Smith b YK Gustave","batsman_runs":"13","batsman_balls":"10"},{"event_id":"12259936","event":"ball","batsman_id":"107726","bowler_id":"150060","over":"7","ball":"4","score":4,"commentary":"Yunieski Gustave to Dwight Thomas, Four,","noball_dismissal":false,"text":"","timestamp":1751305787,"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":"12259939","event":"ball","batsman_id":"107726","bowler_id":"150060","over":"7","ball":"5","score":1,"commentary":"Yunieski Gustave to Dwight Thomas, 1 run,","noball_dismissal":false,"text":"","timestamp":1751305789,"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":"12259944","event":"ball","batsman_id":"99793","bowler_id":"150060","over":"7","ball":"6","score":1,"commentary":"Yunieski Gustave to Jamaal James, 1 run,","noball_dismissal":false,"text":"","timestamp":1751305820,"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":8,"runs":7,"score":"87\/5","bats":[{"runs":5,"balls_faced":7,"fours":0,"sixes":0,"batsman_id":99793},{"runs":5,"balls_faced":2,"fours":1,"sixes":0,"batsman_id":107726}],"bowls":[{"runs_conceded":12,"maidens":0,"wickets":3,"bowler_id":150060,"overs":2},{"runs_conceded":17,"maidens":0,"wickets":0,"bowler_id":107766,"overs":2}],"commentary":"End of over 8 (7 runs), Iyanola Heritage 87\/5"},{"event_id":"12259951","event":"ball","batsman_id":"99793","bowler_id":"99762","over":"8","ball":"1","score":0,"commentary":"Keon Gaston to Jamaal James, no run,","noball_dismissal":false,"text":"","timestamp":1751305905,"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":"12259955","event":"ball","batsman_id":"99793","bowler_id":"99762","over":"8","ball":"2","score":"4b","commentary":"Keon Gaston to Jamaal James, 4 bye,","noball_dismissal":false,"text":"","timestamp":1751305953,"run":4,"noball_run":"0","wide_run":"0","bye_run":"4","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12259958","event":"ball","batsman_id":"99793","bowler_id":"99762","over":"8","ball":"3","score":4,"commentary":"Keon Gaston to Jamaal James, Four,","noball_dismissal":false,"text":"","timestamp":1751305981,"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":198966,"number":2,"name":"Iyanola Heritage Inning","short_name":"IYH Inning","status":2,"issuperover":"false","result":3,"batting_team_id":129001,"fielding_team_id":129003,"scores":"95\/5","scores_full":"95\/5 (8.3 ov)","fielder":[{"fielder_id":"150060","fielder_name":"Yunieski Gustave","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"99723","fielder_name":"Vince Smith","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"99734","fielder_name":"Julian Sylvester","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":"Vernillius Gabriel","batsman_id":"99808","runs":"13","balls":"10","how_out":"c V Smith b YK Gustave","score_at_dismissal":81,"overs_at_dismissal":"7.3","bowler_id":"150060","dismissal":"caught","number":5},"extra_runs":{"byes":8,"legbyes":4,"wides":2,"noballs":2,"penalty":"0","total":16},"equations":{"runs":95,"wickets":5,"overs":"8.3","bowlers_used":6,"runrate":"11.18"},"current_partnership":{"runs":14,"balls":6,"overs":1,"batsmen":[{"name":"Dwight Thomas","batsman_id":107726,"runs":5,"balls":2},{"name":"Jamaal James","batsman_id":99793,"runs":5,"balls":4}]},"did_not_bat":[{"player_id":"138224","name":"Dominic Auguste"},{"player_id":"107772","name":"Jamal Lesmond"},{"player_id":"100052","name":"Aaron Joseph"},{"player_id":"107727","name":"Ephron Charles"}],"max_over":"10","target":"93","recent_scores":"4,4,0,1,1,4,w,1,0,1,0,1,0,6,1,1,0,1","last_five_overs":"42\/3 7.88","last_ten_overs":"95\/5 10.36"},"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":"95\/5 (8.3 ov)","scores":"95\/5","overs":"8.3"},{"tid":129003,"title":"Piton Stickers","abbr":"PTS","alt_name":"Piton Stickers","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Piton-Stickers.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Piton-Stickers.png","country":"wi","sex":"male","team_owner":"","head_coach":"","scores_full":"92\/6 (10 ov)","scores":"92\/6","overs":"10"}],"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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/realjcharles\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(C)"},{"pid":53757,"title":"Craig Emmanuel","short_name":"CW Emmanuel","first_name":"Craig Emmanuel","last_name":"","middle_name":"","birthdate":"1985-09-09","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":99721,"title":"Jason Simon","short_name":"J Simon","first_name":"Jason Simon","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(WK)"},{"pid":99723,"title":"Vince Smith","short_name":"V Smith","first_name":"Vince Smith","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":99733,"title":"Sky Laffeuille","short_name":"S Laffeuille","first_name":"Sky Laffeuille","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":99734,"title":"Julian Sylvester","short_name":"J Sylvester","first_name":"Julian Sylvester","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":""},{"pid":99736,"title":"Xytus Emmanuel","short_name":"X Emmanuel","first_name":"Xytus Emmanuel","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":99738,"title":"Shani Mesmain","short_name":"S Mesmain","first_name":"Shani Mesmain","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":99744,"title":"Sanjay Pamphile","short_name":"S Pamphile","first_name":"Sanjay Pamphile","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":99762,"title":"Keon Gaston","short_name":"K Gaston","first_name":"Keon Gaston","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":"(C)"},{"pid":99788,"title":"Ackeem Auguste","short_name":"A Auguste","first_name":"Ackeem Auguste","last_name":"","middle_name":"","birthdate":"2003-09-12","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"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":8,"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":"wk","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":"wk","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":8.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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":107672,"title":"Tarrique Edward","short_name":"T Edward","first_name":"Tarrique Edward","last_name":"","middle_name":"","birthdate":"2004-10-17","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":107676,"title":"Kuston Jules","short_name":"K Jules","first_name":"Kuston Jules","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"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":6.5,"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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","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":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","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":107766,"title":"Christian Charlery","short_name":"C Charlery","first_name":"Christian Charlery","last_name":"","middle_name":"","birthdate":"","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"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":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":126997,"title":"Cody Fontinelle","short_name":"C Fontinelle","first_name":"Cody Fontinelle","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":128590,"title":"Jermaine thomas","short_name":"J thomas","first_name":"Jermaine thomas","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":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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(WK)"},{"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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":150059,"title":"Jeanille Williams","short_name":"JN Williams","first_name":"Jeanille Williams","last_name":"","middle_name":"","birthdate":"2009-10-04","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":150060,"title":"Yunieski Gustave","short_name":"YK Gustave","first_name":"Yunieski Gustave","last_name":"","middle_name":"","birthdate":"2006-09-20","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":150249,"title":"Nathaniel Joseph","short_name":"N Joseph","first_name":"Nathaniel Joseph","last_name":"","middle_name":"","birthdate":"2009-01-31","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":""}]},"etag":"6c366c3d5847bbf4c578af267bcf6cd9","modified":"2025-07-08 08:21:35","datetime":"2025-07-08 08:21:35","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90947 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:ac059b98-c5b2-444a-b30a-85ecd7e3030c
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90947 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90947,3,'{"status":"ok","response":{"match_id":90947,"title":"Iyanola Heritage vs Piton Stickers","short_title":"IYH vs PTS","subtitle":"Match 13","match_number":"13","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Iyanola Heritage won by 5 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129646,"title":"St. Lucia T10 Blast","abbr":"Lucia T10","type":"tournament","category":"domestic","match_format":"t10","season":"2025","status":"live","datestart":"2025-06-24","dateend":"2025-07-08","country":"na","total_matches":"30","total_rounds":"1","total_teams":"6"},"teama":{"team_id":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":"95\/5 (8.3 ov)","scores":"95\/5","overs":"8.3"},"teamb":{"team_id":129003,"name":"Piton Stickers","short_name":"PTS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Piton-Stickers.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Piton-Stickers.png","scores_full":"92\/6 (10 ov)","scores":"92\/6","overs":"10"},"date_start":"2025-06-30 16:00:00","date_end":"2025-07-01 02:00:00","timestamp_start":1751299200,"timestamp_end":1751335200,"date_start_ist":"2025-06-30 21:30:00","date_end_ist":"2025-07-01 07:30: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":"IYH won by 5 wickets","result_type":1,"win_margin":"5 wickets","winning_team_id":129001,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-28 22:57:50","verify_time":"2025-06-30 23:40:58","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"scattered clouds","temp":28.09,"humidity":69,"visibility":10000,"wind_speed":"17.16","clouds":40},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Iyanola Heritage elected to bowl","winner":129001,"decision":2}},"etag":"25d3e2ffbad079663ee37ba9ec48a22a","modified":"2025-07-08 08:21:36","datetime":"2025-07-08 08:21:36","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90947,"title":"Iyanola Heritage vs Piton Stickers","short_title":"IYH vs PTS","subtitle":"Match 13","match_number":"13","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Iyanola Heritage won by 5 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129646,"title":"St. Lucia T10 Blast","abbr":"Lucia T10","type":"tournament","category":"domestic","match_format":"t10","season":"2025","status":"live","datestart":"2025-06-24","dateend":"2025-07-08","country":"na","total_matches":"30","total_rounds":"1","total_teams":"6"},"teama":{"team_id":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":"95\/5 (8.3 ov)","scores":"95\/5","overs":"8.3"},"teamb":{"team_id":129003,"name":"Piton Stickers","short_name":"PTS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Piton-Stickers.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Piton-Stickers.png","scores_full":"92\/6 (10 ov)","scores":"92\/6","overs":"10"},"date_start":"2025-06-30 16:00:00","date_end":"2025-07-01 02:00:00","timestamp_start":1751299200,"timestamp_end":1751335200,"date_start_ist":"2025-06-30 21:30:00","date_end_ist":"2025-07-01 07:30: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":"IYH won by 5 wickets","result_type":1,"win_margin":"5 wickets","winning_team_id":129001,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-28 22:57:50","verify_time":"2025-06-30 23:40:58","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"scattered clouds","temp":28.09,"humidity":69,"visibility":10000,"wind_speed":"17.16","clouds":40},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Iyanola Heritage elected to bowl","winner":129001,"decision":2}},"etag":"25d3e2ffbad079663ee37ba9ec48a22a","modified":"2025-07-08 08:21:36","datetime":"2025-07-08 08:21:36","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90947 AND DataTypeId = 3 END Live Report & Scorecard of Iyanola Heritage vs Piton Stickers Match 13
Iyanola Heritage vs Piton Stickers, Live Cricket Commentary