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:18c20c85-9b2c-46e2-9c74-fe24d6d90bc4 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90635 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90635,1,'{"status":"ok","response":{"mid":90635,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Bess Motors Blue Devils won by 30 runs","day_remaining_over":"","team_batting":"Chicago Steelpan Players","team_bowling":"Bess Motors Blue Devils","live_inning_number":2,"live_score":{"runs":109,"overs":10,"wickets":4,"target":140,"runrate":10.9,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Clevon Kalawan","batsman_id":52205,"runs":1,"balls_faced":1,"fours":0,"sixes":0,"strike_rate":"100.00"},{"name":"Navin Bidaisee","batsman_id":114147,"runs":10,"balls_faced":9,"fours":0,"sixes":1,"strike_rate":"111.11"}],"bowlers":[{"name":"Kamil Pooran","bowler_id":114089,"overs":1,"runs_conceded":6,"wickets":1,"maidens":0,"econ":"6.00"},{"name":"Justin Gangoo","bowler_id":115829,"overs":1,"runs_conceded":17,"wickets":0,"maidens":0,"econ":"17.00"}],"commentaries":[{"event_id":"12162933","event":"ball","batsman_id":"127908","bowler_id":"114110","over":"6","ball":"1","score":6,"commentary":"Rivaldo Ramlogan to Silus Cooper, Six,","noball_dismissal":false,"text":"","timestamp":1750181866,"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":"12162941","event":"ball","batsman_id":"127908","bowler_id":"114110","over":"6","ball":"2","score":4,"commentary":"Rivaldo Ramlogan to Silus Cooper, Four,","noball_dismissal":false,"text":"","timestamp":1750181997,"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":"12162942","event":"wicket","batsman_id":"127908","bowler_id":"114110","over":"6","ball":"3","score":"w","commentary":"Rivaldo Ramlogan to Silus Cooper, no run, c R Jaipaul b R Ramlogan,","noball_dismissal":false,"text":"","timestamp":1750182000,"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":"127908","how_out":"c R Jaipaul b R Ramlogan","batsman_runs":"44","batsman_balls":"20"},{"event_id":"12162950","event":"ball","batsman_id":"114147","bowler_id":"114110","over":"6","ball":"4","score":0,"commentary":"Rivaldo Ramlogan to Navin Bidaisee, no run,","noball_dismissal":false,"text":"","timestamp":1750182196,"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":"12162951","event":"ball","batsman_id":"114147","bowler_id":"114110","over":"6","ball":"5","score":0,"commentary":"Rivaldo Ramlogan to Navin Bidaisee, no run,","noball_dismissal":false,"text":"","timestamp":1750182198,"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":"12162952","event":"ball","batsman_id":"114147","bowler_id":"114110","over":"6","ball":"6","score":0,"commentary":"Rivaldo Ramlogan to Navin Bidaisee, no run,","noball_dismissal":false,"text":"","timestamp":1750182200,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":7,"runs":10,"score":"73\/3","bats":[{"runs":0,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":114147},{"runs":10,"balls_faced":6,"fours":0,"sixes":1,"batsman_id":92364}],"bowls":[{"runs_conceded":25,"maidens":0,"wickets":2,"bowler_id":114110,"overs":2},{"runs_conceded":19,"maidens":0,"wickets":1,"bowler_id":115830,"overs":2}],"commentary":"End of over 7 (10 runs), Chicago Steelpan Players 73\/3"},{"event_id":"12162966","event":"ball","batsman_id":"92364","bowler_id":"114113","over":"7","ball":"1","score":4,"commentary":"Kashtri Singh to Akiel Cooper, Four,","noball_dismissal":false,"text":"","timestamp":1750182203,"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":"12162970","event":"ball","batsman_id":"92364","bowler_id":"114113","over":"7","ball":"2","score":1,"commentary":"Kashtri Singh to Akiel Cooper, 1 run,","noball_dismissal":false,"text":"","timestamp":1750182301,"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":"12162978","event":"ball","batsman_id":"114147","bowler_id":"114113","over":"7","ball":"3","score":1,"commentary":"Kashtri Singh to Navin Bidaisee, 1 run,","noball_dismissal":false,"text":"","timestamp":1750182354,"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":"12162989","event":"ball","batsman_id":"92364","bowler_id":"114113","over":"7","ball":"4","score":6,"commentary":"Kashtri Singh to Akiel Cooper, Six,","noball_dismissal":false,"text":"","timestamp":1750182357,"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":"12162990","event":"ball","batsman_id":"92364","bowler_id":"114113","over":"7","ball":"5","score":0,"commentary":"Kashtri Singh to Akiel Cooper, no run,","noball_dismissal":false,"text":"","timestamp":1750182385,"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":"12162994","event":"ball","batsman_id":"92364","bowler_id":"114113","over":"7","ball":"6","score":1,"commentary":"Kashtri Singh to Akiel Cooper, 1 run,","noball_dismissal":false,"text":"","timestamp":1750182521,"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":13,"score":"86\/3","bats":[{"runs":22,"balls_faced":11,"fours":1,"sixes":2,"batsman_id":92364},{"runs":1,"balls_faced":4,"fours":0,"sixes":0,"batsman_id":114147}],"bowls":[{"runs_conceded":28,"maidens":0,"wickets":0,"bowler_id":114113,"overs":2},{"runs_conceded":25,"maidens":0,"wickets":2,"bowler_id":114110,"overs":2}],"commentary":"End of over 8 (13 runs), Chicago Steelpan Players 86\/3"},{"event_id":"12163008","event":"ball","batsman_id":"92364","bowler_id":"115829","over":"8","ball":"1","score":0,"commentary":"Justin Gangoo to Akiel Cooper, no run,","noball_dismissal":false,"text":"","timestamp":1750182524,"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":"12163009","event":"ball","batsman_id":"92364","bowler_id":"115829","over":"8","ball":"2","score":"1wd","commentary":"Justin Gangoo to Akiel Cooper, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750182528,"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":"12163010","event":"ball","batsman_id":"92364","bowler_id":"115829","over":"8","ball":"2","score":"1wd","commentary":"Justin Gangoo to Akiel Cooper, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750182530,"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":"12163013","event":"ball","batsman_id":"92364","bowler_id":"115829","over":"8","ball":"2","score":"1wd","commentary":"Justin Gangoo to Akiel Cooper, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750182563,"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":"12163018","event":"ball","batsman_id":"92364","bowler_id":"115829","over":"8","ball":"2","score":1,"commentary":"Justin Gangoo to Akiel Cooper, 1 run,","noball_dismissal":false,"text":"","timestamp":1750182656,"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":"12163024","event":"ball","batsman_id":"114147","bowler_id":"115829","over":"8","ball":"3","score":0,"commentary":"Justin Gangoo to Navin Bidaisee, no run,","noball_dismissal":false,"text":"","timestamp":1750182659,"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":"12163025","event":"ball","batsman_id":"114147","bowler_id":"115829","over":"8","ball":"4","score":6,"commentary":"Justin Gangoo to Navin Bidaisee, Six,","noball_dismissal":false,"text":"","timestamp":1750182732,"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":"12163037","event":"ball","batsman_id":"114147","bowler_id":"115829","over":"8","ball":"5","score":1,"commentary":"Justin Gangoo to Navin Bidaisee, 1 run,","noball_dismissal":false,"text":"","timestamp":1750182734,"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":"12163039","event":"ball","batsman_id":"92364","bowler_id":"115829","over":"8","ball":"6","score":6,"commentary":"Justin Gangoo to Akiel Cooper, Six,","noball_dismissal":false,"text":"","timestamp":1750182853,"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":9,"runs":17,"score":"103\/3","bats":[{"runs":29,"balls_faced":14,"fours":1,"sixes":3,"batsman_id":92364},{"runs":8,"balls_faced":7,"fours":0,"sixes":1,"batsman_id":114147}],"bowls":[{"runs_conceded":17,"maidens":0,"wickets":0,"bowler_id":115829,"overs":1},{"runs_conceded":28,"maidens":0,"wickets":0,"bowler_id":114113,"overs":2}],"commentary":"End of over 9 (17 runs), Chicago Steelpan Players 103\/3"},{"event_id":"12163047","event":"ball","batsman_id":"114147","bowler_id":"114089","over":"9","ball":"1","score":1,"commentary":"Kamil Pooran to Navin Bidaisee, 1 run,","noball_dismissal":false,"text":"","timestamp":1750182855,"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":"12163049","event":"ball","batsman_id":"92364","bowler_id":"114089","over":"9","ball":"2","score":1,"commentary":"Kamil Pooran to Akiel Cooper, 1 run,","noball_dismissal":false,"text":"","timestamp":1750182894,"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":"12163056","event":"ball","batsman_id":"114147","bowler_id":"114089","over":"9","ball":"3","score":1,"commentary":"Kamil Pooran to Navin Bidaisee, 1 run,","noball_dismissal":false,"text":"","timestamp":1750182899,"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":"12163061","event":"ball","batsman_id":"92364","bowler_id":"114089","over":"9","ball":"4","score":2,"commentary":"Kamil Pooran to Akiel Cooper, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750182973,"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":"12163063","event":"wicket","batsman_id":"92364","bowler_id":"114089","over":"9","ball":"5","score":"w","commentary":"Kamil Pooran to Akiel Cooper, no run, c R Jaipaul b K Pooran,","noball_dismissal":false,"text":"","timestamp":1750182976,"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":"92364","how_out":"c R Jaipaul b K Pooran","batsman_runs":"32","batsman_balls":"17"},{"event_id":"12163073","event":"ball","batsman_id":"52205","bowler_id":"114089","over":"9","ball":"6","score":1,"commentary":"Kamil Pooran to Clevon Kalawan, 1 run,","noball_dismissal":false,"text":"","timestamp":1750183047,"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":10,"runs":6,"score":"109\/4","bats":[{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":52205},{"runs":10,"balls_faced":9,"fours":0,"sixes":1,"batsman_id":114147}],"bowls":[{"runs_conceded":6,"maidens":0,"wickets":1,"bowler_id":114089,"overs":1},{"runs_conceded":17,"maidens":0,"wickets":0,"bowler_id":115829,"overs":1}],"commentary":"End of over 10 (6 runs), Chicago Steelpan Players 109\/4"}],"day":"0","session":"0","live_inning":{"iid":198268,"number":2,"name":"Chicago Steelpan Players Inning","short_name":"CSP Inning","status":2,"issuperover":"false","result":4,"batting_team_id":128981,"fielding_team_id":123295,"scores":"109\/4","scores_full":"109\/4 (10 ov)","fielder":[{"fielder_id":"59904","fielder_name":"Ricky Jaipaul","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"115843","fielder_name":"Danny Ramjit Singh","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":"Akiel Cooper","batsman_id":"92364","runs":"32","balls":"17","how_out":"c R Jaipaul b K Pooran","score_at_dismissal":108,"overs_at_dismissal":"9.5","bowler_id":"114089","dismissal":"caught","number":4},"extra_runs":{"byes":0,"legbyes":1,"wides":6,"noballs":0,"penalty":"0","total":7},"equations":{"runs":109,"wickets":4,"overs":"10","bowlers_used":6,"runrate":"10.90"},"current_partnership":{"runs":1,"balls":1,"overs":0.1,"batsmen":[{"name":"Clevon Kalawan","batsman_id":52205,"runs":1,"balls":1},{"name":"Navin Bidaisee","batsman_id":114147,"runs":0,"balls":0}]},"did_not_bat":[{"player_id":"147506","name":"Brandon Ramdial"},{"player_id":"116994","name":"James Duncan"},{"player_id":"91890","name":"Ryan Hurley"},{"player_id":"109938","name":"Anderson Mahase"},{"player_id":"115823","name":"Ramesh Brijlal"}],"max_over":"10","target":"140","recent_scores":"1,w,2,1,1,1,6,1,6,0,1,1,1,1,0,1,0,6","last_five_overs":"57\/2 10.06","last_ten_overs":"109\/4 9.91"},"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":"139\/4 (10 ov)","scores":"139\/4","overs":"10"},{"tid":128981,"title":"Chicago Steelpan Players","abbr":"CSP","alt_name":"Chicago Steelpan Players","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Chicago-Steelpan-Players.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Chicago-Steelpan-Players.png","country":"wi","sex":"male","team_owner":"","head_coach":"","scores_full":"109\/4 (10 ov)","scores":"109\/4","overs":"10"}],"players":[{"pid":1206,"title":"Jyd Goolie","short_name":"J Goolie","first_name":"Jyd Goolie","last_name":"","middle_name":"","birthdate":"1997-05-11","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":"squad","role_str":""},{"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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":50138,"title":"Mark Deyal","short_name":"M Deyal","first_name":"Mark Deyal","last_name":"","middle_name":"","birthdate":"1993-04-07","birthplace":" Diego Martin","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":"https:\/\/www.instagram.com\/markdeyal\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":"(C)"},{"pid":52205,"title":"Clevon Kalawan","short_name":"C Kalawan","first_name":"Clevon Kalawan","last_name":"","middle_name":"","birthdate":"1996-11-12","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":91890,"title":"Ryan Hurley","short_name":"RO Hurley","first_name":"Ryan Hurley","last_name":"","middle_name":"","birthdate":"1975-09-13","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":92364,"title":"Akiel Cooper","short_name":"A Cooper","first_name":"Akiel Cooper","last_name":"","middle_name":"","birthdate":"1990-11-26","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":109938,"title":"Anderson Mahase","short_name":"Anderson Mahase","first_name":"Anderson Mahase","last_name":"","middle_name":"","birthdate":"2003-01-24","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":""},{"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.5,"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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":114147,"title":"Navin Bidaisee","short_name":"N Bidaisee","first_name":"Navin Bidaisee","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":""},{"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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":115823,"title":"Ramesh Brijlal","short_name":"R Brijlal","first_name":"Ramesh Brijlal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":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.5,"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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":116994,"title":"James Duncan","short_name":"J Duncan","first_name":"James Duncan","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":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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","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":"(WK\/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":127857,"title":"Sidel Diaz","short_name":"S Diaz","first_name":"Sidel Diaz","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":127908,"title":"Silus Cooper","short_name":"S Cooper","first_name":"Silus Cooper","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":139141,"title":"Sivan Ramkissoon","short_name":"S Ramkissoon","first_name":"Sivan Ramkissoon","last_name":"","middle_name":"","birthdate":"2000-10-01","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":145181,"title":"Akash Rooplal","short_name":"A Rooplal","first_name":"Akash Rooplal","last_name":"","middle_name":"","birthdate":"1991-02-20","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":147506,"title":"Brandon Ramdial","short_name":"B Ramdial","first_name":"Brandon Ramdial","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)"}]},"etag":"e05bc58305dc32072dea5e5a540fd350","modified":"2025-07-24 19:33:37","datetime":"2025-07-24 19:33:37","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":90635,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Bess Motors Blue Devils won by 30 runs","day_remaining_over":"","team_batting":"Chicago Steelpan Players","team_bowling":"Bess Motors Blue Devils","live_inning_number":2,"live_score":{"runs":109,"overs":10,"wickets":4,"target":140,"runrate":10.9,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Clevon Kalawan","batsman_id":52205,"runs":1,"balls_faced":1,"fours":0,"sixes":0,"strike_rate":"100.00"},{"name":"Navin Bidaisee","batsman_id":114147,"runs":10,"balls_faced":9,"fours":0,"sixes":1,"strike_rate":"111.11"}],"bowlers":[{"name":"Kamil Pooran","bowler_id":114089,"overs":1,"runs_conceded":6,"wickets":1,"maidens":0,"econ":"6.00"},{"name":"Justin Gangoo","bowler_id":115829,"overs":1,"runs_conceded":17,"wickets":0,"maidens":0,"econ":"17.00"}],"commentaries":[{"event_id":"12162933","event":"ball","batsman_id":"127908","bowler_id":"114110","over":"6","ball":"1","score":6,"commentary":"Rivaldo Ramlogan to Silus Cooper, Six,","noball_dismissal":false,"text":"","timestamp":1750181866,"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":"12162941","event":"ball","batsman_id":"127908","bowler_id":"114110","over":"6","ball":"2","score":4,"commentary":"Rivaldo Ramlogan to Silus Cooper, Four,","noball_dismissal":false,"text":"","timestamp":1750181997,"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":"12162942","event":"wicket","batsman_id":"127908","bowler_id":"114110","over":"6","ball":"3","score":"w","commentary":"Rivaldo Ramlogan to Silus Cooper, no run, c R Jaipaul b R Ramlogan,","noball_dismissal":false,"text":"","timestamp":1750182000,"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":"127908","how_out":"c R Jaipaul b R Ramlogan","batsman_runs":"44","batsman_balls":"20"},{"event_id":"12162950","event":"ball","batsman_id":"114147","bowler_id":"114110","over":"6","ball":"4","score":0,"commentary":"Rivaldo Ramlogan to Navin Bidaisee, no run,","noball_dismissal":false,"text":"","timestamp":1750182196,"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":"12162951","event":"ball","batsman_id":"114147","bowler_id":"114110","over":"6","ball":"5","score":0,"commentary":"Rivaldo Ramlogan to Navin Bidaisee, no run,","noball_dismissal":false,"text":"","timestamp":1750182198,"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":"12162952","event":"ball","batsman_id":"114147","bowler_id":"114110","over":"6","ball":"6","score":0,"commentary":"Rivaldo Ramlogan to Navin Bidaisee, no run,","noball_dismissal":false,"text":"","timestamp":1750182200,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":7,"runs":10,"score":"73\/3","bats":[{"runs":0,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":114147},{"runs":10,"balls_faced":6,"fours":0,"sixes":1,"batsman_id":92364}],"bowls":[{"runs_conceded":25,"maidens":0,"wickets":2,"bowler_id":114110,"overs":2},{"runs_conceded":19,"maidens":0,"wickets":1,"bowler_id":115830,"overs":2}],"commentary":"End of over 7 (10 runs), Chicago Steelpan Players 73\/3"},{"event_id":"12162966","event":"ball","batsman_id":"92364","bowler_id":"114113","over":"7","ball":"1","score":4,"commentary":"Kashtri Singh to Akiel Cooper, Four,","noball_dismissal":false,"text":"","timestamp":1750182203,"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":"12162970","event":"ball","batsman_id":"92364","bowler_id":"114113","over":"7","ball":"2","score":1,"commentary":"Kashtri Singh to Akiel Cooper, 1 run,","noball_dismissal":false,"text":"","timestamp":1750182301,"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":"12162978","event":"ball","batsman_id":"114147","bowler_id":"114113","over":"7","ball":"3","score":1,"commentary":"Kashtri Singh to Navin Bidaisee, 1 run,","noball_dismissal":false,"text":"","timestamp":1750182354,"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":"12162989","event":"ball","batsman_id":"92364","bowler_id":"114113","over":"7","ball":"4","score":6,"commentary":"Kashtri Singh to Akiel Cooper, Six,","noball_dismissal":false,"text":"","timestamp":1750182357,"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":"12162990","event":"ball","batsman_id":"92364","bowler_id":"114113","over":"7","ball":"5","score":0,"commentary":"Kashtri Singh to Akiel Cooper, no run,","noball_dismissal":false,"text":"","timestamp":1750182385,"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":"12162994","event":"ball","batsman_id":"92364","bowler_id":"114113","over":"7","ball":"6","score":1,"commentary":"Kashtri Singh to Akiel Cooper, 1 run,","noball_dismissal":false,"text":"","timestamp":1750182521,"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":13,"score":"86\/3","bats":[{"runs":22,"balls_faced":11,"fours":1,"sixes":2,"batsman_id":92364},{"runs":1,"balls_faced":4,"fours":0,"sixes":0,"batsman_id":114147}],"bowls":[{"runs_conceded":28,"maidens":0,"wickets":0,"bowler_id":114113,"overs":2},{"runs_conceded":25,"maidens":0,"wickets":2,"bowler_id":114110,"overs":2}],"commentary":"End of over 8 (13 runs), Chicago Steelpan Players 86\/3"},{"event_id":"12163008","event":"ball","batsman_id":"92364","bowler_id":"115829","over":"8","ball":"1","score":0,"commentary":"Justin Gangoo to Akiel Cooper, no run,","noball_dismissal":false,"text":"","timestamp":1750182524,"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":"12163009","event":"ball","batsman_id":"92364","bowler_id":"115829","over":"8","ball":"2","score":"1wd","commentary":"Justin Gangoo to Akiel Cooper, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750182528,"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":"12163010","event":"ball","batsman_id":"92364","bowler_id":"115829","over":"8","ball":"2","score":"1wd","commentary":"Justin Gangoo to Akiel Cooper, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750182530,"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":"12163013","event":"ball","batsman_id":"92364","bowler_id":"115829","over":"8","ball":"2","score":"1wd","commentary":"Justin Gangoo to Akiel Cooper, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750182563,"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":"12163018","event":"ball","batsman_id":"92364","bowler_id":"115829","over":"8","ball":"2","score":1,"commentary":"Justin Gangoo to Akiel Cooper, 1 run,","noball_dismissal":false,"text":"","timestamp":1750182656,"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":"12163024","event":"ball","batsman_id":"114147","bowler_id":"115829","over":"8","ball":"3","score":0,"commentary":"Justin Gangoo to Navin Bidaisee, no run,","noball_dismissal":false,"text":"","timestamp":1750182659,"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":"12163025","event":"ball","batsman_id":"114147","bowler_id":"115829","over":"8","ball":"4","score":6,"commentary":"Justin Gangoo to Navin Bidaisee, Six,","noball_dismissal":false,"text":"","timestamp":1750182732,"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":"12163037","event":"ball","batsman_id":"114147","bowler_id":"115829","over":"8","ball":"5","score":1,"commentary":"Justin Gangoo to Navin Bidaisee, 1 run,","noball_dismissal":false,"text":"","timestamp":1750182734,"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":"12163039","event":"ball","batsman_id":"92364","bowler_id":"115829","over":"8","ball":"6","score":6,"commentary":"Justin Gangoo to Akiel Cooper, Six,","noball_dismissal":false,"text":"","timestamp":1750182853,"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":9,"runs":17,"score":"103\/3","bats":[{"runs":29,"balls_faced":14,"fours":1,"sixes":3,"batsman_id":92364},{"runs":8,"balls_faced":7,"fours":0,"sixes":1,"batsman_id":114147}],"bowls":[{"runs_conceded":17,"maidens":0,"wickets":0,"bowler_id":115829,"overs":1},{"runs_conceded":28,"maidens":0,"wickets":0,"bowler_id":114113,"overs":2}],"commentary":"End of over 9 (17 runs), Chicago Steelpan Players 103\/3"},{"event_id":"12163047","event":"ball","batsman_id":"114147","bowler_id":"114089","over":"9","ball":"1","score":1,"commentary":"Kamil Pooran to Navin Bidaisee, 1 run,","noball_dismissal":false,"text":"","timestamp":1750182855,"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":"12163049","event":"ball","batsman_id":"92364","bowler_id":"114089","over":"9","ball":"2","score":1,"commentary":"Kamil Pooran to Akiel Cooper, 1 run,","noball_dismissal":false,"text":"","timestamp":1750182894,"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":"12163056","event":"ball","batsman_id":"114147","bowler_id":"114089","over":"9","ball":"3","score":1,"commentary":"Kamil Pooran to Navin Bidaisee, 1 run,","noball_dismissal":false,"text":"","timestamp":1750182899,"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":"12163061","event":"ball","batsman_id":"92364","bowler_id":"114089","over":"9","ball":"4","score":2,"commentary":"Kamil Pooran to Akiel Cooper, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750182973,"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":"12163063","event":"wicket","batsman_id":"92364","bowler_id":"114089","over":"9","ball":"5","score":"w","commentary":"Kamil Pooran to Akiel Cooper, no run, c R Jaipaul b K Pooran,","noball_dismissal":false,"text":"","timestamp":1750182976,"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":"92364","how_out":"c R Jaipaul b K Pooran","batsman_runs":"32","batsman_balls":"17"},{"event_id":"12163073","event":"ball","batsman_id":"52205","bowler_id":"114089","over":"9","ball":"6","score":1,"commentary":"Kamil Pooran to Clevon Kalawan, 1 run,","noball_dismissal":false,"text":"","timestamp":1750183047,"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":10,"runs":6,"score":"109\/4","bats":[{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":52205},{"runs":10,"balls_faced":9,"fours":0,"sixes":1,"batsman_id":114147}],"bowls":[{"runs_conceded":6,"maidens":0,"wickets":1,"bowler_id":114089,"overs":1},{"runs_conceded":17,"maidens":0,"wickets":0,"bowler_id":115829,"overs":1}],"commentary":"End of over 10 (6 runs), Chicago Steelpan Players 109\/4"}],"day":"0","session":"0","live_inning":{"iid":198268,"number":2,"name":"Chicago Steelpan Players Inning","short_name":"CSP Inning","status":2,"issuperover":"false","result":4,"batting_team_id":128981,"fielding_team_id":123295,"scores":"109\/4","scores_full":"109\/4 (10 ov)","fielder":[{"fielder_id":"59904","fielder_name":"Ricky Jaipaul","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"115843","fielder_name":"Danny Ramjit Singh","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":"Akiel Cooper","batsman_id":"92364","runs":"32","balls":"17","how_out":"c R Jaipaul b K Pooran","score_at_dismissal":108,"overs_at_dismissal":"9.5","bowler_id":"114089","dismissal":"caught","number":4},"extra_runs":{"byes":0,"legbyes":1,"wides":6,"noballs":0,"penalty":"0","total":7},"equations":{"runs":109,"wickets":4,"overs":"10","bowlers_used":6,"runrate":"10.90"},"current_partnership":{"runs":1,"balls":1,"overs":0.1,"batsmen":[{"name":"Clevon Kalawan","batsman_id":52205,"runs":1,"balls":1},{"name":"Navin Bidaisee","batsman_id":114147,"runs":0,"balls":0}]},"did_not_bat":[{"player_id":"147506","name":"Brandon Ramdial"},{"player_id":"116994","name":"James Duncan"},{"player_id":"91890","name":"Ryan Hurley"},{"player_id":"109938","name":"Anderson Mahase"},{"player_id":"115823","name":"Ramesh Brijlal"}],"max_over":"10","target":"140","recent_scores":"1,w,2,1,1,1,6,1,6,0,1,1,1,1,0,1,0,6","last_five_overs":"57\/2 10.06","last_ten_overs":"109\/4 9.91"},"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":"139\/4 (10 ov)","scores":"139\/4","overs":"10"},{"tid":128981,"title":"Chicago Steelpan Players","abbr":"CSP","alt_name":"Chicago Steelpan Players","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Chicago-Steelpan-Players.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Chicago-Steelpan-Players.png","country":"wi","sex":"male","team_owner":"","head_coach":"","scores_full":"109\/4 (10 ov)","scores":"109\/4","overs":"10"}],"players":[{"pid":1206,"title":"Jyd Goolie","short_name":"J Goolie","first_name":"Jyd Goolie","last_name":"","middle_name":"","birthdate":"1997-05-11","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":"squad","role_str":""},{"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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":50138,"title":"Mark Deyal","short_name":"M Deyal","first_name":"Mark Deyal","last_name":"","middle_name":"","birthdate":"1993-04-07","birthplace":" Diego Martin","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":"https:\/\/www.instagram.com\/markdeyal\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":"(C)"},{"pid":52205,"title":"Clevon Kalawan","short_name":"C Kalawan","first_name":"Clevon Kalawan","last_name":"","middle_name":"","birthdate":"1996-11-12","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":91890,"title":"Ryan Hurley","short_name":"RO Hurley","first_name":"Ryan Hurley","last_name":"","middle_name":"","birthdate":"1975-09-13","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":92364,"title":"Akiel Cooper","short_name":"A Cooper","first_name":"Akiel Cooper","last_name":"","middle_name":"","birthdate":"1990-11-26","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":109938,"title":"Anderson Mahase","short_name":"Anderson Mahase","first_name":"Anderson Mahase","last_name":"","middle_name":"","birthdate":"2003-01-24","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":""},{"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.5,"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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":114147,"title":"Navin Bidaisee","short_name":"N Bidaisee","first_name":"Navin Bidaisee","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":""},{"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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":115823,"title":"Ramesh Brijlal","short_name":"R Brijlal","first_name":"Ramesh Brijlal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":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.5,"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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":116994,"title":"James Duncan","short_name":"J Duncan","first_name":"James Duncan","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":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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","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":"(WK\/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":127857,"title":"Sidel Diaz","short_name":"S Diaz","first_name":"Sidel Diaz","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":127908,"title":"Silus Cooper","short_name":"S Cooper","first_name":"Silus Cooper","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":139141,"title":"Sivan Ramkissoon","short_name":"S Ramkissoon","first_name":"Sivan Ramkissoon","last_name":"","middle_name":"","birthdate":"2000-10-01","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":145181,"title":"Akash Rooplal","short_name":"A Rooplal","first_name":"Akash Rooplal","last_name":"","middle_name":"","birthdate":"1991-02-20","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":147506,"title":"Brandon Ramdial","short_name":"B Ramdial","first_name":"Brandon Ramdial","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)"}]},"etag":"e05bc58305dc32072dea5e5a540fd350","modified":"2025-07-24 19:33:37","datetime":"2025-07-24 19:33:37","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90635 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:18c20c85-9b2c-46e2-9c74-fe24d6d90bc4 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90635 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90635,3,'{"status":"ok","response":{"match_id":90635,"title":"Chicago Steelpan Players vs Bess Motors Blue Devils","short_title":"CSP vs BLD","subtitle":"Match 19","match_number":"19","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Bess Motors Blue Devils won by 30 runs","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129622,"title":"Trinidad T10 Blast, 7th Edition","abbr":"Trinidad T10","type":"tournament","category":"domestic","match_format":"t10","season":"2025","status":"live","datestart":"2025-06-09","dateend":"2025-06-22","country":"wi","total_matches":"30","total_rounds":"1","total_teams":"6"},"teama":{"team_id":128981,"name":"Chicago Steelpan Players","short_name":"CSP","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Chicago-Steelpan-Players.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Chicago-Steelpan-Players.png","scores_full":"109\/4 (10 ov)","scores":"109\/4","overs":"10"},"teamb":{"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":"139\/4 (10 ov)","scores":"139\/4","overs":"10"},"date_start":"2025-06-17 16:00:00","date_end":"2025-06-18 02:00:00","timestamp_start":1750176000,"timestamp_end":1750212000,"date_start_ist":"2025-06-17 21:30:00","date_end_ist":"2025-06-18 07:30:00","venue":{"venue_id":"204","name":"Brian Lara Stadium","location":"Tarouba","country":"West Indies","timezone":""},"umpires":" Trevlon Williams (West Indies), Avinash Narine (West Indies)","referee":"Ramsahai Ramasar (West Indies)","equation":"","live":"","result":"BLD won by 30 runs","result_type":2,"win_margin":"30 runs","winning_team_id":123295,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-16 10:59:24","verify_time":"2025-06-17 23:38:04","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Rain","weather_desc":"light rain","temp":30.08,"humidity":63,"visibility":10000,"wind_speed":"8.19","clouds":28},"pitch":{"pitch_condition":"","batting_condition":"Average","pace_bowling_condition":"Average","spine_bowling_condition":"Average"},"toss":{"text":"Chicago Steelpan Players elected to bowl","winner":128981,"decision":2}},"etag":"b058d8ec51395bcfe5438466185a5779","modified":"2025-07-24 19:33:38","datetime":"2025-07-24 19:33:38","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90635,"title":"Chicago Steelpan Players vs Bess Motors Blue Devils","short_title":"CSP vs BLD","subtitle":"Match 19","match_number":"19","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Bess Motors Blue Devils won by 30 runs","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129622,"title":"Trinidad T10 Blast, 7th Edition","abbr":"Trinidad T10","type":"tournament","category":"domestic","match_format":"t10","season":"2025","status":"live","datestart":"2025-06-09","dateend":"2025-06-22","country":"wi","total_matches":"30","total_rounds":"1","total_teams":"6"},"teama":{"team_id":128981,"name":"Chicago Steelpan Players","short_name":"CSP","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Chicago-Steelpan-Players.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Chicago-Steelpan-Players.png","scores_full":"109\/4 (10 ov)","scores":"109\/4","overs":"10"},"teamb":{"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":"139\/4 (10 ov)","scores":"139\/4","overs":"10"},"date_start":"2025-06-17 16:00:00","date_end":"2025-06-18 02:00:00","timestamp_start":1750176000,"timestamp_end":1750212000,"date_start_ist":"2025-06-17 21:30:00","date_end_ist":"2025-06-18 07:30:00","venue":{"venue_id":"204","name":"Brian Lara Stadium","location":"Tarouba","country":"West Indies","timezone":""},"umpires":" Trevlon Williams (West Indies), Avinash Narine (West Indies)","referee":"Ramsahai Ramasar (West Indies)","equation":"","live":"","result":"BLD won by 30 runs","result_type":2,"win_margin":"30 runs","winning_team_id":123295,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-16 10:59:24","verify_time":"2025-06-17 23:38:04","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Rain","weather_desc":"light rain","temp":30.08,"humidity":63,"visibility":10000,"wind_speed":"8.19","clouds":28},"pitch":{"pitch_condition":"","batting_condition":"Average","pace_bowling_condition":"Average","spine_bowling_condition":"Average"},"toss":{"text":"Chicago Steelpan Players elected to bowl","winner":128981,"decision":2}},"etag":"b058d8ec51395bcfe5438466185a5779","modified":"2025-07-24 19:33:38","datetime":"2025-07-24 19:33:38","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90635 AND DataTypeId = 3 END
Live Report & Scorecard of Chicago Steelpan Players vs Bess Motors Blue Devils Match 19