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:479885c8-969b-4de4-bb15-a46a00609835 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90750 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90750,1,'{"status":"ok","response":{"mid":90750,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Canada won by 59 runs","day_remaining_over":"","team_batting":"Cayman Islands","team_bowling":"Canada","live_inning_number":2,"live_score":{"runs":103,"overs":20,"wickets":9,"target":163,"runrate":5.15,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Troy Taylor","batsman_id":52481,"runs":0,"balls_faced":2,"fours":0,"sixes":0,"strike_rate":"0.00"},{"name":"Alessandro Morris","batsman_id":52482,"runs":8,"balls_faced":19,"fours":2,"sixes":0,"strike_rate":"42.11"}],"bowlers":[{"name":"Dillon Heyliger","bowler_id":93722,"overs":2,"runs_conceded":19,"wickets":0,"maidens":0,"econ":"9.50"},{"name":"Kaleem Sana","bowler_id":96421,"overs":4,"runs_conceded":14,"wickets":1,"maidens":2,"econ":"3.50"}],"commentaries":[{"event":"overend","over":16,"runs":1,"score":"90\/7","bats":[{"runs":10,"balls_faced":19,"fours":0,"sixes":0,"batsman_id":145432},{"runs":0,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":52482}],"bowls":[{"runs_conceded":12,"maidens":1,"wickets":2,"bowler_id":1126,"overs":3},{"runs_conceded":17,"maidens":0,"wickets":1,"bowler_id":96319,"overs":4}],"commentary":"End of over 16 (1 runs), Cayman Islands 90\/7"},{"event_id":"12157481","event":"ball","batsman_id":"52482","bowler_id":"96421","over":"16","ball":"1","score":0,"commentary":"Kaleem Sana to Alessandro Morris, no run,","noball_dismissal":false,"text":"","timestamp":1750095260,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12157490","event":"ball","batsman_id":"52482","bowler_id":"96421","over":"16","ball":"2","score":0,"commentary":"Kaleem Sana to Alessandro Morris, no run,","noball_dismissal":false,"text":"","timestamp":1750095311,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12157498","event":"ball","batsman_id":"52482","bowler_id":"96421","over":"16","ball":"3","score":0,"commentary":"Kaleem Sana to Alessandro Morris, no run,","noball_dismissal":false,"text":"","timestamp":1750095368,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12157499","event":"ball","batsman_id":"52482","bowler_id":"96421","over":"16","ball":"4","score":0,"commentary":"Kaleem Sana to Alessandro Morris, no run,","noball_dismissal":false,"text":"","timestamp":1750095431,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12157503","event":"ball","batsman_id":"52482","bowler_id":"96421","over":"16","ball":"5","score":0,"commentary":"Kaleem Sana to Alessandro Morris, no run,","noball_dismissal":false,"text":"","timestamp":1750095436,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12157504","event":"ball","batsman_id":"52482","bowler_id":"96421","over":"16","ball":"6","score":0,"commentary":"Kaleem Sana to Alessandro Morris, no run,","noball_dismissal":false,"text":"","timestamp":1750095439,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":17,"runs":0,"score":"90\/7","bats":[{"runs":0,"balls_faced":9,"fours":0,"sixes":0,"batsman_id":52482},{"runs":10,"balls_faced":19,"fours":0,"sixes":0,"batsman_id":145432}],"bowls":[{"runs_conceded":14,"maidens":1,"wickets":0,"bowler_id":96421,"overs":3},{"runs_conceded":12,"maidens":1,"wickets":2,"bowler_id":1126,"overs":3}],"commentary":"End of over 17 (0 runs), Cayman Islands 90\/7"},{"event_id":"12157518","event":"ball","batsman_id":"145432","bowler_id":"1126","over":"17","ball":"1","score":2,"commentary":"Harsh Thaker to Samuel Foster, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750095571,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12157519","event":"ball","batsman_id":"145432","bowler_id":"1126","over":"17","ball":"2","score":1,"commentary":"Harsh Thaker to Samuel Foster, 1 run,","noball_dismissal":false,"text":"","timestamp":1750095575,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12157521","event":"ball","batsman_id":"52482","bowler_id":"1126","over":"17","ball":"3","score":0,"commentary":"Harsh Thaker to Alessandro Morris, no run,","noball_dismissal":false,"text":"","timestamp":1750095580,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12157523","event":"ball","batsman_id":"52482","bowler_id":"1126","over":"17","ball":"4","score":4,"commentary":"Harsh Thaker to Alessandro Morris, Four,","noball_dismissal":false,"text":"","timestamp":1750095597,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12157524","event":"ball","batsman_id":"52482","bowler_id":"1126","over":"17","ball":"5","score":0,"commentary":"Harsh Thaker to Alessandro Morris, no run,","noball_dismissal":false,"text":"","timestamp":1750095636,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12157530","event":"ball","batsman_id":"52482","bowler_id":"1126","over":"17","ball":"6","score":0,"commentary":"Harsh Thaker to Alessandro Morris, no run,","noball_dismissal":false,"text":"","timestamp":1750095640,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":18,"runs":7,"score":"97\/7","bats":[{"runs":4,"balls_faced":13,"fours":1,"sixes":0,"batsman_id":52482},{"runs":13,"balls_faced":21,"fours":0,"sixes":0,"batsman_id":145432}],"bowls":[{"runs_conceded":19,"maidens":1,"wickets":2,"bowler_id":1126,"overs":4},{"runs_conceded":14,"maidens":1,"wickets":0,"bowler_id":96421,"overs":3}],"commentary":"End of over 18 (7 runs), Cayman Islands 97\/7"},{"event_id":"12157535","event":"wicket","batsman_id":"145432","bowler_id":"96421","over":"18","ball":"1","score":"w","commentary":"Kaleem Sana to Samuel Foster, no run, c K Tathgur b K Sana,","noball_dismissal":false,"text":"","timestamp":1750095694,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"145432","how_out":"c K Tathgur b K Sana","batsman_runs":"13","batsman_balls":"22"},{"event_id":"12157549","event":"ball","batsman_id":"52480","bowler_id":"96421","over":"18","ball":"2","score":0,"commentary":"Kaleem Sana to Adrian Wright, no run,","noball_dismissal":false,"text":"","timestamp":1750096004,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12157550","event":"ball","batsman_id":"52480","bowler_id":"96421","over":"18","ball":"3","score":0,"commentary":"Kaleem Sana to Adrian Wright, no run,","noball_dismissal":false,"text":"","timestamp":1750096011,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12157565","event":"wicket","batsman_id":"52480","bowler_id":"96421","over":"18","ball":"4","score":"w","commentary":"Kaleem Sana to Adrian Wright, no run, runout (K Tathgur \/ Jaskaran Singh),","noball_dismissal":false,"text":"","timestamp":1750096018,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"52480","how_out":"runout (K Tathgur \/ Jaskaran Singh)","batsman_runs":"0","batsman_balls":"3"},{"event_id":"12157569","event":"ball","batsman_id":"52481","bowler_id":"96421","over":"18","ball":"5","score":0,"commentary":"Kaleem Sana to Troy Taylor, no run,","noball_dismissal":false,"text":"","timestamp":1750096051,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12157570","event":"ball","batsman_id":"52481","bowler_id":"96421","over":"18","ball":"6","score":0,"commentary":"Kaleem Sana to Troy Taylor, no run,","noball_dismissal":false,"text":"","timestamp":1750096055,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":19,"runs":0,"score":"97\/9","bats":[{"runs":0,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":52481},{"runs":4,"balls_faced":13,"fours":1,"sixes":0,"batsman_id":52482}],"bowls":[{"runs_conceded":14,"maidens":2,"wickets":1,"bowler_id":96421,"overs":4},{"runs_conceded":19,"maidens":1,"wickets":2,"bowler_id":1126,"overs":4}],"commentary":"End of over 19 (0 runs), Cayman Islands 97\/9"},{"event_id":"12157576","event":"ball","batsman_id":"52482","bowler_id":"93722","over":"19","ball":"1","score":"1wd","commentary":"Dillon Heyliger to Alessandro Morris, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750096209,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12157588","event":"ball","batsman_id":"52482","bowler_id":"93722","over":"19","ball":"1","score":0,"commentary":"Dillon Heyliger to Alessandro Morris, no run,","noball_dismissal":false,"text":"","timestamp":1750096214,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12157590","event":"ball","batsman_id":"52482","bowler_id":"93722","over":"19","ball":"2","score":0,"commentary":"Dillon Heyliger to Alessandro Morris, no run,","noball_dismissal":false,"text":"","timestamp":1750096217,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12157591","event":"ball","batsman_id":"52482","bowler_id":"93722","over":"19","ball":"3","score":4,"commentary":"Dillon Heyliger to Alessandro Morris, Four,","noball_dismissal":false,"text":"","timestamp":1750096220,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12157592","event":"ball","batsman_id":"52482","bowler_id":"93722","over":"19","ball":"4","score":"1wd","commentary":"Dillon Heyliger to Alessandro Morris, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750096224,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12157594","event":"ball","batsman_id":"52482","bowler_id":"93722","over":"19","ball":"4","score":0,"commentary":"Dillon Heyliger to Alessandro Morris, no run,","noball_dismissal":false,"text":"","timestamp":1750096233,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12157604","event":"ball","batsman_id":"52482","bowler_id":"93722","over":"19","ball":"5","score":0,"commentary":"Dillon Heyliger to Alessandro Morris, no run,","noball_dismissal":false,"text":"","timestamp":1750096360,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12157605","event":"ball","batsman_id":"52482","bowler_id":"93722","over":"19","ball":"6","score":0,"commentary":"Dillon Heyliger to Alessandro Morris, no run,","noball_dismissal":false,"text":"","timestamp":1750096466,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":20,"runs":6,"score":"103\/9","bats":[{"runs":8,"balls_faced":19,"fours":2,"sixes":0,"batsman_id":52482},{"runs":0,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":52481}],"bowls":[{"runs_conceded":19,"maidens":0,"wickets":0,"bowler_id":93722,"overs":2},{"runs_conceded":14,"maidens":2,"wickets":1,"bowler_id":96421,"overs":4}],"commentary":"End of over 20 (6 runs), Cayman Islands 103\/9"}],"day":"0","session":"0","live_inning":{"iid":198207,"number":2,"name":"Cayman Islands Inning","short_name":"CAY Inning","status":2,"issuperover":"false","result":4,"batting_team_id":19688,"fielding_team_id":6791,"scores":"103\/9","scores_full":"103\/9 (20 ov)","fielder":[{"fielder_id":"93722","fielder_name":"Dillon Heyliger","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"96421","fielder_name":"Kaleem Sana","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"96416","fielder_name":"Kanwarpal Tathgur","catches":3,"runout_thrower":0,"runout_catcher":1,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"90992","fielder_name":"Jaskaran Singh","catches":0,"runout_thrower":1,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Adrian Wright","batsman_id":"52480","runs":"0","balls":"3","how_out":"runout (K Tathgur \/ Jaskaran Singh)","score_at_dismissal":97,"overs_at_dismissal":"18.4","bowler_id":"0","dismissal":"runout","number":9},"extra_runs":{"byes":1,"legbyes":6,"wides":7,"noballs":0,"penalty":"0","total":14},"equations":{"runs":103,"wickets":9,"overs":"20","bowlers_used":6,"runrate":"5.15"},"current_partnership":{"runs":6,"balls":8,"overs":1.2,"batsmen":[{"name":"Troy Taylor","batsman_id":52481,"runs":0,"balls":2},{"name":"Alessandro Morris","batsman_id":52482,"runs":4,"balls":6}]},"did_not_bat":[],"max_over":"20","target":"163","recent_scores":"0,0,0,1,4,0,0,1,0,0,w,0,0,w,0,0,4,0","last_five_overs":"14\/3 2.63","last_ten_overs":"29\/6 2.76"},"teams":[{"tid":6791,"title":"Canada","abbr":"CAN","alt_name":"Canada","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/CANADA.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/CANADA.png","country":"ca","sex":"male","team_owner":"","head_coach":"Pubudu Dassanayake","scores_full":"162\/5 (20 ov)","scores":"162\/5","overs":"20"},{"tid":19688,"title":"Cayman Islands","abbr":"CAY","alt_name":"Cayman Islands","type":"country","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Cayman-Islands.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Cayman-Islands.png","country":"ky","sex":"male","team_owner":"","head_coach":"","scores_full":"103\/9 (20 ov)","scores":"103\/9","overs":"20"}],"players":[{"pid":1126,"title":"Harsh Thaker","short_name":"H Thaker","first_name":"Harsh Thaker","last_name":"","middle_name":"","birthdate":"1997-10-24","birthplace":"","country":"ca","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Canada","role":"all","role_str":""},{"pid":49185,"title":"Navneet Dhaliwal","short_name":"NS Dhaliwal","first_name":"Navneet Dhaliwal","last_name":"","middle_name":"","birthdate":"1988-10-10","birthplace":"","country":"ca","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Canada","role":"squad","role_str":""},{"pid":52190,"title":"Nicholas Kirton","short_name":"Nicholas Kirton","first_name":"Nicholas Kirton","last_name":"","middle_name":"","birthdate":"1998-05-06","birthplace":"","country":"ca","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","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":"Canada","role":"bat","role_str":"(C)"},{"pid":52468,"title":"Ramon Sealy","short_name":"RA Sealy","first_name":"Ramon Sealy","last_name":"","middle_name":"","birthdate":"1991-04-22","birthplace":"","country":"ky","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Cayman Islands","role":"wk","role_str":""},{"pid":52470,"title":"Sacha De Alwis","short_name":"YSD Seneveratne","first_name":"Sacha De Alwis","last_name":"","middle_name":"","birthdate":"1992-01-30","birthplace":"","country":"ky","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","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":"Cayman Islands","role":"squad","role_str":""},{"pid":52471,"title":"Omar Willis","short_name":"OR Willis","first_name":"Omar Willis","last_name":"","middle_name":"","birthdate":"1986-11-25","birthplace":"","country":"ky","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","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":"Cayman Islands","role":"squad","role_str":""},{"pid":52476,"title":"Conroy Wright","short_name":"C Wright","first_name":"Conroy Wright","last_name":"","middle_name":"","birthdate":"1985-04-18","birthplace":"","country":"ky","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","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":"Cayman Islands","role":"bowl","role_str":"(C)"},{"pid":52480,"title":"Adrian Wright","short_name":"A Wright","first_name":"Adrian Wright","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ky","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":"Cayman Islands","role":"bowl","role_str":""},{"pid":52481,"title":"Troy Taylor","short_name":"T Taylor","first_name":"Troy Taylor","last_name":"","middle_name":"","birthdate":"1984-02-28","birthplace":"","country":"ky","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Cayman Islands","role":"bowl","role_str":""},{"pid":52482,"title":"Alessandro Morris","short_name":"A Morris","first_name":"Alessandro Morris","last_name":"","middle_name":"","birthdate":"1982-08-22","birthplace":"","country":"ky","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":"Cayman Islands","role":"bowl","role_str":""},{"pid":61514,"title":"Ronald Ebanks","short_name":"Ronald Ebanks","first_name":"Ronald Ebanks","last_name":"","middle_name":"","birthdate":"1983-04-21","birthplace":"","country":"ky","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Cayman Islands","role":"bowl","role_str":""},{"pid":90558,"title":"Pargat Singh","short_name":"Pargat Singh","first_name":"Pargat Singh","last_name":"","middle_name":"","birthdate":"1992-04-13","birthplace":"","country":"ca","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Canada","role":"bat","role_str":""},{"pid":90992,"title":"Jaskaran Singh","short_name":"Jaskaran Singh","first_name":"Jaskaran Singh","last_name":"","middle_name":"","birthdate":"1989-09-04","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","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":"India","role":"bowl","role_str":""},{"pid":93722,"title":"Dillon Heyliger","short_name":"D Heyliger","first_name":"Dillon Heyliger","last_name":"","middle_name":"","birthdate":"1989-10-21","birthplace":"","country":"ca","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","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":"Canada","role":"bowl","role_str":""},{"pid":94979,"title":"Ravinderpal Singh","short_name":"R Singh","first_name":"Ravinderpal Singh","last_name":"","middle_name":"","birthdate":"1988-10-14","birthplace":"","country":"ca","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Canada","role":"squad","role_str":""},{"pid":95877,"title":"Paul Manning","short_name":"P Manning","first_name":"Paul Manning","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ky","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Cayman Islands","role":"squad","role_str":""},{"pid":96319,"title":"Saad Zafar","short_name":"S Zafar","first_name":"Saad Zafar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ca","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":"Canada","role":"all","role_str":""},{"pid":96416,"title":"Kanwarpal Tathgur","short_name":"K Tathgur","first_name":"Kanwarpal Tathgur","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ca","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":"Canada","role":"wk","role_str":"(WK)"},{"pid":96417,"title":"Shreyas Movva","short_name":"S Movva","first_name":"Shreyas Movva","last_name":"","middle_name":"","birthdate":"1993-09-04","birthplace":"","country":"ca","primary_team":[],"logo_url":"","playing_role":"wk","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":"Canada","role":"squad","role_str":""},{"pid":96421,"title":"Kaleem Sana","short_name":"K Sana","first_name":"Kaleem Sana","last_name":"","middle_name":"","birthdate":"1994-01-01","birthplace":"","country":"ca","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Canada","role":"bowl","role_str":""},{"pid":96773,"title":"Mihir Patel","short_name":"M Patel","first_name":"Mihir Patel","last_name":"","middle_name":"","birthdate":"2002-11-01","birthplace":"","country":"ca","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","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":"Canada","role":"squad","role_str":""},{"pid":104951,"title":"Ansh Patel","short_name":"A Patel","first_name":"Ansh Patel","last_name":"","middle_name":"","birthdate":"2002-02-19","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","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":"India","role":"squad","role_str":""},{"pid":117913,"title":"Aaron Johnson","short_name":"Aaron Johnson","first_name":"Aaron Johnson","last_name":"","middle_name":"","birthdate":"1991-03-16","birthplace":"","country":"ca","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Canada","role":"bat","role_str":""},{"pid":124262,"title":"Paul Chin","short_name":"P Chin","first_name":"Paul Chin","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ck","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":"Cook Islands","role":"squad","role_str":""},{"pid":124264,"title":"Brian Corbin","short_name":"B Corbin","first_name":"Brian Corbin","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ck","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Cook Islands","role":"bat","role_str":""},{"pid":128466,"title":"Dilpreet Bajwa","short_name":"D Bajwa","first_name":"Dilpreet Bajwa","last_name":"","middle_name":"","birthdate":"2003-01-26","birthplace":"","country":"ca","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":"Canada","role":"squad","role_str":""},{"pid":130124,"title":"Yuvraj Samra","short_name":"Y Samra","first_name":"Yuvraj Samra","last_name":"","middle_name":"","birthdate":"2006-09-29","birthplace":"","country":"ca","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":"Canada","role":"bat","role_str":""},{"pid":132664,"title":"Romeo Dunka","short_name":"R Dunka","first_name":"Romeo Dunka","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ky","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Cayman Islands","role":"all","role_str":""},{"pid":132666,"title":"Kevon Bazil","short_name":"K Bazil","first_name":"Kevon Bazil","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ky","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":"Cayman Islands","role":"squad","role_str":""},{"pid":132667,"title":"Akshay Naidoo","short_name":"A Naidoo","first_name":"Akshay Naidoo","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ky","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Cayman Islands","role":"bat","role_str":""},{"pid":138251,"title":"Parveen Kumar Dhull","short_name":"P Dhull","first_name":"Parveen Kumar Dhull","last_name":"","middle_name":"","birthdate":"1994-05-29","birthplace":"","country":"ca","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Canada","role":"squad","role_str":""},{"pid":141763,"title":"Jermaine Baker","short_name":"J Baker","first_name":"Jermaine Baker","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ky","primary_team":[],"logo_url":"","playing_role":"wk","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":"Cayman Islands","role":"wk","role_str":"(WK)"},{"pid":141805,"title":"Davion Codner","short_name":"Davion Codner","first_name":"Davion Codner","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ky","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":"Cayman Islands","role":"squad","role_str":""},{"pid":145431,"title":"Rickel Walker","short_name":"R Walker","first_name":"Rickel Walker","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ky","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Cayman Islands","role":"squad","role_str":""},{"pid":145432,"title":"Samuel Foster","short_name":"S Foster","first_name":"Samuel Foster","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ky","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":"Cayman Islands","role":"bat","role_str":""},{"pid":147985,"title":"Ali Nadeem","short_name":"A Nadeem","first_name":"Ali Nadeem","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ca","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":"Canada","role":"squad","role_str":""},{"pid":147987,"title":"Shivam Sharma","short_name":"S Sharma","first_name":"Shivam Sharma","last_name":"","middle_name":"","birthdate":"1998-03-27","birthplace":"","country":"ca","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Canada","role":"all","role_str":""}]},"etag":"6fcae24897075c148b5986708907b5e6","modified":"2025-07-30 19:49:57","datetime":"2025-07-30 19:49:57","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":90750,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Canada won by 59 runs","day_remaining_over":"","team_batting":"Cayman Islands","team_bowling":"Canada","live_inning_number":2,"live_score":{"runs":103,"overs":20,"wickets":9,"target":163,"runrate":5.15,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Troy Taylor","batsman_id":52481,"runs":0,"balls_faced":2,"fours":0,"sixes":0,"strike_rate":"0.00"},{"name":"Alessandro Morris","batsman_id":52482,"runs":8,"balls_faced":19,"fours":2,"sixes":0,"strike_rate":"42.11"}],"bowlers":[{"name":"Dillon Heyliger","bowler_id":93722,"overs":2,"runs_conceded":19,"wickets":0,"maidens":0,"econ":"9.50"},{"name":"Kaleem Sana","bowler_id":96421,"overs":4,"runs_conceded":14,"wickets":1,"maidens":2,"econ":"3.50"}],"commentaries":[{"event":"overend","over":16,"runs":1,"score":"90\/7","bats":[{"runs":10,"balls_faced":19,"fours":0,"sixes":0,"batsman_id":145432},{"runs":0,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":52482}],"bowls":[{"runs_conceded":12,"maidens":1,"wickets":2,"bowler_id":1126,"overs":3},{"runs_conceded":17,"maidens":0,"wickets":1,"bowler_id":96319,"overs":4}],"commentary":"End of over 16 (1 runs), Cayman Islands 90\/7"},{"event_id":"12157481","event":"ball","batsman_id":"52482","bowler_id":"96421","over":"16","ball":"1","score":0,"commentary":"Kaleem Sana to Alessandro Morris, no run,","noball_dismissal":false,"text":"","timestamp":1750095260,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12157490","event":"ball","batsman_id":"52482","bowler_id":"96421","over":"16","ball":"2","score":0,"commentary":"Kaleem Sana to Alessandro Morris, no run,","noball_dismissal":false,"text":"","timestamp":1750095311,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12157498","event":"ball","batsman_id":"52482","bowler_id":"96421","over":"16","ball":"3","score":0,"commentary":"Kaleem Sana to Alessandro Morris, no run,","noball_dismissal":false,"text":"","timestamp":1750095368,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12157499","event":"ball","batsman_id":"52482","bowler_id":"96421","over":"16","ball":"4","score":0,"commentary":"Kaleem Sana to Alessandro Morris, no run,","noball_dismissal":false,"text":"","timestamp":1750095431,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12157503","event":"ball","batsman_id":"52482","bowler_id":"96421","over":"16","ball":"5","score":0,"commentary":"Kaleem Sana to Alessandro Morris, no run,","noball_dismissal":false,"text":"","timestamp":1750095436,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12157504","event":"ball","batsman_id":"52482","bowler_id":"96421","over":"16","ball":"6","score":0,"commentary":"Kaleem Sana to Alessandro Morris, no run,","noball_dismissal":false,"text":"","timestamp":1750095439,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":17,"runs":0,"score":"90\/7","bats":[{"runs":0,"balls_faced":9,"fours":0,"sixes":0,"batsman_id":52482},{"runs":10,"balls_faced":19,"fours":0,"sixes":0,"batsman_id":145432}],"bowls":[{"runs_conceded":14,"maidens":1,"wickets":0,"bowler_id":96421,"overs":3},{"runs_conceded":12,"maidens":1,"wickets":2,"bowler_id":1126,"overs":3}],"commentary":"End of over 17 (0 runs), Cayman Islands 90\/7"},{"event_id":"12157518","event":"ball","batsman_id":"145432","bowler_id":"1126","over":"17","ball":"1","score":2,"commentary":"Harsh Thaker to Samuel Foster, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750095571,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12157519","event":"ball","batsman_id":"145432","bowler_id":"1126","over":"17","ball":"2","score":1,"commentary":"Harsh Thaker to Samuel Foster, 1 run,","noball_dismissal":false,"text":"","timestamp":1750095575,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12157521","event":"ball","batsman_id":"52482","bowler_id":"1126","over":"17","ball":"3","score":0,"commentary":"Harsh Thaker to Alessandro Morris, no run,","noball_dismissal":false,"text":"","timestamp":1750095580,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12157523","event":"ball","batsman_id":"52482","bowler_id":"1126","over":"17","ball":"4","score":4,"commentary":"Harsh Thaker to Alessandro Morris, Four,","noball_dismissal":false,"text":"","timestamp":1750095597,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12157524","event":"ball","batsman_id":"52482","bowler_id":"1126","over":"17","ball":"5","score":0,"commentary":"Harsh Thaker to Alessandro Morris, no run,","noball_dismissal":false,"text":"","timestamp":1750095636,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12157530","event":"ball","batsman_id":"52482","bowler_id":"1126","over":"17","ball":"6","score":0,"commentary":"Harsh Thaker to Alessandro Morris, no run,","noball_dismissal":false,"text":"","timestamp":1750095640,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":18,"runs":7,"score":"97\/7","bats":[{"runs":4,"balls_faced":13,"fours":1,"sixes":0,"batsman_id":52482},{"runs":13,"balls_faced":21,"fours":0,"sixes":0,"batsman_id":145432}],"bowls":[{"runs_conceded":19,"maidens":1,"wickets":2,"bowler_id":1126,"overs":4},{"runs_conceded":14,"maidens":1,"wickets":0,"bowler_id":96421,"overs":3}],"commentary":"End of over 18 (7 runs), Cayman Islands 97\/7"},{"event_id":"12157535","event":"wicket","batsman_id":"145432","bowler_id":"96421","over":"18","ball":"1","score":"w","commentary":"Kaleem Sana to Samuel Foster, no run, c K Tathgur b K Sana,","noball_dismissal":false,"text":"","timestamp":1750095694,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"145432","how_out":"c K Tathgur b K Sana","batsman_runs":"13","batsman_balls":"22"},{"event_id":"12157549","event":"ball","batsman_id":"52480","bowler_id":"96421","over":"18","ball":"2","score":0,"commentary":"Kaleem Sana to Adrian Wright, no run,","noball_dismissal":false,"text":"","timestamp":1750096004,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12157550","event":"ball","batsman_id":"52480","bowler_id":"96421","over":"18","ball":"3","score":0,"commentary":"Kaleem Sana to Adrian Wright, no run,","noball_dismissal":false,"text":"","timestamp":1750096011,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12157565","event":"wicket","batsman_id":"52480","bowler_id":"96421","over":"18","ball":"4","score":"w","commentary":"Kaleem Sana to Adrian Wright, no run, runout (K Tathgur \/ Jaskaran Singh),","noball_dismissal":false,"text":"","timestamp":1750096018,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"52480","how_out":"runout (K Tathgur \/ Jaskaran Singh)","batsman_runs":"0","batsman_balls":"3"},{"event_id":"12157569","event":"ball","batsman_id":"52481","bowler_id":"96421","over":"18","ball":"5","score":0,"commentary":"Kaleem Sana to Troy Taylor, no run,","noball_dismissal":false,"text":"","timestamp":1750096051,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12157570","event":"ball","batsman_id":"52481","bowler_id":"96421","over":"18","ball":"6","score":0,"commentary":"Kaleem Sana to Troy Taylor, no run,","noball_dismissal":false,"text":"","timestamp":1750096055,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":19,"runs":0,"score":"97\/9","bats":[{"runs":0,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":52481},{"runs":4,"balls_faced":13,"fours":1,"sixes":0,"batsman_id":52482}],"bowls":[{"runs_conceded":14,"maidens":2,"wickets":1,"bowler_id":96421,"overs":4},{"runs_conceded":19,"maidens":1,"wickets":2,"bowler_id":1126,"overs":4}],"commentary":"End of over 19 (0 runs), Cayman Islands 97\/9"},{"event_id":"12157576","event":"ball","batsman_id":"52482","bowler_id":"93722","over":"19","ball":"1","score":"1wd","commentary":"Dillon Heyliger to Alessandro Morris, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750096209,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12157588","event":"ball","batsman_id":"52482","bowler_id":"93722","over":"19","ball":"1","score":0,"commentary":"Dillon Heyliger to Alessandro Morris, no run,","noball_dismissal":false,"text":"","timestamp":1750096214,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12157590","event":"ball","batsman_id":"52482","bowler_id":"93722","over":"19","ball":"2","score":0,"commentary":"Dillon Heyliger to Alessandro Morris, no run,","noball_dismissal":false,"text":"","timestamp":1750096217,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12157591","event":"ball","batsman_id":"52482","bowler_id":"93722","over":"19","ball":"3","score":4,"commentary":"Dillon Heyliger to Alessandro Morris, Four,","noball_dismissal":false,"text":"","timestamp":1750096220,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12157592","event":"ball","batsman_id":"52482","bowler_id":"93722","over":"19","ball":"4","score":"1wd","commentary":"Dillon Heyliger to Alessandro Morris, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750096224,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12157594","event":"ball","batsman_id":"52482","bowler_id":"93722","over":"19","ball":"4","score":0,"commentary":"Dillon Heyliger to Alessandro Morris, no run,","noball_dismissal":false,"text":"","timestamp":1750096233,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12157604","event":"ball","batsman_id":"52482","bowler_id":"93722","over":"19","ball":"5","score":0,"commentary":"Dillon Heyliger to Alessandro Morris, no run,","noball_dismissal":false,"text":"","timestamp":1750096360,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12157605","event":"ball","batsman_id":"52482","bowler_id":"93722","over":"19","ball":"6","score":0,"commentary":"Dillon Heyliger to Alessandro Morris, no run,","noball_dismissal":false,"text":"","timestamp":1750096466,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":20,"runs":6,"score":"103\/9","bats":[{"runs":8,"balls_faced":19,"fours":2,"sixes":0,"batsman_id":52482},{"runs":0,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":52481}],"bowls":[{"runs_conceded":19,"maidens":0,"wickets":0,"bowler_id":93722,"overs":2},{"runs_conceded":14,"maidens":2,"wickets":1,"bowler_id":96421,"overs":4}],"commentary":"End of over 20 (6 runs), Cayman Islands 103\/9"}],"day":"0","session":"0","live_inning":{"iid":198207,"number":2,"name":"Cayman Islands Inning","short_name":"CAY Inning","status":2,"issuperover":"false","result":4,"batting_team_id":19688,"fielding_team_id":6791,"scores":"103\/9","scores_full":"103\/9 (20 ov)","fielder":[{"fielder_id":"93722","fielder_name":"Dillon Heyliger","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"96421","fielder_name":"Kaleem Sana","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"96416","fielder_name":"Kanwarpal Tathgur","catches":3,"runout_thrower":0,"runout_catcher":1,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"90992","fielder_name":"Jaskaran Singh","catches":0,"runout_thrower":1,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Adrian Wright","batsman_id":"52480","runs":"0","balls":"3","how_out":"runout (K Tathgur \/ Jaskaran Singh)","score_at_dismissal":97,"overs_at_dismissal":"18.4","bowler_id":"0","dismissal":"runout","number":9},"extra_runs":{"byes":1,"legbyes":6,"wides":7,"noballs":0,"penalty":"0","total":14},"equations":{"runs":103,"wickets":9,"overs":"20","bowlers_used":6,"runrate":"5.15"},"current_partnership":{"runs":6,"balls":8,"overs":1.2,"batsmen":[{"name":"Troy Taylor","batsman_id":52481,"runs":0,"balls":2},{"name":"Alessandro Morris","batsman_id":52482,"runs":4,"balls":6}]},"did_not_bat":[],"max_over":"20","target":"163","recent_scores":"0,0,0,1,4,0,0,1,0,0,w,0,0,w,0,0,4,0","last_five_overs":"14\/3 2.63","last_ten_overs":"29\/6 2.76"},"teams":[{"tid":6791,"title":"Canada","abbr":"CAN","alt_name":"Canada","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/CANADA.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/CANADA.png","country":"ca","sex":"male","team_owner":"","head_coach":"Pubudu Dassanayake","scores_full":"162\/5 (20 ov)","scores":"162\/5","overs":"20"},{"tid":19688,"title":"Cayman Islands","abbr":"CAY","alt_name":"Cayman Islands","type":"country","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Cayman-Islands.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Cayman-Islands.png","country":"ky","sex":"male","team_owner":"","head_coach":"","scores_full":"103\/9 (20 ov)","scores":"103\/9","overs":"20"}],"players":[{"pid":1126,"title":"Harsh Thaker","short_name":"H Thaker","first_name":"Harsh Thaker","last_name":"","middle_name":"","birthdate":"1997-10-24","birthplace":"","country":"ca","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Canada","role":"all","role_str":""},{"pid":49185,"title":"Navneet Dhaliwal","short_name":"NS Dhaliwal","first_name":"Navneet Dhaliwal","last_name":"","middle_name":"","birthdate":"1988-10-10","birthplace":"","country":"ca","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Canada","role":"squad","role_str":""},{"pid":52190,"title":"Nicholas Kirton","short_name":"Nicholas Kirton","first_name":"Nicholas Kirton","last_name":"","middle_name":"","birthdate":"1998-05-06","birthplace":"","country":"ca","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","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":"Canada","role":"bat","role_str":"(C)"},{"pid":52468,"title":"Ramon Sealy","short_name":"RA Sealy","first_name":"Ramon Sealy","last_name":"","middle_name":"","birthdate":"1991-04-22","birthplace":"","country":"ky","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Cayman Islands","role":"wk","role_str":""},{"pid":52470,"title":"Sacha De Alwis","short_name":"YSD Seneveratne","first_name":"Sacha De Alwis","last_name":"","middle_name":"","birthdate":"1992-01-30","birthplace":"","country":"ky","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","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":"Cayman Islands","role":"squad","role_str":""},{"pid":52471,"title":"Omar Willis","short_name":"OR Willis","first_name":"Omar Willis","last_name":"","middle_name":"","birthdate":"1986-11-25","birthplace":"","country":"ky","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","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":"Cayman Islands","role":"squad","role_str":""},{"pid":52476,"title":"Conroy Wright","short_name":"C Wright","first_name":"Conroy Wright","last_name":"","middle_name":"","birthdate":"1985-04-18","birthplace":"","country":"ky","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","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":"Cayman Islands","role":"bowl","role_str":"(C)"},{"pid":52480,"title":"Adrian Wright","short_name":"A Wright","first_name":"Adrian Wright","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ky","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":"Cayman Islands","role":"bowl","role_str":""},{"pid":52481,"title":"Troy Taylor","short_name":"T Taylor","first_name":"Troy Taylor","last_name":"","middle_name":"","birthdate":"1984-02-28","birthplace":"","country":"ky","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Cayman Islands","role":"bowl","role_str":""},{"pid":52482,"title":"Alessandro Morris","short_name":"A Morris","first_name":"Alessandro Morris","last_name":"","middle_name":"","birthdate":"1982-08-22","birthplace":"","country":"ky","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":"Cayman Islands","role":"bowl","role_str":""},{"pid":61514,"title":"Ronald Ebanks","short_name":"Ronald Ebanks","first_name":"Ronald Ebanks","last_name":"","middle_name":"","birthdate":"1983-04-21","birthplace":"","country":"ky","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Cayman Islands","role":"bowl","role_str":""},{"pid":90558,"title":"Pargat Singh","short_name":"Pargat Singh","first_name":"Pargat Singh","last_name":"","middle_name":"","birthdate":"1992-04-13","birthplace":"","country":"ca","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Canada","role":"bat","role_str":""},{"pid":90992,"title":"Jaskaran Singh","short_name":"Jaskaran Singh","first_name":"Jaskaran Singh","last_name":"","middle_name":"","birthdate":"1989-09-04","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","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":"India","role":"bowl","role_str":""},{"pid":93722,"title":"Dillon Heyliger","short_name":"D Heyliger","first_name":"Dillon Heyliger","last_name":"","middle_name":"","birthdate":"1989-10-21","birthplace":"","country":"ca","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","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":"Canada","role":"bowl","role_str":""},{"pid":94979,"title":"Ravinderpal Singh","short_name":"R Singh","first_name":"Ravinderpal Singh","last_name":"","middle_name":"","birthdate":"1988-10-14","birthplace":"","country":"ca","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Canada","role":"squad","role_str":""},{"pid":95877,"title":"Paul Manning","short_name":"P Manning","first_name":"Paul Manning","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ky","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Cayman Islands","role":"squad","role_str":""},{"pid":96319,"title":"Saad Zafar","short_name":"S Zafar","first_name":"Saad Zafar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ca","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":"Canada","role":"all","role_str":""},{"pid":96416,"title":"Kanwarpal Tathgur","short_name":"K Tathgur","first_name":"Kanwarpal Tathgur","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ca","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":"Canada","role":"wk","role_str":"(WK)"},{"pid":96417,"title":"Shreyas Movva","short_name":"S Movva","first_name":"Shreyas Movva","last_name":"","middle_name":"","birthdate":"1993-09-04","birthplace":"","country":"ca","primary_team":[],"logo_url":"","playing_role":"wk","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":"Canada","role":"squad","role_str":""},{"pid":96421,"title":"Kaleem Sana","short_name":"K Sana","first_name":"Kaleem Sana","last_name":"","middle_name":"","birthdate":"1994-01-01","birthplace":"","country":"ca","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Canada","role":"bowl","role_str":""},{"pid":96773,"title":"Mihir Patel","short_name":"M Patel","first_name":"Mihir Patel","last_name":"","middle_name":"","birthdate":"2002-11-01","birthplace":"","country":"ca","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","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":"Canada","role":"squad","role_str":""},{"pid":104951,"title":"Ansh Patel","short_name":"A Patel","first_name":"Ansh Patel","last_name":"","middle_name":"","birthdate":"2002-02-19","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","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":"India","role":"squad","role_str":""},{"pid":117913,"title":"Aaron Johnson","short_name":"Aaron Johnson","first_name":"Aaron Johnson","last_name":"","middle_name":"","birthdate":"1991-03-16","birthplace":"","country":"ca","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Canada","role":"bat","role_str":""},{"pid":124262,"title":"Paul Chin","short_name":"P Chin","first_name":"Paul Chin","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ck","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":"Cook Islands","role":"squad","role_str":""},{"pid":124264,"title":"Brian Corbin","short_name":"B Corbin","first_name":"Brian Corbin","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ck","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Cook Islands","role":"bat","role_str":""},{"pid":128466,"title":"Dilpreet Bajwa","short_name":"D Bajwa","first_name":"Dilpreet Bajwa","last_name":"","middle_name":"","birthdate":"2003-01-26","birthplace":"","country":"ca","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":"Canada","role":"squad","role_str":""},{"pid":130124,"title":"Yuvraj Samra","short_name":"Y Samra","first_name":"Yuvraj Samra","last_name":"","middle_name":"","birthdate":"2006-09-29","birthplace":"","country":"ca","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":"Canada","role":"bat","role_str":""},{"pid":132664,"title":"Romeo Dunka","short_name":"R Dunka","first_name":"Romeo Dunka","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ky","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Cayman Islands","role":"all","role_str":""},{"pid":132666,"title":"Kevon Bazil","short_name":"K Bazil","first_name":"Kevon Bazil","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ky","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":"Cayman Islands","role":"squad","role_str":""},{"pid":132667,"title":"Akshay Naidoo","short_name":"A Naidoo","first_name":"Akshay Naidoo","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ky","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Cayman Islands","role":"bat","role_str":""},{"pid":138251,"title":"Parveen Kumar Dhull","short_name":"P Dhull","first_name":"Parveen Kumar Dhull","last_name":"","middle_name":"","birthdate":"1994-05-29","birthplace":"","country":"ca","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Canada","role":"squad","role_str":""},{"pid":141763,"title":"Jermaine Baker","short_name":"J Baker","first_name":"Jermaine Baker","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ky","primary_team":[],"logo_url":"","playing_role":"wk","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":"Cayman Islands","role":"wk","role_str":"(WK)"},{"pid":141805,"title":"Davion Codner","short_name":"Davion Codner","first_name":"Davion Codner","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ky","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":"Cayman Islands","role":"squad","role_str":""},{"pid":145431,"title":"Rickel Walker","short_name":"R Walker","first_name":"Rickel Walker","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ky","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Cayman Islands","role":"squad","role_str":""},{"pid":145432,"title":"Samuel Foster","short_name":"S Foster","first_name":"Samuel Foster","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ky","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":"Cayman Islands","role":"bat","role_str":""},{"pid":147985,"title":"Ali Nadeem","short_name":"A Nadeem","first_name":"Ali Nadeem","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ca","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":"Canada","role":"squad","role_str":""},{"pid":147987,"title":"Shivam Sharma","short_name":"S Sharma","first_name":"Shivam Sharma","last_name":"","middle_name":"","birthdate":"1998-03-27","birthplace":"","country":"ca","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Canada","role":"all","role_str":""}]},"etag":"6fcae24897075c148b5986708907b5e6","modified":"2025-07-30 19:49:57","datetime":"2025-07-30 19:49:57","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90750 AND DataTypeId = 1 END

