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:99f1a29a-b84c-4a35-8636-13a9e67a5393
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90628 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90628,1,'{"status":"ok","response":{"mid":90628,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Scarlet Ibis Scorchers won by 7 runs","day_remaining_over":"","team_batting":"Chicago Steelpan Players","team_bowling":"Scarlet Ibis Scorchers","live_inning_number":2,"live_score":{"runs":115,"overs":10,"wickets":6,"target":123,"runrate":11.5,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Navin Bidaisee","batsman_id":114147,"runs":2,"balls_faced":1,"fours":0,"sixes":0,"strike_rate":"200.00"},{"name":"Anderson Mahase","batsman_id":109938,"runs":0,"balls_faced":1,"fours":0,"sixes":0,"strike_rate":"0.00"}],"bowlers":[{"name":"Dexter Sween","bowler_id":114123,"overs":1,"runs_conceded":9,"wickets":1,"maidens":0,"econ":"9.00"},{"name":"Mikkel Govia","bowler_id":126384,"overs":2,"runs_conceded":21,"wickets":1,"maidens":0,"econ":"10.50"}],"commentaries":[{"event":"overend","over":6,"runs":12,"score":"89\/2","bats":[{"runs":15,"balls_faced":11,"fours":2,"sixes":0,"batsman_id":50138},{"runs":25,"balls_faced":10,"fours":3,"sixes":1,"batsman_id":92364}],"bowls":[{"runs_conceded":12,"maidens":0,"wickets":0,"bowler_id":114119,"overs":1},{"runs_conceded":28,"maidens":0,"wickets":1,"bowler_id":116999,"overs":2}],"commentary":"End of over 6 (12 runs), Chicago Steelpan Players 89\/2"},{"event_id":"12144904","event":"ball","batsman_id":"50138","bowler_id":"114114","over":"6","ball":"1","score":1,"commentary":"Andrew Rambaran to Mark Deyal, 1 run,","noball_dismissal":false,"text":"","timestamp":1749931952,"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":"12144912","event":"ball","batsman_id":"92364","bowler_id":"114114","over":"6","ball":"2","score":"1b","commentary":"Andrew Rambaran to Akiel Cooper, 1 bye,","noball_dismissal":false,"text":"","timestamp":1749932018,"run":1,"noball_run":"0","wide_run":"0","bye_run":"1","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12144915","event":"ball","batsman_id":"50138","bowler_id":"114114","over":"6","ball":"3","score":0,"commentary":"Andrew Rambaran to Mark Deyal, no run,","noball_dismissal":false,"text":"","timestamp":1749932028,"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":"12144920","event":"ball","batsman_id":"50138","bowler_id":"114114","over":"6","ball":"4","score":4,"commentary":"Andrew Rambaran to Mark Deyal, Four,","noball_dismissal":false,"text":"","timestamp":1749932084,"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":"12144922","event":"ball","batsman_id":"50138","bowler_id":"114114","over":"6","ball":"5","score":1,"commentary":"Andrew Rambaran to Mark Deyal, 1 run,","noball_dismissal":false,"text":"","timestamp":1749932091,"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":"12144932","event":"ball","batsman_id":"92364","bowler_id":"114114","over":"6","ball":"6","score":1,"commentary":"Andrew Rambaran to Akiel Cooper, 1 run,","noball_dismissal":false,"text":"","timestamp":1749932167,"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":7,"runs":8,"score":"97\/2","bats":[{"runs":26,"balls_faced":12,"fours":3,"sixes":1,"batsman_id":92364},{"runs":21,"balls_faced":15,"fours":3,"sixes":0,"batsman_id":50138}],"bowls":[{"runs_conceded":23,"maidens":0,"wickets":0,"bowler_id":114114,"overs":2},{"runs_conceded":12,"maidens":0,"wickets":0,"bowler_id":114119,"overs":1}],"commentary":"End of over 7 (8 runs), Chicago Steelpan Players 97\/2"},{"event_id":"12144946","event":"ball","batsman_id":"92364","bowler_id":"114119","over":"7","ball":"1","score":0,"commentary":"Eric Garcia to Akiel Cooper, no run,","noball_dismissal":false,"text":"","timestamp":1749932396,"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":"12144954","event":"ball","batsman_id":"92364","bowler_id":"114119","over":"7","ball":"2","score":0,"commentary":"Eric Garcia to Akiel Cooper, no run,","noball_dismissal":false,"text":"","timestamp":1749932407,"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":"12144993","event":"wicket","batsman_id":"92364","bowler_id":"114119","over":"7","ball":"3","score":"w","commentary":"Eric Garcia to Akiel Cooper, no run, c S Seecharan b E Garcia,","noball_dismissal":false,"text":"","timestamp":1749932793,"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 S Seecharan b E Garcia","batsman_runs":"26","batsman_balls":"15"},{"event_id":"12144998","event":"ball","batsman_id":"1206","bowler_id":"114119","over":"7","ball":"4","score":0,"commentary":"Eric Garcia to Jyd Goolie, no run,","noball_dismissal":false,"text":"","timestamp":1749932857,"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":"12144999","event":"ball","batsman_id":"1206","bowler_id":"114119","over":"7","ball":"5","score":"1wd","commentary":"Eric Garcia to Jyd Goolie, 1 wide,","noball_dismissal":false,"text":"","timestamp":1749932860,"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":"12145000","event":"ball","batsman_id":"1206","bowler_id":"114119","over":"7","ball":"5","score":1,"commentary":"Eric Garcia to Jyd Goolie, 1 run,","noball_dismissal":false,"text":"","timestamp":1749932863,"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":"12145001","event":"ball","batsman_id":"50138","bowler_id":"114119","over":"7","ball":"6","score":0,"commentary":"Eric Garcia to Mark Deyal, no run,","noball_dismissal":false,"text":"","timestamp":1749932867,"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":8,"runs":2,"score":"99\/3","bats":[{"runs":21,"balls_faced":16,"fours":3,"sixes":0,"batsman_id":50138},{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":1206}],"bowls":[{"runs_conceded":14,"maidens":0,"wickets":1,"bowler_id":114119,"overs":2},{"runs_conceded":23,"maidens":0,"wickets":0,"bowler_id":114114,"overs":2}],"commentary":"End of over 8 (2 runs), Chicago Steelpan Players 99\/3"},{"event_id":"12145008","event":"ball","batsman_id":"1206","bowler_id":"126384","over":"8","ball":"1","score":0,"commentary":"Mikkel Govia to Jyd Goolie, no run,","noball_dismissal":false,"text":"","timestamp":1749933012,"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":"12145010","event":"ball","batsman_id":"1206","bowler_id":"126384","over":"8","ball":"2","score":2,"commentary":"Mikkel Govia to Jyd Goolie, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749933016,"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":"12145011","event":"ball","batsman_id":"1206","bowler_id":"126384","over":"8","ball":"3","score":2,"commentary":"Mikkel Govia to Jyd Goolie, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749933021,"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":"12145012","event":"ball","batsman_id":"1206","bowler_id":"126384","over":"8","ball":"4","score":1,"commentary":"Mikkel Govia to Jyd Goolie, 1 run,","noball_dismissal":false,"text":"","timestamp":1749933025,"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":"12145013","event":"ball","batsman_id":"50138","bowler_id":"126384","over":"8","ball":"5","score":1,"commentary":"Mikkel Govia to Mark Deyal, 1 run,","noball_dismissal":false,"text":"","timestamp":1749933028,"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":"12145014","event":"ball","batsman_id":"1206","bowler_id":"126384","over":"8","ball":"6","score":1,"commentary":"Mikkel Govia to Jyd Goolie, 1 run,","noball_dismissal":false,"text":"","timestamp":1749933031,"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":9,"runs":7,"score":"106\/3","bats":[{"runs":7,"balls_faced":7,"fours":0,"sixes":0,"batsman_id":1206},{"runs":22,"balls_faced":17,"fours":3,"sixes":0,"batsman_id":50138}],"bowls":[{"runs_conceded":21,"maidens":0,"wickets":1,"bowler_id":126384,"overs":2},{"runs_conceded":14,"maidens":0,"wickets":1,"bowler_id":114119,"overs":2}],"commentary":"End of over 9 (7 runs), Chicago Steelpan Players 106\/3"},{"event_id":"12145017","event":"ball","batsman_id":"1206","bowler_id":"114123","over":"9","ball":"1","score":1,"commentary":"Dexter Sween to Jyd Goolie, 1 run,","noball_dismissal":false,"text":"","timestamp":1749933033,"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":"12145018","event":"ball","batsman_id":"50138","bowler_id":"114123","over":"9","ball":"2","score":4,"commentary":"Dexter Sween to Mark Deyal, Four,","noball_dismissal":false,"text":"","timestamp":1749933036,"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":"12145019","event":"ball","batsman_id":"50138","bowler_id":"114123","over":"9","ball":"3","score":"1wd","commentary":"Dexter Sween to Mark Deyal, 1 wide,","noball_dismissal":false,"text":"","timestamp":1749933039,"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":"12145027","event":"wicket","batsman_id":"50138","bowler_id":"114123","over":"9","ball":"3","score":"w","commentary":"Dexter Sween to Mark Deyal, no run, c M Govia b D Sween,","noball_dismissal":false,"text":"","timestamp":1749933114,"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":"50138","how_out":"c M Govia b D Sween","batsman_runs":"26","batsman_balls":"19"},{"event_id":"12145036","event":"wicket","batsman_id":"114147","bowler_id":"114123","over":"9","ball":"4","score":"w","commentary":"Dexter Sween to Navin Bidaisee, 2 runs, runout (D Williams \/ C Cooper),","noball_dismissal":false,"text":"","timestamp":1749933252,"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,"wicket_batsman_id":"1206","how_out":"runout (D Williams \/ C Cooper)","batsman_runs":"8","batsman_balls":"8"},{"event_id":"12145043","event":"wicket","batsman_id":"52205","bowler_id":"114123","over":"9","ball":"5","score":"w","commentary":"Dexter Sween to Clevon Kalawan, 1 run, runout (D Williams \/ N Ali),","noball_dismissal":false,"text":"","timestamp":1749933360,"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,"wicket_batsman_id":"52205","how_out":"runout (D Williams \/ N Ali)","batsman_runs":"1","batsman_balls":"1"},{"event_id":"12145046","event":"ball","batsman_id":"109938","bowler_id":"114123","over":"9","ball":"6","score":0,"commentary":"Dexter Sween to Anderson Mahase, no run,","noball_dismissal":false,"text":"","timestamp":1749933390,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":10,"runs":9,"score":"115\/6","bats":[{"runs":0,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":109938},{"runs":2,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":114147}],"bowls":[{"runs_conceded":9,"maidens":0,"wickets":1,"bowler_id":114123,"overs":1},{"runs_conceded":21,"maidens":0,"wickets":1,"bowler_id":126384,"overs":2}],"commentary":"End of over 10 (9 runs), Chicago Steelpan Players 115\/6"}],"day":"0","session":"0","live_inning":{"iid":198081,"number":2,"name":"Chicago Steelpan Players Inning","short_name":"CSP Inning","status":2,"issuperover":"false","result":4,"batting_team_id":128981,"fielding_team_id":123303,"scores":"115\/6","scores_full":"115\/6 (10 ov)","fielder":[{"fielder_id":"114116","fielder_name":"Daniel Williams","catches":2,"runout_thrower":0,"runout_catcher":2,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"126384","fielder_name":"Mikkel Govia","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"128748","fielder_name":"Sachin Seecharan","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"52230","fielder_name":"Cephas Cooper","catches":0,"runout_thrower":1,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"115831","fielder_name":"Nicholas Ali","catches":0,"runout_thrower":1,"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":"Clevon Kalawan","batsman_id":"52205","runs":"1","balls":"1","how_out":"runout (D Williams \/ N Ali)","score_at_dismissal":115,"overs_at_dismissal":"9.5","bowler_id":"0","dismissal":"runout","number":6},"extra_runs":{"byes":1,"legbyes":0,"wides":14,"noballs":0,"penalty":"0","total":15},"equations":{"runs":115,"wickets":6,"overs":"10","bowlers_used":6,"runrate":"11.50"},"current_partnership":{"runs":0,"balls":1,"overs":0.1,"batsmen":[{"name":"Anderson Mahase","batsman_id":109938,"runs":0,"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":"115823","name":"Ramesh Brijlal"}],"max_over":"10","target":"123","recent_scores":"0,w,w,w,1,4,1,1,1,1,2,2,0,0,1,1,0,w","last_five_overs":"38\/4 6.91","last_ten_overs":"115\/6 10.15"},"teams":[{"tid":123303,"title":"Scarlet Ibis Scorchers","abbr":"SLS","alt_name":"Scarlet Ibis Scorchers","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/SLS-CR1@2x.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/SLS-CR1@2x.png","country":"wi","sex":"male","team_owner":"","head_coach":"","scores_full":"122\/3 (10 ov)","scores":"122\/3","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":"115\/6 (10 ov)","scores":"115\/6","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":"bat","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":52230,"title":"Cephas Cooper","short_name":"C Cooper","first_name":"Cephas Cooper","last_name":"","middle_name":"","birthdate":"1999-07-11","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":23789,"recent_appearance":1515805200,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":55454,"title":"Nicholas Sookdeosingh","short_name":"N Sookdeosingh","first_name":"Nicholas Sookdeosingh","last_name":"","middle_name":"","birthdate":"1989-07-23","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","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":"squad","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":114114,"title":"Andrew Rambaran","short_name":"A Rambaran","first_name":"Andrew 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":"(C)"},{"pid":114116,"title":"Daniel Williams","short_name":"D Williams","first_name":"Daniel Williams","last_name":"","middle_name":"","birthdate":"1998-01-13","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":114119,"title":"Eric Garcia","short_name":"E Garcia","first_name":"Eric Garcia","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":114123,"title":"Dexter Sween","short_name":"D Sween","first_name":"Dexter Sween","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":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":114320,"title":"Joshua Ramdoo","short_name":"J Ramdoo","first_name":"Joshua Ramdoo","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":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":115831,"title":"Nicholas Ali","short_name":"N Ali","first_name":"Nicholas Ali","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":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":116999,"title":"Liam Vinode Mamchan","short_name":"L V Mamchan","first_name":"Liam Vinode Mamchan","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":126384,"title":"Mikkel Govia","short_name":"M Govia","first_name":"Mikkel Govia","last_name":"","middle_name":"","birthdate":"2002-01-25","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":127247,"title":"Namir Suepaul","short_name":"N Suepaul","first_name":"Namir Suepaul","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":127449,"title":"Keron Rampersad ","short_name":"K Rampersad ","first_name":"Keron Rampersad ","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":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":128748,"title":"Sachin Seecharan","short_name":"S Seecharan","first_name":"Sachin Seecharan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"us","primary_team":[],"logo_url":"","playing_role":"bat","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":"United States","role":"bat","role_str":""},{"pid":139140,"title":"Keifer Ghisyawan","short_name":"K Ghisyawan","first_name":"Keifer Ghisyawan","last_name":"","middle_name":"","birthdate":"2007-07-09","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":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":"c4358bac730f3839643ec605e940a787","modified":"2025-07-08 02:40:34","datetime":"2025-07-08 02:40:34","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":90628,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Scarlet Ibis Scorchers won by 7 runs","day_remaining_over":"","team_batting":"Chicago Steelpan Players","team_bowling":"Scarlet Ibis Scorchers","live_inning_number":2,"live_score":{"runs":115,"overs":10,"wickets":6,"target":123,"runrate":11.5,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Navin Bidaisee","batsman_id":114147,"runs":2,"balls_faced":1,"fours":0,"sixes":0,"strike_rate":"200.00"},{"name":"Anderson Mahase","batsman_id":109938,"runs":0,"balls_faced":1,"fours":0,"sixes":0,"strike_rate":"0.00"}],"bowlers":[{"name":"Dexter Sween","bowler_id":114123,"overs":1,"runs_conceded":9,"wickets":1,"maidens":0,"econ":"9.00"},{"name":"Mikkel Govia","bowler_id":126384,"overs":2,"runs_conceded":21,"wickets":1,"maidens":0,"econ":"10.50"}],"commentaries":[{"event":"overend","over":6,"runs":12,"score":"89\/2","bats":[{"runs":15,"balls_faced":11,"fours":2,"sixes":0,"batsman_id":50138},{"runs":25,"balls_faced":10,"fours":3,"sixes":1,"batsman_id":92364}],"bowls":[{"runs_conceded":12,"maidens":0,"wickets":0,"bowler_id":114119,"overs":1},{"runs_conceded":28,"maidens":0,"wickets":1,"bowler_id":116999,"overs":2}],"commentary":"End of over 6 (12 runs), Chicago Steelpan Players 89\/2"},{"event_id":"12144904","event":"ball","batsman_id":"50138","bowler_id":"114114","over":"6","ball":"1","score":1,"commentary":"Andrew Rambaran to Mark Deyal, 1 run,","noball_dismissal":false,"text":"","timestamp":1749931952,"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":"12144912","event":"ball","batsman_id":"92364","bowler_id":"114114","over":"6","ball":"2","score":"1b","commentary":"Andrew Rambaran to Akiel Cooper, 1 bye,","noball_dismissal":false,"text":"","timestamp":1749932018,"run":1,"noball_run":"0","wide_run":"0","bye_run":"1","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12144915","event":"ball","batsman_id":"50138","bowler_id":"114114","over":"6","ball":"3","score":0,"commentary":"Andrew Rambaran to Mark Deyal, no run,","noball_dismissal":false,"text":"","timestamp":1749932028,"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":"12144920","event":"ball","batsman_id":"50138","bowler_id":"114114","over":"6","ball":"4","score":4,"commentary":"Andrew Rambaran to Mark Deyal, Four,","noball_dismissal":false,"text":"","timestamp":1749932084,"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":"12144922","event":"ball","batsman_id":"50138","bowler_id":"114114","over":"6","ball":"5","score":1,"commentary":"Andrew Rambaran to Mark Deyal, 1 run,","noball_dismissal":false,"text":"","timestamp":1749932091,"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":"12144932","event":"ball","batsman_id":"92364","bowler_id":"114114","over":"6","ball":"6","score":1,"commentary":"Andrew Rambaran to Akiel Cooper, 1 run,","noball_dismissal":false,"text":"","timestamp":1749932167,"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":7,"runs":8,"score":"97\/2","bats":[{"runs":26,"balls_faced":12,"fours":3,"sixes":1,"batsman_id":92364},{"runs":21,"balls_faced":15,"fours":3,"sixes":0,"batsman_id":50138}],"bowls":[{"runs_conceded":23,"maidens":0,"wickets":0,"bowler_id":114114,"overs":2},{"runs_conceded":12,"maidens":0,"wickets":0,"bowler_id":114119,"overs":1}],"commentary":"End of over 7 (8 runs), Chicago Steelpan Players 97\/2"},{"event_id":"12144946","event":"ball","batsman_id":"92364","bowler_id":"114119","over":"7","ball":"1","score":0,"commentary":"Eric Garcia to Akiel Cooper, no run,","noball_dismissal":false,"text":"","timestamp":1749932396,"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":"12144954","event":"ball","batsman_id":"92364","bowler_id":"114119","over":"7","ball":"2","score":0,"commentary":"Eric Garcia to Akiel Cooper, no run,","noball_dismissal":false,"text":"","timestamp":1749932407,"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":"12144993","event":"wicket","batsman_id":"92364","bowler_id":"114119","over":"7","ball":"3","score":"w","commentary":"Eric Garcia to Akiel Cooper, no run, c S Seecharan b E Garcia,","noball_dismissal":false,"text":"","timestamp":1749932793,"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 S Seecharan b E Garcia","batsman_runs":"26","batsman_balls":"15"},{"event_id":"12144998","event":"ball","batsman_id":"1206","bowler_id":"114119","over":"7","ball":"4","score":0,"commentary":"Eric Garcia to Jyd Goolie, no run,","noball_dismissal":false,"text":"","timestamp":1749932857,"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":"12144999","event":"ball","batsman_id":"1206","bowler_id":"114119","over":"7","ball":"5","score":"1wd","commentary":"Eric Garcia to Jyd Goolie, 1 wide,","noball_dismissal":false,"text":"","timestamp":1749932860,"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":"12145000","event":"ball","batsman_id":"1206","bowler_id":"114119","over":"7","ball":"5","score":1,"commentary":"Eric Garcia to Jyd Goolie, 1 run,","noball_dismissal":false,"text":"","timestamp":1749932863,"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":"12145001","event":"ball","batsman_id":"50138","bowler_id":"114119","over":"7","ball":"6","score":0,"commentary":"Eric Garcia to Mark Deyal, no run,","noball_dismissal":false,"text":"","timestamp":1749932867,"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":8,"runs":2,"score":"99\/3","bats":[{"runs":21,"balls_faced":16,"fours":3,"sixes":0,"batsman_id":50138},{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":1206}],"bowls":[{"runs_conceded":14,"maidens":0,"wickets":1,"bowler_id":114119,"overs":2},{"runs_conceded":23,"maidens":0,"wickets":0,"bowler_id":114114,"overs":2}],"commentary":"End of over 8 (2 runs), Chicago Steelpan Players 99\/3"},{"event_id":"12145008","event":"ball","batsman_id":"1206","bowler_id":"126384","over":"8","ball":"1","score":0,"commentary":"Mikkel Govia to Jyd Goolie, no run,","noball_dismissal":false,"text":"","timestamp":1749933012,"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":"12145010","event":"ball","batsman_id":"1206","bowler_id":"126384","over":"8","ball":"2","score":2,"commentary":"Mikkel Govia to Jyd Goolie, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749933016,"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":"12145011","event":"ball","batsman_id":"1206","bowler_id":"126384","over":"8","ball":"3","score":2,"commentary":"Mikkel Govia to Jyd Goolie, 2 runs,","noball_dismissal":false,"text":"","timestamp":1749933021,"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":"12145012","event":"ball","batsman_id":"1206","bowler_id":"126384","over":"8","ball":"4","score":1,"commentary":"Mikkel Govia to Jyd Goolie, 1 run,","noball_dismissal":false,"text":"","timestamp":1749933025,"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":"12145013","event":"ball","batsman_id":"50138","bowler_id":"126384","over":"8","ball":"5","score":1,"commentary":"Mikkel Govia to Mark Deyal, 1 run,","noball_dismissal":false,"text":"","timestamp":1749933028,"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":"12145014","event":"ball","batsman_id":"1206","bowler_id":"126384","over":"8","ball":"6","score":1,"commentary":"Mikkel Govia to Jyd Goolie, 1 run,","noball_dismissal":false,"text":"","timestamp":1749933031,"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":9,"runs":7,"score":"106\/3","bats":[{"runs":7,"balls_faced":7,"fours":0,"sixes":0,"batsman_id":1206},{"runs":22,"balls_faced":17,"fours":3,"sixes":0,"batsman_id":50138}],"bowls":[{"runs_conceded":21,"maidens":0,"wickets":1,"bowler_id":126384,"overs":2},{"runs_conceded":14,"maidens":0,"wickets":1,"bowler_id":114119,"overs":2}],"commentary":"End of over 9 (7 runs), Chicago Steelpan Players 106\/3"},{"event_id":"12145017","event":"ball","batsman_id":"1206","bowler_id":"114123","over":"9","ball":"1","score":1,"commentary":"Dexter Sween to Jyd Goolie, 1 run,","noball_dismissal":false,"text":"","timestamp":1749933033,"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":"12145018","event":"ball","batsman_id":"50138","bowler_id":"114123","over":"9","ball":"2","score":4,"commentary":"Dexter Sween to Mark Deyal, Four,","noball_dismissal":false,"text":"","timestamp":1749933036,"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":"12145019","event":"ball","batsman_id":"50138","bowler_id":"114123","over":"9","ball":"3","score":"1wd","commentary":"Dexter Sween to Mark Deyal, 1 wide,","noball_dismissal":false,"text":"","timestamp":1749933039,"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":"12145027","event":"wicket","batsman_id":"50138","bowler_id":"114123","over":"9","ball":"3","score":"w","commentary":"Dexter Sween to Mark Deyal, no run, c M Govia b D Sween,","noball_dismissal":false,"text":"","timestamp":1749933114,"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":"50138","how_out":"c M Govia b D Sween","batsman_runs":"26","batsman_balls":"19"},{"event_id":"12145036","event":"wicket","batsman_id":"114147","bowler_id":"114123","over":"9","ball":"4","score":"w","commentary":"Dexter Sween to Navin Bidaisee, 2 runs, runout (D Williams \/ C Cooper),","noball_dismissal":false,"text":"","timestamp":1749933252,"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,"wicket_batsman_id":"1206","how_out":"runout (D Williams \/ C Cooper)","batsman_runs":"8","batsman_balls":"8"},{"event_id":"12145043","event":"wicket","batsman_id":"52205","bowler_id":"114123","over":"9","ball":"5","score":"w","commentary":"Dexter Sween to Clevon Kalawan, 1 run, runout (D Williams \/ N Ali),","noball_dismissal":false,"text":"","timestamp":1749933360,"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,"wicket_batsman_id":"52205","how_out":"runout (D Williams \/ N Ali)","batsman_runs":"1","batsman_balls":"1"},{"event_id":"12145046","event":"ball","batsman_id":"109938","bowler_id":"114123","over":"9","ball":"6","score":0,"commentary":"Dexter Sween to Anderson Mahase, no run,","noball_dismissal":false,"text":"","timestamp":1749933390,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":10,"runs":9,"score":"115\/6","bats":[{"runs":0,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":109938},{"runs":2,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":114147}],"bowls":[{"runs_conceded":9,"maidens":0,"wickets":1,"bowler_id":114123,"overs":1},{"runs_conceded":21,"maidens":0,"wickets":1,"bowler_id":126384,"overs":2}],"commentary":"End of over 10 (9 runs), Chicago Steelpan Players 115\/6"}],"day":"0","session":"0","live_inning":{"iid":198081,"number":2,"name":"Chicago Steelpan Players Inning","short_name":"CSP Inning","status":2,"issuperover":"false","result":4,"batting_team_id":128981,"fielding_team_id":123303,"scores":"115\/6","scores_full":"115\/6 (10 ov)","fielder":[{"fielder_id":"114116","fielder_name":"Daniel Williams","catches":2,"runout_thrower":0,"runout_catcher":2,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"126384","fielder_name":"Mikkel Govia","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"128748","fielder_name":"Sachin Seecharan","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"52230","fielder_name":"Cephas Cooper","catches":0,"runout_thrower":1,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"115831","fielder_name":"Nicholas Ali","catches":0,"runout_thrower":1,"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":"Clevon Kalawan","batsman_id":"52205","runs":"1","balls":"1","how_out":"runout (D Williams \/ N Ali)","score_at_dismissal":115,"overs_at_dismissal":"9.5","bowler_id":"0","dismissal":"runout","number":6},"extra_runs":{"byes":1,"legbyes":0,"wides":14,"noballs":0,"penalty":"0","total":15},"equations":{"runs":115,"wickets":6,"overs":"10","bowlers_used":6,"runrate":"11.50"},"current_partnership":{"runs":0,"balls":1,"overs":0.1,"batsmen":[{"name":"Anderson Mahase","batsman_id":109938,"runs":0,"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":"115823","name":"Ramesh Brijlal"}],"max_over":"10","target":"123","recent_scores":"0,w,w,w,1,4,1,1,1,1,2,2,0,0,1,1,0,w","last_five_overs":"38\/4 6.91","last_ten_overs":"115\/6 10.15"},"teams":[{"tid":123303,"title":"Scarlet Ibis Scorchers","abbr":"SLS","alt_name":"Scarlet Ibis Scorchers","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/SLS-CR1@2x.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/SLS-CR1@2x.png","country":"wi","sex":"male","team_owner":"","head_coach":"","scores_full":"122\/3 (10 ov)","scores":"122\/3","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":"115\/6 (10 ov)","scores":"115\/6","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":"bat","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":52230,"title":"Cephas Cooper","short_name":"C Cooper","first_name":"Cephas Cooper","last_name":"","middle_name":"","birthdate":"1999-07-11","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":23789,"recent_appearance":1515805200,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":55454,"title":"Nicholas Sookdeosingh","short_name":"N Sookdeosingh","first_name":"Nicholas Sookdeosingh","last_name":"","middle_name":"","birthdate":"1989-07-23","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","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":"squad","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":114114,"title":"Andrew Rambaran","short_name":"A Rambaran","first_name":"Andrew 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":"(C)"},{"pid":114116,"title":"Daniel Williams","short_name":"D Williams","first_name":"Daniel Williams","last_name":"","middle_name":"","birthdate":"1998-01-13","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":114119,"title":"Eric Garcia","short_name":"E Garcia","first_name":"Eric Garcia","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":114123,"title":"Dexter Sween","short_name":"D Sween","first_name":"Dexter Sween","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":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":114320,"title":"Joshua Ramdoo","short_name":"J Ramdoo","first_name":"Joshua Ramdoo","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":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":115831,"title":"Nicholas Ali","short_name":"N Ali","first_name":"Nicholas Ali","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":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":116999,"title":"Liam Vinode Mamchan","short_name":"L V Mamchan","first_name":"Liam Vinode Mamchan","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":126384,"title":"Mikkel Govia","short_name":"M Govia","first_name":"Mikkel Govia","last_name":"","middle_name":"","birthdate":"2002-01-25","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":127247,"title":"Namir Suepaul","short_name":"N Suepaul","first_name":"Namir Suepaul","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":127449,"title":"Keron Rampersad ","short_name":"K Rampersad ","first_name":"Keron Rampersad ","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":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":128748,"title":"Sachin Seecharan","short_name":"S Seecharan","first_name":"Sachin Seecharan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"us","primary_team":[],"logo_url":"","playing_role":"bat","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":"United States","role":"bat","role_str":""},{"pid":139140,"title":"Keifer Ghisyawan","short_name":"K Ghisyawan","first_name":"Keifer Ghisyawan","last_name":"","middle_name":"","birthdate":"2007-07-09","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":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":"c4358bac730f3839643ec605e940a787","modified":"2025-07-08 02:40:34","datetime":"2025-07-08 02:40:34","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90628 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:99f1a29a-b84c-4a35-8636-13a9e67a5393
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90628 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90628,3,'{"status":"ok","response":{"match_id":90628,"title":"Chicago Steelpan Players vs Scarlet Ibis Scorchers","short_title":"CSP vs SLS","subtitle":"Match 12","match_number":"12","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Scarlet Ibis Scorchers won by 7 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":"115\/6 (10 ov)","scores":"115\/6","overs":"10"},"teamb":{"team_id":123303,"name":"Scarlet Ibis Scorchers","short_name":"SLS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/SLS-CR1@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/SLS-CR1@2x.png","scores_full":"122\/3 (10 ov)","scores":"122\/3","overs":"10"},"date_start":"2025-06-14 18:30:00","date_end":"2025-06-15 04:30:00","timestamp_start":1749925800,"timestamp_end":1749961800,"date_start_ist":"2025-06-15 00:00:00","date_end_ist":"2025-06-15 10:00:00","venue":{"venue_id":"204","name":"Brian Lara Stadium","location":"Tarouba","country":"West Indies","timezone":""},"umpires":" Andel Maynard(West Indies), Simon Aroon(West Indies)","referee":" Ramsahai Ramasar (West Indies)","equation":"","live":"","result":"SLS won by 7 runs","result_type":2,"win_margin":"7 runs","winning_team_id":123303,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-13 01:17:43","verify_time":"2025-06-15 02:33:21","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"scattered clouds","temp":27.48,"humidity":70,"visibility":10000,"wind_speed":"8.46","clouds":38},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Scarlet Ibis Scorchers elected to bat","winner":123303,"decision":1}},"etag":"b5e7d66f585652606339c55398e69fc1","modified":"2025-07-08 02:40:35","datetime":"2025-07-08 02:40:35","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90628,"title":"Chicago Steelpan Players vs Scarlet Ibis Scorchers","short_title":"CSP vs SLS","subtitle":"Match 12","match_number":"12","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Scarlet Ibis Scorchers won by 7 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":"115\/6 (10 ov)","scores":"115\/6","overs":"10"},"teamb":{"team_id":123303,"name":"Scarlet Ibis Scorchers","short_name":"SLS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/SLS-CR1@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/SLS-CR1@2x.png","scores_full":"122\/3 (10 ov)","scores":"122\/3","overs":"10"},"date_start":"2025-06-14 18:30:00","date_end":"2025-06-15 04:30:00","timestamp_start":1749925800,"timestamp_end":1749961800,"date_start_ist":"2025-06-15 00:00:00","date_end_ist":"2025-06-15 10:00:00","venue":{"venue_id":"204","name":"Brian Lara Stadium","location":"Tarouba","country":"West Indies","timezone":""},"umpires":" Andel Maynard(West Indies), Simon Aroon(West Indies)","referee":" Ramsahai Ramasar (West Indies)","equation":"","live":"","result":"SLS won by 7 runs","result_type":2,"win_margin":"7 runs","winning_team_id":123303,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-13 01:17:43","verify_time":"2025-06-15 02:33:21","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"scattered clouds","temp":27.48,"humidity":70,"visibility":10000,"wind_speed":"8.46","clouds":38},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Scarlet Ibis Scorchers elected to bat","winner":123303,"decision":1}},"etag":"b5e7d66f585652606339c55398e69fc1","modified":"2025-07-08 02:40:35","datetime":"2025-07-08 02:40:35","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90628 AND DataTypeId = 3 END Live Report & Scorecard of Chicago Steelpan Players vs Scarlet Ibis Scorchers Match 12