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:652be247-d5b9-4d1e-90dc-6daaf9b05413 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90630 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90630,1,'{"status":"ok","response":{"mid":90630,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Soca Kings won by 31 runs","day_remaining_over":"","team_batting":"SAMP Army Cocrico Cavaliers","team_bowling":"Soca Kings","live_inning_number":2,"live_score":{"runs":117,"overs":10,"wickets":4,"target":149,"runrate":11.7,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Saiba Batoosingh","batsman_id":52202,"runs":5,"balls_faced":3,"fours":1,"sixes":0,"strike_rate":"166.67"},{"name":"Abdul Raheem-Toppin","batsman_id":127451,"runs":1,"balls_faced":3,"fours":0,"sixes":0,"strike_rate":"33.33"}],"bowlers":[{"name":"Tion Webster","bowler_id":90945,"overs":1,"runs_conceded":8,"wickets":1,"maidens":0,"econ":"8.00"},{"name":"Rayad Emrit","bowler_id":43338,"overs":2,"runs_conceded":19,"wickets":1,"maidens":0,"econ":"9.50"}],"commentaries":[{"event_id":"12153282","event":"ball","batsman_id":"53738","bowler_id":"52292","over":"6","ball":"1","score":6,"commentary":"Dejourn Charles to Kjorn Ottley, Six,","noball_dismissal":false,"text":"","timestamp":1750020026,"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":"12153283","event":"wicket","batsman_id":"53738","bowler_id":"52292","over":"6","ball":"2","score":"w","commentary":"Dejourn Charles to Kjorn Ottley, no run, c RR Emrit b D Charles,","noball_dismissal":false,"text":"","timestamp":1750020028,"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":"53738","how_out":"c RR Emrit b D Charles","batsman_runs":"30","batsman_balls":"16"},{"event_id":"12153287","event":"ball","batsman_id":"96399","bowler_id":"52292","over":"6","ball":"3","score":"1wd","commentary":"Dejourn Charles to Leonardo Julien, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750020087,"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":"12153293","event":"ball","batsman_id":"96399","bowler_id":"52292","over":"6","ball":"3","score":1,"commentary":"Dejourn Charles to Leonardo Julien, 1 run,","noball_dismissal":false,"text":"","timestamp":1750020121,"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":"12153295","event":"ball","batsman_id":"117094","bowler_id":"52292","over":"6","ball":"4","score":6,"commentary":"Dejourn Charles to Kyle Ramdoo, Six,","noball_dismissal":false,"text":"","timestamp":1750020151,"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":"12153299","event":"ball","batsman_id":"117094","bowler_id":"52292","over":"6","ball":"5","score":1,"commentary":"Dejourn Charles to Kyle Ramdoo, 1 run,","noball_dismissal":false,"text":"","timestamp":1750020280,"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":"12153302","event":"ball","batsman_id":"96399","bowler_id":"52292","over":"6","ball":"6","score":0,"commentary":"Dejourn Charles to Leonardo Julien, no run,","noball_dismissal":false,"text":"","timestamp":1750020363,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":7,"runs":15,"score":"83\/2","bats":[{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":96399},{"runs":25,"balls_faced":15,"fours":0,"sixes":3,"batsman_id":117094}],"bowls":[{"runs_conceded":24,"maidens":0,"wickets":2,"bowler_id":52292,"overs":2},{"runs_conceded":23,"maidens":0,"wickets":0,"bowler_id":114121,"overs":1}],"commentary":"End of over 7 (15 runs), SAMP Army Cocrico Cavaliers 83\/2"},{"event_id":"12153308","event":"ball","batsman_id":"117094","bowler_id":"114112","over":"7","ball":"1","score":"1wd","commentary":"Chadeon Raymond to Kyle Ramdoo, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750020450,"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":"12153309","event":"ball","batsman_id":"117094","bowler_id":"114112","over":"7","ball":"1","score":"1wd","commentary":"Chadeon Raymond to Kyle Ramdoo, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750020453,"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":"12153312","event":"ball","batsman_id":"117094","bowler_id":"114112","over":"7","ball":"1","score":"1b","commentary":"Chadeon Raymond to Kyle Ramdoo, 1 bye,","noball_dismissal":false,"text":"","timestamp":1750020518,"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":"12153315","event":"ball","batsman_id":"96399","bowler_id":"114112","over":"7","ball":"2","score":6,"commentary":"Chadeon Raymond to Leonardo Julien, Six,","noball_dismissal":false,"text":"","timestamp":1750020645,"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":"12153316","event":"ball","batsman_id":"96399","bowler_id":"114112","over":"7","ball":"3","score":6,"commentary":"Chadeon Raymond to Leonardo Julien, Six,","noball_dismissal":false,"text":"","timestamp":1750020648,"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":"12153319","event":"ball","batsman_id":"96399","bowler_id":"114112","over":"7","ball":"4","score":0,"commentary":"Chadeon Raymond to Leonardo Julien, no run,","noball_dismissal":false,"text":"","timestamp":1750020737,"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":"12153321","event":"ball","batsman_id":"96399","bowler_id":"114112","over":"7","ball":"5","score":1,"commentary":"Chadeon Raymond to Leonardo Julien, 1 run,","noball_dismissal":false,"text":"","timestamp":1750020769,"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":"12153323","event":"ball","batsman_id":"117094","bowler_id":"114112","over":"7","ball":"6","score":1,"commentary":"Chadeon Raymond to Kyle Ramdoo, 1 run,","noball_dismissal":false,"text":"","timestamp":1750020898,"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":17,"score":"100\/2","bats":[{"runs":26,"balls_faced":17,"fours":0,"sixes":3,"batsman_id":117094},{"runs":14,"balls_faced":6,"fours":0,"sixes":2,"batsman_id":96399}],"bowls":[{"runs_conceded":19,"maidens":0,"wickets":0,"bowler_id":114112,"overs":2},{"runs_conceded":24,"maidens":0,"wickets":2,"bowler_id":52292,"overs":2}],"commentary":"End of over 8 (17 runs), SAMP Army Cocrico Cavaliers 100\/2"},{"event_id":"12153333","event":"ball","batsman_id":"117094","bowler_id":"43338","over":"8","ball":"1","score":0,"commentary":"Rayad Emrit to Kyle Ramdoo, no run,","noball_dismissal":false,"text":"","timestamp":1750020964,"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":"12153335","event":"ball","batsman_id":"117094","bowler_id":"43338","over":"8","ball":"2","score":1,"commentary":"Rayad Emrit to Kyle Ramdoo, 1 run,","noball_dismissal":false,"text":"","timestamp":1750021058,"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":"12153339","event":"ball","batsman_id":"96399","bowler_id":"43338","over":"8","ball":"3","score":4,"commentary":"Rayad Emrit to Leonardo Julien, Four,","noball_dismissal":false,"text":"","timestamp":1750021060,"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":"12153342","event":"wicket","batsman_id":"96399","bowler_id":"43338","over":"8","ball":"4","score":"w","commentary":"Rayad Emrit to Leonardo Julien, no run, lbw b RR Emrit,","noball_dismissal":false,"text":"","timestamp":1750021188,"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":"96399","how_out":"lbw b RR Emrit","batsman_runs":"18","batsman_balls":"8"},{"event_id":"12153343","event":"ball","batsman_id":"52202","bowler_id":"43338","over":"8","ball":"5","score":4,"commentary":"Rayad Emrit to Saiba Batoosingh, Four,","noball_dismissal":false,"text":"","timestamp":1750021199,"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":"12153344","event":"ball","batsman_id":"52202","bowler_id":"43338","over":"8","ball":"6","score":0,"commentary":"Rayad Emrit to Saiba Batoosingh, no run,","noball_dismissal":false,"text":"","timestamp":1750021412,"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":9,"runs":9,"score":"109\/3","bats":[{"runs":4,"balls_faced":2,"fours":1,"sixes":0,"batsman_id":52202},{"runs":27,"balls_faced":19,"fours":0,"sixes":3,"batsman_id":117094}],"bowls":[{"runs_conceded":19,"maidens":0,"wickets":1,"bowler_id":43338,"overs":2},{"runs_conceded":19,"maidens":0,"wickets":0,"bowler_id":114112,"overs":2}],"commentary":"End of over 9 (9 runs), SAMP Army Cocrico Cavaliers 109\/3"},{"event_id":"12153356","event":"ball","batsman_id":"117094","bowler_id":"90945","over":"9","ball":"1","score":6,"commentary":"Tion Webster to Kyle Ramdoo, Six,","noball_dismissal":false,"text":"","timestamp":1750021414,"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":"12153357","event":"wicket","batsman_id":"117094","bowler_id":"90945","over":"9","ball":"2","score":"w","commentary":"Tion Webster to Kyle Ramdoo, no run, c A Mohammed b T Webster,","noball_dismissal":false,"text":"","timestamp":1750021416,"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":"117094","how_out":"c A Mohammed b T Webster","batsman_runs":"33","batsman_balls":"21"},{"event_id":"12153360","event":"ball","batsman_id":"127451","bowler_id":"90945","over":"9","ball":"3","score":1,"commentary":"Tion Webster to Abdul Raheem-Toppin, 1 run,","noball_dismissal":false,"text":"","timestamp":1750021515,"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":"12153362","event":"ball","batsman_id":"52202","bowler_id":"90945","over":"9","ball":"4","score":1,"commentary":"Tion Webster to Saiba Batoosingh, 1 run,","noball_dismissal":false,"text":"","timestamp":1750021574,"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":"12153363","event":"ball","batsman_id":"127451","bowler_id":"90945","over":"9","ball":"5","score":0,"commentary":"Tion Webster to Abdul Raheem-Toppin, no run,","noball_dismissal":false,"text":"","timestamp":1750021656,"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":"12153366","event":"ball","batsman_id":"127451","bowler_id":"90945","over":"9","ball":"6","score":0,"commentary":"Tion Webster to Abdul Raheem-Toppin, no run,","noball_dismissal":false,"text":"","timestamp":1750021664,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":10,"runs":8,"score":"117\/4","bats":[{"runs":1,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":127451},{"runs":5,"balls_faced":3,"fours":1,"sixes":0,"batsman_id":52202}],"bowls":[{"runs_conceded":8,"maidens":0,"wickets":1,"bowler_id":90945,"overs":1},{"runs_conceded":19,"maidens":0,"wickets":1,"bowler_id":43338,"overs":2}],"commentary":"End of over 10 (8 runs), SAMP Army Cocrico Cavaliers 117\/4"}],"day":"0","session":"0","live_inning":{"iid":198161,"number":2,"name":"SAMP Army Cocrico Cavaliers Inning","short_name":"CCL Inning","status":2,"issuperover":"false","result":4,"batting_team_id":123297,"fielding_team_id":123301,"scores":"117\/4","scores_full":"117\/4 (10 ov)","fielder":[{"fielder_id":"43338","fielder_name":"Rayad Emrit","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"147243","fielder_name":"Akeel Mohammed","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":"Kyle Ramdoo","batsman_id":"117094","runs":"33","balls":"21","how_out":"c A Mohammed b T Webster","score_at_dismissal":115,"overs_at_dismissal":"9.2","bowler_id":"90945","dismissal":"caught","number":4},"extra_runs":{"byes":1,"legbyes":5,"wides":10,"noballs":0,"penalty":"0","total":16},"equations":{"runs":117,"wickets":4,"overs":"10","bowlers_used":6,"runrate":"11.70"},"current_partnership":{"runs":2,"balls":4,"overs":0.4,"batsmen":[{"name":"Abdul Raheem-Toppin","batsman_id":127451,"runs":1,"balls":3},{"name":"Saiba Batoosingh","batsman_id":52202,"runs":1,"balls":1}]},"did_not_bat":[{"player_id":"127445","name":"Olando James"},{"player_id":"114085","name":"Justin Joseph"},{"player_id":"96615","name":"Avinash Mahabirsingh"},{"player_id":"121766","name":"Jordan Samkaran"},{"player_id":"114094","name":"Shaaron Lewis"}],"max_over":"10","target":"149","recent_scores":"0,0,1,1,w,6,0,4,w,4,1,0,1,1,0,6,6,1","last_five_overs":"72\/3 11.68","last_ten_overs":"117\/4 10.17"},"teams":[{"tid":123297,"title":"SAMP Army Cocrico Cavaliers","abbr":"CCL","alt_name":"Cocrico Cavaliers","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/CCL-CR1@2x.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/CCL-CR1@2x.png","country":"wi","sex":"male","team_owner":"","head_coach":"","scores_full":"117\/4 (10 ov)","scores":"117\/4","overs":"10"},{"tid":123301,"title":"Soca Kings","abbr":"SCK","alt_name":"Soca Kings","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/SCK-CR1@2x.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/SCK-CR1@2x.png","country":"wi","sex":"male","team_owner":"","head_coach":"","scores_full":"148\/3 (10 ov)","scores":"148\/3","overs":"10"}],"players":[{"pid":43338,"title":"Rayad Emrit","short_name":"RR Emrit","first_name":"Rayad Emrit","last_name":"","middle_name":"","birthdate":"1981-03-08","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/rayad51","instagram_profile":"https:\/\/www.instagram.com\/rayad51\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":"(C)"},{"pid":52202,"title":"Saiba Batoosingh","short_name":"S Batoosingh","first_name":"Saiba Batoosingh","last_name":"","middle_name":"","birthdate":"1998-10-10","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":52292,"title":"Dejourn Charles","short_name":"D Charles","first_name":"Dejourn Charles","last_name":"","middle_name":"","birthdate":"1997-10-12","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","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":"all","role_str":""},{"pid":53738,"title":"Kjorn Ottley","short_name":"KY Ottley","first_name":"Kjorn Ottley","last_name":"","middle_name":"","birthdate":"1989-12-09","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","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":"bat","role_str":""},{"pid":90814,"title":"Imran Khan","short_name":"I Khan","first_name":"Imran Khan","last_name":"","middle_name":"","birthdate":"1984-07-06","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":90945,"title":"Tion Webster","short_name":"T Webster","first_name":"Tion Webster","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","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":"bat","role_str":""},{"pid":95511,"title":"Akeem Jordan","short_name":"A Jordan","first_name":"Akeem Jordan","last_name":"","middle_name":"","birthdate":"1994-10-18","birthplace":"Barbados","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/akeem_jordan\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":96399,"title":"Leonardo Julien","short_name":"L Julien","first_name":"Leonardo Julien","last_name":"","middle_name":"","birthdate":"2001-09-09","birthplace":"Trinidad & Tobago","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(WK)"},{"pid":96611,"title":"Joshua James","short_name":"J James","first_name":"Joshua James","last_name":"","middle_name":"","birthdate":"2001-02-21","birthplace":"Trinidad & Tobago","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":96615,"title":"Avinash Mahabirsingh","short_name":"A Mahabirsingh","first_name":"Avinash Mahabirsingh","last_name":"","middle_name":"","birthdate":"2001-04-17","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","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":109937,"title":"Sion Hackett","short_name":"S Hackett","first_name":"Sion Hackett","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"","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":"","thumb_url":"","profile_image":"","nationality":null,"role":"squad","role_str":""},{"pid":114085,"title":"Justin Joseph","short_name":"J Joseph","first_name":"Justin Joseph","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":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":114094,"title":"Shaaron Lewis","short_name":"S Lewis","first_name":"Shaaron Lewis","last_name":"","middle_name":"","birthdate":"1998-03-12","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium Fast","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":"bowl","role_str":""},{"pid":114108,"title":"Jesse Bootan","short_name":"J Bootan","first_name":"Jesse Bootan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":"(C)"},{"pid":114112,"title":"Chadeon Raymond","short_name":"C Raymond","first_name":"Chadeon Raymond","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":114121,"title":"Shatrughan Rambaran","short_name":"S Rambaran","first_name":"Shatrughan Rambaran","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":115835,"title":"Denzil Antoine","short_name":"D Antoine","first_name":"Denzil Antoine","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":116243,"title":"Aamir Ali","short_name":"A Ali","first_name":"Aamir Ali","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":"bowl","role_str":""},{"pid":117094,"title":"Kyle Ramdoo","short_name":"K Ramdoo","first_name":"Kyle Ramdoo","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":""},{"pid":121766,"title":"Jordan Samkaran","short_name":"J Samkaran","first_name":"Jordan Samkaran","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":127227,"title":"Jon Russ Jagessar","short_name":"Jon Jagessar","first_name":"Jon Russ Jagessar","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":127444,"title":"Ricardo Chase","short_name":"R Chase","first_name":"Ricardo Chase","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":127445,"title":"Olando James","short_name":"O James","first_name":"Olando James","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":127451,"title":"Abdul Raheem-Toppin","short_name":"A R-Toppin","first_name":"Abdul Raheem-Toppin","last_name":"","middle_name":"","birthdate":"2005-10-18","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":"all","role_str":""},{"pid":138825,"title":"Aneal Rooplal","short_name":"A Rooplal","first_name":"Aneal Rooplal","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":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":139127,"title":"Abdur Rahman Juman","short_name":"A R Juman","first_name":"Abdur Rahman Juman","last_name":"","middle_name":"","birthdate":"2003-11-14","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":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":147236,"title":"Trevon James","short_name":"T James","first_name":"Trevon James","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":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(WK)"},{"pid":147243,"title":"Akeel Mohammed","short_name":"A Mohammed","first_name":"Akeel Mohammed","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":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":147508,"title":"Christian Lall","short_name":"C Lall","first_name":"Christian Lall","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":149739,"title":"Justin Rajkumar","short_name":"J Rajkumar","first_name":"Justin Rajkumar","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":"squad","role_str":""}]},"etag":"4f30dbbd8dea6a53795cb545217366e0","modified":"2025-07-06 18:41:41","datetime":"2025-07-06 18:41:41","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":90630,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Soca Kings won by 31 runs","day_remaining_over":"","team_batting":"SAMP Army Cocrico Cavaliers","team_bowling":"Soca Kings","live_inning_number":2,"live_score":{"runs":117,"overs":10,"wickets":4,"target":149,"runrate":11.7,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Saiba Batoosingh","batsman_id":52202,"runs":5,"balls_faced":3,"fours":1,"sixes":0,"strike_rate":"166.67"},{"name":"Abdul Raheem-Toppin","batsman_id":127451,"runs":1,"balls_faced":3,"fours":0,"sixes":0,"strike_rate":"33.33"}],"bowlers":[{"name":"Tion Webster","bowler_id":90945,"overs":1,"runs_conceded":8,"wickets":1,"maidens":0,"econ":"8.00"},{"name":"Rayad Emrit","bowler_id":43338,"overs":2,"runs_conceded":19,"wickets":1,"maidens":0,"econ":"9.50"}],"commentaries":[{"event_id":"12153282","event":"ball","batsman_id":"53738","bowler_id":"52292","over":"6","ball":"1","score":6,"commentary":"Dejourn Charles to Kjorn Ottley, Six,","noball_dismissal":false,"text":"","timestamp":1750020026,"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":"12153283","event":"wicket","batsman_id":"53738","bowler_id":"52292","over":"6","ball":"2","score":"w","commentary":"Dejourn Charles to Kjorn Ottley, no run, c RR Emrit b D Charles,","noball_dismissal":false,"text":"","timestamp":1750020028,"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":"53738","how_out":"c RR Emrit b D Charles","batsman_runs":"30","batsman_balls":"16"},{"event_id":"12153287","event":"ball","batsman_id":"96399","bowler_id":"52292","over":"6","ball":"3","score":"1wd","commentary":"Dejourn Charles to Leonardo Julien, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750020087,"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":"12153293","event":"ball","batsman_id":"96399","bowler_id":"52292","over":"6","ball":"3","score":1,"commentary":"Dejourn Charles to Leonardo Julien, 1 run,","noball_dismissal":false,"text":"","timestamp":1750020121,"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":"12153295","event":"ball","batsman_id":"117094","bowler_id":"52292","over":"6","ball":"4","score":6,"commentary":"Dejourn Charles to Kyle Ramdoo, Six,","noball_dismissal":false,"text":"","timestamp":1750020151,"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":"12153299","event":"ball","batsman_id":"117094","bowler_id":"52292","over":"6","ball":"5","score":1,"commentary":"Dejourn Charles to Kyle Ramdoo, 1 run,","noball_dismissal":false,"text":"","timestamp":1750020280,"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":"12153302","event":"ball","batsman_id":"96399","bowler_id":"52292","over":"6","ball":"6","score":0,"commentary":"Dejourn Charles to Leonardo Julien, no run,","noball_dismissal":false,"text":"","timestamp":1750020363,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":7,"runs":15,"score":"83\/2","bats":[{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":96399},{"runs":25,"balls_faced":15,"fours":0,"sixes":3,"batsman_id":117094}],"bowls":[{"runs_conceded":24,"maidens":0,"wickets":2,"bowler_id":52292,"overs":2},{"runs_conceded":23,"maidens":0,"wickets":0,"bowler_id":114121,"overs":1}],"commentary":"End of over 7 (15 runs), SAMP Army Cocrico Cavaliers 83\/2"},{"event_id":"12153308","event":"ball","batsman_id":"117094","bowler_id":"114112","over":"7","ball":"1","score":"1wd","commentary":"Chadeon Raymond to Kyle Ramdoo, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750020450,"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":"12153309","event":"ball","batsman_id":"117094","bowler_id":"114112","over":"7","ball":"1","score":"1wd","commentary":"Chadeon Raymond to Kyle Ramdoo, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750020453,"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":"12153312","event":"ball","batsman_id":"117094","bowler_id":"114112","over":"7","ball":"1","score":"1b","commentary":"Chadeon Raymond to Kyle Ramdoo, 1 bye,","noball_dismissal":false,"text":"","timestamp":1750020518,"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":"12153315","event":"ball","batsman_id":"96399","bowler_id":"114112","over":"7","ball":"2","score":6,"commentary":"Chadeon Raymond to Leonardo Julien, Six,","noball_dismissal":false,"text":"","timestamp":1750020645,"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":"12153316","event":"ball","batsman_id":"96399","bowler_id":"114112","over":"7","ball":"3","score":6,"commentary":"Chadeon Raymond to Leonardo Julien, Six,","noball_dismissal":false,"text":"","timestamp":1750020648,"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":"12153319","event":"ball","batsman_id":"96399","bowler_id":"114112","over":"7","ball":"4","score":0,"commentary":"Chadeon Raymond to Leonardo Julien, no run,","noball_dismissal":false,"text":"","timestamp":1750020737,"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":"12153321","event":"ball","batsman_id":"96399","bowler_id":"114112","over":"7","ball":"5","score":1,"commentary":"Chadeon Raymond to Leonardo Julien, 1 run,","noball_dismissal":false,"text":"","timestamp":1750020769,"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":"12153323","event":"ball","batsman_id":"117094","bowler_id":"114112","over":"7","ball":"6","score":1,"commentary":"Chadeon Raymond to Kyle Ramdoo, 1 run,","noball_dismissal":false,"text":"","timestamp":1750020898,"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":17,"score":"100\/2","bats":[{"runs":26,"balls_faced":17,"fours":0,"sixes":3,"batsman_id":117094},{"runs":14,"balls_faced":6,"fours":0,"sixes":2,"batsman_id":96399}],"bowls":[{"runs_conceded":19,"maidens":0,"wickets":0,"bowler_id":114112,"overs":2},{"runs_conceded":24,"maidens":0,"wickets":2,"bowler_id":52292,"overs":2}],"commentary":"End of over 8 (17 runs), SAMP Army Cocrico Cavaliers 100\/2"},{"event_id":"12153333","event":"ball","batsman_id":"117094","bowler_id":"43338","over":"8","ball":"1","score":0,"commentary":"Rayad Emrit to Kyle Ramdoo, no run,","noball_dismissal":false,"text":"","timestamp":1750020964,"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":"12153335","event":"ball","batsman_id":"117094","bowler_id":"43338","over":"8","ball":"2","score":1,"commentary":"Rayad Emrit to Kyle Ramdoo, 1 run,","noball_dismissal":false,"text":"","timestamp":1750021058,"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":"12153339","event":"ball","batsman_id":"96399","bowler_id":"43338","over":"8","ball":"3","score":4,"commentary":"Rayad Emrit to Leonardo Julien, Four,","noball_dismissal":false,"text":"","timestamp":1750021060,"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":"12153342","event":"wicket","batsman_id":"96399","bowler_id":"43338","over":"8","ball":"4","score":"w","commentary":"Rayad Emrit to Leonardo Julien, no run, lbw b RR Emrit,","noball_dismissal":false,"text":"","timestamp":1750021188,"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":"96399","how_out":"lbw b RR Emrit","batsman_runs":"18","batsman_balls":"8"},{"event_id":"12153343","event":"ball","batsman_id":"52202","bowler_id":"43338","over":"8","ball":"5","score":4,"commentary":"Rayad Emrit to Saiba Batoosingh, Four,","noball_dismissal":false,"text":"","timestamp":1750021199,"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":"12153344","event":"ball","batsman_id":"52202","bowler_id":"43338","over":"8","ball":"6","score":0,"commentary":"Rayad Emrit to Saiba Batoosingh, no run,","noball_dismissal":false,"text":"","timestamp":1750021412,"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":9,"runs":9,"score":"109\/3","bats":[{"runs":4,"balls_faced":2,"fours":1,"sixes":0,"batsman_id":52202},{"runs":27,"balls_faced":19,"fours":0,"sixes":3,"batsman_id":117094}],"bowls":[{"runs_conceded":19,"maidens":0,"wickets":1,"bowler_id":43338,"overs":2},{"runs_conceded":19,"maidens":0,"wickets":0,"bowler_id":114112,"overs":2}],"commentary":"End of over 9 (9 runs), SAMP Army Cocrico Cavaliers 109\/3"},{"event_id":"12153356","event":"ball","batsman_id":"117094","bowler_id":"90945","over":"9","ball":"1","score":6,"commentary":"Tion Webster to Kyle Ramdoo, Six,","noball_dismissal":false,"text":"","timestamp":1750021414,"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":"12153357","event":"wicket","batsman_id":"117094","bowler_id":"90945","over":"9","ball":"2","score":"w","commentary":"Tion Webster to Kyle Ramdoo, no run, c A Mohammed b T Webster,","noball_dismissal":false,"text":"","timestamp":1750021416,"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":"117094","how_out":"c A Mohammed b T Webster","batsman_runs":"33","batsman_balls":"21"},{"event_id":"12153360","event":"ball","batsman_id":"127451","bowler_id":"90945","over":"9","ball":"3","score":1,"commentary":"Tion Webster to Abdul Raheem-Toppin, 1 run,","noball_dismissal":false,"text":"","timestamp":1750021515,"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":"12153362","event":"ball","batsman_id":"52202","bowler_id":"90945","over":"9","ball":"4","score":1,"commentary":"Tion Webster to Saiba Batoosingh, 1 run,","noball_dismissal":false,"text":"","timestamp":1750021574,"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":"12153363","event":"ball","batsman_id":"127451","bowler_id":"90945","over":"9","ball":"5","score":0,"commentary":"Tion Webster to Abdul Raheem-Toppin, no run,","noball_dismissal":false,"text":"","timestamp":1750021656,"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":"12153366","event":"ball","batsman_id":"127451","bowler_id":"90945","over":"9","ball":"6","score":0,"commentary":"Tion Webster to Abdul Raheem-Toppin, no run,","noball_dismissal":false,"text":"","timestamp":1750021664,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":10,"runs":8,"score":"117\/4","bats":[{"runs":1,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":127451},{"runs":5,"balls_faced":3,"fours":1,"sixes":0,"batsman_id":52202}],"bowls":[{"runs_conceded":8,"maidens":0,"wickets":1,"bowler_id":90945,"overs":1},{"runs_conceded":19,"maidens":0,"wickets":1,"bowler_id":43338,"overs":2}],"commentary":"End of over 10 (8 runs), SAMP Army Cocrico Cavaliers 117\/4"}],"day":"0","session":"0","live_inning":{"iid":198161,"number":2,"name":"SAMP Army Cocrico Cavaliers Inning","short_name":"CCL Inning","status":2,"issuperover":"false","result":4,"batting_team_id":123297,"fielding_team_id":123301,"scores":"117\/4","scores_full":"117\/4 (10 ov)","fielder":[{"fielder_id":"43338","fielder_name":"Rayad Emrit","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"147243","fielder_name":"Akeel Mohammed","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":"Kyle Ramdoo","batsman_id":"117094","runs":"33","balls":"21","how_out":"c A Mohammed b T Webster","score_at_dismissal":115,"overs_at_dismissal":"9.2","bowler_id":"90945","dismissal":"caught","number":4},"extra_runs":{"byes":1,"legbyes":5,"wides":10,"noballs":0,"penalty":"0","total":16},"equations":{"runs":117,"wickets":4,"overs":"10","bowlers_used":6,"runrate":"11.70"},"current_partnership":{"runs":2,"balls":4,"overs":0.4,"batsmen":[{"name":"Abdul Raheem-Toppin","batsman_id":127451,"runs":1,"balls":3},{"name":"Saiba Batoosingh","batsman_id":52202,"runs":1,"balls":1}]},"did_not_bat":[{"player_id":"127445","name":"Olando James"},{"player_id":"114085","name":"Justin Joseph"},{"player_id":"96615","name":"Avinash Mahabirsingh"},{"player_id":"121766","name":"Jordan Samkaran"},{"player_id":"114094","name":"Shaaron Lewis"}],"max_over":"10","target":"149","recent_scores":"0,0,1,1,w,6,0,4,w,4,1,0,1,1,0,6,6,1","last_five_overs":"72\/3 11.68","last_ten_overs":"117\/4 10.17"},"teams":[{"tid":123297,"title":"SAMP Army Cocrico Cavaliers","abbr":"CCL","alt_name":"Cocrico Cavaliers","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/CCL-CR1@2x.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/CCL-CR1@2x.png","country":"wi","sex":"male","team_owner":"","head_coach":"","scores_full":"117\/4 (10 ov)","scores":"117\/4","overs":"10"},{"tid":123301,"title":"Soca Kings","abbr":"SCK","alt_name":"Soca Kings","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/SCK-CR1@2x.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/SCK-CR1@2x.png","country":"wi","sex":"male","team_owner":"","head_coach":"","scores_full":"148\/3 (10 ov)","scores":"148\/3","overs":"10"}],"players":[{"pid":43338,"title":"Rayad Emrit","short_name":"RR Emrit","first_name":"Rayad Emrit","last_name":"","middle_name":"","birthdate":"1981-03-08","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/rayad51","instagram_profile":"https:\/\/www.instagram.com\/rayad51\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":"(C)"},{"pid":52202,"title":"Saiba Batoosingh","short_name":"S Batoosingh","first_name":"Saiba Batoosingh","last_name":"","middle_name":"","birthdate":"1998-10-10","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":52292,"title":"Dejourn Charles","short_name":"D Charles","first_name":"Dejourn Charles","last_name":"","middle_name":"","birthdate":"1997-10-12","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","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":"all","role_str":""},{"pid":53738,"title":"Kjorn Ottley","short_name":"KY Ottley","first_name":"Kjorn Ottley","last_name":"","middle_name":"","birthdate":"1989-12-09","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","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":"bat","role_str":""},{"pid":90814,"title":"Imran Khan","short_name":"I Khan","first_name":"Imran Khan","last_name":"","middle_name":"","birthdate":"1984-07-06","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":90945,"title":"Tion Webster","short_name":"T Webster","first_name":"Tion Webster","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","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":"bat","role_str":""},{"pid":95511,"title":"Akeem Jordan","short_name":"A Jordan","first_name":"Akeem Jordan","last_name":"","middle_name":"","birthdate":"1994-10-18","birthplace":"Barbados","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/akeem_jordan\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":96399,"title":"Leonardo Julien","short_name":"L Julien","first_name":"Leonardo Julien","last_name":"","middle_name":"","birthdate":"2001-09-09","birthplace":"Trinidad & Tobago","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(WK)"},{"pid":96611,"title":"Joshua James","short_name":"J James","first_name":"Joshua James","last_name":"","middle_name":"","birthdate":"2001-02-21","birthplace":"Trinidad & Tobago","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":96615,"title":"Avinash Mahabirsingh","short_name":"A Mahabirsingh","first_name":"Avinash Mahabirsingh","last_name":"","middle_name":"","birthdate":"2001-04-17","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","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":109937,"title":"Sion Hackett","short_name":"S Hackett","first_name":"Sion Hackett","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"","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":"","thumb_url":"","profile_image":"","nationality":null,"role":"squad","role_str":""},{"pid":114085,"title":"Justin Joseph","short_name":"J Joseph","first_name":"Justin Joseph","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":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":114094,"title":"Shaaron Lewis","short_name":"S Lewis","first_name":"Shaaron Lewis","last_name":"","middle_name":"","birthdate":"1998-03-12","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium Fast","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":"bowl","role_str":""},{"pid":114108,"title":"Jesse Bootan","short_name":"J Bootan","first_name":"Jesse Bootan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":"(C)"},{"pid":114112,"title":"Chadeon Raymond","short_name":"C Raymond","first_name":"Chadeon Raymond","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":114121,"title":"Shatrughan Rambaran","short_name":"S Rambaran","first_name":"Shatrughan Rambaran","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":115835,"title":"Denzil Antoine","short_name":"D Antoine","first_name":"Denzil Antoine","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":116243,"title":"Aamir Ali","short_name":"A Ali","first_name":"Aamir Ali","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":"bowl","role_str":""},{"pid":117094,"title":"Kyle Ramdoo","short_name":"K Ramdoo","first_name":"Kyle Ramdoo","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":""},{"pid":121766,"title":"Jordan Samkaran","short_name":"J Samkaran","first_name":"Jordan Samkaran","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":127227,"title":"Jon Russ Jagessar","short_name":"Jon Jagessar","first_name":"Jon Russ Jagessar","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":127444,"title":"Ricardo Chase","short_name":"R Chase","first_name":"Ricardo Chase","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":127445,"title":"Olando James","short_name":"O James","first_name":"Olando James","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":127451,"title":"Abdul Raheem-Toppin","short_name":"A R-Toppin","first_name":"Abdul Raheem-Toppin","last_name":"","middle_name":"","birthdate":"2005-10-18","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":"all","role_str":""},{"pid":138825,"title":"Aneal Rooplal","short_name":"A Rooplal","first_name":"Aneal Rooplal","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":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":139127,"title":"Abdur Rahman Juman","short_name":"A R Juman","first_name":"Abdur Rahman Juman","last_name":"","middle_name":"","birthdate":"2003-11-14","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":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":147236,"title":"Trevon James","short_name":"T James","first_name":"Trevon James","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":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(WK)"},{"pid":147243,"title":"Akeel Mohammed","short_name":"A Mohammed","first_name":"Akeel Mohammed","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":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":147508,"title":"Christian Lall","short_name":"C Lall","first_name":"Christian Lall","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":149739,"title":"Justin Rajkumar","short_name":"J Rajkumar","first_name":"Justin Rajkumar","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":"squad","role_str":""}]},"etag":"4f30dbbd8dea6a53795cb545217366e0","modified":"2025-07-06 18:41:41","datetime":"2025-07-06 18:41:41","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90630 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:652be247-d5b9-4d1e-90dc-6daaf9b05413 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90630 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90630,3,'{"status":"ok","response":{"match_id":90630,"title":"Soca Kings vs SAMP Army Cocrico Cavaliers","short_title":"SCK vs CCL","subtitle":"Match 14","match_number":"14","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Soca Kings won by 31 runs","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129622,"title":"Trinidad T10 Blast, 7th Edition","abbr":"Trinidad T10","type":"tournament","category":"domestic","match_format":"t10","season":"2025","status":"live","datestart":"2025-06-09","dateend":"2025-06-22","country":"wi","total_matches":"30","total_rounds":"1","total_teams":"6"},"teama":{"team_id":123301,"name":"Soca Kings","short_name":"SCK","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/SCK-CR1@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/SCK-CR1@2x.png","scores_full":"148\/3 (10 ov)","scores":"148\/3","overs":"10"},"teamb":{"team_id":123297,"name":"SAMP Army Cocrico Cavaliers","short_name":"CCL","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/CCL-CR1@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/CCL-CR1@2x.png","scores_full":"117\/4 (10 ov)","scores":"117\/4","overs":"10"},"date_start":"2025-06-15 18:30:00","date_end":"2025-06-16 04:30:00","timestamp_start":1750012200,"timestamp_end":1750048200,"date_start_ist":"2025-06-16 00:00:00","date_end_ist":"2025-06-16 10:00:00","venue":{"venue_id":"204","name":"Brian Lara Stadium","location":"Tarouba","country":"West Indies","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"SCK won by 31 runs","result_type":1,"win_margin":"31 runs","winning_team_id":123301,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-14 00:44:40","verify_time":"2025-06-16 02:54:37","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"broken clouds","temp":28.42,"humidity":67,"visibility":10000,"wind_speed":"8.39","clouds":55},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"SAMP Army Cocrico Cavaliers elected to bowl","winner":123297,"decision":2}},"etag":"4f30dbbd8dea6a53795cb545217366e0","modified":"2025-07-06 18:41:41","datetime":"2025-07-06 18:41:41","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90630,"title":"Soca Kings vs SAMP Army Cocrico Cavaliers","short_title":"SCK vs CCL","subtitle":"Match 14","match_number":"14","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Soca Kings won by 31 runs","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129622,"title":"Trinidad T10 Blast, 7th Edition","abbr":"Trinidad T10","type":"tournament","category":"domestic","match_format":"t10","season":"2025","status":"live","datestart":"2025-06-09","dateend":"2025-06-22","country":"wi","total_matches":"30","total_rounds":"1","total_teams":"6"},"teama":{"team_id":123301,"name":"Soca Kings","short_name":"SCK","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/SCK-CR1@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/SCK-CR1@2x.png","scores_full":"148\/3 (10 ov)","scores":"148\/3","overs":"10"},"teamb":{"team_id":123297,"name":"SAMP Army Cocrico Cavaliers","short_name":"CCL","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/CCL-CR1@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/CCL-CR1@2x.png","scores_full":"117\/4 (10 ov)","scores":"117\/4","overs":"10"},"date_start":"2025-06-15 18:30:00","date_end":"2025-06-16 04:30:00","timestamp_start":1750012200,"timestamp_end":1750048200,"date_start_ist":"2025-06-16 00:00:00","date_end_ist":"2025-06-16 10:00:00","venue":{"venue_id":"204","name":"Brian Lara Stadium","location":"Tarouba","country":"West Indies","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"SCK won by 31 runs","result_type":1,"win_margin":"31 runs","winning_team_id":123301,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-14 00:44:40","verify_time":"2025-06-16 02:54:37","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"broken clouds","temp":28.42,"humidity":67,"visibility":10000,"wind_speed":"8.39","clouds":55},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"SAMP Army Cocrico Cavaliers elected to bowl","winner":123297,"decision":2}},"etag":"4f30dbbd8dea6a53795cb545217366e0","modified":"2025-07-06 18:41:41","datetime":"2025-07-06 18:41:41","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90630 AND DataTypeId = 3 END
Live Report & Scorecard of Soca Kings vs SAMP Army Cocrico Cavaliers Match 14