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:f7db7ab0-74a2-4f8a-926f-bcf9626df3a5 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90963 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90963,1,'{"status":"ok","response":{"mid":90963,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Iyanola Heritage won by superover","day_remaining_over":"","team_batting":"Bamboo Blasters","team_bowling":"Iyanola Heritage","live_inning_number":4,"live_score":{"runs":1,"overs":0.3,"wickets":2,"target":10,"runrate":2,"required_runrate":18},"commentary":1,"wagon":2,"batsmen":[{"name":"Noelle Leo","batsman_id":100041,"runs":0,"balls_faced":1,"fours":0,"sixes":0,"strike_rate":"0.00"},{"name":"Kyle Adonis","batsman_id":107729,"runs":1,"balls_faced":1,"fours":0,"sixes":0,"strike_rate":"100.00"}],"bowlers":[{"name":"Xavier Gabriel","bowler_id":92689,"overs":0.3,"runs_conceded":1,"wickets":2,"maidens":0,"econ":"2.00"}],"commentaries":[{"event_id":"12268384","event":"wicket","batsman_id":"99786","bowler_id":"92689","over":"0","ball":"1","score":"w","commentary":"Xavier Gabriel to Stephen Naitram, no run, c & b Xavier Gabriel,","noball_dismissal":false,"text":"","timestamp":1751407160,"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":"99786","how_out":"c & b Xavier Gabriel","batsman_runs":"0","batsman_balls":"1"},{"event_id":"12268385","event":"ball","batsman_id":"107729","bowler_id":"92689","over":"0","ball":"2","score":1,"commentary":"Xavier Gabriel to Kyle Adonis, 1 run,","noball_dismissal":false,"text":"","timestamp":1751407173,"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":"12268386","event":"wicket","batsman_id":"100041","bowler_id":"92689","over":"0","ball":"3","score":"w","commentary":"Xavier Gabriel to Noelle Leo, no run, c & b Xavier Gabriel,","noball_dismissal":false,"text":"","timestamp":1751407190,"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":"100041","how_out":"c & b Xavier Gabriel","batsman_runs":"0","batsman_balls":"1"}],"day":"0","session":"0","live_inning":{"iid":199009,"number":4,"name":"Bamboo Blasters Inning","short_name":"BMB Inning","status":2,"issuperover":"true","result":1,"batting_team_id":129006,"fielding_team_id":129001,"scores":"1\/2","scores_full":"1\/2 (0.3 ov)","fielder":[{"fielder_id":"92689","fielder_name":"Xavier Gabriel","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":[],"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Noelle Leo","batsman_id":"100041","runs":"0","balls":"1","how_out":"c & b Xavier Gabriel","score_at_dismissal":1,"overs_at_dismissal":"0.3","bowler_id":"92689","dismissal":"caught","number":2},"extra_runs":{"byes":0,"legbyes":0,"wides":0,"noballs":0,"penalty":"0","total":0},"equations":{"runs":1,"wickets":2,"overs":"0.3","bowlers_used":1,"runrate":"2.00"},"current_partnership":{"runs":1,"balls":2,"overs":0.2,"batsmen":[{"name":"Kyle Adonis","batsman_id":107729,"runs":1,"balls":1},{"name":"Noelle Leo","batsman_id":100041,"runs":0,"balls":1}]},"did_not_bat":[{"player_id":"107730","name":"Qwaine Henry"},{"player_id":"100039","name":"Shervon Joseph"},{"player_id":"107702","name":"Khan Elcock"},{"player_id":"150062","name":"Mateo Boulogne"},{"player_id":"99739","name":"Kevin Gassie"},{"player_id":"99791","name":"Keygan Arnold"},{"player_id":"99732","name":"Bronte Bess"},{"player_id":"99798","name":"Dillan John"}],"max_over":"1","target":"10","recent_scores":"w,1,w","last_five_overs":"1\/2 2.00","last_ten_overs":"1\/2 2.00"},"teams":[{"tid":129001,"title":"Iyanola Heritage","abbr":"IYH","alt_name":"Iyanola Heritage","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Iyanola-Heritage.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Iyanola-Heritage.png","country":"wi","sex":"male","team_owner":"","head_coach":"","scores_full":"97\/4 (10 ov) & 9\/2 (1 ov)","scores":"97\/4 & 9\/2","overs":"10 & 1"},{"tid":129006,"title":"Bamboo Blasters","abbr":"BMB","alt_name":"Bamboo Blasters","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Bamboo-Blasters.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Bamboo-Blasters.png","country":"wi","sex":"male","team_owner":"","head_coach":"","scores_full":"97\/9 (10 ov) & 1\/2 (0.3 ov)","scores":"97\/9 & 1\/2","overs":"10 & 0.3"}],"players":[{"pid":482,"title":"Johnson Charles","short_name":"J Charles","first_name":"Johnson Charles","last_name":"","middle_name":"","birthdate":"1989-01-14","birthplace":"St Lucia","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/realjcharles\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(WK\/C)"},{"pid":92689,"title":"Xavier Gabriel","short_name":"Xavier Gabriel","first_name":"Xavier Gabriel","last_name":"","middle_name":"","birthdate":"1985-12-18","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":99732,"title":"Bronte Bess","short_name":"B Bess","first_name":"Bronte Bess","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":99739,"title":"Kevin Gassie","short_name":"K Gassie","first_name":"Kevin Gassie","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":99786,"title":"Stephen Naitram","short_name":"S Naitram","first_name":"Stephen Naitram","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(C)"},{"pid":99791,"title":"Keygan Arnold","short_name":"K Arnold","first_name":"Keygan Arnold","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right 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":99793,"title":"Jamaal James","short_name":"J James","first_name":"Jamaal James","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":99798,"title":"Dillan John","short_name":"D John","first_name":"Dillan John","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left 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":99808,"title":"Vernillius Gabriel","short_name":"V Gabriel","first_name":"Vernillius Gabriel","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":100039,"title":"Shervon Joseph","short_name":"S Joseph","first_name":"Shervon Joseph","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm 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":100040,"title":"Nyeem Rosemond","short_name":"N Rosemond","first_name":"Nyeem Rosemond","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":100041,"title":"Noelle Leo","short_name":"N Leo","first_name":"Noelle Leo","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":"(WK)"},{"pid":100044,"title":"Collinus Callendar","short_name":"C Callendar","first_name":"Collinus Callendar","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":100052,"title":"Aaron Joseph","short_name":"A Joseph","first_name":"Aaron Joseph","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":107702,"title":"Khan Elcock","short_name":"K Elcock","first_name":"Khan Elcock","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":107703,"title":"Bolton Sayers","short_name":"B Sayers","first_name":"Bolton Sayers","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":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":107721,"title":"Wendell Inglis","short_name":"W Inglis","first_name":"Wendell Inglis","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":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":107726,"title":"Dwight Thomas","short_name":"D Thomas","first_name":"Dwight Thomas","last_name":"","middle_name":"","birthdate":"","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":107727,"title":"Ephron Charles","short_name":"E Charles","first_name":"Ephron Charles","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":107729,"title":"Kyle Adonis","short_name":"K Adonis","first_name":"Kyle Adonis","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":107730,"title":"Qwaine Henry","short_name":"Q Henry","first_name":"Qwaine Henry","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":""},{"pid":107772,"title":"Jamal Lesmond","short_name":"J Lesmond","first_name":"Jamal Lesmond","last_name":"","middle_name":"","birthdate":"","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":116125,"title":"Jaylan Chandler","short_name":"J Chandler","first_name":"Jaylan Chandler","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":""},{"pid":116162,"title":"Kensley Paul","short_name":"K Paul","first_name":"Kensley Paul","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":116168,"title":"Jehan Boodha","short_name":"J Boodha","first_name":"Jehan Boodha","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":116247,"title":"Theo Edward","short_name":"T Edward","first_name":"Theo 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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":127058,"title":"Joshua Mann","short_name":"J Mann","first_name":"Joshua Mann","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":138224,"title":"Dominic Auguste","short_name":"D Auguste","first_name":"Dominic Auguste","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":""},{"pid":138230,"title":"Zinakki Louis","short_name":"Z Louis","first_name":"Zinakki Louis","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":150058,"title":"Aiden Scholer","short_name":"AD Scholer","first_name":"Aiden Scholer","last_name":"","middle_name":"","birthdate":"2009-10-13","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":150062,"title":"Mateo Boulogne","short_name":"MT Boulogne","first_name":"Mateo Boulogne","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","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":150199,"title":"Yulieski Gustave","short_name":"Y Gustave","first_name":"Yulieski Gustave","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":"squad","role_str":""}]},"etag":"b656d524ee71e2176c7269d515763eae","modified":"2025-07-08 12:09:22","datetime":"2025-07-08 12:09:22","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":90963,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Iyanola Heritage won by superover","day_remaining_over":"","team_batting":"Bamboo Blasters","team_bowling":"Iyanola Heritage","live_inning_number":4,"live_score":{"runs":1,"overs":0.3,"wickets":2,"target":10,"runrate":2,"required_runrate":18},"commentary":1,"wagon":2,"batsmen":[{"name":"Noelle Leo","batsman_id":100041,"runs":0,"balls_faced":1,"fours":0,"sixes":0,"strike_rate":"0.00"},{"name":"Kyle Adonis","batsman_id":107729,"runs":1,"balls_faced":1,"fours":0,"sixes":0,"strike_rate":"100.00"}],"bowlers":[{"name":"Xavier Gabriel","bowler_id":92689,"overs":0.3,"runs_conceded":1,"wickets":2,"maidens":0,"econ":"2.00"}],"commentaries":[{"event_id":"12268384","event":"wicket","batsman_id":"99786","bowler_id":"92689","over":"0","ball":"1","score":"w","commentary":"Xavier Gabriel to Stephen Naitram, no run, c & b Xavier Gabriel,","noball_dismissal":false,"text":"","timestamp":1751407160,"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":"99786","how_out":"c & b Xavier Gabriel","batsman_runs":"0","batsman_balls":"1"},{"event_id":"12268385","event":"ball","batsman_id":"107729","bowler_id":"92689","over":"0","ball":"2","score":1,"commentary":"Xavier Gabriel to Kyle Adonis, 1 run,","noball_dismissal":false,"text":"","timestamp":1751407173,"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":"12268386","event":"wicket","batsman_id":"100041","bowler_id":"92689","over":"0","ball":"3","score":"w","commentary":"Xavier Gabriel to Noelle Leo, no run, c & b Xavier Gabriel,","noball_dismissal":false,"text":"","timestamp":1751407190,"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":"100041","how_out":"c & b Xavier Gabriel","batsman_runs":"0","batsman_balls":"1"}],"day":"0","session":"0","live_inning":{"iid":199009,"number":4,"name":"Bamboo Blasters Inning","short_name":"BMB Inning","status":2,"issuperover":"true","result":1,"batting_team_id":129006,"fielding_team_id":129001,"scores":"1\/2","scores_full":"1\/2 (0.3 ov)","fielder":[{"fielder_id":"92689","fielder_name":"Xavier Gabriel","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":[],"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Noelle Leo","batsman_id":"100041","runs":"0","balls":"1","how_out":"c & b Xavier Gabriel","score_at_dismissal":1,"overs_at_dismissal":"0.3","bowler_id":"92689","dismissal":"caught","number":2},"extra_runs":{"byes":0,"legbyes":0,"wides":0,"noballs":0,"penalty":"0","total":0},"equations":{"runs":1,"wickets":2,"overs":"0.3","bowlers_used":1,"runrate":"2.00"},"current_partnership":{"runs":1,"balls":2,"overs":0.2,"batsmen":[{"name":"Kyle Adonis","batsman_id":107729,"runs":1,"balls":1},{"name":"Noelle Leo","batsman_id":100041,"runs":0,"balls":1}]},"did_not_bat":[{"player_id":"107730","name":"Qwaine Henry"},{"player_id":"100039","name":"Shervon Joseph"},{"player_id":"107702","name":"Khan Elcock"},{"player_id":"150062","name":"Mateo Boulogne"},{"player_id":"99739","name":"Kevin Gassie"},{"player_id":"99791","name":"Keygan Arnold"},{"player_id":"99732","name":"Bronte Bess"},{"player_id":"99798","name":"Dillan John"}],"max_over":"1","target":"10","recent_scores":"w,1,w","last_five_overs":"1\/2 2.00","last_ten_overs":"1\/2 2.00"},"teams":[{"tid":129001,"title":"Iyanola Heritage","abbr":"IYH","alt_name":"Iyanola Heritage","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Iyanola-Heritage.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Iyanola-Heritage.png","country":"wi","sex":"male","team_owner":"","head_coach":"","scores_full":"97\/4 (10 ov) & 9\/2 (1 ov)","scores":"97\/4 & 9\/2","overs":"10 & 1"},{"tid":129006,"title":"Bamboo Blasters","abbr":"BMB","alt_name":"Bamboo Blasters","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Bamboo-Blasters.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Bamboo-Blasters.png","country":"wi","sex":"male","team_owner":"","head_coach":"","scores_full":"97\/9 (10 ov) & 1\/2 (0.3 ov)","scores":"97\/9 & 1\/2","overs":"10 & 0.3"}],"players":[{"pid":482,"title":"Johnson Charles","short_name":"J Charles","first_name":"Johnson Charles","last_name":"","middle_name":"","birthdate":"1989-01-14","birthplace":"St Lucia","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/realjcharles\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(WK\/C)"},{"pid":92689,"title":"Xavier Gabriel","short_name":"Xavier Gabriel","first_name":"Xavier Gabriel","last_name":"","middle_name":"","birthdate":"1985-12-18","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":99732,"title":"Bronte Bess","short_name":"B Bess","first_name":"Bronte Bess","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":99739,"title":"Kevin Gassie","short_name":"K Gassie","first_name":"Kevin Gassie","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":99786,"title":"Stephen Naitram","short_name":"S Naitram","first_name":"Stephen Naitram","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(C)"},{"pid":99791,"title":"Keygan Arnold","short_name":"K Arnold","first_name":"Keygan Arnold","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right 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":99793,"title":"Jamaal James","short_name":"J James","first_name":"Jamaal James","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":99798,"title":"Dillan John","short_name":"D John","first_name":"Dillan John","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left 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":99808,"title":"Vernillius Gabriel","short_name":"V Gabriel","first_name":"Vernillius Gabriel","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":100039,"title":"Shervon Joseph","short_name":"S Joseph","first_name":"Shervon Joseph","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm 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":100040,"title":"Nyeem Rosemond","short_name":"N Rosemond","first_name":"Nyeem Rosemond","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":100041,"title":"Noelle Leo","short_name":"N Leo","first_name":"Noelle Leo","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":"(WK)"},{"pid":100044,"title":"Collinus Callendar","short_name":"C Callendar","first_name":"Collinus Callendar","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":100052,"title":"Aaron Joseph","short_name":"A Joseph","first_name":"Aaron Joseph","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":107702,"title":"Khan Elcock","short_name":"K Elcock","first_name":"Khan Elcock","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":107703,"title":"Bolton Sayers","short_name":"B Sayers","first_name":"Bolton Sayers","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":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":107721,"title":"Wendell Inglis","short_name":"W Inglis","first_name":"Wendell Inglis","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":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":107726,"title":"Dwight Thomas","short_name":"D Thomas","first_name":"Dwight Thomas","last_name":"","middle_name":"","birthdate":"","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":107727,"title":"Ephron Charles","short_name":"E Charles","first_name":"Ephron Charles","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":107729,"title":"Kyle Adonis","short_name":"K Adonis","first_name":"Kyle Adonis","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":107730,"title":"Qwaine Henry","short_name":"Q Henry","first_name":"Qwaine Henry","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":""},{"pid":107772,"title":"Jamal Lesmond","short_name":"J Lesmond","first_name":"Jamal Lesmond","last_name":"","middle_name":"","birthdate":"","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":116125,"title":"Jaylan Chandler","short_name":"J Chandler","first_name":"Jaylan Chandler","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":""},{"pid":116162,"title":"Kensley Paul","short_name":"K Paul","first_name":"Kensley Paul","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":116168,"title":"Jehan Boodha","short_name":"J Boodha","first_name":"Jehan Boodha","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":116247,"title":"Theo Edward","short_name":"T Edward","first_name":"Theo 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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":127058,"title":"Joshua Mann","short_name":"J Mann","first_name":"Joshua Mann","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":138224,"title":"Dominic Auguste","short_name":"D Auguste","first_name":"Dominic Auguste","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":""},{"pid":138230,"title":"Zinakki Louis","short_name":"Z Louis","first_name":"Zinakki Louis","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":150058,"title":"Aiden Scholer","short_name":"AD Scholer","first_name":"Aiden Scholer","last_name":"","middle_name":"","birthdate":"2009-10-13","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":150062,"title":"Mateo Boulogne","short_name":"MT Boulogne","first_name":"Mateo Boulogne","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","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":150199,"title":"Yulieski Gustave","short_name":"Y Gustave","first_name":"Yulieski Gustave","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":"squad","role_str":""}]},"etag":"b656d524ee71e2176c7269d515763eae","modified":"2025-07-08 12:09:22","datetime":"2025-07-08 12:09:22","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90963 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:f7db7ab0-74a2-4f8a-926f-bcf9626df3a5 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90963 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90963,3,'{"status":"ok","response":{"match_id":90963,"title":"Iyanola Heritage vs Bamboo Blasters","short_title":"IYH vs BMB","subtitle":"Match 16","match_number":"16","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Iyanola Heritage won by superover","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":129001,"name":"Iyanola Heritage","short_name":"IYH","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Iyanola-Heritage.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Iyanola-Heritage.png","scores_full":"97\/4 (10 ov) & 9\/2 (1 ov)","scores":"97\/4 & 9\/2","overs":"10 & 1"},"teamb":{"team_id":129006,"name":"Bamboo Blasters","short_name":"BMB","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Bamboo-Blasters.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Bamboo-Blasters.png","scores_full":"97\/9 (10 ov) & 1\/2 (0.3 ov)","scores":"97\/9 & 1\/2","overs":"10 & 0.3"},"date_start":"2025-07-01 19:30:00","date_end":"2025-07-02 05:30:00","timestamp_start":1751398200,"timestamp_end":1751434200,"date_start_ist":"2025-07-02 01:00:00","date_end_ist":"2025-07-02 11: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":"IYH won by superover","result_type":1,"win_margin":"superover","winning_team_id":129001,"commentary":1,"wagon":2,"latest_inning_number":4,"presquad_time":"2025-06-30 22:07:22","verify_time":"2025-07-02 03:35:50","match_dls_affected":"false","live_inning_number":4,"day":"0","session":"0","weather":{"weather":"Clear","weather_desc":"clear sky","temp":27.11,"humidity":76,"visibility":10000,"wind_speed":"13.47","clouds":3},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Iyanola Heritage elected to bowl","winner":129001,"decision":2}},"etag":"b656d524ee71e2176c7269d515763eae","modified":"2025-07-08 12:09:22","datetime":"2025-07-08 12:09:22","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90963,"title":"Iyanola Heritage vs Bamboo Blasters","short_title":"IYH vs BMB","subtitle":"Match 16","match_number":"16","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Iyanola Heritage won by superover","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":129001,"name":"Iyanola Heritage","short_name":"IYH","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Iyanola-Heritage.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Iyanola-Heritage.png","scores_full":"97\/4 (10 ov) & 9\/2 (1 ov)","scores":"97\/4 & 9\/2","overs":"10 & 1"},"teamb":{"team_id":129006,"name":"Bamboo Blasters","short_name":"BMB","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Bamboo-Blasters.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Bamboo-Blasters.png","scores_full":"97\/9 (10 ov) & 1\/2 (0.3 ov)","scores":"97\/9 & 1\/2","overs":"10 & 0.3"},"date_start":"2025-07-01 19:30:00","date_end":"2025-07-02 05:30:00","timestamp_start":1751398200,"timestamp_end":1751434200,"date_start_ist":"2025-07-02 01:00:00","date_end_ist":"2025-07-02 11: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":"IYH won by superover","result_type":1,"win_margin":"superover","winning_team_id":129001,"commentary":1,"wagon":2,"latest_inning_number":4,"presquad_time":"2025-06-30 22:07:22","verify_time":"2025-07-02 03:35:50","match_dls_affected":"false","live_inning_number":4,"day":"0","session":"0","weather":{"weather":"Clear","weather_desc":"clear sky","temp":27.11,"humidity":76,"visibility":10000,"wind_speed":"13.47","clouds":3},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Iyanola Heritage elected to bowl","winner":129001,"decision":2}},"etag":"b656d524ee71e2176c7269d515763eae","modified":"2025-07-08 12:09:22","datetime":"2025-07-08 12:09:22","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90963 AND DataTypeId = 3 END
Live Report & Scorecard of Iyanola Heritage vs Bamboo Blasters Match 16