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:79fe99ed-f508-463e-85be-cb34a6e9c8d9
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 91447 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (91447,1,'{"status":"ok","response":{"mid":91447,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Dussledorf Blackcaps won by 8 wickets","day_remaining_over":"","team_batting":"Dussledorf Blackcaps","team_bowling":"Bonn Blue Star","live_inning_number":2,"live_score":{"runs":168,"overs":7.1,"wickets":2,"target":168,"runrate":23.44,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Ubaid Manzoor","batsman_id":130955,"runs":26,"balls_faced":7,"fours":2,"sixes":3,"strike_rate":"371.43"},{"name":"Kashif Shahab","batsman_id":108069,"runs":8,"balls_faced":3,"fours":0,"sixes":1,"strike_rate":"266.67"}],"bowlers":[{"name":"Banny Brar","bowler_id":130705,"overs":0.1,"runs_conceded":1,"wickets":0,"maidens":0,"econ":"6.00"},{"name":"Ameya Deshpande","bowler_id":108088,"overs":1,"runs_conceded":25,"wickets":1,"maidens":0,"econ":"25.00"}],"commentaries":[{"event_id":"12355141","event":"ball","batsman_id":"108061","bowler_id":"118821","over":"3","ball":"1","score":6,"commentary":"Niamat Safi to Jamshed Mutahidi, Six,","noball_dismissal":false,"text":"","timestamp":1752754970,"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":"12355142","event":"ball","batsman_id":"108061","bowler_id":"118821","over":"3","ball":"2","score":6,"commentary":"Niamat Safi to Jamshed Mutahidi, Six,","noball_dismissal":false,"text":"","timestamp":1752755001,"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":"12355144","event":"ball","batsman_id":"108061","bowler_id":"118821","over":"3","ball":"3","score":4,"commentary":"Niamat Safi to Jamshed Mutahidi, Four,","noball_dismissal":false,"text":"","timestamp":1752755039,"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":"12355145","event":"ball","batsman_id":"108061","bowler_id":"118821","over":"3","ball":"4","score":6,"commentary":"Niamat Safi to Jamshed Mutahidi, Six,","noball_dismissal":false,"text":"","timestamp":1752755136,"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":"12355147","event":"ball","batsman_id":"108061","bowler_id":"118821","over":"3","ball":"5","score":6,"commentary":"Niamat Safi to Jamshed Mutahidi, Six,","noball_dismissal":false,"text":"","timestamp":1752755140,"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":"12355150","event":"ball","batsman_id":"108061","bowler_id":"118821","over":"3","ball":"6","score":4,"commentary":"Niamat Safi to Jamshed Mutahidi, Four,","noball_dismissal":false,"text":"","timestamp":1752755238,"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":4,"runs":32,"score":"101\/0","bats":[{"runs":73,"balls_faced":17,"fours":7,"sixes":7,"batsman_id":108061},{"runs":26,"balls_faced":7,"fours":2,"sixes":3,"batsman_id":130958}],"bowls":[{"runs_conceded":54,"maidens":0,"wickets":0,"bowler_id":118821,"overs":2},{"runs_conceded":19,"maidens":0,"wickets":0,"bowler_id":150576,"overs":1}],"commentary":"End of over 4 (32 runs), Dussledorf Blackcaps 101\/0"},{"event_id":"12355151","event":"ball","batsman_id":"130958","bowler_id":"62005","over":"4","ball":"1","score":6,"commentary":"Asad Mohammad to Udit Mehta, Six,","noball_dismissal":false,"text":"","timestamp":1752755271,"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":"12355152","event":"ball","batsman_id":"130958","bowler_id":"62005","over":"4","ball":"2","score":6,"commentary":"Asad Mohammad to Udit Mehta, Six,","noball_dismissal":false,"text":"","timestamp":1752755286,"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":"12355153","event":"ball","batsman_id":"130958","bowler_id":"62005","over":"4","ball":"3","score":6,"commentary":"Asad Mohammad to Udit Mehta, Six,","noball_dismissal":false,"text":"","timestamp":1752755317,"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":"12355154","event":"ball","batsman_id":"130958","bowler_id":"62005","over":"4","ball":"4","score":6,"commentary":"Asad Mohammad to Udit Mehta, Six,","noball_dismissal":false,"text":"","timestamp":1752755351,"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":"12355159","event":"wicket","batsman_id":"130958","bowler_id":"62005","over":"4","ball":"5","score":"w","commentary":"Asad Mohammad to Udit Mehta, no run, b Asad Mohammad,","noball_dismissal":false,"text":"","timestamp":1752755396,"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":"130958","how_out":"b Asad Mohammad","batsman_runs":"50","batsman_balls":"12"},{"event_id":"12355161","event":"ball","batsman_id":"130955","bowler_id":"62005","over":"4","ball":"6","score":0,"commentary":"Asad Mohammad to Ubaid Manzoor, no run,","noball_dismissal":false,"text":"","timestamp":1752755508,"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":5,"runs":24,"score":"125\/1","bats":[{"runs":0,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":130955},{"runs":73,"balls_faced":17,"fours":7,"sixes":7,"batsman_id":108061}],"bowls":[{"runs_conceded":24,"maidens":0,"wickets":1,"bowler_id":62005,"overs":1},{"runs_conceded":54,"maidens":0,"wickets":0,"bowler_id":118821,"overs":2}],"commentary":"End of over 5 (24 runs), Dussledorf Blackcaps 125\/1"},{"event_id":"12355166","event":"ball","batsman_id":"108061","bowler_id":"150576","over":"5","ball":"1","score":6,"commentary":"Kiran Kumaraswamy to Jamshed Mutahidi, Six,","noball_dismissal":false,"text":"","timestamp":1752755528,"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":"12355167","event":"ball","batsman_id":"108061","bowler_id":"150576","over":"5","ball":"2","score":0,"commentary":"Kiran Kumaraswamy to Jamshed Mutahidi, no run,","noball_dismissal":false,"text":"","timestamp":1752755567,"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":"12355170","event":"ball","batsman_id":"108061","bowler_id":"150576","over":"5","ball":"3","score":1,"commentary":"Kiran Kumaraswamy to Jamshed Mutahidi, 1 run,","noball_dismissal":false,"text":"","timestamp":1752755608,"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":"12355171","event":"ball","batsman_id":"130955","bowler_id":"150576","over":"5","ball":"4","score":4,"commentary":"Kiran Kumaraswamy to Ubaid Manzoor, Four,","noball_dismissal":false,"text":"","timestamp":1752755637,"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":"12355173","event":"ball","batsman_id":"130955","bowler_id":"150576","over":"5","ball":"5","score":6,"commentary":"Kiran Kumaraswamy to Ubaid Manzoor, Six,","noball_dismissal":false,"text":"","timestamp":1752755669,"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":"12355175","event":"ball","batsman_id":"130955","bowler_id":"150576","over":"5","ball":"6","score":0,"commentary":"Kiran Kumaraswamy to Ubaid Manzoor, no run,","noball_dismissal":false,"text":"","timestamp":1752755779,"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":6,"runs":17,"score":"142\/1","bats":[{"runs":10,"balls_faced":4,"fours":1,"sixes":1,"batsman_id":130955},{"runs":80,"balls_faced":20,"fours":7,"sixes":8,"batsman_id":108061}],"bowls":[{"runs_conceded":36,"maidens":0,"wickets":0,"bowler_id":150576,"overs":2},{"runs_conceded":24,"maidens":0,"wickets":1,"bowler_id":62005,"overs":1}],"commentary":"End of over 6 (17 runs), Dussledorf Blackcaps 142\/1"},{"event_id":"12355184","event":"ball","batsman_id":"108061","bowler_id":"108088","over":"6","ball":"1","score":"1wd","commentary":"Ameya Deshpande to Jamshed Mutahidi, 1 wide,","noball_dismissal":false,"text":"","timestamp":1752755809,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12355187","event":"wicket","batsman_id":"108061","bowler_id":"108088","over":"6","ball":"1","score":"w","commentary":"Ameya Deshpande to Jamshed Mutahidi, no run, c H Khan b A Deshpande,","noball_dismissal":false,"text":"","timestamp":1752755818,"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":"108061","how_out":"c H Khan b A Deshpande","batsman_runs":"80","batsman_balls":"21"},{"event_id":"12355190","event":"ball","batsman_id":"108069","bowler_id":"108088","over":"6","ball":"2","score":"1wd","commentary":"Ameya Deshpande to Kashif Shahab, 1 wide,","noball_dismissal":false,"text":"","timestamp":1752755976,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12355195","event":"ball","batsman_id":"108069","bowler_id":"108088","over":"6","ball":"2","score":6,"commentary":"Ameya Deshpande to Kashif Shahab, Six,","noball_dismissal":false,"text":"","timestamp":1752755987,"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":"12355196","event":"ball","batsman_id":"108069","bowler_id":"108088","over":"6","ball":"3","score":1,"commentary":"Ameya Deshpande to Kashif Shahab, 1 run,","noball_dismissal":false,"text":"","timestamp":1752756061,"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":"12355197","event":"ball","batsman_id":"130955","bowler_id":"108088","over":"6","ball":"4","score":4,"commentary":"Ameya Deshpande to Ubaid Manzoor, Four,","noball_dismissal":false,"text":"","timestamp":1752756072,"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":"12355202","event":"ball","batsman_id":"130955","bowler_id":"108088","over":"6","ball":"5","score":6,"commentary":"Ameya Deshpande to Ubaid Manzoor, Six,","noball_dismissal":false,"text":"","timestamp":1752756075,"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":"12355203","event":"ball","batsman_id":"130955","bowler_id":"108088","over":"6","ball":"6","score":6,"commentary":"Ameya Deshpande to Ubaid Manzoor, Six,","noball_dismissal":false,"text":"","timestamp":1752756078,"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":7,"runs":25,"score":"167\/2","bats":[{"runs":26,"balls_faced":7,"fours":2,"sixes":3,"batsman_id":130955},{"runs":7,"balls_faced":2,"fours":0,"sixes":1,"batsman_id":108069}],"bowls":[{"runs_conceded":25,"maidens":0,"wickets":1,"bowler_id":108088,"overs":1},{"runs_conceded":36,"maidens":0,"wickets":0,"bowler_id":150576,"overs":2}],"commentary":"End of over 7 (25 runs), Dussledorf Blackcaps 167\/2"},{"event_id":"12355204","event":"ball","batsman_id":"108069","bowler_id":"130705","over":"7","ball":"1","score":1,"commentary":"Banny Brar to Kashif Shahab, 1 run,","noball_dismissal":false,"text":"","timestamp":1752756096,"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}],"day":"0","session":"0","live_inning":{"iid":199720,"number":2,"name":"Dussledorf Blackcaps Inning","short_name":"DB Inning","status":2,"issuperover":"false","result":3,"batting_team_id":119937,"fielding_team_id":119942,"scores":"168\/2","scores_full":"168\/2 (7.1 ov)","fielder":[{"fielder_id":"108116","fielder_name":"Haron Khan","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":"Jamshed Mutahidi","batsman_id":"108061","runs":"80","balls":"21","how_out":"c H Khan b A Deshpande","score_at_dismissal":143,"overs_at_dismissal":"6.1","bowler_id":"108088","dismissal":"caught","number":2},"extra_runs":{"byes":0,"legbyes":0,"wides":4,"noballs":0,"penalty":"0","total":4},"equations":{"runs":168,"wickets":2,"overs":"7.1","bowlers_used":6,"runrate":"23.44"},"current_partnership":{"runs":25,"balls":6,"overs":1,"batsmen":[{"name":"Kashif Shahab","batsman_id":108069,"runs":8,"balls":3},{"name":"Ubaid Manzoor","batsman_id":130955,"runs":16,"balls":3}]},"did_not_bat":[{"player_id":"108070","name":"Benjamin Das"},{"player_id":"150536","name":"Koushik Chowdhury"},{"player_id":"150537","name":"Pranoy Tugnawat"},{"player_id":"150539","name":"Ahmadzia Ahmadzai"},{"player_id":"150541","name":"Vikesh Subramoniam"},{"player_id":"108071","name":"Abdulmajeed Ahmadzai"},{"player_id":"150543","name":"Popal Katakhil"}],"max_over":"10","target":"168","recent_scores":"1,6,6,4,1,6,1,w,1,0,6,4,1,0,6,0,w,6","last_five_overs":"112\/2 21.00","last_ten_overs":"168\/2 21.45"},"teams":[{"tid":119937,"title":"Dussledorf Blackcaps","abbr":"DB","alt_name":"Dussledorf Blackcaps","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2021\/05\/scrnli_5_14_2021_10-34-17-PM.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2021\/05\/scrnli_5_14_2021_10-34-17-PM.png","country":"de","sex":"male","team_owner":"","head_coach":"","scores_full":"168\/2 (7.1 ov)","scores":"168\/2","overs":"7.1"},{"tid":119942,"title":"Bonn Blue Star","abbr":"BBS","alt_name":"Bonn Blue Star","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2021\/05\/scrnli_5_14_2021_10-46-32-PM.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2021\/05\/scrnli_5_14_2021_10-46-32-PM.png","country":"de","sex":"male","team_owner":"","head_coach":"","scores_full":"167\/5 (10 ov)","scores":"167\/5","overs":"10"}],"players":[{"pid":62005,"title":"Asad Mohammad","short_name":"Asad Mohammad","first_name":"Asad Mohammad","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"bowl","role_str":"(C)"},{"pid":99147,"title":"Pramod Kumar","short_name":"P Kumar","first_name":"Pramod Kumar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"International","role":"squad","role_str":""},{"pid":103459,"title":"Ranjit Singh","short_name":"R Singh","first_name":"Ranjit Singh","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"squad","role_str":""},{"pid":108061,"title":"Jamshed Mutahidi","short_name":"J Mutahidi","first_name":"Jamshed Mutahidi","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"wk","role_str":""},{"pid":108069,"title":"Kashif Shahab","short_name":"K Shahab","first_name":"Kashif Shahab","last_name":"","middle_name":"","birthdate":"1985-08-25","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Germany","role":"all","role_str":""},{"pid":108070,"title":"Benjamin Das","short_name":"B Das","first_name":"Benjamin Das","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"wk","role_str":"(WK)"},{"pid":108071,"title":"Abdulmajeed Ahmadzai","short_name":"A Ahmadzai","first_name":"Abdulmajeed Ahmadzai","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"bowl","role_str":"(C)"},{"pid":108081,"title":"Amit Saini","short_name":"A Saini","first_name":"Amit Saini","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"squad","role_str":""},{"pid":108087,"title":"Ashish Makkar","short_name":"A Makkar","first_name":"Ashish Makkar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","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":"Germany","role":"all","role_str":""},{"pid":108088,"title":"Ameya Deshpande","short_name":"A Deshpande","first_name":"Ameya Deshpande","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","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":"Germany","role":"all","role_str":""},{"pid":108098,"title":"Dhruv Rathod","short_name":"D Rathod","first_name":"Dhruv Rathod","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"squad","role_str":""},{"pid":108106,"title":"Karanjit Brar","short_name":"K Brar","first_name":"Karanjit Brar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"squad","role_str":""},{"pid":108110,"title":"Vikram Jeet","short_name":"V Jeet","first_name":"Vikram Jeet","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"squad","role_str":""},{"pid":108116,"title":"Haron Khan","short_name":"H Khan","first_name":"Haron Khan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"all","role_str":""},{"pid":109412,"title":"Ghulam Rasul Ahmadi","short_name":"GR Ahmadi","first_name":"Ghulam Rasul Ahmadi","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"squad","role_str":""},{"pid":118821,"title":"Niamat Safi","short_name":"Niamat Safi","first_name":"Niamat Safi","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"bowl","role_str":""},{"pid":118824,"title":"Haroon Javed","short_name":"H Javed","first_name":"Haroon Javed","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"wk","role_str":""},{"pid":118826,"title":"Farmanullah Miakhel","short_name":"F Miakhel","first_name":"Farmanullah Miakhel","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"squad","role_str":""},{"pid":119061,"title":"Aman Kapoor","short_name":"Aman Kapoor","first_name":"Aman Kapoor","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"wk","role_str":"(WK)"},{"pid":130700,"title":"Zaheer Abbas-I","short_name":"Z Abbas-I","first_name":"Zaheer Abbas-I","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"bat","role_str":""},{"pid":130704,"title":"Bharath Thumula","short_name":"B Thumula","first_name":"Bharath Thumula","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","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":"Germany","role":"squad","role_str":""},{"pid":130705,"title":"Banny Brar","short_name":"B Brar","first_name":"Banny Brar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"bowl","role_str":""},{"pid":130955,"title":"Ubaid Manzoor","short_name":"U Manzoor","first_name":"Ubaid Manzoor","last_name":"","middle_name":"","birthdate":"","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":130958,"title":"Udit Mehta","short_name":"U Mehta","first_name":"Udit Mehta","last_name":"","middle_name":"","birthdate":"","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":130962,"title":"Raviteja Velamuri","short_name":"R Velamuri","first_name":"Raviteja Velamuri","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":150536,"title":"Koushik Chowdhury","short_name":"K Chowdhury","first_name":"Koushik Chowdhury","last_name":"","middle_name":"","birthdate":"1993-04-22","birthplace":"","country":"in","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"wk","role_str":""},{"pid":150537,"title":"Pranoy Tugnawat","short_name":"P Tugnawat","first_name":"Pranoy Tugnawat","last_name":"","middle_name":"","birthdate":"1988-12-21","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Germany","role":"bat","role_str":""},{"pid":150538,"title":"Zashid Malik","short_name":"Z Malik","first_name":"Zashid Malik","last_name":"","middle_name":"","birthdate":"1984-12-31","birthplace":"","country":"bd","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":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Bangladesh","role":"squad","role_str":""},{"pid":150539,"title":"Ahmadzia Ahmadzai","short_name":"A Ahmadzai","first_name":"Ahmadzia Ahmadzai","last_name":"","middle_name":"","birthdate":"2008-02-13","birthplace":"","country":"af","primary_team":[],"logo_url":"","playing_role":"all","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":"Afghanistan","role":"all","role_str":""},{"pid":150540,"title":"Punit Jindal","short_name":"P Jindal","first_name":"Punit Jindal","last_name":"","middle_name":"","birthdate":"1987-03-16","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":150541,"title":"Vikesh Subramoniam","short_name":"V Subramoniam","first_name":"Vikesh Subramoniam","last_name":"","middle_name":"","birthdate":"1997-10-06","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":""},{"pid":150542,"title":"Aakash Pandey","short_name":"A Pandey","first_name":"Aakash Pandey","last_name":"","middle_name":"","birthdate":"1999-08-27","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":150543,"title":"Popal Katakhil","short_name":"P Katakhil","first_name":"Popal Katakhil","last_name":"","middle_name":"","birthdate":"2005-08-12","birthplace":"","country":"af","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":"Afghanistan","role":"bowl","role_str":""},{"pid":150544,"title":"Ravish Talwar","short_name":"R Talwar","first_name":"Ravish Talwar","last_name":"","middle_name":"","birthdate":"1992-07-12","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":150572,"title":"Fahim Alikhil","short_name":"F Alikhil","first_name":"Fahim Alikhil","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"squad","role_str":""},{"pid":150573,"title":"Honeyjeet Brar","short_name":"H Brar","first_name":"Honeyjeet Brar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"bat","role_str":""},{"pid":150574,"title":"Adam Mangal","short_name":"A Mangal","first_name":"Adam Mangal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"squad","role_str":""},{"pid":150575,"title":"Mohit Somani","short_name":"M Somani","first_name":"Mohit Somani","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"squad","role_str":""},{"pid":150576,"title":"Kiran Kumaraswamy","short_name":"K Kumaraswamy","first_name":"Kiran Kumaraswamy","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","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":"Germany","role":"bowl","role_str":""},{"pid":150577,"title":"Jain Kumar","short_name":"J Kumar","first_name":"Jain Kumar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","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":"Germany","role":"squad","role_str":""}]},"etag":"393a9a8b77de310a60d723e8d27f1544","modified":"2025-07-30 02:03:23","datetime":"2025-07-30 02:03:23","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":91447,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Dussledorf Blackcaps won by 8 wickets","day_remaining_over":"","team_batting":"Dussledorf Blackcaps","team_bowling":"Bonn Blue Star","live_inning_number":2,"live_score":{"runs":168,"overs":7.1,"wickets":2,"target":168,"runrate":23.44,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Ubaid Manzoor","batsman_id":130955,"runs":26,"balls_faced":7,"fours":2,"sixes":3,"strike_rate":"371.43"},{"name":"Kashif Shahab","batsman_id":108069,"runs":8,"balls_faced":3,"fours":0,"sixes":1,"strike_rate":"266.67"}],"bowlers":[{"name":"Banny Brar","bowler_id":130705,"overs":0.1,"runs_conceded":1,"wickets":0,"maidens":0,"econ":"6.00"},{"name":"Ameya Deshpande","bowler_id":108088,"overs":1,"runs_conceded":25,"wickets":1,"maidens":0,"econ":"25.00"}],"commentaries":[{"event_id":"12355141","event":"ball","batsman_id":"108061","bowler_id":"118821","over":"3","ball":"1","score":6,"commentary":"Niamat Safi to Jamshed Mutahidi, Six,","noball_dismissal":false,"text":"","timestamp":1752754970,"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":"12355142","event":"ball","batsman_id":"108061","bowler_id":"118821","over":"3","ball":"2","score":6,"commentary":"Niamat Safi to Jamshed Mutahidi, Six,","noball_dismissal":false,"text":"","timestamp":1752755001,"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":"12355144","event":"ball","batsman_id":"108061","bowler_id":"118821","over":"3","ball":"3","score":4,"commentary":"Niamat Safi to Jamshed Mutahidi, Four,","noball_dismissal":false,"text":"","timestamp":1752755039,"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":"12355145","event":"ball","batsman_id":"108061","bowler_id":"118821","over":"3","ball":"4","score":6,"commentary":"Niamat Safi to Jamshed Mutahidi, Six,","noball_dismissal":false,"text":"","timestamp":1752755136,"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":"12355147","event":"ball","batsman_id":"108061","bowler_id":"118821","over":"3","ball":"5","score":6,"commentary":"Niamat Safi to Jamshed Mutahidi, Six,","noball_dismissal":false,"text":"","timestamp":1752755140,"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":"12355150","event":"ball","batsman_id":"108061","bowler_id":"118821","over":"3","ball":"6","score":4,"commentary":"Niamat Safi to Jamshed Mutahidi, Four,","noball_dismissal":false,"text":"","timestamp":1752755238,"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":4,"runs":32,"score":"101\/0","bats":[{"runs":73,"balls_faced":17,"fours":7,"sixes":7,"batsman_id":108061},{"runs":26,"balls_faced":7,"fours":2,"sixes":3,"batsman_id":130958}],"bowls":[{"runs_conceded":54,"maidens":0,"wickets":0,"bowler_id":118821,"overs":2},{"runs_conceded":19,"maidens":0,"wickets":0,"bowler_id":150576,"overs":1}],"commentary":"End of over 4 (32 runs), Dussledorf Blackcaps 101\/0"},{"event_id":"12355151","event":"ball","batsman_id":"130958","bowler_id":"62005","over":"4","ball":"1","score":6,"commentary":"Asad Mohammad to Udit Mehta, Six,","noball_dismissal":false,"text":"","timestamp":1752755271,"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":"12355152","event":"ball","batsman_id":"130958","bowler_id":"62005","over":"4","ball":"2","score":6,"commentary":"Asad Mohammad to Udit Mehta, Six,","noball_dismissal":false,"text":"","timestamp":1752755286,"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":"12355153","event":"ball","batsman_id":"130958","bowler_id":"62005","over":"4","ball":"3","score":6,"commentary":"Asad Mohammad to Udit Mehta, Six,","noball_dismissal":false,"text":"","timestamp":1752755317,"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":"12355154","event":"ball","batsman_id":"130958","bowler_id":"62005","over":"4","ball":"4","score":6,"commentary":"Asad Mohammad to Udit Mehta, Six,","noball_dismissal":false,"text":"","timestamp":1752755351,"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":"12355159","event":"wicket","batsman_id":"130958","bowler_id":"62005","over":"4","ball":"5","score":"w","commentary":"Asad Mohammad to Udit Mehta, no run, b Asad Mohammad,","noball_dismissal":false,"text":"","timestamp":1752755396,"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":"130958","how_out":"b Asad Mohammad","batsman_runs":"50","batsman_balls":"12"},{"event_id":"12355161","event":"ball","batsman_id":"130955","bowler_id":"62005","over":"4","ball":"6","score":0,"commentary":"Asad Mohammad to Ubaid Manzoor, no run,","noball_dismissal":false,"text":"","timestamp":1752755508,"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":5,"runs":24,"score":"125\/1","bats":[{"runs":0,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":130955},{"runs":73,"balls_faced":17,"fours":7,"sixes":7,"batsman_id":108061}],"bowls":[{"runs_conceded":24,"maidens":0,"wickets":1,"bowler_id":62005,"overs":1},{"runs_conceded":54,"maidens":0,"wickets":0,"bowler_id":118821,"overs":2}],"commentary":"End of over 5 (24 runs), Dussledorf Blackcaps 125\/1"},{"event_id":"12355166","event":"ball","batsman_id":"108061","bowler_id":"150576","over":"5","ball":"1","score":6,"commentary":"Kiran Kumaraswamy to Jamshed Mutahidi, Six,","noball_dismissal":false,"text":"","timestamp":1752755528,"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":"12355167","event":"ball","batsman_id":"108061","bowler_id":"150576","over":"5","ball":"2","score":0,"commentary":"Kiran Kumaraswamy to Jamshed Mutahidi, no run,","noball_dismissal":false,"text":"","timestamp":1752755567,"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":"12355170","event":"ball","batsman_id":"108061","bowler_id":"150576","over":"5","ball":"3","score":1,"commentary":"Kiran Kumaraswamy to Jamshed Mutahidi, 1 run,","noball_dismissal":false,"text":"","timestamp":1752755608,"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":"12355171","event":"ball","batsman_id":"130955","bowler_id":"150576","over":"5","ball":"4","score":4,"commentary":"Kiran Kumaraswamy to Ubaid Manzoor, Four,","noball_dismissal":false,"text":"","timestamp":1752755637,"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":"12355173","event":"ball","batsman_id":"130955","bowler_id":"150576","over":"5","ball":"5","score":6,"commentary":"Kiran Kumaraswamy to Ubaid Manzoor, Six,","noball_dismissal":false,"text":"","timestamp":1752755669,"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":"12355175","event":"ball","batsman_id":"130955","bowler_id":"150576","over":"5","ball":"6","score":0,"commentary":"Kiran Kumaraswamy to Ubaid Manzoor, no run,","noball_dismissal":false,"text":"","timestamp":1752755779,"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":6,"runs":17,"score":"142\/1","bats":[{"runs":10,"balls_faced":4,"fours":1,"sixes":1,"batsman_id":130955},{"runs":80,"balls_faced":20,"fours":7,"sixes":8,"batsman_id":108061}],"bowls":[{"runs_conceded":36,"maidens":0,"wickets":0,"bowler_id":150576,"overs":2},{"runs_conceded":24,"maidens":0,"wickets":1,"bowler_id":62005,"overs":1}],"commentary":"End of over 6 (17 runs), Dussledorf Blackcaps 142\/1"},{"event_id":"12355184","event":"ball","batsman_id":"108061","bowler_id":"108088","over":"6","ball":"1","score":"1wd","commentary":"Ameya Deshpande to Jamshed Mutahidi, 1 wide,","noball_dismissal":false,"text":"","timestamp":1752755809,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12355187","event":"wicket","batsman_id":"108061","bowler_id":"108088","over":"6","ball":"1","score":"w","commentary":"Ameya Deshpande to Jamshed Mutahidi, no run, c H Khan b A Deshpande,","noball_dismissal":false,"text":"","timestamp":1752755818,"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":"108061","how_out":"c H Khan b A Deshpande","batsman_runs":"80","batsman_balls":"21"},{"event_id":"12355190","event":"ball","batsman_id":"108069","bowler_id":"108088","over":"6","ball":"2","score":"1wd","commentary":"Ameya Deshpande to Kashif Shahab, 1 wide,","noball_dismissal":false,"text":"","timestamp":1752755976,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12355195","event":"ball","batsman_id":"108069","bowler_id":"108088","over":"6","ball":"2","score":6,"commentary":"Ameya Deshpande to Kashif Shahab, Six,","noball_dismissal":false,"text":"","timestamp":1752755987,"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":"12355196","event":"ball","batsman_id":"108069","bowler_id":"108088","over":"6","ball":"3","score":1,"commentary":"Ameya Deshpande to Kashif Shahab, 1 run,","noball_dismissal":false,"text":"","timestamp":1752756061,"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":"12355197","event":"ball","batsman_id":"130955","bowler_id":"108088","over":"6","ball":"4","score":4,"commentary":"Ameya Deshpande to Ubaid Manzoor, Four,","noball_dismissal":false,"text":"","timestamp":1752756072,"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":"12355202","event":"ball","batsman_id":"130955","bowler_id":"108088","over":"6","ball":"5","score":6,"commentary":"Ameya Deshpande to Ubaid Manzoor, Six,","noball_dismissal":false,"text":"","timestamp":1752756075,"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":"12355203","event":"ball","batsman_id":"130955","bowler_id":"108088","over":"6","ball":"6","score":6,"commentary":"Ameya Deshpande to Ubaid Manzoor, Six,","noball_dismissal":false,"text":"","timestamp":1752756078,"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":7,"runs":25,"score":"167\/2","bats":[{"runs":26,"balls_faced":7,"fours":2,"sixes":3,"batsman_id":130955},{"runs":7,"balls_faced":2,"fours":0,"sixes":1,"batsman_id":108069}],"bowls":[{"runs_conceded":25,"maidens":0,"wickets":1,"bowler_id":108088,"overs":1},{"runs_conceded":36,"maidens":0,"wickets":0,"bowler_id":150576,"overs":2}],"commentary":"End of over 7 (25 runs), Dussledorf Blackcaps 167\/2"},{"event_id":"12355204","event":"ball","batsman_id":"108069","bowler_id":"130705","over":"7","ball":"1","score":1,"commentary":"Banny Brar to Kashif Shahab, 1 run,","noball_dismissal":false,"text":"","timestamp":1752756096,"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}],"day":"0","session":"0","live_inning":{"iid":199720,"number":2,"name":"Dussledorf Blackcaps Inning","short_name":"DB Inning","status":2,"issuperover":"false","result":3,"batting_team_id":119937,"fielding_team_id":119942,"scores":"168\/2","scores_full":"168\/2 (7.1 ov)","fielder":[{"fielder_id":"108116","fielder_name":"Haron Khan","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":"Jamshed Mutahidi","batsman_id":"108061","runs":"80","balls":"21","how_out":"c H Khan b A Deshpande","score_at_dismissal":143,"overs_at_dismissal":"6.1","bowler_id":"108088","dismissal":"caught","number":2},"extra_runs":{"byes":0,"legbyes":0,"wides":4,"noballs":0,"penalty":"0","total":4},"equations":{"runs":168,"wickets":2,"overs":"7.1","bowlers_used":6,"runrate":"23.44"},"current_partnership":{"runs":25,"balls":6,"overs":1,"batsmen":[{"name":"Kashif Shahab","batsman_id":108069,"runs":8,"balls":3},{"name":"Ubaid Manzoor","batsman_id":130955,"runs":16,"balls":3}]},"did_not_bat":[{"player_id":"108070","name":"Benjamin Das"},{"player_id":"150536","name":"Koushik Chowdhury"},{"player_id":"150537","name":"Pranoy Tugnawat"},{"player_id":"150539","name":"Ahmadzia Ahmadzai"},{"player_id":"150541","name":"Vikesh Subramoniam"},{"player_id":"108071","name":"Abdulmajeed Ahmadzai"},{"player_id":"150543","name":"Popal Katakhil"}],"max_over":"10","target":"168","recent_scores":"1,6,6,4,1,6,1,w,1,0,6,4,1,0,6,0,w,6","last_five_overs":"112\/2 21.00","last_ten_overs":"168\/2 21.45"},"teams":[{"tid":119937,"title":"Dussledorf Blackcaps","abbr":"DB","alt_name":"Dussledorf Blackcaps","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2021\/05\/scrnli_5_14_2021_10-34-17-PM.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2021\/05\/scrnli_5_14_2021_10-34-17-PM.png","country":"de","sex":"male","team_owner":"","head_coach":"","scores_full":"168\/2 (7.1 ov)","scores":"168\/2","overs":"7.1"},{"tid":119942,"title":"Bonn Blue Star","abbr":"BBS","alt_name":"Bonn Blue Star","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2021\/05\/scrnli_5_14_2021_10-46-32-PM.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2021\/05\/scrnli_5_14_2021_10-46-32-PM.png","country":"de","sex":"male","team_owner":"","head_coach":"","scores_full":"167\/5 (10 ov)","scores":"167\/5","overs":"10"}],"players":[{"pid":62005,"title":"Asad Mohammad","short_name":"Asad Mohammad","first_name":"Asad Mohammad","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"bowl","role_str":"(C)"},{"pid":99147,"title":"Pramod Kumar","short_name":"P Kumar","first_name":"Pramod Kumar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"International","role":"squad","role_str":""},{"pid":103459,"title":"Ranjit Singh","short_name":"R Singh","first_name":"Ranjit Singh","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"squad","role_str":""},{"pid":108061,"title":"Jamshed Mutahidi","short_name":"J Mutahidi","first_name":"Jamshed Mutahidi","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"wk","role_str":""},{"pid":108069,"title":"Kashif Shahab","short_name":"K Shahab","first_name":"Kashif Shahab","last_name":"","middle_name":"","birthdate":"1985-08-25","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Germany","role":"all","role_str":""},{"pid":108070,"title":"Benjamin Das","short_name":"B Das","first_name":"Benjamin Das","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"wk","role_str":"(WK)"},{"pid":108071,"title":"Abdulmajeed Ahmadzai","short_name":"A Ahmadzai","first_name":"Abdulmajeed Ahmadzai","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"bowl","role_str":"(C)"},{"pid":108081,"title":"Amit Saini","short_name":"A Saini","first_name":"Amit Saini","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"squad","role_str":""},{"pid":108087,"title":"Ashish Makkar","short_name":"A Makkar","first_name":"Ashish Makkar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","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":"Germany","role":"all","role_str":""},{"pid":108088,"title":"Ameya Deshpande","short_name":"A Deshpande","first_name":"Ameya Deshpande","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","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":"Germany","role":"all","role_str":""},{"pid":108098,"title":"Dhruv Rathod","short_name":"D Rathod","first_name":"Dhruv Rathod","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"squad","role_str":""},{"pid":108106,"title":"Karanjit Brar","short_name":"K Brar","first_name":"Karanjit Brar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"squad","role_str":""},{"pid":108110,"title":"Vikram Jeet","short_name":"V Jeet","first_name":"Vikram Jeet","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"squad","role_str":""},{"pid":108116,"title":"Haron Khan","short_name":"H Khan","first_name":"Haron Khan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"all","role_str":""},{"pid":109412,"title":"Ghulam Rasul Ahmadi","short_name":"GR Ahmadi","first_name":"Ghulam Rasul Ahmadi","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"squad","role_str":""},{"pid":118821,"title":"Niamat Safi","short_name":"Niamat Safi","first_name":"Niamat Safi","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"bowl","role_str":""},{"pid":118824,"title":"Haroon Javed","short_name":"H Javed","first_name":"Haroon Javed","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"wk","role_str":""},{"pid":118826,"title":"Farmanullah Miakhel","short_name":"F Miakhel","first_name":"Farmanullah Miakhel","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"squad","role_str":""},{"pid":119061,"title":"Aman Kapoor","short_name":"Aman Kapoor","first_name":"Aman Kapoor","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"wk","role_str":"(WK)"},{"pid":130700,"title":"Zaheer Abbas-I","short_name":"Z Abbas-I","first_name":"Zaheer Abbas-I","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"bat","role_str":""},{"pid":130704,"title":"Bharath Thumula","short_name":"B Thumula","first_name":"Bharath Thumula","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","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":"Germany","role":"squad","role_str":""},{"pid":130705,"title":"Banny Brar","short_name":"B Brar","first_name":"Banny Brar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"bowl","role_str":""},{"pid":130955,"title":"Ubaid Manzoor","short_name":"U Manzoor","first_name":"Ubaid Manzoor","last_name":"","middle_name":"","birthdate":"","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":130958,"title":"Udit Mehta","short_name":"U Mehta","first_name":"Udit Mehta","last_name":"","middle_name":"","birthdate":"","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":130962,"title":"Raviteja Velamuri","short_name":"R Velamuri","first_name":"Raviteja Velamuri","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":150536,"title":"Koushik Chowdhury","short_name":"K Chowdhury","first_name":"Koushik Chowdhury","last_name":"","middle_name":"","birthdate":"1993-04-22","birthplace":"","country":"in","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"wk","role_str":""},{"pid":150537,"title":"Pranoy Tugnawat","short_name":"P Tugnawat","first_name":"Pranoy Tugnawat","last_name":"","middle_name":"","birthdate":"1988-12-21","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Germany","role":"bat","role_str":""},{"pid":150538,"title":"Zashid Malik","short_name":"Z Malik","first_name":"Zashid Malik","last_name":"","middle_name":"","birthdate":"1984-12-31","birthplace":"","country":"bd","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":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Bangladesh","role":"squad","role_str":""},{"pid":150539,"title":"Ahmadzia Ahmadzai","short_name":"A Ahmadzai","first_name":"Ahmadzia Ahmadzai","last_name":"","middle_name":"","birthdate":"2008-02-13","birthplace":"","country":"af","primary_team":[],"logo_url":"","playing_role":"all","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":"Afghanistan","role":"all","role_str":""},{"pid":150540,"title":"Punit Jindal","short_name":"P Jindal","first_name":"Punit Jindal","last_name":"","middle_name":"","birthdate":"1987-03-16","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":150541,"title":"Vikesh Subramoniam","short_name":"V Subramoniam","first_name":"Vikesh Subramoniam","last_name":"","middle_name":"","birthdate":"1997-10-06","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":""},{"pid":150542,"title":"Aakash Pandey","short_name":"A Pandey","first_name":"Aakash Pandey","last_name":"","middle_name":"","birthdate":"1999-08-27","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":150543,"title":"Popal Katakhil","short_name":"P Katakhil","first_name":"Popal Katakhil","last_name":"","middle_name":"","birthdate":"2005-08-12","birthplace":"","country":"af","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":"Afghanistan","role":"bowl","role_str":""},{"pid":150544,"title":"Ravish Talwar","short_name":"R Talwar","first_name":"Ravish Talwar","last_name":"","middle_name":"","birthdate":"1992-07-12","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":150572,"title":"Fahim Alikhil","short_name":"F Alikhil","first_name":"Fahim Alikhil","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"squad","role_str":""},{"pid":150573,"title":"Honeyjeet Brar","short_name":"H Brar","first_name":"Honeyjeet Brar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"bat","role_str":""},{"pid":150574,"title":"Adam Mangal","short_name":"A Mangal","first_name":"Adam Mangal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"squad","role_str":""},{"pid":150575,"title":"Mohit Somani","short_name":"M Somani","first_name":"Mohit Somani","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"squad","role_str":""},{"pid":150576,"title":"Kiran Kumaraswamy","short_name":"K Kumaraswamy","first_name":"Kiran Kumaraswamy","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","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":"Germany","role":"bowl","role_str":""},{"pid":150577,"title":"Jain Kumar","short_name":"J Kumar","first_name":"Jain Kumar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","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":"Germany","role":"squad","role_str":""}]},"etag":"393a9a8b77de310a60d723e8d27f1544","modified":"2025-07-30 02:03:23","datetime":"2025-07-30 02:03:23","api_version":"3.0"}', Modified = GetDate() WHERE Id = 91447 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:79fe99ed-f508-463e-85be-cb34a6e9c8d9
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 91447 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (91447,3,'{"status":"ok","response":{"match_id":91447,"title":"Bonn Blue Star vs Dussledorf Blackcaps","short_title":"BBS vs DB","subtitle":"Match 18","match_number":"18","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Dussledorf Blackcaps won by 8 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129678,"title":"ECS Krefeld, Germany","abbr":"ECS Germany","type":"tournament","category":"domestic","match_format":"t10","season":"2025","status":"live","datestart":"2025-07-14","dateend":"2025-07-18","country":"de","total_matches":"24","total_rounds":"2","total_teams":"12"},"teama":{"team_id":119942,"name":"Bonn Blue Star","short_name":"BBS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2021\/05\/scrnli_5_14_2021_10-46-32-PM.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2021\/05\/scrnli_5_14_2021_10-46-32-PM.png","scores_full":"167\/5 (10 ov)","scores":"167\/5","overs":"10"},"teamb":{"team_id":119937,"name":"Dussledorf Blackcaps","short_name":"DB","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2021\/05\/scrnli_5_14_2021_10-34-17-PM.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2021\/05\/scrnli_5_14_2021_10-34-17-PM.png","scores_full":"168\/2 (7.1 ov)","scores":"168\/2","overs":"7.1"},"date_start":"2025-07-17 11:15:00","date_end":"2025-07-17 21:15:00","timestamp_start":1752750900,"timestamp_end":1752786900,"date_start_ist":"2025-07-17 16:45:00","date_end_ist":"2025-07-18 02:45:00","venue":{"venue_id":"1213721","name":"Sportclub Krefeld 1905 e.V. Cricket Ground","location":"Krefeld","country":"Germany","timezone":""},"umpires":"Guruchander Arulmozhivarman (Germany), Avinash Hariharan (India),Ayush Sharma (India,TV)","referee":"Tyrone Peters (South Africa)","equation":"","live":"","result":"DB won by 8 wickets","result_type":2,"win_margin":"8 wickets","winning_team_id":119937,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-16 20:01:35","verify_time":"2025-07-17 18:24:45","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"broken clouds","temp":23.76,"humidity":50,"visibility":10000,"wind_speed":"7.87","clouds":70},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Dussledorf Blackcaps elected to bowl","winner":119937,"decision":2}},"etag":"e9a1ed154a593990a9dd77f66a9eb1a0","modified":"2025-07-30 02:03:24","datetime":"2025-07-30 02:03:24","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":91447,"title":"Bonn Blue Star vs Dussledorf Blackcaps","short_title":"BBS vs DB","subtitle":"Match 18","match_number":"18","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Dussledorf Blackcaps won by 8 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129678,"title":"ECS Krefeld, Germany","abbr":"ECS Germany","type":"tournament","category":"domestic","match_format":"t10","season":"2025","status":"live","datestart":"2025-07-14","dateend":"2025-07-18","country":"de","total_matches":"24","total_rounds":"2","total_teams":"12"},"teama":{"team_id":119942,"name":"Bonn Blue Star","short_name":"BBS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2021\/05\/scrnli_5_14_2021_10-46-32-PM.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2021\/05\/scrnli_5_14_2021_10-46-32-PM.png","scores_full":"167\/5 (10 ov)","scores":"167\/5","overs":"10"},"teamb":{"team_id":119937,"name":"Dussledorf Blackcaps","short_name":"DB","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2021\/05\/scrnli_5_14_2021_10-34-17-PM.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2021\/05\/scrnli_5_14_2021_10-34-17-PM.png","scores_full":"168\/2 (7.1 ov)","scores":"168\/2","overs":"7.1"},"date_start":"2025-07-17 11:15:00","date_end":"2025-07-17 21:15:00","timestamp_start":1752750900,"timestamp_end":1752786900,"date_start_ist":"2025-07-17 16:45:00","date_end_ist":"2025-07-18 02:45:00","venue":{"venue_id":"1213721","name":"Sportclub Krefeld 1905 e.V. Cricket Ground","location":"Krefeld","country":"Germany","timezone":""},"umpires":"Guruchander Arulmozhivarman (Germany), Avinash Hariharan (India),Ayush Sharma (India,TV)","referee":"Tyrone Peters (South Africa)","equation":"","live":"","result":"DB won by 8 wickets","result_type":2,"win_margin":"8 wickets","winning_team_id":119937,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-16 20:01:35","verify_time":"2025-07-17 18:24:45","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"broken clouds","temp":23.76,"humidity":50,"visibility":10000,"wind_speed":"7.87","clouds":70},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Dussledorf Blackcaps elected to bowl","winner":119937,"decision":2}},"etag":"e9a1ed154a593990a9dd77f66a9eb1a0","modified":"2025-07-30 02:03:24","datetime":"2025-07-30 02:03:24","api_version":"3.0"}', Modified = GetDate() WHERE Id = 91447 AND DataTypeId = 3 END Live Report & Scorecard of Bonn Blue Star vs Dussledorf Blackcaps Match 18
Bonn Blue Star vs Dussledorf Blackcaps, Live Cricket Commentary