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:366962fa-f28e-4e02-a9e8-640d053314b7
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90940 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90940,1,'{"status":"ok","response":{"mid":90940,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Piton Stickers won by 21 runs","day_remaining_over":"","team_batting":"Calabash Giants","team_bowling":"Piton Stickers","live_inning_number":2,"live_score":{"runs":99,"overs":10,"wickets":4,"target":121,"runrate":9.9,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Cody Lesmond","batsman_id":126998,"runs":1,"balls_faced":1,"fours":0,"sixes":0,"strike_rate":"100.00"},{"name":"Stephen Abraham","batsman_id":127133,"runs":40,"balls_faced":22,"fours":1,"sixes":4,"strike_rate":"181.82"}],"bowlers":[{"name":"Kuston Jules","bowler_id":107676,"overs":2,"runs_conceded":26,"wickets":0,"maidens":0,"econ":"13.00"},{"name":"Keon Gaston","bowler_id":99762,"overs":2,"runs_conceded":9,"wickets":0,"maidens":0,"econ":"4.50"}],"commentaries":[{"event":"overend","over":6,"runs":10,"score":"59\/2","bats":[{"runs":3,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":127132},{"runs":15,"balls_faced":9,"fours":0,"sixes":2,"batsman_id":127133}],"bowls":[{"runs_conceded":10,"maidens":0,"wickets":1,"bowler_id":150060,"overs":1},{"runs_conceded":11,"maidens":0,"wickets":0,"bowler_id":107766,"overs":1}],"commentary":"End of over 6 (10 runs), Calabash Giants 59\/2"},{"event_id":"12233326","event":"ball","batsman_id":"127133","bowler_id":"107766","over":"6","ball":"1","score":1,"commentary":"Christian Charlery to Stephen Abraham, 1 run,","noball_dismissal":false,"text":"","timestamp":1750969118,"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":"12233331","event":"wicket","batsman_id":"127132","bowler_id":"107766","over":"6","ball":"2","score":"w","commentary":"Christian Charlery to Caleb Thomas, no run, c N Joseph b C Charlery,","noball_dismissal":false,"text":"","timestamp":1750969123,"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":"127132","how_out":"c N Joseph b C Charlery","batsman_runs":"3","batsman_balls":"3"},{"event_id":"12233332","event":"ball","batsman_id":"127001","bowler_id":"107766","over":"6","ball":"3","score":4,"commentary":"Christian Charlery to Magaran Shoulette, Four,","noball_dismissal":false,"text":"","timestamp":1750969127,"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":"12233334","event":"ball","batsman_id":"127001","bowler_id":"107766","over":"6","ball":"4","score":1,"commentary":"Christian Charlery to Magaran Shoulette, 1 run,","noball_dismissal":false,"text":"","timestamp":1750969131,"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":"12233335","event":"ball","batsman_id":"127133","bowler_id":"107766","over":"6","ball":"5","score":"1wd","commentary":"Christian Charlery to Stephen Abraham, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750969172,"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":"12233337","event":"ball","batsman_id":"127133","bowler_id":"107766","over":"6","ball":"5","score":1,"commentary":"Christian Charlery to Stephen Abraham, 1 run,","noball_dismissal":false,"text":"","timestamp":1750969175,"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":"12233340","event":"ball","batsman_id":"127001","bowler_id":"107766","over":"6","ball":"6","score":0,"commentary":"Christian Charlery to Magaran Shoulette, no run,","noball_dismissal":false,"text":"","timestamp":1750969179,"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":7,"runs":8,"score":"67\/3","bats":[{"runs":5,"balls_faced":3,"fours":1,"sixes":0,"batsman_id":127001},{"runs":17,"balls_faced":11,"fours":0,"sixes":2,"batsman_id":127133}],"bowls":[{"runs_conceded":19,"maidens":0,"wickets":1,"bowler_id":107766,"overs":2},{"runs_conceded":10,"maidens":0,"wickets":1,"bowler_id":150060,"overs":1}],"commentary":"End of over 7 (8 runs), Calabash Giants 67\/3"},{"event_id":"12233345","event":"ball","batsman_id":"127133","bowler_id":"99744","over":"7","ball":"1","score":1,"commentary":"Sanjay Pamphile to Stephen Abraham, 1 run,","noball_dismissal":false,"text":"","timestamp":1750969388,"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":"12233346","event":"ball","batsman_id":"127001","bowler_id":"99744","over":"7","ball":"2","score":"1lb","commentary":"Sanjay Pamphile to Magaran Shoulette, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1750969392,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"1","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12233348","event":"ball","batsman_id":"127133","bowler_id":"99744","over":"7","ball":"3","score":1,"commentary":"Sanjay Pamphile to Stephen Abraham, 1 run,","noball_dismissal":false,"text":"","timestamp":1750969395,"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":"12233350","event":"ball","batsman_id":"127001","bowler_id":"99744","over":"7","ball":"4","score":1,"commentary":"Sanjay Pamphile to Magaran Shoulette, 1 run,","noball_dismissal":false,"text":"","timestamp":1750969398,"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":"12233351","event":"ball","batsman_id":"127133","bowler_id":"99744","over":"7","ball":"5","score":6,"commentary":"Sanjay Pamphile to Stephen Abraham, Six,","noball_dismissal":false,"text":"","timestamp":1750969401,"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":"12233352","event":"ball","batsman_id":"127133","bowler_id":"99744","over":"7","ball":"6","score":2,"commentary":"Sanjay Pamphile to Stephen Abraham, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750969439,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":8,"runs":12,"score":"79\/3","bats":[{"runs":27,"balls_faced":15,"fours":0,"sixes":3,"batsman_id":127133},{"runs":6,"balls_faced":5,"fours":1,"sixes":0,"batsman_id":127001}],"bowls":[{"runs_conceded":11,"maidens":0,"wickets":0,"bowler_id":99744,"overs":1},{"runs_conceded":19,"maidens":0,"wickets":1,"bowler_id":107766,"overs":2}],"commentary":"End of over 8 (12 runs), Calabash Giants 79\/3"},{"event_id":"12233362","event":"ball","batsman_id":"127001","bowler_id":"99762","over":"8","ball":"1","score":0,"commentary":"Keon Gaston to Magaran Shoulette, no run,","noball_dismissal":false,"text":"","timestamp":1750969689,"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":"12233364","event":"ball","batsman_id":"127001","bowler_id":"99762","over":"8","ball":"2","score":1,"commentary":"Keon Gaston to Magaran Shoulette, 1 run,","noball_dismissal":false,"text":"","timestamp":1750969693,"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":"12233365","event":"ball","batsman_id":"127133","bowler_id":"99762","over":"8","ball":"3","score":4,"commentary":"Keon Gaston to Stephen Abraham, Four,","noball_dismissal":false,"text":"","timestamp":1750969697,"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":"12233369","event":"ball","batsman_id":"127133","bowler_id":"99762","over":"8","ball":"4","score":0,"commentary":"Keon Gaston to Stephen Abraham, no run,","noball_dismissal":false,"text":"","timestamp":1750969700,"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":"12233370","event":"ball","batsman_id":"127133","bowler_id":"99762","over":"8","ball":"5","score":0,"commentary":"Keon Gaston to Stephen Abraham, no run,","noball_dismissal":false,"text":"","timestamp":1750969704,"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":"12233372","event":"ball","batsman_id":"127133","bowler_id":"99762","over":"8","ball":"6","score":1,"commentary":"Keon Gaston to Stephen Abraham, 1 run,","noball_dismissal":false,"text":"","timestamp":1750969708,"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":9,"runs":6,"score":"85\/3","bats":[{"runs":32,"balls_faced":19,"fours":1,"sixes":3,"batsman_id":127133},{"runs":7,"balls_faced":7,"fours":1,"sixes":0,"batsman_id":127001}],"bowls":[{"runs_conceded":9,"maidens":0,"wickets":0,"bowler_id":99762,"overs":2},{"runs_conceded":11,"maidens":0,"wickets":0,"bowler_id":99744,"overs":1}],"commentary":"End of over 9 (6 runs), Calabash Giants 85\/3"},{"event_id":"12233378","event":"ball","batsman_id":"127133","bowler_id":"107676","over":"9","ball":"1","score":6,"commentary":"Kuston Jules to Stephen Abraham, Six,","noball_dismissal":false,"text":"","timestamp":1750969903,"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":"12233380","event":"ball","batsman_id":"127133","bowler_id":"107676","over":"9","ball":"2","score":1,"commentary":"Kuston Jules to Stephen Abraham, 1 run,","noball_dismissal":false,"text":"","timestamp":1750969907,"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":"12233382","event":"ball","batsman_id":"127001","bowler_id":"107676","over":"9","ball":"3","score":4,"commentary":"Kuston Jules to Magaran Shoulette, Four,","noball_dismissal":false,"text":"","timestamp":1750969911,"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":"12233388","event":"wicket","batsman_id":"127001","bowler_id":"107676","over":"9","ball":"4","score":"w","commentary":"Kuston Jules to Magaran Shoulette, no run, runout (K Jules),","noball_dismissal":false,"text":"","timestamp":1750969954,"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":"127001","how_out":"runout (K Jules)","batsman_runs":"11","batsman_balls":"9"},{"event_id":"12233394","event":"ball","batsman_id":"127133","bowler_id":"107676","over":"9","ball":"5","score":"1wd","commentary":"Kuston Jules to Stephen Abraham, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750970023,"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":"12233395","event":"ball","batsman_id":"127133","bowler_id":"107676","over":"9","ball":"5","score":1,"commentary":"Kuston Jules to Stephen Abraham, 1 run,","noball_dismissal":false,"text":"","timestamp":1750970026,"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":"12233397","event":"ball","batsman_id":"126998","bowler_id":"107676","over":"9","ball":"6","score":1,"commentary":"Kuston Jules to Cody Lesmond, 1 run,","noball_dismissal":false,"text":"","timestamp":1750970040,"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":10,"runs":14,"score":"99\/4","bats":[{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":126998},{"runs":40,"balls_faced":22,"fours":1,"sixes":4,"batsman_id":127133}],"bowls":[{"runs_conceded":26,"maidens":0,"wickets":0,"bowler_id":107676,"overs":2},{"runs_conceded":9,"maidens":0,"wickets":0,"bowler_id":99762,"overs":2}],"commentary":"End of over 10 (14 runs), Calabash Giants 99\/4"}],"day":"0","session":"0","live_inning":{"iid":198801,"number":2,"name":"Calabash Giants Inning","short_name":"CBG Inning","status":2,"issuperover":"false","result":4,"batting_team_id":129005,"fielding_team_id":129003,"scores":"99\/4","scores_full":"99\/4 (10 ov)","fielder":[{"fielder_id":"99744","fielder_name":"Sanjay Pamphile","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"150249","fielder_name":"Nathaniel Joseph","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"107676","fielder_name":"Kuston Jules","catches":0,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":1,"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":"Magaran Shoulette","batsman_id":"127001","runs":"11","balls":"9","how_out":"runout (K Jules)","score_at_dismissal":96,"overs_at_dismissal":"9.4","bowler_id":"0","dismissal":"runout","number":4},"extra_runs":{"byes":0,"legbyes":1,"wides":9,"noballs":0,"penalty":"0","total":10},"equations":{"runs":99,"wickets":4,"overs":"10","bowlers_used":6,"runrate":"9.90"},"current_partnership":{"runs":3,"balls":2,"overs":0.2,"batsmen":[{"name":"Stephen Abraham","batsman_id":127133,"runs":1,"balls":1},{"name":"Cody Lesmond","batsman_id":126998,"runs":1,"balls":1}]},"did_not_bat":[{"player_id":"99821","name":"David Naitram"},{"player_id":"52175","name":"Dornan Edward"},{"player_id":"116188","name":"Marklin Sylvester"},{"player_id":"99743","name":"Wayne Prospere"},{"player_id":"150063","name":"Alexus Charles"}],"max_over":"10","target":"121","recent_scores":"1,1,1,w,4,1,6,1,0,0,4,1,0,2,6,1,1,1","last_five_overs":"50\/3 9.38","last_ten_overs":"99\/4 9.14"},"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":"120\/6 (10 ov)","scores":"120\/6","overs":"10"},{"tid":129005,"title":"Calabash Giants","abbr":"CBG","alt_name":"Calabash Giants","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Calabash-Giants.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Calabash-Giants.png","country":"wi","sex":"male","team_owner":"","head_coach":"","scores_full":"99\/4 (10 ov)","scores":"99\/4","overs":"10"}],"players":[{"pid":52175,"title":"Dornan Edward","short_name":"DC Edward","first_name":"Dornan Edward","last_name":"","middle_name":"","birthdate":"1996-10-28","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":70012,"title":"Mervin Wells","short_name":"M Wells","first_name":"Mervin Wells","last_name":"","middle_name":"","birthdate":"1987-01-16","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","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":6.5,"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":"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":"","bowling_type":"","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":"","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":99743,"title":"Wayne Prospere","short_name":"W Prospere","first_name":"Wayne Prospere","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":"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.5,"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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":"(C)"},{"pid":99764,"title":"Sadrack Descartes","short_name":"S Descartes","first_name":"Sadrack Descartes","last_name":"","middle_name":"","birthdate":"1997-10-19","birthplace":"Cheshire","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left 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":"all","role_str":"(C)"},{"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":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":99821,"title":"David Naitram","short_name":"D Naitram","first_name":"David Naitram","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":107712,"title":"Kurt Edward","short_name":"K Edward","first_name":"Kurt 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":"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":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":115903,"title":"Josan James","short_name":"J James","first_name":"Josan James","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":116188,"title":"Marklin Sylvester","short_name":"M Sylvester","first_name":"Marklin Sylvester","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":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":126998,"title":"Cody Lesmond","short_name":"Cody Lesmond","first_name":"Cody Lesmond","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":127001,"title":"Magaran Shoulette","short_name":"M Shoulette","first_name":"Magaran Shoulette","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":""},{"pid":127132,"title":"Caleb Thomas","short_name":"C Thomas","first_name":"Caleb Thomas","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":""},{"pid":127133,"title":"Stephen Abraham","short_name":"S Abraham","first_name":"Stephen Abraham","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":"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":"bowl","role_str":""},{"pid":138227,"title":"Bjorn Fanus","short_name":"B Fanus","first_name":"Bjorn Fanus","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":"squad","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":"","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":150063,"title":"Alexus Charles","short_name":"AX Charles","first_name":"Alexus Charles","last_name":"","middle_name":"","birthdate":"2006-05-31","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":150064,"title":"Denzie JnPaul","short_name":"DZ JnPaul","first_name":"Denzie JnPaul","last_name":"","middle_name":"","birthdate":"2007-11-18","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":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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""}]},"etag":"c33bf64ffc379deaf508e0187b0ebc07","modified":"2025-07-08 15:17:57","datetime":"2025-07-08 15:17:57","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":90940,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Piton Stickers won by 21 runs","day_remaining_over":"","team_batting":"Calabash Giants","team_bowling":"Piton Stickers","live_inning_number":2,"live_score":{"runs":99,"overs":10,"wickets":4,"target":121,"runrate":9.9,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Cody Lesmond","batsman_id":126998,"runs":1,"balls_faced":1,"fours":0,"sixes":0,"strike_rate":"100.00"},{"name":"Stephen Abraham","batsman_id":127133,"runs":40,"balls_faced":22,"fours":1,"sixes":4,"strike_rate":"181.82"}],"bowlers":[{"name":"Kuston Jules","bowler_id":107676,"overs":2,"runs_conceded":26,"wickets":0,"maidens":0,"econ":"13.00"},{"name":"Keon Gaston","bowler_id":99762,"overs":2,"runs_conceded":9,"wickets":0,"maidens":0,"econ":"4.50"}],"commentaries":[{"event":"overend","over":6,"runs":10,"score":"59\/2","bats":[{"runs":3,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":127132},{"runs":15,"balls_faced":9,"fours":0,"sixes":2,"batsman_id":127133}],"bowls":[{"runs_conceded":10,"maidens":0,"wickets":1,"bowler_id":150060,"overs":1},{"runs_conceded":11,"maidens":0,"wickets":0,"bowler_id":107766,"overs":1}],"commentary":"End of over 6 (10 runs), Calabash Giants 59\/2"},{"event_id":"12233326","event":"ball","batsman_id":"127133","bowler_id":"107766","over":"6","ball":"1","score":1,"commentary":"Christian Charlery to Stephen Abraham, 1 run,","noball_dismissal":false,"text":"","timestamp":1750969118,"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":"12233331","event":"wicket","batsman_id":"127132","bowler_id":"107766","over":"6","ball":"2","score":"w","commentary":"Christian Charlery to Caleb Thomas, no run, c N Joseph b C Charlery,","noball_dismissal":false,"text":"","timestamp":1750969123,"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":"127132","how_out":"c N Joseph b C Charlery","batsman_runs":"3","batsman_balls":"3"},{"event_id":"12233332","event":"ball","batsman_id":"127001","bowler_id":"107766","over":"6","ball":"3","score":4,"commentary":"Christian Charlery to Magaran Shoulette, Four,","noball_dismissal":false,"text":"","timestamp":1750969127,"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":"12233334","event":"ball","batsman_id":"127001","bowler_id":"107766","over":"6","ball":"4","score":1,"commentary":"Christian Charlery to Magaran Shoulette, 1 run,","noball_dismissal":false,"text":"","timestamp":1750969131,"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":"12233335","event":"ball","batsman_id":"127133","bowler_id":"107766","over":"6","ball":"5","score":"1wd","commentary":"Christian Charlery to Stephen Abraham, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750969172,"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":"12233337","event":"ball","batsman_id":"127133","bowler_id":"107766","over":"6","ball":"5","score":1,"commentary":"Christian Charlery to Stephen Abraham, 1 run,","noball_dismissal":false,"text":"","timestamp":1750969175,"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":"12233340","event":"ball","batsman_id":"127001","bowler_id":"107766","over":"6","ball":"6","score":0,"commentary":"Christian Charlery to Magaran Shoulette, no run,","noball_dismissal":false,"text":"","timestamp":1750969179,"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":7,"runs":8,"score":"67\/3","bats":[{"runs":5,"balls_faced":3,"fours":1,"sixes":0,"batsman_id":127001},{"runs":17,"balls_faced":11,"fours":0,"sixes":2,"batsman_id":127133}],"bowls":[{"runs_conceded":19,"maidens":0,"wickets":1,"bowler_id":107766,"overs":2},{"runs_conceded":10,"maidens":0,"wickets":1,"bowler_id":150060,"overs":1}],"commentary":"End of over 7 (8 runs), Calabash Giants 67\/3"},{"event_id":"12233345","event":"ball","batsman_id":"127133","bowler_id":"99744","over":"7","ball":"1","score":1,"commentary":"Sanjay Pamphile to Stephen Abraham, 1 run,","noball_dismissal":false,"text":"","timestamp":1750969388,"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":"12233346","event":"ball","batsman_id":"127001","bowler_id":"99744","over":"7","ball":"2","score":"1lb","commentary":"Sanjay Pamphile to Magaran Shoulette, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1750969392,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"1","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12233348","event":"ball","batsman_id":"127133","bowler_id":"99744","over":"7","ball":"3","score":1,"commentary":"Sanjay Pamphile to Stephen Abraham, 1 run,","noball_dismissal":false,"text":"","timestamp":1750969395,"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":"12233350","event":"ball","batsman_id":"127001","bowler_id":"99744","over":"7","ball":"4","score":1,"commentary":"Sanjay Pamphile to Magaran Shoulette, 1 run,","noball_dismissal":false,"text":"","timestamp":1750969398,"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":"12233351","event":"ball","batsman_id":"127133","bowler_id":"99744","over":"7","ball":"5","score":6,"commentary":"Sanjay Pamphile to Stephen Abraham, Six,","noball_dismissal":false,"text":"","timestamp":1750969401,"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":"12233352","event":"ball","batsman_id":"127133","bowler_id":"99744","over":"7","ball":"6","score":2,"commentary":"Sanjay Pamphile to Stephen Abraham, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750969439,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":8,"runs":12,"score":"79\/3","bats":[{"runs":27,"balls_faced":15,"fours":0,"sixes":3,"batsman_id":127133},{"runs":6,"balls_faced":5,"fours":1,"sixes":0,"batsman_id":127001}],"bowls":[{"runs_conceded":11,"maidens":0,"wickets":0,"bowler_id":99744,"overs":1},{"runs_conceded":19,"maidens":0,"wickets":1,"bowler_id":107766,"overs":2}],"commentary":"End of over 8 (12 runs), Calabash Giants 79\/3"},{"event_id":"12233362","event":"ball","batsman_id":"127001","bowler_id":"99762","over":"8","ball":"1","score":0,"commentary":"Keon Gaston to Magaran Shoulette, no run,","noball_dismissal":false,"text":"","timestamp":1750969689,"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":"12233364","event":"ball","batsman_id":"127001","bowler_id":"99762","over":"8","ball":"2","score":1,"commentary":"Keon Gaston to Magaran Shoulette, 1 run,","noball_dismissal":false,"text":"","timestamp":1750969693,"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":"12233365","event":"ball","batsman_id":"127133","bowler_id":"99762","over":"8","ball":"3","score":4,"commentary":"Keon Gaston to Stephen Abraham, Four,","noball_dismissal":false,"text":"","timestamp":1750969697,"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":"12233369","event":"ball","batsman_id":"127133","bowler_id":"99762","over":"8","ball":"4","score":0,"commentary":"Keon Gaston to Stephen Abraham, no run,","noball_dismissal":false,"text":"","timestamp":1750969700,"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":"12233370","event":"ball","batsman_id":"127133","bowler_id":"99762","over":"8","ball":"5","score":0,"commentary":"Keon Gaston to Stephen Abraham, no run,","noball_dismissal":false,"text":"","timestamp":1750969704,"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":"12233372","event":"ball","batsman_id":"127133","bowler_id":"99762","over":"8","ball":"6","score":1,"commentary":"Keon Gaston to Stephen Abraham, 1 run,","noball_dismissal":false,"text":"","timestamp":1750969708,"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":9,"runs":6,"score":"85\/3","bats":[{"runs":32,"balls_faced":19,"fours":1,"sixes":3,"batsman_id":127133},{"runs":7,"balls_faced":7,"fours":1,"sixes":0,"batsman_id":127001}],"bowls":[{"runs_conceded":9,"maidens":0,"wickets":0,"bowler_id":99762,"overs":2},{"runs_conceded":11,"maidens":0,"wickets":0,"bowler_id":99744,"overs":1}],"commentary":"End of over 9 (6 runs), Calabash Giants 85\/3"},{"event_id":"12233378","event":"ball","batsman_id":"127133","bowler_id":"107676","over":"9","ball":"1","score":6,"commentary":"Kuston Jules to Stephen Abraham, Six,","noball_dismissal":false,"text":"","timestamp":1750969903,"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":"12233380","event":"ball","batsman_id":"127133","bowler_id":"107676","over":"9","ball":"2","score":1,"commentary":"Kuston Jules to Stephen Abraham, 1 run,","noball_dismissal":false,"text":"","timestamp":1750969907,"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":"12233382","event":"ball","batsman_id":"127001","bowler_id":"107676","over":"9","ball":"3","score":4,"commentary":"Kuston Jules to Magaran Shoulette, Four,","noball_dismissal":false,"text":"","timestamp":1750969911,"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":"12233388","event":"wicket","batsman_id":"127001","bowler_id":"107676","over":"9","ball":"4","score":"w","commentary":"Kuston Jules to Magaran Shoulette, no run, runout (K Jules),","noball_dismissal":false,"text":"","timestamp":1750969954,"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":"127001","how_out":"runout (K Jules)","batsman_runs":"11","batsman_balls":"9"},{"event_id":"12233394","event":"ball","batsman_id":"127133","bowler_id":"107676","over":"9","ball":"5","score":"1wd","commentary":"Kuston Jules to Stephen Abraham, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750970023,"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":"12233395","event":"ball","batsman_id":"127133","bowler_id":"107676","over":"9","ball":"5","score":1,"commentary":"Kuston Jules to Stephen Abraham, 1 run,","noball_dismissal":false,"text":"","timestamp":1750970026,"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":"12233397","event":"ball","batsman_id":"126998","bowler_id":"107676","over":"9","ball":"6","score":1,"commentary":"Kuston Jules to Cody Lesmond, 1 run,","noball_dismissal":false,"text":"","timestamp":1750970040,"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":10,"runs":14,"score":"99\/4","bats":[{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":126998},{"runs":40,"balls_faced":22,"fours":1,"sixes":4,"batsman_id":127133}],"bowls":[{"runs_conceded":26,"maidens":0,"wickets":0,"bowler_id":107676,"overs":2},{"runs_conceded":9,"maidens":0,"wickets":0,"bowler_id":99762,"overs":2}],"commentary":"End of over 10 (14 runs), Calabash Giants 99\/4"}],"day":"0","session":"0","live_inning":{"iid":198801,"number":2,"name":"Calabash Giants Inning","short_name":"CBG Inning","status":2,"issuperover":"false","result":4,"batting_team_id":129005,"fielding_team_id":129003,"scores":"99\/4","scores_full":"99\/4 (10 ov)","fielder":[{"fielder_id":"99744","fielder_name":"Sanjay Pamphile","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"150249","fielder_name":"Nathaniel Joseph","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"107676","fielder_name":"Kuston Jules","catches":0,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":1,"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":"Magaran Shoulette","batsman_id":"127001","runs":"11","balls":"9","how_out":"runout (K Jules)","score_at_dismissal":96,"overs_at_dismissal":"9.4","bowler_id":"0","dismissal":"runout","number":4},"extra_runs":{"byes":0,"legbyes":1,"wides":9,"noballs":0,"penalty":"0","total":10},"equations":{"runs":99,"wickets":4,"overs":"10","bowlers_used":6,"runrate":"9.90"},"current_partnership":{"runs":3,"balls":2,"overs":0.2,"batsmen":[{"name":"Stephen Abraham","batsman_id":127133,"runs":1,"balls":1},{"name":"Cody Lesmond","batsman_id":126998,"runs":1,"balls":1}]},"did_not_bat":[{"player_id":"99821","name":"David Naitram"},{"player_id":"52175","name":"Dornan Edward"},{"player_id":"116188","name":"Marklin Sylvester"},{"player_id":"99743","name":"Wayne Prospere"},{"player_id":"150063","name":"Alexus Charles"}],"max_over":"10","target":"121","recent_scores":"1,1,1,w,4,1,6,1,0,0,4,1,0,2,6,1,1,1","last_five_overs":"50\/3 9.38","last_ten_overs":"99\/4 9.14"},"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":"120\/6 (10 ov)","scores":"120\/6","overs":"10"},{"tid":129005,"title":"Calabash Giants","abbr":"CBG","alt_name":"Calabash Giants","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Calabash-Giants.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Calabash-Giants.png","country":"wi","sex":"male","team_owner":"","head_coach":"","scores_full":"99\/4 (10 ov)","scores":"99\/4","overs":"10"}],"players":[{"pid":52175,"title":"Dornan Edward","short_name":"DC Edward","first_name":"Dornan Edward","last_name":"","middle_name":"","birthdate":"1996-10-28","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":70012,"title":"Mervin Wells","short_name":"M Wells","first_name":"Mervin Wells","last_name":"","middle_name":"","birthdate":"1987-01-16","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","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":6.5,"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":"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":"","bowling_type":"","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":"","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":99743,"title":"Wayne Prospere","short_name":"W Prospere","first_name":"Wayne Prospere","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":"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.5,"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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":"(C)"},{"pid":99764,"title":"Sadrack Descartes","short_name":"S Descartes","first_name":"Sadrack Descartes","last_name":"","middle_name":"","birthdate":"1997-10-19","birthplace":"Cheshire","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left 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":"all","role_str":"(C)"},{"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":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":99821,"title":"David Naitram","short_name":"D Naitram","first_name":"David Naitram","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":107712,"title":"Kurt Edward","short_name":"K Edward","first_name":"Kurt 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":"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":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":115903,"title":"Josan James","short_name":"J James","first_name":"Josan James","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":116188,"title":"Marklin Sylvester","short_name":"M Sylvester","first_name":"Marklin Sylvester","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":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":126998,"title":"Cody Lesmond","short_name":"Cody Lesmond","first_name":"Cody Lesmond","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":127001,"title":"Magaran Shoulette","short_name":"M Shoulette","first_name":"Magaran Shoulette","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":""},{"pid":127132,"title":"Caleb Thomas","short_name":"C Thomas","first_name":"Caleb Thomas","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":""},{"pid":127133,"title":"Stephen Abraham","short_name":"S Abraham","first_name":"Stephen Abraham","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":"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":"bowl","role_str":""},{"pid":138227,"title":"Bjorn Fanus","short_name":"B Fanus","first_name":"Bjorn Fanus","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":"squad","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":"","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":150063,"title":"Alexus Charles","short_name":"AX Charles","first_name":"Alexus Charles","last_name":"","middle_name":"","birthdate":"2006-05-31","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":150064,"title":"Denzie JnPaul","short_name":"DZ JnPaul","first_name":"Denzie JnPaul","last_name":"","middle_name":"","birthdate":"2007-11-18","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":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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""}]},"etag":"c33bf64ffc379deaf508e0187b0ebc07","modified":"2025-07-08 15:17:57","datetime":"2025-07-08 15:17:57","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90940 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:366962fa-f28e-4e02-a9e8-640d053314b7
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90940 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90940,3,'{"status":"ok","response":{"match_id":90940,"title":"Piton Stickers vs Calabash Giants","short_title":"PTS vs CBG","subtitle":"Match 6","match_number":"6","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Piton Stickers won by 21 runs","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":"120\/6 (10 ov)","scores":"120\/6","overs":"10"},"teamb":{"team_id":129005,"name":"Calabash Giants","short_name":"CBG","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Calabash-Giants.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Calabash-Giants.png","scores_full":"99\/4 (10 ov)","scores":"99\/4","overs":"10"},"date_start":"2025-06-26 18:30:00","date_end":"2025-06-27 04:30:00","timestamp_start":1750962600,"timestamp_end":1750998600,"date_start_ist":"2025-06-27 00:00:00","date_end_ist":"2025-06-27 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 21 runs","result_type":1,"win_margin":"21 runs","winning_team_id":129003,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-25 21:41:42","verify_time":"2025-06-27 02:29:48","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":27.61,"humidity":72,"visibility":10000,"wind_speed":"14.63","clouds":100},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Calabash Giants elected to bowl","winner":129005,"decision":2}},"etag":"c6384362e8860b5d0a495b3600f28b74","modified":"2025-07-08 15:17:58","datetime":"2025-07-08 15:17:58","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90940,"title":"Piton Stickers vs Calabash Giants","short_title":"PTS vs CBG","subtitle":"Match 6","match_number":"6","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Piton Stickers won by 21 runs","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":"120\/6 (10 ov)","scores":"120\/6","overs":"10"},"teamb":{"team_id":129005,"name":"Calabash Giants","short_name":"CBG","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Calabash-Giants.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Calabash-Giants.png","scores_full":"99\/4 (10 ov)","scores":"99\/4","overs":"10"},"date_start":"2025-06-26 18:30:00","date_end":"2025-06-27 04:30:00","timestamp_start":1750962600,"timestamp_end":1750998600,"date_start_ist":"2025-06-27 00:00:00","date_end_ist":"2025-06-27 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 21 runs","result_type":1,"win_margin":"21 runs","winning_team_id":129003,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-25 21:41:42","verify_time":"2025-06-27 02:29:48","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":27.61,"humidity":72,"visibility":10000,"wind_speed":"14.63","clouds":100},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Calabash Giants elected to bowl","winner":129005,"decision":2}},"etag":"c6384362e8860b5d0a495b3600f28b74","modified":"2025-07-08 15:17:58","datetime":"2025-07-08 15:17:58","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90940 AND DataTypeId = 3 END Live Report & Scorecard of Piton Stickers vs Calabash Giants Match 6
Piton Stickers vs Calabash Giants, Live Cricket Commentary