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:0edf040d-e9ed-4a80-ae17-3ae138f1a3e8 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 91178 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (91178,1,'{"status":"ok","response":{"mid":91178,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Dubai Capitals won by 22 runs","day_remaining_over":"","team_batting":"Central Districts","team_bowling":"Dubai Capitals","live_inning_number":2,"live_score":{"runs":143,"overs":20,"wickets":8,"target":166,"runrate":7.15,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Matthew Forde","batsman_id":96610,"runs":0,"balls_faced":0,"fours":0,"sixes":0,"strike_rate":"0.00"},{"name":"Ajaz Patel","batsman_id":46314,"runs":4,"balls_faced":2,"fours":1,"sixes":0,"strike_rate":"200.00"}],"bowlers":[{"name":"Khuzaima Bin Tanvir","bowler_id":111316,"overs":3,"runs_conceded":28,"wickets":2,"maidens":0,"econ":"9.33"},{"name":"Dominic Drakes","bowler_id":52193,"overs":4,"runs_conceded":26,"wickets":1,"maidens":0,"econ":"6.50"}],"commentaries":[{"event_id":"12320525","event":"ball","batsman_id":"16613","bowler_id":"111316","over":"15","ball":"5","score":1,"commentary":"Khuzaima Bin Tanvir to Tom Bruce, 1 run,","noball_dismissal":false,"text":"","timestamp":1752167888,"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":"12320526","event":"ball","batsman_id":"95500","bowler_id":"111316","over":"15","ball":"6","score":4,"commentary":"Khuzaima Bin Tanvir to William Clark, Four,","noball_dismissal":false,"text":"","timestamp":1752167906,"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":16,"runs":10,"score":"113\/4","bats":[{"runs":19,"balls_faced":17,"fours":1,"sixes":0,"batsman_id":95500},{"runs":28,"balls_faced":33,"fours":2,"sixes":0,"batsman_id":16613}],"bowls":[{"runs_conceded":22,"maidens":0,"wickets":0,"bowler_id":111316,"overs":2},{"runs_conceded":17,"maidens":0,"wickets":0,"bowler_id":52193,"overs":3}],"commentary":"End of over 16 (10 runs), Central Districts 113\/4"},{"event_id":"12320532","event":"ball","batsman_id":"16613","bowler_id":"348","over":"16","ball":"1","score":"1lb","commentary":"Shakib Al Hasan to Tom Bruce, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1752167923,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"1","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12320533","event":"ball","batsman_id":"95500","bowler_id":"348","over":"16","ball":"2","score":1,"commentary":"Shakib Al Hasan to William Clark, 1 run,","noball_dismissal":false,"text":"","timestamp":1752167936,"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":"12320534","event":"ball","batsman_id":"16613","bowler_id":"348","over":"16","ball":"3","score":1,"commentary":"Shakib Al Hasan to Tom Bruce, 1 run,","noball_dismissal":false,"text":"","timestamp":1752167940,"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":"12320540","event":"wicket","batsman_id":"95500","bowler_id":"348","over":"16","ball":"4","score":"w","commentary":"Shakib Al Hasan to William Clark, no run, b S Al Hasan,","noball_dismissal":false,"text":"","timestamp":1752167999,"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":"95500","how_out":"b S Al Hasan","batsman_runs":"20","batsman_balls":"19"},{"event_id":"12320549","event":"ball","batsman_id":"49103","bowler_id":"348","over":"16","ball":"5","score":0,"commentary":"Shakib Al Hasan to Doug Bracewell, no run,","noball_dismissal":false,"text":"","timestamp":1752168135,"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":"12320556","event":"ball","batsman_id":"49103","bowler_id":"348","over":"16","ball":"6","score":0,"commentary":"Shakib Al Hasan to Doug Bracewell, no run,","noball_dismissal":false,"text":"","timestamp":1752168191,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":17,"runs":3,"score":"116\/5","bats":[{"runs":0,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":49103},{"runs":29,"balls_faced":35,"fours":2,"sixes":0,"batsman_id":16613}],"bowls":[{"runs_conceded":13,"maidens":1,"wickets":4,"bowler_id":348,"overs":4},{"runs_conceded":22,"maidens":0,"wickets":0,"bowler_id":111316,"overs":2}],"commentary":"End of over 17 (3 runs), Central Districts 116\/5"},{"event_id":"12320558","event":"ball","batsman_id":"16613","bowler_id":"96421","over":"17","ball":"1","score":4,"commentary":"Kaleem Sana to Tom Bruce, Four,","noball_dismissal":false,"text":"","timestamp":1752168258,"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":"12320561","event":"ball","batsman_id":"16613","bowler_id":"96421","over":"17","ball":"2","score":"1lb","commentary":"Kaleem Sana to Tom Bruce, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1752168334,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"1","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12320564","event":"ball","batsman_id":"49103","bowler_id":"96421","over":"17","ball":"3","score":4,"commentary":"Kaleem Sana to Doug Bracewell, Four,","noball_dismissal":false,"text":"","timestamp":1752168346,"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":"12320568","event":"ball","batsman_id":"49103","bowler_id":"96421","over":"17","ball":"4","score":2,"commentary":"Kaleem Sana to Doug Bracewell, 2 runs,","noball_dismissal":false,"text":"","timestamp":1752168420,"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":"12320570","event":"ball","batsman_id":"49103","bowler_id":"96421","over":"17","ball":"5","score":0,"commentary":"Kaleem Sana to Doug Bracewell, no run,","noball_dismissal":false,"text":"","timestamp":1752168432,"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":"12320573","event":"ball","batsman_id":"49103","bowler_id":"96421","over":"17","ball":"6","score":0,"commentary":"Kaleem Sana to Doug Bracewell, no run,","noball_dismissal":false,"text":"","timestamp":1752168462,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":18,"runs":11,"score":"127\/5","bats":[{"runs":6,"balls_faced":6,"fours":1,"sixes":0,"batsman_id":49103},{"runs":33,"balls_faced":37,"fours":3,"sixes":0,"batsman_id":16613}],"bowls":[{"runs_conceded":21,"maidens":0,"wickets":0,"bowler_id":96421,"overs":3},{"runs_conceded":13,"maidens":1,"wickets":4,"bowler_id":348,"overs":4}],"commentary":"End of over 18 (11 runs), Central Districts 127\/5"},{"event_id":"12320580","event":"ball","batsman_id":"16613","bowler_id":"52193","over":"18","ball":"1","score":1,"commentary":"Dominic Drakes to Tom Bruce, 1 run,","noball_dismissal":false,"text":"","timestamp":1752168643,"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":"12320585","event":"ball","batsman_id":"49103","bowler_id":"52193","over":"18","ball":"2","score":0,"commentary":"Dominic Drakes to Doug Bracewell, no run,","noball_dismissal":false,"text":"","timestamp":1752168668,"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":"12320587","event":"ball","batsman_id":"49103","bowler_id":"52193","over":"18","ball":"3","score":4,"commentary":"Dominic Drakes to Doug Bracewell, Four,","noball_dismissal":false,"text":"","timestamp":1752168672,"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":"12320591","event":"ball","batsman_id":"49103","bowler_id":"52193","over":"18","ball":"4","score":4,"commentary":"Dominic Drakes to Doug Bracewell, Four,","noball_dismissal":false,"text":"","timestamp":1752168735,"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":"12320592","event":"ball","batsman_id":"49103","bowler_id":"52193","over":"18","ball":"5","score":"1lb","commentary":"Dominic Drakes to Doug Bracewell, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1752168747,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"1","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12320603","event":"wicket","batsman_id":"16613","bowler_id":"52193","over":"18","ball":"6","score":"w","commentary":"Dominic Drakes to Tom Bruce, no run, c G Naib b DC Drakes,","noball_dismissal":false,"text":"","timestamp":1752168759,"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":"16613","how_out":"c G Naib b DC Drakes","batsman_runs":"34","batsman_balls":"39"},{"event":"overend","over":19,"runs":10,"score":"137\/6","bats":[{"runs":34,"balls_faced":39,"fours":3,"sixes":0,"batsman_id":16613},{"runs":14,"balls_faced":10,"fours":3,"sixes":0,"batsman_id":49103}],"bowls":[{"runs_conceded":26,"maidens":0,"wickets":1,"bowler_id":52193,"overs":4},{"runs_conceded":21,"maidens":0,"wickets":0,"bowler_id":96421,"overs":3}],"commentary":"End of over 19 (10 runs), Central Districts 137\/6"},{"event_id":"12320610","event":"ball","batsman_id":"49103","bowler_id":"111316","over":"19","ball":"1","score":2,"commentary":"Khuzaima Bin Tanvir to Doug Bracewell, 2 runs,","noball_dismissal":false,"text":"","timestamp":1752168924,"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":"12320611","event":"ball","batsman_id":"49103","bowler_id":"111316","over":"19","ball":"2","score":0,"commentary":"Khuzaima Bin Tanvir to Doug Bracewell, no run,","noball_dismissal":false,"text":"","timestamp":1752168928,"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":"12320617","event":"wicket","batsman_id":"49103","bowler_id":"111316","over":"19","ball":"3","score":"w","commentary":"Khuzaima Bin Tanvir to Doug Bracewell, no run, c K Alleyne b KB Tanvir,","noball_dismissal":false,"text":"","timestamp":1752169008,"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":"49103","how_out":"c K Alleyne b KB Tanvir","batsman_runs":"16","batsman_balls":"13"},{"event_id":"12320622","event":"wicket","batsman_id":"123218","bowler_id":"111316","over":"19","ball":"4","score":"w","commentary":"Khuzaima Bin Tanvir to Angus Schaw, no run, lbw b KB Tanvir,","noball_dismissal":false,"text":"","timestamp":1752169170,"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":"123218","how_out":"lbw b KB Tanvir","batsman_runs":"0","batsman_balls":"1"},{"event_id":"12320630","event":"ball","batsman_id":"46314","bowler_id":"111316","over":"19","ball":"5","score":4,"commentary":"Khuzaima Bin Tanvir to Ajaz Patel, Four,","noball_dismissal":false,"text":"","timestamp":1752169221,"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":"12320633","event":"ball","batsman_id":"46314","bowler_id":"111316","over":"19","ball":"6","score":0,"commentary":"Khuzaima Bin Tanvir to Ajaz Patel, no run,","noball_dismissal":false,"text":"","timestamp":1752169260,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":20,"runs":6,"score":"143\/8","bats":[{"runs":4,"balls_faced":2,"fours":1,"sixes":0,"batsman_id":46314},{"runs":0,"balls_faced":0,"fours":0,"sixes":0,"batsman_id":96610}],"bowls":[{"runs_conceded":28,"maidens":0,"wickets":2,"bowler_id":111316,"overs":3},{"runs_conceded":26,"maidens":0,"wickets":1,"bowler_id":52193,"overs":4}],"commentary":"End of over 20 (6 runs), Central Districts 143\/8"}],"day":"0","session":"0","live_inning":{"iid":199432,"number":2,"name":"Central Districts Inning","short_name":"CD Inning","status":2,"issuperover":"false","result":4,"batting_team_id":13222,"fielding_team_id":127168,"scores":"143\/8","scores_full":"143\/8 (20 ov)","fielder":[{"fielder_id":"428","fielder_name":"Gulbadin Naib","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"109449","fielder_name":"Kadeem Alleyne","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"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":"Angus Schaw","batsman_id":"123218","runs":"0","balls":"1","how_out":"lbw b KB Tanvir","score_at_dismissal":139,"overs_at_dismissal":"19.4","bowler_id":"111316","dismissal":"lbw","number":8},"extra_runs":{"byes":5,"legbyes":7,"wides":5,"noballs":0,"penalty":"0","total":17},"equations":{"runs":143,"wickets":8,"overs":"20","bowlers_used":6,"runrate":"7.15"},"current_partnership":{"runs":4,"balls":2,"overs":0.2,"batsmen":[{"name":"Ajaz Patel","batsman_id":46314,"runs":4,"balls":2},{"name":"Matthew Forde","batsman_id":96610,"runs":0,"balls":0}]},"did_not_bat":[{"player_id":"46310","name":"Blair Tickner"}],"max_over":"20","target":"166","recent_scores":"0,4,w,w,0,2,w,1,4,4,0,1,0,0,2,4,1,4","last_five_overs":"40\/4 7.74","last_ten_overs":"76\/5 7.48"},"teams":[{"tid":13222,"title":"Central Districts","abbr":"CD","alt_name":"Central Districts","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Central_Stags_logo_transparent.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Central_Stags_logo_transparent.png","country":"nz","sex":"male","team_owner":"","head_coach":"","scores_full":"143\/8 (20 ov)","scores":"143\/8","overs":"20"},{"tid":127168,"title":"Dubai Capitals","abbr":"DC","alt_name":"Dubai Capitals","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Rectangle-3348-2023-07-10T104951.123.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Rectangle-3348-2023-07-10T104951.123.png","country":"ae","sex":"male","team_owner":"","head_coach":"","scores_full":"165\/7 (20 ov)","scores":"165\/7","overs":"20"}],"players":[{"pid":348,"title":"Shakib Al Hasan","short_name":"S Al Hasan","first_name":"Shakib Al Hasan","last_name":"","middle_name":"","birthdate":"1987-03-24","birthplace":"Magura, Jessore","country":"bd","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":9,"facebook_profile":"https:\/\/www.facebook.com\/Shakib.Al.Hasan\/","twitter_profile":"https:\/\/twitter.com\/Sah75official","instagram_profile":"https:\/\/www.instagram.com\/shaki_b75\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Bangladesh","role":"all","role_str":""},{"pid":428,"title":"Gulbadin Naib","short_name":"G Naib","first_name":"Gulbadin Naib","last_name":"","middle_name":"","birthdate":"1991-06-04","birthplace":" Logar, Afghanistan","country":"af","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium 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":"Afghanistan","role":"all","role_str":"(C)"},{"pid":1085,"title":"Josh Clarkson","short_name":"JA Clarkson","first_name":"Josh Clarkson","last_name":"","middle_name":"","birthdate":"1997-01-21","birthplace":"","country":"nz","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bat","role_str":""},{"pid":1253,"title":"Dean Foxcroft","short_name":"D Foxcroft","first_name":"Dean Foxcroft","last_name":"","middle_name":"","birthdate":"1998-04-20","birthplace":"Pretoria, South Africa","country":"za","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":"https:\/\/twitter.com\/FoxcroftDean","instagram_profile":"https:\/\/www.instagram.com\/deanfoxcroft11\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"South Africa","role":"all","role_str":""},{"pid":1763,"title":"Niroshan Dickwella","short_name":"N Dickwella","first_name":"Niroshan Dickwella","last_name":"","middle_name":"","birthdate":"1993-06-23","birthplace":"Kandy","country":"lk","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/NiroshanDickwellaOfficial\/","twitter_profile":"https:\/\/twitter.com\/NiroshanDikka","instagram_profile":"https:\/\/www.instagram.com\/niroshan48dikka\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Sri Lanka","role":"wk","role_str":"(WK)"},{"pid":16609,"title":"Will Young","short_name":"W Young","first_name":"Will Young","last_name":"","middle_name":"","birthdate":"1992-11-22","birthplace":"New Plymouth","country":"nz","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":8.5,"facebook_profile":"https:\/\/www.facebook.com\/willyoung\/","twitter_profile":"https:\/\/twitter.com\/willyoung","instagram_profile":"https:\/\/www.instagram.com\/willyoungofficial\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bat","role_str":""},{"pid":16611,"title":"Dane Cleaver","short_name":"D Cleaver","first_name":"Dane Cleaver","last_name":"","middle_name":"","birthdate":"1992-01-01","birthplace":"Palmerston North","country":"nz","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"wicket keeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/dane_cleaver\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"wk","role_str":"(WK)"},{"pid":16613,"title":"Tom Bruce","short_name":"TC Bruce","first_name":"Tom Bruce","last_name":"","middle_name":"","birthdate":"1991-08-02","birthplace":"","country":"nz","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":23993,"recent_appearance":1514512800,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bat","role_str":"(C)"},{"pid":45056,"title":"Qais Ahmad","short_name":"Q Ahmad","first_name":"Qais Ahmad","last_name":"","middle_name":"","birthdate":"2000-08-15","birthplace":"Nangarhar","country":"af","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/qaisahmadkamawalFanpage\/","twitter_profile":"https:\/\/twitter.com\/Qais_AhmadK","instagram_profile":"https:\/\/www.instagram.com\/qais_ahmad_32\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Afghanistan","role":"squad","role_str":""},{"pid":46310,"title":"Blair Tickner","short_name":"BM Tickner","first_name":"Blair Tickner","last_name":"","middle_name":"","birthdate":"1993-10-13","birthplace":"Napier, Hawke''s Bay","country":"nz","primary_team":[],"logo_url":"","playing_role":"bowl","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":"https:\/\/www.facebook.com\/blair.tickner\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/ticks93\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bowl","role_str":""},{"pid":46314,"title":"Ajaz Patel","short_name":"AY Patel","first_name":"Ajaz Patel","last_name":"","middle_name":"","birthdate":"1988-10-21","birthplace":"Bombay (now Mumbai), Maharashtra, India","country":"nz","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/AjazP","instagram_profile":"https:\/\/www.instagram.com\/ajazpatel\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bowl","role_str":""},{"pid":49103,"title":"Doug Bracewell","short_name":"DAJ Bracewell","first_name":"Doug Bracewell","last_name":"","middle_name":"","birthdate":"1990-09-28","birthplace":"Tauranga, Bay of Plenty","country":"nz","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":23991,"recent_appearance":1513980000,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/dougalba\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bowl","role_str":""},{"pid":52193,"title":"Dominic Drakes","short_name":"DC Drakes","first_name":"Dominic Drakes","last_name":"","middle_name":"","birthdate":"1998-02-06","birthplace":"Barbados","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Dommie_48","instagram_profile":"https:\/\/www.instagram.com\/dommie48\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":55467,"title":"Rovman Powell","short_name":"R Powell","first_name":"Rovman Powell","last_name":"","middle_name":"","birthdate":"1993-07-23","birthplace":"Jamaica","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":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Ravipowell26","instagram_profile":"https:\/\/www.instagram.com\/ravipowell52\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":95500,"title":"William Clark","short_name":"William Clark","first_name":"William Clark","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"nz","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":"New Zealand","role":"all","role_str":""},{"pid":96421,"title":"Kaleem Sana","short_name":"K Sana","first_name":"Kaleem Sana","last_name":"","middle_name":"","birthdate":"1994-01-01","birthplace":"","country":"ca","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Canada","role":"bowl","role_str":""},{"pid":96509,"title":"Jayden Lennox","short_name":"J Lennox","first_name":"Jayden Lennox","last_name":"","middle_name":"","birthdate":"1994-12-14","birthplace":"","country":"nz","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":"New Zealand","role":"squad","role_str":""},{"pid":96610,"title":"Matthew Forde","short_name":"M Forde","first_name":"Matthew Forde","last_name":"","middle_name":"","birthdate":"2002-04-29","birthplace":"Barbados","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/matao_05\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":102259,"title":"Sediqullah Atal","short_name":"Sediqullah Atal","first_name":"Sediqullah Atal","last_name":"","middle_name":"","birthdate":"2001-08-12","birthplace":"","country":"af","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","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":"Afghanistan","role":"bat","role_str":""},{"pid":105224,"title":"Khalid Shah","short_name":"K Shah","first_name":"Khalid Shah","last_name":"","middle_name":"","birthdate":"1996-07-16","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"squad","role_str":""},{"pid":109449,"title":"Kadeem Alleyne","short_name":"K Alleyne","first_name":"Kadeem Alleyne","last_name":"","middle_name":"","birthdate":"2001-01-01","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":7,"facebook_profile":"https:\/\/www.facebook.com\/kadeem.alleyne.73\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/callmeelprofessor\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":111316,"title":"Khuzaima Bin Tanvir","short_name":"KB Tanvir","first_name":"Khuzaima Bin Tanvir","last_name":"","middle_name":"","birthdate":"1999-12-20","birthplace":"Faisalabad","country":"ae","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"bowl","role_str":""},{"pid":113125,"title":"Jordan Johnson","short_name":"J Johnson","first_name":"Jordan Johnson","last_name":"","middle_name":"","birthdate":"2005-04-26","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"Left Arm Wrist Spin","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":"wk","role_str":""},{"pid":114108,"title":"Jesse Bootan","short_name":"J Bootan","first_name":"Jesse Bootan","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":121286,"title":"Curtis Heaphy","short_name":"C Heaphy","first_name":"Curtis Heaphy","last_name":"","middle_name":"","birthdate":"2003-07-28","birthplace":"","country":"nz","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"squad","role_str":""},{"pid":123218,"title":"Angus Schaw","short_name":"A Schaw","first_name":"Angus Schaw","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"au","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":"Australia","role":"all","role_str":""},{"pid":124401,"title":"Farhan Khan","short_name":"F Khan","first_name":"Farhan Khan","last_name":"","middle_name":"","birthdate":"2004-04-25","birthplace":"Peshawar","country":"ae","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"squad","role_str":""},{"pid":125362,"title":"Toby Findlay","short_name":"T Findlay","first_name":"Toby Findlay","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"nz","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":"New Zealand","role":"squad","role_str":""},{"pid":140058,"title":"Zeeshan Naseer Ahmed","short_name":"Z Naseer","first_name":"Zeeshan Naseer Ahmed","last_name":"","middle_name":"","birthdate":"2000-04-01","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"bowl","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":"United Arab Emirates","role":"squad","role_str":""},{"pid":146094,"title":"Aryaman Varma","short_name":"A Varma","first_name":"Aryaman Varma","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"England","role":"all","role_str":""}]},"etag":"21e61430be6c14894a6155bac1e1afc7","modified":"2025-08-03 18:22:24","datetime":"2025-08-03 18:22:24","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":91178,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Dubai Capitals won by 22 runs","day_remaining_over":"","team_batting":"Central Districts","team_bowling":"Dubai Capitals","live_inning_number":2,"live_score":{"runs":143,"overs":20,"wickets":8,"target":166,"runrate":7.15,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Matthew Forde","batsman_id":96610,"runs":0,"balls_faced":0,"fours":0,"sixes":0,"strike_rate":"0.00"},{"name":"Ajaz Patel","batsman_id":46314,"runs":4,"balls_faced":2,"fours":1,"sixes":0,"strike_rate":"200.00"}],"bowlers":[{"name":"Khuzaima Bin Tanvir","bowler_id":111316,"overs":3,"runs_conceded":28,"wickets":2,"maidens":0,"econ":"9.33"},{"name":"Dominic Drakes","bowler_id":52193,"overs":4,"runs_conceded":26,"wickets":1,"maidens":0,"econ":"6.50"}],"commentaries":[{"event_id":"12320525","event":"ball","batsman_id":"16613","bowler_id":"111316","over":"15","ball":"5","score":1,"commentary":"Khuzaima Bin Tanvir to Tom Bruce, 1 run,","noball_dismissal":false,"text":"","timestamp":1752167888,"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":"12320526","event":"ball","batsman_id":"95500","bowler_id":"111316","over":"15","ball":"6","score":4,"commentary":"Khuzaima Bin Tanvir to William Clark, Four,","noball_dismissal":false,"text":"","timestamp":1752167906,"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":16,"runs":10,"score":"113\/4","bats":[{"runs":19,"balls_faced":17,"fours":1,"sixes":0,"batsman_id":95500},{"runs":28,"balls_faced":33,"fours":2,"sixes":0,"batsman_id":16613}],"bowls":[{"runs_conceded":22,"maidens":0,"wickets":0,"bowler_id":111316,"overs":2},{"runs_conceded":17,"maidens":0,"wickets":0,"bowler_id":52193,"overs":3}],"commentary":"End of over 16 (10 runs), Central Districts 113\/4"},{"event_id":"12320532","event":"ball","batsman_id":"16613","bowler_id":"348","over":"16","ball":"1","score":"1lb","commentary":"Shakib Al Hasan to Tom Bruce, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1752167923,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"1","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12320533","event":"ball","batsman_id":"95500","bowler_id":"348","over":"16","ball":"2","score":1,"commentary":"Shakib Al Hasan to William Clark, 1 run,","noball_dismissal":false,"text":"","timestamp":1752167936,"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":"12320534","event":"ball","batsman_id":"16613","bowler_id":"348","over":"16","ball":"3","score":1,"commentary":"Shakib Al Hasan to Tom Bruce, 1 run,","noball_dismissal":false,"text":"","timestamp":1752167940,"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":"12320540","event":"wicket","batsman_id":"95500","bowler_id":"348","over":"16","ball":"4","score":"w","commentary":"Shakib Al Hasan to William Clark, no run, b S Al Hasan,","noball_dismissal":false,"text":"","timestamp":1752167999,"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":"95500","how_out":"b S Al Hasan","batsman_runs":"20","batsman_balls":"19"},{"event_id":"12320549","event":"ball","batsman_id":"49103","bowler_id":"348","over":"16","ball":"5","score":0,"commentary":"Shakib Al Hasan to Doug Bracewell, no run,","noball_dismissal":false,"text":"","timestamp":1752168135,"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":"12320556","event":"ball","batsman_id":"49103","bowler_id":"348","over":"16","ball":"6","score":0,"commentary":"Shakib Al Hasan to Doug Bracewell, no run,","noball_dismissal":false,"text":"","timestamp":1752168191,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":17,"runs":3,"score":"116\/5","bats":[{"runs":0,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":49103},{"runs":29,"balls_faced":35,"fours":2,"sixes":0,"batsman_id":16613}],"bowls":[{"runs_conceded":13,"maidens":1,"wickets":4,"bowler_id":348,"overs":4},{"runs_conceded":22,"maidens":0,"wickets":0,"bowler_id":111316,"overs":2}],"commentary":"End of over 17 (3 runs), Central Districts 116\/5"},{"event_id":"12320558","event":"ball","batsman_id":"16613","bowler_id":"96421","over":"17","ball":"1","score":4,"commentary":"Kaleem Sana to Tom Bruce, Four,","noball_dismissal":false,"text":"","timestamp":1752168258,"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":"12320561","event":"ball","batsman_id":"16613","bowler_id":"96421","over":"17","ball":"2","score":"1lb","commentary":"Kaleem Sana to Tom Bruce, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1752168334,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"1","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12320564","event":"ball","batsman_id":"49103","bowler_id":"96421","over":"17","ball":"3","score":4,"commentary":"Kaleem Sana to Doug Bracewell, Four,","noball_dismissal":false,"text":"","timestamp":1752168346,"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":"12320568","event":"ball","batsman_id":"49103","bowler_id":"96421","over":"17","ball":"4","score":2,"commentary":"Kaleem Sana to Doug Bracewell, 2 runs,","noball_dismissal":false,"text":"","timestamp":1752168420,"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":"12320570","event":"ball","batsman_id":"49103","bowler_id":"96421","over":"17","ball":"5","score":0,"commentary":"Kaleem Sana to Doug Bracewell, no run,","noball_dismissal":false,"text":"","timestamp":1752168432,"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":"12320573","event":"ball","batsman_id":"49103","bowler_id":"96421","over":"17","ball":"6","score":0,"commentary":"Kaleem Sana to Doug Bracewell, no run,","noball_dismissal":false,"text":"","timestamp":1752168462,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":18,"runs":11,"score":"127\/5","bats":[{"runs":6,"balls_faced":6,"fours":1,"sixes":0,"batsman_id":49103},{"runs":33,"balls_faced":37,"fours":3,"sixes":0,"batsman_id":16613}],"bowls":[{"runs_conceded":21,"maidens":0,"wickets":0,"bowler_id":96421,"overs":3},{"runs_conceded":13,"maidens":1,"wickets":4,"bowler_id":348,"overs":4}],"commentary":"End of over 18 (11 runs), Central Districts 127\/5"},{"event_id":"12320580","event":"ball","batsman_id":"16613","bowler_id":"52193","over":"18","ball":"1","score":1,"commentary":"Dominic Drakes to Tom Bruce, 1 run,","noball_dismissal":false,"text":"","timestamp":1752168643,"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":"12320585","event":"ball","batsman_id":"49103","bowler_id":"52193","over":"18","ball":"2","score":0,"commentary":"Dominic Drakes to Doug Bracewell, no run,","noball_dismissal":false,"text":"","timestamp":1752168668,"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":"12320587","event":"ball","batsman_id":"49103","bowler_id":"52193","over":"18","ball":"3","score":4,"commentary":"Dominic Drakes to Doug Bracewell, Four,","noball_dismissal":false,"text":"","timestamp":1752168672,"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":"12320591","event":"ball","batsman_id":"49103","bowler_id":"52193","over":"18","ball":"4","score":4,"commentary":"Dominic Drakes to Doug Bracewell, Four,","noball_dismissal":false,"text":"","timestamp":1752168735,"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":"12320592","event":"ball","batsman_id":"49103","bowler_id":"52193","over":"18","ball":"5","score":"1lb","commentary":"Dominic Drakes to Doug Bracewell, 1 leg bye,","noball_dismissal":false,"text":"","timestamp":1752168747,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"1","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12320603","event":"wicket","batsman_id":"16613","bowler_id":"52193","over":"18","ball":"6","score":"w","commentary":"Dominic Drakes to Tom Bruce, no run, c G Naib b DC Drakes,","noball_dismissal":false,"text":"","timestamp":1752168759,"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":"16613","how_out":"c G Naib b DC Drakes","batsman_runs":"34","batsman_balls":"39"},{"event":"overend","over":19,"runs":10,"score":"137\/6","bats":[{"runs":34,"balls_faced":39,"fours":3,"sixes":0,"batsman_id":16613},{"runs":14,"balls_faced":10,"fours":3,"sixes":0,"batsman_id":49103}],"bowls":[{"runs_conceded":26,"maidens":0,"wickets":1,"bowler_id":52193,"overs":4},{"runs_conceded":21,"maidens":0,"wickets":0,"bowler_id":96421,"overs":3}],"commentary":"End of over 19 (10 runs), Central Districts 137\/6"},{"event_id":"12320610","event":"ball","batsman_id":"49103","bowler_id":"111316","over":"19","ball":"1","score":2,"commentary":"Khuzaima Bin Tanvir to Doug Bracewell, 2 runs,","noball_dismissal":false,"text":"","timestamp":1752168924,"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":"12320611","event":"ball","batsman_id":"49103","bowler_id":"111316","over":"19","ball":"2","score":0,"commentary":"Khuzaima Bin Tanvir to Doug Bracewell, no run,","noball_dismissal":false,"text":"","timestamp":1752168928,"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":"12320617","event":"wicket","batsman_id":"49103","bowler_id":"111316","over":"19","ball":"3","score":"w","commentary":"Khuzaima Bin Tanvir to Doug Bracewell, no run, c K Alleyne b KB Tanvir,","noball_dismissal":false,"text":"","timestamp":1752169008,"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":"49103","how_out":"c K Alleyne b KB Tanvir","batsman_runs":"16","batsman_balls":"13"},{"event_id":"12320622","event":"wicket","batsman_id":"123218","bowler_id":"111316","over":"19","ball":"4","score":"w","commentary":"Khuzaima Bin Tanvir to Angus Schaw, no run, lbw b KB Tanvir,","noball_dismissal":false,"text":"","timestamp":1752169170,"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":"123218","how_out":"lbw b KB Tanvir","batsman_runs":"0","batsman_balls":"1"},{"event_id":"12320630","event":"ball","batsman_id":"46314","bowler_id":"111316","over":"19","ball":"5","score":4,"commentary":"Khuzaima Bin Tanvir to Ajaz Patel, Four,","noball_dismissal":false,"text":"","timestamp":1752169221,"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":"12320633","event":"ball","batsman_id":"46314","bowler_id":"111316","over":"19","ball":"6","score":0,"commentary":"Khuzaima Bin Tanvir to Ajaz Patel, no run,","noball_dismissal":false,"text":"","timestamp":1752169260,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":20,"runs":6,"score":"143\/8","bats":[{"runs":4,"balls_faced":2,"fours":1,"sixes":0,"batsman_id":46314},{"runs":0,"balls_faced":0,"fours":0,"sixes":0,"batsman_id":96610}],"bowls":[{"runs_conceded":28,"maidens":0,"wickets":2,"bowler_id":111316,"overs":3},{"runs_conceded":26,"maidens":0,"wickets":1,"bowler_id":52193,"overs":4}],"commentary":"End of over 20 (6 runs), Central Districts 143\/8"}],"day":"0","session":"0","live_inning":{"iid":199432,"number":2,"name":"Central Districts Inning","short_name":"CD Inning","status":2,"issuperover":"false","result":4,"batting_team_id":13222,"fielding_team_id":127168,"scores":"143\/8","scores_full":"143\/8 (20 ov)","fielder":[{"fielder_id":"428","fielder_name":"Gulbadin Naib","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"109449","fielder_name":"Kadeem Alleyne","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"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":"Angus Schaw","batsman_id":"123218","runs":"0","balls":"1","how_out":"lbw b KB Tanvir","score_at_dismissal":139,"overs_at_dismissal":"19.4","bowler_id":"111316","dismissal":"lbw","number":8},"extra_runs":{"byes":5,"legbyes":7,"wides":5,"noballs":0,"penalty":"0","total":17},"equations":{"runs":143,"wickets":8,"overs":"20","bowlers_used":6,"runrate":"7.15"},"current_partnership":{"runs":4,"balls":2,"overs":0.2,"batsmen":[{"name":"Ajaz Patel","batsman_id":46314,"runs":4,"balls":2},{"name":"Matthew Forde","batsman_id":96610,"runs":0,"balls":0}]},"did_not_bat":[{"player_id":"46310","name":"Blair Tickner"}],"max_over":"20","target":"166","recent_scores":"0,4,w,w,0,2,w,1,4,4,0,1,0,0,2,4,1,4","last_five_overs":"40\/4 7.74","last_ten_overs":"76\/5 7.48"},"teams":[{"tid":13222,"title":"Central Districts","abbr":"CD","alt_name":"Central Districts","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Central_Stags_logo_transparent.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Central_Stags_logo_transparent.png","country":"nz","sex":"male","team_owner":"","head_coach":"","scores_full":"143\/8 (20 ov)","scores":"143\/8","overs":"20"},{"tid":127168,"title":"Dubai Capitals","abbr":"DC","alt_name":"Dubai Capitals","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Rectangle-3348-2023-07-10T104951.123.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Rectangle-3348-2023-07-10T104951.123.png","country":"ae","sex":"male","team_owner":"","head_coach":"","scores_full":"165\/7 (20 ov)","scores":"165\/7","overs":"20"}],"players":[{"pid":348,"title":"Shakib Al Hasan","short_name":"S Al Hasan","first_name":"Shakib Al Hasan","last_name":"","middle_name":"","birthdate":"1987-03-24","birthplace":"Magura, Jessore","country":"bd","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":9,"facebook_profile":"https:\/\/www.facebook.com\/Shakib.Al.Hasan\/","twitter_profile":"https:\/\/twitter.com\/Sah75official","instagram_profile":"https:\/\/www.instagram.com\/shaki_b75\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Bangladesh","role":"all","role_str":""},{"pid":428,"title":"Gulbadin Naib","short_name":"G Naib","first_name":"Gulbadin Naib","last_name":"","middle_name":"","birthdate":"1991-06-04","birthplace":" Logar, Afghanistan","country":"af","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium 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":"Afghanistan","role":"all","role_str":"(C)"},{"pid":1085,"title":"Josh Clarkson","short_name":"JA Clarkson","first_name":"Josh Clarkson","last_name":"","middle_name":"","birthdate":"1997-01-21","birthplace":"","country":"nz","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bat","role_str":""},{"pid":1253,"title":"Dean Foxcroft","short_name":"D Foxcroft","first_name":"Dean Foxcroft","last_name":"","middle_name":"","birthdate":"1998-04-20","birthplace":"Pretoria, South Africa","country":"za","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":"https:\/\/twitter.com\/FoxcroftDean","instagram_profile":"https:\/\/www.instagram.com\/deanfoxcroft11\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"South Africa","role":"all","role_str":""},{"pid":1763,"title":"Niroshan Dickwella","short_name":"N Dickwella","first_name":"Niroshan Dickwella","last_name":"","middle_name":"","birthdate":"1993-06-23","birthplace":"Kandy","country":"lk","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/NiroshanDickwellaOfficial\/","twitter_profile":"https:\/\/twitter.com\/NiroshanDikka","instagram_profile":"https:\/\/www.instagram.com\/niroshan48dikka\/","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Sri Lanka","role":"wk","role_str":"(WK)"},{"pid":16609,"title":"Will Young","short_name":"W Young","first_name":"Will Young","last_name":"","middle_name":"","birthdate":"1992-11-22","birthplace":"New Plymouth","country":"nz","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":8.5,"facebook_profile":"https:\/\/www.facebook.com\/willyoung\/","twitter_profile":"https:\/\/twitter.com\/willyoung","instagram_profile":"https:\/\/www.instagram.com\/willyoungofficial\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bat","role_str":""},{"pid":16611,"title":"Dane Cleaver","short_name":"D Cleaver","first_name":"Dane Cleaver","last_name":"","middle_name":"","birthdate":"1992-01-01","birthplace":"Palmerston North","country":"nz","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"wicket keeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/dane_cleaver\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"wk","role_str":"(WK)"},{"pid":16613,"title":"Tom Bruce","short_name":"TC Bruce","first_name":"Tom Bruce","last_name":"","middle_name":"","birthdate":"1991-08-02","birthplace":"","country":"nz","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":23993,"recent_appearance":1514512800,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bat","role_str":"(C)"},{"pid":45056,"title":"Qais Ahmad","short_name":"Q Ahmad","first_name":"Qais Ahmad","last_name":"","middle_name":"","birthdate":"2000-08-15","birthplace":"Nangarhar","country":"af","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/qaisahmadkamawalFanpage\/","twitter_profile":"https:\/\/twitter.com\/Qais_AhmadK","instagram_profile":"https:\/\/www.instagram.com\/qais_ahmad_32\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Afghanistan","role":"squad","role_str":""},{"pid":46310,"title":"Blair Tickner","short_name":"BM Tickner","first_name":"Blair Tickner","last_name":"","middle_name":"","birthdate":"1993-10-13","birthplace":"Napier, Hawke''s Bay","country":"nz","primary_team":[],"logo_url":"","playing_role":"bowl","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":"https:\/\/www.facebook.com\/blair.tickner\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/ticks93\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bowl","role_str":""},{"pid":46314,"title":"Ajaz Patel","short_name":"AY Patel","first_name":"Ajaz Patel","last_name":"","middle_name":"","birthdate":"1988-10-21","birthplace":"Bombay (now Mumbai), Maharashtra, India","country":"nz","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/AjazP","instagram_profile":"https:\/\/www.instagram.com\/ajazpatel\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bowl","role_str":""},{"pid":49103,"title":"Doug Bracewell","short_name":"DAJ Bracewell","first_name":"Doug Bracewell","last_name":"","middle_name":"","birthdate":"1990-09-28","birthplace":"Tauranga, Bay of Plenty","country":"nz","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":23991,"recent_appearance":1513980000,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/dougalba\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bowl","role_str":""},{"pid":52193,"title":"Dominic Drakes","short_name":"DC Drakes","first_name":"Dominic Drakes","last_name":"","middle_name":"","birthdate":"1998-02-06","birthplace":"Barbados","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Dommie_48","instagram_profile":"https:\/\/www.instagram.com\/dommie48\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":55467,"title":"Rovman Powell","short_name":"R Powell","first_name":"Rovman Powell","last_name":"","middle_name":"","birthdate":"1993-07-23","birthplace":"Jamaica","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":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Ravipowell26","instagram_profile":"https:\/\/www.instagram.com\/ravipowell52\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":95500,"title":"William Clark","short_name":"William Clark","first_name":"William Clark","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"nz","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":"New Zealand","role":"all","role_str":""},{"pid":96421,"title":"Kaleem Sana","short_name":"K Sana","first_name":"Kaleem Sana","last_name":"","middle_name":"","birthdate":"1994-01-01","birthplace":"","country":"ca","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Canada","role":"bowl","role_str":""},{"pid":96509,"title":"Jayden Lennox","short_name":"J Lennox","first_name":"Jayden Lennox","last_name":"","middle_name":"","birthdate":"1994-12-14","birthplace":"","country":"nz","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":"New Zealand","role":"squad","role_str":""},{"pid":96610,"title":"Matthew Forde","short_name":"M Forde","first_name":"Matthew Forde","last_name":"","middle_name":"","birthdate":"2002-04-29","birthplace":"Barbados","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/matao_05\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":102259,"title":"Sediqullah Atal","short_name":"Sediqullah Atal","first_name":"Sediqullah Atal","last_name":"","middle_name":"","birthdate":"2001-08-12","birthplace":"","country":"af","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","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":"Afghanistan","role":"bat","role_str":""},{"pid":105224,"title":"Khalid Shah","short_name":"K Shah","first_name":"Khalid Shah","last_name":"","middle_name":"","birthdate":"1996-07-16","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"squad","role_str":""},{"pid":109449,"title":"Kadeem Alleyne","short_name":"K Alleyne","first_name":"Kadeem Alleyne","last_name":"","middle_name":"","birthdate":"2001-01-01","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":7,"facebook_profile":"https:\/\/www.facebook.com\/kadeem.alleyne.73\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/callmeelprofessor\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":111316,"title":"Khuzaima Bin Tanvir","short_name":"KB Tanvir","first_name":"Khuzaima Bin Tanvir","last_name":"","middle_name":"","birthdate":"1999-12-20","birthplace":"Faisalabad","country":"ae","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"bowl","role_str":""},{"pid":113125,"title":"Jordan Johnson","short_name":"J Johnson","first_name":"Jordan Johnson","last_name":"","middle_name":"","birthdate":"2005-04-26","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"Left Arm Wrist Spin","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":"wk","role_str":""},{"pid":114108,"title":"Jesse Bootan","short_name":"J Bootan","first_name":"Jesse Bootan","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":121286,"title":"Curtis Heaphy","short_name":"C Heaphy","first_name":"Curtis Heaphy","last_name":"","middle_name":"","birthdate":"2003-07-28","birthplace":"","country":"nz","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"squad","role_str":""},{"pid":123218,"title":"Angus Schaw","short_name":"A Schaw","first_name":"Angus Schaw","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"au","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":"Australia","role":"all","role_str":""},{"pid":124401,"title":"Farhan Khan","short_name":"F Khan","first_name":"Farhan Khan","last_name":"","middle_name":"","birthdate":"2004-04-25","birthplace":"Peshawar","country":"ae","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"squad","role_str":""},{"pid":125362,"title":"Toby Findlay","short_name":"T Findlay","first_name":"Toby Findlay","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"nz","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":"New Zealand","role":"squad","role_str":""},{"pid":140058,"title":"Zeeshan Naseer Ahmed","short_name":"Z Naseer","first_name":"Zeeshan Naseer Ahmed","last_name":"","middle_name":"","birthdate":"2000-04-01","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"bowl","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":"United Arab Emirates","role":"squad","role_str":""},{"pid":146094,"title":"Aryaman Varma","short_name":"A Varma","first_name":"Aryaman Varma","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"England","role":"all","role_str":""}]},"etag":"21e61430be6c14894a6155bac1e1afc7","modified":"2025-08-03 18:22:24","datetime":"2025-08-03 18:22:24","api_version":"3.0"}', Modified = GetDate() WHERE Id = 91178 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:a1e3577f-1066-4641-858f-96937b3c160c Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 91178 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (91178,3,'{"status":"ok","response":{"match_id":91178,"title":"Central Districts vs Dubai Capitals","short_title":"CD vs DC","subtitle":"1st Match","match_number":"1","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Dubai Capitals won by 22 runs","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129659,"title":"Global Super League","abbr":"Global Super League","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-07-10","dateend":"2025-07-18","country":"wi","total_matches":"10","total_rounds":"1","total_teams":"5"},"teama":{"team_id":13222,"name":"Central Districts","short_name":"CD","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Central_Stags_logo_transparent.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Central_Stags_logo_transparent.png","scores_full":"143\/8 (20 ov)","scores":"143\/8","overs":"20"},"teamb":{"team_id":127168,"name":"Dubai Capitals","short_name":"DC","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Rectangle-3348-2023-07-10T104951.123.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Rectangle-3348-2023-07-10T104951.123.png","scores_full":"165\/7 (20 ov)","scores":"165\/7","overs":"20"},"date_start":"2025-07-10 14:00:00","date_end":"2025-07-11 00:00:00","timestamp_start":1752156000,"timestamp_end":1752192000,"date_start_ist":"2025-07-10 19:30:00","date_end_ist":"2025-07-11 05:30:00","venue":{"venue_id":"35","name":"Providence Stadium","location":"Guyana","country":"West Indies","timezone":""},"umpires":"Carl Tuckett (West Indies), Chris Wright (West Indies), Christopher Taylor (West Indies, TV)","referee":"Reon King (West Indies)","equation":"","live":"","result":"DC won by 22 runs","result_type":2,"win_margin":"22 runs","winning_team_id":127168,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-08 20:23:22","verify_time":"2025-07-10 23:22:58","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":28.88,"humidity":76,"visibility":10000,"wind_speed":"5.86","clouds":93},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Slow Spin"},"toss":{"text":"Central Districts elected to bowl","winner":13222,"decision":2}},"etag":"b2812211080f7e34894f7aa5244d751c","modified":"2025-08-03 18:22:25","datetime":"2025-08-03 18:22:25","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":91178,"title":"Central Districts vs Dubai Capitals","short_title":"CD vs DC","subtitle":"1st Match","match_number":"1","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Dubai Capitals won by 22 runs","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129659,"title":"Global Super League","abbr":"Global Super League","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-07-10","dateend":"2025-07-18","country":"wi","total_matches":"10","total_rounds":"1","total_teams":"5"},"teama":{"team_id":13222,"name":"Central Districts","short_name":"CD","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Central_Stags_logo_transparent.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Central_Stags_logo_transparent.png","scores_full":"143\/8 (20 ov)","scores":"143\/8","overs":"20"},"teamb":{"team_id":127168,"name":"Dubai Capitals","short_name":"DC","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Rectangle-3348-2023-07-10T104951.123.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Rectangle-3348-2023-07-10T104951.123.png","scores_full":"165\/7 (20 ov)","scores":"165\/7","overs":"20"},"date_start":"2025-07-10 14:00:00","date_end":"2025-07-11 00:00:00","timestamp_start":1752156000,"timestamp_end":1752192000,"date_start_ist":"2025-07-10 19:30:00","date_end_ist":"2025-07-11 05:30:00","venue":{"venue_id":"35","name":"Providence Stadium","location":"Guyana","country":"West Indies","timezone":""},"umpires":"Carl Tuckett (West Indies), Chris Wright (West Indies), Christopher Taylor (West Indies, TV)","referee":"Reon King (West Indies)","equation":"","live":"","result":"DC won by 22 runs","result_type":2,"win_margin":"22 runs","winning_team_id":127168,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-08 20:23:22","verify_time":"2025-07-10 23:22:58","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":28.88,"humidity":76,"visibility":10000,"wind_speed":"5.86","clouds":93},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Slow Spin"},"toss":{"text":"Central Districts elected to bowl","winner":13222,"decision":2}},"etag":"b2812211080f7e34894f7aa5244d751c","modified":"2025-08-03 18:22:25","datetime":"2025-08-03 18:22:25","api_version":"3.0"}', Modified = GetDate() WHERE Id = 91178 AND DataTypeId = 3 END
Live Report & Scorecard of Central Districts vs Dubai Capitals 1st Match