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:86397fc2-64c2-44d9-b3f4-a97c5f6cbed1 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90637 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90637,1,'{"status":"ok","response":{"mid":90637,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"SAMP Army Cocrico Cavaliers won by 10 wickets","day_remaining_over":"","team_batting":"SAMP Army Cocrico Cavaliers","team_bowling":"Soca Kings","live_inning_number":2,"live_score":{"runs":119,"overs":6.3,"wickets":0,"target":117,"runrate":17.85,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Jesse Bootan","batsman_id":114108,"runs":91,"balls_faced":28,"fours":9,"sixes":8,"strike_rate":"325.00"},{"name":"Leonardo Julien","batsman_id":96399,"runs":16,"balls_faced":11,"fours":0,"sixes":1,"strike_rate":"145.45"}],"bowlers":[{"name":"Tion Webster","bowler_id":90945,"overs":0.3,"runs_conceded":16,"wickets":0,"maidens":0,"econ":"32.00"},{"name":"Chadeon Raymond","bowler_id":114112,"overs":1,"runs_conceded":21,"wickets":0,"maidens":0,"econ":"21.00"}],"commentaries":[{"event_id":"12163875","event":"ball","batsman_id":"114108","bowler_id":"52292","over":"2","ball":"3","score":6,"commentary":"Dejourn Charles to Jesse Bootan, Six,","noball_dismissal":false,"text":"","timestamp":1750199889,"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":"12163876","event":"ball","batsman_id":"114108","bowler_id":"52292","over":"2","ball":"4","score":4,"commentary":"Dejourn Charles to Jesse Bootan, Four,","noball_dismissal":false,"text":"","timestamp":1750199919,"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":"12163877","event":"ball","batsman_id":"114108","bowler_id":"52292","over":"2","ball":"5","score":4,"commentary":"Dejourn Charles to Jesse Bootan, Four,","noball_dismissal":false,"text":"","timestamp":1750199954,"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":"12163878","event":"ball","batsman_id":"114108","bowler_id":"52292","over":"2","ball":"6","score":0,"commentary":"Dejourn Charles to Jesse Bootan, no run,","noball_dismissal":false,"text":"","timestamp":1750200016,"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":3,"runs":17,"score":"49\/0","bats":[{"runs":41,"balls_faced":13,"fours":5,"sixes":3,"batsman_id":114108},{"runs":4,"balls_faced":5,"fours":0,"sixes":0,"batsman_id":96399}],"bowls":[{"runs_conceded":17,"maidens":0,"wickets":0,"bowler_id":52292,"overs":1},{"runs_conceded":17,"maidens":0,"wickets":0,"bowler_id":43338,"overs":1}],"commentary":"End of over 3 (17 runs), SAMP Army Cocrico Cavaliers 49\/0"},{"event_id":"12163879","event":"ball","batsman_id":"96399","bowler_id":"116243","over":"3","ball":"1","score":2,"commentary":"Aamir Ali to Leonardo Julien, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750200068,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12163880","event":"ball","batsman_id":"96399","bowler_id":"116243","over":"3","ball":"2","score":1,"commentary":"Aamir Ali to Leonardo Julien, 1 run,","noball_dismissal":false,"text":"","timestamp":1750200127,"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":"12163881","event":"ball","batsman_id":"114108","bowler_id":"116243","over":"3","ball":"3","score":6,"commentary":"Aamir Ali to Jesse Bootan, Six,","noball_dismissal":false,"text":"","timestamp":1750200174,"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":"12163882","event":"ball","batsman_id":"114108","bowler_id":"116243","over":"3","ball":"4","score":1,"commentary":"Aamir Ali to Jesse Bootan, 1 run,","noball_dismissal":false,"text":"","timestamp":1750200219,"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":"12163883","event":"ball","batsman_id":"96399","bowler_id":"116243","over":"3","ball":"5","score":1,"commentary":"Aamir Ali to Leonardo Julien, 1 run,","noball_dismissal":false,"text":"","timestamp":1750200255,"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":"12163884","event":"ball","batsman_id":"114108","bowler_id":"116243","over":"3","ball":"6","score":1,"commentary":"Aamir Ali to Jesse Bootan, 1 run,","noball_dismissal":false,"text":"","timestamp":1750200257,"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":4,"runs":12,"score":"61\/0","bats":[{"runs":49,"balls_faced":16,"fours":5,"sixes":4,"batsman_id":114108},{"runs":8,"balls_faced":8,"fours":0,"sixes":0,"batsman_id":96399}],"bowls":[{"runs_conceded":12,"maidens":0,"wickets":0,"bowler_id":116243,"overs":1},{"runs_conceded":17,"maidens":0,"wickets":0,"bowler_id":52292,"overs":1}],"commentary":"End of over 4 (12 runs), SAMP Army Cocrico Cavaliers 61\/0"},{"event_id":"12163885","event":"ball","batsman_id":"114108","bowler_id":"90814","over":"4","ball":"1","score":"3wd","commentary":"Imran Khan to Jesse Bootan, 3 wide,","noball_dismissal":false,"text":"","timestamp":1750200372,"run":3,"noball_run":"0","wide_run":"3","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12163886","event":"ball","batsman_id":"114108","bowler_id":"90814","over":"4","ball":"1","score":4,"commentary":"Imran Khan to Jesse Bootan, Four,","noball_dismissal":false,"text":"","timestamp":1750200428,"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":"12163887","event":"ball","batsman_id":"114108","bowler_id":"90814","over":"4","ball":"2","score":0,"commentary":"Imran Khan to Jesse Bootan, no run,","noball_dismissal":false,"text":"","timestamp":1750200458,"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":"12163888","event":"ball","batsman_id":"114108","bowler_id":"90814","over":"4","ball":"3","score":6,"commentary":"Imran Khan to Jesse Bootan, Six,","noball_dismissal":false,"text":"","timestamp":1750200460,"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":"12163889","event":"ball","batsman_id":"114108","bowler_id":"90814","over":"4","ball":"4","score":2,"commentary":"Imran Khan to Jesse Bootan, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750200502,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12163890","event":"ball","batsman_id":"114108","bowler_id":"90814","over":"4","ball":"5","score":0,"commentary":"Imran Khan to Jesse Bootan, no run,","noball_dismissal":false,"text":"","timestamp":1750200547,"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":"12163891","event":"ball","batsman_id":"114108","bowler_id":"90814","over":"4","ball":"6","score":6,"commentary":"Imran Khan to Jesse Bootan, Six,","noball_dismissal":false,"text":"","timestamp":1750200572,"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":5,"runs":21,"score":"82\/0","bats":[{"runs":67,"balls_faced":22,"fours":6,"sixes":6,"batsman_id":114108},{"runs":8,"balls_faced":8,"fours":0,"sixes":0,"batsman_id":96399}],"bowls":[{"runs_conceded":21,"maidens":0,"wickets":0,"bowler_id":90814,"overs":1},{"runs_conceded":12,"maidens":0,"wickets":0,"bowler_id":116243,"overs":1}],"commentary":"End of over 5 (21 runs), SAMP Army Cocrico Cavaliers 82\/0"},{"event_id":"12163892","event":"ball","batsman_id":"96399","bowler_id":"114112","over":"5","ball":"1","score":6,"commentary":"Chadeon Raymond to Leonardo Julien, Six,","noball_dismissal":false,"text":"","timestamp":1750200717,"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":"12163893","event":"ball","batsman_id":"96399","bowler_id":"114112","over":"5","ball":"2","score":1,"commentary":"Chadeon Raymond to Leonardo Julien, 1 run,","noball_dismissal":false,"text":"","timestamp":1750200722,"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":"12163894","event":"ball","batsman_id":"114108","bowler_id":"114112","over":"5","ball":"3","score":0,"commentary":"Chadeon Raymond to Jesse Bootan, no run,","noball_dismissal":false,"text":"","timestamp":1750200787,"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":"12163895","event":"ball","batsman_id":"114108","bowler_id":"114112","over":"5","ball":"4","score":6,"commentary":"Chadeon Raymond to Jesse Bootan, Six,","noball_dismissal":false,"text":"","timestamp":1750200830,"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":"12163896","event":"ball","batsman_id":"114108","bowler_id":"114112","over":"5","ball":"5","score":4,"commentary":"Chadeon Raymond to Jesse Bootan, Four,","noball_dismissal":false,"text":"","timestamp":1750200884,"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":"12163897","event":"ball","batsman_id":"114108","bowler_id":"114112","over":"5","ball":"6","score":4,"commentary":"Chadeon Raymond to Jesse Bootan, Four,","noball_dismissal":false,"text":"","timestamp":1750200935,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event":"overend","over":6,"runs":21,"score":"103\/0","bats":[{"runs":81,"balls_faced":26,"fours":8,"sixes":7,"batsman_id":114108},{"runs":15,"balls_faced":10,"fours":0,"sixes":1,"batsman_id":96399}],"bowls":[{"runs_conceded":21,"maidens":0,"wickets":0,"bowler_id":114112,"overs":1},{"runs_conceded":21,"maidens":0,"wickets":0,"bowler_id":90814,"overs":1}],"commentary":"End of over 6 (21 runs), SAMP Army Cocrico Cavaliers 103\/0"},{"event_id":"12163898","event":"ball","batsman_id":"96399","bowler_id":"90945","over":"6","ball":"1","score":1,"commentary":"Tion Webster to Leonardo Julien, 1 run,","noball_dismissal":false,"text":"","timestamp":1750201050,"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":"12163899","event":"ball","batsman_id":"114108","bowler_id":"90945","over":"6","ball":"2","score":6,"commentary":"Tion Webster to Jesse Bootan, Six,","noball_dismissal":false,"text":"","timestamp":1750201070,"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":"12163900","event":"ball","batsman_id":"114108","bowler_id":"90945","over":"6","ball":"3","score":4,"commentary":"Tion Webster to Jesse Bootan, Four,","noball_dismissal":false,"text":"","timestamp":1750201133,"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":"12163901","event":"ball","batsman_id":"114108","bowler_id":"90945","over":"6","ball":"4","score":"5wd","commentary":"Tion Webster to Jesse Bootan, 5 wide,","noball_dismissal":false,"text":"","timestamp":1750201177,"run":5,"noball_run":"0","wide_run":"5","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false}],"day":"0","session":"0","live_inning":{"iid":198278,"number":2,"name":"SAMP Army Cocrico Cavaliers Inning","short_name":"CCL Inning","status":2,"issuperover":"false","result":3,"batting_team_id":123297,"fielding_team_id":123301,"scores":"119\/0","scores_full":"119\/0 (6.3 ov)","fielder":[],"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":[],"extra_runs":{"byes":0,"legbyes":1,"wides":11,"noballs":0,"penalty":"0","total":12},"equations":{"runs":119,"wickets":0,"overs":"6.3","bowlers_used":7,"runrate":"17.85"},"current_partnership":{"runs":119,"balls":39,"overs":6.3,"batsmen":[{"name":"Jesse Bootan","batsman_id":114108,"runs":91,"balls":28},{"name":"Leonardo Julien","batsman_id":96399,"runs":16,"balls":11}]},"did_not_bat":[{"player_id":"117094","name":"Kyle Ramdoo"},{"player_id":"52202","name":"Saiba Batoosingh"},{"player_id":"53738","name":"Kjorn Ottley"},{"player_id":"127445","name":"Olando James"},{"player_id":"114085","name":"Justin Joseph"},{"player_id":"127451","name":"Abdul Raheem-Toppin"},{"player_id":"96615","name":"Avinash Mahabirsingh"},{"player_id":"138825","name":"Aneal Rooplal"},{"player_id":"114094","name":"Shaaron Lewis"}],"max_over":"10","target":"117","recent_scores":"5,4,6,1,4,4,6,0,1,6,6,0,2,6,0,4,3,1","last_five_overs":"95\/0 17.27","last_ten_overs":"119\/0 16.23"},"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":"119\/0 (6.3 ov)","scores":"119\/0","overs":"6.3"},{"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":"116\/9 (10 ov)","scores":"116\/9","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":"squad","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":"bowl","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":"83a755909e6368e461273b1c6273c4df","modified":"2025-07-25 18:03:32","datetime":"2025-07-25 18:03:32","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":90637,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"SAMP Army Cocrico Cavaliers won by 10 wickets","day_remaining_over":"","team_batting":"SAMP Army Cocrico Cavaliers","team_bowling":"Soca Kings","live_inning_number":2,"live_score":{"runs":119,"overs":6.3,"wickets":0,"target":117,"runrate":17.85,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Jesse Bootan","batsman_id":114108,"runs":91,"balls_faced":28,"fours":9,"sixes":8,"strike_rate":"325.00"},{"name":"Leonardo Julien","batsman_id":96399,"runs":16,"balls_faced":11,"fours":0,"sixes":1,"strike_rate":"145.45"}],"bowlers":[{"name":"Tion Webster","bowler_id":90945,"overs":0.3,"runs_conceded":16,"wickets":0,"maidens":0,"econ":"32.00"},{"name":"Chadeon Raymond","bowler_id":114112,"overs":1,"runs_conceded":21,"wickets":0,"maidens":0,"econ":"21.00"}],"commentaries":[{"event_id":"12163875","event":"ball","batsman_id":"114108","bowler_id":"52292","over":"2","ball":"3","score":6,"commentary":"Dejourn Charles to Jesse Bootan, Six,","noball_dismissal":false,"text":"","timestamp":1750199889,"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":"12163876","event":"ball","batsman_id":"114108","bowler_id":"52292","over":"2","ball":"4","score":4,"commentary":"Dejourn Charles to Jesse Bootan, Four,","noball_dismissal":false,"text":"","timestamp":1750199919,"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":"12163877","event":"ball","batsman_id":"114108","bowler_id":"52292","over":"2","ball":"5","score":4,"commentary":"Dejourn Charles to Jesse Bootan, Four,","noball_dismissal":false,"text":"","timestamp":1750199954,"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":"12163878","event":"ball","batsman_id":"114108","bowler_id":"52292","over":"2","ball":"6","score":0,"commentary":"Dejourn Charles to Jesse Bootan, no run,","noball_dismissal":false,"text":"","timestamp":1750200016,"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":3,"runs":17,"score":"49\/0","bats":[{"runs":41,"balls_faced":13,"fours":5,"sixes":3,"batsman_id":114108},{"runs":4,"balls_faced":5,"fours":0,"sixes":0,"batsman_id":96399}],"bowls":[{"runs_conceded":17,"maidens":0,"wickets":0,"bowler_id":52292,"overs":1},{"runs_conceded":17,"maidens":0,"wickets":0,"bowler_id":43338,"overs":1}],"commentary":"End of over 3 (17 runs), SAMP Army Cocrico Cavaliers 49\/0"},{"event_id":"12163879","event":"ball","batsman_id":"96399","bowler_id":"116243","over":"3","ball":"1","score":2,"commentary":"Aamir Ali to Leonardo Julien, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750200068,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12163880","event":"ball","batsman_id":"96399","bowler_id":"116243","over":"3","ball":"2","score":1,"commentary":"Aamir Ali to Leonardo Julien, 1 run,","noball_dismissal":false,"text":"","timestamp":1750200127,"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":"12163881","event":"ball","batsman_id":"114108","bowler_id":"116243","over":"3","ball":"3","score":6,"commentary":"Aamir Ali to Jesse Bootan, Six,","noball_dismissal":false,"text":"","timestamp":1750200174,"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":"12163882","event":"ball","batsman_id":"114108","bowler_id":"116243","over":"3","ball":"4","score":1,"commentary":"Aamir Ali to Jesse Bootan, 1 run,","noball_dismissal":false,"text":"","timestamp":1750200219,"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":"12163883","event":"ball","batsman_id":"96399","bowler_id":"116243","over":"3","ball":"5","score":1,"commentary":"Aamir Ali to Leonardo Julien, 1 run,","noball_dismissal":false,"text":"","timestamp":1750200255,"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":"12163884","event":"ball","batsman_id":"114108","bowler_id":"116243","over":"3","ball":"6","score":1,"commentary":"Aamir Ali to Jesse Bootan, 1 run,","noball_dismissal":false,"text":"","timestamp":1750200257,"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":4,"runs":12,"score":"61\/0","bats":[{"runs":49,"balls_faced":16,"fours":5,"sixes":4,"batsman_id":114108},{"runs":8,"balls_faced":8,"fours":0,"sixes":0,"batsman_id":96399}],"bowls":[{"runs_conceded":12,"maidens":0,"wickets":0,"bowler_id":116243,"overs":1},{"runs_conceded":17,"maidens":0,"wickets":0,"bowler_id":52292,"overs":1}],"commentary":"End of over 4 (12 runs), SAMP Army Cocrico Cavaliers 61\/0"},{"event_id":"12163885","event":"ball","batsman_id":"114108","bowler_id":"90814","over":"4","ball":"1","score":"3wd","commentary":"Imran Khan to Jesse Bootan, 3 wide,","noball_dismissal":false,"text":"","timestamp":1750200372,"run":3,"noball_run":"0","wide_run":"3","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12163886","event":"ball","batsman_id":"114108","bowler_id":"90814","over":"4","ball":"1","score":4,"commentary":"Imran Khan to Jesse Bootan, Four,","noball_dismissal":false,"text":"","timestamp":1750200428,"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":"12163887","event":"ball","batsman_id":"114108","bowler_id":"90814","over":"4","ball":"2","score":0,"commentary":"Imran Khan to Jesse Bootan, no run,","noball_dismissal":false,"text":"","timestamp":1750200458,"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":"12163888","event":"ball","batsman_id":"114108","bowler_id":"90814","over":"4","ball":"3","score":6,"commentary":"Imran Khan to Jesse Bootan, Six,","noball_dismissal":false,"text":"","timestamp":1750200460,"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":"12163889","event":"ball","batsman_id":"114108","bowler_id":"90814","over":"4","ball":"4","score":2,"commentary":"Imran Khan to Jesse Bootan, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750200502,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12163890","event":"ball","batsman_id":"114108","bowler_id":"90814","over":"4","ball":"5","score":0,"commentary":"Imran Khan to Jesse Bootan, no run,","noball_dismissal":false,"text":"","timestamp":1750200547,"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":"12163891","event":"ball","batsman_id":"114108","bowler_id":"90814","over":"4","ball":"6","score":6,"commentary":"Imran Khan to Jesse Bootan, Six,","noball_dismissal":false,"text":"","timestamp":1750200572,"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":5,"runs":21,"score":"82\/0","bats":[{"runs":67,"balls_faced":22,"fours":6,"sixes":6,"batsman_id":114108},{"runs":8,"balls_faced":8,"fours":0,"sixes":0,"batsman_id":96399}],"bowls":[{"runs_conceded":21,"maidens":0,"wickets":0,"bowler_id":90814,"overs":1},{"runs_conceded":12,"maidens":0,"wickets":0,"bowler_id":116243,"overs":1}],"commentary":"End of over 5 (21 runs), SAMP Army Cocrico Cavaliers 82\/0"},{"event_id":"12163892","event":"ball","batsman_id":"96399","bowler_id":"114112","over":"5","ball":"1","score":6,"commentary":"Chadeon Raymond to Leonardo Julien, Six,","noball_dismissal":false,"text":"","timestamp":1750200717,"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":"12163893","event":"ball","batsman_id":"96399","bowler_id":"114112","over":"5","ball":"2","score":1,"commentary":"Chadeon Raymond to Leonardo Julien, 1 run,","noball_dismissal":false,"text":"","timestamp":1750200722,"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":"12163894","event":"ball","batsman_id":"114108","bowler_id":"114112","over":"5","ball":"3","score":0,"commentary":"Chadeon Raymond to Jesse Bootan, no run,","noball_dismissal":false,"text":"","timestamp":1750200787,"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":"12163895","event":"ball","batsman_id":"114108","bowler_id":"114112","over":"5","ball":"4","score":6,"commentary":"Chadeon Raymond to Jesse Bootan, Six,","noball_dismissal":false,"text":"","timestamp":1750200830,"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":"12163896","event":"ball","batsman_id":"114108","bowler_id":"114112","over":"5","ball":"5","score":4,"commentary":"Chadeon Raymond to Jesse Bootan, Four,","noball_dismissal":false,"text":"","timestamp":1750200884,"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":"12163897","event":"ball","batsman_id":"114108","bowler_id":"114112","over":"5","ball":"6","score":4,"commentary":"Chadeon Raymond to Jesse Bootan, Four,","noball_dismissal":false,"text":"","timestamp":1750200935,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event":"overend","over":6,"runs":21,"score":"103\/0","bats":[{"runs":81,"balls_faced":26,"fours":8,"sixes":7,"batsman_id":114108},{"runs":15,"balls_faced":10,"fours":0,"sixes":1,"batsman_id":96399}],"bowls":[{"runs_conceded":21,"maidens":0,"wickets":0,"bowler_id":114112,"overs":1},{"runs_conceded":21,"maidens":0,"wickets":0,"bowler_id":90814,"overs":1}],"commentary":"End of over 6 (21 runs), SAMP Army Cocrico Cavaliers 103\/0"},{"event_id":"12163898","event":"ball","batsman_id":"96399","bowler_id":"90945","over":"6","ball":"1","score":1,"commentary":"Tion Webster to Leonardo Julien, 1 run,","noball_dismissal":false,"text":"","timestamp":1750201050,"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":"12163899","event":"ball","batsman_id":"114108","bowler_id":"90945","over":"6","ball":"2","score":6,"commentary":"Tion Webster to Jesse Bootan, Six,","noball_dismissal":false,"text":"","timestamp":1750201070,"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":"12163900","event":"ball","batsman_id":"114108","bowler_id":"90945","over":"6","ball":"3","score":4,"commentary":"Tion Webster to Jesse Bootan, Four,","noball_dismissal":false,"text":"","timestamp":1750201133,"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":"12163901","event":"ball","batsman_id":"114108","bowler_id":"90945","over":"6","ball":"4","score":"5wd","commentary":"Tion Webster to Jesse Bootan, 5 wide,","noball_dismissal":false,"text":"","timestamp":1750201177,"run":5,"noball_run":"0","wide_run":"5","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false}],"day":"0","session":"0","live_inning":{"iid":198278,"number":2,"name":"SAMP Army Cocrico Cavaliers Inning","short_name":"CCL Inning","status":2,"issuperover":"false","result":3,"batting_team_id":123297,"fielding_team_id":123301,"scores":"119\/0","scores_full":"119\/0 (6.3 ov)","fielder":[],"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":[],"extra_runs":{"byes":0,"legbyes":1,"wides":11,"noballs":0,"penalty":"0","total":12},"equations":{"runs":119,"wickets":0,"overs":"6.3","bowlers_used":7,"runrate":"17.85"},"current_partnership":{"runs":119,"balls":39,"overs":6.3,"batsmen":[{"name":"Jesse Bootan","batsman_id":114108,"runs":91,"balls":28},{"name":"Leonardo Julien","batsman_id":96399,"runs":16,"balls":11}]},"did_not_bat":[{"player_id":"117094","name":"Kyle Ramdoo"},{"player_id":"52202","name":"Saiba Batoosingh"},{"player_id":"53738","name":"Kjorn Ottley"},{"player_id":"127445","name":"Olando James"},{"player_id":"114085","name":"Justin Joseph"},{"player_id":"127451","name":"Abdul Raheem-Toppin"},{"player_id":"96615","name":"Avinash Mahabirsingh"},{"player_id":"138825","name":"Aneal Rooplal"},{"player_id":"114094","name":"Shaaron Lewis"}],"max_over":"10","target":"117","recent_scores":"5,4,6,1,4,4,6,0,1,6,6,0,2,6,0,4,3,1","last_five_overs":"95\/0 17.27","last_ten_overs":"119\/0 16.23"},"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":"119\/0 (6.3 ov)","scores":"119\/0","overs":"6.3"},{"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":"116\/9 (10 ov)","scores":"116\/9","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":"squad","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":"bowl","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":"83a755909e6368e461273b1c6273c4df","modified":"2025-07-25 18:03:32","datetime":"2025-07-25 18:03:32","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90637 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:86397fc2-64c2-44d9-b3f4-a97c5f6cbed1 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90637 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90637,3,'{"status":"ok","response":{"match_id":90637,"title":"SAMP Army Cocrico Cavaliers vs Soca Kings","short_title":"CCL vs SCK","subtitle":"Match 21","match_number":"21","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"SAMP Army Cocrico Cavaliers won by 10 wickets","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":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":"119\/0 (6.3 ov)","scores":"119\/0","overs":"6.3"},"teamb":{"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":"116\/9 (10 ov)","scores":"116\/9","overs":"10"},"date_start":"2025-06-17 21:00:00","date_end":"2025-06-18 07:00:00","timestamp_start":1750194000,"timestamp_end":1750230000,"date_start_ist":"2025-06-18 02:30:00","date_end_ist":"2025-06-18 12:30:00","venue":{"venue_id":"204","name":"Brian Lara Stadium","location":"Tarouba","country":"West Indies","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"CCL won by 10 wickets","result_type":1,"win_margin":"10 wickets","winning_team_id":123297,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-17 00:26:59","verify_time":"2025-06-18 04:42:17","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"scattered clouds","temp":24.81,"humidity":88,"visibility":10000,"wind_speed":"5.46","clouds":36},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Slow Spin"},"toss":{"text":"SAMP Army Cocrico Cavaliers elected to bowl","winner":123297,"decision":2}},"etag":"36c540cff7abd930388e1fe3a245c3e2","modified":"2025-07-25 18:03:33","datetime":"2025-07-25 18:03:33","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90637,"title":"SAMP Army Cocrico Cavaliers vs Soca Kings","short_title":"CCL vs SCK","subtitle":"Match 21","match_number":"21","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"SAMP Army Cocrico Cavaliers won by 10 wickets","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":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":"119\/0 (6.3 ov)","scores":"119\/0","overs":"6.3"},"teamb":{"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":"116\/9 (10 ov)","scores":"116\/9","overs":"10"},"date_start":"2025-06-17 21:00:00","date_end":"2025-06-18 07:00:00","timestamp_start":1750194000,"timestamp_end":1750230000,"date_start_ist":"2025-06-18 02:30:00","date_end_ist":"2025-06-18 12:30:00","venue":{"venue_id":"204","name":"Brian Lara Stadium","location":"Tarouba","country":"West Indies","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"CCL won by 10 wickets","result_type":1,"win_margin":"10 wickets","winning_team_id":123297,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-17 00:26:59","verify_time":"2025-06-18 04:42:17","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"scattered clouds","temp":24.81,"humidity":88,"visibility":10000,"wind_speed":"5.46","clouds":36},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Slow Spin"},"toss":{"text":"SAMP Army Cocrico Cavaliers elected to bowl","winner":123297,"decision":2}},"etag":"36c540cff7abd930388e1fe3a245c3e2","modified":"2025-07-25 18:03:33","datetime":"2025-07-25 18:03:33","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90637 AND DataTypeId = 3 END
Live Report & Scorecard of SAMP Army Cocrico Cavaliers vs Soca Kings Match 21