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:c923ac29-481a-4e30-b105-240f8e06b27b Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90636 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90636,1,'{"status":"ok","response":{"mid":90636,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Scarlet Ibis Scorchers won by 8 wickets","day_remaining_over":"","team_batting":"Scarlet Ibis Scorchers","team_bowling":"Leatherback Strikers","live_inning_number":2,"live_score":{"runs":77,"overs":4.4,"wickets":2,"target":72,"runrate":16.5,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Dexter Sween","batsman_id":114123,"runs":31,"balls_faced":10,"fours":1,"sixes":4,"strike_rate":"310.00"},{"name":"Mikkel Govia","batsman_id":126384,"runs":17,"balls_faced":8,"fours":0,"sixes":2,"strike_rate":"212.50"}],"bowlers":[{"name":"Selwin Allert","bowler_id":140982,"overs":0.4,"runs_conceded":23,"wickets":0,"maidens":0,"econ":"34.50"},{"name":"Damion Joachim","bowler_id":115822,"overs":1,"runs_conceded":10,"wickets":0,"maidens":0,"econ":"10.00"}],"commentaries":[{"event_id":"12163539","event":"ball","batsman_id":"52230","bowler_id":"93874","over":"0","ball":"4","score":0,"commentary":"Terrance Hinds to Cephas Cooper, no run,","noball_dismissal":false,"text":"","timestamp":1750190149,"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":"12163543","event":"ball","batsman_id":"52230","bowler_id":"93874","over":"0","ball":"5","score":6,"commentary":"Terrance Hinds to Cephas Cooper, Six,","noball_dismissal":false,"text":"","timestamp":1750190178,"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":"12163548","event":"wicket","batsman_id":"52230","bowler_id":"93874","over":"0","ball":"6","score":"w","commentary":"Terrance Hinds to Cephas Cooper, no run, b T Hinds,","noball_dismissal":false,"text":"","timestamp":1750190235,"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":"52230","how_out":"b T Hinds","batsman_runs":"10","batsman_balls":"5"},{"event":"overend","over":1,"runs":12,"score":"12\/1","bats":[{"runs":10,"balls_faced":5,"fours":1,"sixes":1,"batsman_id":52230},{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":114116}],"bowls":[{"runs_conceded":12,"maidens":0,"wickets":1,"bowler_id":93874,"overs":1}],"commentary":"End of over 1 (12 runs), Scarlet Ibis Scorchers 12\/1"},{"event_id":"12163557","event":"ball","batsman_id":"114116","bowler_id":"140979","over":"1","ball":"1","score":"4b","commentary":"Junior Bailey to Daniel Williams, 4 bye,","noball_dismissal":false,"text":"","timestamp":1750190555,"run":4,"noball_run":"0","wide_run":"0","bye_run":"4","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12163559","event":"ball","batsman_id":"114116","bowler_id":"140979","over":"1","ball":"2","score":4,"commentary":"Junior Bailey to Daniel Williams, Four,","noball_dismissal":false,"text":"","timestamp":1750190559,"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":"12163562","event":"ball","batsman_id":"114116","bowler_id":"140979","over":"1","ball":"3","score":1,"commentary":"Junior Bailey to Daniel Williams, 1 run,","noball_dismissal":false,"text":"","timestamp":1750190562,"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":"12163565","event":"ball","batsman_id":"126384","bowler_id":"140979","over":"1","ball":"4","score":0,"commentary":"Junior Bailey to Mikkel Govia, no run,","noball_dismissal":false,"text":"","timestamp":1750190567,"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":"12163567","event":"ball","batsman_id":"126384","bowler_id":"140979","over":"1","ball":"5","score":6,"commentary":"Junior Bailey to Mikkel Govia, Six,","noball_dismissal":false,"text":"","timestamp":1750190571,"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":"12163572","event":"ball","batsman_id":"126384","bowler_id":"140979","over":"1","ball":"6","score":2,"commentary":"Junior Bailey to Mikkel Govia, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750190580,"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":"overend","over":2,"runs":17,"score":"29\/1","bats":[{"runs":8,"balls_faced":3,"fours":0,"sixes":1,"batsman_id":126384},{"runs":6,"balls_faced":4,"fours":1,"sixes":0,"batsman_id":114116}],"bowls":[{"runs_conceded":13,"maidens":0,"wickets":0,"bowler_id":140979,"overs":1},{"runs_conceded":12,"maidens":0,"wickets":1,"bowler_id":93874,"overs":1}],"commentary":"End of over 2 (17 runs), Scarlet Ibis Scorchers 29\/1"},{"event_id":"12163580","event":"ball","batsman_id":"114116","bowler_id":"114083","over":"2","ball":"1","score":6,"commentary":"Christopher Vincent to Daniel Williams, Six,","noball_dismissal":false,"text":"","timestamp":1750190717,"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":"12163583","event":"wicket","batsman_id":"114116","bowler_id":"114083","over":"2","ball":"2","score":"w","commentary":"Christopher Vincent to Daniel Williams, no run, c S Allert b C Vincent,","noball_dismissal":false,"text":"","timestamp":1750190758,"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":"114116","how_out":"c S Allert b C Vincent","batsman_runs":"12","batsman_balls":"6"},{"event_id":"12163592","event":"ball","batsman_id":"114123","bowler_id":"114083","over":"2","ball":"3","score":"7nb","commentary":"Christopher Vincent to Dexter Sween, 7 no ball,","noball_dismissal":false,"text":"","timestamp":1750190853,"run":7,"noball_run":"1","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":true,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12163593","event":"ball","batsman_id":"114123","bowler_id":"114083","over":"2","ball":"3","score":0,"commentary":"Christopher Vincent to Dexter Sween, no run,","noball_dismissal":false,"text":"","timestamp":1750190889,"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":"12163595","event":"ball","batsman_id":"114123","bowler_id":"114083","over":"2","ball":"4","score":0,"commentary":"Christopher Vincent to Dexter Sween, no run,","noball_dismissal":false,"text":"","timestamp":1750190909,"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":"12163599","event":"ball","batsman_id":"114123","bowler_id":"114083","over":"2","ball":"5","score":1,"commentary":"Christopher Vincent to Dexter Sween, 1 run,","noball_dismissal":false,"text":"","timestamp":1750190955,"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":"12163601","event":"ball","batsman_id":"126384","bowler_id":"114083","over":"2","ball":"6","score":1,"commentary":"Christopher Vincent to Mikkel Govia, 1 run,","noball_dismissal":false,"text":"","timestamp":1750190988,"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":15,"score":"44\/2","bats":[{"runs":9,"balls_faced":4,"fours":0,"sixes":1,"batsman_id":126384},{"runs":7,"balls_faced":4,"fours":0,"sixes":1,"batsman_id":114123}],"bowls":[{"runs_conceded":15,"maidens":0,"wickets":1,"bowler_id":114083,"overs":1},{"runs_conceded":13,"maidens":0,"wickets":0,"bowler_id":140979,"overs":1}],"commentary":"End of over 3 (15 runs), Scarlet Ibis Scorchers 44\/2"},{"event_id":"12163610","event":"ball","batsman_id":"126384","bowler_id":"115822","over":"3","ball":"1","score":1,"commentary":"Damion Joachim to Mikkel Govia, 1 run,","noball_dismissal":false,"text":"","timestamp":1750191309,"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":"12163613","event":"ball","batsman_id":"114123","bowler_id":"115822","over":"3","ball":"2","score":1,"commentary":"Damion Joachim to Dexter Sween, 1 run,","noball_dismissal":false,"text":"","timestamp":1750191316,"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":"12163614","event":"ball","batsman_id":"126384","bowler_id":"115822","over":"3","ball":"3","score":0,"commentary":"Damion Joachim to Mikkel Govia, no run,","noball_dismissal":false,"text":"","timestamp":1750191320,"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":"12163620","event":"ball","batsman_id":"126384","bowler_id":"115822","over":"3","ball":"4","score":1,"commentary":"Damion Joachim to Mikkel Govia, 1 run,","noball_dismissal":false,"text":"","timestamp":1750191324,"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":"12163622","event":"ball","batsman_id":"114123","bowler_id":"115822","over":"3","ball":"5","score":1,"commentary":"Damion Joachim to Dexter Sween, 1 run,","noball_dismissal":false,"text":"","timestamp":1750191329,"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":"12163623","event":"ball","batsman_id":"126384","bowler_id":"115822","over":"3","ball":"6","score":6,"commentary":"Damion Joachim to Mikkel Govia, Six,","noball_dismissal":false,"text":"","timestamp":1750191333,"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":10,"score":"54\/2","bats":[{"runs":17,"balls_faced":8,"fours":0,"sixes":2,"batsman_id":126384},{"runs":9,"balls_faced":6,"fours":0,"sixes":1,"batsman_id":114123}],"bowls":[{"runs_conceded":10,"maidens":0,"wickets":0,"bowler_id":115822,"overs":1},{"runs_conceded":15,"maidens":0,"wickets":1,"bowler_id":114083,"overs":1}],"commentary":"End of over 4 (10 runs), Scarlet Ibis Scorchers 54\/2"},{"event_id":"12163628","event":"ball","batsman_id":"114123","bowler_id":"140982","over":"4","ball":"1","score":"1wd","commentary":"Selwin Allert to Dexter Sween, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750191375,"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":"12163629","event":"ball","batsman_id":"114123","bowler_id":"140982","over":"4","ball":"1","score":6,"commentary":"Selwin Allert to Dexter Sween, Six,","noball_dismissal":false,"text":"","timestamp":1750191379,"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":"12163631","event":"ball","batsman_id":"114123","bowler_id":"140982","over":"4","ball":"2","score":6,"commentary":"Selwin Allert to Dexter Sween, Six,","noball_dismissal":false,"text":"","timestamp":1750191401,"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":"12163632","event":"ball","batsman_id":"114123","bowler_id":"140982","over":"4","ball":"3","score":4,"commentary":"Selwin Allert to Dexter Sween, Four,","noball_dismissal":false,"text":"","timestamp":1750191426,"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":"12163633","event":"ball","batsman_id":"114123","bowler_id":"140982","over":"4","ball":"4","score":6,"commentary":"Selwin Allert to Dexter Sween, Six,","noball_dismissal":false,"text":"","timestamp":1750191459,"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":198276,"number":2,"name":"Scarlet Ibis Scorchers Inning","short_name":"SLS Inning","status":2,"issuperover":"false","result":3,"batting_team_id":123303,"fielding_team_id":128980,"scores":"77\/2","scores_full":"77\/2 (4.4 ov)","fielder":[{"fielder_id":"140982","fielder_name":"Selwin Allert","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"3"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Daniel Williams","batsman_id":"114116","runs":"12","balls":"6","how_out":"c S Allert b C Vincent","score_at_dismissal":35,"overs_at_dismissal":"2.2","bowler_id":"114083","dismissal":"caught","number":2},"extra_runs":{"byes":4,"legbyes":0,"wides":2,"noballs":1,"penalty":"0","total":7},"equations":{"runs":77,"wickets":2,"overs":"4.4","bowlers_used":5,"runrate":"16.50"},"current_partnership":{"runs":42,"balls":15,"overs":2.3,"batsmen":[{"name":"Dexter Sween","batsman_id":114123,"runs":31,"balls":10},{"name":"Mikkel Govia","batsman_id":126384,"runs":9,"balls":5}]},"did_not_bat":[{"player_id":"128748","name":"Sachin Seecharan"},{"player_id":"114320","name":"Joshua Ramdoo"},{"player_id":"114114","name":"Andrew Rambaran"},{"player_id":"127449","name":"Keron Rampersad "},{"player_id":"116999","name":"Liam Vinode Mamchan"},{"player_id":"114119","name":"Eric Garcia"},{"player_id":"115831","name":"Nicholas Ali"}],"max_over":"10","target":"72","recent_scores":"6,4,6,6,1,6,1,1,0,1,1,1,1,0,0,7,w,6","last_five_overs":"77\/2 14.90","last_ten_overs":"77\/2 14.90"},"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":"77\/2 (4.4 ov)","scores":"77\/2","overs":"4.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":"71\/6 (10 ov)","scores":"71\/6","overs":"10"}],"players":[{"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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","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":8,"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":7,"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":7,"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":"all","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":"https:\/\/www.instagram.com\/terrohinds64","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","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":"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":"(C)"},{"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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","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,"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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","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":"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":"bowl","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":6.5,"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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","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":8.5,"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":"all","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":"all","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":6.5,"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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","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":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":8,"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":"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":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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(WK)"},{"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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""}]},"etag":"cf4061c671c5f2cf0e9bce57f29039b1","modified":"2025-07-24 18:21:42","datetime":"2025-07-24 18:21:42","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":90636,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Scarlet Ibis Scorchers won by 8 wickets","day_remaining_over":"","team_batting":"Scarlet Ibis Scorchers","team_bowling":"Leatherback Strikers","live_inning_number":2,"live_score":{"runs":77,"overs":4.4,"wickets":2,"target":72,"runrate":16.5,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Dexter Sween","batsman_id":114123,"runs":31,"balls_faced":10,"fours":1,"sixes":4,"strike_rate":"310.00"},{"name":"Mikkel Govia","batsman_id":126384,"runs":17,"balls_faced":8,"fours":0,"sixes":2,"strike_rate":"212.50"}],"bowlers":[{"name":"Selwin Allert","bowler_id":140982,"overs":0.4,"runs_conceded":23,"wickets":0,"maidens":0,"econ":"34.50"},{"name":"Damion Joachim","bowler_id":115822,"overs":1,"runs_conceded":10,"wickets":0,"maidens":0,"econ":"10.00"}],"commentaries":[{"event_id":"12163539","event":"ball","batsman_id":"52230","bowler_id":"93874","over":"0","ball":"4","score":0,"commentary":"Terrance Hinds to Cephas Cooper, no run,","noball_dismissal":false,"text":"","timestamp":1750190149,"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":"12163543","event":"ball","batsman_id":"52230","bowler_id":"93874","over":"0","ball":"5","score":6,"commentary":"Terrance Hinds to Cephas Cooper, Six,","noball_dismissal":false,"text":"","timestamp":1750190178,"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":"12163548","event":"wicket","batsman_id":"52230","bowler_id":"93874","over":"0","ball":"6","score":"w","commentary":"Terrance Hinds to Cephas Cooper, no run, b T Hinds,","noball_dismissal":false,"text":"","timestamp":1750190235,"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":"52230","how_out":"b T Hinds","batsman_runs":"10","batsman_balls":"5"},{"event":"overend","over":1,"runs":12,"score":"12\/1","bats":[{"runs":10,"balls_faced":5,"fours":1,"sixes":1,"batsman_id":52230},{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":114116}],"bowls":[{"runs_conceded":12,"maidens":0,"wickets":1,"bowler_id":93874,"overs":1}],"commentary":"End of over 1 (12 runs), Scarlet Ibis Scorchers 12\/1"},{"event_id":"12163557","event":"ball","batsman_id":"114116","bowler_id":"140979","over":"1","ball":"1","score":"4b","commentary":"Junior Bailey to Daniel Williams, 4 bye,","noball_dismissal":false,"text":"","timestamp":1750190555,"run":4,"noball_run":"0","wide_run":"0","bye_run":"4","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12163559","event":"ball","batsman_id":"114116","bowler_id":"140979","over":"1","ball":"2","score":4,"commentary":"Junior Bailey to Daniel Williams, Four,","noball_dismissal":false,"text":"","timestamp":1750190559,"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":"12163562","event":"ball","batsman_id":"114116","bowler_id":"140979","over":"1","ball":"3","score":1,"commentary":"Junior Bailey to Daniel Williams, 1 run,","noball_dismissal":false,"text":"","timestamp":1750190562,"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":"12163565","event":"ball","batsman_id":"126384","bowler_id":"140979","over":"1","ball":"4","score":0,"commentary":"Junior Bailey to Mikkel Govia, no run,","noball_dismissal":false,"text":"","timestamp":1750190567,"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":"12163567","event":"ball","batsman_id":"126384","bowler_id":"140979","over":"1","ball":"5","score":6,"commentary":"Junior Bailey to Mikkel Govia, Six,","noball_dismissal":false,"text":"","timestamp":1750190571,"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":"12163572","event":"ball","batsman_id":"126384","bowler_id":"140979","over":"1","ball":"6","score":2,"commentary":"Junior Bailey to Mikkel Govia, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750190580,"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":"overend","over":2,"runs":17,"score":"29\/1","bats":[{"runs":8,"balls_faced":3,"fours":0,"sixes":1,"batsman_id":126384},{"runs":6,"balls_faced":4,"fours":1,"sixes":0,"batsman_id":114116}],"bowls":[{"runs_conceded":13,"maidens":0,"wickets":0,"bowler_id":140979,"overs":1},{"runs_conceded":12,"maidens":0,"wickets":1,"bowler_id":93874,"overs":1}],"commentary":"End of over 2 (17 runs), Scarlet Ibis Scorchers 29\/1"},{"event_id":"12163580","event":"ball","batsman_id":"114116","bowler_id":"114083","over":"2","ball":"1","score":6,"commentary":"Christopher Vincent to Daniel Williams, Six,","noball_dismissal":false,"text":"","timestamp":1750190717,"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":"12163583","event":"wicket","batsman_id":"114116","bowler_id":"114083","over":"2","ball":"2","score":"w","commentary":"Christopher Vincent to Daniel Williams, no run, c S Allert b C Vincent,","noball_dismissal":false,"text":"","timestamp":1750190758,"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":"114116","how_out":"c S Allert b C Vincent","batsman_runs":"12","batsman_balls":"6"},{"event_id":"12163592","event":"ball","batsman_id":"114123","bowler_id":"114083","over":"2","ball":"3","score":"7nb","commentary":"Christopher Vincent to Dexter Sween, 7 no ball,","noball_dismissal":false,"text":"","timestamp":1750190853,"run":7,"noball_run":"1","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":true,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12163593","event":"ball","batsman_id":"114123","bowler_id":"114083","over":"2","ball":"3","score":0,"commentary":"Christopher Vincent to Dexter Sween, no run,","noball_dismissal":false,"text":"","timestamp":1750190889,"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":"12163595","event":"ball","batsman_id":"114123","bowler_id":"114083","over":"2","ball":"4","score":0,"commentary":"Christopher Vincent to Dexter Sween, no run,","noball_dismissal":false,"text":"","timestamp":1750190909,"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":"12163599","event":"ball","batsman_id":"114123","bowler_id":"114083","over":"2","ball":"5","score":1,"commentary":"Christopher Vincent to Dexter Sween, 1 run,","noball_dismissal":false,"text":"","timestamp":1750190955,"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":"12163601","event":"ball","batsman_id":"126384","bowler_id":"114083","over":"2","ball":"6","score":1,"commentary":"Christopher Vincent to Mikkel Govia, 1 run,","noball_dismissal":false,"text":"","timestamp":1750190988,"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":15,"score":"44\/2","bats":[{"runs":9,"balls_faced":4,"fours":0,"sixes":1,"batsman_id":126384},{"runs":7,"balls_faced":4,"fours":0,"sixes":1,"batsman_id":114123}],"bowls":[{"runs_conceded":15,"maidens":0,"wickets":1,"bowler_id":114083,"overs":1},{"runs_conceded":13,"maidens":0,"wickets":0,"bowler_id":140979,"overs":1}],"commentary":"End of over 3 (15 runs), Scarlet Ibis Scorchers 44\/2"},{"event_id":"12163610","event":"ball","batsman_id":"126384","bowler_id":"115822","over":"3","ball":"1","score":1,"commentary":"Damion Joachim to Mikkel Govia, 1 run,","noball_dismissal":false,"text":"","timestamp":1750191309,"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":"12163613","event":"ball","batsman_id":"114123","bowler_id":"115822","over":"3","ball":"2","score":1,"commentary":"Damion Joachim to Dexter Sween, 1 run,","noball_dismissal":false,"text":"","timestamp":1750191316,"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":"12163614","event":"ball","batsman_id":"126384","bowler_id":"115822","over":"3","ball":"3","score":0,"commentary":"Damion Joachim to Mikkel Govia, no run,","noball_dismissal":false,"text":"","timestamp":1750191320,"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":"12163620","event":"ball","batsman_id":"126384","bowler_id":"115822","over":"3","ball":"4","score":1,"commentary":"Damion Joachim to Mikkel Govia, 1 run,","noball_dismissal":false,"text":"","timestamp":1750191324,"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":"12163622","event":"ball","batsman_id":"114123","bowler_id":"115822","over":"3","ball":"5","score":1,"commentary":"Damion Joachim to Dexter Sween, 1 run,","noball_dismissal":false,"text":"","timestamp":1750191329,"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":"12163623","event":"ball","batsman_id":"126384","bowler_id":"115822","over":"3","ball":"6","score":6,"commentary":"Damion Joachim to Mikkel Govia, Six,","noball_dismissal":false,"text":"","timestamp":1750191333,"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":10,"score":"54\/2","bats":[{"runs":17,"balls_faced":8,"fours":0,"sixes":2,"batsman_id":126384},{"runs":9,"balls_faced":6,"fours":0,"sixes":1,"batsman_id":114123}],"bowls":[{"runs_conceded":10,"maidens":0,"wickets":0,"bowler_id":115822,"overs":1},{"runs_conceded":15,"maidens":0,"wickets":1,"bowler_id":114083,"overs":1}],"commentary":"End of over 4 (10 runs), Scarlet Ibis Scorchers 54\/2"},{"event_id":"12163628","event":"ball","batsman_id":"114123","bowler_id":"140982","over":"4","ball":"1","score":"1wd","commentary":"Selwin Allert to Dexter Sween, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750191375,"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":"12163629","event":"ball","batsman_id":"114123","bowler_id":"140982","over":"4","ball":"1","score":6,"commentary":"Selwin Allert to Dexter Sween, Six,","noball_dismissal":false,"text":"","timestamp":1750191379,"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":"12163631","event":"ball","batsman_id":"114123","bowler_id":"140982","over":"4","ball":"2","score":6,"commentary":"Selwin Allert to Dexter Sween, Six,","noball_dismissal":false,"text":"","timestamp":1750191401,"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":"12163632","event":"ball","batsman_id":"114123","bowler_id":"140982","over":"4","ball":"3","score":4,"commentary":"Selwin Allert to Dexter Sween, Four,","noball_dismissal":false,"text":"","timestamp":1750191426,"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":"12163633","event":"ball","batsman_id":"114123","bowler_id":"140982","over":"4","ball":"4","score":6,"commentary":"Selwin Allert to Dexter Sween, Six,","noball_dismissal":false,"text":"","timestamp":1750191459,"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":198276,"number":2,"name":"Scarlet Ibis Scorchers Inning","short_name":"SLS Inning","status":2,"issuperover":"false","result":3,"batting_team_id":123303,"fielding_team_id":128980,"scores":"77\/2","scores_full":"77\/2 (4.4 ov)","fielder":[{"fielder_id":"140982","fielder_name":"Selwin Allert","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"3"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Daniel Williams","batsman_id":"114116","runs":"12","balls":"6","how_out":"c S Allert b C Vincent","score_at_dismissal":35,"overs_at_dismissal":"2.2","bowler_id":"114083","dismissal":"caught","number":2},"extra_runs":{"byes":4,"legbyes":0,"wides":2,"noballs":1,"penalty":"0","total":7},"equations":{"runs":77,"wickets":2,"overs":"4.4","bowlers_used":5,"runrate":"16.50"},"current_partnership":{"runs":42,"balls":15,"overs":2.3,"batsmen":[{"name":"Dexter Sween","batsman_id":114123,"runs":31,"balls":10},{"name":"Mikkel Govia","batsman_id":126384,"runs":9,"balls":5}]},"did_not_bat":[{"player_id":"128748","name":"Sachin Seecharan"},{"player_id":"114320","name":"Joshua Ramdoo"},{"player_id":"114114","name":"Andrew Rambaran"},{"player_id":"127449","name":"Keron Rampersad "},{"player_id":"116999","name":"Liam Vinode Mamchan"},{"player_id":"114119","name":"Eric Garcia"},{"player_id":"115831","name":"Nicholas Ali"}],"max_over":"10","target":"72","recent_scores":"6,4,6,6,1,6,1,1,0,1,1,1,1,0,0,7,w,6","last_five_overs":"77\/2 14.90","last_ten_overs":"77\/2 14.90"},"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":"77\/2 (4.4 ov)","scores":"77\/2","overs":"4.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":"71\/6 (10 ov)","scores":"71\/6","overs":"10"}],"players":[{"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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","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":8,"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":7,"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":7,"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":"all","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":"https:\/\/www.instagram.com\/terrohinds64","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","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":"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":"(C)"},{"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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","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,"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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","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":"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":"bowl","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":6.5,"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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","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":8.5,"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":"all","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":"all","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":6.5,"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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","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":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":8,"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":"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":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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(WK)"},{"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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""}]},"etag":"cf4061c671c5f2cf0e9bce57f29039b1","modified":"2025-07-24 18:21:42","datetime":"2025-07-24 18:21:42","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90636 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:c923ac29-481a-4e30-b105-240f8e06b27b Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90636 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90636,3,'{"status":"ok","response":{"match_id":90636,"title":"Leatherback Strikers vs Scarlet Ibis Scorchers","short_title":"TLS vs SLS","subtitle":"Match 20","match_number":"20","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Scarlet Ibis Scorchers 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":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":"71\/6 (10 ov)","scores":"71\/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":"77\/2 (4.4 ov)","scores":"77\/2","overs":"4.4"},"date_start":"2025-06-17 18:30:00","date_end":"2025-06-18 04:30:00","timestamp_start":1750185000,"timestamp_end":1750221000,"date_start_ist":"2025-06-18 00:00:00","date_end_ist":"2025-06-18 10:00:00","venue":{"venue_id":"204","name":"Brian Lara Stadium","location":"Tarouba","country":"West Indies","timezone":""},"umpires":"Avinash Narine (West Indies), Andre Martin (West Indies)","referee":"Ramsahai Ramasar (West Indies)","equation":"","live":"","result":"SLS won by 8 wickets","result_type":2,"win_margin":"8 wickets","winning_team_id":123303,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-16 22:08:17","verify_time":"2025-06-18 02:11:33","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"scattered clouds","temp":28.39,"humidity":70,"visibility":10000,"wind_speed":"6.85","clouds":34},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Leatherback Strikers elected to bat","winner":128980,"decision":1}},"etag":"e4e2048ac365771bc4b406530683cc6a","modified":"2025-07-24 18:21:43","datetime":"2025-07-24 18:21:43","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90636,"title":"Leatherback Strikers vs Scarlet Ibis Scorchers","short_title":"TLS vs SLS","subtitle":"Match 20","match_number":"20","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Scarlet Ibis Scorchers 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":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":"71\/6 (10 ov)","scores":"71\/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":"77\/2 (4.4 ov)","scores":"77\/2","overs":"4.4"},"date_start":"2025-06-17 18:30:00","date_end":"2025-06-18 04:30:00","timestamp_start":1750185000,"timestamp_end":1750221000,"date_start_ist":"2025-06-18 00:00:00","date_end_ist":"2025-06-18 10:00:00","venue":{"venue_id":"204","name":"Brian Lara Stadium","location":"Tarouba","country":"West Indies","timezone":""},"umpires":"Avinash Narine (West Indies), Andre Martin (West Indies)","referee":"Ramsahai Ramasar (West Indies)","equation":"","live":"","result":"SLS won by 8 wickets","result_type":2,"win_margin":"8 wickets","winning_team_id":123303,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-16 22:08:17","verify_time":"2025-06-18 02:11:33","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"scattered clouds","temp":28.39,"humidity":70,"visibility":10000,"wind_speed":"6.85","clouds":34},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Leatherback Strikers elected to bat","winner":128980,"decision":1}},"etag":"e4e2048ac365771bc4b406530683cc6a","modified":"2025-07-24 18:21:43","datetime":"2025-07-24 18:21:43","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90636 AND DataTypeId = 3 END
Live Report & Scorecard of Leatherback Strikers vs Scarlet Ibis Scorchers Match 20