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:64d5d3cb-ae68-4264-8f10-35d82de76179 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 89764 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (89764,1,'{"status":"ok","response":{"mid":89764,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Ajman won by 4 wickets","day_remaining_over":"","team_batting":"Ajman","team_bowling":"Sharjah","live_inning_number":2,"live_score":{"runs":90,"overs":9,"wickets":6,"target":87,"runrate":10,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Shoaib Ali","batsman_id":145538,"runs":9,"balls_faced":7,"fours":1,"sixes":0,"strike_rate":"128.57"},{"name":"Said Nazeer Afridi","batsman_id":95311,"runs":27,"balls_faced":10,"fours":1,"sixes":3,"strike_rate":"270.00"}],"bowlers":[{"name":"Awais Ali Shah","bowler_id":127701,"overs":1,"runs_conceded":20,"wickets":0,"maidens":0,"econ":"20.00"},{"name":"Khuzaima Bin Tanvir","bowler_id":111316,"overs":1,"runs_conceded":11,"wickets":0,"maidens":0,"econ":"11.00"}],"commentaries":[{"event_id":"12047484","event":"ball","batsman_id":"135446","bowler_id":"148733","over":"4","ball":"6","score":1,"commentary":"Ibrahim Masood to Muhammad Aftab Javed, 1 run,","noball_dismissal":false,"text":"","timestamp":1748624335,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":5,"runs":9,"score":"39\/4","bats":[{"runs":14,"balls_faced":11,"fours":2,"sixes":0,"batsman_id":135446},{"runs":7,"balls_faced":4,"fours":0,"sixes":1,"batsman_id":112810}],"bowls":[{"runs_conceded":18,"maidens":0,"wickets":1,"bowler_id":148733,"overs":2},{"runs_conceded":10,"maidens":0,"wickets":3,"bowler_id":137638,"overs":2}],"commentary":"End of over 5 (9 runs), Ajman 39\/4"},{"event_id":"12047499","event":"ball","batsman_id":"135446","bowler_id":"148732","over":"5","ball":"1","score":0,"commentary":"Daniyal Liyaquat to Muhammad Aftab Javed, no run,","noball_dismissal":false,"text":"","timestamp":1748624380,"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":"12047503","event":"ball","batsman_id":"135446","bowler_id":"148732","over":"5","ball":"2","score":6,"commentary":"Daniyal Liyaquat to Muhammad Aftab Javed, Six,","noball_dismissal":false,"text":"","timestamp":1748624403,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12047507","event":"ball","batsman_id":"135446","bowler_id":"148732","over":"5","ball":"3","score":2,"commentary":"Daniyal Liyaquat to Muhammad Aftab Javed, 2 runs,","noball_dismissal":false,"text":"","timestamp":1748624439,"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":"12047515","event":"wicket","batsman_id":"135446","bowler_id":"148732","over":"5","ball":"4","score":"w","commentary":"Daniyal Liyaquat to Muhammad Aftab Javed, no run, c & b D Liyaquat,","noball_dismissal":false,"text":"","timestamp":1748624500,"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":"135446","how_out":"c & b D Liyaquat","batsman_runs":"22","batsman_balls":"15"},{"event_id":"12047560","event":"ball","batsman_id":"145538","bowler_id":"148732","over":"5","ball":"5","score":1,"commentary":"Daniyal Liyaquat to Shoaib Ali, 1 run,","noball_dismissal":false,"text":"","timestamp":1748624777,"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":"12047561","event":"ball","batsman_id":"112810","bowler_id":"148732","over":"5","ball":"6","score":1,"commentary":"Daniyal Liyaquat to Harshit Seth, 1 run,","noball_dismissal":false,"text":"","timestamp":1748624779,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":6,"runs":10,"score":"49\/5","bats":[{"runs":8,"balls_faced":5,"fours":0,"sixes":1,"batsman_id":112810},{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":145538}],"bowls":[{"runs_conceded":21,"maidens":0,"wickets":1,"bowler_id":148732,"overs":2},{"runs_conceded":18,"maidens":0,"wickets":1,"bowler_id":148733,"overs":2}],"commentary":"End of over 6 (10 runs), Ajman 49\/5"},{"event_id":"12047563","event":"ball","batsman_id":"112810","bowler_id":"135817","over":"6","ball":"1","score":4,"commentary":"Muhammad Irfan Yousafzai Aurangzeb to Harshit Seth, Four,","noball_dismissal":false,"text":"","timestamp":1748624841,"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":"12047564","event":"ball","batsman_id":"112810","bowler_id":"135817","over":"6","ball":"2","score":1,"commentary":"Muhammad Irfan Yousafzai Aurangzeb to Harshit Seth, 1 run,","noball_dismissal":false,"text":"","timestamp":1748624845,"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":"12047565","event":"ball","batsman_id":"145538","bowler_id":"135817","over":"6","ball":"3","score":0,"commentary":"Muhammad Irfan Yousafzai Aurangzeb to Shoaib Ali, no run,","noball_dismissal":false,"text":"","timestamp":1748624848,"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":"12047566","event":"ball","batsman_id":"145538","bowler_id":"135817","over":"6","ball":"4","score":1,"commentary":"Muhammad Irfan Yousafzai Aurangzeb to Shoaib Ali, 1 run,","noball_dismissal":false,"text":"","timestamp":1748624852,"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":"12047573","event":"wicket","batsman_id":"112810","bowler_id":"135817","over":"6","ball":"5","score":"w","commentary":"Muhammad Irfan Yousafzai Aurangzeb to Harshit Seth, no run, c K Shah b M Aurangzeb,","noball_dismissal":false,"text":"","timestamp":1748624859,"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":"112810","how_out":"c K Shah b M Aurangzeb","batsman_runs":"13","batsman_balls":"8"},{"event_id":"12047582","event":"ball","batsman_id":"95311","bowler_id":"135817","over":"6","ball":"6","score":4,"commentary":"Muhammad Irfan Yousafzai Aurangzeb to Said Nazeer Afridi, Four,","noball_dismissal":false,"text":"","timestamp":1748624900,"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":7,"runs":10,"score":"59\/6","bats":[{"runs":4,"balls_faced":1,"fours":1,"sixes":0,"batsman_id":95311},{"runs":2,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":145538}],"bowls":[{"runs_conceded":10,"maidens":0,"wickets":1,"bowler_id":135817,"overs":1},{"runs_conceded":21,"maidens":0,"wickets":1,"bowler_id":148732,"overs":2}],"commentary":"End of over 7 (10 runs), Ajman 59\/6"},{"event_id":"12047600","event":"ball","batsman_id":"145538","bowler_id":"111316","over":"7","ball":"1","score":4,"commentary":"Khuzaima Bin Tanvir to Shoaib Ali, Four,","noball_dismissal":false,"text":"","timestamp":1748624996,"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":"12047608","event":"ball","batsman_id":"145538","bowler_id":"111316","over":"7","ball":"2","score":1,"commentary":"Khuzaima Bin Tanvir to Shoaib Ali, 1 run,","noball_dismissal":false,"text":"","timestamp":1748625058,"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":"12047615","event":"ball","batsman_id":"95311","bowler_id":"111316","over":"7","ball":"3","score":1,"commentary":"Khuzaima Bin Tanvir to Said Nazeer Afridi, 1 run,","noball_dismissal":false,"text":"","timestamp":1748625111,"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":"12047624","event":"ball","batsman_id":"145538","bowler_id":"111316","over":"7","ball":"4","score":"2nb","commentary":"Khuzaima Bin Tanvir to Shoaib Ali, 2 no ball,","noball_dismissal":false,"text":"","timestamp":1748625155,"run":2,"noball_run":"1","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":true,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12047632","event":"ball","batsman_id":"95311","bowler_id":"111316","over":"7","ball":"4","score":0,"commentary":"Khuzaima Bin Tanvir to Said Nazeer Afridi, no run,","noball_dismissal":false,"text":"","timestamp":1748625195,"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":"12047639","event":"ball","batsman_id":"95311","bowler_id":"111316","over":"7","ball":"5","score":2,"commentary":"Khuzaima Bin Tanvir to Said Nazeer Afridi, 2 runs,","noball_dismissal":false,"text":"","timestamp":1748625324,"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":"12047651","event":"ball","batsman_id":"95311","bowler_id":"111316","over":"7","ball":"6","score":1,"commentary":"Khuzaima Bin Tanvir to Said Nazeer Afridi, 1 run,","noball_dismissal":false,"text":"","timestamp":1748625327,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":8,"runs":11,"score":"70\/6","bats":[{"runs":8,"balls_faced":5,"fours":1,"sixes":0,"batsman_id":95311},{"runs":8,"balls_faced":6,"fours":1,"sixes":0,"batsman_id":145538}],"bowls":[{"runs_conceded":11,"maidens":0,"wickets":0,"bowler_id":111316,"overs":1},{"runs_conceded":10,"maidens":0,"wickets":1,"bowler_id":135817,"overs":1}],"commentary":"End of over 8 (11 runs), Ajman 70\/6"},{"event_id":"12047664","event":"ball","batsman_id":"95311","bowler_id":"127701","over":"8","ball":"1","score":6,"commentary":"Awais Ali Shah to Said Nazeer Afridi, Six,","noball_dismissal":false,"text":"","timestamp":1748625389,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12047670","event":"ball","batsman_id":"95311","bowler_id":"127701","over":"8","ball":"2","score":6,"commentary":"Awais Ali Shah to Said Nazeer Afridi, Six,","noball_dismissal":false,"text":"","timestamp":1748625410,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12047676","event":"ball","batsman_id":"95311","bowler_id":"127701","over":"8","ball":"3","score":1,"commentary":"Awais Ali Shah to Said Nazeer Afridi, 1 run,","noball_dismissal":false,"text":"","timestamp":1748625465,"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":"12047685","event":"ball","batsman_id":"145538","bowler_id":"127701","over":"8","ball":"4","score":1,"commentary":"Awais Ali Shah to Shoaib Ali, 1 run,","noball_dismissal":false,"text":"","timestamp":1748625541,"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":"12047686","event":"ball","batsman_id":"95311","bowler_id":"127701","over":"8","ball":"5","score":0,"commentary":"Awais Ali Shah to Said Nazeer Afridi, no run,","noball_dismissal":false,"text":"","timestamp":1748625545,"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":"12047688","event":"ball","batsman_id":"95311","bowler_id":"127701","over":"8","ball":"6","score":6,"commentary":"Awais Ali Shah to Said Nazeer Afridi, Six,","noball_dismissal":false,"text":"","timestamp":1748625549,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event":"overend","over":9,"runs":20,"score":"90\/6","bats":[{"runs":27,"balls_faced":10,"fours":1,"sixes":3,"batsman_id":95311},{"runs":9,"balls_faced":7,"fours":1,"sixes":0,"batsman_id":145538}],"bowls":[{"runs_conceded":20,"maidens":0,"wickets":0,"bowler_id":127701,"overs":1},{"runs_conceded":11,"maidens":0,"wickets":0,"bowler_id":111316,"overs":1}],"commentary":"End of over 9 (20 runs), Ajman 90\/6"}],"day":"0","session":"0","live_inning":{"iid":197191,"number":2,"name":"Ajman Inning","short_name":"AJM Inning","status":2,"issuperover":"false","result":3,"batting_team_id":116221,"fielding_team_id":116225,"scores":"90\/6","scores_full":"90\/6 (9 ov)","fielder":[{"fielder_id":"105224","fielder_name":"Khalid Shah","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"94179","fielder_name":"Alishan Sharafu","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"148733","fielder_name":"Ibrahim Masood","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"119551","fielder_name":"Mudit Agarwal","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"148732","fielder_name":"Daniyal Liyaquat","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"3"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Harshit Seth","batsman_id":"112810","runs":"13","balls":"8","how_out":"c K Shah b M Aurangzeb","score_at_dismissal":55,"overs_at_dismissal":"6.5","bowler_id":"135817","dismissal":"caught","number":6},"extra_runs":{"byes":0,"legbyes":0,"wides":0,"noballs":1,"penalty":"0","total":1},"equations":{"runs":90,"wickets":6,"overs":"9","bowlers_used":6,"runrate":"10.00"},"current_partnership":{"runs":35,"balls":14,"overs":2.2,"batsmen":[{"name":"Said Nazeer Afridi","batsman_id":95311,"runs":27,"balls":10},{"name":"Shoaib Ali","batsman_id":145538,"runs":7,"balls":4}]},"did_not_bat":[{"player_id":"113772","name":"Zohair Iqbal"},{"player_id":"125726","name":"Ali Iqbal"},{"player_id":"112843","name":"Essam Muti Ur Rab"}],"max_over":"10","target":"87","recent_scores":"6,0,1,1,6,6,1,2,0,2,1,1,4,4,w,1,0,1","last_five_overs":"60\/2 11.61","last_ten_overs":"90\/6 9.82"},"teams":[{"tid":116221,"title":"Ajman","abbr":"AJM","alt_name":"Ajman","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/06\/AJM-CR2@2x.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/06\/AJM-CR2@2x.png","country":"ae","sex":"male","team_owner":"","head_coach":"","scores_full":"90\/6 (9 ov)","scores":"90\/6","overs":"9"},{"tid":116225,"title":"Sharjah","abbr":"SHA","alt_name":"Sharjah","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/SHA-CR2@2x.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/SHA-CR2@2x.png","country":"ae","sex":"male","team_owner":"","head_coach":"","scores_full":"86\/10 (9.2 ov)","scores":"86\/10","overs":"9.2"}],"players":[{"pid":94168,"title":"Ansh Tandon","short_name":"A Tandon","first_name":"Ansh Tandon","last_name":"","middle_name":"","birthdate":"2001-11-08","birthplace":" New Delhi, India ","country":"ae","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left 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\/AnshTandon15","instagram_profile":"https:\/\/www.instagram.com\/anshtandon\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"bat","role_str":"(C)"},{"pid":94179,"title":"Alishan Sharafu","short_name":"A Sharafu","first_name":"Alishan Sharafu","last_name":"","middle_name":"","birthdate":"2003-01-10","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"bat","role_str":""},{"pid":94495,"title":"CP Rizwan","short_name":"CP Rizwan","first_name":"CP Rizwan","last_name":"","middle_name":"","birthdate":"1988-04-19","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"squad","role_str":""},{"pid":95311,"title":"Said Nazeer Afridi","short_name":"S Nazeer","first_name":"Said Nazeer Afridi","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bowl","role_str":""},{"pid":104640,"title":"Mohammed Halan Harris","short_name":"MH Harris","first_name":"Mohammed Halan Harris","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"bat","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":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","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":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"wk","role_str":"(C)"},{"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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"bowl","role_str":""},{"pid":112810,"title":"Harshit Seth","short_name":"H Seth","first_name":"Harshit Seth","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":""},{"pid":112811,"title":"Ankur Sangwan","short_name":"A Sangwan","first_name":"Ankur Sangwan","last_name":"","middle_name":"","birthdate":"1997-11-18","birthplace":"Delhi","country":"ae","primary_team":[],"logo_url":"","playing_role":"bowl","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":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"squad","role_str":""},{"pid":112843,"title":"Essam Muti Ur Rab","short_name":"E M Ur Rab","first_name":"Essam Muti Ur Rab","last_name":"","middle_name":"","birthdate":"","birthplace":"","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"bowl","role_str":""},{"pid":113402,"title":"Shahrukh Amin","short_name":"S Amin","first_name":"Shahrukh Amin","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"wk","role_str":""},{"pid":113711,"title":"Hameed Khan","short_name":"H Khan","first_name":"Hameed Khan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"squad","role_str":""},{"pid":113735,"title":"Salman Shahid","short_name":"S Shahid","first_name":"Salman Shahid","last_name":"","middle_name":"","birthdate":"1996-09-03","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"wk","role_str":"(WK)"},{"pid":113772,"title":"Zohair Iqbal","short_name":"Z Iqbal","first_name":"Zohair Iqbal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bowl","role_str":""},{"pid":114996,"title":"Muhammad Saghir Khan","short_name":"M S Khan","first_name":"Muhammad Saghir Khan","last_name":"","middle_name":"","birthdate":"1999-02-18","birthplace":"","country":"ae","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"squad","role_str":""},{"pid":119503,"title":"Muhammad Irfan-II","short_name":"M Irfan-II","first_name":"Muhammad Irfan-II","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"pk","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":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"squad","role_str":""},{"pid":119551,"title":"Mudit Agarwal","short_name":"M Agarwal","first_name":"Mudit Agarwal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","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":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"wk","role_str":"(WK)"},{"pid":125665,"title":"Noor Ullah Ayobi","short_name":"Noor Ullah Ayobi","first_name":"Noor Ullah Ayobi","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"af","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":"","thumb_url":"","profile_image":"","nationality":"Afghanistan","role":"bat","role_str":""},{"pid":125726,"title":"Ali Iqbal","short_name":"Ali Iqbal","first_name":"Ali Iqbal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bowl","role_str":""},{"pid":126544,"title":"Muzamil Qasim Khan","short_name":"M Q Khan","first_name":"Muzamil Qasim Khan","last_name":"","middle_name":"","birthdate":"1986-01-01","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"squad","role_str":""},{"pid":127701,"title":"Awais Ali Shah","short_name":"A Shah","first_name":"Awais Ali Shah","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"all","role_str":""},{"pid":132813,"title":"Luqman Faisal","short_name":"L Faisal","first_name":"Luqman Faisal","last_name":"","middle_name":"","birthdate":"2001-03-23","birthplace":"Swat","country":"pk","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"squad","role_str":""},{"pid":132866,"title":"Wasim Akram","short_name":"W Akram","first_name":"Wasim Akram","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"squad","role_str":""},{"pid":133147,"title":"Mohsin Khan","short_name":"M Khan","first_name":"Mohsin Khan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"squad","role_str":""},{"pid":135446,"title":"Muhammad Aftab Javed","short_name":"M Javed","first_name":"Muhammad Aftab Javed","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"all","role_str":""},{"pid":135817,"title":"Muhammad Irfan Yousafzai Aurangzeb","short_name":"M Aurangzeb","first_name":"Muhammad Irfan Yousafzai Aurangzeb","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"bowl","role_str":""},{"pid":137638,"title":"Tahir Zaman","short_name":"Tahir Zaman","first_name":"Tahir Zaman","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"bowl","role_str":""},{"pid":138303,"title":"Sohaib Khan","short_name":"S Khan","first_name":"Sohaib Khan","last_name":"","middle_name":"","birthdate":"1998-06-05","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":145538,"title":"Shoaib Ali","short_name":"S Ali","first_name":"Shoaib Ali","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"all","role_str":""},{"pid":148720,"title":"Usman Khan Shinwari","short_name":"U K Shinwari","first_name":"Usman Khan Shinwari","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"af","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":"","thumb_url":"","profile_image":"","nationality":"Afghanistan","role":"squad","role_str":""},{"pid":148721,"title":"Bazil Asim","short_name":"B Asim","first_name":"Bazil Asim","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","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":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"squad","role_str":""},{"pid":148731,"title":"Fathhur Rahman","short_name":"F Rahman","first_name":"Fathhur Rahman","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"lk","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Sri Lanka","role":"squad","role_str":""},{"pid":148732,"title":"Daniyal Liyaquat","short_name":"D Liyaquat","first_name":"Daniyal Liyaquat","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"pk","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":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"all","role_str":""},{"pid":148733,"title":"Ibrahim Masood","short_name":"I Masood","first_name":"Ibrahim Masood","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bowl","role_str":""}]},"etag":"a460b35eab7c84b5f7a563384868b154","modified":"2025-06-18 18:47:37","datetime":"2025-06-18 18:47:37","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":89764,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Ajman won by 4 wickets","day_remaining_over":"","team_batting":"Ajman","team_bowling":"Sharjah","live_inning_number":2,"live_score":{"runs":90,"overs":9,"wickets":6,"target":87,"runrate":10,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Shoaib Ali","batsman_id":145538,"runs":9,"balls_faced":7,"fours":1,"sixes":0,"strike_rate":"128.57"},{"name":"Said Nazeer Afridi","batsman_id":95311,"runs":27,"balls_faced":10,"fours":1,"sixes":3,"strike_rate":"270.00"}],"bowlers":[{"name":"Awais Ali Shah","bowler_id":127701,"overs":1,"runs_conceded":20,"wickets":0,"maidens":0,"econ":"20.00"},{"name":"Khuzaima Bin Tanvir","bowler_id":111316,"overs":1,"runs_conceded":11,"wickets":0,"maidens":0,"econ":"11.00"}],"commentaries":[{"event_id":"12047484","event":"ball","batsman_id":"135446","bowler_id":"148733","over":"4","ball":"6","score":1,"commentary":"Ibrahim Masood to Muhammad Aftab Javed, 1 run,","noball_dismissal":false,"text":"","timestamp":1748624335,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":5,"runs":9,"score":"39\/4","bats":[{"runs":14,"balls_faced":11,"fours":2,"sixes":0,"batsman_id":135446},{"runs":7,"balls_faced":4,"fours":0,"sixes":1,"batsman_id":112810}],"bowls":[{"runs_conceded":18,"maidens":0,"wickets":1,"bowler_id":148733,"overs":2},{"runs_conceded":10,"maidens":0,"wickets":3,"bowler_id":137638,"overs":2}],"commentary":"End of over 5 (9 runs), Ajman 39\/4"},{"event_id":"12047499","event":"ball","batsman_id":"135446","bowler_id":"148732","over":"5","ball":"1","score":0,"commentary":"Daniyal Liyaquat to Muhammad Aftab Javed, no run,","noball_dismissal":false,"text":"","timestamp":1748624380,"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":"12047503","event":"ball","batsman_id":"135446","bowler_id":"148732","over":"5","ball":"2","score":6,"commentary":"Daniyal Liyaquat to Muhammad Aftab Javed, Six,","noball_dismissal":false,"text":"","timestamp":1748624403,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12047507","event":"ball","batsman_id":"135446","bowler_id":"148732","over":"5","ball":"3","score":2,"commentary":"Daniyal Liyaquat to Muhammad Aftab Javed, 2 runs,","noball_dismissal":false,"text":"","timestamp":1748624439,"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":"12047515","event":"wicket","batsman_id":"135446","bowler_id":"148732","over":"5","ball":"4","score":"w","commentary":"Daniyal Liyaquat to Muhammad Aftab Javed, no run, c & b D Liyaquat,","noball_dismissal":false,"text":"","timestamp":1748624500,"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":"135446","how_out":"c & b D Liyaquat","batsman_runs":"22","batsman_balls":"15"},{"event_id":"12047560","event":"ball","batsman_id":"145538","bowler_id":"148732","over":"5","ball":"5","score":1,"commentary":"Daniyal Liyaquat to Shoaib Ali, 1 run,","noball_dismissal":false,"text":"","timestamp":1748624777,"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":"12047561","event":"ball","batsman_id":"112810","bowler_id":"148732","over":"5","ball":"6","score":1,"commentary":"Daniyal Liyaquat to Harshit Seth, 1 run,","noball_dismissal":false,"text":"","timestamp":1748624779,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":6,"runs":10,"score":"49\/5","bats":[{"runs":8,"balls_faced":5,"fours":0,"sixes":1,"batsman_id":112810},{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":145538}],"bowls":[{"runs_conceded":21,"maidens":0,"wickets":1,"bowler_id":148732,"overs":2},{"runs_conceded":18,"maidens":0,"wickets":1,"bowler_id":148733,"overs":2}],"commentary":"End of over 6 (10 runs), Ajman 49\/5"},{"event_id":"12047563","event":"ball","batsman_id":"112810","bowler_id":"135817","over":"6","ball":"1","score":4,"commentary":"Muhammad Irfan Yousafzai Aurangzeb to Harshit Seth, Four,","noball_dismissal":false,"text":"","timestamp":1748624841,"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":"12047564","event":"ball","batsman_id":"112810","bowler_id":"135817","over":"6","ball":"2","score":1,"commentary":"Muhammad Irfan Yousafzai Aurangzeb to Harshit Seth, 1 run,","noball_dismissal":false,"text":"","timestamp":1748624845,"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":"12047565","event":"ball","batsman_id":"145538","bowler_id":"135817","over":"6","ball":"3","score":0,"commentary":"Muhammad Irfan Yousafzai Aurangzeb to Shoaib Ali, no run,","noball_dismissal":false,"text":"","timestamp":1748624848,"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":"12047566","event":"ball","batsman_id":"145538","bowler_id":"135817","over":"6","ball":"4","score":1,"commentary":"Muhammad Irfan Yousafzai Aurangzeb to Shoaib Ali, 1 run,","noball_dismissal":false,"text":"","timestamp":1748624852,"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":"12047573","event":"wicket","batsman_id":"112810","bowler_id":"135817","over":"6","ball":"5","score":"w","commentary":"Muhammad Irfan Yousafzai Aurangzeb to Harshit Seth, no run, c K Shah b M Aurangzeb,","noball_dismissal":false,"text":"","timestamp":1748624859,"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":"112810","how_out":"c K Shah b M Aurangzeb","batsman_runs":"13","batsman_balls":"8"},{"event_id":"12047582","event":"ball","batsman_id":"95311","bowler_id":"135817","over":"6","ball":"6","score":4,"commentary":"Muhammad Irfan Yousafzai Aurangzeb to Said Nazeer Afridi, Four,","noball_dismissal":false,"text":"","timestamp":1748624900,"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":7,"runs":10,"score":"59\/6","bats":[{"runs":4,"balls_faced":1,"fours":1,"sixes":0,"batsman_id":95311},{"runs":2,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":145538}],"bowls":[{"runs_conceded":10,"maidens":0,"wickets":1,"bowler_id":135817,"overs":1},{"runs_conceded":21,"maidens":0,"wickets":1,"bowler_id":148732,"overs":2}],"commentary":"End of over 7 (10 runs), Ajman 59\/6"},{"event_id":"12047600","event":"ball","batsman_id":"145538","bowler_id":"111316","over":"7","ball":"1","score":4,"commentary":"Khuzaima Bin Tanvir to Shoaib Ali, Four,","noball_dismissal":false,"text":"","timestamp":1748624996,"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":"12047608","event":"ball","batsman_id":"145538","bowler_id":"111316","over":"7","ball":"2","score":1,"commentary":"Khuzaima Bin Tanvir to Shoaib Ali, 1 run,","noball_dismissal":false,"text":"","timestamp":1748625058,"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":"12047615","event":"ball","batsman_id":"95311","bowler_id":"111316","over":"7","ball":"3","score":1,"commentary":"Khuzaima Bin Tanvir to Said Nazeer Afridi, 1 run,","noball_dismissal":false,"text":"","timestamp":1748625111,"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":"12047624","event":"ball","batsman_id":"145538","bowler_id":"111316","over":"7","ball":"4","score":"2nb","commentary":"Khuzaima Bin Tanvir to Shoaib Ali, 2 no ball,","noball_dismissal":false,"text":"","timestamp":1748625155,"run":2,"noball_run":"1","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":true,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12047632","event":"ball","batsman_id":"95311","bowler_id":"111316","over":"7","ball":"4","score":0,"commentary":"Khuzaima Bin Tanvir to Said Nazeer Afridi, no run,","noball_dismissal":false,"text":"","timestamp":1748625195,"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":"12047639","event":"ball","batsman_id":"95311","bowler_id":"111316","over":"7","ball":"5","score":2,"commentary":"Khuzaima Bin Tanvir to Said Nazeer Afridi, 2 runs,","noball_dismissal":false,"text":"","timestamp":1748625324,"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":"12047651","event":"ball","batsman_id":"95311","bowler_id":"111316","over":"7","ball":"6","score":1,"commentary":"Khuzaima Bin Tanvir to Said Nazeer Afridi, 1 run,","noball_dismissal":false,"text":"","timestamp":1748625327,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":8,"runs":11,"score":"70\/6","bats":[{"runs":8,"balls_faced":5,"fours":1,"sixes":0,"batsman_id":95311},{"runs":8,"balls_faced":6,"fours":1,"sixes":0,"batsman_id":145538}],"bowls":[{"runs_conceded":11,"maidens":0,"wickets":0,"bowler_id":111316,"overs":1},{"runs_conceded":10,"maidens":0,"wickets":1,"bowler_id":135817,"overs":1}],"commentary":"End of over 8 (11 runs), Ajman 70\/6"},{"event_id":"12047664","event":"ball","batsman_id":"95311","bowler_id":"127701","over":"8","ball":"1","score":6,"commentary":"Awais Ali Shah to Said Nazeer Afridi, Six,","noball_dismissal":false,"text":"","timestamp":1748625389,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12047670","event":"ball","batsman_id":"95311","bowler_id":"127701","over":"8","ball":"2","score":6,"commentary":"Awais Ali Shah to Said Nazeer Afridi, Six,","noball_dismissal":false,"text":"","timestamp":1748625410,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12047676","event":"ball","batsman_id":"95311","bowler_id":"127701","over":"8","ball":"3","score":1,"commentary":"Awais Ali Shah to Said Nazeer Afridi, 1 run,","noball_dismissal":false,"text":"","timestamp":1748625465,"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":"12047685","event":"ball","batsman_id":"145538","bowler_id":"127701","over":"8","ball":"4","score":1,"commentary":"Awais Ali Shah to Shoaib Ali, 1 run,","noball_dismissal":false,"text":"","timestamp":1748625541,"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":"12047686","event":"ball","batsman_id":"95311","bowler_id":"127701","over":"8","ball":"5","score":0,"commentary":"Awais Ali Shah to Said Nazeer Afridi, no run,","noball_dismissal":false,"text":"","timestamp":1748625545,"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":"12047688","event":"ball","batsman_id":"95311","bowler_id":"127701","over":"8","ball":"6","score":6,"commentary":"Awais Ali Shah to Said Nazeer Afridi, Six,","noball_dismissal":false,"text":"","timestamp":1748625549,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event":"overend","over":9,"runs":20,"score":"90\/6","bats":[{"runs":27,"balls_faced":10,"fours":1,"sixes":3,"batsman_id":95311},{"runs":9,"balls_faced":7,"fours":1,"sixes":0,"batsman_id":145538}],"bowls":[{"runs_conceded":20,"maidens":0,"wickets":0,"bowler_id":127701,"overs":1},{"runs_conceded":11,"maidens":0,"wickets":0,"bowler_id":111316,"overs":1}],"commentary":"End of over 9 (20 runs), Ajman 90\/6"}],"day":"0","session":"0","live_inning":{"iid":197191,"number":2,"name":"Ajman Inning","short_name":"AJM Inning","status":2,"issuperover":"false","result":3,"batting_team_id":116221,"fielding_team_id":116225,"scores":"90\/6","scores_full":"90\/6 (9 ov)","fielder":[{"fielder_id":"105224","fielder_name":"Khalid Shah","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"94179","fielder_name":"Alishan Sharafu","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"148733","fielder_name":"Ibrahim Masood","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"119551","fielder_name":"Mudit Agarwal","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"148732","fielder_name":"Daniyal Liyaquat","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"3"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Harshit Seth","batsman_id":"112810","runs":"13","balls":"8","how_out":"c K Shah b M Aurangzeb","score_at_dismissal":55,"overs_at_dismissal":"6.5","bowler_id":"135817","dismissal":"caught","number":6},"extra_runs":{"byes":0,"legbyes":0,"wides":0,"noballs":1,"penalty":"0","total":1},"equations":{"runs":90,"wickets":6,"overs":"9","bowlers_used":6,"runrate":"10.00"},"current_partnership":{"runs":35,"balls":14,"overs":2.2,"batsmen":[{"name":"Said Nazeer Afridi","batsman_id":95311,"runs":27,"balls":10},{"name":"Shoaib Ali","batsman_id":145538,"runs":7,"balls":4}]},"did_not_bat":[{"player_id":"113772","name":"Zohair Iqbal"},{"player_id":"125726","name":"Ali Iqbal"},{"player_id":"112843","name":"Essam Muti Ur Rab"}],"max_over":"10","target":"87","recent_scores":"6,0,1,1,6,6,1,2,0,2,1,1,4,4,w,1,0,1","last_five_overs":"60\/2 11.61","last_ten_overs":"90\/6 9.82"},"teams":[{"tid":116221,"title":"Ajman","abbr":"AJM","alt_name":"Ajman","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/06\/AJM-CR2@2x.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/06\/AJM-CR2@2x.png","country":"ae","sex":"male","team_owner":"","head_coach":"","scores_full":"90\/6 (9 ov)","scores":"90\/6","overs":"9"},{"tid":116225,"title":"Sharjah","abbr":"SHA","alt_name":"Sharjah","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/SHA-CR2@2x.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/SHA-CR2@2x.png","country":"ae","sex":"male","team_owner":"","head_coach":"","scores_full":"86\/10 (9.2 ov)","scores":"86\/10","overs":"9.2"}],"players":[{"pid":94168,"title":"Ansh Tandon","short_name":"A Tandon","first_name":"Ansh Tandon","last_name":"","middle_name":"","birthdate":"2001-11-08","birthplace":" New Delhi, India ","country":"ae","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left 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\/AnshTandon15","instagram_profile":"https:\/\/www.instagram.com\/anshtandon\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"bat","role_str":"(C)"},{"pid":94179,"title":"Alishan Sharafu","short_name":"A Sharafu","first_name":"Alishan Sharafu","last_name":"","middle_name":"","birthdate":"2003-01-10","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"bat","role_str":""},{"pid":94495,"title":"CP Rizwan","short_name":"CP Rizwan","first_name":"CP Rizwan","last_name":"","middle_name":"","birthdate":"1988-04-19","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"squad","role_str":""},{"pid":95311,"title":"Said Nazeer Afridi","short_name":"S Nazeer","first_name":"Said Nazeer Afridi","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bowl","role_str":""},{"pid":104640,"title":"Mohammed Halan Harris","short_name":"MH Harris","first_name":"Mohammed Halan Harris","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"bat","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":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","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":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"wk","role_str":"(C)"},{"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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"bowl","role_str":""},{"pid":112810,"title":"Harshit Seth","short_name":"H Seth","first_name":"Harshit Seth","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":""},{"pid":112811,"title":"Ankur Sangwan","short_name":"A Sangwan","first_name":"Ankur Sangwan","last_name":"","middle_name":"","birthdate":"1997-11-18","birthplace":"Delhi","country":"ae","primary_team":[],"logo_url":"","playing_role":"bowl","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":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"squad","role_str":""},{"pid":112843,"title":"Essam Muti Ur Rab","short_name":"E M Ur Rab","first_name":"Essam Muti Ur Rab","last_name":"","middle_name":"","birthdate":"","birthplace":"","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"bowl","role_str":""},{"pid":113402,"title":"Shahrukh Amin","short_name":"S Amin","first_name":"Shahrukh Amin","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"wk","role_str":""},{"pid":113711,"title":"Hameed Khan","short_name":"H Khan","first_name":"Hameed Khan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"squad","role_str":""},{"pid":113735,"title":"Salman Shahid","short_name":"S Shahid","first_name":"Salman Shahid","last_name":"","middle_name":"","birthdate":"1996-09-03","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"wk","role_str":"(WK)"},{"pid":113772,"title":"Zohair Iqbal","short_name":"Z Iqbal","first_name":"Zohair Iqbal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bowl","role_str":""},{"pid":114996,"title":"Muhammad Saghir Khan","short_name":"M S Khan","first_name":"Muhammad Saghir Khan","last_name":"","middle_name":"","birthdate":"1999-02-18","birthplace":"","country":"ae","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"squad","role_str":""},{"pid":119503,"title":"Muhammad Irfan-II","short_name":"M Irfan-II","first_name":"Muhammad Irfan-II","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"pk","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":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"squad","role_str":""},{"pid":119551,"title":"Mudit Agarwal","short_name":"M Agarwal","first_name":"Mudit Agarwal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","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":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"wk","role_str":"(WK)"},{"pid":125665,"title":"Noor Ullah Ayobi","short_name":"Noor Ullah Ayobi","first_name":"Noor Ullah Ayobi","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"af","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":"","thumb_url":"","profile_image":"","nationality":"Afghanistan","role":"bat","role_str":""},{"pid":125726,"title":"Ali Iqbal","short_name":"Ali Iqbal","first_name":"Ali Iqbal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bowl","role_str":""},{"pid":126544,"title":"Muzamil Qasim Khan","short_name":"M Q Khan","first_name":"Muzamil Qasim Khan","last_name":"","middle_name":"","birthdate":"1986-01-01","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"squad","role_str":""},{"pid":127701,"title":"Awais Ali Shah","short_name":"A Shah","first_name":"Awais Ali Shah","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"all","role_str":""},{"pid":132813,"title":"Luqman Faisal","short_name":"L Faisal","first_name":"Luqman Faisal","last_name":"","middle_name":"","birthdate":"2001-03-23","birthplace":"Swat","country":"pk","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"squad","role_str":""},{"pid":132866,"title":"Wasim Akram","short_name":"W Akram","first_name":"Wasim Akram","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"squad","role_str":""},{"pid":133147,"title":"Mohsin Khan","short_name":"M Khan","first_name":"Mohsin Khan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"squad","role_str":""},{"pid":135446,"title":"Muhammad Aftab Javed","short_name":"M Javed","first_name":"Muhammad Aftab Javed","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"all","role_str":""},{"pid":135817,"title":"Muhammad Irfan Yousafzai Aurangzeb","short_name":"M Aurangzeb","first_name":"Muhammad Irfan Yousafzai Aurangzeb","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"bowl","role_str":""},{"pid":137638,"title":"Tahir Zaman","short_name":"Tahir Zaman","first_name":"Tahir Zaman","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"bowl","role_str":""},{"pid":138303,"title":"Sohaib Khan","short_name":"S Khan","first_name":"Sohaib Khan","last_name":"","middle_name":"","birthdate":"1998-06-05","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":145538,"title":"Shoaib Ali","short_name":"S Ali","first_name":"Shoaib Ali","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"all","role_str":""},{"pid":148720,"title":"Usman Khan Shinwari","short_name":"U K Shinwari","first_name":"Usman Khan Shinwari","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"af","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":"","thumb_url":"","profile_image":"","nationality":"Afghanistan","role":"squad","role_str":""},{"pid":148721,"title":"Bazil Asim","short_name":"B Asim","first_name":"Bazil Asim","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ae","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":"","thumb_url":"","profile_image":"","nationality":"United Arab Emirates","role":"squad","role_str":""},{"pid":148731,"title":"Fathhur Rahman","short_name":"F Rahman","first_name":"Fathhur Rahman","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"lk","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Sri Lanka","role":"squad","role_str":""},{"pid":148732,"title":"Daniyal Liyaquat","short_name":"D Liyaquat","first_name":"Daniyal Liyaquat","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"pk","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":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"all","role_str":""},{"pid":148733,"title":"Ibrahim Masood","short_name":"I Masood","first_name":"Ibrahim Masood","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bowl","role_str":""}]},"etag":"a460b35eab7c84b5f7a563384868b154","modified":"2025-06-18 18:47:37","datetime":"2025-06-18 18:47:37","api_version":"3.0"}', Modified = GetDate() WHERE Id = 89764 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:64d5d3cb-ae68-4264-8f10-35d82de76179 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 89764 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (89764,3,'{"status":"ok","response":{"match_id":89764,"title":"Sharjah vs Ajman","short_title":"SHA vs AJM","subtitle":"Match 41","match_number":"41","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Ajman won by 4 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129576,"title":"Emirates D10 Tournament ","abbr":"Emirates D10","type":"tournament","category":"domestic","match_format":"t10","season":"2025","status":"live","datestart":"2025-05-12","dateend":"2025-05-31","country":"ae","total_matches":"45","total_rounds":"1","total_teams":"7"},"teama":{"team_id":116225,"name":"Sharjah","short_name":"SHA","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/SHA-CR2@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/SHA-CR2@2x.png","scores_full":"86\/10 (9.2 ov)","scores":"86\/10","overs":"9.2"},"teamb":{"team_id":116221,"name":"Ajman","short_name":"AJM","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/06\/AJM-CR2@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/06\/AJM-CR2@2x.png","scores_full":"90\/6 (9 ov)","scores":"90\/6","overs":"9"},"date_start":"2025-05-30 15:30:00","date_end":"2025-05-31 01:30:00","timestamp_start":1748619000,"timestamp_end":1748655000,"date_start_ist":"2025-05-30 21:00:00","date_end_ist":"2025-05-31 07:00:00","venue":{"venue_id":"98","name":"Sharjah Cricket Stadium","location":"Sharjah","country":"United Arab Emirates","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"AJM won by 4 wickets","result_type":2,"win_margin":"4 wickets","winning_team_id":116221,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-05-29 19:07:08","verify_time":"2025-05-30 23:16:07","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"broken clouds","temp":33.21,"humidity":63,"visibility":10000,"wind_speed":"4.09","clouds":82},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Sharjah elected to bat","winner":116225,"decision":1}},"etag":"a54ef0e4bbd6755e6d97684db8b78240","modified":"2025-06-18 18:47:38","datetime":"2025-06-18 18:47:38","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":89764,"title":"Sharjah vs Ajman","short_title":"SHA vs AJM","subtitle":"Match 41","match_number":"41","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Ajman won by 4 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129576,"title":"Emirates D10 Tournament ","abbr":"Emirates D10","type":"tournament","category":"domestic","match_format":"t10","season":"2025","status":"live","datestart":"2025-05-12","dateend":"2025-05-31","country":"ae","total_matches":"45","total_rounds":"1","total_teams":"7"},"teama":{"team_id":116225,"name":"Sharjah","short_name":"SHA","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/SHA-CR2@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/SHA-CR2@2x.png","scores_full":"86\/10 (9.2 ov)","scores":"86\/10","overs":"9.2"},"teamb":{"team_id":116221,"name":"Ajman","short_name":"AJM","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/06\/AJM-CR2@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/06\/AJM-CR2@2x.png","scores_full":"90\/6 (9 ov)","scores":"90\/6","overs":"9"},"date_start":"2025-05-30 15:30:00","date_end":"2025-05-31 01:30:00","timestamp_start":1748619000,"timestamp_end":1748655000,"date_start_ist":"2025-05-30 21:00:00","date_end_ist":"2025-05-31 07:00:00","venue":{"venue_id":"98","name":"Sharjah Cricket Stadium","location":"Sharjah","country":"United Arab Emirates","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"AJM won by 4 wickets","result_type":2,"win_margin":"4 wickets","winning_team_id":116221,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-05-29 19:07:08","verify_time":"2025-05-30 23:16:07","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"broken clouds","temp":33.21,"humidity":63,"visibility":10000,"wind_speed":"4.09","clouds":82},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Sharjah elected to bat","winner":116225,"decision":1}},"etag":"a54ef0e4bbd6755e6d97684db8b78240","modified":"2025-06-18 18:47:38","datetime":"2025-06-18 18:47:38","api_version":"3.0"}', Modified = GetDate() WHERE Id = 89764 AND DataTypeId = 3 END
Live Report & Scorecard of Sharjah vs Ajman Match 41