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:69e699ff-7dbf-428b-88c9-87a99bf8354d
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90935 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90935,1,'{"status":"ok","response":{"mid":90935,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Iyanola Heritage won by 9 wickets","day_remaining_over":"","team_batting":"Iyanola Heritage","team_bowling":"Amazonian Warriors","live_inning_number":2,"live_score":{"runs":95,"overs":6.5,"wickets":1,"target":92,"runrate":13.9,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Kensley Paul","batsman_id":116162,"runs":13,"balls_faced":6,"fours":1,"sixes":1,"strike_rate":"216.67"},{"name":"Johnson Charles","batsman_id":482,"runs":51,"balls_faced":23,"fours":4,"sixes":5,"strike_rate":"221.74"}],"bowlers":[{"name":"Jaden Elibox","bowler_id":99795,"overs":1.5,"runs_conceded":28,"wickets":0,"maidens":0,"econ":"15.27"},{"name":"Kester Charlermagne","bowler_id":100050,"overs":1,"runs_conceded":9,"wickets":0,"maidens":0,"econ":"9.00"}],"commentaries":[{"event_id":"12218647","event":"ball","batsman_id":"482","bowler_id":"99779","over":"2","ball":"5","score":6,"commentary":"Antoine Zayee to Johnson Charles, Six,","noball_dismissal":false,"text":"","timestamp":1750785670,"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":"12218661","event":"ball","batsman_id":"482","bowler_id":"99779","over":"2","ball":"6","score":6,"commentary":"Antoine Zayee to Johnson Charles, Six,","noball_dismissal":false,"text":"","timestamp":1750785678,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event":"overend","over":3,"runs":20,"score":"40\/0","bats":[{"runs":29,"balls_faced":11,"fours":4,"sixes":2,"batsman_id":482},{"runs":10,"balls_faced":7,"fours":1,"sixes":1,"batsman_id":99793}],"bowls":[{"runs_conceded":20,"maidens":0,"wickets":0,"bowler_id":99779,"overs":1},{"runs_conceded":10,"maidens":0,"wickets":0,"bowler_id":107750,"overs":1}],"commentary":"End of over 3 (20 runs), Iyanola Heritage 40\/0"},{"event_id":"12218680","event":"ball","batsman_id":"99793","bowler_id":"107750","over":"3","ball":"1","score":6,"commentary":"Royce Paul to Jamaal James, Six,","noball_dismissal":false,"text":"","timestamp":1750785776,"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":"12218685","event":"ball","batsman_id":"99793","bowler_id":"107750","over":"3","ball":"2","score":4,"commentary":"Royce Paul to Jamaal James, Four,","noball_dismissal":false,"text":"","timestamp":1750785809,"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":"12218698","event":"ball","batsman_id":"99793","bowler_id":"107750","over":"3","ball":"3","score":0,"commentary":"Royce Paul to Jamaal James, no run,","noball_dismissal":false,"text":"","timestamp":1750785853,"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":"12218704","event":"ball","batsman_id":"99793","bowler_id":"107750","over":"3","ball":"4","score":6,"commentary":"Royce Paul to Jamaal James, Six,","noball_dismissal":false,"text":"","timestamp":1750785895,"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":"12218715","event":"wicket","batsman_id":"99793","bowler_id":"107750","over":"3","ball":"5","score":"w","commentary":"Royce Paul to Jamaal James, no run, c D Edward b R Paul,","noball_dismissal":false,"text":"","timestamp":1750785945,"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":"99793","how_out":"c D Edward b R Paul","batsman_runs":"26","batsman_balls":"12"},{"event_id":"12218721","event":"ball","batsman_id":"116162","bowler_id":"107750","over":"3","ball":"6","score":0,"commentary":"Royce Paul to Kensley Paul, no run,","noball_dismissal":false,"text":"","timestamp":1750785984,"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":4,"runs":16,"score":"56\/1","bats":[{"runs":0,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":116162},{"runs":29,"balls_faced":11,"fours":4,"sixes":2,"batsman_id":482}],"bowls":[{"runs_conceded":26,"maidens":0,"wickets":1,"bowler_id":107750,"overs":2},{"runs_conceded":20,"maidens":0,"wickets":0,"bowler_id":99779,"overs":1}],"commentary":"End of over 4 (16 runs), Iyanola Heritage 56\/1"},{"event_id":"12218734","event":"ball","batsman_id":"482","bowler_id":"99795","over":"4","ball":"1","score":6,"commentary":"Jaden Elibox to Johnson Charles, Six,","noball_dismissal":false,"text":"","timestamp":1750786079,"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":"12218755","event":"ball","batsman_id":"482","bowler_id":"99795","over":"4","ball":"2","score":6,"commentary":"Jaden Elibox to Johnson Charles, Six,","noball_dismissal":false,"text":"","timestamp":1750786166,"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":"12218765","event":"ball","batsman_id":"482","bowler_id":"99795","over":"4","ball":"3","score":"1wd","commentary":"Jaden Elibox to Johnson Charles, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750786218,"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":"12218768","event":"ball","batsman_id":"482","bowler_id":"99795","over":"4","ball":"3","score":0,"commentary":"Jaden Elibox to Johnson Charles, no run,","noball_dismissal":false,"text":"","timestamp":1750786245,"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":"12218774","event":"ball","batsman_id":"482","bowler_id":"99795","over":"4","ball":"4","score":"1b","commentary":"Jaden Elibox to Johnson Charles, 1 bye,","noball_dismissal":false,"text":"","timestamp":1750786260,"run":1,"noball_run":"0","wide_run":"0","bye_run":"1","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12218787","event":"ball","batsman_id":"116162","bowler_id":"99795","over":"4","ball":"5","score":1,"commentary":"Jaden Elibox to Kensley Paul, 1 run,","noball_dismissal":false,"text":"","timestamp":1750786334,"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":"12218790","event":"ball","batsman_id":"482","bowler_id":"99795","over":"4","ball":"6","score":"1lb","commentary":"Jaden Elibox to Johnson Charles, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1750786982,"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":"overend","over":5,"runs":16,"score":"72\/1","bats":[{"runs":41,"balls_faced":16,"fours":4,"sixes":4,"batsman_id":482},{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":116162}],"bowls":[{"runs_conceded":14,"maidens":0,"wickets":0,"bowler_id":99795,"overs":1},{"runs_conceded":26,"maidens":0,"wickets":1,"bowler_id":107750,"overs":2}],"commentary":"End of over 5 (16 runs), Iyanola Heritage 72\/1"},{"event_id":"12218816","event":"ball","batsman_id":"482","bowler_id":"100050","over":"5","ball":"1","score":1,"commentary":"Kester Charlermagne to Johnson Charles, 1 run,","noball_dismissal":false,"text":"","timestamp":1750786399,"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":"12218825","event":"ball","batsman_id":"116162","bowler_id":"100050","over":"5","ball":"2","score":1,"commentary":"Kester Charlermagne to Kensley Paul, 1 run,","noball_dismissal":false,"text":"","timestamp":1750786451,"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":"12218828","event":"ball","batsman_id":"482","bowler_id":"100050","over":"5","ball":"3","score":0,"commentary":"Kester Charlermagne to Johnson Charles, no run,","noball_dismissal":false,"text":"","timestamp":1750786473,"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":"12218837","event":"ball","batsman_id":"482","bowler_id":"100050","over":"5","ball":"4","score":0,"commentary":"Kester Charlermagne to Johnson Charles, no run,","noball_dismissal":false,"text":"","timestamp":1750786520,"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":"12218838","event":"ball","batsman_id":"482","bowler_id":"100050","over":"5","ball":"5","score":6,"commentary":"Kester Charlermagne to Johnson Charles, Six,","noball_dismissal":false,"text":"","timestamp":1750786542,"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":"12218850","event":"ball","batsman_id":"482","bowler_id":"100050","over":"5","ball":"6","score":1,"commentary":"Kester Charlermagne to Johnson Charles, 1 run,","noball_dismissal":false,"text":"","timestamp":1750786580,"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":9,"score":"81\/1","bats":[{"runs":49,"balls_faced":21,"fours":4,"sixes":5,"batsman_id":482},{"runs":2,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":116162}],"bowls":[{"runs_conceded":9,"maidens":0,"wickets":0,"bowler_id":100050,"overs":1},{"runs_conceded":14,"maidens":0,"wickets":0,"bowler_id":99795,"overs":1}],"commentary":"End of over 6 (9 runs), Iyanola Heritage 81\/1"},{"event_id":"12218859","event":"ball","batsman_id":"482","bowler_id":"99795","over":"6","ball":"1","score":1,"commentary":"Jaden Elibox to Johnson Charles, 1 run,","noball_dismissal":false,"text":"","timestamp":1750786648,"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":"12218864","event":"ball","batsman_id":"116162","bowler_id":"99795","over":"6","ball":"2","score":1,"commentary":"Jaden Elibox to Kensley Paul, 1 run,","noball_dismissal":false,"text":"","timestamp":1750786682,"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":"12218867","event":"ball","batsman_id":"482","bowler_id":"99795","over":"6","ball":"3","score":"1wd","commentary":"Jaden Elibox to Johnson Charles, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750786745,"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":"12218871","event":"ball","batsman_id":"482","bowler_id":"99795","over":"6","ball":"3","score":1,"commentary":"Jaden Elibox to Johnson Charles, 1 run,","noball_dismissal":false,"text":"","timestamp":1750786747,"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":"12218875","event":"ball","batsman_id":"116162","bowler_id":"99795","over":"6","ball":"4","score":6,"commentary":"Jaden Elibox to Kensley Paul, Six,","noball_dismissal":false,"text":"","timestamp":1750786769,"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":"12218893","event":"ball","batsman_id":"116162","bowler_id":"99795","over":"6","ball":"5","score":4,"commentary":"Jaden Elibox to Kensley Paul, Four,","noball_dismissal":false,"text":"","timestamp":1750786870,"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":198686,"number":2,"name":"Iyanola Heritage Inning","short_name":"IYH Inning","status":2,"issuperover":"false","result":3,"batting_team_id":129001,"fielding_team_id":129002,"scores":"95\/1","scores_full":"95\/1 (6.5 ov)","fielder":[{"fielder_id":"99805","fielder_name":"Dane Edward","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"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":"Jamaal James","batsman_id":"99793","runs":"26","balls":"12","how_out":"c D Edward b R Paul","score_at_dismissal":56,"overs_at_dismissal":"3.5","bowler_id":"107750","dismissal":"caught","number":1},"extra_runs":{"byes":2,"legbyes":1,"wides":2,"noballs":0,"penalty":"0","total":5},"equations":{"runs":95,"wickets":1,"overs":"6.5","bowlers_used":5,"runrate":"13.90"},"current_partnership":{"runs":39,"balls":18,"overs":3,"batsmen":[{"name":"Kensley Paul","batsman_id":116162,"runs":13,"balls":6},{"name":"Johnson Charles","batsman_id":482,"runs":22,"balls":12}]},"did_not_bat":[{"player_id":"138224","name":"Dominic Auguste"},{"player_id":"99808","name":"Vernillius Gabriel"},{"player_id":"107726","name":"Dwight Thomas"},{"player_id":"100044","name":"Collinus Callendar"},{"player_id":"92689","name":"Xavier Gabriel"},{"player_id":"107772","name":"Jamal Lesmond"},{"player_id":"100052","name":"Aaron Joseph"},{"player_id":"138230","name":"Zinakki Louis"}],"max_over":"10","target":"92","recent_scores":"4,6,1,1,1,1,1,6,0,0,1,1,1,1,1,0,1,6","last_five_overs":"81\/1 15.19","last_ten_overs":"95\/1 13.26"},"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\/1 (6.5 ov)","scores":"95\/1","overs":"6.5"},{"tid":129002,"title":"Amazonian Warriors","abbr":"AMW","alt_name":"Amazonian Warriors","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Amazonian-Warriors.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Amazonian-Warriors.png","country":"wi","sex":"male","team_owner":"","head_coach":"","scores_full":"91\/5 (10 ov)","scores":"91\/5","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/realjcharles\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(C)"},{"pid":52283,"title":"Johnnel Eugene","short_name":"J Eugene","first_name":"Johnnel Eugene","last_name":"","middle_name":"","birthdate":"1999-09-15","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":92688,"title":"Alleyn Prospere","short_name":"A Prospere","first_name":"Alleyn Prospere","last_name":"","middle_name":"","birthdate":"1979-10-10","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":"bowl","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":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":99779,"title":"Antoine Zayee","short_name":"A Zayee","first_name":"Antoine Zayee","last_name":"","middle_name":"","birthdate":"","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":99795,"title":"Jaden Elibox","short_name":"J Elibox","first_name":"Jaden Elibox","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":99805,"title":"Dane Edward","short_name":"D Edward","first_name":"Dane Edward","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","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":"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":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":100050,"title":"Kester Charlermagne","short_name":"K Charlermagne","first_name":"Kester Charlermagne","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":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":"(C)"},{"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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":100065,"title":"Murlan Sammy","short_name":"M Sammy","first_name":"Murlan Sammy","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","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":"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":"","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":107750,"title":"Royce Paul","short_name":"R Paul","first_name":"Royce Paul","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":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":107768,"title":"Rohan Lesmond","short_name":"R Lesmond","first_name":"Rohan Lesmond","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":"","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":116100,"title":"Dexter Solomon","short_name":"D Solomon","first_name":"Dexter Solomon","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":116473,"title":"Joshua Cepal","short_name":"J Cepal","first_name":"Joshua Cepal","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":127130,"title":"Alex Joseph","short_name":"A Joseph","first_name":"Alex Joseph","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":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(WK)"},{"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":"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":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":"(WK)"},{"pid":138228,"title":"Isiah Jones","short_name":"I Jones","first_name":"Isiah Jones","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","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":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":138273,"title":"Renee Jones","short_name":"R Jones","first_name":"Renee Jones","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":138276,"title":"Tyler Venner","short_name":"T Venner","first_name":"Tyler Venner","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":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""}]},"etag":"be0e727d70f78f782f364a7b0ad6f5c8","modified":"2025-07-10 09:18:42","datetime":"2025-07-10 09:18:42","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":90935,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Iyanola Heritage won by 9 wickets","day_remaining_over":"","team_batting":"Iyanola Heritage","team_bowling":"Amazonian Warriors","live_inning_number":2,"live_score":{"runs":95,"overs":6.5,"wickets":1,"target":92,"runrate":13.9,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Kensley Paul","batsman_id":116162,"runs":13,"balls_faced":6,"fours":1,"sixes":1,"strike_rate":"216.67"},{"name":"Johnson Charles","batsman_id":482,"runs":51,"balls_faced":23,"fours":4,"sixes":5,"strike_rate":"221.74"}],"bowlers":[{"name":"Jaden Elibox","bowler_id":99795,"overs":1.5,"runs_conceded":28,"wickets":0,"maidens":0,"econ":"15.27"},{"name":"Kester Charlermagne","bowler_id":100050,"overs":1,"runs_conceded":9,"wickets":0,"maidens":0,"econ":"9.00"}],"commentaries":[{"event_id":"12218647","event":"ball","batsman_id":"482","bowler_id":"99779","over":"2","ball":"5","score":6,"commentary":"Antoine Zayee to Johnson Charles, Six,","noball_dismissal":false,"text":"","timestamp":1750785670,"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":"12218661","event":"ball","batsman_id":"482","bowler_id":"99779","over":"2","ball":"6","score":6,"commentary":"Antoine Zayee to Johnson Charles, Six,","noball_dismissal":false,"text":"","timestamp":1750785678,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event":"overend","over":3,"runs":20,"score":"40\/0","bats":[{"runs":29,"balls_faced":11,"fours":4,"sixes":2,"batsman_id":482},{"runs":10,"balls_faced":7,"fours":1,"sixes":1,"batsman_id":99793}],"bowls":[{"runs_conceded":20,"maidens":0,"wickets":0,"bowler_id":99779,"overs":1},{"runs_conceded":10,"maidens":0,"wickets":0,"bowler_id":107750,"overs":1}],"commentary":"End of over 3 (20 runs), Iyanola Heritage 40\/0"},{"event_id":"12218680","event":"ball","batsman_id":"99793","bowler_id":"107750","over":"3","ball":"1","score":6,"commentary":"Royce Paul to Jamaal James, Six,","noball_dismissal":false,"text":"","timestamp":1750785776,"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":"12218685","event":"ball","batsman_id":"99793","bowler_id":"107750","over":"3","ball":"2","score":4,"commentary":"Royce Paul to Jamaal James, Four,","noball_dismissal":false,"text":"","timestamp":1750785809,"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":"12218698","event":"ball","batsman_id":"99793","bowler_id":"107750","over":"3","ball":"3","score":0,"commentary":"Royce Paul to Jamaal James, no run,","noball_dismissal":false,"text":"","timestamp":1750785853,"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":"12218704","event":"ball","batsman_id":"99793","bowler_id":"107750","over":"3","ball":"4","score":6,"commentary":"Royce Paul to Jamaal James, Six,","noball_dismissal":false,"text":"","timestamp":1750785895,"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":"12218715","event":"wicket","batsman_id":"99793","bowler_id":"107750","over":"3","ball":"5","score":"w","commentary":"Royce Paul to Jamaal James, no run, c D Edward b R Paul,","noball_dismissal":false,"text":"","timestamp":1750785945,"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":"99793","how_out":"c D Edward b R Paul","batsman_runs":"26","batsman_balls":"12"},{"event_id":"12218721","event":"ball","batsman_id":"116162","bowler_id":"107750","over":"3","ball":"6","score":0,"commentary":"Royce Paul to Kensley Paul, no run,","noball_dismissal":false,"text":"","timestamp":1750785984,"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":4,"runs":16,"score":"56\/1","bats":[{"runs":0,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":116162},{"runs":29,"balls_faced":11,"fours":4,"sixes":2,"batsman_id":482}],"bowls":[{"runs_conceded":26,"maidens":0,"wickets":1,"bowler_id":107750,"overs":2},{"runs_conceded":20,"maidens":0,"wickets":0,"bowler_id":99779,"overs":1}],"commentary":"End of over 4 (16 runs), Iyanola Heritage 56\/1"},{"event_id":"12218734","event":"ball","batsman_id":"482","bowler_id":"99795","over":"4","ball":"1","score":6,"commentary":"Jaden Elibox to Johnson Charles, Six,","noball_dismissal":false,"text":"","timestamp":1750786079,"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":"12218755","event":"ball","batsman_id":"482","bowler_id":"99795","over":"4","ball":"2","score":6,"commentary":"Jaden Elibox to Johnson Charles, Six,","noball_dismissal":false,"text":"","timestamp":1750786166,"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":"12218765","event":"ball","batsman_id":"482","bowler_id":"99795","over":"4","ball":"3","score":"1wd","commentary":"Jaden Elibox to Johnson Charles, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750786218,"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":"12218768","event":"ball","batsman_id":"482","bowler_id":"99795","over":"4","ball":"3","score":0,"commentary":"Jaden Elibox to Johnson Charles, no run,","noball_dismissal":false,"text":"","timestamp":1750786245,"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":"12218774","event":"ball","batsman_id":"482","bowler_id":"99795","over":"4","ball":"4","score":"1b","commentary":"Jaden Elibox to Johnson Charles, 1 bye,","noball_dismissal":false,"text":"","timestamp":1750786260,"run":1,"noball_run":"0","wide_run":"0","bye_run":"1","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12218787","event":"ball","batsman_id":"116162","bowler_id":"99795","over":"4","ball":"5","score":1,"commentary":"Jaden Elibox to Kensley Paul, 1 run,","noball_dismissal":false,"text":"","timestamp":1750786334,"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":"12218790","event":"ball","batsman_id":"482","bowler_id":"99795","over":"4","ball":"6","score":"1lb","commentary":"Jaden Elibox to Johnson Charles, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1750786982,"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":"overend","over":5,"runs":16,"score":"72\/1","bats":[{"runs":41,"balls_faced":16,"fours":4,"sixes":4,"batsman_id":482},{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":116162}],"bowls":[{"runs_conceded":14,"maidens":0,"wickets":0,"bowler_id":99795,"overs":1},{"runs_conceded":26,"maidens":0,"wickets":1,"bowler_id":107750,"overs":2}],"commentary":"End of over 5 (16 runs), Iyanola Heritage 72\/1"},{"event_id":"12218816","event":"ball","batsman_id":"482","bowler_id":"100050","over":"5","ball":"1","score":1,"commentary":"Kester Charlermagne to Johnson Charles, 1 run,","noball_dismissal":false,"text":"","timestamp":1750786399,"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":"12218825","event":"ball","batsman_id":"116162","bowler_id":"100050","over":"5","ball":"2","score":1,"commentary":"Kester Charlermagne to Kensley Paul, 1 run,","noball_dismissal":false,"text":"","timestamp":1750786451,"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":"12218828","event":"ball","batsman_id":"482","bowler_id":"100050","over":"5","ball":"3","score":0,"commentary":"Kester Charlermagne to Johnson Charles, no run,","noball_dismissal":false,"text":"","timestamp":1750786473,"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":"12218837","event":"ball","batsman_id":"482","bowler_id":"100050","over":"5","ball":"4","score":0,"commentary":"Kester Charlermagne to Johnson Charles, no run,","noball_dismissal":false,"text":"","timestamp":1750786520,"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":"12218838","event":"ball","batsman_id":"482","bowler_id":"100050","over":"5","ball":"5","score":6,"commentary":"Kester Charlermagne to Johnson Charles, Six,","noball_dismissal":false,"text":"","timestamp":1750786542,"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":"12218850","event":"ball","batsman_id":"482","bowler_id":"100050","over":"5","ball":"6","score":1,"commentary":"Kester Charlermagne to Johnson Charles, 1 run,","noball_dismissal":false,"text":"","timestamp":1750786580,"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":9,"score":"81\/1","bats":[{"runs":49,"balls_faced":21,"fours":4,"sixes":5,"batsman_id":482},{"runs":2,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":116162}],"bowls":[{"runs_conceded":9,"maidens":0,"wickets":0,"bowler_id":100050,"overs":1},{"runs_conceded":14,"maidens":0,"wickets":0,"bowler_id":99795,"overs":1}],"commentary":"End of over 6 (9 runs), Iyanola Heritage 81\/1"},{"event_id":"12218859","event":"ball","batsman_id":"482","bowler_id":"99795","over":"6","ball":"1","score":1,"commentary":"Jaden Elibox to Johnson Charles, 1 run,","noball_dismissal":false,"text":"","timestamp":1750786648,"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":"12218864","event":"ball","batsman_id":"116162","bowler_id":"99795","over":"6","ball":"2","score":1,"commentary":"Jaden Elibox to Kensley Paul, 1 run,","noball_dismissal":false,"text":"","timestamp":1750786682,"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":"12218867","event":"ball","batsman_id":"482","bowler_id":"99795","over":"6","ball":"3","score":"1wd","commentary":"Jaden Elibox to Johnson Charles, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750786745,"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":"12218871","event":"ball","batsman_id":"482","bowler_id":"99795","over":"6","ball":"3","score":1,"commentary":"Jaden Elibox to Johnson Charles, 1 run,","noball_dismissal":false,"text":"","timestamp":1750786747,"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":"12218875","event":"ball","batsman_id":"116162","bowler_id":"99795","over":"6","ball":"4","score":6,"commentary":"Jaden Elibox to Kensley Paul, Six,","noball_dismissal":false,"text":"","timestamp":1750786769,"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":"12218893","event":"ball","batsman_id":"116162","bowler_id":"99795","over":"6","ball":"5","score":4,"commentary":"Jaden Elibox to Kensley Paul, Four,","noball_dismissal":false,"text":"","timestamp":1750786870,"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":198686,"number":2,"name":"Iyanola Heritage Inning","short_name":"IYH Inning","status":2,"issuperover":"false","result":3,"batting_team_id":129001,"fielding_team_id":129002,"scores":"95\/1","scores_full":"95\/1 (6.5 ov)","fielder":[{"fielder_id":"99805","fielder_name":"Dane Edward","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"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":"Jamaal James","batsman_id":"99793","runs":"26","balls":"12","how_out":"c D Edward b R Paul","score_at_dismissal":56,"overs_at_dismissal":"3.5","bowler_id":"107750","dismissal":"caught","number":1},"extra_runs":{"byes":2,"legbyes":1,"wides":2,"noballs":0,"penalty":"0","total":5},"equations":{"runs":95,"wickets":1,"overs":"6.5","bowlers_used":5,"runrate":"13.90"},"current_partnership":{"runs":39,"balls":18,"overs":3,"batsmen":[{"name":"Kensley Paul","batsman_id":116162,"runs":13,"balls":6},{"name":"Johnson Charles","batsman_id":482,"runs":22,"balls":12}]},"did_not_bat":[{"player_id":"138224","name":"Dominic Auguste"},{"player_id":"99808","name":"Vernillius Gabriel"},{"player_id":"107726","name":"Dwight Thomas"},{"player_id":"100044","name":"Collinus Callendar"},{"player_id":"92689","name":"Xavier Gabriel"},{"player_id":"107772","name":"Jamal Lesmond"},{"player_id":"100052","name":"Aaron Joseph"},{"player_id":"138230","name":"Zinakki Louis"}],"max_over":"10","target":"92","recent_scores":"4,6,1,1,1,1,1,6,0,0,1,1,1,1,1,0,1,6","last_five_overs":"81\/1 15.19","last_ten_overs":"95\/1 13.26"},"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\/1 (6.5 ov)","scores":"95\/1","overs":"6.5"},{"tid":129002,"title":"Amazonian Warriors","abbr":"AMW","alt_name":"Amazonian Warriors","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Amazonian-Warriors.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Amazonian-Warriors.png","country":"wi","sex":"male","team_owner":"","head_coach":"","scores_full":"91\/5 (10 ov)","scores":"91\/5","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/realjcharles\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(C)"},{"pid":52283,"title":"Johnnel Eugene","short_name":"J Eugene","first_name":"Johnnel Eugene","last_name":"","middle_name":"","birthdate":"1999-09-15","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":92688,"title":"Alleyn Prospere","short_name":"A Prospere","first_name":"Alleyn Prospere","last_name":"","middle_name":"","birthdate":"1979-10-10","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":"bowl","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":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":99779,"title":"Antoine Zayee","short_name":"A Zayee","first_name":"Antoine Zayee","last_name":"","middle_name":"","birthdate":"","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":99795,"title":"Jaden Elibox","short_name":"J Elibox","first_name":"Jaden Elibox","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":99805,"title":"Dane Edward","short_name":"D Edward","first_name":"Dane Edward","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","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":"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":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":100050,"title":"Kester Charlermagne","short_name":"K Charlermagne","first_name":"Kester Charlermagne","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":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":"(C)"},{"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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":100065,"title":"Murlan Sammy","short_name":"M Sammy","first_name":"Murlan Sammy","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","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":"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":"","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":107750,"title":"Royce Paul","short_name":"R Paul","first_name":"Royce Paul","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":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":107768,"title":"Rohan Lesmond","short_name":"R Lesmond","first_name":"Rohan Lesmond","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":"","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":116100,"title":"Dexter Solomon","short_name":"D Solomon","first_name":"Dexter Solomon","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":116473,"title":"Joshua Cepal","short_name":"J Cepal","first_name":"Joshua Cepal","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":127130,"title":"Alex Joseph","short_name":"A Joseph","first_name":"Alex Joseph","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":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(WK)"},{"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":"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":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":"(WK)"},{"pid":138228,"title":"Isiah Jones","short_name":"I Jones","first_name":"Isiah Jones","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","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":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":138273,"title":"Renee Jones","short_name":"R Jones","first_name":"Renee Jones","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":138276,"title":"Tyler Venner","short_name":"T Venner","first_name":"Tyler Venner","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":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""}]},"etag":"be0e727d70f78f782f364a7b0ad6f5c8","modified":"2025-07-10 09:18:42","datetime":"2025-07-10 09:18:42","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90935 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:69e699ff-7dbf-428b-88c9-87a99bf8354d
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90935 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90935,3,'{"status":"ok","response":{"match_id":90935,"title":"Iyanola Heritage vs Amazonian Warriors","short_title":"IYH vs AMW","subtitle":"Match 1","match_number":"1","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Iyanola Heritage won by 9 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129646,"title":"St. Lucia T10 Blast","abbr":"Lucia T10","type":"tournament","category":"domestic","match_format":"t10","season":"2025","status":"live","datestart":"2025-06-24","dateend":"2025-07-08","country":"na","total_matches":"30","total_rounds":"1","total_teams":"6"},"teama":{"team_id":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\/1 (6.5 ov)","scores":"95\/1","overs":"6.5"},"teamb":{"team_id":129002,"name":"Amazonian Warriors","short_name":"AMW","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Amazonian-Warriors.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Amazonian-Warriors.png","scores_full":"91\/5 (10 ov)","scores":"91\/5","overs":"10"},"date_start":"2025-06-24 16:00:00","date_end":"2025-06-25 02:00:00","timestamp_start":1750780800,"timestamp_end":1750816800,"date_start_ist":"2025-06-24 21:30:00","date_end_ist":"2025-06-25 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 9 wickets","result_type":1,"win_margin":"9 wickets","winning_team_id":129001,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-22 16:33:43","verify_time":"2025-06-24 23:29:35","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":28.24,"humidity":74,"visibility":10000,"wind_speed":"19.48","clouds":100},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Slow Spin"},"toss":{"text":"Iyanola Heritage elected to bowl","winner":129001,"decision":2}},"etag":"be0e727d70f78f782f364a7b0ad6f5c8","modified":"2025-07-10 09:18:42","datetime":"2025-07-10 09:18:42","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90935,"title":"Iyanola Heritage vs Amazonian Warriors","short_title":"IYH vs AMW","subtitle":"Match 1","match_number":"1","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Iyanola Heritage won by 9 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129646,"title":"St. Lucia T10 Blast","abbr":"Lucia T10","type":"tournament","category":"domestic","match_format":"t10","season":"2025","status":"live","datestart":"2025-06-24","dateend":"2025-07-08","country":"na","total_matches":"30","total_rounds":"1","total_teams":"6"},"teama":{"team_id":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\/1 (6.5 ov)","scores":"95\/1","overs":"6.5"},"teamb":{"team_id":129002,"name":"Amazonian Warriors","short_name":"AMW","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Amazonian-Warriors.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Amazonian-Warriors.png","scores_full":"91\/5 (10 ov)","scores":"91\/5","overs":"10"},"date_start":"2025-06-24 16:00:00","date_end":"2025-06-25 02:00:00","timestamp_start":1750780800,"timestamp_end":1750816800,"date_start_ist":"2025-06-24 21:30:00","date_end_ist":"2025-06-25 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 9 wickets","result_type":1,"win_margin":"9 wickets","winning_team_id":129001,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-22 16:33:43","verify_time":"2025-06-24 23:29:35","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":28.24,"humidity":74,"visibility":10000,"wind_speed":"19.48","clouds":100},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Slow Spin"},"toss":{"text":"Iyanola Heritage elected to bowl","winner":129001,"decision":2}},"etag":"be0e727d70f78f782f364a7b0ad6f5c8","modified":"2025-07-10 09:18:42","datetime":"2025-07-10 09:18:42","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90935 AND DataTypeId = 3 END Live Report & Scorecard of Iyanola Heritage vs Amazonian Warriors Match 1
Iyanola Heritage vs Amazonian Warriors, Live Cricket Commentary