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:b307b903-28a9-4f58-8f04-d8cfb2151cbf
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90630 AND DataTypeId = 2) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90630,2,'{"status":"ok","response":{"match_id":90630,"title":"Soca Kings vs SAMP Army Cocrico Cavaliers","short_title":"SCK vs CCL","subtitle":"Match 14","match_number":"14","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Soca Kings won by 31 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":123301,"name":"Soca Kings","short_name":"SCK","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/SCK-CR1@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/SCK-CR1@2x.png","scores_full":"148\/3 (10 ov)","scores":"148\/3","overs":"10"},"teamb":{"team_id":123297,"name":"SAMP Army Cocrico Cavaliers","short_name":"CCL","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/CCL-CR1@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/CCL-CR1@2x.png","scores_full":"117\/4 (10 ov)","scores":"117\/4","overs":"10"},"date_start":"2025-06-15 18:30:00","date_end":"2025-06-16 04:30:00","timestamp_start":1750012200,"timestamp_end":1750048200,"date_start_ist":"2025-06-16 00:00:00","date_end_ist":"2025-06-16 10:00:00","venue":{"venue_id":"204","name":"Brian Lara Stadium","location":"Tarouba","country":"West Indies","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"SCK won by 31 runs","result_type":1,"win_margin":"31 runs","winning_team_id":123301,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-14 00:44:40","verify_time":"2025-06-16 02:54:37","match_dls_affected":"false","live_inning_number":"","day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"broken clouds","temp":28.42,"humidity":67,"visibility":10000,"wind_speed":"8.39","clouds":55},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"SAMP Army Cocrico Cavaliers elected to bowl","winner":123297,"decision":2},"current_over":"","previous_over":"","man_of_the_match":{"pid":52292,"name":"Dejourn Charles","thumb_url":""},"man_of_the_series":"","is_followon":0,"team_batting_first":"","team_batting_second":"","last_five_overs":"","innings":[{"iid":198158,"number":1,"name":"Soca Kings Inning","short_name":"SCK Inning","status":2,"issuperover":"false","result":4,"batting_team_id":123301,"fielding_team_id":123297,"scores":"148\/3","scores_full":"148\/3 (10 ov)","batsmen":[{"name":"Tion Webster","batsman_id":"90945","batting":"false","position":"","role":"bat","role_str":"","runs":"68","balls_faced":"25","fours":"7","sixes":"5","run0":"5","run1":"6","run2":"2","run3":"0","run5":"0","how_out":"c J Joseph b J Bootan","dismissal":"caught","strike_rate":"272.00","bowler_id":"114108","first_fielder_id":"114085","second_fielder_id":"","third_fielder_id":""},{"name":"Dejourn Charles","batsman_id":"52292","batting":"false","position":"","role":"all","role_str":"","runs":"61","balls_faced":"25","fours":"2","sixes":"7","run0":"6","run1":"9","run2":"1","run3":"0","run5":"0","how_out":"c A Mahabirsingh b J Bootan","dismissal":"caught","strike_rate":"244.00","bowler_id":"114108","first_fielder_id":"96615","second_fielder_id":"","third_fielder_id":""},{"name":"Joshua James","batsman_id":"96611","batting":"false","position":"","role":"bat","role_str":"","runs":"8","balls_faced":"5","fours":"2","sixes":"0","run0":"3","run1":"0","run2":"0","run3":"0","run5":"0","how_out":"c K Ramdoo b A R-Toppin","dismissal":"caught","strike_rate":"160.00","bowler_id":"127451","first_fielder_id":"117094","second_fielder_id":"","third_fielder_id":""},{"name":"Shatrughan Rambaran","batsman_id":"114121","batting":"true","position":"striker","role":"all","role_str":"","runs":"4","balls_faced":"4","fours":"0","sixes":"0","run0":"1","run1":"2","run2":"1","run3":"0","run5":"0","how_out":"Not out","dismissal":"","strike_rate":"100.00","bowler_id":"0","first_fielder_id":"","second_fielder_id":"","third_fielder_id":""},{"name":"Trevon James","batsman_id":"147236","batting":"true","position":"non striker","role":"wk","role_str":"(WK)","runs":"1","balls_faced":"1","fours":"0","sixes":"0","run0":"0","run1":"1","run2":"0","run3":"0","run5":"0","how_out":"Not out","dismissal":"","strike_rate":"100.00","bowler_id":"0","first_fielder_id":"","second_fielder_id":"","third_fielder_id":""}],"bowlers":[{"name":"Shaaron Lewis","bowler_id":"114094","bowling":"false","position":"","overs":"2","maidens":"0","runs_conceded":"27","wickets":"0","noballs":"0","wides":"2","econ":"13.50","run0":"3","bowledcount":"0","lbwcount":"0"},{"name":"Abdul Raheem-Toppin","bowler_id":"127451","bowling":"false","position":"last bowler","overs":"2","maidens":"0","runs_conceded":"24","wickets":"1","noballs":"0","wides":"0","econ":"12.00","run0":"5","bowledcount":"0","lbwcount":"0"},{"name":"Jordan Samkaran","bowler_id":"121766","bowling":"false","position":"","overs":"1","maidens":"0","runs_conceded":"25","wickets":"0","noballs":"0","wides":"0","econ":"25.00","run0":"1","bowledcount":"0","lbwcount":"0"},{"name":"Avinash Mahabirsingh","bowler_id":"96615","bowling":"false","position":"","overs":"1","maidens":"0","runs_conceded":"20","wickets":"0","noballs":"0","wides":"2","econ":"20.00","run0":"1","bowledcount":"0","lbwcount":"0"},{"name":"Olando James","bowler_id":"127445","bowling":"false","position":"","overs":"1","maidens":"0","runs_conceded":"15","wickets":"0","noballs":"0","wides":"1","econ":"15.00","run0":"0","bowledcount":"0","lbwcount":"0"},{"name":"Leonardo Julien","bowler_id":"96399","bowling":"false","position":"","overs":"1","maidens":"0","runs_conceded":"20","wickets":"0","noballs":"0","wides":"0","econ":"20.00","run0":"0","bowledcount":"0","lbwcount":"0"},{"name":"Jesse Bootan","bowler_id":"114108","bowling":"true","position":"active bowler","overs":"2","maidens":"0","runs_conceded":"16","wickets":"2","noballs":"0","wides":"0","econ":"8.00","run0":"5","bowledcount":"0","lbwcount":"0"}],"fielder":[{"fielder_id":"114085","fielder_name":"Justin Joseph","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"96615","fielder_name":"Avinash Mahabirsingh","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"117094","fielder_name":"Kyle Ramdoo","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"}},"fows":[{"name":"Tion Webster","batsman_id":"90945","runs":"68","balls":"25","how_out":"c J Joseph b J Bootan","score_at_dismissal":134,"overs_at_dismissal":"7.4","bowler_id":"114108","dismissal":"caught","number":1},{"name":"Joshua James","batsman_id":"96611","runs":"8","balls":"5","how_out":"c K Ramdoo b A R-Toppin","score_at_dismissal":143,"overs_at_dismissal":"8.5","bowler_id":"127451","dismissal":"caught","number":2},{"name":"Dejourn Charles","batsman_id":"52292","runs":"61","balls":"25","how_out":"c A Mahabirsingh b J Bootan","score_at_dismissal":145,"overs_at_dismissal":"9.3","bowler_id":"114108","dismissal":"caught","number":3}],"last_wicket":{"name":"Dejourn Charles","batsman_id":"52292","runs":"61","balls":"25","how_out":"c A Mahabirsingh b J Bootan","score_at_dismissal":145,"overs_at_dismissal":"9.3","bowler_id":"114108","dismissal":"caught","number":3},"extra_runs":{"byes":1,"legbyes":0,"wides":5,"noballs":0,"penalty":"0","total":6},"equations":{"runs":148,"wickets":3,"overs":"10","bowlers_used":7,"runrate":"14.80"},"current_partnership":{"runs":3,"balls":3,"overs":0.3,"batsmen":[{"name":"Trevon James","batsman_id":147236,"runs":1,"balls":1},{"name":"Shatrughan Rambaran","batsman_id":114121,"runs":2,"balls":2}]},"did_not_bat":[{"player_id":"147243","name":"Akeel Mohammed"},{"player_id":"90814","name":"Imran Khan"},{"player_id":"127227","name":"Jon Russ Jagessar"},{"player_id":"114112","name":"Chadeon Raymond"},{"player_id":"43338","name":"Rayad Emrit"},{"player_id":"116243","name":"Aamir Ali"}],"max_over":"10","target":"0"},{"iid":198161,"number":2,"name":"SAMP Army Cocrico Cavaliers Inning","short_name":"CCL Inning","status":2,"issuperover":"false","result":4,"batting_team_id":123297,"fielding_team_id":123301,"scores":"117\/4","scores_full":"117\/4 (10 ov)","batsmen":[{"name":"Kjorn Ottley","batsman_id":"53738","batting":"false","position":"","role":"bat","role_str":"","runs":"30","balls_faced":"16","fours":"1","sixes":"3","run0":"4","run1":"8","run2":"0","run3":"0","run5":"0","how_out":"c RR Emrit b D Charles","dismissal":"caught","strike_rate":"187.50","bowler_id":"52292","first_fielder_id":"43338","second_fielder_id":"","third_fielder_id":""},{"name":"Jesse Bootan","batsman_id":"114108","batting":"false","position":"","role":"all","role_str":"(C)","runs":"14","balls_faced":"9","fours":"0","sixes":"2","run0":"5","run1":"2","run2":"0","run3":"0","run5":"0","how_out":"c RR Emrit b D Charles","dismissal":"caught","strike_rate":"155.56","bowler_id":"52292","first_fielder_id":"43338","second_fielder_id":"","third_fielder_id":""},{"name":"Kyle Ramdoo","batsman_id":"117094","batting":"false","position":"","role":"wk","role_str":"","runs":"33","balls_faced":"21","fours":"0","sixes":"4","run0":"9","run1":"7","run2":"1","run3":"0","run5":"0","how_out":"c A Mohammed b T Webster","dismissal":"caught","strike_rate":"157.14","bowler_id":"90945","first_fielder_id":"147243","second_fielder_id":"","third_fielder_id":""},{"name":"Leonardo Julien","batsman_id":"96399","batting":"false","position":"","role":"wk","role_str":"(WK)","runs":"18","balls_faced":"8","fours":"1","sixes":"2","run0":"3","run1":"2","run2":"0","run3":"0","run5":"0","how_out":"lbw b RR Emrit","dismissal":"lbw","strike_rate":"225.00","bowler_id":"43338","first_fielder_id":"","second_fielder_id":"","third_fielder_id":""},{"name":"Saiba Batoosingh","batsman_id":"52202","batting":"true","position":"non striker","role":"bat","role_str":"","runs":"5","balls_faced":"3","fours":"1","sixes":"0","run0":"1","run1":"1","run2":"0","run3":"0","run5":"0","how_out":"Not out","dismissal":"","strike_rate":"166.67","bowler_id":"0","first_fielder_id":"","second_fielder_id":"","third_fielder_id":""},{"name":"Abdul Raheem-Toppin","batsman_id":"127451","batting":"true","position":"striker","role":"all","role_str":"","runs":"1","balls_faced":"3","fours":"0","sixes":"0","run0":"2","run1":"1","run2":"0","run3":"0","run5":"0","how_out":"Not out","dismissal":"","strike_rate":"33.33","bowler_id":"0","first_fielder_id":"","second_fielder_id":"","third_fielder_id":""}],"bowlers":[{"name":"Rayad Emrit","bowler_id":"43338","bowling":"false","position":"last bowler","overs":"2","maidens":"0","runs_conceded":"19","wickets":"1","noballs":"0","wides":"2","econ":"9.50","run0":"6","bowledcount":"0","lbwcount":"1"},{"name":"Jon Russ Jagessar","bowler_id":"127227","bowling":"false","position":"","overs":"2","maidens":"0","runs_conceded":"18","wickets":"0","noballs":"0","wides":"0","econ":"9.00","run0":"4","bowledcount":"0","lbwcount":"0"},{"name":"Dejourn Charles","bowler_id":"52292","bowling":"false","position":"","overs":"2","maidens":"0","runs_conceded":"24","wickets":"2","noballs":"0","wides":"1","econ":"12.00","run0":"5","bowledcount":"0","lbwcount":"0"},{"name":"Chadeon Raymond","bowler_id":"114112","bowling":"false","position":"","overs":"2","maidens":"0","runs_conceded":"19","wickets":"0","noballs":"0","wides":"2","econ":"9.50","run0":"5","bowledcount":"0","lbwcount":"0"},{"name":"Shatrughan Rambaran","bowler_id":"114121","bowling":"false","position":"","overs":"1","maidens":"0","runs_conceded":"23","wickets":"0","noballs":"0","wides":"4","econ":"23.00","run0":"1","bowledcount":"0","lbwcount":"0"},{"name":"Tion Webster","bowler_id":"90945","bowling":"true","position":"active bowler","overs":"1","maidens":"0","runs_conceded":"8","wickets":"1","noballs":"0","wides":"0","econ":"8.00","run0":"3","bowledcount":"0","lbwcount":"0"}],"fielder":[{"fielder_id":"43338","fielder_name":"Rayad Emrit","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"147243","fielder_name":"Akeel Mohammed","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"}},"fows":[{"name":"Jesse Bootan","batsman_id":"114108","runs":"14","balls":"9","how_out":"c RR Emrit b D Charles","score_at_dismissal":19,"overs_at_dismissal":"2.2","bowler_id":"52292","dismissal":"caught","number":1},{"name":"Kjorn Ottley","batsman_id":"53738","runs":"30","balls":"16","how_out":"c RR Emrit b D Charles","score_at_dismissal":74,"overs_at_dismissal":"6.2","bowler_id":"52292","dismissal":"caught","number":2},{"name":"Leonardo Julien","batsman_id":"96399","runs":"18","balls":"8","how_out":"lbw b RR Emrit","score_at_dismissal":105,"overs_at_dismissal":"8.4","bowler_id":"43338","dismissal":"lbw","number":3},{"name":"Kyle Ramdoo","batsman_id":"117094","runs":"33","balls":"21","how_out":"c A Mohammed b T Webster","score_at_dismissal":115,"overs_at_dismissal":"9.2","bowler_id":"90945","dismissal":"caught","number":4}],"last_wicket":{"name":"Kyle Ramdoo","batsman_id":"117094","runs":"33","balls":"21","how_out":"c A Mohammed b T Webster","score_at_dismissal":115,"overs_at_dismissal":"9.2","bowler_id":"90945","dismissal":"caught","number":4},"extra_runs":{"byes":1,"legbyes":5,"wides":10,"noballs":0,"penalty":"0","total":16},"equations":{"runs":117,"wickets":4,"overs":"10","bowlers_used":6,"runrate":"11.70"},"current_partnership":{"runs":2,"balls":4,"overs":0.4,"batsmen":[{"name":"Abdul Raheem-Toppin","batsman_id":127451,"runs":1,"balls":3},{"name":"Saiba Batoosingh","batsman_id":52202,"runs":1,"balls":1}]},"did_not_bat":[{"player_id":"127445","name":"Olando James"},{"player_id":"114085","name":"Justin Joseph"},{"player_id":"96615","name":"Avinash Mahabirsingh"},{"player_id":"121766","name":"Jordan Samkaran"},{"player_id":"114094","name":"Shaaron Lewis"}],"max_over":"10","target":"149"}],"players":[{"pid":43338,"title":"Rayad Emrit","short_name":"RR Emrit","first_name":"Rayad Emrit","last_name":"","middle_name":"","birthdate":"1981-03-08","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/rayad51","instagram_profile":"https:\/\/www.instagram.com\/rayad51\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":"(C)"},{"pid":52202,"title":"Saiba Batoosingh","short_name":"S Batoosingh","first_name":"Saiba Batoosingh","last_name":"","middle_name":"","birthdate":"1998-10-10","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":52292,"title":"Dejourn Charles","short_name":"D Charles","first_name":"Dejourn Charles","last_name":"","middle_name":"","birthdate":"1997-10-12","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":53738,"title":"Kjorn Ottley","short_name":"KY Ottley","first_name":"Kjorn Ottley","last_name":"","middle_name":"","birthdate":"1989-12-09","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":90814,"title":"Imran Khan","short_name":"I Khan","first_name":"Imran Khan","last_name":"","middle_name":"","birthdate":"1984-07-06","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","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":90945,"title":"Tion Webster","short_name":"T Webster","first_name":"Tion Webster","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":95511,"title":"Akeem Jordan","short_name":"A Jordan","first_name":"Akeem Jordan","last_name":"","middle_name":"","birthdate":"1994-10-18","birthplace":"Barbados","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/akeem_jordan\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":96399,"title":"Leonardo Julien","short_name":"L Julien","first_name":"Leonardo Julien","last_name":"","middle_name":"","birthdate":"2001-09-09","birthplace":"Trinidad & Tobago","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(WK)"},{"pid":96611,"title":"Joshua James","short_name":"J James","first_name":"Joshua James","last_name":"","middle_name":"","birthdate":"2001-02-21","birthplace":"Trinidad & Tobago","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":96615,"title":"Avinash Mahabirsingh","short_name":"A Mahabirsingh","first_name":"Avinash Mahabirsingh","last_name":"","middle_name":"","birthdate":"2001-04-17","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":109937,"title":"Sion Hackett","short_name":"S Hackett","first_name":"Sion Hackett","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":null,"role":"squad","role_str":""},{"pid":114085,"title":"Justin Joseph","short_name":"J Joseph","first_name":"Justin Joseph","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":114094,"title":"Shaaron Lewis","short_name":"S Lewis","first_name":"Shaaron Lewis","last_name":"","middle_name":"","birthdate":"1998-03-12","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":114108,"title":"Jesse Bootan","short_name":"J Bootan","first_name":"Jesse Bootan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":"(C)"},{"pid":114112,"title":"Chadeon Raymond","short_name":"C Raymond","first_name":"Chadeon Raymond","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":114121,"title":"Shatrughan Rambaran","short_name":"S Rambaran","first_name":"Shatrughan Rambaran","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":115835,"title":"Denzil Antoine","short_name":"D Antoine","first_name":"Denzil Antoine","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":116243,"title":"Aamir Ali","short_name":"A Ali","first_name":"Aamir Ali","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":117094,"title":"Kyle Ramdoo","short_name":"K Ramdoo","first_name":"Kyle Ramdoo","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":""},{"pid":121766,"title":"Jordan Samkaran","short_name":"J Samkaran","first_name":"Jordan Samkaran","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":127227,"title":"Jon Russ Jagessar","short_name":"Jon Jagessar","first_name":"Jon Russ Jagessar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":127444,"title":"Ricardo Chase","short_name":"R Chase","first_name":"Ricardo Chase","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":127445,"title":"Olando James","short_name":"O James","first_name":"Olando James","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":127451,"title":"Abdul Raheem-Toppin","short_name":"A R-Toppin","first_name":"Abdul Raheem-Toppin","last_name":"","middle_name":"","birthdate":"2005-10-18","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":138825,"title":"Aneal Rooplal","short_name":"A Rooplal","first_name":"Aneal Rooplal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":139127,"title":"Abdur Rahman Juman","short_name":"A R Juman","first_name":"Abdur Rahman Juman","last_name":"","middle_name":"","birthdate":"2003-11-14","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":147236,"title":"Trevon James","short_name":"T James","first_name":"Trevon James","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(WK)"},{"pid":147243,"title":"Akeel Mohammed","short_name":"A Mohammed","first_name":"Akeel Mohammed","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":147508,"title":"Christian Lall","short_name":"C Lall","first_name":"Christian Lall","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":149739,"title":"Justin Rajkumar","short_name":"J Rajkumar","first_name":"Justin Rajkumar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""}],"pre_match_odds":[],"day_remaining_over":"","match_notes":[["Soca Kings inning 1","Soca Kings: 50 runs in 2.4 overs.","50 run partnership of 16 balls,Dejourn Charles 25(6) runs, Tion Webster 28(10) runs.","Powerplay 1 (0.1 - 3) Run 54, wicket 0","Soca Kings: 100 runs in 5.4 overs.","100 run partnership of 34 balls,Tion Webster 53(19) runs, Dejourn Charles 46(15) runs.","Tion Webster 53 runs in 19 balls (4 x 7, 6 X 3).","Dejourn Charles 53 runs in 18 balls (4 x 2, 6 X 6).","Innings Break: Soca Kings - 148\/3 overs 10 (balls 60)."],["SAMP Army Cocrico Cavaliers inning 2","Powerplay 1 (0.1 - 3) Run 27, wicket 1","SAMP Army Cocrico Cavaliers: 50 runs in 5.2 overs.","50 run partnership of 23 balls,Kjorn Ottley 27(10) runs, Kyle Ramdoo 18(13) runs.","SAMP Army Cocrico Cavaliers: 100 runs in 7.6 overs."]]},"etag":"3e67591748eef0c951a9747e73eec229","modified":"2025-07-16 09:05:31","datetime":"2025-07-16 09:05:31","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90630,"title":"Soca Kings vs SAMP Army Cocrico Cavaliers","short_title":"SCK vs CCL","subtitle":"Match 14","match_number":"14","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Soca Kings won by 31 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":123301,"name":"Soca Kings","short_name":"SCK","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/SCK-CR1@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/SCK-CR1@2x.png","scores_full":"148\/3 (10 ov)","scores":"148\/3","overs":"10"},"teamb":{"team_id":123297,"name":"SAMP Army Cocrico Cavaliers","short_name":"CCL","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/CCL-CR1@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/CCL-CR1@2x.png","scores_full":"117\/4 (10 ov)","scores":"117\/4","overs":"10"},"date_start":"2025-06-15 18:30:00","date_end":"2025-06-16 04:30:00","timestamp_start":1750012200,"timestamp_end":1750048200,"date_start_ist":"2025-06-16 00:00:00","date_end_ist":"2025-06-16 10:00:00","venue":{"venue_id":"204","name":"Brian Lara Stadium","location":"Tarouba","country":"West Indies","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"SCK won by 31 runs","result_type":1,"win_margin":"31 runs","winning_team_id":123301,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-14 00:44:40","verify_time":"2025-06-16 02:54:37","match_dls_affected":"false","live_inning_number":"","day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"broken clouds","temp":28.42,"humidity":67,"visibility":10000,"wind_speed":"8.39","clouds":55},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"SAMP Army Cocrico Cavaliers elected to bowl","winner":123297,"decision":2},"current_over":"","previous_over":"","man_of_the_match":{"pid":52292,"name":"Dejourn Charles","thumb_url":""},"man_of_the_series":"","is_followon":0,"team_batting_first":"","team_batting_second":"","last_five_overs":"","innings":[{"iid":198158,"number":1,"name":"Soca Kings Inning","short_name":"SCK Inning","status":2,"issuperover":"false","result":4,"batting_team_id":123301,"fielding_team_id":123297,"scores":"148\/3","scores_full":"148\/3 (10 ov)","batsmen":[{"name":"Tion Webster","batsman_id":"90945","batting":"false","position":"","role":"bat","role_str":"","runs":"68","balls_faced":"25","fours":"7","sixes":"5","run0":"5","run1":"6","run2":"2","run3":"0","run5":"0","how_out":"c J Joseph b J Bootan","dismissal":"caught","strike_rate":"272.00","bowler_id":"114108","first_fielder_id":"114085","second_fielder_id":"","third_fielder_id":""},{"name":"Dejourn Charles","batsman_id":"52292","batting":"false","position":"","role":"all","role_str":"","runs":"61","balls_faced":"25","fours":"2","sixes":"7","run0":"6","run1":"9","run2":"1","run3":"0","run5":"0","how_out":"c A Mahabirsingh b J Bootan","dismissal":"caught","strike_rate":"244.00","bowler_id":"114108","first_fielder_id":"96615","second_fielder_id":"","third_fielder_id":""},{"name":"Joshua James","batsman_id":"96611","batting":"false","position":"","role":"bat","role_str":"","runs":"8","balls_faced":"5","fours":"2","sixes":"0","run0":"3","run1":"0","run2":"0","run3":"0","run5":"0","how_out":"c K Ramdoo b A R-Toppin","dismissal":"caught","strike_rate":"160.00","bowler_id":"127451","first_fielder_id":"117094","second_fielder_id":"","third_fielder_id":""},{"name":"Shatrughan Rambaran","batsman_id":"114121","batting":"true","position":"striker","role":"all","role_str":"","runs":"4","balls_faced":"4","fours":"0","sixes":"0","run0":"1","run1":"2","run2":"1","run3":"0","run5":"0","how_out":"Not out","dismissal":"","strike_rate":"100.00","bowler_id":"0","first_fielder_id":"","second_fielder_id":"","third_fielder_id":""},{"name":"Trevon James","batsman_id":"147236","batting":"true","position":"non striker","role":"wk","role_str":"(WK)","runs":"1","balls_faced":"1","fours":"0","sixes":"0","run0":"0","run1":"1","run2":"0","run3":"0","run5":"0","how_out":"Not out","dismissal":"","strike_rate":"100.00","bowler_id":"0","first_fielder_id":"","second_fielder_id":"","third_fielder_id":""}],"bowlers":[{"name":"Shaaron Lewis","bowler_id":"114094","bowling":"false","position":"","overs":"2","maidens":"0","runs_conceded":"27","wickets":"0","noballs":"0","wides":"2","econ":"13.50","run0":"3","bowledcount":"0","lbwcount":"0"},{"name":"Abdul Raheem-Toppin","bowler_id":"127451","bowling":"false","position":"last bowler","overs":"2","maidens":"0","runs_conceded":"24","wickets":"1","noballs":"0","wides":"0","econ":"12.00","run0":"5","bowledcount":"0","lbwcount":"0"},{"name":"Jordan Samkaran","bowler_id":"121766","bowling":"false","position":"","overs":"1","maidens":"0","runs_conceded":"25","wickets":"0","noballs":"0","wides":"0","econ":"25.00","run0":"1","bowledcount":"0","lbwcount":"0"},{"name":"Avinash Mahabirsingh","bowler_id":"96615","bowling":"false","position":"","overs":"1","maidens":"0","runs_conceded":"20","wickets":"0","noballs":"0","wides":"2","econ":"20.00","run0":"1","bowledcount":"0","lbwcount":"0"},{"name":"Olando James","bowler_id":"127445","bowling":"false","position":"","overs":"1","maidens":"0","runs_conceded":"15","wickets":"0","noballs":"0","wides":"1","econ":"15.00","run0":"0","bowledcount":"0","lbwcount":"0"},{"name":"Leonardo Julien","bowler_id":"96399","bowling":"false","position":"","overs":"1","maidens":"0","runs_conceded":"20","wickets":"0","noballs":"0","wides":"0","econ":"20.00","run0":"0","bowledcount":"0","lbwcount":"0"},{"name":"Jesse Bootan","bowler_id":"114108","bowling":"true","position":"active bowler","overs":"2","maidens":"0","runs_conceded":"16","wickets":"2","noballs":"0","wides":"0","econ":"8.00","run0":"5","bowledcount":"0","lbwcount":"0"}],"fielder":[{"fielder_id":"114085","fielder_name":"Justin Joseph","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"96615","fielder_name":"Avinash Mahabirsingh","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"117094","fielder_name":"Kyle Ramdoo","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"}},"fows":[{"name":"Tion Webster","batsman_id":"90945","runs":"68","balls":"25","how_out":"c J Joseph b J Bootan","score_at_dismissal":134,"overs_at_dismissal":"7.4","bowler_id":"114108","dismissal":"caught","number":1},{"name":"Joshua James","batsman_id":"96611","runs":"8","balls":"5","how_out":"c K Ramdoo b A R-Toppin","score_at_dismissal":143,"overs_at_dismissal":"8.5","bowler_id":"127451","dismissal":"caught","number":2},{"name":"Dejourn Charles","batsman_id":"52292","runs":"61","balls":"25","how_out":"c A Mahabirsingh b J Bootan","score_at_dismissal":145,"overs_at_dismissal":"9.3","bowler_id":"114108","dismissal":"caught","number":3}],"last_wicket":{"name":"Dejourn Charles","batsman_id":"52292","runs":"61","balls":"25","how_out":"c A Mahabirsingh b J Bootan","score_at_dismissal":145,"overs_at_dismissal":"9.3","bowler_id":"114108","dismissal":"caught","number":3},"extra_runs":{"byes":1,"legbyes":0,"wides":5,"noballs":0,"penalty":"0","total":6},"equations":{"runs":148,"wickets":3,"overs":"10","bowlers_used":7,"runrate":"14.80"},"current_partnership":{"runs":3,"balls":3,"overs":0.3,"batsmen":[{"name":"Trevon James","batsman_id":147236,"runs":1,"balls":1},{"name":"Shatrughan Rambaran","batsman_id":114121,"runs":2,"balls":2}]},"did_not_bat":[{"player_id":"147243","name":"Akeel Mohammed"},{"player_id":"90814","name":"Imran Khan"},{"player_id":"127227","name":"Jon Russ Jagessar"},{"player_id":"114112","name":"Chadeon Raymond"},{"player_id":"43338","name":"Rayad Emrit"},{"player_id":"116243","name":"Aamir Ali"}],"max_over":"10","target":"0"},{"iid":198161,"number":2,"name":"SAMP Army Cocrico Cavaliers Inning","short_name":"CCL Inning","status":2,"issuperover":"false","result":4,"batting_team_id":123297,"fielding_team_id":123301,"scores":"117\/4","scores_full":"117\/4 (10 ov)","batsmen":[{"name":"Kjorn Ottley","batsman_id":"53738","batting":"false","position":"","role":"bat","role_str":"","runs":"30","balls_faced":"16","fours":"1","sixes":"3","run0":"4","run1":"8","run2":"0","run3":"0","run5":"0","how_out":"c RR Emrit b D Charles","dismissal":"caught","strike_rate":"187.50","bowler_id":"52292","first_fielder_id":"43338","second_fielder_id":"","third_fielder_id":""},{"name":"Jesse Bootan","batsman_id":"114108","batting":"false","position":"","role":"all","role_str":"(C)","runs":"14","balls_faced":"9","fours":"0","sixes":"2","run0":"5","run1":"2","run2":"0","run3":"0","run5":"0","how_out":"c RR Emrit b D Charles","dismissal":"caught","strike_rate":"155.56","bowler_id":"52292","first_fielder_id":"43338","second_fielder_id":"","third_fielder_id":""},{"name":"Kyle Ramdoo","batsman_id":"117094","batting":"false","position":"","role":"wk","role_str":"","runs":"33","balls_faced":"21","fours":"0","sixes":"4","run0":"9","run1":"7","run2":"1","run3":"0","run5":"0","how_out":"c A Mohammed b T Webster","dismissal":"caught","strike_rate":"157.14","bowler_id":"90945","first_fielder_id":"147243","second_fielder_id":"","third_fielder_id":""},{"name":"Leonardo Julien","batsman_id":"96399","batting":"false","position":"","role":"wk","role_str":"(WK)","runs":"18","balls_faced":"8","fours":"1","sixes":"2","run0":"3","run1":"2","run2":"0","run3":"0","run5":"0","how_out":"lbw b RR Emrit","dismissal":"lbw","strike_rate":"225.00","bowler_id":"43338","first_fielder_id":"","second_fielder_id":"","third_fielder_id":""},{"name":"Saiba Batoosingh","batsman_id":"52202","batting":"true","position":"non striker","role":"bat","role_str":"","runs":"5","balls_faced":"3","fours":"1","sixes":"0","run0":"1","run1":"1","run2":"0","run3":"0","run5":"0","how_out":"Not out","dismissal":"","strike_rate":"166.67","bowler_id":"0","first_fielder_id":"","second_fielder_id":"","third_fielder_id":""},{"name":"Abdul Raheem-Toppin","batsman_id":"127451","batting":"true","position":"striker","role":"all","role_str":"","runs":"1","balls_faced":"3","fours":"0","sixes":"0","run0":"2","run1":"1","run2":"0","run3":"0","run5":"0","how_out":"Not out","dismissal":"","strike_rate":"33.33","bowler_id":"0","first_fielder_id":"","second_fielder_id":"","third_fielder_id":""}],"bowlers":[{"name":"Rayad Emrit","bowler_id":"43338","bowling":"false","position":"last bowler","overs":"2","maidens":"0","runs_conceded":"19","wickets":"1","noballs":"0","wides":"2","econ":"9.50","run0":"6","bowledcount":"0","lbwcount":"1"},{"name":"Jon Russ Jagessar","bowler_id":"127227","bowling":"false","position":"","overs":"2","maidens":"0","runs_conceded":"18","wickets":"0","noballs":"0","wides":"0","econ":"9.00","run0":"4","bowledcount":"0","lbwcount":"0"},{"name":"Dejourn Charles","bowler_id":"52292","bowling":"false","position":"","overs":"2","maidens":"0","runs_conceded":"24","wickets":"2","noballs":"0","wides":"1","econ":"12.00","run0":"5","bowledcount":"0","lbwcount":"0"},{"name":"Chadeon Raymond","bowler_id":"114112","bowling":"false","position":"","overs":"2","maidens":"0","runs_conceded":"19","wickets":"0","noballs":"0","wides":"2","econ":"9.50","run0":"5","bowledcount":"0","lbwcount":"0"},{"name":"Shatrughan Rambaran","bowler_id":"114121","bowling":"false","position":"","overs":"1","maidens":"0","runs_conceded":"23","wickets":"0","noballs":"0","wides":"4","econ":"23.00","run0":"1","bowledcount":"0","lbwcount":"0"},{"name":"Tion Webster","bowler_id":"90945","bowling":"true","position":"active bowler","overs":"1","maidens":"0","runs_conceded":"8","wickets":"1","noballs":"0","wides":"0","econ":"8.00","run0":"3","bowledcount":"0","lbwcount":"0"}],"fielder":[{"fielder_id":"43338","fielder_name":"Rayad Emrit","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"147243","fielder_name":"Akeel Mohammed","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"}},"fows":[{"name":"Jesse Bootan","batsman_id":"114108","runs":"14","balls":"9","how_out":"c RR Emrit b D Charles","score_at_dismissal":19,"overs_at_dismissal":"2.2","bowler_id":"52292","dismissal":"caught","number":1},{"name":"Kjorn Ottley","batsman_id":"53738","runs":"30","balls":"16","how_out":"c RR Emrit b D Charles","score_at_dismissal":74,"overs_at_dismissal":"6.2","bowler_id":"52292","dismissal":"caught","number":2},{"name":"Leonardo Julien","batsman_id":"96399","runs":"18","balls":"8","how_out":"lbw b RR Emrit","score_at_dismissal":105,"overs_at_dismissal":"8.4","bowler_id":"43338","dismissal":"lbw","number":3},{"name":"Kyle Ramdoo","batsman_id":"117094","runs":"33","balls":"21","how_out":"c A Mohammed b T Webster","score_at_dismissal":115,"overs_at_dismissal":"9.2","bowler_id":"90945","dismissal":"caught","number":4}],"last_wicket":{"name":"Kyle Ramdoo","batsman_id":"117094","runs":"33","balls":"21","how_out":"c A Mohammed b T Webster","score_at_dismissal":115,"overs_at_dismissal":"9.2","bowler_id":"90945","dismissal":"caught","number":4},"extra_runs":{"byes":1,"legbyes":5,"wides":10,"noballs":0,"penalty":"0","total":16},"equations":{"runs":117,"wickets":4,"overs":"10","bowlers_used":6,"runrate":"11.70"},"current_partnership":{"runs":2,"balls":4,"overs":0.4,"batsmen":[{"name":"Abdul Raheem-Toppin","batsman_id":127451,"runs":1,"balls":3},{"name":"Saiba Batoosingh","batsman_id":52202,"runs":1,"balls":1}]},"did_not_bat":[{"player_id":"127445","name":"Olando James"},{"player_id":"114085","name":"Justin Joseph"},{"player_id":"96615","name":"Avinash Mahabirsingh"},{"player_id":"121766","name":"Jordan Samkaran"},{"player_id":"114094","name":"Shaaron Lewis"}],"max_over":"10","target":"149"}],"players":[{"pid":43338,"title":"Rayad Emrit","short_name":"RR Emrit","first_name":"Rayad Emrit","last_name":"","middle_name":"","birthdate":"1981-03-08","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/rayad51","instagram_profile":"https:\/\/www.instagram.com\/rayad51\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":"(C)"},{"pid":52202,"title":"Saiba Batoosingh","short_name":"S Batoosingh","first_name":"Saiba Batoosingh","last_name":"","middle_name":"","birthdate":"1998-10-10","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":52292,"title":"Dejourn Charles","short_name":"D Charles","first_name":"Dejourn Charles","last_name":"","middle_name":"","birthdate":"1997-10-12","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":53738,"title":"Kjorn Ottley","short_name":"KY Ottley","first_name":"Kjorn Ottley","last_name":"","middle_name":"","birthdate":"1989-12-09","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":90814,"title":"Imran Khan","short_name":"I Khan","first_name":"Imran Khan","last_name":"","middle_name":"","birthdate":"1984-07-06","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","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":90945,"title":"Tion Webster","short_name":"T Webster","first_name":"Tion Webster","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":95511,"title":"Akeem Jordan","short_name":"A Jordan","first_name":"Akeem Jordan","last_name":"","middle_name":"","birthdate":"1994-10-18","birthplace":"Barbados","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/akeem_jordan\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":96399,"title":"Leonardo Julien","short_name":"L Julien","first_name":"Leonardo Julien","last_name":"","middle_name":"","birthdate":"2001-09-09","birthplace":"Trinidad & Tobago","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(WK)"},{"pid":96611,"title":"Joshua James","short_name":"J James","first_name":"Joshua James","last_name":"","middle_name":"","birthdate":"2001-02-21","birthplace":"Trinidad & Tobago","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":96615,"title":"Avinash Mahabirsingh","short_name":"A Mahabirsingh","first_name":"Avinash Mahabirsingh","last_name":"","middle_name":"","birthdate":"2001-04-17","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":109937,"title":"Sion Hackett","short_name":"S Hackett","first_name":"Sion Hackett","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":null,"role":"squad","role_str":""},{"pid":114085,"title":"Justin Joseph","short_name":"J Joseph","first_name":"Justin Joseph","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":114094,"title":"Shaaron Lewis","short_name":"S Lewis","first_name":"Shaaron Lewis","last_name":"","middle_name":"","birthdate":"1998-03-12","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":114108,"title":"Jesse Bootan","short_name":"J Bootan","first_name":"Jesse Bootan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":"(C)"},{"pid":114112,"title":"Chadeon Raymond","short_name":"C Raymond","first_name":"Chadeon Raymond","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":114121,"title":"Shatrughan Rambaran","short_name":"S Rambaran","first_name":"Shatrughan Rambaran","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":115835,"title":"Denzil Antoine","short_name":"D Antoine","first_name":"Denzil Antoine","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":116243,"title":"Aamir Ali","short_name":"A Ali","first_name":"Aamir Ali","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":117094,"title":"Kyle Ramdoo","short_name":"K Ramdoo","first_name":"Kyle Ramdoo","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":""},{"pid":121766,"title":"Jordan Samkaran","short_name":"J Samkaran","first_name":"Jordan Samkaran","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":127227,"title":"Jon Russ Jagessar","short_name":"Jon Jagessar","first_name":"Jon Russ Jagessar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":127444,"title":"Ricardo Chase","short_name":"R Chase","first_name":"Ricardo Chase","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":127445,"title":"Olando James","short_name":"O James","first_name":"Olando James","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":127451,"title":"Abdul Raheem-Toppin","short_name":"A R-Toppin","first_name":"Abdul Raheem-Toppin","last_name":"","middle_name":"","birthdate":"2005-10-18","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":138825,"title":"Aneal Rooplal","short_name":"A Rooplal","first_name":"Aneal Rooplal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":139127,"title":"Abdur Rahman Juman","short_name":"A R Juman","first_name":"Abdur Rahman Juman","last_name":"","middle_name":"","birthdate":"2003-11-14","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":147236,"title":"Trevon James","short_name":"T James","first_name":"Trevon James","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(WK)"},{"pid":147243,"title":"Akeel Mohammed","short_name":"A Mohammed","first_name":"Akeel Mohammed","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":147508,"title":"Christian Lall","short_name":"C Lall","first_name":"Christian Lall","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":149739,"title":"Justin Rajkumar","short_name":"J Rajkumar","first_name":"Justin Rajkumar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""}],"pre_match_odds":[],"day_remaining_over":"","match_notes":[["Soca Kings inning 1","Soca Kings: 50 runs in 2.4 overs.","50 run partnership of 16 balls,Dejourn Charles 25(6) runs, Tion Webster 28(10) runs.","Powerplay 1 (0.1 - 3) Run 54, wicket 0","Soca Kings: 100 runs in 5.4 overs.","100 run partnership of 34 balls,Tion Webster 53(19) runs, Dejourn Charles 46(15) runs.","Tion Webster 53 runs in 19 balls (4 x 7, 6 X 3).","Dejourn Charles 53 runs in 18 balls (4 x 2, 6 X 6).","Innings Break: Soca Kings - 148\/3 overs 10 (balls 60)."],["SAMP Army Cocrico Cavaliers inning 2","Powerplay 1 (0.1 - 3) Run 27, wicket 1","SAMP Army Cocrico Cavaliers: 50 runs in 5.2 overs.","50 run partnership of 23 balls,Kjorn Ottley 27(10) runs, Kyle Ramdoo 18(13) runs.","SAMP Army Cocrico Cavaliers: 100 runs in 7.6 overs."]]},"etag":"3e67591748eef0c951a9747e73eec229","modified":"2025-07-16 09:05:31","datetime":"2025-07-16 09:05:31","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90630 AND DataTypeId = 2 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:b307b903-28a9-4f58-8f04-d8cfb2151cbf
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90630 AND DataTypeId = 8) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90630,8,'{"status":"ok","response":{"teama":{"team_id":123301,"squads":[{"player_id":"147236","substitute":"false","out":"false","in":"false","role_str":"(WK)","role":"wk","playing11":"true","name":"Trevon James"},{"player_id":"90945","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Tion Webster"},{"player_id":"96611","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Joshua James"},{"player_id":"147243","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Akeel Mohammed"},{"player_id":"52292","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"Dejourn Charles"},{"player_id":"90814","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"Imran Khan"},{"player_id":"114121","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"Shatrughan Rambaran"},{"player_id":"127227","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Jon Russ Jagessar"},{"player_id":"114112","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Chadeon Raymond"},{"player_id":"43338","substitute":"false","out":"false","in":"false","role_str":"(C)","role":"bowl","playing11":"true","name":"Rayad Emrit"},{"player_id":"116243","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Aamir Ali"},{"player_id":"147508","substitute":"false","out":"false","in":"false","role_str":"","role":"wk","playing11":"false","name":"Christian Lall"},{"player_id":"109937","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"false","name":"Sion Hackett"},{"player_id":"115835","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"false","name":"Denzil Antoine"},{"player_id":"139127","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"false","name":"Abdur Rahman Juman"}]},"teamb":{"team_id":123297,"squads":[{"player_id":"96399","substitute":"false","out":"false","in":"false","role_str":"(WK)","role":"wk","playing11":"true","name":"Leonardo Julien"},{"player_id":"117094","substitute":"false","out":"false","in":"false","role_str":"","role":"wk","playing11":"true","name":"Kyle Ramdoo"},{"player_id":"52202","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Saiba Batoosingh"},{"player_id":"53738","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Kjorn Ottley"},{"player_id":"127445","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Olando James"},{"player_id":"114108","substitute":"false","out":"false","in":"false","role_str":"(C)","role":"all","playing11":"true","name":"Jesse Bootan"},{"player_id":"114085","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"Justin Joseph"},{"player_id":"127451","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"Abdul Raheem-Toppin"},{"player_id":"96615","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Avinash Mahabirsingh"},{"player_id":"121766","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Jordan Samkaran"},{"player_id":"114094","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Shaaron Lewis"},{"player_id":"95511","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"false","name":"Akeem Jordan"},{"player_id":"138825","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"false","name":"Aneal Rooplal"},{"player_id":"127444","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"false","name":"Ricardo Chase"},{"player_id":"149739","substitute":"false","out":"false","in":"false","role_str":"","role":"wk","playing11":"false","name":"Justin Rajkumar"}]},"teams":[{"tid":123297,"title":"SAMP Army Cocrico Cavaliers","abbr":"CCL","alt_name":"Cocrico Cavaliers","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/CCL-CR1@2x.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/CCL-CR1@2x.png","country":"wi","sex":"male","team_owner":"","head_coach":""},{"tid":123301,"title":"Soca Kings","abbr":"SCK","alt_name":"Soca Kings","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/SCK-CR1@2x.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/SCK-CR1@2x.png","country":"wi","sex":"male","team_owner":"","head_coach":""}],"players":[{"pid":43338,"title":"Rayad Emrit","short_name":"RR Emrit","first_name":"Rayad Emrit","last_name":"","middle_name":"","birthdate":"1981-03-08","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/rayad51","instagram_profile":"https:\/\/www.instagram.com\/rayad51\/","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":52202,"title":"Saiba Batoosingh","short_name":"S Batoosingh","first_name":"Saiba Batoosingh","last_name":"","middle_name":"","birthdate":"1998-10-10","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":52292,"title":"Dejourn Charles","short_name":"D Charles","first_name":"Dejourn Charles","last_name":"","middle_name":"","birthdate":"1997-10-12","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":53738,"title":"Kjorn Ottley","short_name":"KY Ottley","first_name":"Kjorn Ottley","last_name":"","middle_name":"","birthdate":"1989-12-09","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":90814,"title":"Imran Khan","short_name":"I Khan","first_name":"Imran Khan","last_name":"","middle_name":"","birthdate":"1984-07-06","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":90945,"title":"Tion Webster","short_name":"T Webster","first_name":"Tion Webster","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":95511,"title":"Akeem Jordan","short_name":"A Jordan","first_name":"Akeem Jordan","last_name":"","middle_name":"","birthdate":"1994-10-18","birthplace":"Barbados","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/akeem_jordan\/","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":96399,"title":"Leonardo Julien","short_name":"L Julien","first_name":"Leonardo Julien","last_name":"","middle_name":"","birthdate":"2001-09-09","birthplace":"Trinidad & Tobago","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":96611,"title":"Joshua James","short_name":"J James","first_name":"Joshua James","last_name":"","middle_name":"","birthdate":"2001-02-21","birthplace":"Trinidad & Tobago","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":96615,"title":"Avinash Mahabirsingh","short_name":"A Mahabirsingh","first_name":"Avinash Mahabirsingh","last_name":"","middle_name":"","birthdate":"2001-04-17","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":109937,"title":"Sion Hackett","short_name":"S Hackett","first_name":"Sion Hackett","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":null},{"pid":114085,"title":"Justin Joseph","short_name":"J Joseph","first_name":"Justin Joseph","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":114094,"title":"Shaaron Lewis","short_name":"S Lewis","first_name":"Shaaron Lewis","last_name":"","middle_name":"","birthdate":"1998-03-12","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":114108,"title":"Jesse Bootan","short_name":"J Bootan","first_name":"Jesse Bootan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":114112,"title":"Chadeon Raymond","short_name":"C Raymond","first_name":"Chadeon Raymond","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":114121,"title":"Shatrughan Rambaran","short_name":"S Rambaran","first_name":"Shatrughan Rambaran","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":115835,"title":"Denzil Antoine","short_name":"D Antoine","first_name":"Denzil Antoine","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":116243,"title":"Aamir Ali","short_name":"A Ali","first_name":"Aamir Ali","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":117094,"title":"Kyle Ramdoo","short_name":"K Ramdoo","first_name":"Kyle Ramdoo","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":121766,"title":"Jordan Samkaran","short_name":"J Samkaran","first_name":"Jordan Samkaran","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":127227,"title":"Jon Russ Jagessar","short_name":"Jon Jagessar","first_name":"Jon Russ Jagessar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":127444,"title":"Ricardo Chase","short_name":"R Chase","first_name":"Ricardo Chase","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":127445,"title":"Olando James","short_name":"O James","first_name":"Olando James","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":127451,"title":"Abdul Raheem-Toppin","short_name":"A R-Toppin","first_name":"Abdul Raheem-Toppin","last_name":"","middle_name":"","birthdate":"2005-10-18","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":138825,"title":"Aneal Rooplal","short_name":"A Rooplal","first_name":"Aneal Rooplal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":139127,"title":"Abdur Rahman Juman","short_name":"A R Juman","first_name":"Abdur Rahman Juman","last_name":"","middle_name":"","birthdate":"2003-11-14","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":147236,"title":"Trevon James","short_name":"T James","first_name":"Trevon James","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":147243,"title":"Akeel Mohammed","short_name":"A Mohammed","first_name":"Akeel Mohammed","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":147508,"title":"Christian Lall","short_name":"C Lall","first_name":"Christian Lall","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":149739,"title":"Justin Rajkumar","short_name":"J Rajkumar","first_name":"Justin Rajkumar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"}]},"etag":"cc0157000b2e619350a6d03decb923dc","modified":"2025-07-16 09:05:32","datetime":"2025-07-16 09:05:32","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"teama":{"team_id":123301,"squads":[{"player_id":"147236","substitute":"false","out":"false","in":"false","role_str":"(WK)","role":"wk","playing11":"true","name":"Trevon James"},{"player_id":"90945","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Tion Webster"},{"player_id":"96611","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Joshua James"},{"player_id":"147243","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Akeel Mohammed"},{"player_id":"52292","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"Dejourn Charles"},{"player_id":"90814","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"Imran Khan"},{"player_id":"114121","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"Shatrughan Rambaran"},{"player_id":"127227","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Jon Russ Jagessar"},{"player_id":"114112","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Chadeon Raymond"},{"player_id":"43338","substitute":"false","out":"false","in":"false","role_str":"(C)","role":"bowl","playing11":"true","name":"Rayad Emrit"},{"player_id":"116243","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Aamir Ali"},{"player_id":"147508","substitute":"false","out":"false","in":"false","role_str":"","role":"wk","playing11":"false","name":"Christian Lall"},{"player_id":"109937","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"false","name":"Sion Hackett"},{"player_id":"115835","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"false","name":"Denzil Antoine"},{"player_id":"139127","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"false","name":"Abdur Rahman Juman"}]},"teamb":{"team_id":123297,"squads":[{"player_id":"96399","substitute":"false","out":"false","in":"false","role_str":"(WK)","role":"wk","playing11":"true","name":"Leonardo Julien"},{"player_id":"117094","substitute":"false","out":"false","in":"false","role_str":"","role":"wk","playing11":"true","name":"Kyle Ramdoo"},{"player_id":"52202","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Saiba Batoosingh"},{"player_id":"53738","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Kjorn Ottley"},{"player_id":"127445","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Olando James"},{"player_id":"114108","substitute":"false","out":"false","in":"false","role_str":"(C)","role":"all","playing11":"true","name":"Jesse Bootan"},{"player_id":"114085","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"Justin Joseph"},{"player_id":"127451","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"Abdul Raheem-Toppin"},{"player_id":"96615","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Avinash Mahabirsingh"},{"player_id":"121766","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Jordan Samkaran"},{"player_id":"114094","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Shaaron Lewis"},{"player_id":"95511","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"false","name":"Akeem Jordan"},{"player_id":"138825","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"false","name":"Aneal Rooplal"},{"player_id":"127444","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"false","name":"Ricardo Chase"},{"player_id":"149739","substitute":"false","out":"false","in":"false","role_str":"","role":"wk","playing11":"false","name":"Justin Rajkumar"}]},"teams":[{"tid":123297,"title":"SAMP Army Cocrico Cavaliers","abbr":"CCL","alt_name":"Cocrico Cavaliers","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/CCL-CR1@2x.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/CCL-CR1@2x.png","country":"wi","sex":"male","team_owner":"","head_coach":""},{"tid":123301,"title":"Soca Kings","abbr":"SCK","alt_name":"Soca Kings","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/SCK-CR1@2x.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/SCK-CR1@2x.png","country":"wi","sex":"male","team_owner":"","head_coach":""}],"players":[{"pid":43338,"title":"Rayad Emrit","short_name":"RR Emrit","first_name":"Rayad Emrit","last_name":"","middle_name":"","birthdate":"1981-03-08","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/rayad51","instagram_profile":"https:\/\/www.instagram.com\/rayad51\/","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":52202,"title":"Saiba Batoosingh","short_name":"S Batoosingh","first_name":"Saiba Batoosingh","last_name":"","middle_name":"","birthdate":"1998-10-10","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":52292,"title":"Dejourn Charles","short_name":"D Charles","first_name":"Dejourn Charles","last_name":"","middle_name":"","birthdate":"1997-10-12","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":53738,"title":"Kjorn Ottley","short_name":"KY Ottley","first_name":"Kjorn Ottley","last_name":"","middle_name":"","birthdate":"1989-12-09","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":90814,"title":"Imran Khan","short_name":"I Khan","first_name":"Imran Khan","last_name":"","middle_name":"","birthdate":"1984-07-06","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":90945,"title":"Tion Webster","short_name":"T Webster","first_name":"Tion Webster","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":95511,"title":"Akeem Jordan","short_name":"A Jordan","first_name":"Akeem Jordan","last_name":"","middle_name":"","birthdate":"1994-10-18","birthplace":"Barbados","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/akeem_jordan\/","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":96399,"title":"Leonardo Julien","short_name":"L Julien","first_name":"Leonardo Julien","last_name":"","middle_name":"","birthdate":"2001-09-09","birthplace":"Trinidad & Tobago","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":96611,"title":"Joshua James","short_name":"J James","first_name":"Joshua James","last_name":"","middle_name":"","birthdate":"2001-02-21","birthplace":"Trinidad & Tobago","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":96615,"title":"Avinash Mahabirsingh","short_name":"A Mahabirsingh","first_name":"Avinash Mahabirsingh","last_name":"","middle_name":"","birthdate":"2001-04-17","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":109937,"title":"Sion Hackett","short_name":"S Hackett","first_name":"Sion Hackett","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":null},{"pid":114085,"title":"Justin Joseph","short_name":"J Joseph","first_name":"Justin Joseph","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":114094,"title":"Shaaron Lewis","short_name":"S Lewis","first_name":"Shaaron Lewis","last_name":"","middle_name":"","birthdate":"1998-03-12","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":114108,"title":"Jesse Bootan","short_name":"J Bootan","first_name":"Jesse Bootan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":114112,"title":"Chadeon Raymond","short_name":"C Raymond","first_name":"Chadeon Raymond","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":114121,"title":"Shatrughan Rambaran","short_name":"S Rambaran","first_name":"Shatrughan Rambaran","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":115835,"title":"Denzil Antoine","short_name":"D Antoine","first_name":"Denzil Antoine","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":116243,"title":"Aamir Ali","short_name":"A Ali","first_name":"Aamir Ali","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":117094,"title":"Kyle Ramdoo","short_name":"K Ramdoo","first_name":"Kyle Ramdoo","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":121766,"title":"Jordan Samkaran","short_name":"J Samkaran","first_name":"Jordan Samkaran","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":127227,"title":"Jon Russ Jagessar","short_name":"Jon Jagessar","first_name":"Jon Russ Jagessar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":127444,"title":"Ricardo Chase","short_name":"R Chase","first_name":"Ricardo Chase","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":127445,"title":"Olando James","short_name":"O James","first_name":"Olando James","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":127451,"title":"Abdul Raheem-Toppin","short_name":"A R-Toppin","first_name":"Abdul Raheem-Toppin","last_name":"","middle_name":"","birthdate":"2005-10-18","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":138825,"title":"Aneal Rooplal","short_name":"A Rooplal","first_name":"Aneal Rooplal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":139127,"title":"Abdur Rahman Juman","short_name":"A R Juman","first_name":"Abdur Rahman Juman","last_name":"","middle_name":"","birthdate":"2003-11-14","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":147236,"title":"Trevon James","short_name":"T James","first_name":"Trevon James","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":147243,"title":"Akeel Mohammed","short_name":"A Mohammed","first_name":"Akeel Mohammed","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":147508,"title":"Christian Lall","short_name":"C Lall","first_name":"Christian Lall","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":149739,"title":"Justin Rajkumar","short_name":"J Rajkumar","first_name":"Justin Rajkumar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"}]},"etag":"cc0157000b2e619350a6d03decb923dc","modified":"2025-07-16 09:05:32","datetime":"2025-07-16 09:05:32","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90630 AND DataTypeId = 8 END Playing XI for Soca Kings vs SAMP Army Cocrico Cavaliers Match 14 2025