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:79207a06-2162-4eed-b6cc-cbec3c42b2fa
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90943 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90943,1,'{"status":"ok","response":{"mid":90943,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Amazonian Warriors won by 10 wickets","day_remaining_over":"","team_batting":"Amazonian Warriors","team_bowling":"Piton Stickers","live_inning_number":2,"live_score":{"runs":57,"overs":3.1,"wickets":0,"target":54,"runrate":18,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Dane Edward","batsman_id":99805,"runs":11,"balls_faced":8,"fours":2,"sixes":0,"strike_rate":"137.50"},{"name":"Johnnel Eugene","batsman_id":52283,"runs":42,"balls_faced":11,"fours":2,"sixes":5,"strike_rate":"381.82"}],"bowlers":[{"name":"Keon Gaston","bowler_id":99762,"overs":0.1,"runs_conceded":4,"wickets":0,"maidens":0,"econ":"24.00"},{"name":"Yunieski Gustave","bowler_id":150060,"overs":1,"runs_conceded":25,"wickets":0,"maidens":0,"econ":"25.00"}],"commentaries":[{"event_id":"12242022","event":"ball","batsman_id":"99805","bowler_id":"107676","over":"0","ball":"1","score":"1wd","commentary":"Kuston Jules to Dane Edward, 1 wide,","noball_dismissal":false,"text":"","timestamp":1751131466,"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":"12242023","event":"ball","batsman_id":"99805","bowler_id":"107676","over":"0","ball":"1","score":0,"commentary":"Kuston Jules to Dane Edward, no run,","noball_dismissal":false,"text":"","timestamp":1751131471,"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":"12242024","event":"ball","batsman_id":"99805","bowler_id":"107676","over":"0","ball":"2","score":0,"commentary":"Kuston Jules to Dane Edward, no run,","noball_dismissal":false,"text":"","timestamp":1751131485,"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":"12242026","event":"ball","batsman_id":"99805","bowler_id":"107676","over":"0","ball":"3","score":0,"commentary":"Kuston Jules to Dane Edward, no run,","noball_dismissal":false,"text":"","timestamp":1751131513,"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":"12242028","event":"ball","batsman_id":"99805","bowler_id":"107676","over":"0","ball":"4","score":"1wd","commentary":"Kuston Jules to Dane Edward, 1 wide,","noball_dismissal":false,"text":"","timestamp":1751131618,"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":"12242030","event":"ball","batsman_id":"99805","bowler_id":"107676","over":"0","ball":"4","score":"1wd","commentary":"Kuston Jules to Dane Edward, 1 wide,","noball_dismissal":false,"text":"","timestamp":1751131621,"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":"12242032","event":"ball","batsman_id":"99805","bowler_id":"107676","over":"0","ball":"4","score":1,"commentary":"Kuston Jules to Dane Edward, 1 run,","noball_dismissal":false,"text":"","timestamp":1751131626,"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":"12242033","event":"ball","batsman_id":"52283","bowler_id":"107676","over":"0","ball":"5","score":0,"commentary":"Kuston Jules to Johnnel Eugene, no run,","noball_dismissal":false,"text":"","timestamp":1751131670,"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":"12242037","event":"ball","batsman_id":"52283","bowler_id":"107676","over":"0","ball":"6","score":1,"commentary":"Kuston Jules to Johnnel Eugene, 1 run,","noball_dismissal":false,"text":"","timestamp":1751131713,"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":1,"runs":5,"score":"5\/0","bats":[{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":52283},{"runs":1,"balls_faced":4,"fours":0,"sixes":0,"batsman_id":99805}],"bowls":[{"runs_conceded":5,"maidens":0,"wickets":0,"bowler_id":107676,"overs":1}],"commentary":"End of over 1 (5 runs), Amazonian Warriors 5\/0"},{"event_id":"12242043","event":"ball","batsman_id":"52283","bowler_id":"150249","over":"1","ball":"1","score":"1wd","commentary":"Nathaniel Joseph to Johnnel Eugene, 1 wide,","noball_dismissal":false,"text":"","timestamp":1751131823,"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":"12242045","event":"ball","batsman_id":"52283","bowler_id":"150249","over":"1","ball":"1","score":6,"commentary":"Nathaniel Joseph to Johnnel Eugene, Six,","noball_dismissal":false,"text":"","timestamp":1751131883,"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":"12242048","event":"ball","batsman_id":"52283","bowler_id":"150249","over":"1","ball":"2","score":6,"commentary":"Nathaniel Joseph to Johnnel Eugene, Six,","noball_dismissal":false,"text":"","timestamp":1751131886,"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":"12242050","event":"ball","batsman_id":"52283","bowler_id":"150249","over":"1","ball":"3","score":1,"commentary":"Nathaniel Joseph to Johnnel Eugene, 1 run,","noball_dismissal":false,"text":"","timestamp":1751131933,"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":"12242053","event":"ball","batsman_id":"99805","bowler_id":"150249","over":"1","ball":"4","score":4,"commentary":"Nathaniel Joseph to Dane Edward, Four,","noball_dismissal":false,"text":"","timestamp":1751131964,"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":"12242059","event":"ball","batsman_id":"99805","bowler_id":"150249","over":"1","ball":"5","score":1,"commentary":"Nathaniel Joseph to Dane Edward, 1 run,","noball_dismissal":false,"text":"","timestamp":1751132004,"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":"12242064","event":"ball","batsman_id":"52283","bowler_id":"150249","over":"1","ball":"6","score":4,"commentary":"Nathaniel Joseph to Johnnel Eugene, Four,","noball_dismissal":false,"text":"","timestamp":1751132034,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event":"overend","over":2,"runs":23,"score":"28\/0","bats":[{"runs":18,"balls_faced":6,"fours":1,"sixes":2,"batsman_id":52283},{"runs":6,"balls_faced":6,"fours":1,"sixes":0,"batsman_id":99805}],"bowls":[{"runs_conceded":23,"maidens":0,"wickets":0,"bowler_id":150249,"overs":1},{"runs_conceded":5,"maidens":0,"wickets":0,"bowler_id":107676,"overs":1}],"commentary":"End of over 2 (23 runs), Amazonian Warriors 28\/0"},{"event_id":"12242072","event":"ball","batsman_id":"99805","bowler_id":"150060","over":"2","ball":"1","score":1,"commentary":"Yunieski Gustave to Dane Edward, 1 run,","noball_dismissal":false,"text":"","timestamp":1751132205,"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":"12242073","event":"ball","batsman_id":"52283","bowler_id":"150060","over":"2","ball":"2","score":6,"commentary":"Yunieski Gustave to Johnnel Eugene, Six,","noball_dismissal":false,"text":"","timestamp":1751132208,"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":"12242077","event":"ball","batsman_id":"52283","bowler_id":"150060","over":"2","ball":"3","score":6,"commentary":"Yunieski Gustave to Johnnel Eugene, Six,","noball_dismissal":false,"text":"","timestamp":1751132211,"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":"12242080","event":"ball","batsman_id":"52283","bowler_id":"150060","over":"2","ball":"4","score":6,"commentary":"Yunieski Gustave to Johnnel Eugene, Six,","noball_dismissal":false,"text":"","timestamp":1751132237,"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":"12242084","event":"ball","batsman_id":"52283","bowler_id":"150060","over":"2","ball":"5","score":2,"commentary":"Yunieski Gustave to Johnnel Eugene, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751132312,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12242086","event":"ball","batsman_id":"52283","bowler_id":"150060","over":"2","ball":"6","score":4,"commentary":"Yunieski Gustave to Johnnel Eugene, Four,","noball_dismissal":false,"text":"","timestamp":1751132316,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event":"overend","over":3,"runs":25,"score":"53\/0","bats":[{"runs":42,"balls_faced":11,"fours":2,"sixes":5,"batsman_id":52283},{"runs":7,"balls_faced":7,"fours":1,"sixes":0,"batsman_id":99805}],"bowls":[{"runs_conceded":25,"maidens":0,"wickets":0,"bowler_id":150060,"overs":1},{"runs_conceded":23,"maidens":0,"wickets":0,"bowler_id":150249,"overs":1}],"commentary":"End of over 3 (25 runs), Amazonian Warriors 53\/0"},{"event_id":"12242094","event":"ball","batsman_id":"99805","bowler_id":"99762","over":"3","ball":"1","score":4,"commentary":"Keon Gaston to Dane Edward, Four,","noball_dismissal":false,"text":"","timestamp":1751132433,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false}],"day":"0","session":"0","live_inning":{"iid":198880,"number":2,"name":"Amazonian Warriors Inning","short_name":"AMW Inning","status":2,"issuperover":"false","result":3,"batting_team_id":129002,"fielding_team_id":129003,"scores":"57\/0","scores_full":"57\/0 (3.1 ov)","fielder":[],"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":[],"extra_runs":{"byes":0,"legbyes":0,"wides":4,"noballs":0,"penalty":"0","total":4},"equations":{"runs":57,"wickets":0,"overs":"3.1","bowlers_used":4,"runrate":"18.00"},"current_partnership":{"runs":57,"balls":19,"overs":3.1,"batsmen":[{"name":"Dane Edward","batsman_id":99805,"runs":11,"balls":8},{"name":"Johnnel Eugene","batsman_id":52283,"runs":42,"balls":11}]},"did_not_bat":[{"player_id":"127130","name":"Alex Joseph"},{"player_id":"107768","name":"Rohan Lesmond"},{"player_id":"138276","name":"Tyler Venner"},{"player_id":"100065","name":"Murlan Sammy"},{"player_id":"99779","name":"Antoine Zayee"},{"player_id":"92688","name":"Alleyn Prospere"},{"player_id":"99795","name":"Jaden Elibox"},{"player_id":"100050","name":"Kester Charlermagne"},{"player_id":"116473","name":"Joshua Cepal"}],"max_over":"5","target":"54","recent_scores":"4,4,2,6,6,6,1,4,1,4,1,6,6,1,1,0,1,1","last_five_overs":"57\/0 14.87","last_ten_overs":"57\/0 14.87"},"teams":[{"tid":129002,"title":"Amazonian Warriors","abbr":"AMW","alt_name":"Amazonian Warriors","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Amazonian-Warriors.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Amazonian-Warriors.png","country":"wi","sex":"male","team_owner":"","head_coach":"","scores_full":"57\/0 (3.1 ov)","scores":"57\/0","overs":"3.1"},{"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":"53\/6 (5 ov)","scores":"53\/6","overs":"5"}],"players":[{"pid":52283,"title":"Johnnel Eugene","short_name":"J Eugene","first_name":"Johnnel Eugene","last_name":"","middle_name":"","birthdate":"1999-09-15","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","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":"all","role_str":""},{"pid":92688,"title":"Alleyn Prospere","short_name":"A Prospere","first_name":"Alleyn Prospere","last_name":"","middle_name":"","birthdate":"1979-10-10","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":99721,"title":"Jason Simon","short_name":"J Simon","first_name":"Jason Simon","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":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":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":99779,"title":"Antoine Zayee","short_name":"A Zayee","first_name":"Antoine Zayee","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":99788,"title":"Ackeem Auguste","short_name":"A Auguste","first_name":"Ackeem Auguste","last_name":"","middle_name":"","birthdate":"2003-09-12","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":99795,"title":"Jaden Elibox","short_name":"J Elibox","first_name":"Jaden Elibox","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":99805,"title":"Dane Edward","short_name":"D Edward","first_name":"Dane Edward","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":100050,"title":"Kester Charlermagne","short_name":"K Charlermagne","first_name":"Kester Charlermagne","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","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":"bowl","role_str":"(C)"},{"pid":100065,"title":"Murlan Sammy","short_name":"M Sammy","first_name":"Murlan Sammy","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","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":107750,"title":"Royce Paul","short_name":"R Paul","first_name":"Royce Paul","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":107766,"title":"Christian Charlery","short_name":"C Charlery","first_name":"Christian Charlery","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":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":107768,"title":"Rohan Lesmond","short_name":"R Lesmond","first_name":"Rohan Lesmond","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":116100,"title":"Dexter Solomon","short_name":"D Solomon","first_name":"Dexter Solomon","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":116473,"title":"Joshua Cepal","short_name":"J Cepal","first_name":"Joshua Cepal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":126997,"title":"Cody Fontinelle","short_name":"C Fontinelle","first_name":"Cody Fontinelle","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":127130,"title":"Alex Joseph","short_name":"A Joseph","first_name":"Alex Joseph","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(WK)"},{"pid":128590,"title":"Jermaine thomas","short_name":"J thomas","first_name":"Jermaine thomas","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":138228,"title":"Isiah Jones","short_name":"I Jones","first_name":"Isiah Jones","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":138273,"title":"Renee Jones","short_name":"R Jones","first_name":"Renee Jones","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":138276,"title":"Tyler Venner","short_name":"T Venner","first_name":"Tyler Venner","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":150059,"title":"Jeanille Williams","short_name":"JN Williams","first_name":"Jeanille Williams","last_name":"","middle_name":"","birthdate":"2009-10-04","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":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":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":"c49f9a63c1cd98dbd7b360c114124de0","modified":"2025-07-07 10:08:42","datetime":"2025-07-07 10:08:42","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":90943,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Amazonian Warriors won by 10 wickets","day_remaining_over":"","team_batting":"Amazonian Warriors","team_bowling":"Piton Stickers","live_inning_number":2,"live_score":{"runs":57,"overs":3.1,"wickets":0,"target":54,"runrate":18,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Dane Edward","batsman_id":99805,"runs":11,"balls_faced":8,"fours":2,"sixes":0,"strike_rate":"137.50"},{"name":"Johnnel Eugene","batsman_id":52283,"runs":42,"balls_faced":11,"fours":2,"sixes":5,"strike_rate":"381.82"}],"bowlers":[{"name":"Keon Gaston","bowler_id":99762,"overs":0.1,"runs_conceded":4,"wickets":0,"maidens":0,"econ":"24.00"},{"name":"Yunieski Gustave","bowler_id":150060,"overs":1,"runs_conceded":25,"wickets":0,"maidens":0,"econ":"25.00"}],"commentaries":[{"event_id":"12242022","event":"ball","batsman_id":"99805","bowler_id":"107676","over":"0","ball":"1","score":"1wd","commentary":"Kuston Jules to Dane Edward, 1 wide,","noball_dismissal":false,"text":"","timestamp":1751131466,"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":"12242023","event":"ball","batsman_id":"99805","bowler_id":"107676","over":"0","ball":"1","score":0,"commentary":"Kuston Jules to Dane Edward, no run,","noball_dismissal":false,"text":"","timestamp":1751131471,"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":"12242024","event":"ball","batsman_id":"99805","bowler_id":"107676","over":"0","ball":"2","score":0,"commentary":"Kuston Jules to Dane Edward, no run,","noball_dismissal":false,"text":"","timestamp":1751131485,"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":"12242026","event":"ball","batsman_id":"99805","bowler_id":"107676","over":"0","ball":"3","score":0,"commentary":"Kuston Jules to Dane Edward, no run,","noball_dismissal":false,"text":"","timestamp":1751131513,"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":"12242028","event":"ball","batsman_id":"99805","bowler_id":"107676","over":"0","ball":"4","score":"1wd","commentary":"Kuston Jules to Dane Edward, 1 wide,","noball_dismissal":false,"text":"","timestamp":1751131618,"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":"12242030","event":"ball","batsman_id":"99805","bowler_id":"107676","over":"0","ball":"4","score":"1wd","commentary":"Kuston Jules to Dane Edward, 1 wide,","noball_dismissal":false,"text":"","timestamp":1751131621,"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":"12242032","event":"ball","batsman_id":"99805","bowler_id":"107676","over":"0","ball":"4","score":1,"commentary":"Kuston Jules to Dane Edward, 1 run,","noball_dismissal":false,"text":"","timestamp":1751131626,"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":"12242033","event":"ball","batsman_id":"52283","bowler_id":"107676","over":"0","ball":"5","score":0,"commentary":"Kuston Jules to Johnnel Eugene, no run,","noball_dismissal":false,"text":"","timestamp":1751131670,"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":"12242037","event":"ball","batsman_id":"52283","bowler_id":"107676","over":"0","ball":"6","score":1,"commentary":"Kuston Jules to Johnnel Eugene, 1 run,","noball_dismissal":false,"text":"","timestamp":1751131713,"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":1,"runs":5,"score":"5\/0","bats":[{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":52283},{"runs":1,"balls_faced":4,"fours":0,"sixes":0,"batsman_id":99805}],"bowls":[{"runs_conceded":5,"maidens":0,"wickets":0,"bowler_id":107676,"overs":1}],"commentary":"End of over 1 (5 runs), Amazonian Warriors 5\/0"},{"event_id":"12242043","event":"ball","batsman_id":"52283","bowler_id":"150249","over":"1","ball":"1","score":"1wd","commentary":"Nathaniel Joseph to Johnnel Eugene, 1 wide,","noball_dismissal":false,"text":"","timestamp":1751131823,"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":"12242045","event":"ball","batsman_id":"52283","bowler_id":"150249","over":"1","ball":"1","score":6,"commentary":"Nathaniel Joseph to Johnnel Eugene, Six,","noball_dismissal":false,"text":"","timestamp":1751131883,"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":"12242048","event":"ball","batsman_id":"52283","bowler_id":"150249","over":"1","ball":"2","score":6,"commentary":"Nathaniel Joseph to Johnnel Eugene, Six,","noball_dismissal":false,"text":"","timestamp":1751131886,"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":"12242050","event":"ball","batsman_id":"52283","bowler_id":"150249","over":"1","ball":"3","score":1,"commentary":"Nathaniel Joseph to Johnnel Eugene, 1 run,","noball_dismissal":false,"text":"","timestamp":1751131933,"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":"12242053","event":"ball","batsman_id":"99805","bowler_id":"150249","over":"1","ball":"4","score":4,"commentary":"Nathaniel Joseph to Dane Edward, Four,","noball_dismissal":false,"text":"","timestamp":1751131964,"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":"12242059","event":"ball","batsman_id":"99805","bowler_id":"150249","over":"1","ball":"5","score":1,"commentary":"Nathaniel Joseph to Dane Edward, 1 run,","noball_dismissal":false,"text":"","timestamp":1751132004,"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":"12242064","event":"ball","batsman_id":"52283","bowler_id":"150249","over":"1","ball":"6","score":4,"commentary":"Nathaniel Joseph to Johnnel Eugene, Four,","noball_dismissal":false,"text":"","timestamp":1751132034,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event":"overend","over":2,"runs":23,"score":"28\/0","bats":[{"runs":18,"balls_faced":6,"fours":1,"sixes":2,"batsman_id":52283},{"runs":6,"balls_faced":6,"fours":1,"sixes":0,"batsman_id":99805}],"bowls":[{"runs_conceded":23,"maidens":0,"wickets":0,"bowler_id":150249,"overs":1},{"runs_conceded":5,"maidens":0,"wickets":0,"bowler_id":107676,"overs":1}],"commentary":"End of over 2 (23 runs), Amazonian Warriors 28\/0"},{"event_id":"12242072","event":"ball","batsman_id":"99805","bowler_id":"150060","over":"2","ball":"1","score":1,"commentary":"Yunieski Gustave to Dane Edward, 1 run,","noball_dismissal":false,"text":"","timestamp":1751132205,"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":"12242073","event":"ball","batsman_id":"52283","bowler_id":"150060","over":"2","ball":"2","score":6,"commentary":"Yunieski Gustave to Johnnel Eugene, Six,","noball_dismissal":false,"text":"","timestamp":1751132208,"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":"12242077","event":"ball","batsman_id":"52283","bowler_id":"150060","over":"2","ball":"3","score":6,"commentary":"Yunieski Gustave to Johnnel Eugene, Six,","noball_dismissal":false,"text":"","timestamp":1751132211,"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":"12242080","event":"ball","batsman_id":"52283","bowler_id":"150060","over":"2","ball":"4","score":6,"commentary":"Yunieski Gustave to Johnnel Eugene, Six,","noball_dismissal":false,"text":"","timestamp":1751132237,"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":"12242084","event":"ball","batsman_id":"52283","bowler_id":"150060","over":"2","ball":"5","score":2,"commentary":"Yunieski Gustave to Johnnel Eugene, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751132312,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12242086","event":"ball","batsman_id":"52283","bowler_id":"150060","over":"2","ball":"6","score":4,"commentary":"Yunieski Gustave to Johnnel Eugene, Four,","noball_dismissal":false,"text":"","timestamp":1751132316,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event":"overend","over":3,"runs":25,"score":"53\/0","bats":[{"runs":42,"balls_faced":11,"fours":2,"sixes":5,"batsman_id":52283},{"runs":7,"balls_faced":7,"fours":1,"sixes":0,"batsman_id":99805}],"bowls":[{"runs_conceded":25,"maidens":0,"wickets":0,"bowler_id":150060,"overs":1},{"runs_conceded":23,"maidens":0,"wickets":0,"bowler_id":150249,"overs":1}],"commentary":"End of over 3 (25 runs), Amazonian Warriors 53\/0"},{"event_id":"12242094","event":"ball","batsman_id":"99805","bowler_id":"99762","over":"3","ball":"1","score":4,"commentary":"Keon Gaston to Dane Edward, Four,","noball_dismissal":false,"text":"","timestamp":1751132433,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false}],"day":"0","session":"0","live_inning":{"iid":198880,"number":2,"name":"Amazonian Warriors Inning","short_name":"AMW Inning","status":2,"issuperover":"false","result":3,"batting_team_id":129002,"fielding_team_id":129003,"scores":"57\/0","scores_full":"57\/0 (3.1 ov)","fielder":[],"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":[],"extra_runs":{"byes":0,"legbyes":0,"wides":4,"noballs":0,"penalty":"0","total":4},"equations":{"runs":57,"wickets":0,"overs":"3.1","bowlers_used":4,"runrate":"18.00"},"current_partnership":{"runs":57,"balls":19,"overs":3.1,"batsmen":[{"name":"Dane Edward","batsman_id":99805,"runs":11,"balls":8},{"name":"Johnnel Eugene","batsman_id":52283,"runs":42,"balls":11}]},"did_not_bat":[{"player_id":"127130","name":"Alex Joseph"},{"player_id":"107768","name":"Rohan Lesmond"},{"player_id":"138276","name":"Tyler Venner"},{"player_id":"100065","name":"Murlan Sammy"},{"player_id":"99779","name":"Antoine Zayee"},{"player_id":"92688","name":"Alleyn Prospere"},{"player_id":"99795","name":"Jaden Elibox"},{"player_id":"100050","name":"Kester Charlermagne"},{"player_id":"116473","name":"Joshua Cepal"}],"max_over":"5","target":"54","recent_scores":"4,4,2,6,6,6,1,4,1,4,1,6,6,1,1,0,1,1","last_five_overs":"57\/0 14.87","last_ten_overs":"57\/0 14.87"},"teams":[{"tid":129002,"title":"Amazonian Warriors","abbr":"AMW","alt_name":"Amazonian Warriors","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Amazonian-Warriors.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Amazonian-Warriors.png","country":"wi","sex":"male","team_owner":"","head_coach":"","scores_full":"57\/0 (3.1 ov)","scores":"57\/0","overs":"3.1"},{"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":"53\/6 (5 ov)","scores":"53\/6","overs":"5"}],"players":[{"pid":52283,"title":"Johnnel Eugene","short_name":"J Eugene","first_name":"Johnnel Eugene","last_name":"","middle_name":"","birthdate":"1999-09-15","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","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":"all","role_str":""},{"pid":92688,"title":"Alleyn Prospere","short_name":"A Prospere","first_name":"Alleyn Prospere","last_name":"","middle_name":"","birthdate":"1979-10-10","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":99721,"title":"Jason Simon","short_name":"J Simon","first_name":"Jason Simon","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":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":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":99779,"title":"Antoine Zayee","short_name":"A Zayee","first_name":"Antoine Zayee","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":99788,"title":"Ackeem Auguste","short_name":"A Auguste","first_name":"Ackeem Auguste","last_name":"","middle_name":"","birthdate":"2003-09-12","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":99795,"title":"Jaden Elibox","short_name":"J Elibox","first_name":"Jaden Elibox","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":99805,"title":"Dane Edward","short_name":"D Edward","first_name":"Dane Edward","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":100050,"title":"Kester Charlermagne","short_name":"K Charlermagne","first_name":"Kester Charlermagne","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","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":"bowl","role_str":"(C)"},{"pid":100065,"title":"Murlan Sammy","short_name":"M Sammy","first_name":"Murlan Sammy","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","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":107750,"title":"Royce Paul","short_name":"R Paul","first_name":"Royce Paul","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":107766,"title":"Christian Charlery","short_name":"C Charlery","first_name":"Christian Charlery","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":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":107768,"title":"Rohan Lesmond","short_name":"R Lesmond","first_name":"Rohan Lesmond","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":116100,"title":"Dexter Solomon","short_name":"D Solomon","first_name":"Dexter Solomon","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":116473,"title":"Joshua Cepal","short_name":"J Cepal","first_name":"Joshua Cepal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":126997,"title":"Cody Fontinelle","short_name":"C Fontinelle","first_name":"Cody Fontinelle","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":127130,"title":"Alex Joseph","short_name":"A Joseph","first_name":"Alex Joseph","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(WK)"},{"pid":128590,"title":"Jermaine thomas","short_name":"J thomas","first_name":"Jermaine thomas","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":138228,"title":"Isiah Jones","short_name":"I Jones","first_name":"Isiah Jones","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":138273,"title":"Renee Jones","short_name":"R Jones","first_name":"Renee Jones","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":138276,"title":"Tyler Venner","short_name":"T Venner","first_name":"Tyler Venner","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":150059,"title":"Jeanille Williams","short_name":"JN Williams","first_name":"Jeanille Williams","last_name":"","middle_name":"","birthdate":"2009-10-04","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":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":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":"c49f9a63c1cd98dbd7b360c114124de0","modified":"2025-07-07 10:08:42","datetime":"2025-07-07 10:08:42","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90943 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:79207a06-2162-4eed-b6cc-cbec3c42b2fa
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90943 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90943,3,'{"status":"ok","response":{"match_id":90943,"title":"Piton Stickers vs Amazonian Warriors","short_title":"PTS vs AMW","subtitle":"Match 9","match_number":"9","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Amazonian Warriors won by 10 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":"53\/6 (5 ov)","scores":"53\/6","overs":"5"},"teamb":{"team_id":129002,"name":"Amazonian Warriors","short_name":"AMW","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Amazonian-Warriors.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Amazonian-Warriors.png","scores_full":"57\/0 (3.1 ov)","scores":"57\/0","overs":"3.1"},"date_start":"2025-06-28 16:00:00","date_end":"2025-06-29 02:00:00","timestamp_start":1751126400,"timestamp_end":1751162400,"date_start_ist":"2025-06-28 21:30:00","date_end_ist":"2025-06-29 07:30:00","venue":{"venue_id":"85","name":"Daren Sammy National Cricket Stadium, St Lucia","location":"Gros Islet","country":"West Indies","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"AMW won by 10 wickets","result_type":2,"win_margin":"10 wickets","winning_team_id":129002,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-27 01:54:07","verify_time":"2025-06-28 23:26:16","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Rain","weather_desc":"light rain","temp":27.41,"humidity":81,"visibility":10000,"wind_speed":"17.83","clouds":97},"pitch":{"pitch_condition":"","batting_condition":"Average","pace_bowling_condition":"Average","spine_bowling_condition":"Average"},"toss":{"text":"Amazonian Warriors elected to bowl","winner":129002,"decision":2}},"etag":"4b6c619e7274c200a8393ba08660efa3","modified":"2025-07-07 10:08:43","datetime":"2025-07-07 10:08:43","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90943,"title":"Piton Stickers vs Amazonian Warriors","short_title":"PTS vs AMW","subtitle":"Match 9","match_number":"9","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Amazonian Warriors won by 10 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":"53\/6 (5 ov)","scores":"53\/6","overs":"5"},"teamb":{"team_id":129002,"name":"Amazonian Warriors","short_name":"AMW","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Amazonian-Warriors.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Amazonian-Warriors.png","scores_full":"57\/0 (3.1 ov)","scores":"57\/0","overs":"3.1"},"date_start":"2025-06-28 16:00:00","date_end":"2025-06-29 02:00:00","timestamp_start":1751126400,"timestamp_end":1751162400,"date_start_ist":"2025-06-28 21:30:00","date_end_ist":"2025-06-29 07:30:00","venue":{"venue_id":"85","name":"Daren Sammy National Cricket Stadium, St Lucia","location":"Gros Islet","country":"West Indies","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"AMW won by 10 wickets","result_type":2,"win_margin":"10 wickets","winning_team_id":129002,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-27 01:54:07","verify_time":"2025-06-28 23:26:16","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Rain","weather_desc":"light rain","temp":27.41,"humidity":81,"visibility":10000,"wind_speed":"17.83","clouds":97},"pitch":{"pitch_condition":"","batting_condition":"Average","pace_bowling_condition":"Average","spine_bowling_condition":"Average"},"toss":{"text":"Amazonian Warriors elected to bowl","winner":129002,"decision":2}},"etag":"4b6c619e7274c200a8393ba08660efa3","modified":"2025-07-07 10:08:43","datetime":"2025-07-07 10:08:43","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90943 AND DataTypeId = 3 END Live Report & Scorecard of Piton Stickers vs Amazonian Warriors Match 9
Piton Stickers vs Amazonian Warriors, Live Cricket Commentary