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:538af871-5b57-4ca5-9701-b8e7421d3753 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90625 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90625,1,'{"status":"ok","response":{"mid":90625,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Soca Kings won by 8 wickets","day_remaining_over":"","team_batting":"Soca Kings","team_bowling":"Leatherback Strikers","live_inning_number":2,"live_score":{"runs":77,"overs":5.4,"wickets":2,"target":76,"runrate":13.59,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Joshua James","batsman_id":96611,"runs":41,"balls_faced":16,"fours":3,"sixes":4,"strike_rate":"256.25"},{"name":"Dejourn Charles","batsman_id":52292,"runs":33,"balls_faced":16,"fours":2,"sixes":3,"strike_rate":"206.25"}],"bowlers":[{"name":"Junior Bailey","bowler_id":140979,"overs":1.4,"runs_conceded":20,"wickets":0,"maidens":0,"econ":"12.00"},{"name":"Damion Joachim","bowler_id":115822,"overs":1,"runs_conceded":27,"wickets":0,"maidens":0,"econ":"27.00"}],"commentaries":[{"event_id":"12135798","event":"ball","batsman_id":"52292","bowler_id":"93261","over":"1","ball":"3","score":6,"commentary":"Uthman Muhammad to Dejourn Charles, Six,","noball_dismissal":false,"text":"","timestamp":1749835536,"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":"12135800","event":"ball","batsman_id":"52292","bowler_id":"93261","over":"1","ball":"4","score":3,"commentary":"Uthman Muhammad to Dejourn Charles, 3 runs,","noball_dismissal":false,"text":"","timestamp":1749835544,"run":3,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"3","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12135807","event":"ball","batsman_id":"96611","bowler_id":"93261","over":"1","ball":"5","score":0,"commentary":"Uthman Muhammad to Joshua James, no run,","noball_dismissal":false,"text":"","timestamp":1749835627,"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":"12135870","event":"ball","batsman_id":"96611","bowler_id":"93261","over":"1","ball":"6","score":6,"commentary":"Uthman Muhammad to Joshua James, Six,","noball_dismissal":false,"text":"","timestamp":1749835951,"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":2,"runs":19,"score":"20\/2","bats":[{"runs":6,"balls_faced":4,"fours":0,"sixes":1,"batsman_id":96611},{"runs":14,"balls_faced":6,"fours":1,"sixes":1,"batsman_id":52292}],"bowls":[{"runs_conceded":19,"maidens":0,"wickets":0,"bowler_id":93261,"overs":1},{"runs_conceded":1,"maidens":0,"wickets":1,"bowler_id":93874,"overs":1}],"commentary":"End of over 2 (19 runs), Soca Kings 20\/2"},{"event_id":"12135873","event":"ball","batsman_id":"52292","bowler_id":"114083","over":"2","ball":"1","score":0,"commentary":"Christopher Vincent to Dejourn Charles, no run,","noball_dismissal":false,"text":"","timestamp":1749835953,"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":"12135874","event":"ball","batsman_id":"52292","bowler_id":"114083","over":"2","ball":"2","score":1,"commentary":"Christopher Vincent to Dejourn Charles, 1 run,","noball_dismissal":false,"text":"","timestamp":1749835956,"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":"12135876","event":"ball","batsman_id":"96611","bowler_id":"114083","over":"2","ball":"3","score":"3wd","commentary":"Christopher Vincent to Joshua James, 3 wide,","noball_dismissal":false,"text":"","timestamp":1749836117,"run":3,"noball_run":"0","wide_run":"3","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12135877","event":"ball","batsman_id":"96611","bowler_id":"114083","over":"2","ball":"3","score":1,"commentary":"Christopher Vincent to Joshua James, 1 run,","noball_dismissal":false,"text":"","timestamp":1749835961,"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":"12135880","event":"ball","batsman_id":"52292","bowler_id":"114083","over":"2","ball":"4","score":4,"commentary":"Christopher Vincent to Dejourn Charles, Four,","noball_dismissal":false,"text":"","timestamp":1749835963,"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":"12135881","event":"ball","batsman_id":"52292","bowler_id":"114083","over":"2","ball":"5","score":0,"commentary":"Christopher Vincent to Dejourn Charles, no run,","noball_dismissal":false,"text":"","timestamp":1749835966,"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":"12135918","event":"ball","batsman_id":"52292","bowler_id":"114083","over":"2","ball":"6","score":1,"commentary":"Christopher Vincent to Dejourn Charles, 1 run,","noball_dismissal":false,"text":"","timestamp":1749836155,"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":3,"runs":10,"score":"30\/2","bats":[{"runs":20,"balls_faced":11,"fours":2,"sixes":1,"batsman_id":52292},{"runs":7,"balls_faced":5,"fours":0,"sixes":1,"batsman_id":96611}],"bowls":[{"runs_conceded":10,"maidens":0,"wickets":0,"bowler_id":114083,"overs":1},{"runs_conceded":19,"maidens":0,"wickets":0,"bowler_id":93261,"overs":1}],"commentary":"End of over 3 (10 runs), Soca Kings 30\/2"},{"event_id":"12135948","event":"ball","batsman_id":"52292","bowler_id":"140979","over":"3","ball":"1","score":0,"commentary":"Junior Bailey to Dejourn Charles, no run,","noball_dismissal":false,"text":"","timestamp":1749836269,"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":"12135949","event":"ball","batsman_id":"52292","bowler_id":"140979","over":"3","ball":"2","score":1,"commentary":"Junior Bailey to Dejourn Charles, 1 run,","noball_dismissal":false,"text":"","timestamp":1749836272,"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":"12135950","event":"ball","batsman_id":"96611","bowler_id":"140979","over":"3","ball":"3","score":0,"commentary":"Junior Bailey to Joshua James, no run,","noball_dismissal":false,"text":"","timestamp":1749836274,"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":"12135951","event":"ball","batsman_id":"96611","bowler_id":"140979","over":"3","ball":"4","score":1,"commentary":"Junior Bailey to Joshua James, 1 run,","noball_dismissal":false,"text":"","timestamp":1749836280,"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":"12135953","event":"ball","batsman_id":"52292","bowler_id":"140979","over":"3","ball":"5","score":0,"commentary":"Junior Bailey to Dejourn Charles, no run,","noball_dismissal":false,"text":"","timestamp":1749836288,"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":"12135954","event":"ball","batsman_id":"52292","bowler_id":"140979","over":"3","ball":"6","score":6,"commentary":"Junior Bailey to Dejourn Charles, Six,","noball_dismissal":false,"text":"","timestamp":1749836291,"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":4,"runs":8,"score":"38\/2","bats":[{"runs":27,"balls_faced":15,"fours":2,"sixes":2,"batsman_id":52292},{"runs":8,"balls_faced":7,"fours":0,"sixes":1,"batsman_id":96611}],"bowls":[{"runs_conceded":8,"maidens":0,"wickets":0,"bowler_id":140979,"overs":1},{"runs_conceded":10,"maidens":0,"wickets":0,"bowler_id":114083,"overs":1}],"commentary":"End of over 4 (8 runs), Soca Kings 38\/2"},{"event_id":"12135960","event":"ball","batsman_id":"96611","bowler_id":"115822","over":"4","ball":"1","score":4,"commentary":"Damion Joachim to Joshua James, Four,","noball_dismissal":false,"text":"","timestamp":1749836310,"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":"12135961","event":"ball","batsman_id":"96611","bowler_id":"115822","over":"4","ball":"2","score":6,"commentary":"Damion Joachim to Joshua James, Six,","noball_dismissal":false,"text":"","timestamp":1749836322,"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":"12135979","event":"ball","batsman_id":"96611","bowler_id":"115822","over":"4","ball":"3","score":4,"commentary":"Damion Joachim to Joshua James, Four,","noball_dismissal":false,"text":"","timestamp":1749836415,"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":"12135985","event":"ball","batsman_id":"96611","bowler_id":"115822","over":"4","ball":"4","score":6,"commentary":"Damion Joachim to Joshua James, Six,","noball_dismissal":false,"text":"","timestamp":1749836445,"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":"12136008","event":"ball","batsman_id":"96611","bowler_id":"115822","over":"4","ball":"5","score":1,"commentary":"Damion Joachim to Joshua James, 1 run,","noball_dismissal":false,"text":"","timestamp":1749836549,"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":"12136010","event":"ball","batsman_id":"52292","bowler_id":"115822","over":"4","ball":"6","score":6,"commentary":"Damion Joachim to Dejourn Charles, Six,","noball_dismissal":false,"text":"","timestamp":1749836552,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event":"overend","over":5,"runs":27,"score":"65\/2","bats":[{"runs":33,"balls_faced":16,"fours":2,"sixes":3,"batsman_id":52292},{"runs":29,"balls_faced":12,"fours":2,"sixes":3,"batsman_id":96611}],"bowls":[{"runs_conceded":27,"maidens":0,"wickets":0,"bowler_id":115822,"overs":1},{"runs_conceded":8,"maidens":0,"wickets":0,"bowler_id":140979,"overs":1}],"commentary":"End of over 5 (27 runs), Soca Kings 65\/2"},{"event_id":"12136032","event":"ball","batsman_id":"96611","bowler_id":"140979","over":"5","ball":"1","score":2,"commentary":"Junior Bailey to Joshua James, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749836652,"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":"12136033","event":"ball","batsman_id":"96611","bowler_id":"140979","over":"5","ball":"2","score":0,"commentary":"Junior Bailey to Joshua James, no run,","noball_dismissal":false,"text":"","timestamp":1749836655,"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":"12136035","event":"ball","batsman_id":"96611","bowler_id":"140979","over":"5","ball":"3","score":4,"commentary":"Junior Bailey to Joshua James, Four,","noball_dismissal":false,"text":"","timestamp":1749836665,"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":"12136040","event":"ball","batsman_id":"96611","bowler_id":"140979","over":"5","ball":"4","score":6,"commentary":"Junior Bailey to Joshua James, Six,","noball_dismissal":false,"text":"","timestamp":1749836710,"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":197991,"number":2,"name":"Soca Kings Inning","short_name":"SCK Inning","status":2,"issuperover":"false","result":3,"batting_team_id":123301,"fielding_team_id":128980,"scores":"77\/2","scores_full":"77\/2 (5.4 ov)","fielder":[{"fielder_id":"145177","fielder_name":"Kevin Ryan Ramasray","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"147342","fielder_name":"Rondel Ramlogan","catches":0,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":1,"stumping":0,"is_substitute":"true"}],"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":"Shatrughan Rambaran","batsman_id":"114121","runs":"0","balls":"1","how_out":"runout ( (sub R Ramlogan ))","score_at_dismissal":0,"overs_at_dismissal":"0.2","bowler_id":"0","dismissal":"runout","number":2},"extra_runs":{"byes":0,"legbyes":0,"wides":3,"noballs":0,"penalty":"0","total":3},"equations":{"runs":77,"wickets":2,"overs":"5.4","bowlers_used":5,"runrate":"13.59"},"current_partnership":{"runs":77,"balls":32,"overs":5.2,"batsmen":[{"name":"Dejourn Charles","batsman_id":52292,"runs":33,"balls":16},{"name":"Joshua James","batsman_id":96611,"runs":41,"balls":16}]},"did_not_bat":[{"player_id":"147508","name":"Christian Lall"},{"player_id":"147243","name":"Akeel Mohammed"},{"player_id":"127227","name":"Jon Russ Jagessar"},{"player_id":"90814","name":"Imran Khan"},{"player_id":"116243","name":"Aamir Ali"},{"player_id":"43338","name":"Rayad Emrit"},{"player_id":"114112","name":"Chadeon Raymond"}],"max_over":"10","target":"76","recent_scores":"6,4,0,2,6,1,6,4,6,4,6,0,1,0,1,0,1,0","last_five_overs":"76\/0 14.71","last_ten_overs":"77\/2 13.20"},"teams":[{"tid":123301,"title":"Soca Kings","abbr":"SCK","alt_name":"Soca Kings","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/SCK-CR1@2x.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/SCK-CR1@2x.png","country":"wi","sex":"male","team_owner":"","head_coach":"","scores_full":"77\/2 (5.4 ov)","scores":"77\/2","overs":"5.4"},{"tid":128980,"title":"Leatherback Strikers","abbr":"TLS","alt_name":"Leatherback Strikers","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Leatherback-Strikers.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Leatherback-Strikers.png","country":"wi","sex":"male","team_owner":"","head_coach":"","scores_full":"75\/3 (10 ov)","scores":"75\/3","overs":"10"}],"players":[{"pid":43338,"title":"Rayad Emrit","short_name":"RR Emrit","first_name":"Rayad Emrit","last_name":"","middle_name":"","birthdate":"1981-03-08","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/rayad51","instagram_profile":"https:\/\/www.instagram.com\/rayad51\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":50112,"title":"William Perkins","short_name":"WKD Perkins","first_name":"William Perkins","last_name":"","middle_name":"","birthdate":"1986-10-08","birthplace":"Barbados","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":52292,"title":"Dejourn Charles","short_name":"D Charles","first_name":"Dejourn Charles","last_name":"","middle_name":"","birthdate":"1997-10-12","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":90814,"title":"Imran Khan","short_name":"I Khan","first_name":"Imran Khan","last_name":"","middle_name":"","birthdate":"1984-07-06","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","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":90945,"title":"Tion Webster","short_name":"T Webster","first_name":"Tion Webster","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":93005,"title":"Ewart Nicholson","short_name":"E Nicholson","first_name":"Ewart Nicholson","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":93261,"title":"Uthman Muhammad","short_name":"U Muhammad","first_name":"Uthman Muhammad","last_name":"","middle_name":"","birthdate":"1989-03-01","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":93874,"title":"Terrance Hinds","short_name":"T Hinds","first_name":"Terrance Hinds","last_name":"","middle_name":"","birthdate":"1992-01-23","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/terrohinds64","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":96611,"title":"Joshua James","short_name":"J James","first_name":"Joshua James","last_name":"","middle_name":"","birthdate":"2001-02-21","birthplace":"Trinidad & Tobago","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":"(C)"},{"pid":109937,"title":"Sion Hackett","short_name":"S Hackett","first_name":"Sion Hackett","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":null,"role":"squad","role_str":""},{"pid":114083,"title":"Christopher Vincent","short_name":"C Vincent","first_name":"Christopher Vincent","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":114084,"title":"Vishan Jagessar","short_name":"V Jagessar","first_name":"Vishan Jagessar","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":"(C)"},{"pid":114112,"title":"Chadeon Raymond","short_name":"C Raymond","first_name":"Chadeon Raymond","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":114121,"title":"Shatrughan Rambaran","short_name":"S Rambaran","first_name":"Shatrughan Rambaran","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":115822,"title":"Damion Joachim","short_name":"D Joachim","first_name":"Damion Joachim","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":"all","role_str":""},{"pid":115835,"title":"Denzil Antoine","short_name":"D Antoine","first_name":"Denzil Antoine","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":115852,"title":"Suraj Seepaul","short_name":"S Seepaul","first_name":"Suraj Seepaul","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":116231,"title":"Tevon Jadoo","short_name":"T Jadoo","first_name":"Tevon Jadoo","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":116243,"title":"Aamir Ali","short_name":"A Ali","first_name":"Aamir Ali","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":127227,"title":"Jon Russ Jagessar","short_name":"Jon Jagessar","first_name":"Jon Russ Jagessar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":139127,"title":"Abdur Rahman Juman","short_name":"A R Juman","first_name":"Abdur Rahman Juman","last_name":"","middle_name":"","birthdate":"2003-11-14","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":140979,"title":"Junior Bailey","short_name":"J Bailey","first_name":"Junior Bailey","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":140982,"title":"Selwin Allert","short_name":"S Allert","first_name":"Selwin Allert","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":"all","role_str":""},{"pid":145177,"title":"Kevin Ryan Ramasray","short_name":"K R Ramasray","first_name":"Kevin Ryan Ramasray","last_name":"","middle_name":"","birthdate":"1993-05-19","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":147236,"title":"Trevon James","short_name":"T James","first_name":"Trevon James","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":""},{"pid":147243,"title":"Akeel Mohammed","short_name":"A Mohammed","first_name":"Akeel Mohammed","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":147342,"title":"Rondel Ramlogan","short_name":"R Ramlogan","first_name":"Rondel Ramlogan","last_name":"","middle_name":"","birthdate":"2004-11-08","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","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":147508,"title":"Christian Lall","short_name":"C Lall","first_name":"Christian Lall","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(WK)"},{"pid":149628,"title":"Nickolas Wellington","short_name":"N Wellington","first_name":"Nickolas Wellington","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":"bat","role_str":""}]},"etag":"f9bd1701bab740b075a1415ab40412a8","modified":"2025-07-08 18:48:54","datetime":"2025-07-08 18:48:54","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":90625,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Soca Kings won by 8 wickets","day_remaining_over":"","team_batting":"Soca Kings","team_bowling":"Leatherback Strikers","live_inning_number":2,"live_score":{"runs":77,"overs":5.4,"wickets":2,"target":76,"runrate":13.59,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Joshua James","batsman_id":96611,"runs":41,"balls_faced":16,"fours":3,"sixes":4,"strike_rate":"256.25"},{"name":"Dejourn Charles","batsman_id":52292,"runs":33,"balls_faced":16,"fours":2,"sixes":3,"strike_rate":"206.25"}],"bowlers":[{"name":"Junior Bailey","bowler_id":140979,"overs":1.4,"runs_conceded":20,"wickets":0,"maidens":0,"econ":"12.00"},{"name":"Damion Joachim","bowler_id":115822,"overs":1,"runs_conceded":27,"wickets":0,"maidens":0,"econ":"27.00"}],"commentaries":[{"event_id":"12135798","event":"ball","batsman_id":"52292","bowler_id":"93261","over":"1","ball":"3","score":6,"commentary":"Uthman Muhammad to Dejourn Charles, Six,","noball_dismissal":false,"text":"","timestamp":1749835536,"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":"12135800","event":"ball","batsman_id":"52292","bowler_id":"93261","over":"1","ball":"4","score":3,"commentary":"Uthman Muhammad to Dejourn Charles, 3 runs,","noball_dismissal":false,"text":"","timestamp":1749835544,"run":3,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"3","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12135807","event":"ball","batsman_id":"96611","bowler_id":"93261","over":"1","ball":"5","score":0,"commentary":"Uthman Muhammad to Joshua James, no run,","noball_dismissal":false,"text":"","timestamp":1749835627,"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":"12135870","event":"ball","batsman_id":"96611","bowler_id":"93261","over":"1","ball":"6","score":6,"commentary":"Uthman Muhammad to Joshua James, Six,","noball_dismissal":false,"text":"","timestamp":1749835951,"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":2,"runs":19,"score":"20\/2","bats":[{"runs":6,"balls_faced":4,"fours":0,"sixes":1,"batsman_id":96611},{"runs":14,"balls_faced":6,"fours":1,"sixes":1,"batsman_id":52292}],"bowls":[{"runs_conceded":19,"maidens":0,"wickets":0,"bowler_id":93261,"overs":1},{"runs_conceded":1,"maidens":0,"wickets":1,"bowler_id":93874,"overs":1}],"commentary":"End of over 2 (19 runs), Soca Kings 20\/2"},{"event_id":"12135873","event":"ball","batsman_id":"52292","bowler_id":"114083","over":"2","ball":"1","score":0,"commentary":"Christopher Vincent to Dejourn Charles, no run,","noball_dismissal":false,"text":"","timestamp":1749835953,"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":"12135874","event":"ball","batsman_id":"52292","bowler_id":"114083","over":"2","ball":"2","score":1,"commentary":"Christopher Vincent to Dejourn Charles, 1 run,","noball_dismissal":false,"text":"","timestamp":1749835956,"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":"12135876","event":"ball","batsman_id":"96611","bowler_id":"114083","over":"2","ball":"3","score":"3wd","commentary":"Christopher Vincent to Joshua James, 3 wide,","noball_dismissal":false,"text":"","timestamp":1749836117,"run":3,"noball_run":"0","wide_run":"3","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12135877","event":"ball","batsman_id":"96611","bowler_id":"114083","over":"2","ball":"3","score":1,"commentary":"Christopher Vincent to Joshua James, 1 run,","noball_dismissal":false,"text":"","timestamp":1749835961,"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":"12135880","event":"ball","batsman_id":"52292","bowler_id":"114083","over":"2","ball":"4","score":4,"commentary":"Christopher Vincent to Dejourn Charles, Four,","noball_dismissal":false,"text":"","timestamp":1749835963,"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":"12135881","event":"ball","batsman_id":"52292","bowler_id":"114083","over":"2","ball":"5","score":0,"commentary":"Christopher Vincent to Dejourn Charles, no run,","noball_dismissal":false,"text":"","timestamp":1749835966,"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":"12135918","event":"ball","batsman_id":"52292","bowler_id":"114083","over":"2","ball":"6","score":1,"commentary":"Christopher Vincent to Dejourn Charles, 1 run,","noball_dismissal":false,"text":"","timestamp":1749836155,"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":3,"runs":10,"score":"30\/2","bats":[{"runs":20,"balls_faced":11,"fours":2,"sixes":1,"batsman_id":52292},{"runs":7,"balls_faced":5,"fours":0,"sixes":1,"batsman_id":96611}],"bowls":[{"runs_conceded":10,"maidens":0,"wickets":0,"bowler_id":114083,"overs":1},{"runs_conceded":19,"maidens":0,"wickets":0,"bowler_id":93261,"overs":1}],"commentary":"End of over 3 (10 runs), Soca Kings 30\/2"},{"event_id":"12135948","event":"ball","batsman_id":"52292","bowler_id":"140979","over":"3","ball":"1","score":0,"commentary":"Junior Bailey to Dejourn Charles, no run,","noball_dismissal":false,"text":"","timestamp":1749836269,"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":"12135949","event":"ball","batsman_id":"52292","bowler_id":"140979","over":"3","ball":"2","score":1,"commentary":"Junior Bailey to Dejourn Charles, 1 run,","noball_dismissal":false,"text":"","timestamp":1749836272,"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":"12135950","event":"ball","batsman_id":"96611","bowler_id":"140979","over":"3","ball":"3","score":0,"commentary":"Junior Bailey to Joshua James, no run,","noball_dismissal":false,"text":"","timestamp":1749836274,"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":"12135951","event":"ball","batsman_id":"96611","bowler_id":"140979","over":"3","ball":"4","score":1,"commentary":"Junior Bailey to Joshua James, 1 run,","noball_dismissal":false,"text":"","timestamp":1749836280,"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":"12135953","event":"ball","batsman_id":"52292","bowler_id":"140979","over":"3","ball":"5","score":0,"commentary":"Junior Bailey to Dejourn Charles, no run,","noball_dismissal":false,"text":"","timestamp":1749836288,"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":"12135954","event":"ball","batsman_id":"52292","bowler_id":"140979","over":"3","ball":"6","score":6,"commentary":"Junior Bailey to Dejourn Charles, Six,","noball_dismissal":false,"text":"","timestamp":1749836291,"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":4,"runs":8,"score":"38\/2","bats":[{"runs":27,"balls_faced":15,"fours":2,"sixes":2,"batsman_id":52292},{"runs":8,"balls_faced":7,"fours":0,"sixes":1,"batsman_id":96611}],"bowls":[{"runs_conceded":8,"maidens":0,"wickets":0,"bowler_id":140979,"overs":1},{"runs_conceded":10,"maidens":0,"wickets":0,"bowler_id":114083,"overs":1}],"commentary":"End of over 4 (8 runs), Soca Kings 38\/2"},{"event_id":"12135960","event":"ball","batsman_id":"96611","bowler_id":"115822","over":"4","ball":"1","score":4,"commentary":"Damion Joachim to Joshua James, Four,","noball_dismissal":false,"text":"","timestamp":1749836310,"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":"12135961","event":"ball","batsman_id":"96611","bowler_id":"115822","over":"4","ball":"2","score":6,"commentary":"Damion Joachim to Joshua James, Six,","noball_dismissal":false,"text":"","timestamp":1749836322,"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":"12135979","event":"ball","batsman_id":"96611","bowler_id":"115822","over":"4","ball":"3","score":4,"commentary":"Damion Joachim to Joshua James, Four,","noball_dismissal":false,"text":"","timestamp":1749836415,"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":"12135985","event":"ball","batsman_id":"96611","bowler_id":"115822","over":"4","ball":"4","score":6,"commentary":"Damion Joachim to Joshua James, Six,","noball_dismissal":false,"text":"","timestamp":1749836445,"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":"12136008","event":"ball","batsman_id":"96611","bowler_id":"115822","over":"4","ball":"5","score":1,"commentary":"Damion Joachim to Joshua James, 1 run,","noball_dismissal":false,"text":"","timestamp":1749836549,"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":"12136010","event":"ball","batsman_id":"52292","bowler_id":"115822","over":"4","ball":"6","score":6,"commentary":"Damion Joachim to Dejourn Charles, Six,","noball_dismissal":false,"text":"","timestamp":1749836552,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event":"overend","over":5,"runs":27,"score":"65\/2","bats":[{"runs":33,"balls_faced":16,"fours":2,"sixes":3,"batsman_id":52292},{"runs":29,"balls_faced":12,"fours":2,"sixes":3,"batsman_id":96611}],"bowls":[{"runs_conceded":27,"maidens":0,"wickets":0,"bowler_id":115822,"overs":1},{"runs_conceded":8,"maidens":0,"wickets":0,"bowler_id":140979,"overs":1}],"commentary":"End of over 5 (27 runs), Soca Kings 65\/2"},{"event_id":"12136032","event":"ball","batsman_id":"96611","bowler_id":"140979","over":"5","ball":"1","score":2,"commentary":"Junior Bailey to Joshua James, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749836652,"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":"12136033","event":"ball","batsman_id":"96611","bowler_id":"140979","over":"5","ball":"2","score":0,"commentary":"Junior Bailey to Joshua James, no run,","noball_dismissal":false,"text":"","timestamp":1749836655,"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":"12136035","event":"ball","batsman_id":"96611","bowler_id":"140979","over":"5","ball":"3","score":4,"commentary":"Junior Bailey to Joshua James, Four,","noball_dismissal":false,"text":"","timestamp":1749836665,"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":"12136040","event":"ball","batsman_id":"96611","bowler_id":"140979","over":"5","ball":"4","score":6,"commentary":"Junior Bailey to Joshua James, Six,","noball_dismissal":false,"text":"","timestamp":1749836710,"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":197991,"number":2,"name":"Soca Kings Inning","short_name":"SCK Inning","status":2,"issuperover":"false","result":3,"batting_team_id":123301,"fielding_team_id":128980,"scores":"77\/2","scores_full":"77\/2 (5.4 ov)","fielder":[{"fielder_id":"145177","fielder_name":"Kevin Ryan Ramasray","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"147342","fielder_name":"Rondel Ramlogan","catches":0,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":1,"stumping":0,"is_substitute":"true"}],"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":"Shatrughan Rambaran","batsman_id":"114121","runs":"0","balls":"1","how_out":"runout ( (sub R Ramlogan ))","score_at_dismissal":0,"overs_at_dismissal":"0.2","bowler_id":"0","dismissal":"runout","number":2},"extra_runs":{"byes":0,"legbyes":0,"wides":3,"noballs":0,"penalty":"0","total":3},"equations":{"runs":77,"wickets":2,"overs":"5.4","bowlers_used":5,"runrate":"13.59"},"current_partnership":{"runs":77,"balls":32,"overs":5.2,"batsmen":[{"name":"Dejourn Charles","batsman_id":52292,"runs":33,"balls":16},{"name":"Joshua James","batsman_id":96611,"runs":41,"balls":16}]},"did_not_bat":[{"player_id":"147508","name":"Christian Lall"},{"player_id":"147243","name":"Akeel Mohammed"},{"player_id":"127227","name":"Jon Russ Jagessar"},{"player_id":"90814","name":"Imran Khan"},{"player_id":"116243","name":"Aamir Ali"},{"player_id":"43338","name":"Rayad Emrit"},{"player_id":"114112","name":"Chadeon Raymond"}],"max_over":"10","target":"76","recent_scores":"6,4,0,2,6,1,6,4,6,4,6,0,1,0,1,0,1,0","last_five_overs":"76\/0 14.71","last_ten_overs":"77\/2 13.20"},"teams":[{"tid":123301,"title":"Soca Kings","abbr":"SCK","alt_name":"Soca Kings","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/SCK-CR1@2x.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/SCK-CR1@2x.png","country":"wi","sex":"male","team_owner":"","head_coach":"","scores_full":"77\/2 (5.4 ov)","scores":"77\/2","overs":"5.4"},{"tid":128980,"title":"Leatherback Strikers","abbr":"TLS","alt_name":"Leatherback Strikers","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Leatherback-Strikers.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Leatherback-Strikers.png","country":"wi","sex":"male","team_owner":"","head_coach":"","scores_full":"75\/3 (10 ov)","scores":"75\/3","overs":"10"}],"players":[{"pid":43338,"title":"Rayad Emrit","short_name":"RR Emrit","first_name":"Rayad Emrit","last_name":"","middle_name":"","birthdate":"1981-03-08","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/rayad51","instagram_profile":"https:\/\/www.instagram.com\/rayad51\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":50112,"title":"William Perkins","short_name":"WKD Perkins","first_name":"William Perkins","last_name":"","middle_name":"","birthdate":"1986-10-08","birthplace":"Barbados","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":52292,"title":"Dejourn Charles","short_name":"D Charles","first_name":"Dejourn Charles","last_name":"","middle_name":"","birthdate":"1997-10-12","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":90814,"title":"Imran Khan","short_name":"I Khan","first_name":"Imran Khan","last_name":"","middle_name":"","birthdate":"1984-07-06","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","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":90945,"title":"Tion Webster","short_name":"T Webster","first_name":"Tion Webster","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":93005,"title":"Ewart Nicholson","short_name":"E Nicholson","first_name":"Ewart Nicholson","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":93261,"title":"Uthman Muhammad","short_name":"U Muhammad","first_name":"Uthman Muhammad","last_name":"","middle_name":"","birthdate":"1989-03-01","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":93874,"title":"Terrance Hinds","short_name":"T Hinds","first_name":"Terrance Hinds","last_name":"","middle_name":"","birthdate":"1992-01-23","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/terrohinds64","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":96611,"title":"Joshua James","short_name":"J James","first_name":"Joshua James","last_name":"","middle_name":"","birthdate":"2001-02-21","birthplace":"Trinidad & Tobago","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":"(C)"},{"pid":109937,"title":"Sion Hackett","short_name":"S Hackett","first_name":"Sion Hackett","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":null,"role":"squad","role_str":""},{"pid":114083,"title":"Christopher Vincent","short_name":"C Vincent","first_name":"Christopher Vincent","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":114084,"title":"Vishan Jagessar","short_name":"V Jagessar","first_name":"Vishan Jagessar","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":"(C)"},{"pid":114112,"title":"Chadeon Raymond","short_name":"C Raymond","first_name":"Chadeon Raymond","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":114121,"title":"Shatrughan Rambaran","short_name":"S Rambaran","first_name":"Shatrughan Rambaran","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":115822,"title":"Damion Joachim","short_name":"D Joachim","first_name":"Damion Joachim","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":"all","role_str":""},{"pid":115835,"title":"Denzil Antoine","short_name":"D Antoine","first_name":"Denzil Antoine","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":115852,"title":"Suraj Seepaul","short_name":"S Seepaul","first_name":"Suraj Seepaul","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":116231,"title":"Tevon Jadoo","short_name":"T Jadoo","first_name":"Tevon Jadoo","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":116243,"title":"Aamir Ali","short_name":"A Ali","first_name":"Aamir Ali","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":127227,"title":"Jon Russ Jagessar","short_name":"Jon Jagessar","first_name":"Jon Russ Jagessar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":139127,"title":"Abdur Rahman Juman","short_name":"A R Juman","first_name":"Abdur Rahman Juman","last_name":"","middle_name":"","birthdate":"2003-11-14","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":140979,"title":"Junior Bailey","short_name":"J Bailey","first_name":"Junior Bailey","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":140982,"title":"Selwin Allert","short_name":"S Allert","first_name":"Selwin Allert","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":"all","role_str":""},{"pid":145177,"title":"Kevin Ryan Ramasray","short_name":"K R Ramasray","first_name":"Kevin Ryan Ramasray","last_name":"","middle_name":"","birthdate":"1993-05-19","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":147236,"title":"Trevon James","short_name":"T James","first_name":"Trevon James","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":""},{"pid":147243,"title":"Akeel Mohammed","short_name":"A Mohammed","first_name":"Akeel Mohammed","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":147342,"title":"Rondel Ramlogan","short_name":"R Ramlogan","first_name":"Rondel Ramlogan","last_name":"","middle_name":"","birthdate":"2004-11-08","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","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":147508,"title":"Christian Lall","short_name":"C Lall","first_name":"Christian Lall","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(WK)"},{"pid":149628,"title":"Nickolas Wellington","short_name":"N Wellington","first_name":"Nickolas Wellington","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":"bat","role_str":""}]},"etag":"f9bd1701bab740b075a1415ab40412a8","modified":"2025-07-08 18:48:54","datetime":"2025-07-08 18:48:54","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90625 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:538af871-5b57-4ca5-9701-b8e7421d3753 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90625 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90625,3,'{"status":"ok","response":{"match_id":90625,"title":"Soca Kings vs Leatherback Strikers","short_title":"SCK vs TLS","subtitle":"Match 9","match_number":"9","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Soca Kings 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":123301,"name":"Soca Kings","short_name":"SCK","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/SCK-CR1@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/SCK-CR1@2x.png","scores_full":"77\/2 (5.4 ov)","scores":"77\/2","overs":"5.4"},"teamb":{"team_id":128980,"name":"Leatherback Strikers","short_name":"TLS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Leatherback-Strikers.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Leatherback-Strikers.png","scores_full":"75\/3 (10 ov)","scores":"75\/3","overs":"10"},"date_start":"2025-06-13 16:00:00","date_end":"2025-06-14 02:00:00","timestamp_start":1749830400,"timestamp_end":1749866400,"date_start_ist":"2025-06-13 21:30:00","date_end_ist":"2025-06-14 07:30:00","venue":{"venue_id":"204","name":"Brian Lara Stadium","location":"Tarouba","country":"West Indies","timezone":""},"umpires":" Andre Martin (West Indies), Hansraj Dass (West Indies)","referee":"Ramsahai Ramasar (West Indies)","equation":"","live":"","result":"SCK won by 8 wickets","result_type":1,"win_margin":"8 wickets","winning_team_id":123301,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-12 01:27:39","verify_time":"2025-06-13 23:29:56","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":23.64,"humidity":90,"visibility":10000,"wind_speed":"7.00","clouds":98},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Soca Kings elected to bowl","winner":123301,"decision":2}},"etag":"830a2b2855210880a2b6807c0a6e0120","modified":"2025-07-08 18:48:55","datetime":"2025-07-08 18:48:55","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90625,"title":"Soca Kings vs Leatherback Strikers","short_title":"SCK vs TLS","subtitle":"Match 9","match_number":"9","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Soca Kings 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":123301,"name":"Soca Kings","short_name":"SCK","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/SCK-CR1@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/SCK-CR1@2x.png","scores_full":"77\/2 (5.4 ov)","scores":"77\/2","overs":"5.4"},"teamb":{"team_id":128980,"name":"Leatherback Strikers","short_name":"TLS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Leatherback-Strikers.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Leatherback-Strikers.png","scores_full":"75\/3 (10 ov)","scores":"75\/3","overs":"10"},"date_start":"2025-06-13 16:00:00","date_end":"2025-06-14 02:00:00","timestamp_start":1749830400,"timestamp_end":1749866400,"date_start_ist":"2025-06-13 21:30:00","date_end_ist":"2025-06-14 07:30:00","venue":{"venue_id":"204","name":"Brian Lara Stadium","location":"Tarouba","country":"West Indies","timezone":""},"umpires":" Andre Martin (West Indies), Hansraj Dass (West Indies)","referee":"Ramsahai Ramasar (West Indies)","equation":"","live":"","result":"SCK won by 8 wickets","result_type":1,"win_margin":"8 wickets","winning_team_id":123301,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-12 01:27:39","verify_time":"2025-06-13 23:29:56","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":23.64,"humidity":90,"visibility":10000,"wind_speed":"7.00","clouds":98},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Soca Kings elected to bowl","winner":123301,"decision":2}},"etag":"830a2b2855210880a2b6807c0a6e0120","modified":"2025-07-08 18:48:55","datetime":"2025-07-08 18:48:55","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90625 AND DataTypeId = 3 END
Live Report & Scorecard of Soca Kings vs Leatherback Strikers Match 9