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:10a0b3d9-a3ee-4dc9-890a-9cc34ff7b764
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90755 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90755,1,'{"status":"ok","response":{"mid":90755,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Canada won by 42 runs","day_remaining_over":"","team_batting":"Cayman Islands","team_bowling":"Canada","live_inning_number":2,"live_score":{"runs":39,"overs":5,"wickets":5,"target":82,"runrate":7.8,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Samuel Foster","batsman_id":145432,"runs":3,"balls_faced":4,"fours":0,"sixes":0,"strike_rate":"75.00"},{"name":"Rickel Walker","batsman_id":145431,"runs":0,"balls_faced":1,"fours":0,"sixes":0,"strike_rate":"0.00"}],"bowlers":[{"name":"Saad Zafar","bowler_id":96319,"overs":2,"runs_conceded":22,"wickets":1,"maidens":0,"econ":"11.00"},{"name":"Shivam Sharma","bowler_id":147987,"overs":1,"runs_conceded":5,"wickets":2,"maidens":0,"econ":"5.00"}],"commentaries":[{"event_id":"12175729","event":"ball","batsman_id":"124264","bowler_id":"93722","over":"0","ball":"6","score":"1wd","commentary":"Dillon Heyliger to Brian Corbin, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750373742,"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":"12175730","event":"ball","batsman_id":"124264","bowler_id":"93722","over":"0","ball":"6","score":0,"commentary":"Dillon Heyliger to Brian Corbin, no run,","noball_dismissal":false,"text":"","timestamp":1750373767,"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":1,"runs":3,"score":"3\/1","bats":[{"runs":0,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":124264},{"runs":1,"balls_faced":4,"fours":0,"sixes":0,"batsman_id":141763}],"bowls":[{"runs_conceded":3,"maidens":0,"wickets":1,"bowler_id":93722,"overs":1}],"commentary":"End of over 1 (3 runs), Cayman Islands 3\/1"},{"event_id":"12175733","event":"ball","batsman_id":"141763","bowler_id":"96319","over":"1","ball":"1","score":2,"commentary":"Saad Zafar to Jermaine Baker, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750373869,"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":"12175734","event":"ball","batsman_id":"141763","bowler_id":"96319","over":"1","ball":"2","score":6,"commentary":"Saad Zafar to Jermaine Baker, Six,","noball_dismissal":false,"text":"","timestamp":1750373885,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12175735","event":"ball","batsman_id":"141763","bowler_id":"96319","over":"1","ball":"3","score":6,"commentary":"Saad Zafar to Jermaine Baker, Six,","noball_dismissal":false,"text":"","timestamp":1750373917,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12175736","event":"wicket","batsman_id":"141763","bowler_id":"96319","over":"1","ball":"4","score":"w","commentary":"Saad Zafar to Jermaine Baker, no run, c Jaskaran Singh b S Zafar,","noball_dismissal":false,"text":"","timestamp":1750373981,"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":"141763","how_out":"c Jaskaran Singh b S Zafar","batsman_runs":"15","batsman_balls":"8"},{"event_id":"12175741","event":"ball","batsman_id":"132664","bowler_id":"96319","over":"1","ball":"5","score":0,"commentary":"Saad Zafar to Romeo Dunka, no run,","noball_dismissal":false,"text":"","timestamp":1750374020,"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":"12175742","event":"ball","batsman_id":"132664","bowler_id":"96319","over":"1","ball":"6","score":4,"commentary":"Saad Zafar to Romeo Dunka, Four,","noball_dismissal":false,"text":"","timestamp":1750374023,"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":"overend","over":2,"runs":18,"score":"21\/2","bats":[{"runs":4,"balls_faced":2,"fours":1,"sixes":0,"batsman_id":132664},{"runs":0,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":124264}],"bowls":[{"runs_conceded":18,"maidens":0,"wickets":1,"bowler_id":96319,"overs":1},{"runs_conceded":3,"maidens":0,"wickets":1,"bowler_id":93722,"overs":1}],"commentary":"End of over 2 (18 runs), Cayman Islands 21\/2"},{"event_id":"12175743","event":"ball","batsman_id":"124264","bowler_id":"1126","over":"2","ball":"1","score":1,"commentary":"Harsh Thaker to Brian Corbin, 1 run,","noball_dismissal":false,"text":"","timestamp":1750374061,"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":"12175744","event":"ball","batsman_id":"132664","bowler_id":"1126","over":"2","ball":"2","score":6,"commentary":"Harsh Thaker to Romeo Dunka, Six,","noball_dismissal":false,"text":"","timestamp":1750374080,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12175746","event":"ball","batsman_id":"132664","bowler_id":"1126","over":"2","ball":"3","score":0,"commentary":"Harsh Thaker to Romeo Dunka, no run,","noball_dismissal":false,"text":"","timestamp":1750374126,"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":"12175747","event":"ball","batsman_id":"132664","bowler_id":"1126","over":"2","ball":"4","score":1,"commentary":"Harsh Thaker to Romeo Dunka, 1 run,","noball_dismissal":false,"text":"","timestamp":1750374129,"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":"12175749","event":"ball","batsman_id":"124264","bowler_id":"1126","over":"2","ball":"5","score":0,"commentary":"Harsh Thaker to Brian Corbin, no run,","noball_dismissal":false,"text":"","timestamp":1750374214,"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":"12175750","event":"ball","batsman_id":"124264","bowler_id":"1126","over":"2","ball":"6","score":1,"commentary":"Harsh Thaker to Brian Corbin, 1 run,","noball_dismissal":false,"text":"","timestamp":1750374216,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":3,"runs":9,"score":"30\/2","bats":[{"runs":2,"balls_faced":4,"fours":0,"sixes":0,"batsman_id":124264},{"runs":11,"balls_faced":5,"fours":1,"sixes":1,"batsman_id":132664}],"bowls":[{"runs_conceded":9,"maidens":0,"wickets":0,"bowler_id":1126,"overs":1},{"runs_conceded":18,"maidens":0,"wickets":1,"bowler_id":96319,"overs":1}],"commentary":"End of over 3 (9 runs), Cayman Islands 30\/2"},{"event_id":"12175751","event":"ball","batsman_id":"124264","bowler_id":"147987","over":"3","ball":"1","score":4,"commentary":"Shivam Sharma to Brian Corbin, Four,","noball_dismissal":false,"text":"","timestamp":1750374271,"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":"12175752","event":"wicket","batsman_id":"124264","bowler_id":"147987","over":"3","ball":"2","score":"w","commentary":"Shivam Sharma to Brian Corbin, no run, b S Sharma,","noball_dismissal":false,"text":"","timestamp":1750374297,"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":"124264","how_out":"b S Sharma","batsman_runs":"6","batsman_balls":"6"},{"event_id":"12175753","event":"ball","batsman_id":"145432","bowler_id":"147987","over":"3","ball":"3","score":0,"commentary":"Shivam Sharma to Samuel Foster, no run,","noball_dismissal":false,"text":"","timestamp":1750374349,"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":"12175754","event":"ball","batsman_id":"145432","bowler_id":"147987","over":"3","ball":"4","score":1,"commentary":"Shivam Sharma to Samuel Foster, 1 run,","noball_dismissal":false,"text":"","timestamp":1750374371,"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":"12175755","event":"ball","batsman_id":"132664","bowler_id":"147987","over":"3","ball":"5","score":0,"commentary":"Shivam Sharma to Romeo Dunka, no run,","noball_dismissal":false,"text":"","timestamp":1750374415,"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":"12175757","event":"wicket","batsman_id":"132664","bowler_id":"147987","over":"3","ball":"6","score":"w","commentary":"Shivam Sharma to Romeo Dunka, no run, b S Sharma,","noball_dismissal":false,"text":"","timestamp":1750374417,"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":"132664","how_out":"b S Sharma","batsman_runs":"11","batsman_balls":"7"},{"event":"overend","over":4,"runs":5,"score":"35\/4","bats":[{"runs":11,"balls_faced":7,"fours":1,"sixes":1,"batsman_id":132664},{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":145432}],"bowls":[{"runs_conceded":5,"maidens":0,"wickets":2,"bowler_id":147987,"overs":1},{"runs_conceded":9,"maidens":0,"wickets":0,"bowler_id":1126,"overs":1}],"commentary":"End of over 4 (5 runs), Cayman Islands 35\/4"},{"event_id":"12175758","event":"ball","batsman_id":"145432","bowler_id":"96319","over":"4","ball":"1","score":1,"commentary":"Saad Zafar to Samuel Foster, 1 run,","noball_dismissal":false,"text":"","timestamp":1750374500,"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":"12175759","event":"ball","batsman_id":"132667","bowler_id":"96319","over":"4","ball":"2","score":0,"commentary":"Saad Zafar to Akshay Naidoo, no run,","noball_dismissal":false,"text":"","timestamp":1750374502,"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":"12175760","event":"ball","batsman_id":"132667","bowler_id":"96319","over":"4","ball":"3","score":1,"commentary":"Saad Zafar to Akshay Naidoo, 1 run,","noball_dismissal":false,"text":"","timestamp":1750374505,"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":"12175762","event":"ball","batsman_id":"145432","bowler_id":"96319","over":"4","ball":"4","score":1,"commentary":"Saad Zafar to Samuel Foster, 1 run,","noball_dismissal":false,"text":"","timestamp":1750374515,"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":"12175763","event":"wicket","batsman_id":"132667","bowler_id":"96319","over":"4","ball":"5","score":"w","commentary":"Saad Zafar to Akshay Naidoo, 1 run, runout (K Tathgur \/ S Sharma),","noball_dismissal":false,"text":"","timestamp":1750376205,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"132667","how_out":"runout (K Tathgur \/ S Sharma)","batsman_runs":"2","batsman_balls":"3"},{"event_id":"12175764","event":"ball","batsman_id":"145431","bowler_id":"96319","over":"4","ball":"6","score":0,"commentary":"Saad Zafar to Rickel Walker, no run,","noball_dismissal":false,"text":"","timestamp":1750374980,"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":5,"runs":4,"score":"39\/5","bats":[{"runs":0,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":145431},{"runs":3,"balls_faced":4,"fours":0,"sixes":0,"batsman_id":145432}],"bowls":[{"runs_conceded":22,"maidens":0,"wickets":1,"bowler_id":96319,"overs":2},{"runs_conceded":5,"maidens":0,"wickets":2,"bowler_id":147987,"overs":1}],"commentary":"End of over 5 (4 runs), Cayman Islands 39\/5"}],"day":"0","session":"0","live_inning":{"iid":198402,"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":"39\/5","scores_full":"39\/5 (5 ov)","fielder":[{"fielder_id":"90992","fielder_name":"Jaskaran Singh","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"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":"147987","fielder_name":"Shivam Sharma","catches":0,"runout_thrower":1,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"96416","fielder_name":"Kanwarpal Tathgur","catches":0,"runout_thrower":0,"runout_catcher":1,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":[],"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":"Akshay Naidoo","batsman_id":"132667","runs":"2","balls":"3","how_out":"runout (K Tathgur \/ S Sharma)","score_at_dismissal":39,"overs_at_dismissal":"4.5","bowler_id":"0","dismissal":"runout","number":5},"extra_runs":{"byes":0,"legbyes":0,"wides":2,"noballs":0,"penalty":"0","total":2},"equations":{"runs":39,"wickets":5,"overs":"5","bowlers_used":4,"runrate":"7.80"},"current_partnership":{"runs":0,"balls":1,"overs":0.1,"batsmen":[{"name":"Rickel Walker","batsman_id":145431,"runs":0,"balls":1},{"name":"Samuel Foster","batsman_id":145432,"runs":0,"balls":0}]},"did_not_bat":[{"player_id":"52476","name":"Conroy Wright"},{"player_id":"52480","name":"Adrian Wright"},{"player_id":"132666","name":"Kevon Bazil"},{"player_id":"52482","name":"Alessandro Morris"}],"max_over":"5","target":"82","recent_scores":"0,w,1,1,0,1,w,0,1,0,w,4,1,0,1,0,6,1","last_five_overs":"39\/5 7.31","last_ten_overs":"39\/5 7.31"},"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":"81\/0 (5 ov)","scores":"81\/0","overs":"5"},{"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":"39\/5 (5 ov)","scores":"39\/5","overs":"5"}],"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":"(WK)"},{"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":"squad","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":"squad","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":"squad","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":"bowl","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":"squad","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":"bat","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":"all","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":""},{"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":"bat","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":""},{"pid":149988,"title":"Anubhav Dhar","short_name":"Anubhav Dhar","first_name":"Anubhav Dhar","last_name":"","middle_name":"","birthdate":"1988-10-29","birthplace":"","country":"","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left 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":null,"role":"squad","role_str":""},{"pid":149989,"title":"Sunil","short_name":"Sunil","first_name":"Sunil","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Cayman Islands","role":"squad","role_str":""}]},"etag":"07c7733c9d07887f1738ed04ae86c593","modified":"2025-07-17 04:58:36","datetime":"2025-07-17 04:58:36","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":90755,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Canada won by 42 runs","day_remaining_over":"","team_batting":"Cayman Islands","team_bowling":"Canada","live_inning_number":2,"live_score":{"runs":39,"overs":5,"wickets":5,"target":82,"runrate":7.8,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Samuel Foster","batsman_id":145432,"runs":3,"balls_faced":4,"fours":0,"sixes":0,"strike_rate":"75.00"},{"name":"Rickel Walker","batsman_id":145431,"runs":0,"balls_faced":1,"fours":0,"sixes":0,"strike_rate":"0.00"}],"bowlers":[{"name":"Saad Zafar","bowler_id":96319,"overs":2,"runs_conceded":22,"wickets":1,"maidens":0,"econ":"11.00"},{"name":"Shivam Sharma","bowler_id":147987,"overs":1,"runs_conceded":5,"wickets":2,"maidens":0,"econ":"5.00"}],"commentaries":[{"event_id":"12175729","event":"ball","batsman_id":"124264","bowler_id":"93722","over":"0","ball":"6","score":"1wd","commentary":"Dillon Heyliger to Brian Corbin, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750373742,"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":"12175730","event":"ball","batsman_id":"124264","bowler_id":"93722","over":"0","ball":"6","score":0,"commentary":"Dillon Heyliger to Brian Corbin, no run,","noball_dismissal":false,"text":"","timestamp":1750373767,"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":1,"runs":3,"score":"3\/1","bats":[{"runs":0,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":124264},{"runs":1,"balls_faced":4,"fours":0,"sixes":0,"batsman_id":141763}],"bowls":[{"runs_conceded":3,"maidens":0,"wickets":1,"bowler_id":93722,"overs":1}],"commentary":"End of over 1 (3 runs), Cayman Islands 3\/1"},{"event_id":"12175733","event":"ball","batsman_id":"141763","bowler_id":"96319","over":"1","ball":"1","score":2,"commentary":"Saad Zafar to Jermaine Baker, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750373869,"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":"12175734","event":"ball","batsman_id":"141763","bowler_id":"96319","over":"1","ball":"2","score":6,"commentary":"Saad Zafar to Jermaine Baker, Six,","noball_dismissal":false,"text":"","timestamp":1750373885,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12175735","event":"ball","batsman_id":"141763","bowler_id":"96319","over":"1","ball":"3","score":6,"commentary":"Saad Zafar to Jermaine Baker, Six,","noball_dismissal":false,"text":"","timestamp":1750373917,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12175736","event":"wicket","batsman_id":"141763","bowler_id":"96319","over":"1","ball":"4","score":"w","commentary":"Saad Zafar to Jermaine Baker, no run, c Jaskaran Singh b S Zafar,","noball_dismissal":false,"text":"","timestamp":1750373981,"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":"141763","how_out":"c Jaskaran Singh b S Zafar","batsman_runs":"15","batsman_balls":"8"},{"event_id":"12175741","event":"ball","batsman_id":"132664","bowler_id":"96319","over":"1","ball":"5","score":0,"commentary":"Saad Zafar to Romeo Dunka, no run,","noball_dismissal":false,"text":"","timestamp":1750374020,"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":"12175742","event":"ball","batsman_id":"132664","bowler_id":"96319","over":"1","ball":"6","score":4,"commentary":"Saad Zafar to Romeo Dunka, Four,","noball_dismissal":false,"text":"","timestamp":1750374023,"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":"overend","over":2,"runs":18,"score":"21\/2","bats":[{"runs":4,"balls_faced":2,"fours":1,"sixes":0,"batsman_id":132664},{"runs":0,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":124264}],"bowls":[{"runs_conceded":18,"maidens":0,"wickets":1,"bowler_id":96319,"overs":1},{"runs_conceded":3,"maidens":0,"wickets":1,"bowler_id":93722,"overs":1}],"commentary":"End of over 2 (18 runs), Cayman Islands 21\/2"},{"event_id":"12175743","event":"ball","batsman_id":"124264","bowler_id":"1126","over":"2","ball":"1","score":1,"commentary":"Harsh Thaker to Brian Corbin, 1 run,","noball_dismissal":false,"text":"","timestamp":1750374061,"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":"12175744","event":"ball","batsman_id":"132664","bowler_id":"1126","over":"2","ball":"2","score":6,"commentary":"Harsh Thaker to Romeo Dunka, Six,","noball_dismissal":false,"text":"","timestamp":1750374080,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12175746","event":"ball","batsman_id":"132664","bowler_id":"1126","over":"2","ball":"3","score":0,"commentary":"Harsh Thaker to Romeo Dunka, no run,","noball_dismissal":false,"text":"","timestamp":1750374126,"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":"12175747","event":"ball","batsman_id":"132664","bowler_id":"1126","over":"2","ball":"4","score":1,"commentary":"Harsh Thaker to Romeo Dunka, 1 run,","noball_dismissal":false,"text":"","timestamp":1750374129,"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":"12175749","event":"ball","batsman_id":"124264","bowler_id":"1126","over":"2","ball":"5","score":0,"commentary":"Harsh Thaker to Brian Corbin, no run,","noball_dismissal":false,"text":"","timestamp":1750374214,"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":"12175750","event":"ball","batsman_id":"124264","bowler_id":"1126","over":"2","ball":"6","score":1,"commentary":"Harsh Thaker to Brian Corbin, 1 run,","noball_dismissal":false,"text":"","timestamp":1750374216,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":3,"runs":9,"score":"30\/2","bats":[{"runs":2,"balls_faced":4,"fours":0,"sixes":0,"batsman_id":124264},{"runs":11,"balls_faced":5,"fours":1,"sixes":1,"batsman_id":132664}],"bowls":[{"runs_conceded":9,"maidens":0,"wickets":0,"bowler_id":1126,"overs":1},{"runs_conceded":18,"maidens":0,"wickets":1,"bowler_id":96319,"overs":1}],"commentary":"End of over 3 (9 runs), Cayman Islands 30\/2"},{"event_id":"12175751","event":"ball","batsman_id":"124264","bowler_id":"147987","over":"3","ball":"1","score":4,"commentary":"Shivam Sharma to Brian Corbin, Four,","noball_dismissal":false,"text":"","timestamp":1750374271,"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":"12175752","event":"wicket","batsman_id":"124264","bowler_id":"147987","over":"3","ball":"2","score":"w","commentary":"Shivam Sharma to Brian Corbin, no run, b S Sharma,","noball_dismissal":false,"text":"","timestamp":1750374297,"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":"124264","how_out":"b S Sharma","batsman_runs":"6","batsman_balls":"6"},{"event_id":"12175753","event":"ball","batsman_id":"145432","bowler_id":"147987","over":"3","ball":"3","score":0,"commentary":"Shivam Sharma to Samuel Foster, no run,","noball_dismissal":false,"text":"","timestamp":1750374349,"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":"12175754","event":"ball","batsman_id":"145432","bowler_id":"147987","over":"3","ball":"4","score":1,"commentary":"Shivam Sharma to Samuel Foster, 1 run,","noball_dismissal":false,"text":"","timestamp":1750374371,"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":"12175755","event":"ball","batsman_id":"132664","bowler_id":"147987","over":"3","ball":"5","score":0,"commentary":"Shivam Sharma to Romeo Dunka, no run,","noball_dismissal":false,"text":"","timestamp":1750374415,"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":"12175757","event":"wicket","batsman_id":"132664","bowler_id":"147987","over":"3","ball":"6","score":"w","commentary":"Shivam Sharma to Romeo Dunka, no run, b S Sharma,","noball_dismissal":false,"text":"","timestamp":1750374417,"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":"132664","how_out":"b S Sharma","batsman_runs":"11","batsman_balls":"7"},{"event":"overend","over":4,"runs":5,"score":"35\/4","bats":[{"runs":11,"balls_faced":7,"fours":1,"sixes":1,"batsman_id":132664},{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":145432}],"bowls":[{"runs_conceded":5,"maidens":0,"wickets":2,"bowler_id":147987,"overs":1},{"runs_conceded":9,"maidens":0,"wickets":0,"bowler_id":1126,"overs":1}],"commentary":"End of over 4 (5 runs), Cayman Islands 35\/4"},{"event_id":"12175758","event":"ball","batsman_id":"145432","bowler_id":"96319","over":"4","ball":"1","score":1,"commentary":"Saad Zafar to Samuel Foster, 1 run,","noball_dismissal":false,"text":"","timestamp":1750374500,"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":"12175759","event":"ball","batsman_id":"132667","bowler_id":"96319","over":"4","ball":"2","score":0,"commentary":"Saad Zafar to Akshay Naidoo, no run,","noball_dismissal":false,"text":"","timestamp":1750374502,"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":"12175760","event":"ball","batsman_id":"132667","bowler_id":"96319","over":"4","ball":"3","score":1,"commentary":"Saad Zafar to Akshay Naidoo, 1 run,","noball_dismissal":false,"text":"","timestamp":1750374505,"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":"12175762","event":"ball","batsman_id":"145432","bowler_id":"96319","over":"4","ball":"4","score":1,"commentary":"Saad Zafar to Samuel Foster, 1 run,","noball_dismissal":false,"text":"","timestamp":1750374515,"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":"12175763","event":"wicket","batsman_id":"132667","bowler_id":"96319","over":"4","ball":"5","score":"w","commentary":"Saad Zafar to Akshay Naidoo, 1 run, runout (K Tathgur \/ S Sharma),","noball_dismissal":false,"text":"","timestamp":1750376205,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"132667","how_out":"runout (K Tathgur \/ S Sharma)","batsman_runs":"2","batsman_balls":"3"},{"event_id":"12175764","event":"ball","batsman_id":"145431","bowler_id":"96319","over":"4","ball":"6","score":0,"commentary":"Saad Zafar to Rickel Walker, no run,","noball_dismissal":false,"text":"","timestamp":1750374980,"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":5,"runs":4,"score":"39\/5","bats":[{"runs":0,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":145431},{"runs":3,"balls_faced":4,"fours":0,"sixes":0,"batsman_id":145432}],"bowls":[{"runs_conceded":22,"maidens":0,"wickets":1,"bowler_id":96319,"overs":2},{"runs_conceded":5,"maidens":0,"wickets":2,"bowler_id":147987,"overs":1}],"commentary":"End of over 5 (4 runs), Cayman Islands 39\/5"}],"day":"0","session":"0","live_inning":{"iid":198402,"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":"39\/5","scores_full":"39\/5 (5 ov)","fielder":[{"fielder_id":"90992","fielder_name":"Jaskaran Singh","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"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":"147987","fielder_name":"Shivam Sharma","catches":0,"runout_thrower":1,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"96416","fielder_name":"Kanwarpal Tathgur","catches":0,"runout_thrower":0,"runout_catcher":1,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":[],"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":"Akshay Naidoo","batsman_id":"132667","runs":"2","balls":"3","how_out":"runout (K Tathgur \/ S Sharma)","score_at_dismissal":39,"overs_at_dismissal":"4.5","bowler_id":"0","dismissal":"runout","number":5},"extra_runs":{"byes":0,"legbyes":0,"wides":2,"noballs":0,"penalty":"0","total":2},"equations":{"runs":39,"wickets":5,"overs":"5","bowlers_used":4,"runrate":"7.80"},"current_partnership":{"runs":0,"balls":1,"overs":0.1,"batsmen":[{"name":"Rickel Walker","batsman_id":145431,"runs":0,"balls":1},{"name":"Samuel Foster","batsman_id":145432,"runs":0,"balls":0}]},"did_not_bat":[{"player_id":"52476","name":"Conroy Wright"},{"player_id":"52480","name":"Adrian Wright"},{"player_id":"132666","name":"Kevon Bazil"},{"player_id":"52482","name":"Alessandro Morris"}],"max_over":"5","target":"82","recent_scores":"0,w,1,1,0,1,w,0,1,0,w,4,1,0,1,0,6,1","last_five_overs":"39\/5 7.31","last_ten_overs":"39\/5 7.31"},"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":"81\/0 (5 ov)","scores":"81\/0","overs":"5"},{"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":"39\/5 (5 ov)","scores":"39\/5","overs":"5"}],"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":"(WK)"},{"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":"squad","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":"squad","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":"squad","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":"bowl","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":"squad","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":"bat","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":"all","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":""},{"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":"bat","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":""},{"pid":149988,"title":"Anubhav Dhar","short_name":"Anubhav Dhar","first_name":"Anubhav Dhar","last_name":"","middle_name":"","birthdate":"1988-10-29","birthplace":"","country":"","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left 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":null,"role":"squad","role_str":""},{"pid":149989,"title":"Sunil","short_name":"Sunil","first_name":"Sunil","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Cayman Islands","role":"squad","role_str":""}]},"etag":"07c7733c9d07887f1738ed04ae86c593","modified":"2025-07-17 04:58:36","datetime":"2025-07-17 04:58:36","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90755 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:10a0b3d9-a3ee-4dc9-890a-9cc34ff7b764
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90755 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90755,3,'{"status":"ok","response":{"match_id":90755,"title":"Cayman Islands vs Canada ","short_title":"CAY vs CAN","subtitle":"Match 8","match_number":"8","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Canada won by 42 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":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":"39\/5 (5 ov)","scores":"39\/5","overs":"5"},"teamb":{"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":"81\/0 (5 ov)","scores":"81\/0","overs":"5"},"date_start":"2025-06-19 19:30:00","date_end":"2025-06-20 05:30:00","timestamp_start":1750361400,"timestamp_end":1750397400,"date_start_ist":"2025-06-20 01:00:00","date_end_ist":"2025-06-20 11:00:00","venue":{"venue_id":"294","name":"Maple Leaf North-West Ground (A)","location":"King City","country":"Canada","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"CAN won by 42 runs","result_type":2,"win_margin":"42 runs","winning_team_id":6791,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-17 01:37:40","verify_time":"2025-06-20 05:09:41","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":18.5,"humidity":82,"visibility":10000,"wind_speed":"26.44","clouds":93},"pitch":{"pitch_condition":"Spinning Pitch","batting_condition":"Low Scoring","pace_bowling_condition":"Swing Favourable","spine_bowling_condition":"Average"},"toss":{"text":"Cayman Islands elected to bowl","winner":19688,"decision":2}},"etag":"07c7733c9d07887f1738ed04ae86c593","modified":"2025-07-17 04:58:36","datetime":"2025-07-17 04:58:36","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90755,"title":"Cayman Islands vs Canada ","short_title":"CAY vs CAN","subtitle":"Match 8","match_number":"8","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Canada won by 42 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":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":"39\/5 (5 ov)","scores":"39\/5","overs":"5"},"teamb":{"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":"81\/0 (5 ov)","scores":"81\/0","overs":"5"},"date_start":"2025-06-19 19:30:00","date_end":"2025-06-20 05:30:00","timestamp_start":1750361400,"timestamp_end":1750397400,"date_start_ist":"2025-06-20 01:00:00","date_end_ist":"2025-06-20 11:00:00","venue":{"venue_id":"294","name":"Maple Leaf North-West Ground (A)","location":"King City","country":"Canada","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"CAN won by 42 runs","result_type":2,"win_margin":"42 runs","winning_team_id":6791,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-17 01:37:40","verify_time":"2025-06-20 05:09:41","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":18.5,"humidity":82,"visibility":10000,"wind_speed":"26.44","clouds":93},"pitch":{"pitch_condition":"Spinning Pitch","batting_condition":"Low Scoring","pace_bowling_condition":"Swing Favourable","spine_bowling_condition":"Average"},"toss":{"text":"Cayman Islands elected to bowl","winner":19688,"decision":2}},"etag":"07c7733c9d07887f1738ed04ae86c593","modified":"2025-07-17 04:58:36","datetime":"2025-07-17 04:58:36","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90755 AND DataTypeId = 3 END Live Report & Scorecard of Cayman Islands vs Canada Match 8
Cayman Islands vs Canada , Live Cricket Commentary