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:f725c26b-69ec-4ba1-bf71-2fcf82f3e2db Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90629 AND DataTypeId = 2) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90629,2,'{"status":"ok","response":{"match_id":90629,"title":"SAMP Army Cocrico Cavaliers vs Chicago Steelpan Players","short_title":"CCL vs CSP","subtitle":"Match 13","match_number":"13","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Chicago Steelpan Players won by 7 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129622,"title":"Trinidad T10 Blast, 7th Edition","abbr":"Trinidad T10","type":"tournament","category":"domestic","match_format":"t10","season":"2025","status":"live","datestart":"2025-06-09","dateend":"2025-06-22","country":"wi","total_matches":"30","total_rounds":"1","total_teams":"6"},"teama":{"team_id":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":"121\/5 (10 ov)","scores":"121\/5","overs":"10"},"teamb":{"team_id":128981,"name":"Chicago Steelpan Players","short_name":"CSP","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Chicago-Steelpan-Players.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Chicago-Steelpan-Players.png","scores_full":"123\/3 (9.3 ov)","scores":"123\/3","overs":"9.3"},"date_start":"2025-06-15 16:00:00","date_end":"2025-06-16 02:00:00","timestamp_start":1750003200,"timestamp_end":1750039200,"date_start_ist":"2025-06-15 21:30:00","date_end_ist":"2025-06-16 07:30:00","venue":{"venue_id":"204","name":"Brian Lara Stadium","location":"Tarouba","country":"West Indies","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"CSP won by 7 wickets","result_type":2,"win_margin":"7 wickets","winning_team_id":128981,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-13 22:58:24","verify_time":"2025-06-15 23:57:05","match_dls_affected":"false","live_inning_number":"","day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"scattered clouds","temp":30.9,"humidity":53,"visibility":10000,"wind_speed":"10.40","clouds":30},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Chicago Steelpan Players elected to bowl","winner":128981,"decision":2},"current_over":"","previous_over":"","man_of_the_match":{"pid":127857,"name":"Sidel Diaz","thumb_url":""},"man_of_the_series":"","is_followon":0,"team_batting_first":"","team_batting_second":"","last_five_overs":"","innings":[{"iid":198144,"number":1,"name":"SAMP Army Cocrico Cavaliers Inning","short_name":"CCL Inning","status":2,"issuperover":"false","result":4,"batting_team_id":123297,"fielding_team_id":128981,"scores":"121\/5","scores_full":"121\/5 (10 ov)","batsmen":[{"name":"Kjorn Ottley","batsman_id":"53738","batting":"false","position":"","role":"bat","role_str":"","runs":"22","balls_faced":"14","fours":"1","sixes":"1","run0":"3","run1":"6","run2":"3","run3":"0","run5":"0","how_out":"c N Bidaisee b M Deyal","dismissal":"caught","strike_rate":"157.14","bowler_id":"50138","first_fielder_id":"114147","second_fielder_id":"","third_fielder_id":""},{"name":"Jesse Bootan","batsman_id":"114108","batting":"false","position":"","role":"all","role_str":"(C)","runs":"35","balls_faced":"17","fours":"3","sixes":"3","run0":"7","run1":"3","run2":"1","run3":"0","run5":"0","how_out":"c J Goolie b S Diaz","dismissal":"caught","strike_rate":"205.88","bowler_id":"127857","first_fielder_id":"1206","second_fielder_id":"","third_fielder_id":""},{"name":"Kyle Ramdoo","batsman_id":"117094","batting":"false","position":"","role":"wk","role_str":"","runs":"26","balls_faced":"13","fours":"0","sixes":"3","run0":"4","run1":"4","run2":"2","run3":"0","run5":"0","how_out":"b S Diaz","dismissal":"bowled","strike_rate":"200.00","bowler_id":"127857","first_fielder_id":"","second_fielder_id":"","third_fielder_id":""},{"name":"Saiba Batoosingh","batsman_id":"52202","batting":"false","position":"","role":"bat","role_str":"","runs":"15","balls_faced":"8","fours":"0","sixes":"2","run0":"3","run1":"3","run2":"0","run3":"0","run5":"0","how_out":"c S Cooper b J Duncan","dismissal":"caught","strike_rate":"187.50","bowler_id":"116994","first_fielder_id":"127908","second_fielder_id":"","third_fielder_id":""},{"name":"Leonardo Julien","batsman_id":"96399","batting":"true","position":"non striker","role":"wk","role_str":"(WK)","runs":"6","balls_faced":"5","fours":"1","sixes":"0","run0":"2","run1":"2","run2":"0","run3":"0","run5":"0","how_out":"Not out","dismissal":"","strike_rate":"120.00","bowler_id":"0","first_fielder_id":"","second_fielder_id":"","third_fielder_id":""},{"name":"Olando James","batsman_id":"127445","batting":"false","position":"","role":"bat","role_str":"","runs":"0","balls_faced":"2","fours":"0","sixes":"0","run0":"2","run1":"0","run2":"0","run3":"0","run5":"0","how_out":"c B Ramdial b J Duncan","dismissal":"caught","strike_rate":"0.00","bowler_id":"116994","first_fielder_id":"147506","second_fielder_id":"","third_fielder_id":""},{"name":"Jordan Samkaran","batsman_id":"121766","batting":"true","position":"striker","role":"bowl","role_str":"","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":"James Duncan","bowler_id":"116994","bowling":"true","position":"active bowler","overs":"2","maidens":"0","runs_conceded":"14","wickets":"2","noballs":"0","wides":"3","econ":"7.00","run0":"7","bowledcount":"0","lbwcount":"0"},{"name":"Mark Deyal","bowler_id":"50138","bowling":"false","position":"","overs":"2","maidens":"0","runs_conceded":"35","wickets":"1","noballs":"0","wides":"0","econ":"17.50","run0":"4","bowledcount":"0","lbwcount":"0"},{"name":"Navin Bidaisee","bowler_id":"114147","bowling":"false","position":"","overs":"2","maidens":"0","runs_conceded":"24","wickets":"0","noballs":"0","wides":"2","econ":"12.00","run0":"1","bowledcount":"0","lbwcount":"0"},{"name":"Sidel Diaz","bowler_id":"127857","bowling":"false","position":"last bowler","overs":"2","maidens":"0","runs_conceded":"15","wickets":"2","noballs":"0","wides":"2","econ":"7.50","run0":"6","bowledcount":"1","lbwcount":"0"},{"name":"Jyd Goolie","bowler_id":"1206","bowling":"false","position":"","overs":"1","maidens":"0","runs_conceded":"6","wickets":"0","noballs":"0","wides":"0","econ":"6.00","run0":"1","bowledcount":"0","lbwcount":"0"},{"name":"Ramesh Brijlal","bowler_id":"115823","bowling":"false","position":"","overs":"1","maidens":"0","runs_conceded":"19","wickets":"0","noballs":"0","wides":"0","econ":"19.00","run0":"2","bowledcount":"0","lbwcount":"0"}],"fielder":[{"fielder_id":"114147","fielder_name":"Navin Bidaisee","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"1206","fielder_name":"Jyd Goolie","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"127908","fielder_name":"Silus Cooper","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"147506","fielder_name":"Brandon Ramdial","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":"35","balls":"17","how_out":"c J Goolie b S Diaz","score_at_dismissal":54,"overs_at_dismissal":"3.6","bowler_id":"127857","dismissal":"caught","number":1},{"name":"Kjorn Ottley","batsman_id":"53738","runs":"22","balls":"14","how_out":"c N Bidaisee b M Deyal","score_at_dismissal":73,"overs_at_dismissal":"5.5","bowler_id":"50138","dismissal":"caught","number":2},{"name":"Kyle Ramdoo","batsman_id":"117094","runs":"26","balls":"13","how_out":"b S Diaz","score_at_dismissal":108,"overs_at_dismissal":"8.2","bowler_id":"127857","dismissal":"bowled","number":3},{"name":"Saiba Batoosingh","batsman_id":"52202","runs":"15","balls":"8","how_out":"c S Cooper b J Duncan","score_at_dismissal":120,"overs_at_dismissal":"9.3","bowler_id":"116994","dismissal":"caught","number":4},{"name":"Olando James","batsman_id":"127445","runs":"0","balls":"2","how_out":"c B Ramdial b J Duncan","score_at_dismissal":120,"overs_at_dismissal":"9.5","bowler_id":"116994","dismissal":"caught","number":5}],"last_wicket":{"name":"Olando James","batsman_id":"127445","runs":"0","balls":"2","how_out":"c B Ramdial b J Duncan","score_at_dismissal":120,"overs_at_dismissal":"9.5","bowler_id":"116994","dismissal":"caught","number":5},"extra_runs":{"byes":1,"legbyes":7,"wides":8,"noballs":0,"penalty":"0","total":16},"equations":{"runs":121,"wickets":5,"overs":"10","bowlers_used":6,"runrate":"12.10"},"current_partnership":{"runs":1,"balls":1,"overs":0.1,"batsmen":[{"name":"Jordan Samkaran","batsman_id":121766,"runs":1,"balls":1},{"name":"Leonardo Julien","batsman_id":96399,"runs":0,"balls":0}]},"did_not_bat":[{"player_id":"114085","name":"Justin Joseph"},{"player_id":"127451","name":"Abdul Raheem-Toppin"},{"player_id":"96615","name":"Avinash Mahabirsingh"},{"player_id":"114094","name":"Shaaron Lewis"}],"max_over":"10","target":"0"},{"iid":198156,"number":2,"name":"Chicago Steelpan Players Inning","short_name":"CSP Inning","status":2,"issuperover":"false","result":3,"batting_team_id":128981,"fielding_team_id":123297,"scores":"123\/3","scores_full":"123\/3 (9.3 ov)","batsmen":[{"name":"Sidel Diaz","batsman_id":"127857","batting":"false","position":"","role":"all","role_str":"","runs":"50","balls_faced":"23","fours":"5","sixes":"4","run0":"10","run1":"2","run2":"2","run3":"0","run5":"0","how_out":"c A R-Toppin b O James","dismissal":"caught","strike_rate":"217.39","bowler_id":"127445","first_fielder_id":"127451","second_fielder_id":"","third_fielder_id":""},{"name":"Silus Cooper","batsman_id":"127908","batting":"false","position":"","role":"bat","role_str":"","runs":"53","balls_faced":"30","fours":"3","sixes":"5","run0":"14","run1":"5","run2":"3","run3":"0","run5":"0","how_out":"c S Lewis b K Ramdoo","dismissal":"caught","strike_rate":"176.67","bowler_id":"117094","first_fielder_id":"114094","second_fielder_id":"","third_fielder_id":""},{"name":"Mark Deyal","batsman_id":"50138","batting":"false","position":"","role":"all","role_str":"(C)","runs":"4","balls_faced":"2","fours":"1","sixes":"0","run0":"1","run1":"0","run2":"0","run3":"0","run5":"0","how_out":"c A Mahabirsingh b O James","dismissal":"caught","strike_rate":"200.00","bowler_id":"127445","first_fielder_id":"96615","second_fielder_id":"","third_fielder_id":""},{"name":"Akiel Cooper","batsman_id":"92364","batting":"true","position":"non striker","role":"bat","role_str":"","runs":"6","balls_faced":"1","fours":"0","sixes":"1","run0":"0","run1":"0","run2":"0","run3":"0","run5":"0","how_out":"Not out","dismissal":"","strike_rate":"600.00","bowler_id":"0","first_fielder_id":"","second_fielder_id":"","third_fielder_id":""},{"name":"Jyd Goolie","batsman_id":"1206","batting":"true","position":"striker","role":"bat","role_str":"","runs":"4","balls_faced":"2","fours":"1","sixes":"0","run0":"1","run1":"0","run2":"0","run3":"0","run5":"0","how_out":"Not out","dismissal":"","strike_rate":"200.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":"17","wickets":"0","noballs":"0","wides":"1","econ":"8.50","run0":"6","bowledcount":"0","lbwcount":"0"},{"name":"Justin Joseph","bowler_id":"114085","bowling":"false","position":"","overs":"2","maidens":"0","runs_conceded":"42","wickets":"0","noballs":"0","wides":"0","econ":"21.00","run0":"1","bowledcount":"0","lbwcount":"0"},{"name":"Abdul Raheem-Toppin","bowler_id":"127451","bowling":"false","position":"","overs":"2","maidens":"0","runs_conceded":"15","wickets":"0","noballs":"0","wides":"0","econ":"7.50","run0":"7","bowledcount":"0","lbwcount":"0"},{"name":"Kjorn Ottley","bowler_id":"53738","bowling":"false","position":"","overs":"1","maidens":"0","runs_conceded":"18","wickets":"0","noballs":"0","wides":"2","econ":"18.00","run0":"3","bowledcount":"0","lbwcount":"0"},{"name":"Olando James","bowler_id":"127445","bowling":"false","position":"last bowler","overs":"2","maidens":"0","runs_conceded":"26","wickets":"2","noballs":"1","wides":"1","econ":"13.00","run0":"6","bowledcount":"0","lbwcount":"0"},{"name":"Kyle Ramdoo","bowler_id":"117094","bowling":"true","position":"active bowler","overs":"0.3","maidens":"0","runs_conceded":"4","wickets":"1","noballs":"0","wides":"0","econ":"8.00","run0":"2","bowledcount":"0","lbwcount":"0"}],"fielder":[{"fielder_id":"127451","fielder_name":"Abdul Raheem-Toppin","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"114094","fielder_name":"Shaaron Lewis","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"}],"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":"Sidel Diaz","batsman_id":"127857","runs":"50","balls":"23","how_out":"c A R-Toppin b O James","score_at_dismissal":109,"overs_at_dismissal":"8.3","bowler_id":"127445","dismissal":"caught","number":1},{"name":"Mark Deyal","batsman_id":"50138","runs":"4","balls":"2","how_out":"c A Mahabirsingh b O James","score_at_dismissal":113,"overs_at_dismissal":"8.5","bowler_id":"127445","dismissal":"caught","number":2},{"name":"Silus Cooper","batsman_id":"127908","runs":"53","balls":"30","how_out":"c S Lewis b K Ramdoo","score_at_dismissal":119,"overs_at_dismissal":"9.1","bowler_id":"117094","dismissal":"caught","number":3}],"last_wicket":{"name":"Silus Cooper","batsman_id":"127908","runs":"53","balls":"30","how_out":"c S Lewis b K Ramdoo","score_at_dismissal":119,"overs_at_dismissal":"9.1","bowler_id":"117094","dismissal":"caught","number":3},"extra_runs":{"byes":0,"legbyes":1,"wides":4,"noballs":1,"penalty":"0","total":6},"equations":{"runs":123,"wickets":3,"overs":"9.3","bowlers_used":6,"runrate":"12.95"},"current_partnership":{"runs":4,"balls":2,"overs":0.2,"batsmen":[{"name":"Jyd Goolie","batsman_id":1206,"runs":4,"balls":2},{"name":"Akiel Cooper","batsman_id":92364,"runs":0,"balls":0}]},"did_not_bat":[{"player_id":"147506","name":"Brandon Ramdial"},{"player_id":"114147","name":"Navin Bidaisee"},{"player_id":"52205","name":"Clevon Kalawan"},{"player_id":"116994","name":"James Duncan"},{"player_id":"109938","name":"Anderson Mahase"},{"player_id":"115823","name":"Ramesh Brijlal"}],"max_over":"10","target":"122"}],"players":[{"pid":1206,"title":"Jyd Goolie","short_name":"J Goolie","first_name":"Jyd Goolie","last_name":"","middle_name":"","birthdate":"1997-05-11","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":50138,"title":"Mark Deyal","short_name":"M Deyal","first_name":"Mark Deyal","last_name":"","middle_name":"","birthdate":"1993-04-07","birthplace":" Diego Martin","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/markdeyal\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":"(C)"},{"pid":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":52205,"title":"Clevon Kalawan","short_name":"C Kalawan","first_name":"Clevon Kalawan","last_name":"","middle_name":"","birthdate":"1996-11-12","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":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":91890,"title":"Ryan Hurley","short_name":"RO Hurley","first_name":"Ryan Hurley","last_name":"","middle_name":"","birthdate":"1975-09-13","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":92364,"title":"Akiel Cooper","short_name":"A Cooper","first_name":"Akiel Cooper","last_name":"","middle_name":"","birthdate":"1990-11-26","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":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":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":109938,"title":"Anderson Mahase","short_name":"Anderson Mahase","first_name":"Anderson Mahase","last_name":"","middle_name":"","birthdate":"2003-01-24","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":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":114147,"title":"Navin Bidaisee","short_name":"N Bidaisee","first_name":"Navin Bidaisee","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":115823,"title":"Ramesh Brijlal","short_name":"R Brijlal","first_name":"Ramesh Brijlal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":116994,"title":"James Duncan","short_name":"J Duncan","first_name":"James Duncan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":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":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":127857,"title":"Sidel Diaz","short_name":"S Diaz","first_name":"Sidel Diaz","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":127908,"title":"Silus Cooper","short_name":"S Cooper","first_name":"Silus Cooper","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":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":139141,"title":"Sivan Ramkissoon","short_name":"S Ramkissoon","first_name":"Sivan Ramkissoon","last_name":"","middle_name":"","birthdate":"2000-10-01","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":145181,"title":"Akash Rooplal","short_name":"A Rooplal","first_name":"Akash Rooplal","last_name":"","middle_name":"","birthdate":"1991-02-20","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":147506,"title":"Brandon Ramdial","short_name":"B Ramdial","first_name":"Brandon Ramdial","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(WK)"},{"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":[["SAMP Army Cocrico Cavaliers inning 1","Powerplay 1 (0.1 - 3) Run 41, wicket 0","SAMP Army Cocrico Cavaliers: 50 runs in 3.4 overs.","50 run partnership of 22 balls,Kjorn Ottley 5(6) runs, Jesse Bootan 35(16) runs.","SAMP Army Cocrico Cavaliers: 100 runs in 7.5 overs.","Innings Break: SAMP Army Cocrico Cavaliers - 121\/5 overs 10 (balls 60)."],["Chicago Steelpan Players inning 2","Powerplay 1 (0.1 - 3) Run 45, wicket 0","Chicago Steelpan Players: 50 runs in 3.4 overs.","50 run partnership of 22 balls,Silus Cooper 12(8) runs, Sidel Diaz 36(14) runs.","Sidel Diaz 50 runs in 20 balls (4 x 5, 6 X 4).","Chicago Steelpan Players: 100 runs in 6.5 overs.","100 run partnership of 42 balls,Silus Cooper 48(22) runs, Sidel Diaz 50(20) runs.","Silus Cooper 51 runs in 27 balls (4 x 3, 6 X 5)."]]},"etag":"93c71f7de4660d96eda71bc84f2ae384","modified":"2025-08-07 18:28:31","datetime":"2025-08-07 18:28:31","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90629,"title":"SAMP Army Cocrico Cavaliers vs Chicago Steelpan Players","short_title":"CCL vs CSP","subtitle":"Match 13","match_number":"13","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Chicago Steelpan Players won by 7 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129622,"title":"Trinidad T10 Blast, 7th Edition","abbr":"Trinidad T10","type":"tournament","category":"domestic","match_format":"t10","season":"2025","status":"live","datestart":"2025-06-09","dateend":"2025-06-22","country":"wi","total_matches":"30","total_rounds":"1","total_teams":"6"},"teama":{"team_id":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":"121\/5 (10 ov)","scores":"121\/5","overs":"10"},"teamb":{"team_id":128981,"name":"Chicago Steelpan Players","short_name":"CSP","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Chicago-Steelpan-Players.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Chicago-Steelpan-Players.png","scores_full":"123\/3 (9.3 ov)","scores":"123\/3","overs":"9.3"},"date_start":"2025-06-15 16:00:00","date_end":"2025-06-16 02:00:00","timestamp_start":1750003200,"timestamp_end":1750039200,"date_start_ist":"2025-06-15 21:30:00","date_end_ist":"2025-06-16 07:30:00","venue":{"venue_id":"204","name":"Brian Lara Stadium","location":"Tarouba","country":"West Indies","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"CSP won by 7 wickets","result_type":2,"win_margin":"7 wickets","winning_team_id":128981,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-13 22:58:24","verify_time":"2025-06-15 23:57:05","match_dls_affected":"false","live_inning_number":"","day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"scattered clouds","temp":30.9,"humidity":53,"visibility":10000,"wind_speed":"10.40","clouds":30},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Chicago Steelpan Players elected to bowl","winner":128981,"decision":2},"current_over":"","previous_over":"","man_of_the_match":{"pid":127857,"name":"Sidel Diaz","thumb_url":""},"man_of_the_series":"","is_followon":0,"team_batting_first":"","team_batting_second":"","last_five_overs":"","innings":[{"iid":198144,"number":1,"name":"SAMP Army Cocrico Cavaliers Inning","short_name":"CCL Inning","status":2,"issuperover":"false","result":4,"batting_team_id":123297,"fielding_team_id":128981,"scores":"121\/5","scores_full":"121\/5 (10 ov)","batsmen":[{"name":"Kjorn Ottley","batsman_id":"53738","batting":"false","position":"","role":"bat","role_str":"","runs":"22","balls_faced":"14","fours":"1","sixes":"1","run0":"3","run1":"6","run2":"3","run3":"0","run5":"0","how_out":"c N Bidaisee b M Deyal","dismissal":"caught","strike_rate":"157.14","bowler_id":"50138","first_fielder_id":"114147","second_fielder_id":"","third_fielder_id":""},{"name":"Jesse Bootan","batsman_id":"114108","batting":"false","position":"","role":"all","role_str":"(C)","runs":"35","balls_faced":"17","fours":"3","sixes":"3","run0":"7","run1":"3","run2":"1","run3":"0","run5":"0","how_out":"c J Goolie b S Diaz","dismissal":"caught","strike_rate":"205.88","bowler_id":"127857","first_fielder_id":"1206","second_fielder_id":"","third_fielder_id":""},{"name":"Kyle Ramdoo","batsman_id":"117094","batting":"false","position":"","role":"wk","role_str":"","runs":"26","balls_faced":"13","fours":"0","sixes":"3","run0":"4","run1":"4","run2":"2","run3":"0","run5":"0","how_out":"b S Diaz","dismissal":"bowled","strike_rate":"200.00","bowler_id":"127857","first_fielder_id":"","second_fielder_id":"","third_fielder_id":""},{"name":"Saiba Batoosingh","batsman_id":"52202","batting":"false","position":"","role":"bat","role_str":"","runs":"15","balls_faced":"8","fours":"0","sixes":"2","run0":"3","run1":"3","run2":"0","run3":"0","run5":"0","how_out":"c S Cooper b J Duncan","dismissal":"caught","strike_rate":"187.50","bowler_id":"116994","first_fielder_id":"127908","second_fielder_id":"","third_fielder_id":""},{"name":"Leonardo Julien","batsman_id":"96399","batting":"true","position":"non striker","role":"wk","role_str":"(WK)","runs":"6","balls_faced":"5","fours":"1","sixes":"0","run0":"2","run1":"2","run2":"0","run3":"0","run5":"0","how_out":"Not out","dismissal":"","strike_rate":"120.00","bowler_id":"0","first_fielder_id":"","second_fielder_id":"","third_fielder_id":""},{"name":"Olando James","batsman_id":"127445","batting":"false","position":"","role":"bat","role_str":"","runs":"0","balls_faced":"2","fours":"0","sixes":"0","run0":"2","run1":"0","run2":"0","run3":"0","run5":"0","how_out":"c B Ramdial b J Duncan","dismissal":"caught","strike_rate":"0.00","bowler_id":"116994","first_fielder_id":"147506","second_fielder_id":"","third_fielder_id":""},{"name":"Jordan Samkaran","batsman_id":"121766","batting":"true","position":"striker","role":"bowl","role_str":"","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":"James Duncan","bowler_id":"116994","bowling":"true","position":"active bowler","overs":"2","maidens":"0","runs_conceded":"14","wickets":"2","noballs":"0","wides":"3","econ":"7.00","run0":"7","bowledcount":"0","lbwcount":"0"},{"name":"Mark Deyal","bowler_id":"50138","bowling":"false","position":"","overs":"2","maidens":"0","runs_conceded":"35","wickets":"1","noballs":"0","wides":"0","econ":"17.50","run0":"4","bowledcount":"0","lbwcount":"0"},{"name":"Navin Bidaisee","bowler_id":"114147","bowling":"false","position":"","overs":"2","maidens":"0","runs_conceded":"24","wickets":"0","noballs":"0","wides":"2","econ":"12.00","run0":"1","bowledcount":"0","lbwcount":"0"},{"name":"Sidel Diaz","bowler_id":"127857","bowling":"false","position":"last bowler","overs":"2","maidens":"0","runs_conceded":"15","wickets":"2","noballs":"0","wides":"2","econ":"7.50","run0":"6","bowledcount":"1","lbwcount":"0"},{"name":"Jyd Goolie","bowler_id":"1206","bowling":"false","position":"","overs":"1","maidens":"0","runs_conceded":"6","wickets":"0","noballs":"0","wides":"0","econ":"6.00","run0":"1","bowledcount":"0","lbwcount":"0"},{"name":"Ramesh Brijlal","bowler_id":"115823","bowling":"false","position":"","overs":"1","maidens":"0","runs_conceded":"19","wickets":"0","noballs":"0","wides":"0","econ":"19.00","run0":"2","bowledcount":"0","lbwcount":"0"}],"fielder":[{"fielder_id":"114147","fielder_name":"Navin Bidaisee","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"1206","fielder_name":"Jyd Goolie","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"127908","fielder_name":"Silus Cooper","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"147506","fielder_name":"Brandon Ramdial","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":"35","balls":"17","how_out":"c J Goolie b S Diaz","score_at_dismissal":54,"overs_at_dismissal":"3.6","bowler_id":"127857","dismissal":"caught","number":1},{"name":"Kjorn Ottley","batsman_id":"53738","runs":"22","balls":"14","how_out":"c N Bidaisee b M Deyal","score_at_dismissal":73,"overs_at_dismissal":"5.5","bowler_id":"50138","dismissal":"caught","number":2},{"name":"Kyle Ramdoo","batsman_id":"117094","runs":"26","balls":"13","how_out":"b S Diaz","score_at_dismissal":108,"overs_at_dismissal":"8.2","bowler_id":"127857","dismissal":"bowled","number":3},{"name":"Saiba Batoosingh","batsman_id":"52202","runs":"15","balls":"8","how_out":"c S Cooper b J Duncan","score_at_dismissal":120,"overs_at_dismissal":"9.3","bowler_id":"116994","dismissal":"caught","number":4},{"name":"Olando James","batsman_id":"127445","runs":"0","balls":"2","how_out":"c B Ramdial b J Duncan","score_at_dismissal":120,"overs_at_dismissal":"9.5","bowler_id":"116994","dismissal":"caught","number":5}],"last_wicket":{"name":"Olando James","batsman_id":"127445","runs":"0","balls":"2","how_out":"c B Ramdial b J Duncan","score_at_dismissal":120,"overs_at_dismissal":"9.5","bowler_id":"116994","dismissal":"caught","number":5},"extra_runs":{"byes":1,"legbyes":7,"wides":8,"noballs":0,"penalty":"0","total":16},"equations":{"runs":121,"wickets":5,"overs":"10","bowlers_used":6,"runrate":"12.10"},"current_partnership":{"runs":1,"balls":1,"overs":0.1,"batsmen":[{"name":"Jordan Samkaran","batsman_id":121766,"runs":1,"balls":1},{"name":"Leonardo Julien","batsman_id":96399,"runs":0,"balls":0}]},"did_not_bat":[{"player_id":"114085","name":"Justin Joseph"},{"player_id":"127451","name":"Abdul Raheem-Toppin"},{"player_id":"96615","name":"Avinash Mahabirsingh"},{"player_id":"114094","name":"Shaaron Lewis"}],"max_over":"10","target":"0"},{"iid":198156,"number":2,"name":"Chicago Steelpan Players Inning","short_name":"CSP Inning","status":2,"issuperover":"false","result":3,"batting_team_id":128981,"fielding_team_id":123297,"scores":"123\/3","scores_full":"123\/3 (9.3 ov)","batsmen":[{"name":"Sidel Diaz","batsman_id":"127857","batting":"false","position":"","role":"all","role_str":"","runs":"50","balls_faced":"23","fours":"5","sixes":"4","run0":"10","run1":"2","run2":"2","run3":"0","run5":"0","how_out":"c A R-Toppin b O James","dismissal":"caught","strike_rate":"217.39","bowler_id":"127445","first_fielder_id":"127451","second_fielder_id":"","third_fielder_id":""},{"name":"Silus Cooper","batsman_id":"127908","batting":"false","position":"","role":"bat","role_str":"","runs":"53","balls_faced":"30","fours":"3","sixes":"5","run0":"14","run1":"5","run2":"3","run3":"0","run5":"0","how_out":"c S Lewis b K Ramdoo","dismissal":"caught","strike_rate":"176.67","bowler_id":"117094","first_fielder_id":"114094","second_fielder_id":"","third_fielder_id":""},{"name":"Mark Deyal","batsman_id":"50138","batting":"false","position":"","role":"all","role_str":"(C)","runs":"4","balls_faced":"2","fours":"1","sixes":"0","run0":"1","run1":"0","run2":"0","run3":"0","run5":"0","how_out":"c A Mahabirsingh b O James","dismissal":"caught","strike_rate":"200.00","bowler_id":"127445","first_fielder_id":"96615","second_fielder_id":"","third_fielder_id":""},{"name":"Akiel Cooper","batsman_id":"92364","batting":"true","position":"non striker","role":"bat","role_str":"","runs":"6","balls_faced":"1","fours":"0","sixes":"1","run0":"0","run1":"0","run2":"0","run3":"0","run5":"0","how_out":"Not out","dismissal":"","strike_rate":"600.00","bowler_id":"0","first_fielder_id":"","second_fielder_id":"","third_fielder_id":""},{"name":"Jyd Goolie","batsman_id":"1206","batting":"true","position":"striker","role":"bat","role_str":"","runs":"4","balls_faced":"2","fours":"1","sixes":"0","run0":"1","run1":"0","run2":"0","run3":"0","run5":"0","how_out":"Not out","dismissal":"","strike_rate":"200.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":"17","wickets":"0","noballs":"0","wides":"1","econ":"8.50","run0":"6","bowledcount":"0","lbwcount":"0"},{"name":"Justin Joseph","bowler_id":"114085","bowling":"false","position":"","overs":"2","maidens":"0","runs_conceded":"42","wickets":"0","noballs":"0","wides":"0","econ":"21.00","run0":"1","bowledcount":"0","lbwcount":"0"},{"name":"Abdul Raheem-Toppin","bowler_id":"127451","bowling":"false","position":"","overs":"2","maidens":"0","runs_conceded":"15","wickets":"0","noballs":"0","wides":"0","econ":"7.50","run0":"7","bowledcount":"0","lbwcount":"0"},{"name":"Kjorn Ottley","bowler_id":"53738","bowling":"false","position":"","overs":"1","maidens":"0","runs_conceded":"18","wickets":"0","noballs":"0","wides":"2","econ":"18.00","run0":"3","bowledcount":"0","lbwcount":"0"},{"name":"Olando James","bowler_id":"127445","bowling":"false","position":"last bowler","overs":"2","maidens":"0","runs_conceded":"26","wickets":"2","noballs":"1","wides":"1","econ":"13.00","run0":"6","bowledcount":"0","lbwcount":"0"},{"name":"Kyle Ramdoo","bowler_id":"117094","bowling":"true","position":"active bowler","overs":"0.3","maidens":"0","runs_conceded":"4","wickets":"1","noballs":"0","wides":"0","econ":"8.00","run0":"2","bowledcount":"0","lbwcount":"0"}],"fielder":[{"fielder_id":"127451","fielder_name":"Abdul Raheem-Toppin","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"114094","fielder_name":"Shaaron Lewis","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"}],"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":"Sidel Diaz","batsman_id":"127857","runs":"50","balls":"23","how_out":"c A R-Toppin b O James","score_at_dismissal":109,"overs_at_dismissal":"8.3","bowler_id":"127445","dismissal":"caught","number":1},{"name":"Mark Deyal","batsman_id":"50138","runs":"4","balls":"2","how_out":"c A Mahabirsingh b O James","score_at_dismissal":113,"overs_at_dismissal":"8.5","bowler_id":"127445","dismissal":"caught","number":2},{"name":"Silus Cooper","batsman_id":"127908","runs":"53","balls":"30","how_out":"c S Lewis b K Ramdoo","score_at_dismissal":119,"overs_at_dismissal":"9.1","bowler_id":"117094","dismissal":"caught","number":3}],"last_wicket":{"name":"Silus Cooper","batsman_id":"127908","runs":"53","balls":"30","how_out":"c S Lewis b K Ramdoo","score_at_dismissal":119,"overs_at_dismissal":"9.1","bowler_id":"117094","dismissal":"caught","number":3},"extra_runs":{"byes":0,"legbyes":1,"wides":4,"noballs":1,"penalty":"0","total":6},"equations":{"runs":123,"wickets":3,"overs":"9.3","bowlers_used":6,"runrate":"12.95"},"current_partnership":{"runs":4,"balls":2,"overs":0.2,"batsmen":[{"name":"Jyd Goolie","batsman_id":1206,"runs":4,"balls":2},{"name":"Akiel Cooper","batsman_id":92364,"runs":0,"balls":0}]},"did_not_bat":[{"player_id":"147506","name":"Brandon Ramdial"},{"player_id":"114147","name":"Navin Bidaisee"},{"player_id":"52205","name":"Clevon Kalawan"},{"player_id":"116994","name":"James Duncan"},{"player_id":"109938","name":"Anderson Mahase"},{"player_id":"115823","name":"Ramesh Brijlal"}],"max_over":"10","target":"122"}],"players":[{"pid":1206,"title":"Jyd Goolie","short_name":"J Goolie","first_name":"Jyd Goolie","last_name":"","middle_name":"","birthdate":"1997-05-11","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":50138,"title":"Mark Deyal","short_name":"M Deyal","first_name":"Mark Deyal","last_name":"","middle_name":"","birthdate":"1993-04-07","birthplace":" Diego Martin","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/markdeyal\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":"(C)"},{"pid":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":52205,"title":"Clevon Kalawan","short_name":"C Kalawan","first_name":"Clevon Kalawan","last_name":"","middle_name":"","birthdate":"1996-11-12","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":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":91890,"title":"Ryan Hurley","short_name":"RO Hurley","first_name":"Ryan Hurley","last_name":"","middle_name":"","birthdate":"1975-09-13","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":92364,"title":"Akiel Cooper","short_name":"A Cooper","first_name":"Akiel Cooper","last_name":"","middle_name":"","birthdate":"1990-11-26","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":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":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":109938,"title":"Anderson Mahase","short_name":"Anderson Mahase","first_name":"Anderson Mahase","last_name":"","middle_name":"","birthdate":"2003-01-24","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":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":114147,"title":"Navin Bidaisee","short_name":"N Bidaisee","first_name":"Navin Bidaisee","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":115823,"title":"Ramesh Brijlal","short_name":"R Brijlal","first_name":"Ramesh Brijlal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":116994,"title":"James Duncan","short_name":"J Duncan","first_name":"James Duncan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":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":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":127857,"title":"Sidel Diaz","short_name":"S Diaz","first_name":"Sidel Diaz","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":127908,"title":"Silus Cooper","short_name":"S Cooper","first_name":"Silus Cooper","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":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":139141,"title":"Sivan Ramkissoon","short_name":"S Ramkissoon","first_name":"Sivan Ramkissoon","last_name":"","middle_name":"","birthdate":"2000-10-01","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":145181,"title":"Akash Rooplal","short_name":"A Rooplal","first_name":"Akash Rooplal","last_name":"","middle_name":"","birthdate":"1991-02-20","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":147506,"title":"Brandon Ramdial","short_name":"B Ramdial","first_name":"Brandon Ramdial","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(WK)"},{"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":[["SAMP Army Cocrico Cavaliers inning 1","Powerplay 1 (0.1 - 3) Run 41, wicket 0","SAMP Army Cocrico Cavaliers: 50 runs in 3.4 overs.","50 run partnership of 22 balls,Kjorn Ottley 5(6) runs, Jesse Bootan 35(16) runs.","SAMP Army Cocrico Cavaliers: 100 runs in 7.5 overs.","Innings Break: SAMP Army Cocrico Cavaliers - 121\/5 overs 10 (balls 60)."],["Chicago Steelpan Players inning 2","Powerplay 1 (0.1 - 3) Run 45, wicket 0","Chicago Steelpan Players: 50 runs in 3.4 overs.","50 run partnership of 22 balls,Silus Cooper 12(8) runs, Sidel Diaz 36(14) runs.","Sidel Diaz 50 runs in 20 balls (4 x 5, 6 X 4).","Chicago Steelpan Players: 100 runs in 6.5 overs.","100 run partnership of 42 balls,Silus Cooper 48(22) runs, Sidel Diaz 50(20) runs.","Silus Cooper 51 runs in 27 balls (4 x 3, 6 X 5)."]]},"etag":"93c71f7de4660d96eda71bc84f2ae384","modified":"2025-08-07 18:28:31","datetime":"2025-08-07 18:28:31","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90629 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:f725c26b-69ec-4ba1-bf71-2fcf82f3e2db Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90629 AND DataTypeId = 8) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90629,8,'{"status":"ok","response":{"teama":{"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"}]},"teamb":{"team_id":128981,"squads":[{"player_id":"147506","substitute":"false","out":"false","in":"false","role_str":"(WK)","role":"wk","playing11":"true","name":"Brandon Ramdial"},{"player_id":"1206","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Jyd Goolie"},{"player_id":"92364","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Akiel Cooper"},{"player_id":"127908","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Silus Cooper"},{"player_id":"127857","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"Sidel Diaz"},{"player_id":"50138","substitute":"false","out":"false","in":"false","role_str":"(C)","role":"all","playing11":"true","name":"Mark Deyal"},{"player_id":"114147","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"Navin Bidaisee"},{"player_id":"52205","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"Clevon Kalawan"},{"player_id":"116994","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"James Duncan"},{"player_id":"109938","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Anderson Mahase"},{"player_id":"115823","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Ramesh Brijlal"},{"player_id":"139141","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"false","name":"Sivan Ramkissoon"},{"player_id":"145181","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"false","name":"Akash Rooplal"},{"player_id":"91890","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"false","name":"Ryan Hurley"}]},"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":128981,"title":"Chicago Steelpan Players","abbr":"CSP","alt_name":"Chicago Steelpan Players","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Chicago-Steelpan-Players.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Chicago-Steelpan-Players.png","country":"wi","sex":"male","team_owner":"","head_coach":""}],"players":[{"pid":1206,"title":"Jyd Goolie","short_name":"J Goolie","first_name":"Jyd Goolie","last_name":"","middle_name":"","birthdate":"1997-05-11","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":50138,"title":"Mark Deyal","short_name":"M Deyal","first_name":"Mark Deyal","last_name":"","middle_name":"","birthdate":"1993-04-07","birthplace":" Diego Martin","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/markdeyal\/","debut_data":"","thumb_url":"","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":52205,"title":"Clevon Kalawan","short_name":"C Kalawan","first_name":"Clevon Kalawan","last_name":"","middle_name":"","birthdate":"1996-11-12","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","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":91890,"title":"Ryan Hurley","short_name":"RO Hurley","first_name":"Ryan Hurley","last_name":"","middle_name":"","birthdate":"1975-09-13","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":92364,"title":"Akiel Cooper","short_name":"A Cooper","first_name":"Akiel Cooper","last_name":"","middle_name":"","birthdate":"1990-11-26","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","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":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":109938,"title":"Anderson Mahase","short_name":"Anderson Mahase","first_name":"Anderson Mahase","last_name":"","middle_name":"","birthdate":"2003-01-24","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"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":114147,"title":"Navin Bidaisee","short_name":"N Bidaisee","first_name":"Navin Bidaisee","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":115823,"title":"Ramesh Brijlal","short_name":"R Brijlal","first_name":"Ramesh Brijlal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":116994,"title":"James Duncan","short_name":"J Duncan","first_name":"James Duncan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","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":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":127857,"title":"Sidel Diaz","short_name":"S Diaz","first_name":"Sidel Diaz","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":127908,"title":"Silus Cooper","short_name":"S Cooper","first_name":"Silus Cooper","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","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":139141,"title":"Sivan Ramkissoon","short_name":"S Ramkissoon","first_name":"Sivan Ramkissoon","last_name":"","middle_name":"","birthdate":"2000-10-01","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":145181,"title":"Akash Rooplal","short_name":"A Rooplal","first_name":"Akash Rooplal","last_name":"","middle_name":"","birthdate":"1991-02-20","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":147506,"title":"Brandon Ramdial","short_name":"B Ramdial","first_name":"Brandon Ramdial","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","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":"63158de9246e6c900b163b41336b0c94","modified":"2025-08-07 18:28:32","datetime":"2025-08-07 18:28:32","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"teama":{"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"}]},"teamb":{"team_id":128981,"squads":[{"player_id":"147506","substitute":"false","out":"false","in":"false","role_str":"(WK)","role":"wk","playing11":"true","name":"Brandon Ramdial"},{"player_id":"1206","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Jyd Goolie"},{"player_id":"92364","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Akiel Cooper"},{"player_id":"127908","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Silus Cooper"},{"player_id":"127857","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"Sidel Diaz"},{"player_id":"50138","substitute":"false","out":"false","in":"false","role_str":"(C)","role":"all","playing11":"true","name":"Mark Deyal"},{"player_id":"114147","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"Navin Bidaisee"},{"player_id":"52205","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"Clevon Kalawan"},{"player_id":"116994","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"James Duncan"},{"player_id":"109938","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Anderson Mahase"},{"player_id":"115823","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Ramesh Brijlal"},{"player_id":"139141","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"false","name":"Sivan Ramkissoon"},{"player_id":"145181","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"false","name":"Akash Rooplal"},{"player_id":"91890","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"false","name":"Ryan Hurley"}]},"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":128981,"title":"Chicago Steelpan Players","abbr":"CSP","alt_name":"Chicago Steelpan Players","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Chicago-Steelpan-Players.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Chicago-Steelpan-Players.png","country":"wi","sex":"male","team_owner":"","head_coach":""}],"players":[{"pid":1206,"title":"Jyd Goolie","short_name":"J Goolie","first_name":"Jyd Goolie","last_name":"","middle_name":"","birthdate":"1997-05-11","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":50138,"title":"Mark Deyal","short_name":"M Deyal","first_name":"Mark Deyal","last_name":"","middle_name":"","birthdate":"1993-04-07","birthplace":" Diego Martin","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/markdeyal\/","debut_data":"","thumb_url":"","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":52205,"title":"Clevon Kalawan","short_name":"C Kalawan","first_name":"Clevon Kalawan","last_name":"","middle_name":"","birthdate":"1996-11-12","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","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":91890,"title":"Ryan Hurley","short_name":"RO Hurley","first_name":"Ryan Hurley","last_name":"","middle_name":"","birthdate":"1975-09-13","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":92364,"title":"Akiel Cooper","short_name":"A Cooper","first_name":"Akiel Cooper","last_name":"","middle_name":"","birthdate":"1990-11-26","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","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":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":109938,"title":"Anderson Mahase","short_name":"Anderson Mahase","first_name":"Anderson Mahase","last_name":"","middle_name":"","birthdate":"2003-01-24","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"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":114147,"title":"Navin Bidaisee","short_name":"N Bidaisee","first_name":"Navin Bidaisee","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":115823,"title":"Ramesh Brijlal","short_name":"R Brijlal","first_name":"Ramesh Brijlal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":116994,"title":"James Duncan","short_name":"J Duncan","first_name":"James Duncan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","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":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":127857,"title":"Sidel Diaz","short_name":"S Diaz","first_name":"Sidel Diaz","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":127908,"title":"Silus Cooper","short_name":"S Cooper","first_name":"Silus Cooper","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","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":139141,"title":"Sivan Ramkissoon","short_name":"S Ramkissoon","first_name":"Sivan Ramkissoon","last_name":"","middle_name":"","birthdate":"2000-10-01","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":145181,"title":"Akash Rooplal","short_name":"A Rooplal","first_name":"Akash Rooplal","last_name":"","middle_name":"","birthdate":"1991-02-20","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},{"pid":147506,"title":"Brandon Ramdial","short_name":"B Ramdial","first_name":"Brandon Ramdial","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","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":"63158de9246e6c900b163b41336b0c94","modified":"2025-08-07 18:28:32","datetime":"2025-08-07 18:28:32","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90629 AND DataTypeId = 8 END
Playing XI for SAMP Army Cocrico Cavaliers vs Chicago Steelpan Players Match 13 2025