System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'StatusId'. Invalid column name 'ErrorLog'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Etoz.ConnectData.DataAccess.ExecuteQuery(String query) in c:\inetpub\wwwroot\cricdirect.com\api\v6\App_Code\db\data_access.cs:line 117 ClientConnectionId:13226f4e-6989-43bb-a4d3-c1f5907b3ef9 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90750 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90750,3,'{"status":"ok","response":{"match_id":90750,"title":"Canada vs Cayman Islands","short_title":"CAN vs CAY","subtitle":"Match 3","match_number":"3","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Canada won by 59 runs","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129634,"title":"ICC Mens T20 World Cup Americas Regional Final","abbr":"ICC Mens T20 World Cup Americas Regional Final","type":"tournament","category":"international","match_format":"t20","season":"2025","status":"live","datestart":"2025-06-15","dateend":"2025-06-23","country":"int","total_matches":"12","total_rounds":"1","total_teams":"4"},"teama":{"team_id":6791,"name":"Canada","short_name":"CAN","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/CANADA.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/CANADA.png","scores_full":"162\/5 (20 ov)","scores":"162\/5","overs":"20"},"teamb":{"team_id":19688,"name":"Cayman Islands","short_name":"CAY","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Cayman-Islands.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Cayman-Islands.png","scores_full":"103\/9 (20 ov)","scores":"103\/9","overs":"20"},"date_start":"2025-06-16 14:30:00","date_end":"2025-06-17 00:30:00","timestamp_start":1750084200,"timestamp_end":1750120200,"date_start_ist":"2025-06-16 20:00:00","date_end_ist":"2025-06-17 06:00:00","venue":{"venue_id":"294","name":"Maple Leaf North-West Ground (A)","location":"King City","country":"Canada","timezone":""},"umpires":"regory Brathwaite (West Indies), Zahid Bassarath (West Indies), Arnold Maddela (Canada, TV)","referee":"Deighton Butler (West Indies)","equation":"","live":"","result":"CAN won by 59 runs","result_type":1,"win_margin":"59 runs","winning_team_id":6791,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-16 01:22:45","verify_time":"2025-06-16 23:45:48","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":23.97,"humidity":57,"visibility":10000,"wind_speed":"7.18","clouds":100},"pitch":{"pitch_condition":"Spinning Pitch","batting_condition":"Average","pace_bowling_condition":"Swing Favourable","spine_bowling_condition":"Average"},"toss":{"text":"Cayman Islands elected to bowl","winner":19688,"decision":2}},"etag":"d7966b20e30785c0ffbe79702ecc257b","modified":"2025-07-30 19:49:58","datetime":"2025-07-30 19:49:58","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90750,"title":"Canada vs Cayman Islands","short_title":"CAN vs CAY","subtitle":"Match 3","match_number":"3","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Canada won by 59 runs","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129634,"title":"ICC Mens T20 World Cup Americas Regional Final","abbr":"ICC Mens T20 World Cup Americas Regional Final","type":"tournament","category":"international","match_format":"t20","season":"2025","status":"live","datestart":"2025-06-15","dateend":"2025-06-23","country":"int","total_matches":"12","total_rounds":"1","total_teams":"4"},"teama":{"team_id":6791,"name":"Canada","short_name":"CAN","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/CANADA.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/CANADA.png","scores_full":"162\/5 (20 ov)","scores":"162\/5","overs":"20"},"teamb":{"team_id":19688,"name":"Cayman Islands","short_name":"CAY","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Cayman-Islands.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Cayman-Islands.png","scores_full":"103\/9 (20 ov)","scores":"103\/9","overs":"20"},"date_start":"2025-06-16 14:30:00","date_end":"2025-06-17 00:30:00","timestamp_start":1750084200,"timestamp_end":1750120200,"date_start_ist":"2025-06-16 20:00:00","date_end_ist":"2025-06-17 06:00:00","venue":{"venue_id":"294","name":"Maple Leaf North-West Ground (A)","location":"King City","country":"Canada","timezone":""},"umpires":"regory Brathwaite (West Indies), Zahid Bassarath (West Indies), Arnold Maddela (Canada, TV)","referee":"Deighton Butler (West Indies)","equation":"","live":"","result":"CAN won by 59 runs","result_type":1,"win_margin":"59 runs","winning_team_id":6791,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-16 01:22:45","verify_time":"2025-06-16 23:45:48","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":23.97,"humidity":57,"visibility":10000,"wind_speed":"7.18","clouds":100},"pitch":{"pitch_condition":"Spinning Pitch","batting_condition":"Average","pace_bowling_condition":"Swing Favourable","spine_bowling_condition":"Average"},"toss":{"text":"Cayman Islands elected to bowl","winner":19688,"decision":2}},"etag":"d7966b20e30785c0ffbe79702ecc257b","modified":"2025-07-30 19:49:58","datetime":"2025-07-30 19:49:58","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90750 AND DataTypeId = 3 END
Live Report & Scorecard of Canada vs Cayman Islands Match 3