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:6b6315a6-8eb4-45f8-8024-444cfb086394
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90936 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90936,1,'{"status":"ok","response":{"mid":90936,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Piton Stickers won by 8 wickets","day_remaining_over":"","team_batting":"Piton Stickers","team_bowling":"Whiptail Smashers","live_inning_number":2,"live_score":{"runs":108,"overs":6.5,"wickets":2,"target":106,"runrate":15.8,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Jason Simon","batsman_id":99721,"runs":55,"balls_faced":18,"fours":0,"sixes":8,"strike_rate":"305.56"},{"name":"Christian Charlery","batsman_id":107766,"runs":7,"balls_faced":4,"fours":0,"sixes":1,"strike_rate":"175.00"}],"bowlers":[{"name":"Ryan Goodman","bowler_id":107705,"overs":0.5,"runs_conceded":15,"wickets":0,"maidens":0,"econ":"18.00"},{"name":"Lee John","bowler_id":116171,"overs":1,"runs_conceded":7,"wickets":2,"maidens":0,"econ":"7.00"}],"commentaries":[{"event_id":"12219629","event":"ball","batsman_id":"99734","bowler_id":"107804","over":"2","ball":"6","score":6,"commentary":"Jeandell Cyril to Julian Sylvester, Six,","noball_dismissal":false,"text":"","timestamp":1750796389,"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":3,"runs":8,"score":"38\/0","bats":[{"runs":10,"balls_faced":10,"fours":0,"sixes":1,"batsman_id":99734},{"runs":21,"balls_faced":8,"fours":0,"sixes":3,"batsman_id":99721}],"bowls":[{"runs_conceded":19,"maidens":0,"wickets":0,"bowler_id":107804,"overs":2},{"runs_conceded":15,"maidens":0,"wickets":0,"bowler_id":99811,"overs":1}],"commentary":"End of over 3 (8 runs), Piton Stickers 38\/0"},{"event_id":"12219632","event":"ball","batsman_id":"99721","bowler_id":"107775","over":"3","ball":"1","score":1,"commentary":"Shawnil Edward to Jason Simon, 1 run,","noball_dismissal":false,"text":"","timestamp":1750796465,"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":"12219633","event":"ball","batsman_id":"99734","bowler_id":"107775","over":"3","ball":"2","score":4,"commentary":"Shawnil Edward to Julian Sylvester, Four,","noball_dismissal":false,"text":"","timestamp":1750796479,"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":"12219634","event":"ball","batsman_id":"99734","bowler_id":"107775","over":"3","ball":"3","score":6,"commentary":"Shawnil Edward to Julian Sylvester, Six,","noball_dismissal":false,"text":"","timestamp":1750796481,"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":"12219635","event":"ball","batsman_id":"99734","bowler_id":"107775","over":"3","ball":"4","score":4,"commentary":"Shawnil Edward to Julian Sylvester, Four,","noball_dismissal":false,"text":"","timestamp":1750796484,"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":"12219636","event":"ball","batsman_id":"99734","bowler_id":"107775","over":"3","ball":"5","score":6,"commentary":"Shawnil Edward to Julian Sylvester, Six,","noball_dismissal":false,"text":"","timestamp":1750796486,"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":"12219638","event":"ball","batsman_id":"99734","bowler_id":"107775","over":"3","ball":"6","score":0,"commentary":"Shawnil Edward to Julian Sylvester, no run,","noball_dismissal":false,"text":"","timestamp":1750796488,"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":4,"runs":21,"score":"59\/0","bats":[{"runs":30,"balls_faced":15,"fours":2,"sixes":3,"batsman_id":99734},{"runs":22,"balls_faced":9,"fours":0,"sixes":3,"batsman_id":99721}],"bowls":[{"runs_conceded":21,"maidens":0,"wickets":0,"bowler_id":107775,"overs":1},{"runs_conceded":19,"maidens":0,"wickets":0,"bowler_id":107804,"overs":2}],"commentary":"End of over 4 (21 runs), Piton Stickers 59\/0"},{"event_id":"12219639","event":"ball","batsman_id":"99721","bowler_id":"116173","over":"4","ball":"1","score":"1wd","commentary":"Ted Jonas to Jason Simon, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750796547,"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":"12219640","event":"ball","batsman_id":"99721","bowler_id":"116173","over":"4","ball":"1","score":"1wd","commentary":"Ted Jonas to Jason Simon, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750796549,"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":"12219641","event":"ball","batsman_id":"99721","bowler_id":"116173","over":"4","ball":"1","score":6,"commentary":"Ted Jonas to Jason Simon, Six,","noball_dismissal":false,"text":"","timestamp":1750796552,"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":"12219642","event":"ball","batsman_id":"99721","bowler_id":"116173","over":"4","ball":"2","score":6,"commentary":"Ted Jonas to Jason Simon, Six,","noball_dismissal":false,"text":"","timestamp":1750796554,"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":"12219643","event":"ball","batsman_id":"99721","bowler_id":"116173","over":"4","ball":"3","score":6,"commentary":"Ted Jonas to Jason Simon, Six,","noball_dismissal":false,"text":"","timestamp":1750796556,"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":"12219644","event":"ball","batsman_id":"99721","bowler_id":"116173","over":"4","ball":"4","score":1,"commentary":"Ted Jonas to Jason Simon, 1 run,","noball_dismissal":false,"text":"","timestamp":1750796559,"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":"12219645","event":"ball","batsman_id":"99734","bowler_id":"116173","over":"4","ball":"5","score":0,"commentary":"Ted Jonas to Julian Sylvester, no run,","noball_dismissal":false,"text":"","timestamp":1750796562,"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":"12219647","event":"ball","batsman_id":"99734","bowler_id":"116173","over":"4","ball":"6","score":6,"commentary":"Ted Jonas to Julian Sylvester, Six,","noball_dismissal":false,"text":"","timestamp":1750796565,"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":5,"runs":27,"score":"86\/0","bats":[{"runs":36,"balls_faced":17,"fours":2,"sixes":4,"batsman_id":99734},{"runs":41,"balls_faced":13,"fours":0,"sixes":6,"batsman_id":99721}],"bowls":[{"runs_conceded":27,"maidens":0,"wickets":0,"bowler_id":116173,"overs":1},{"runs_conceded":21,"maidens":0,"wickets":0,"bowler_id":107775,"overs":1}],"commentary":"End of over 5 (27 runs), Piton Stickers 86\/0"},{"event_id":"12219648","event":"ball","batsman_id":"99721","bowler_id":"116171","over":"5","ball":"1","score":1,"commentary":"Lee John to Jason Simon, 1 run,","noball_dismissal":false,"text":"","timestamp":1750796587,"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":"12219649","event":"wicket","batsman_id":"99734","bowler_id":"116171","over":"5","ball":"2","score":"w","commentary":"Lee John to Julian Sylvester, no run, c & b L John,","noball_dismissal":false,"text":"","timestamp":1750796593,"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":"99734","how_out":"c & b L John","batsman_runs":"36","batsman_balls":"18"},{"event_id":"12219650","event":"wicket","batsman_id":"99736","bowler_id":"116171","over":"5","ball":"3","score":"w","commentary":"Lee John to Xytus Emmanuel, no run, b L John,","noball_dismissal":false,"text":"","timestamp":1750796613,"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":"99736","how_out":"b L John","batsman_runs":"0","batsman_balls":"1"},{"event_id":"12219651","event":"ball","batsman_id":"107766","bowler_id":"116171","over":"5","ball":"4","score":0,"commentary":"Lee John to Christian Charlery, no run,","noball_dismissal":false,"text":"","timestamp":1750796632,"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":"12219653","event":"ball","batsman_id":"107766","bowler_id":"116171","over":"5","ball":"5","score":0,"commentary":"Lee John to Christian Charlery, no run,","noball_dismissal":false,"text":"","timestamp":1750796635,"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":"12219654","event":"ball","batsman_id":"107766","bowler_id":"116171","over":"5","ball":"6","score":6,"commentary":"Lee John to Christian Charlery, Six,","noball_dismissal":false,"text":"","timestamp":1750796638,"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":6,"runs":7,"score":"93\/2","bats":[{"runs":6,"balls_faced":3,"fours":0,"sixes":1,"batsman_id":107766},{"runs":42,"balls_faced":14,"fours":0,"sixes":6,"batsman_id":99721}],"bowls":[{"runs_conceded":7,"maidens":0,"wickets":2,"bowler_id":116171,"overs":1},{"runs_conceded":27,"maidens":0,"wickets":0,"bowler_id":116173,"overs":1}],"commentary":"End of over 6 (7 runs), Piton Stickers 93\/2"},{"event_id":"12219656","event":"ball","batsman_id":"99721","bowler_id":"107705","over":"6","ball":"1","score":"1wd","commentary":"Ryan Goodman to Jason Simon, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750796672,"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":"12219657","event":"ball","batsman_id":"99721","bowler_id":"107705","over":"6","ball":"1","score":1,"commentary":"Ryan Goodman to Jason Simon, 1 run,","noball_dismissal":false,"text":"","timestamp":1750796698,"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":"12219658","event":"ball","batsman_id":"107766","bowler_id":"107705","over":"6","ball":"2","score":1,"commentary":"Ryan Goodman to Christian Charlery, 1 run,","noball_dismissal":false,"text":"","timestamp":1750796707,"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":"12219661","event":"ball","batsman_id":"99721","bowler_id":"107705","over":"6","ball":"3","score":0,"commentary":"Ryan Goodman to Jason Simon, no run,","noball_dismissal":false,"text":"","timestamp":1750796719,"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":"12219662","event":"ball","batsman_id":"99721","bowler_id":"107705","over":"6","ball":"4","score":6,"commentary":"Ryan Goodman to Jason Simon, Six,","noball_dismissal":false,"text":"","timestamp":1750796736,"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":"12219663","event":"ball","batsman_id":"99721","bowler_id":"107705","over":"6","ball":"5","score":6,"commentary":"Ryan Goodman to Jason Simon, Six,","noball_dismissal":false,"text":"","timestamp":1750796748,"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}],"day":"0","session":"0","live_inning":{"iid":198692,"number":2,"name":"Piton Stickers Inning","short_name":"PTS Inning","status":2,"issuperover":"false","result":3,"batting_team_id":129003,"fielding_team_id":129004,"scores":"108\/2","scores_full":"108\/2 (6.5 ov)","fielder":[{"fielder_id":"116171","fielder_name":"Lee John","catches":1,"runout_thrower":0,"runout_catcher":0,"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":"Xytus Emmanuel","batsman_id":"99736","runs":"0","balls":"1","how_out":"b L John","score_at_dismissal":87,"overs_at_dismissal":"5.3","bowler_id":"116171","dismissal":"bowled","number":2},"extra_runs":{"byes":4,"legbyes":0,"wides":6,"noballs":0,"penalty":"0","total":10},"equations":{"runs":108,"wickets":2,"overs":"6.5","bowlers_used":6,"runrate":"15.80"},"current_partnership":{"runs":21,"balls":8,"overs":1.2,"batsmen":[{"name":"Christian Charlery","batsman_id":107766,"runs":7,"balls":4},{"name":"Jason Simon","batsman_id":99721,"runs":13,"balls":4}]},"did_not_bat":[{"player_id":"99723","name":"Vince Smith"},{"player_id":"99744","name":"Sanjay Pamphile"},{"player_id":"107672","name":"Tarrique Edward"},{"player_id":"99762","name":"Keon Gaston"},{"player_id":"107676","name":"Kuston Jules"},{"player_id":"150060","name":"Yunieski Gustave"},{"player_id":"128590","name":"Jermaine thomas"}],"max_over":"10","target":"106","recent_scores":"6,6,0,1,1,1,6,0,0,w,w,1,6,0,1,6,6,6","last_five_overs":"84\/2 15.27","last_ten_overs":"108\/2 13.79"},"teams":[{"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":"108\/2 (6.5 ov)","scores":"108\/2","overs":"6.5"},{"tid":129004,"title":"Whiptail Smashers","abbr":"WTS","alt_name":"Whiptail Smashers","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Whiptail-Smashers.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Whiptail-Smashers.png","country":"wi","sex":"male","team_owner":"","head_coach":"","scores_full":"105\/7 (10 ov)","scores":"105\/7","overs":"10"}],"players":[{"pid":93587,"title":"Kimani Melius","short_name":"KS Melius","first_name":"Kimani Melius","last_name":"","middle_name":"","birthdate":"2001-01-17","birthplace":"St. Lucia","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":23789,"recent_appearance":1515805200,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":"(C)"},{"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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":""},{"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":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":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":"","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":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(WK)"},{"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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":99794,"title":"Tyler Sookwa","short_name":"T Sookwa","first_name":"Tyler Sookwa","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":99806,"title":"Jard Goodman","short_name":"J Goodman","first_name":"Jard Goodman","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":99811,"title":"Tyrel Chicot","short_name":"T Chicot","first_name":"Tyrel Chicot","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":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":99815,"title":"Simeon Gerson","short_name":"S Gerson","first_name":"Simeon Gerson","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":"","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":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":"(C)"},{"pid":107705,"title":"Ryan Goodman","short_name":"R Goodman","first_name":"Ryan Goodman","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":107775,"title":"Shawnil Edward","short_name":"S Edward","first_name":"Shawnil Edward","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":107804,"title":"Jeandell Cyril","short_name":"J Cyril","first_name":"Jeandell Cyril","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":116169,"title":"Rene Montoute","short_name":"R Montoute","first_name":"Rene Montoute","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":116171,"title":"Lee John","short_name":"L John","first_name":"Lee John","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":116173,"title":"Ted Jonas","short_name":"T Jonas","first_name":"Ted Jonas","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":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":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"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":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":138226,"title":"Darvin Forde","short_name":"D Forde","first_name":"Darvin Forde","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":138229,"title":"Trent Belfon","short_name":"T Belfon","first_name":"Trent Belfon","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":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":138274,"title":"Leon Alexander","short_name":"L Alexander","first_name":"Leon Alexander","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":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":138275,"title":"Ashton Alexander","short_name":"A Alexander","first_name":"Ashton Alexander","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":150061,"title":"Kanil Nelson","short_name":"KN Nelson","first_name":"Kanil Nelson","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(WK)"}]},"etag":"a3b0447b9f507448fd735406161dbdc6","modified":"2025-07-09 04:13:29","datetime":"2025-07-09 04:13:29","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":90936,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Piton Stickers won by 8 wickets","day_remaining_over":"","team_batting":"Piton Stickers","team_bowling":"Whiptail Smashers","live_inning_number":2,"live_score":{"runs":108,"overs":6.5,"wickets":2,"target":106,"runrate":15.8,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Jason Simon","batsman_id":99721,"runs":55,"balls_faced":18,"fours":0,"sixes":8,"strike_rate":"305.56"},{"name":"Christian Charlery","batsman_id":107766,"runs":7,"balls_faced":4,"fours":0,"sixes":1,"strike_rate":"175.00"}],"bowlers":[{"name":"Ryan Goodman","bowler_id":107705,"overs":0.5,"runs_conceded":15,"wickets":0,"maidens":0,"econ":"18.00"},{"name":"Lee John","bowler_id":116171,"overs":1,"runs_conceded":7,"wickets":2,"maidens":0,"econ":"7.00"}],"commentaries":[{"event_id":"12219629","event":"ball","batsman_id":"99734","bowler_id":"107804","over":"2","ball":"6","score":6,"commentary":"Jeandell Cyril to Julian Sylvester, Six,","noball_dismissal":false,"text":"","timestamp":1750796389,"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":3,"runs":8,"score":"38\/0","bats":[{"runs":10,"balls_faced":10,"fours":0,"sixes":1,"batsman_id":99734},{"runs":21,"balls_faced":8,"fours":0,"sixes":3,"batsman_id":99721}],"bowls":[{"runs_conceded":19,"maidens":0,"wickets":0,"bowler_id":107804,"overs":2},{"runs_conceded":15,"maidens":0,"wickets":0,"bowler_id":99811,"overs":1}],"commentary":"End of over 3 (8 runs), Piton Stickers 38\/0"},{"event_id":"12219632","event":"ball","batsman_id":"99721","bowler_id":"107775","over":"3","ball":"1","score":1,"commentary":"Shawnil Edward to Jason Simon, 1 run,","noball_dismissal":false,"text":"","timestamp":1750796465,"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":"12219633","event":"ball","batsman_id":"99734","bowler_id":"107775","over":"3","ball":"2","score":4,"commentary":"Shawnil Edward to Julian Sylvester, Four,","noball_dismissal":false,"text":"","timestamp":1750796479,"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":"12219634","event":"ball","batsman_id":"99734","bowler_id":"107775","over":"3","ball":"3","score":6,"commentary":"Shawnil Edward to Julian Sylvester, Six,","noball_dismissal":false,"text":"","timestamp":1750796481,"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":"12219635","event":"ball","batsman_id":"99734","bowler_id":"107775","over":"3","ball":"4","score":4,"commentary":"Shawnil Edward to Julian Sylvester, Four,","noball_dismissal":false,"text":"","timestamp":1750796484,"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":"12219636","event":"ball","batsman_id":"99734","bowler_id":"107775","over":"3","ball":"5","score":6,"commentary":"Shawnil Edward to Julian Sylvester, Six,","noball_dismissal":false,"text":"","timestamp":1750796486,"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":"12219638","event":"ball","batsman_id":"99734","bowler_id":"107775","over":"3","ball":"6","score":0,"commentary":"Shawnil Edward to Julian Sylvester, no run,","noball_dismissal":false,"text":"","timestamp":1750796488,"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":4,"runs":21,"score":"59\/0","bats":[{"runs":30,"balls_faced":15,"fours":2,"sixes":3,"batsman_id":99734},{"runs":22,"balls_faced":9,"fours":0,"sixes":3,"batsman_id":99721}],"bowls":[{"runs_conceded":21,"maidens":0,"wickets":0,"bowler_id":107775,"overs":1},{"runs_conceded":19,"maidens":0,"wickets":0,"bowler_id":107804,"overs":2}],"commentary":"End of over 4 (21 runs), Piton Stickers 59\/0"},{"event_id":"12219639","event":"ball","batsman_id":"99721","bowler_id":"116173","over":"4","ball":"1","score":"1wd","commentary":"Ted Jonas to Jason Simon, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750796547,"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":"12219640","event":"ball","batsman_id":"99721","bowler_id":"116173","over":"4","ball":"1","score":"1wd","commentary":"Ted Jonas to Jason Simon, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750796549,"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":"12219641","event":"ball","batsman_id":"99721","bowler_id":"116173","over":"4","ball":"1","score":6,"commentary":"Ted Jonas to Jason Simon, Six,","noball_dismissal":false,"text":"","timestamp":1750796552,"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":"12219642","event":"ball","batsman_id":"99721","bowler_id":"116173","over":"4","ball":"2","score":6,"commentary":"Ted Jonas to Jason Simon, Six,","noball_dismissal":false,"text":"","timestamp":1750796554,"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":"12219643","event":"ball","batsman_id":"99721","bowler_id":"116173","over":"4","ball":"3","score":6,"commentary":"Ted Jonas to Jason Simon, Six,","noball_dismissal":false,"text":"","timestamp":1750796556,"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":"12219644","event":"ball","batsman_id":"99721","bowler_id":"116173","over":"4","ball":"4","score":1,"commentary":"Ted Jonas to Jason Simon, 1 run,","noball_dismissal":false,"text":"","timestamp":1750796559,"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":"12219645","event":"ball","batsman_id":"99734","bowler_id":"116173","over":"4","ball":"5","score":0,"commentary":"Ted Jonas to Julian Sylvester, no run,","noball_dismissal":false,"text":"","timestamp":1750796562,"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":"12219647","event":"ball","batsman_id":"99734","bowler_id":"116173","over":"4","ball":"6","score":6,"commentary":"Ted Jonas to Julian Sylvester, Six,","noball_dismissal":false,"text":"","timestamp":1750796565,"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":5,"runs":27,"score":"86\/0","bats":[{"runs":36,"balls_faced":17,"fours":2,"sixes":4,"batsman_id":99734},{"runs":41,"balls_faced":13,"fours":0,"sixes":6,"batsman_id":99721}],"bowls":[{"runs_conceded":27,"maidens":0,"wickets":0,"bowler_id":116173,"overs":1},{"runs_conceded":21,"maidens":0,"wickets":0,"bowler_id":107775,"overs":1}],"commentary":"End of over 5 (27 runs), Piton Stickers 86\/0"},{"event_id":"12219648","event":"ball","batsman_id":"99721","bowler_id":"116171","over":"5","ball":"1","score":1,"commentary":"Lee John to Jason Simon, 1 run,","noball_dismissal":false,"text":"","timestamp":1750796587,"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":"12219649","event":"wicket","batsman_id":"99734","bowler_id":"116171","over":"5","ball":"2","score":"w","commentary":"Lee John to Julian Sylvester, no run, c & b L John,","noball_dismissal":false,"text":"","timestamp":1750796593,"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":"99734","how_out":"c & b L John","batsman_runs":"36","batsman_balls":"18"},{"event_id":"12219650","event":"wicket","batsman_id":"99736","bowler_id":"116171","over":"5","ball":"3","score":"w","commentary":"Lee John to Xytus Emmanuel, no run, b L John,","noball_dismissal":false,"text":"","timestamp":1750796613,"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":"99736","how_out":"b L John","batsman_runs":"0","batsman_balls":"1"},{"event_id":"12219651","event":"ball","batsman_id":"107766","bowler_id":"116171","over":"5","ball":"4","score":0,"commentary":"Lee John to Christian Charlery, no run,","noball_dismissal":false,"text":"","timestamp":1750796632,"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":"12219653","event":"ball","batsman_id":"107766","bowler_id":"116171","over":"5","ball":"5","score":0,"commentary":"Lee John to Christian Charlery, no run,","noball_dismissal":false,"text":"","timestamp":1750796635,"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":"12219654","event":"ball","batsman_id":"107766","bowler_id":"116171","over":"5","ball":"6","score":6,"commentary":"Lee John to Christian Charlery, Six,","noball_dismissal":false,"text":"","timestamp":1750796638,"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":6,"runs":7,"score":"93\/2","bats":[{"runs":6,"balls_faced":3,"fours":0,"sixes":1,"batsman_id":107766},{"runs":42,"balls_faced":14,"fours":0,"sixes":6,"batsman_id":99721}],"bowls":[{"runs_conceded":7,"maidens":0,"wickets":2,"bowler_id":116171,"overs":1},{"runs_conceded":27,"maidens":0,"wickets":0,"bowler_id":116173,"overs":1}],"commentary":"End of over 6 (7 runs), Piton Stickers 93\/2"},{"event_id":"12219656","event":"ball","batsman_id":"99721","bowler_id":"107705","over":"6","ball":"1","score":"1wd","commentary":"Ryan Goodman to Jason Simon, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750796672,"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":"12219657","event":"ball","batsman_id":"99721","bowler_id":"107705","over":"6","ball":"1","score":1,"commentary":"Ryan Goodman to Jason Simon, 1 run,","noball_dismissal":false,"text":"","timestamp":1750796698,"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":"12219658","event":"ball","batsman_id":"107766","bowler_id":"107705","over":"6","ball":"2","score":1,"commentary":"Ryan Goodman to Christian Charlery, 1 run,","noball_dismissal":false,"text":"","timestamp":1750796707,"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":"12219661","event":"ball","batsman_id":"99721","bowler_id":"107705","over":"6","ball":"3","score":0,"commentary":"Ryan Goodman to Jason Simon, no run,","noball_dismissal":false,"text":"","timestamp":1750796719,"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":"12219662","event":"ball","batsman_id":"99721","bowler_id":"107705","over":"6","ball":"4","score":6,"commentary":"Ryan Goodman to Jason Simon, Six,","noball_dismissal":false,"text":"","timestamp":1750796736,"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":"12219663","event":"ball","batsman_id":"99721","bowler_id":"107705","over":"6","ball":"5","score":6,"commentary":"Ryan Goodman to Jason Simon, Six,","noball_dismissal":false,"text":"","timestamp":1750796748,"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}],"day":"0","session":"0","live_inning":{"iid":198692,"number":2,"name":"Piton Stickers Inning","short_name":"PTS Inning","status":2,"issuperover":"false","result":3,"batting_team_id":129003,"fielding_team_id":129004,"scores":"108\/2","scores_full":"108\/2 (6.5 ov)","fielder":[{"fielder_id":"116171","fielder_name":"Lee John","catches":1,"runout_thrower":0,"runout_catcher":0,"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":"Xytus Emmanuel","batsman_id":"99736","runs":"0","balls":"1","how_out":"b L John","score_at_dismissal":87,"overs_at_dismissal":"5.3","bowler_id":"116171","dismissal":"bowled","number":2},"extra_runs":{"byes":4,"legbyes":0,"wides":6,"noballs":0,"penalty":"0","total":10},"equations":{"runs":108,"wickets":2,"overs":"6.5","bowlers_used":6,"runrate":"15.80"},"current_partnership":{"runs":21,"balls":8,"overs":1.2,"batsmen":[{"name":"Christian Charlery","batsman_id":107766,"runs":7,"balls":4},{"name":"Jason Simon","batsman_id":99721,"runs":13,"balls":4}]},"did_not_bat":[{"player_id":"99723","name":"Vince Smith"},{"player_id":"99744","name":"Sanjay Pamphile"},{"player_id":"107672","name":"Tarrique Edward"},{"player_id":"99762","name":"Keon Gaston"},{"player_id":"107676","name":"Kuston Jules"},{"player_id":"150060","name":"Yunieski Gustave"},{"player_id":"128590","name":"Jermaine thomas"}],"max_over":"10","target":"106","recent_scores":"6,6,0,1,1,1,6,0,0,w,w,1,6,0,1,6,6,6","last_five_overs":"84\/2 15.27","last_ten_overs":"108\/2 13.79"},"teams":[{"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":"108\/2 (6.5 ov)","scores":"108\/2","overs":"6.5"},{"tid":129004,"title":"Whiptail Smashers","abbr":"WTS","alt_name":"Whiptail Smashers","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Whiptail-Smashers.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Whiptail-Smashers.png","country":"wi","sex":"male","team_owner":"","head_coach":"","scores_full":"105\/7 (10 ov)","scores":"105\/7","overs":"10"}],"players":[{"pid":93587,"title":"Kimani Melius","short_name":"KS Melius","first_name":"Kimani Melius","last_name":"","middle_name":"","birthdate":"2001-01-17","birthplace":"St. Lucia","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":23789,"recent_appearance":1515805200,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":"(C)"},{"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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":""},{"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":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":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":"","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":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(WK)"},{"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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":99794,"title":"Tyler Sookwa","short_name":"T Sookwa","first_name":"Tyler Sookwa","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":99806,"title":"Jard Goodman","short_name":"J Goodman","first_name":"Jard Goodman","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":99811,"title":"Tyrel Chicot","short_name":"T Chicot","first_name":"Tyrel Chicot","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":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":99815,"title":"Simeon Gerson","short_name":"S Gerson","first_name":"Simeon Gerson","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":"","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":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":"(C)"},{"pid":107705,"title":"Ryan Goodman","short_name":"R Goodman","first_name":"Ryan Goodman","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":107775,"title":"Shawnil Edward","short_name":"S Edward","first_name":"Shawnil Edward","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":107804,"title":"Jeandell Cyril","short_name":"J Cyril","first_name":"Jeandell Cyril","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":116169,"title":"Rene Montoute","short_name":"R Montoute","first_name":"Rene Montoute","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":116171,"title":"Lee John","short_name":"L John","first_name":"Lee John","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":116173,"title":"Ted Jonas","short_name":"T Jonas","first_name":"Ted Jonas","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":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":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"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":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":138226,"title":"Darvin Forde","short_name":"D Forde","first_name":"Darvin Forde","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":138229,"title":"Trent Belfon","short_name":"T Belfon","first_name":"Trent Belfon","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":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":138274,"title":"Leon Alexander","short_name":"L Alexander","first_name":"Leon Alexander","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":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":138275,"title":"Ashton Alexander","short_name":"A Alexander","first_name":"Ashton Alexander","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":150061,"title":"Kanil Nelson","short_name":"KN Nelson","first_name":"Kanil Nelson","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(WK)"}]},"etag":"a3b0447b9f507448fd735406161dbdc6","modified":"2025-07-09 04:13:29","datetime":"2025-07-09 04:13:29","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90936 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:6b6315a6-8eb4-45f8-8024-444cfb086394
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90936 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90936,3,'{"status":"ok","response":{"match_id":90936,"title":"Piton Stickers vs Whiptail Smashers","short_title":"PTS vs WTS","subtitle":"Match 2","match_number":"2","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Piton Stickers won by 8 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":"108\/2 (6.5 ov)","scores":"108\/2","overs":"6.5"},"teamb":{"team_id":129004,"name":"Whiptail Smashers","short_name":"WTS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Whiptail-Smashers.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Whiptail-Smashers.png","scores_full":"105\/7 (10 ov)","scores":"105\/7","overs":"10"},"date_start":"2025-06-24 18:30:00","date_end":"2025-06-25 04:30:00","timestamp_start":1750789800,"timestamp_end":1750825800,"date_start_ist":"2025-06-25 00:00:00","date_end_ist":"2025-06-25 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":"PTS won by 8 wickets","result_type":1,"win_margin":"8 wickets","winning_team_id":129003,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-22 16:28:12","verify_time":"2025-06-25 02:34:00","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":27.5,"humidity":80,"visibility":10000,"wind_speed":"18.88","clouds":100},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Sharp Turn"},"toss":{"text":"Piton Stickers elected to bowl","winner":129003,"decision":2}},"etag":"22811e3127877ef1a594df82fa547859","modified":"2025-07-09 04:13:30","datetime":"2025-07-09 04:13:30","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90936,"title":"Piton Stickers vs Whiptail Smashers","short_title":"PTS vs WTS","subtitle":"Match 2","match_number":"2","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Piton Stickers won by 8 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":"108\/2 (6.5 ov)","scores":"108\/2","overs":"6.5"},"teamb":{"team_id":129004,"name":"Whiptail Smashers","short_name":"WTS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Whiptail-Smashers.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Whiptail-Smashers.png","scores_full":"105\/7 (10 ov)","scores":"105\/7","overs":"10"},"date_start":"2025-06-24 18:30:00","date_end":"2025-06-25 04:30:00","timestamp_start":1750789800,"timestamp_end":1750825800,"date_start_ist":"2025-06-25 00:00:00","date_end_ist":"2025-06-25 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":"PTS won by 8 wickets","result_type":1,"win_margin":"8 wickets","winning_team_id":129003,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-22 16:28:12","verify_time":"2025-06-25 02:34:00","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":27.5,"humidity":80,"visibility":10000,"wind_speed":"18.88","clouds":100},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Sharp Turn"},"toss":{"text":"Piton Stickers elected to bowl","winner":129003,"decision":2}},"etag":"22811e3127877ef1a594df82fa547859","modified":"2025-07-09 04:13:30","datetime":"2025-07-09 04:13:30","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90936 AND DataTypeId = 3 END Live Report & Scorecard of Piton Stickers vs Whiptail Smashers Match 2
Piton Stickers vs Whiptail Smashers, Live Cricket Commentary