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:2b9ff4a8-f2dd-4cb6-ac72-8eb419638887 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90626 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90626,1,'{"status":"ok","response":{"mid":90626,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"SAMP Army Cocrico Cavaliers won by 8 wickets","day_remaining_over":"","team_batting":"SAMP Army Cocrico Cavaliers","team_bowling":"Bess Motors Blue Devils","live_inning_number":2,"live_score":{"runs":137,"overs":8.5,"wickets":2,"target":132,"runrate":15.51,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Leonardo Julien","batsman_id":96399,"runs":21,"balls_faced":7,"fours":2,"sixes":2,"strike_rate":"300.00"},{"name":"Jesse Bootan","batsman_id":114108,"runs":62,"balls_faced":29,"fours":3,"sixes":7,"strike_rate":"213.79"}],"bowlers":[{"name":"Danny Ramjit Singh","bowler_id":115843,"overs":0.5,"runs_conceded":13,"wickets":0,"maidens":0,"econ":"15.60"},{"name":"Kashtri Singh","bowler_id":114113,"overs":2,"runs_conceded":29,"wickets":0,"maidens":0,"econ":"14.50"}],"commentaries":[{"event_id":"12137793","event":"ball","batsman_id":"114108","bowler_id":"115829","over":"4","ball":"4","score":6,"commentary":"Justin Gangoo to Jesse Bootan, Six,","noball_dismissal":false,"text":"","timestamp":1749845272,"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":"12137814","event":"ball","batsman_id":"114108","bowler_id":"115829","over":"4","ball":"5","score":"1wd","commentary":"Justin Gangoo to Jesse Bootan, 1 wide,","noball_dismissal":false,"text":"","timestamp":1749845376,"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":"12137815","event":"ball","batsman_id":"114108","bowler_id":"115829","over":"4","ball":"5","score":0,"commentary":"Justin Gangoo to Jesse Bootan, no run,","noball_dismissal":false,"text":"","timestamp":1749845379,"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":"12137816","event":"ball","batsman_id":"114108","bowler_id":"115829","over":"4","ball":"6","score":1,"commentary":"Justin Gangoo to Jesse Bootan, 1 run,","noball_dismissal":false,"text":"","timestamp":1749845382,"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":5,"runs":19,"score":"83\/1","bats":[{"runs":39,"balls_faced":17,"fours":1,"sixes":5,"batsman_id":114108},{"runs":0,"balls_faced":0,"fours":0,"sixes":0,"batsman_id":117094}],"bowls":[{"runs_conceded":34,"maidens":0,"wickets":0,"bowler_id":115829,"overs":2},{"runs_conceded":14,"maidens":0,"wickets":1,"bowler_id":115830,"overs":1}],"commentary":"End of over 5 (19 runs), SAMP Army Cocrico Cavaliers 83\/1"},{"event_id":"12137858","event":"ball","batsman_id":"114108","bowler_id":"115830","over":"5","ball":"1","score":6,"commentary":"Samuel Roopnarine to Jesse Bootan, Six,","noball_dismissal":false,"text":"","timestamp":1749845675,"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":"12137859","event":"ball","batsman_id":"114108","bowler_id":"115830","over":"5","ball":"2","score":0,"commentary":"Samuel Roopnarine to Jesse Bootan, no run,","noball_dismissal":false,"text":"","timestamp":1749845678,"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":"12137861","event":"ball","batsman_id":"114108","bowler_id":"115830","over":"5","ball":"3","score":6,"commentary":"Samuel Roopnarine to Jesse Bootan, Six,","noball_dismissal":false,"text":"","timestamp":1749845681,"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":"12137886","event":"ball","batsman_id":"114108","bowler_id":"115830","over":"5","ball":"4","score":0,"commentary":"Samuel Roopnarine to Jesse Bootan, no run,","noball_dismissal":false,"text":"","timestamp":1749845684,"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":"12137897","event":"ball","batsman_id":"114108","bowler_id":"115830","over":"5","ball":"5","score":0,"commentary":"Samuel Roopnarine to Jesse Bootan, no run,","noball_dismissal":false,"text":"","timestamp":1749845781,"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":"12137898","event":"ball","batsman_id":"114108","bowler_id":"115830","over":"5","ball":"6","score":0,"commentary":"Samuel Roopnarine to Jesse Bootan, no run,","noball_dismissal":false,"text":"","timestamp":1749845785,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":6,"runs":12,"score":"95\/1","bats":[{"runs":51,"balls_faced":23,"fours":1,"sixes":7,"batsman_id":114108},{"runs":0,"balls_faced":0,"fours":0,"sixes":0,"batsman_id":117094}],"bowls":[{"runs_conceded":26,"maidens":0,"wickets":1,"bowler_id":115830,"overs":2},{"runs_conceded":34,"maidens":0,"wickets":0,"bowler_id":115829,"overs":2}],"commentary":"End of over 6 (12 runs), SAMP Army Cocrico Cavaliers 95\/1"},{"event_id":"12137904","event":"ball","batsman_id":"117094","bowler_id":"114110","over":"6","ball":"1","score":0,"commentary":"Rivaldo Ramlogan to Kyle Ramdoo, no run,","noball_dismissal":false,"text":"","timestamp":1749845856,"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":"12137911","event":"ball","batsman_id":"117094","bowler_id":"114110","over":"6","ball":"2","score":4,"commentary":"Rivaldo Ramlogan to Kyle Ramdoo, Four,","noball_dismissal":false,"text":"","timestamp":1749845859,"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":"12137913","event":"ball","batsman_id":"117094","bowler_id":"114110","over":"6","ball":"3","score":6,"commentary":"Rivaldo Ramlogan to Kyle Ramdoo, Six,","noball_dismissal":false,"text":"","timestamp":1749845861,"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":"12137935","event":"wicket","batsman_id":"117094","bowler_id":"114110","over":"6","ball":"4","score":"w","commentary":"Rivaldo Ramlogan to Kyle Ramdoo, no run, b R Ramlogan,","noball_dismissal":false,"text":"","timestamp":1749845927,"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":"b R Ramlogan","batsman_runs":"10","batsman_balls":"4"},{"event_id":"12137958","event":"ball","batsman_id":"96399","bowler_id":"114110","over":"6","ball":"5","score":4,"commentary":"Rivaldo Ramlogan to Leonardo Julien, Four,","noball_dismissal":false,"text":"","timestamp":1749846040,"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":"12137967","event":"ball","batsman_id":"96399","bowler_id":"114110","over":"6","ball":"6","score":4,"commentary":"Rivaldo Ramlogan to Leonardo Julien, Four,","noball_dismissal":false,"text":"","timestamp":1749846087,"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":7,"runs":18,"score":"113\/2","bats":[{"runs":8,"balls_faced":2,"fours":2,"sixes":0,"batsman_id":96399},{"runs":51,"balls_faced":23,"fours":1,"sixes":7,"batsman_id":114108}],"bowls":[{"runs_conceded":18,"maidens":0,"wickets":1,"bowler_id":114110,"overs":1},{"runs_conceded":26,"maidens":0,"wickets":1,"bowler_id":115830,"overs":2}],"commentary":"End of over 7 (18 runs), SAMP Army Cocrico Cavaliers 113\/2"},{"event_id":"12137975","event":"ball","batsman_id":"114108","bowler_id":"114113","over":"7","ball":"1","score":4,"commentary":"Kashtri Singh to Jesse Bootan, Four,","noball_dismissal":false,"text":"","timestamp":1749846150,"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":"12137979","event":"ball","batsman_id":"114108","bowler_id":"114113","over":"7","ball":"2","score":1,"commentary":"Kashtri Singh to Jesse Bootan, 1 run,","noball_dismissal":false,"text":"","timestamp":1749846176,"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":"12137989","event":"ball","batsman_id":"96399","bowler_id":"114113","over":"7","ball":"3","score":1,"commentary":"Kashtri Singh to Leonardo Julien, 1 run,","noball_dismissal":false,"text":"","timestamp":1749846306,"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":"12137991","event":"ball","batsman_id":"114108","bowler_id":"114113","over":"7","ball":"4","score":0,"commentary":"Kashtri Singh to Jesse Bootan, no run,","noball_dismissal":false,"text":"","timestamp":1749846309,"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":"12137992","event":"ball","batsman_id":"114108","bowler_id":"114113","over":"7","ball":"5","score":4,"commentary":"Kashtri Singh to Jesse Bootan, Four,","noball_dismissal":false,"text":"","timestamp":1749846313,"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":"12137999","event":"ball","batsman_id":"114108","bowler_id":"114113","over":"7","ball":"6","score":1,"commentary":"Kashtri Singh to Jesse Bootan, 1 run,","noball_dismissal":false,"text":"","timestamp":1749846347,"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":11,"score":"124\/2","bats":[{"runs":61,"balls_faced":28,"fours":3,"sixes":7,"batsman_id":114108},{"runs":9,"balls_faced":3,"fours":2,"sixes":0,"batsman_id":96399}],"bowls":[{"runs_conceded":29,"maidens":0,"wickets":0,"bowler_id":114113,"overs":2},{"runs_conceded":18,"maidens":0,"wickets":1,"bowler_id":114110,"overs":1}],"commentary":"End of over 8 (11 runs), SAMP Army Cocrico Cavaliers 124\/2"},{"event_id":"12138010","event":"ball","batsman_id":"114108","bowler_id":"115843","over":"8","ball":"1","score":1,"commentary":"Danny Ramjit Singh to Jesse Bootan, 1 run,","noball_dismissal":false,"text":"","timestamp":1749846548,"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":"12138011","event":"ball","batsman_id":"96399","bowler_id":"115843","over":"8","ball":"2","score":0,"commentary":"Danny Ramjit Singh to Leonardo Julien, no run,","noball_dismissal":false,"text":"","timestamp":1749846552,"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":"12138012","event":"ball","batsman_id":"96399","bowler_id":"115843","over":"8","ball":"3","score":0,"commentary":"Danny Ramjit Singh to Leonardo Julien, no run,","noball_dismissal":false,"text":"","timestamp":1749846554,"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":"12138022","event":"ball","batsman_id":"96399","bowler_id":"115843","over":"8","ball":"4","score":6,"commentary":"Danny Ramjit Singh to Leonardo Julien, Six,","noball_dismissal":false,"text":"","timestamp":1749846557,"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":"12138024","event":"ball","batsman_id":"96399","bowler_id":"115843","over":"8","ball":"5","score":6,"commentary":"Danny Ramjit Singh to Leonardo Julien, Six,","noball_dismissal":false,"text":"","timestamp":1749846560,"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}],"day":"0","session":"0","live_inning":{"iid":198010,"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":123295,"scores":"137\/2","scores_full":"137\/2 (8.5 ov)","fielder":[{"fielder_id":"121763","fielder_name":"Adrian Sehzad Ali","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":"10","balls":"4","how_out":"b R Ramlogan","score_at_dismissal":105,"overs_at_dismissal":"6.4","bowler_id":"114110","dismissal":"bowled","number":2},"extra_runs":{"byes":0,"legbyes":0,"wides":13,"noballs":1,"penalty":"0","total":14},"equations":{"runs":137,"wickets":2,"overs":"8.5","bowlers_used":6,"runrate":"15.51"},"current_partnership":{"runs":32,"balls":13,"overs":2.1,"batsmen":[{"name":"Leonardo Julien","batsman_id":96399,"runs":21,"balls":7},{"name":"Jesse Bootan","batsman_id":114108,"runs":11,"balls":6}]},"did_not_bat":[{"player_id":"52202","name":"Saiba Batoosingh"},{"player_id":"114085","name":"Justin Joseph"},{"player_id":"127451","name":"Abdul Raheem-Toppin"},{"player_id":"96615","name":"Avinash Mahabirsingh"},{"player_id":"121766","name":"Jordan Samkaran"},{"player_id":"138825","name":"Aneal Rooplal"},{"player_id":"114094","name":"Shaaron Lewis"}],"max_over":"10","target":"132","recent_scores":"6,6,0,0,1,1,4,0,1,1,4,4,4,w,6,4,0,0","last_five_overs":"73\/2 13.69","last_ten_overs":"137\/2 13.26"},"teams":[{"tid":123295,"title":"Bess Motors Blue Devils","abbr":"BLD","alt_name":"Bess Motors Blue Devils","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/BLD-CR1@2x.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/BLD-CR1@2x.png","country":"wi","sex":"male","team_owner":"","head_coach":"","scores_full":"131\/4 (10 ov)","scores":"131\/4","overs":"10"},{"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":"137\/2 (8.5 ov)","scores":"137\/2","overs":"8.5"}],"players":[{"pid":1212,"title":"Kirstan Kallicharan","short_name":"K Kallicharan","first_name":"Kirstan Kallicharan","last_name":"","middle_name":"","birthdate":"1999-12-29","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"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":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":59904,"title":"Ricky Jaipaul","short_name":"R Jaipaul","first_name":"Ricky Jaipaul","last_name":"","middle_name":"","birthdate":"1992-03-03","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","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":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":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":114089,"title":"Kamil Pooran","short_name":"K Pooran","first_name":"Kamil Pooran","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":114090,"title":"Crystian Thurton","short_name":"C Thurton","first_name":"Crystian Thurton","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":"wk","role_str":"(WK)"},{"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":114110,"title":"Rivaldo Ramlogan","short_name":"R Ramlogan","first_name":"Rivaldo Ramlogan","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":114113,"title":"Kashtri Singh","short_name":"K Singh","first_name":"Kashtri Singh","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":114125,"title":"Kiedel Glasgow","short_name":"K Glasgow","first_name":"Kiedel Glasgow","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":115816,"title":"Brandon Boodoo","short_name":"B Boodoo","first_name":"Brandon Boodoo","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":"squad","role_str":""},{"pid":115829,"title":"Justin Gangoo","short_name":"J Gangoo","first_name":"Justin Gangoo","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":115830,"title":"Samuel Roopnarine","short_name":"S Roopnarine","first_name":"Samuel Roopnarine","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":115843,"title":"Danny Ramjit Singh","short_name":"D R Singh","first_name":"Danny Ramjit Singh","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":116995,"title":"Rajeev Ramnath","short_name":"R Ramnath","first_name":"Rajeev Ramnath","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":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":121763,"title":"Adrian Sehzad Ali","short_name":"A S Ali","first_name":"Adrian Sehzad Ali","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(C)"},{"pid":121764,"title":"Teshawn Castro","short_name":"T Castro","first_name":"Teshawn Castro","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"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":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":"squad","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":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":"ec165173aabf9679bcc549f7e60b7e68","modified":"2025-07-24 20:37:24","datetime":"2025-07-24 20:37:24","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":90626,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"SAMP Army Cocrico Cavaliers won by 8 wickets","day_remaining_over":"","team_batting":"SAMP Army Cocrico Cavaliers","team_bowling":"Bess Motors Blue Devils","live_inning_number":2,"live_score":{"runs":137,"overs":8.5,"wickets":2,"target":132,"runrate":15.51,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Leonardo Julien","batsman_id":96399,"runs":21,"balls_faced":7,"fours":2,"sixes":2,"strike_rate":"300.00"},{"name":"Jesse Bootan","batsman_id":114108,"runs":62,"balls_faced":29,"fours":3,"sixes":7,"strike_rate":"213.79"}],"bowlers":[{"name":"Danny Ramjit Singh","bowler_id":115843,"overs":0.5,"runs_conceded":13,"wickets":0,"maidens":0,"econ":"15.60"},{"name":"Kashtri Singh","bowler_id":114113,"overs":2,"runs_conceded":29,"wickets":0,"maidens":0,"econ":"14.50"}],"commentaries":[{"event_id":"12137793","event":"ball","batsman_id":"114108","bowler_id":"115829","over":"4","ball":"4","score":6,"commentary":"Justin Gangoo to Jesse Bootan, Six,","noball_dismissal":false,"text":"","timestamp":1749845272,"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":"12137814","event":"ball","batsman_id":"114108","bowler_id":"115829","over":"4","ball":"5","score":"1wd","commentary":"Justin Gangoo to Jesse Bootan, 1 wide,","noball_dismissal":false,"text":"","timestamp":1749845376,"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":"12137815","event":"ball","batsman_id":"114108","bowler_id":"115829","over":"4","ball":"5","score":0,"commentary":"Justin Gangoo to Jesse Bootan, no run,","noball_dismissal":false,"text":"","timestamp":1749845379,"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":"12137816","event":"ball","batsman_id":"114108","bowler_id":"115829","over":"4","ball":"6","score":1,"commentary":"Justin Gangoo to Jesse Bootan, 1 run,","noball_dismissal":false,"text":"","timestamp":1749845382,"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":5,"runs":19,"score":"83\/1","bats":[{"runs":39,"balls_faced":17,"fours":1,"sixes":5,"batsman_id":114108},{"runs":0,"balls_faced":0,"fours":0,"sixes":0,"batsman_id":117094}],"bowls":[{"runs_conceded":34,"maidens":0,"wickets":0,"bowler_id":115829,"overs":2},{"runs_conceded":14,"maidens":0,"wickets":1,"bowler_id":115830,"overs":1}],"commentary":"End of over 5 (19 runs), SAMP Army Cocrico Cavaliers 83\/1"},{"event_id":"12137858","event":"ball","batsman_id":"114108","bowler_id":"115830","over":"5","ball":"1","score":6,"commentary":"Samuel Roopnarine to Jesse Bootan, Six,","noball_dismissal":false,"text":"","timestamp":1749845675,"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":"12137859","event":"ball","batsman_id":"114108","bowler_id":"115830","over":"5","ball":"2","score":0,"commentary":"Samuel Roopnarine to Jesse Bootan, no run,","noball_dismissal":false,"text":"","timestamp":1749845678,"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":"12137861","event":"ball","batsman_id":"114108","bowler_id":"115830","over":"5","ball":"3","score":6,"commentary":"Samuel Roopnarine to Jesse Bootan, Six,","noball_dismissal":false,"text":"","timestamp":1749845681,"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":"12137886","event":"ball","batsman_id":"114108","bowler_id":"115830","over":"5","ball":"4","score":0,"commentary":"Samuel Roopnarine to Jesse Bootan, no run,","noball_dismissal":false,"text":"","timestamp":1749845684,"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":"12137897","event":"ball","batsman_id":"114108","bowler_id":"115830","over":"5","ball":"5","score":0,"commentary":"Samuel Roopnarine to Jesse Bootan, no run,","noball_dismissal":false,"text":"","timestamp":1749845781,"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":"12137898","event":"ball","batsman_id":"114108","bowler_id":"115830","over":"5","ball":"6","score":0,"commentary":"Samuel Roopnarine to Jesse Bootan, no run,","noball_dismissal":false,"text":"","timestamp":1749845785,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":6,"runs":12,"score":"95\/1","bats":[{"runs":51,"balls_faced":23,"fours":1,"sixes":7,"batsman_id":114108},{"runs":0,"balls_faced":0,"fours":0,"sixes":0,"batsman_id":117094}],"bowls":[{"runs_conceded":26,"maidens":0,"wickets":1,"bowler_id":115830,"overs":2},{"runs_conceded":34,"maidens":0,"wickets":0,"bowler_id":115829,"overs":2}],"commentary":"End of over 6 (12 runs), SAMP Army Cocrico Cavaliers 95\/1"},{"event_id":"12137904","event":"ball","batsman_id":"117094","bowler_id":"114110","over":"6","ball":"1","score":0,"commentary":"Rivaldo Ramlogan to Kyle Ramdoo, no run,","noball_dismissal":false,"text":"","timestamp":1749845856,"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":"12137911","event":"ball","batsman_id":"117094","bowler_id":"114110","over":"6","ball":"2","score":4,"commentary":"Rivaldo Ramlogan to Kyle Ramdoo, Four,","noball_dismissal":false,"text":"","timestamp":1749845859,"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":"12137913","event":"ball","batsman_id":"117094","bowler_id":"114110","over":"6","ball":"3","score":6,"commentary":"Rivaldo Ramlogan to Kyle Ramdoo, Six,","noball_dismissal":false,"text":"","timestamp":1749845861,"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":"12137935","event":"wicket","batsman_id":"117094","bowler_id":"114110","over":"6","ball":"4","score":"w","commentary":"Rivaldo Ramlogan to Kyle Ramdoo, no run, b R Ramlogan,","noball_dismissal":false,"text":"","timestamp":1749845927,"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":"b R Ramlogan","batsman_runs":"10","batsman_balls":"4"},{"event_id":"12137958","event":"ball","batsman_id":"96399","bowler_id":"114110","over":"6","ball":"5","score":4,"commentary":"Rivaldo Ramlogan to Leonardo Julien, Four,","noball_dismissal":false,"text":"","timestamp":1749846040,"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":"12137967","event":"ball","batsman_id":"96399","bowler_id":"114110","over":"6","ball":"6","score":4,"commentary":"Rivaldo Ramlogan to Leonardo Julien, Four,","noball_dismissal":false,"text":"","timestamp":1749846087,"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":7,"runs":18,"score":"113\/2","bats":[{"runs":8,"balls_faced":2,"fours":2,"sixes":0,"batsman_id":96399},{"runs":51,"balls_faced":23,"fours":1,"sixes":7,"batsman_id":114108}],"bowls":[{"runs_conceded":18,"maidens":0,"wickets":1,"bowler_id":114110,"overs":1},{"runs_conceded":26,"maidens":0,"wickets":1,"bowler_id":115830,"overs":2}],"commentary":"End of over 7 (18 runs), SAMP Army Cocrico Cavaliers 113\/2"},{"event_id":"12137975","event":"ball","batsman_id":"114108","bowler_id":"114113","over":"7","ball":"1","score":4,"commentary":"Kashtri Singh to Jesse Bootan, Four,","noball_dismissal":false,"text":"","timestamp":1749846150,"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":"12137979","event":"ball","batsman_id":"114108","bowler_id":"114113","over":"7","ball":"2","score":1,"commentary":"Kashtri Singh to Jesse Bootan, 1 run,","noball_dismissal":false,"text":"","timestamp":1749846176,"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":"12137989","event":"ball","batsman_id":"96399","bowler_id":"114113","over":"7","ball":"3","score":1,"commentary":"Kashtri Singh to Leonardo Julien, 1 run,","noball_dismissal":false,"text":"","timestamp":1749846306,"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":"12137991","event":"ball","batsman_id":"114108","bowler_id":"114113","over":"7","ball":"4","score":0,"commentary":"Kashtri Singh to Jesse Bootan, no run,","noball_dismissal":false,"text":"","timestamp":1749846309,"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":"12137992","event":"ball","batsman_id":"114108","bowler_id":"114113","over":"7","ball":"5","score":4,"commentary":"Kashtri Singh to Jesse Bootan, Four,","noball_dismissal":false,"text":"","timestamp":1749846313,"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":"12137999","event":"ball","batsman_id":"114108","bowler_id":"114113","over":"7","ball":"6","score":1,"commentary":"Kashtri Singh to Jesse Bootan, 1 run,","noball_dismissal":false,"text":"","timestamp":1749846347,"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":11,"score":"124\/2","bats":[{"runs":61,"balls_faced":28,"fours":3,"sixes":7,"batsman_id":114108},{"runs":9,"balls_faced":3,"fours":2,"sixes":0,"batsman_id":96399}],"bowls":[{"runs_conceded":29,"maidens":0,"wickets":0,"bowler_id":114113,"overs":2},{"runs_conceded":18,"maidens":0,"wickets":1,"bowler_id":114110,"overs":1}],"commentary":"End of over 8 (11 runs), SAMP Army Cocrico Cavaliers 124\/2"},{"event_id":"12138010","event":"ball","batsman_id":"114108","bowler_id":"115843","over":"8","ball":"1","score":1,"commentary":"Danny Ramjit Singh to Jesse Bootan, 1 run,","noball_dismissal":false,"text":"","timestamp":1749846548,"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":"12138011","event":"ball","batsman_id":"96399","bowler_id":"115843","over":"8","ball":"2","score":0,"commentary":"Danny Ramjit Singh to Leonardo Julien, no run,","noball_dismissal":false,"text":"","timestamp":1749846552,"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":"12138012","event":"ball","batsman_id":"96399","bowler_id":"115843","over":"8","ball":"3","score":0,"commentary":"Danny Ramjit Singh to Leonardo Julien, no run,","noball_dismissal":false,"text":"","timestamp":1749846554,"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":"12138022","event":"ball","batsman_id":"96399","bowler_id":"115843","over":"8","ball":"4","score":6,"commentary":"Danny Ramjit Singh to Leonardo Julien, Six,","noball_dismissal":false,"text":"","timestamp":1749846557,"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":"12138024","event":"ball","batsman_id":"96399","bowler_id":"115843","over":"8","ball":"5","score":6,"commentary":"Danny Ramjit Singh to Leonardo Julien, Six,","noball_dismissal":false,"text":"","timestamp":1749846560,"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}],"day":"0","session":"0","live_inning":{"iid":198010,"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":123295,"scores":"137\/2","scores_full":"137\/2 (8.5 ov)","fielder":[{"fielder_id":"121763","fielder_name":"Adrian Sehzad Ali","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":"10","balls":"4","how_out":"b R Ramlogan","score_at_dismissal":105,"overs_at_dismissal":"6.4","bowler_id":"114110","dismissal":"bowled","number":2},"extra_runs":{"byes":0,"legbyes":0,"wides":13,"noballs":1,"penalty":"0","total":14},"equations":{"runs":137,"wickets":2,"overs":"8.5","bowlers_used":6,"runrate":"15.51"},"current_partnership":{"runs":32,"balls":13,"overs":2.1,"batsmen":[{"name":"Leonardo Julien","batsman_id":96399,"runs":21,"balls":7},{"name":"Jesse Bootan","batsman_id":114108,"runs":11,"balls":6}]},"did_not_bat":[{"player_id":"52202","name":"Saiba Batoosingh"},{"player_id":"114085","name":"Justin Joseph"},{"player_id":"127451","name":"Abdul Raheem-Toppin"},{"player_id":"96615","name":"Avinash Mahabirsingh"},{"player_id":"121766","name":"Jordan Samkaran"},{"player_id":"138825","name":"Aneal Rooplal"},{"player_id":"114094","name":"Shaaron Lewis"}],"max_over":"10","target":"132","recent_scores":"6,6,0,0,1,1,4,0,1,1,4,4,4,w,6,4,0,0","last_five_overs":"73\/2 13.69","last_ten_overs":"137\/2 13.26"},"teams":[{"tid":123295,"title":"Bess Motors Blue Devils","abbr":"BLD","alt_name":"Bess Motors Blue Devils","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/BLD-CR1@2x.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/BLD-CR1@2x.png","country":"wi","sex":"male","team_owner":"","head_coach":"","scores_full":"131\/4 (10 ov)","scores":"131\/4","overs":"10"},{"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":"137\/2 (8.5 ov)","scores":"137\/2","overs":"8.5"}],"players":[{"pid":1212,"title":"Kirstan Kallicharan","short_name":"K Kallicharan","first_name":"Kirstan Kallicharan","last_name":"","middle_name":"","birthdate":"1999-12-29","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"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":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":59904,"title":"Ricky Jaipaul","short_name":"R Jaipaul","first_name":"Ricky Jaipaul","last_name":"","middle_name":"","birthdate":"1992-03-03","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","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":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":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":114089,"title":"Kamil Pooran","short_name":"K Pooran","first_name":"Kamil Pooran","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":114090,"title":"Crystian Thurton","short_name":"C Thurton","first_name":"Crystian Thurton","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":"wk","role_str":"(WK)"},{"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":114110,"title":"Rivaldo Ramlogan","short_name":"R Ramlogan","first_name":"Rivaldo Ramlogan","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":114113,"title":"Kashtri Singh","short_name":"K Singh","first_name":"Kashtri Singh","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":114125,"title":"Kiedel Glasgow","short_name":"K Glasgow","first_name":"Kiedel Glasgow","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":115816,"title":"Brandon Boodoo","short_name":"B Boodoo","first_name":"Brandon Boodoo","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":"squad","role_str":""},{"pid":115829,"title":"Justin Gangoo","short_name":"J Gangoo","first_name":"Justin Gangoo","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":115830,"title":"Samuel Roopnarine","short_name":"S Roopnarine","first_name":"Samuel Roopnarine","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":115843,"title":"Danny Ramjit Singh","short_name":"D R Singh","first_name":"Danny Ramjit Singh","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":116995,"title":"Rajeev Ramnath","short_name":"R Ramnath","first_name":"Rajeev Ramnath","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":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":121763,"title":"Adrian Sehzad Ali","short_name":"A S Ali","first_name":"Adrian Sehzad Ali","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(C)"},{"pid":121764,"title":"Teshawn Castro","short_name":"T Castro","first_name":"Teshawn Castro","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"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":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":"squad","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":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":"ec165173aabf9679bcc549f7e60b7e68","modified":"2025-07-24 20:37:24","datetime":"2025-07-24 20:37:24","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90626 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:8f49b2d0-fc71-450e-a856-743e1fd87049 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90626 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90626,3,'{"status":"ok","response":{"match_id":90626,"title":"Bess Motors Blue Devils vs SAMP Army Cocrico Cavaliers","short_title":"BLD vs CCL","subtitle":"Match 10","match_number":"10","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"SAMP Army Cocrico Cavaliers won by 8 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":123295,"name":"Bess Motors Blue Devils","short_name":"BLD","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/BLD-CR1@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/BLD-CR1@2x.png","scores_full":"131\/4 (10 ov)","scores":"131\/4","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":"137\/2 (8.5 ov)","scores":"137\/2","overs":"8.5"},"date_start":"2025-06-13 18:30:00","date_end":"2025-06-14 04:30:00","timestamp_start":1749839400,"timestamp_end":1749875400,"date_start_ist":"2025-06-14 00:00:00","date_end_ist":"2025-06-14 10:00:00","venue":{"venue_id":"204","name":"Brian Lara Stadium","location":"Tarouba","country":"West Indies","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"CCL won by 8 wickets","result_type":2,"win_margin":"8 wickets","winning_team_id":123297,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-13 00:41:13","verify_time":"2025-06-14 02:16:05","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":26.39,"humidity":77,"visibility":10000,"wind_speed":"9.31","clouds":100},"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":"ec165173aabf9679bcc549f7e60b7e68","modified":"2025-07-24 20:37:24","datetime":"2025-07-24 20:37:24","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90626,"title":"Bess Motors Blue Devils vs SAMP Army Cocrico Cavaliers","short_title":"BLD vs CCL","subtitle":"Match 10","match_number":"10","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"SAMP Army Cocrico Cavaliers won by 8 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":123295,"name":"Bess Motors Blue Devils","short_name":"BLD","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/BLD-CR1@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/BLD-CR1@2x.png","scores_full":"131\/4 (10 ov)","scores":"131\/4","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":"137\/2 (8.5 ov)","scores":"137\/2","overs":"8.5"},"date_start":"2025-06-13 18:30:00","date_end":"2025-06-14 04:30:00","timestamp_start":1749839400,"timestamp_end":1749875400,"date_start_ist":"2025-06-14 00:00:00","date_end_ist":"2025-06-14 10:00:00","venue":{"venue_id":"204","name":"Brian Lara Stadium","location":"Tarouba","country":"West Indies","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"CCL won by 8 wickets","result_type":2,"win_margin":"8 wickets","winning_team_id":123297,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-13 00:41:13","verify_time":"2025-06-14 02:16:05","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":26.39,"humidity":77,"visibility":10000,"wind_speed":"9.31","clouds":100},"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":"ec165173aabf9679bcc549f7e60b7e68","modified":"2025-07-24 20:37:24","datetime":"2025-07-24 20:37:24","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90626 AND DataTypeId = 3 END
Live Report & Scorecard of Bess Motors Blue Devils vs SAMP Army Cocrico Cavaliers Match 10