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:ccbda265-b51a-435b-b410-d5bef9520805
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90967 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90967,1,'{"status":"ok","response":{"mid":90967,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Amazonian Warriors won by 6 wickets","day_remaining_over":"","team_batting":"Amazonian Warriors","team_bowling":"Piton Stickers","live_inning_number":2,"live_score":{"runs":117,"overs":8.4,"wickets":4,"target":114,"runrate":13.5,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Antoine Zayee","batsman_id":99779,"runs":4,"balls_faced":1,"fours":1,"sixes":0,"strike_rate":"400.00"},{"name":"Joshua Cepal","batsman_id":116473,"runs":29,"balls_faced":15,"fours":2,"sixes":3,"strike_rate":"193.33"}],"bowlers":[{"name":"Keon Gaston","bowler_id":99762,"overs":1.4,"runs_conceded":18,"wickets":1,"maidens":0,"econ":"10.80"},{"name":"Shani Mesmain","bowler_id":99738,"overs":2,"runs_conceded":30,"wickets":1,"maidens":0,"econ":"15.00"}],"commentaries":[{"event_id":"12278112","event":"ball","batsman_id":"116473","bowler_id":"150060","over":"4","ball":"3","score":0,"commentary":"Yunieski Gustave to Joshua Cepal, no run,","noball_dismissal":false,"text":"","timestamp":1751572775,"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":"12278116","event":"ball","batsman_id":"116473","bowler_id":"150060","over":"4","ball":"4","score":6,"commentary":"Yunieski Gustave to Joshua Cepal, Six,","noball_dismissal":false,"text":"","timestamp":1751572862,"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":"12278117","event":"ball","batsman_id":"116473","bowler_id":"150060","over":"4","ball":"5","score":0,"commentary":"Yunieski Gustave to Joshua Cepal, no run,","noball_dismissal":false,"text":"","timestamp":1751572867,"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":"12278118","event":"ball","batsman_id":"116473","bowler_id":"150060","over":"4","ball":"6","score":0,"commentary":"Yunieski Gustave to Joshua Cepal, no run,","noball_dismissal":false,"text":"","timestamp":1751572877,"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":6,"score":"61\/3","bats":[{"runs":7,"balls_faced":7,"fours":0,"sixes":1,"batsman_id":116473},{"runs":16,"balls_faced":6,"fours":2,"sixes":1,"batsman_id":99805}],"bowls":[{"runs_conceded":6,"maidens":0,"wickets":0,"bowler_id":150060,"overs":1},{"runs_conceded":13,"maidens":0,"wickets":1,"bowler_id":99744,"overs":1}],"commentary":"End of over 5 (6 runs), Amazonian Warriors 61\/3"},{"event_id":"12278120","event":"ball","batsman_id":"99805","bowler_id":"107676","over":"5","ball":"1","score":1,"commentary":"Kuston Jules to Dane Edward, 1 run,","noball_dismissal":false,"text":"","timestamp":1751572990,"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":"12278121","event":"ball","batsman_id":"116473","bowler_id":"107676","over":"5","ball":"2","score":4,"commentary":"Kuston Jules to Joshua Cepal, Four,","noball_dismissal":false,"text":"","timestamp":1751572993,"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":"12278124","event":"ball","batsman_id":"116473","bowler_id":"107676","over":"5","ball":"3","score":4,"commentary":"Kuston Jules to Joshua Cepal, Four,","noball_dismissal":false,"text":"","timestamp":1751573037,"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":"12278125","event":"ball","batsman_id":"116473","bowler_id":"107676","over":"5","ball":"4","score":0,"commentary":"Kuston Jules to Joshua Cepal, no run,","noball_dismissal":false,"text":"","timestamp":1751573076,"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":"12278127","event":"ball","batsman_id":"116473","bowler_id":"107676","over":"5","ball":"5","score":1,"commentary":"Kuston Jules to Joshua Cepal, 1 run,","noball_dismissal":false,"text":"","timestamp":1751573116,"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":"12278128","event":"ball","batsman_id":"99805","bowler_id":"107676","over":"5","ball":"6","score":1,"commentary":"Kuston Jules to Dane Edward, 1 run,","noball_dismissal":false,"text":"","timestamp":1751573153,"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":6,"runs":11,"score":"72\/3","bats":[{"runs":18,"balls_faced":8,"fours":2,"sixes":1,"batsman_id":99805},{"runs":16,"balls_faced":11,"fours":2,"sixes":1,"batsman_id":116473}],"bowls":[{"runs_conceded":28,"maidens":0,"wickets":1,"bowler_id":107676,"overs":2},{"runs_conceded":6,"maidens":0,"wickets":0,"bowler_id":150060,"overs":1}],"commentary":"End of over 6 (11 runs), Amazonian Warriors 72\/3"},{"event_id":"12278129","event":"ball","batsman_id":"99805","bowler_id":"99736","over":"6","ball":"1","score":6,"commentary":"Xytus Emmanuel to Dane Edward, Six,","noball_dismissal":false,"text":"","timestamp":1751573236,"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":"12278131","event":"ball","batsman_id":"99805","bowler_id":"99736","over":"6","ball":"2","score":4,"commentary":"Xytus Emmanuel to Dane Edward, Four,","noball_dismissal":false,"text":"","timestamp":1751573308,"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":"12278133","event":"ball","batsman_id":"99805","bowler_id":"99736","over":"6","ball":"3","score":4,"commentary":"Xytus Emmanuel to Dane Edward, Four,","noball_dismissal":false,"text":"","timestamp":1751573316,"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":"12278134","event":"ball","batsman_id":"99805","bowler_id":"99736","over":"6","ball":"4","score":1,"commentary":"Xytus Emmanuel to Dane Edward, 1 run,","noball_dismissal":false,"text":"","timestamp":1751573360,"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":"12278137","event":"ball","batsman_id":"116473","bowler_id":"99736","over":"6","ball":"5","score":0,"commentary":"Xytus Emmanuel to Joshua Cepal, no run,","noball_dismissal":false,"text":"","timestamp":1751573428,"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":"12278138","event":"ball","batsman_id":"116473","bowler_id":"99736","over":"6","ball":"6","score":"1wd","commentary":"Xytus Emmanuel to Joshua Cepal, 1 wide,","noball_dismissal":false,"text":"","timestamp":1751573431,"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":"12278139","event":"ball","batsman_id":"116473","bowler_id":"99736","over":"6","ball":"6","score":6,"commentary":"Xytus Emmanuel to Joshua Cepal, Six,","noball_dismissal":false,"text":"","timestamp":1751573434,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event":"overend","over":7,"runs":22,"score":"94\/3","bats":[{"runs":22,"balls_faced":13,"fours":2,"sixes":2,"batsman_id":116473},{"runs":33,"balls_faced":12,"fours":4,"sixes":2,"batsman_id":99805}],"bowls":[{"runs_conceded":22,"maidens":0,"wickets":0,"bowler_id":99736,"overs":1},{"runs_conceded":28,"maidens":0,"wickets":1,"bowler_id":107676,"overs":2}],"commentary":"End of over 7 (22 runs), Amazonian Warriors 94\/3"},{"event_id":"12278142","event":"ball","batsman_id":"99805","bowler_id":"99738","over":"7","ball":"1","score":6,"commentary":"Shani Mesmain to Dane Edward, Six,","noball_dismissal":false,"text":"","timestamp":1751573517,"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":"12278145","event":"ball","batsman_id":"99805","bowler_id":"99738","over":"7","ball":"2","score":4,"commentary":"Shani Mesmain to Dane Edward, Four,","noball_dismissal":false,"text":"","timestamp":1751573620,"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":"12278147","event":"ball","batsman_id":"99805","bowler_id":"99738","over":"7","ball":"3","score":1,"commentary":"Shani Mesmain to Dane Edward, 1 run,","noball_dismissal":false,"text":"","timestamp":1751573669,"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":"12278148","event":"ball","batsman_id":"116473","bowler_id":"99738","over":"7","ball":"4","score":1,"commentary":"Shani Mesmain to Joshua Cepal, 1 run,","noball_dismissal":false,"text":"","timestamp":1751573690,"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":"12278150","event":"ball","batsman_id":"99805","bowler_id":"99738","over":"7","ball":"5","score":1,"commentary":"Shani Mesmain to Dane Edward, 1 run,","noball_dismissal":false,"text":"","timestamp":1751573733,"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":"12278152","event":"ball","batsman_id":"116473","bowler_id":"99738","over":"7","ball":"6","score":6,"commentary":"Shani Mesmain to Joshua Cepal, Six,","noball_dismissal":false,"text":"","timestamp":1751573758,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event":"overend","over":8,"runs":19,"score":"113\/3","bats":[{"runs":29,"balls_faced":15,"fours":2,"sixes":3,"batsman_id":116473},{"runs":45,"balls_faced":16,"fours":5,"sixes":3,"batsman_id":99805}],"bowls":[{"runs_conceded":30,"maidens":0,"wickets":1,"bowler_id":99738,"overs":2},{"runs_conceded":22,"maidens":0,"wickets":0,"bowler_id":99736,"overs":1}],"commentary":"End of over 8 (19 runs), Amazonian Warriors 113\/3"},{"event_id":"12278155","event":"ball","batsman_id":"99805","bowler_id":"99762","over":"8","ball":"1","score":0,"commentary":"Keon Gaston to Dane Edward, no run,","noball_dismissal":false,"text":"","timestamp":1751573857,"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":"12278156","event":"ball","batsman_id":"99805","bowler_id":"99762","over":"8","ball":"2","score":0,"commentary":"Keon Gaston to Dane Edward, no run,","noball_dismissal":false,"text":"","timestamp":1751573890,"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":"12278158","event":"wicket","batsman_id":"99805","bowler_id":"99762","over":"8","ball":"3","score":"w","commentary":"Keon Gaston to Dane Edward, no run, b K Gaston,","noball_dismissal":false,"text":"","timestamp":1751573945,"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":"99805","how_out":"b K Gaston","batsman_runs":"45","batsman_balls":"19"},{"event_id":"12278160","event":"ball","batsman_id":"99779","bowler_id":"99762","over":"8","ball":"4","score":4,"commentary":"Keon Gaston to Antoine Zayee, Four,","noball_dismissal":false,"text":"","timestamp":1751574045,"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}],"day":"0","session":"0","live_inning":{"iid":199069,"number":2,"name":"Amazonian Warriors Inning","short_name":"AMW Inning","status":2,"issuperover":"false","result":3,"batting_team_id":129002,"fielding_team_id":129003,"scores":"117\/4","scores_full":"117\/4 (8.4 ov)","fielder":[{"fielder_id":"99721","fielder_name":"Jason Simon","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"99738","fielder_name":"Shani Mesmain","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"3"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Dane Edward","batsman_id":"99805","runs":"45","balls":"19","how_out":"b K Gaston","score_at_dismissal":113,"overs_at_dismissal":"8.3","bowler_id":"99762","dismissal":"bowled","number":4},"extra_runs":{"byes":0,"legbyes":0,"wides":3,"noballs":0,"penalty":"0","total":3},"equations":{"runs":117,"wickets":4,"overs":"8.4","bowlers_used":6,"runrate":"13.50"},"current_partnership":{"runs":4,"balls":1,"overs":0.1,"batsmen":[{"name":"Antoine Zayee","batsman_id":99779,"runs":4,"balls":1},{"name":"Joshua Cepal","batsman_id":116473,"runs":0,"balls":0}]},"did_not_bat":[{"player_id":"107768","name":"Rohan Lesmond"},{"player_id":"138276","name":"Tyler Venner"},{"player_id":"92688","name":"Alleyn Prospere"},{"player_id":"138273","name":"Renee Jones"},{"player_id":"116100","name":"Dexter Solomon"}],"max_over":"10","target":"114","recent_scores":"4,w,0,0,6,1,1,1,4,6,6,1,0,1,4,4,6,1","last_five_overs":"69\/1 13.35","last_ten_overs":"117\/4 12.76"},"teams":[{"tid":129002,"title":"Amazonian Warriors","abbr":"AMW","alt_name":"Amazonian Warriors","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Amazonian-Warriors.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Amazonian-Warriors.png","country":"wi","sex":"male","team_owner":"","head_coach":"","scores_full":"117\/4 (8.4 ov)","scores":"117\/4","overs":"8.4"},{"tid":129003,"title":"Piton Stickers","abbr":"PTS","alt_name":"Piton Stickers","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Piton-Stickers.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Piton-Stickers.png","country":"wi","sex":"male","team_owner":"","head_coach":"","scores_full":"113\/7 (10 ov)","scores":"113\/7","overs":"10"}],"players":[{"pid":52283,"title":"Johnnel Eugene","short_name":"J Eugene","first_name":"Johnnel Eugene","last_name":"","middle_name":"","birthdate":"1999-09-15","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":53757,"title":"Craig Emmanuel","short_name":"CW Emmanuel","first_name":"Craig Emmanuel","last_name":"","middle_name":"","birthdate":"1985-09-09","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":92688,"title":"Alleyn Prospere","short_name":"A Prospere","first_name":"Alleyn Prospere","last_name":"","middle_name":"","birthdate":"1979-10-10","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":99721,"title":"Jason Simon","short_name":"J Simon","first_name":"Jason Simon","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(WK)"},{"pid":99723,"title":"Vince Smith","short_name":"V Smith","first_name":"Vince Smith","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":99733,"title":"Sky Laffeuille","short_name":"S Laffeuille","first_name":"Sky Laffeuille","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":99734,"title":"Julian Sylvester","short_name":"J Sylvester","first_name":"Julian Sylvester","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":""},{"pid":99736,"title":"Xytus Emmanuel","short_name":"X Emmanuel","first_name":"Xytus Emmanuel","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":99738,"title":"Shani Mesmain","short_name":"S Mesmain","first_name":"Shani Mesmain","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":99744,"title":"Sanjay Pamphile","short_name":"S Pamphile","first_name":"Sanjay Pamphile","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":99762,"title":"Keon Gaston","short_name":"K Gaston","first_name":"Keon Gaston","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":"(C)"},{"pid":99779,"title":"Antoine Zayee","short_name":"A Zayee","first_name":"Antoine Zayee","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":99788,"title":"Ackeem Auguste","short_name":"A Auguste","first_name":"Ackeem Auguste","last_name":"","middle_name":"","birthdate":"2003-09-12","birthplace":"","country":"wi","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":99795,"title":"Jaden Elibox","short_name":"J Elibox","first_name":"Jaden Elibox","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":99805,"title":"Dane Edward","short_name":"D Edward","first_name":"Dane Edward","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":100050,"title":"Kester Charlermagne","short_name":"K Charlermagne","first_name":"Kester Charlermagne","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":"(C)"},{"pid":100065,"title":"Murlan Sammy","short_name":"M Sammy","first_name":"Murlan Sammy","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":107672,"title":"Tarrique Edward","short_name":"T Edward","first_name":"Tarrique Edward","last_name":"","middle_name":"","birthdate":"2004-10-17","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":107676,"title":"Kuston Jules","short_name":"K Jules","first_name":"Kuston Jules","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":107750,"title":"Royce Paul","short_name":"R Paul","first_name":"Royce Paul","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":107766,"title":"Christian Charlery","short_name":"C Charlery","first_name":"Christian Charlery","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":107768,"title":"Rohan Lesmond","short_name":"R Lesmond","first_name":"Rohan Lesmond","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":116100,"title":"Dexter Solomon","short_name":"D Solomon","first_name":"Dexter Solomon","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":116473,"title":"Joshua Cepal","short_name":"J Cepal","first_name":"Joshua Cepal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":126997,"title":"Cody Fontinelle","short_name":"C Fontinelle","first_name":"Cody Fontinelle","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":127130,"title":"Alex Joseph","short_name":"A Joseph","first_name":"Alex Joseph","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(WK)"},{"pid":128590,"title":"Jermaine thomas","short_name":"J thomas","first_name":"Jermaine thomas","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":138228,"title":"Isiah Jones","short_name":"I Jones","first_name":"Isiah Jones","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":138273,"title":"Renee Jones","short_name":"R Jones","first_name":"Renee Jones","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":138276,"title":"Tyler Venner","short_name":"T Venner","first_name":"Tyler Venner","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":150059,"title":"Jeanille Williams","short_name":"JN Williams","first_name":"Jeanille Williams","last_name":"","middle_name":"","birthdate":"2009-10-04","birthplace":"","country":"wi","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":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":150060,"title":"Yunieski Gustave","short_name":"YK Gustave","first_name":"Yunieski Gustave","last_name":"","middle_name":"","birthdate":"2006-09-20","birthplace":"","country":"wi","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":150249,"title":"Nathaniel Joseph","short_name":"N Joseph","first_name":"Nathaniel Joseph","last_name":"","middle_name":"","birthdate":"2009-01-31","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":150296,"title":"Liam Joseph","short_name":"L Joseph","first_name":"Liam Joseph","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""}]},"etag":"472252d94e47ca738280df14bd7bd0e0","modified":"2025-07-10 08:40:01","datetime":"2025-07-10 08:40:01","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":90967,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Amazonian Warriors won by 6 wickets","day_remaining_over":"","team_batting":"Amazonian Warriors","team_bowling":"Piton Stickers","live_inning_number":2,"live_score":{"runs":117,"overs":8.4,"wickets":4,"target":114,"runrate":13.5,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Antoine Zayee","batsman_id":99779,"runs":4,"balls_faced":1,"fours":1,"sixes":0,"strike_rate":"400.00"},{"name":"Joshua Cepal","batsman_id":116473,"runs":29,"balls_faced":15,"fours":2,"sixes":3,"strike_rate":"193.33"}],"bowlers":[{"name":"Keon Gaston","bowler_id":99762,"overs":1.4,"runs_conceded":18,"wickets":1,"maidens":0,"econ":"10.80"},{"name":"Shani Mesmain","bowler_id":99738,"overs":2,"runs_conceded":30,"wickets":1,"maidens":0,"econ":"15.00"}],"commentaries":[{"event_id":"12278112","event":"ball","batsman_id":"116473","bowler_id":"150060","over":"4","ball":"3","score":0,"commentary":"Yunieski Gustave to Joshua Cepal, no run,","noball_dismissal":false,"text":"","timestamp":1751572775,"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":"12278116","event":"ball","batsman_id":"116473","bowler_id":"150060","over":"4","ball":"4","score":6,"commentary":"Yunieski Gustave to Joshua Cepal, Six,","noball_dismissal":false,"text":"","timestamp":1751572862,"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":"12278117","event":"ball","batsman_id":"116473","bowler_id":"150060","over":"4","ball":"5","score":0,"commentary":"Yunieski Gustave to Joshua Cepal, no run,","noball_dismissal":false,"text":"","timestamp":1751572867,"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":"12278118","event":"ball","batsman_id":"116473","bowler_id":"150060","over":"4","ball":"6","score":0,"commentary":"Yunieski Gustave to Joshua Cepal, no run,","noball_dismissal":false,"text":"","timestamp":1751572877,"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":6,"score":"61\/3","bats":[{"runs":7,"balls_faced":7,"fours":0,"sixes":1,"batsman_id":116473},{"runs":16,"balls_faced":6,"fours":2,"sixes":1,"batsman_id":99805}],"bowls":[{"runs_conceded":6,"maidens":0,"wickets":0,"bowler_id":150060,"overs":1},{"runs_conceded":13,"maidens":0,"wickets":1,"bowler_id":99744,"overs":1}],"commentary":"End of over 5 (6 runs), Amazonian Warriors 61\/3"},{"event_id":"12278120","event":"ball","batsman_id":"99805","bowler_id":"107676","over":"5","ball":"1","score":1,"commentary":"Kuston Jules to Dane Edward, 1 run,","noball_dismissal":false,"text":"","timestamp":1751572990,"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":"12278121","event":"ball","batsman_id":"116473","bowler_id":"107676","over":"5","ball":"2","score":4,"commentary":"Kuston Jules to Joshua Cepal, Four,","noball_dismissal":false,"text":"","timestamp":1751572993,"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":"12278124","event":"ball","batsman_id":"116473","bowler_id":"107676","over":"5","ball":"3","score":4,"commentary":"Kuston Jules to Joshua Cepal, Four,","noball_dismissal":false,"text":"","timestamp":1751573037,"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":"12278125","event":"ball","batsman_id":"116473","bowler_id":"107676","over":"5","ball":"4","score":0,"commentary":"Kuston Jules to Joshua Cepal, no run,","noball_dismissal":false,"text":"","timestamp":1751573076,"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":"12278127","event":"ball","batsman_id":"116473","bowler_id":"107676","over":"5","ball":"5","score":1,"commentary":"Kuston Jules to Joshua Cepal, 1 run,","noball_dismissal":false,"text":"","timestamp":1751573116,"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":"12278128","event":"ball","batsman_id":"99805","bowler_id":"107676","over":"5","ball":"6","score":1,"commentary":"Kuston Jules to Dane Edward, 1 run,","noball_dismissal":false,"text":"","timestamp":1751573153,"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":6,"runs":11,"score":"72\/3","bats":[{"runs":18,"balls_faced":8,"fours":2,"sixes":1,"batsman_id":99805},{"runs":16,"balls_faced":11,"fours":2,"sixes":1,"batsman_id":116473}],"bowls":[{"runs_conceded":28,"maidens":0,"wickets":1,"bowler_id":107676,"overs":2},{"runs_conceded":6,"maidens":0,"wickets":0,"bowler_id":150060,"overs":1}],"commentary":"End of over 6 (11 runs), Amazonian Warriors 72\/3"},{"event_id":"12278129","event":"ball","batsman_id":"99805","bowler_id":"99736","over":"6","ball":"1","score":6,"commentary":"Xytus Emmanuel to Dane Edward, Six,","noball_dismissal":false,"text":"","timestamp":1751573236,"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":"12278131","event":"ball","batsman_id":"99805","bowler_id":"99736","over":"6","ball":"2","score":4,"commentary":"Xytus Emmanuel to Dane Edward, Four,","noball_dismissal":false,"text":"","timestamp":1751573308,"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":"12278133","event":"ball","batsman_id":"99805","bowler_id":"99736","over":"6","ball":"3","score":4,"commentary":"Xytus Emmanuel to Dane Edward, Four,","noball_dismissal":false,"text":"","timestamp":1751573316,"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":"12278134","event":"ball","batsman_id":"99805","bowler_id":"99736","over":"6","ball":"4","score":1,"commentary":"Xytus Emmanuel to Dane Edward, 1 run,","noball_dismissal":false,"text":"","timestamp":1751573360,"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":"12278137","event":"ball","batsman_id":"116473","bowler_id":"99736","over":"6","ball":"5","score":0,"commentary":"Xytus Emmanuel to Joshua Cepal, no run,","noball_dismissal":false,"text":"","timestamp":1751573428,"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":"12278138","event":"ball","batsman_id":"116473","bowler_id":"99736","over":"6","ball":"6","score":"1wd","commentary":"Xytus Emmanuel to Joshua Cepal, 1 wide,","noball_dismissal":false,"text":"","timestamp":1751573431,"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":"12278139","event":"ball","batsman_id":"116473","bowler_id":"99736","over":"6","ball":"6","score":6,"commentary":"Xytus Emmanuel to Joshua Cepal, Six,","noball_dismissal":false,"text":"","timestamp":1751573434,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event":"overend","over":7,"runs":22,"score":"94\/3","bats":[{"runs":22,"balls_faced":13,"fours":2,"sixes":2,"batsman_id":116473},{"runs":33,"balls_faced":12,"fours":4,"sixes":2,"batsman_id":99805}],"bowls":[{"runs_conceded":22,"maidens":0,"wickets":0,"bowler_id":99736,"overs":1},{"runs_conceded":28,"maidens":0,"wickets":1,"bowler_id":107676,"overs":2}],"commentary":"End of over 7 (22 runs), Amazonian Warriors 94\/3"},{"event_id":"12278142","event":"ball","batsman_id":"99805","bowler_id":"99738","over":"7","ball":"1","score":6,"commentary":"Shani Mesmain to Dane Edward, Six,","noball_dismissal":false,"text":"","timestamp":1751573517,"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":"12278145","event":"ball","batsman_id":"99805","bowler_id":"99738","over":"7","ball":"2","score":4,"commentary":"Shani Mesmain to Dane Edward, Four,","noball_dismissal":false,"text":"","timestamp":1751573620,"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":"12278147","event":"ball","batsman_id":"99805","bowler_id":"99738","over":"7","ball":"3","score":1,"commentary":"Shani Mesmain to Dane Edward, 1 run,","noball_dismissal":false,"text":"","timestamp":1751573669,"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":"12278148","event":"ball","batsman_id":"116473","bowler_id":"99738","over":"7","ball":"4","score":1,"commentary":"Shani Mesmain to Joshua Cepal, 1 run,","noball_dismissal":false,"text":"","timestamp":1751573690,"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":"12278150","event":"ball","batsman_id":"99805","bowler_id":"99738","over":"7","ball":"5","score":1,"commentary":"Shani Mesmain to Dane Edward, 1 run,","noball_dismissal":false,"text":"","timestamp":1751573733,"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":"12278152","event":"ball","batsman_id":"116473","bowler_id":"99738","over":"7","ball":"6","score":6,"commentary":"Shani Mesmain to Joshua Cepal, Six,","noball_dismissal":false,"text":"","timestamp":1751573758,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event":"overend","over":8,"runs":19,"score":"113\/3","bats":[{"runs":29,"balls_faced":15,"fours":2,"sixes":3,"batsman_id":116473},{"runs":45,"balls_faced":16,"fours":5,"sixes":3,"batsman_id":99805}],"bowls":[{"runs_conceded":30,"maidens":0,"wickets":1,"bowler_id":99738,"overs":2},{"runs_conceded":22,"maidens":0,"wickets":0,"bowler_id":99736,"overs":1}],"commentary":"End of over 8 (19 runs), Amazonian Warriors 113\/3"},{"event_id":"12278155","event":"ball","batsman_id":"99805","bowler_id":"99762","over":"8","ball":"1","score":0,"commentary":"Keon Gaston to Dane Edward, no run,","noball_dismissal":false,"text":"","timestamp":1751573857,"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":"12278156","event":"ball","batsman_id":"99805","bowler_id":"99762","over":"8","ball":"2","score":0,"commentary":"Keon Gaston to Dane Edward, no run,","noball_dismissal":false,"text":"","timestamp":1751573890,"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":"12278158","event":"wicket","batsman_id":"99805","bowler_id":"99762","over":"8","ball":"3","score":"w","commentary":"Keon Gaston to Dane Edward, no run, b K Gaston,","noball_dismissal":false,"text":"","timestamp":1751573945,"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":"99805","how_out":"b K Gaston","batsman_runs":"45","batsman_balls":"19"},{"event_id":"12278160","event":"ball","batsman_id":"99779","bowler_id":"99762","over":"8","ball":"4","score":4,"commentary":"Keon Gaston to Antoine Zayee, Four,","noball_dismissal":false,"text":"","timestamp":1751574045,"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}],"day":"0","session":"0","live_inning":{"iid":199069,"number":2,"name":"Amazonian Warriors Inning","short_name":"AMW Inning","status":2,"issuperover":"false","result":3,"batting_team_id":129002,"fielding_team_id":129003,"scores":"117\/4","scores_full":"117\/4 (8.4 ov)","fielder":[{"fielder_id":"99721","fielder_name":"Jason Simon","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"99738","fielder_name":"Shani Mesmain","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"3"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Dane Edward","batsman_id":"99805","runs":"45","balls":"19","how_out":"b K Gaston","score_at_dismissal":113,"overs_at_dismissal":"8.3","bowler_id":"99762","dismissal":"bowled","number":4},"extra_runs":{"byes":0,"legbyes":0,"wides":3,"noballs":0,"penalty":"0","total":3},"equations":{"runs":117,"wickets":4,"overs":"8.4","bowlers_used":6,"runrate":"13.50"},"current_partnership":{"runs":4,"balls":1,"overs":0.1,"batsmen":[{"name":"Antoine Zayee","batsman_id":99779,"runs":4,"balls":1},{"name":"Joshua Cepal","batsman_id":116473,"runs":0,"balls":0}]},"did_not_bat":[{"player_id":"107768","name":"Rohan Lesmond"},{"player_id":"138276","name":"Tyler Venner"},{"player_id":"92688","name":"Alleyn Prospere"},{"player_id":"138273","name":"Renee Jones"},{"player_id":"116100","name":"Dexter Solomon"}],"max_over":"10","target":"114","recent_scores":"4,w,0,0,6,1,1,1,4,6,6,1,0,1,4,4,6,1","last_five_overs":"69\/1 13.35","last_ten_overs":"117\/4 12.76"},"teams":[{"tid":129002,"title":"Amazonian Warriors","abbr":"AMW","alt_name":"Amazonian Warriors","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Amazonian-Warriors.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Amazonian-Warriors.png","country":"wi","sex":"male","team_owner":"","head_coach":"","scores_full":"117\/4 (8.4 ov)","scores":"117\/4","overs":"8.4"},{"tid":129003,"title":"Piton Stickers","abbr":"PTS","alt_name":"Piton Stickers","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Piton-Stickers.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Piton-Stickers.png","country":"wi","sex":"male","team_owner":"","head_coach":"","scores_full":"113\/7 (10 ov)","scores":"113\/7","overs":"10"}],"players":[{"pid":52283,"title":"Johnnel Eugene","short_name":"J Eugene","first_name":"Johnnel Eugene","last_name":"","middle_name":"","birthdate":"1999-09-15","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":53757,"title":"Craig Emmanuel","short_name":"CW Emmanuel","first_name":"Craig Emmanuel","last_name":"","middle_name":"","birthdate":"1985-09-09","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":92688,"title":"Alleyn Prospere","short_name":"A Prospere","first_name":"Alleyn Prospere","last_name":"","middle_name":"","birthdate":"1979-10-10","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":99721,"title":"Jason Simon","short_name":"J Simon","first_name":"Jason Simon","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(WK)"},{"pid":99723,"title":"Vince Smith","short_name":"V Smith","first_name":"Vince Smith","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":99733,"title":"Sky Laffeuille","short_name":"S Laffeuille","first_name":"Sky Laffeuille","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":99734,"title":"Julian Sylvester","short_name":"J Sylvester","first_name":"Julian Sylvester","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":""},{"pid":99736,"title":"Xytus Emmanuel","short_name":"X Emmanuel","first_name":"Xytus Emmanuel","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":99738,"title":"Shani Mesmain","short_name":"S Mesmain","first_name":"Shani Mesmain","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":99744,"title":"Sanjay Pamphile","short_name":"S Pamphile","first_name":"Sanjay Pamphile","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":99762,"title":"Keon Gaston","short_name":"K Gaston","first_name":"Keon Gaston","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":"(C)"},{"pid":99779,"title":"Antoine Zayee","short_name":"A Zayee","first_name":"Antoine Zayee","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","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":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":99788,"title":"Ackeem Auguste","short_name":"A Auguste","first_name":"Ackeem Auguste","last_name":"","middle_name":"","birthdate":"2003-09-12","birthplace":"","country":"wi","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":99795,"title":"Jaden Elibox","short_name":"J Elibox","first_name":"Jaden Elibox","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":99805,"title":"Dane Edward","short_name":"D Edward","first_name":"Dane Edward","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":100050,"title":"Kester Charlermagne","short_name":"K Charlermagne","first_name":"Kester Charlermagne","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":"(C)"},{"pid":100065,"title":"Murlan Sammy","short_name":"M Sammy","first_name":"Murlan Sammy","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":107672,"title":"Tarrique Edward","short_name":"T Edward","first_name":"Tarrique Edward","last_name":"","middle_name":"","birthdate":"2004-10-17","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":107676,"title":"Kuston Jules","short_name":"K Jules","first_name":"Kuston Jules","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":107750,"title":"Royce Paul","short_name":"R Paul","first_name":"Royce Paul","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":107766,"title":"Christian Charlery","short_name":"C Charlery","first_name":"Christian Charlery","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":107768,"title":"Rohan Lesmond","short_name":"R Lesmond","first_name":"Rohan Lesmond","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":116100,"title":"Dexter Solomon","short_name":"D Solomon","first_name":"Dexter Solomon","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":116473,"title":"Joshua Cepal","short_name":"J Cepal","first_name":"Joshua Cepal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":126997,"title":"Cody Fontinelle","short_name":"C Fontinelle","first_name":"Cody Fontinelle","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":127130,"title":"Alex Joseph","short_name":"A Joseph","first_name":"Alex Joseph","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(WK)"},{"pid":128590,"title":"Jermaine thomas","short_name":"J thomas","first_name":"Jermaine thomas","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":138228,"title":"Isiah Jones","short_name":"I Jones","first_name":"Isiah Jones","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":138273,"title":"Renee Jones","short_name":"R Jones","first_name":"Renee Jones","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":138276,"title":"Tyler Venner","short_name":"T Venner","first_name":"Tyler Venner","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":150059,"title":"Jeanille Williams","short_name":"JN Williams","first_name":"Jeanille Williams","last_name":"","middle_name":"","birthdate":"2009-10-04","birthplace":"","country":"wi","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":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":150060,"title":"Yunieski Gustave","short_name":"YK Gustave","first_name":"Yunieski Gustave","last_name":"","middle_name":"","birthdate":"2006-09-20","birthplace":"","country":"wi","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":150249,"title":"Nathaniel Joseph","short_name":"N Joseph","first_name":"Nathaniel Joseph","last_name":"","middle_name":"","birthdate":"2009-01-31","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":150296,"title":"Liam Joseph","short_name":"L Joseph","first_name":"Liam Joseph","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""}]},"etag":"472252d94e47ca738280df14bd7bd0e0","modified":"2025-07-10 08:40:01","datetime":"2025-07-10 08:40:01","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90967 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:ccbda265-b51a-435b-b410-d5bef9520805
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90967 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90967,3,'{"status":"ok","response":{"match_id":90967,"title":"Piton Stickers vs Amazonian Warriors","short_title":"PTS vs AMW","subtitle":"Match 20","match_number":"20","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Amazonian Warriors won by 6 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129646,"title":"St. Lucia T10 Blast","abbr":"Lucia T10","type":"tournament","category":"domestic","match_format":"t10","season":"2025","status":"live","datestart":"2025-06-24","dateend":"2025-07-08","country":"na","total_matches":"30","total_rounds":"1","total_teams":"6"},"teama":{"team_id":129003,"name":"Piton Stickers","short_name":"PTS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Piton-Stickers.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Piton-Stickers.png","scores_full":"113\/7 (10 ov)","scores":"113\/7","overs":"10"},"teamb":{"team_id":129002,"name":"Amazonian Warriors","short_name":"AMW","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Amazonian-Warriors.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Amazonian-Warriors.png","scores_full":"117\/4 (8.4 ov)","scores":"117\/4","overs":"8.4"},"date_start":"2025-07-03 18:30:00","date_end":"2025-07-04 04:30:00","timestamp_start":1751567400,"timestamp_end":1751603400,"date_start_ist":"2025-07-04 00:00:00","date_end_ist":"2025-07-04 10:00:00","venue":{"venue_id":"85","name":"Daren Sammy National Cricket Stadium, St Lucia","location":"Gros Islet","country":"West Indies","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"AMW won by 6 wickets","result_type":2,"win_margin":"6 wickets","winning_team_id":129002,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-02 01:22:45","verify_time":"2025-07-04 02:05:55","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":27.78,"humidity":79,"visibility":10000,"wind_speed":"16.22","clouds":98},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Amazonian Warriors elected to bowl","winner":129002,"decision":2}},"etag":"d8faa2efd04e54b39d262f64b6485815","modified":"2025-07-10 08:40:02","datetime":"2025-07-10 08:40:02","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90967,"title":"Piton Stickers vs Amazonian Warriors","short_title":"PTS vs AMW","subtitle":"Match 20","match_number":"20","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Amazonian Warriors won by 6 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129646,"title":"St. Lucia T10 Blast","abbr":"Lucia T10","type":"tournament","category":"domestic","match_format":"t10","season":"2025","status":"live","datestart":"2025-06-24","dateend":"2025-07-08","country":"na","total_matches":"30","total_rounds":"1","total_teams":"6"},"teama":{"team_id":129003,"name":"Piton Stickers","short_name":"PTS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Piton-Stickers.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Piton-Stickers.png","scores_full":"113\/7 (10 ov)","scores":"113\/7","overs":"10"},"teamb":{"team_id":129002,"name":"Amazonian Warriors","short_name":"AMW","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Amazonian-Warriors.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Amazonian-Warriors.png","scores_full":"117\/4 (8.4 ov)","scores":"117\/4","overs":"8.4"},"date_start":"2025-07-03 18:30:00","date_end":"2025-07-04 04:30:00","timestamp_start":1751567400,"timestamp_end":1751603400,"date_start_ist":"2025-07-04 00:00:00","date_end_ist":"2025-07-04 10:00:00","venue":{"venue_id":"85","name":"Daren Sammy National Cricket Stadium, St Lucia","location":"Gros Islet","country":"West Indies","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"AMW won by 6 wickets","result_type":2,"win_margin":"6 wickets","winning_team_id":129002,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-02 01:22:45","verify_time":"2025-07-04 02:05:55","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":27.78,"humidity":79,"visibility":10000,"wind_speed":"16.22","clouds":98},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Amazonian Warriors elected to bowl","winner":129002,"decision":2}},"etag":"d8faa2efd04e54b39d262f64b6485815","modified":"2025-07-10 08:40:02","datetime":"2025-07-10 08:40:02","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90967 AND DataTypeId = 3 END Live Report & Scorecard of Piton Stickers vs Amazonian Warriors Match 20
Piton Stickers vs Amazonian Warriors, Live Cricket Commentary