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:2c80c5ac-b203-4fc7-8ad3-edabd204f178
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 91609 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (91609,1,'{"status":"ok","response":{"mid":91609,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"VFB Gelsenkirchen won by 35 runs","day_remaining_over":"","team_batting":"Dussledorf Blackcaps","team_bowling":"VFB Gelsenkirchen","live_inning_number":2,"live_score":{"runs":134,"overs":10,"wickets":5,"target":170,"runrate":13.4,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Benjamin Das","batsman_id":108070,"runs":5,"balls_faced":2,"fours":1,"sixes":0,"strike_rate":"250.00"},{"name":"Kashif Shahab","batsman_id":108069,"runs":83,"balls_faced":31,"fours":7,"sixes":8,"strike_rate":"267.74"}],"bowlers":[{"name":"Raj Bhushan","bowler_id":108054,"overs":2,"runs_conceded":33,"wickets":2,"maidens":0,"econ":"16.50"},{"name":"Shrutarv Awasthi","bowler_id":107918,"overs":2,"runs_conceded":26,"wickets":1,"maidens":0,"econ":"13.00"}],"commentaries":[{"event_id":"12360905","event":"ball","batsman_id":"108071","bowler_id":"118853","over":"5","ball":"5","score":1,"commentary":"Zakirullah Asmari to Abdulmajeed Ahmadzai, 1 run,","noball_dismissal":false,"text":"","timestamp":1752855575,"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":"12360908","event":"ball","batsman_id":"108069","bowler_id":"118853","over":"5","ball":"6","score":4,"commentary":"Zakirullah Asmari to Kashif Shahab, Four,","noball_dismissal":false,"text":"","timestamp":1752855580,"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":6,"runs":9,"score":"78\/3","bats":[{"runs":55,"balls_faced":19,"fours":5,"sixes":5,"batsman_id":108069},{"runs":6,"balls_faced":6,"fours":0,"sixes":0,"batsman_id":108071}],"bowls":[{"runs_conceded":21,"maidens":0,"wickets":1,"bowler_id":118853,"overs":2},{"runs_conceded":22,"maidens":0,"wickets":0,"bowler_id":108054,"overs":1}],"commentary":"End of over 6 (9 runs), Dussledorf Blackcaps 78\/3"},{"event_id":"12360918","event":"ball","batsman_id":"108071","bowler_id":"108074","over":"6","ball":"1","score":1,"commentary":"Muhammad Raheel to Abdulmajeed Ahmadzai, 1 run,","noball_dismissal":false,"text":"","timestamp":1752855750,"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":"12360929","event":"ball","batsman_id":"108069","bowler_id":"108074","over":"6","ball":"2","score":"1b","commentary":"Muhammad Raheel to Kashif Shahab, 1 bye,","noball_dismissal":false,"text":"","timestamp":1752855759,"run":1,"noball_run":"0","wide_run":"0","bye_run":"1","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12360930","event":"ball","batsman_id":"108071","bowler_id":"108074","over":"6","ball":"3","score":6,"commentary":"Muhammad Raheel to Abdulmajeed Ahmadzai, Six,","noball_dismissal":false,"text":"","timestamp":1752855792,"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":"12360932","event":"ball","batsman_id":"108071","bowler_id":"108074","over":"6","ball":"4","score":0,"commentary":"Muhammad Raheel to Abdulmajeed Ahmadzai, no run,","noball_dismissal":false,"text":"","timestamp":1752855808,"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":"12360934","event":"ball","batsman_id":"108071","bowler_id":"108074","over":"6","ball":"5","score":4,"commentary":"Muhammad Raheel to Abdulmajeed Ahmadzai, Four,","noball_dismissal":false,"text":"","timestamp":1752855820,"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":"12360941","event":"ball","batsman_id":"108071","bowler_id":"108074","over":"6","ball":"6","score":"4b","commentary":"Muhammad Raheel to Abdulmajeed Ahmadzai, 4 bye,","noball_dismissal":false,"text":"","timestamp":1752855946,"run":4,"noball_run":"0","wide_run":"0","bye_run":"4","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":7,"runs":16,"score":"94\/3","bats":[{"runs":17,"balls_faced":11,"fours":1,"sixes":1,"batsman_id":108071},{"runs":55,"balls_faced":20,"fours":5,"sixes":5,"batsman_id":108069}],"bowls":[{"runs_conceded":17,"maidens":0,"wickets":1,"bowler_id":108074,"overs":2},{"runs_conceded":21,"maidens":0,"wickets":1,"bowler_id":118853,"overs":2}],"commentary":"End of over 7 (16 runs), Dussledorf Blackcaps 94\/3"},{"event_id":"12360950","event":"ball","batsman_id":"108069","bowler_id":"99522","over":"7","ball":"1","score":6,"commentary":"Muhammad Asif-I to Kashif Shahab, Six,","noball_dismissal":false,"text":"","timestamp":1752855956,"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":"12360951","event":"ball","batsman_id":"108069","bowler_id":"99522","over":"7","ball":"2","score":0,"commentary":"Muhammad Asif-I to Kashif Shahab, no run,","noball_dismissal":false,"text":"","timestamp":1752855960,"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":"12360952","event":"ball","batsman_id":"108069","bowler_id":"99522","over":"7","ball":"3","score":4,"commentary":"Muhammad Asif-I to Kashif Shahab, Four,","noball_dismissal":false,"text":"","timestamp":1752856000,"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":"12360962","event":"ball","batsman_id":"108069","bowler_id":"99522","over":"7","ball":"4","score":4,"commentary":"Muhammad Asif-I to Kashif Shahab, Four,","noball_dismissal":false,"text":"","timestamp":1752856040,"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":"12360963","event":"ball","batsman_id":"108069","bowler_id":"99522","over":"7","ball":"5","score":0,"commentary":"Muhammad Asif-I to Kashif Shahab, no run,","noball_dismissal":false,"text":"","timestamp":1752856065,"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":"12360965","event":"ball","batsman_id":"108069","bowler_id":"99522","over":"7","ball":"6","score":1,"commentary":"Muhammad Asif-I to Kashif Shahab, 1 run,","noball_dismissal":false,"text":"","timestamp":1752856085,"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":15,"score":"109\/3","bats":[{"runs":70,"balls_faced":26,"fours":7,"sixes":6,"batsman_id":108069},{"runs":17,"balls_faced":11,"fours":1,"sixes":1,"batsman_id":108071}],"bowls":[{"runs_conceded":31,"maidens":0,"wickets":0,"bowler_id":99522,"overs":2},{"runs_conceded":17,"maidens":0,"wickets":1,"bowler_id":108074,"overs":2}],"commentary":"End of over 8 (15 runs), Dussledorf Blackcaps 109\/3"},{"event_id":"12360974","event":"ball","batsman_id":"108069","bowler_id":"107918","over":"8","ball":"1","score":6,"commentary":"Shrutarv Awasthi to Kashif Shahab, Six,","noball_dismissal":false,"text":"","timestamp":1752856153,"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":"12360976","event":"ball","batsman_id":"108069","bowler_id":"107918","over":"8","ball":"2","score":0,"commentary":"Shrutarv Awasthi to Kashif Shahab, no run,","noball_dismissal":false,"text":"","timestamp":1752856171,"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":"12360980","event":"ball","batsman_id":"108069","bowler_id":"107918","over":"8","ball":"3","score":1,"commentary":"Shrutarv Awasthi to Kashif Shahab, 1 run,","noball_dismissal":false,"text":"","timestamp":1752856197,"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":"12360985","event":"ball","batsman_id":"108071","bowler_id":"107918","over":"8","ball":"4","score":0,"commentary":"Shrutarv Awasthi to Abdulmajeed Ahmadzai, no run,","noball_dismissal":false,"text":"","timestamp":1752856247,"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":"12360991","event":"ball","batsman_id":"108071","bowler_id":"107918","over":"8","ball":"5","score":1,"commentary":"Shrutarv Awasthi to Abdulmajeed Ahmadzai, 1 run,","noball_dismissal":false,"text":"","timestamp":1752856308,"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":"12360995","event":"ball","batsman_id":"108069","bowler_id":"107918","over":"8","ball":"6","score":6,"commentary":"Shrutarv Awasthi to Kashif Shahab, Six,","noball_dismissal":false,"text":"","timestamp":1752856332,"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":14,"score":"123\/3","bats":[{"runs":83,"balls_faced":30,"fours":7,"sixes":8,"batsman_id":108069},{"runs":18,"balls_faced":13,"fours":1,"sixes":1,"batsman_id":108071}],"bowls":[{"runs_conceded":26,"maidens":0,"wickets":1,"bowler_id":107918,"overs":2},{"runs_conceded":31,"maidens":0,"wickets":0,"bowler_id":99522,"overs":2}],"commentary":"End of over 9 (14 runs), Dussledorf Blackcaps 123\/3"},{"event_id":"12361011","event":"wicket","batsman_id":"108071","bowler_id":"108054","over":"9","ball":"1","score":"w","commentary":"Raj Bhushan to Abdulmajeed Ahmadzai, no run, c Z Asmari b R Bhushan,","noball_dismissal":false,"text":"","timestamp":1752856478,"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":"108071","how_out":"c Z Asmari b R Bhushan","batsman_runs":"18","batsman_balls":"14"},{"event_id":"12361018","event":"ball","batsman_id":"150539","bowler_id":"108054","over":"9","ball":"2","score":6,"commentary":"Raj Bhushan to Ahmadzia Ahmadzai, Six,","noball_dismissal":false,"text":"","timestamp":1752856573,"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":"12361020","event":"wicket","batsman_id":"150539","bowler_id":"108054","over":"9","ball":"3","score":"w","commentary":"Raj Bhushan to Ahmadzia Ahmadzai, no run, st Amal Mudappattu b R Bhushan,","noball_dismissal":false,"text":"","timestamp":1752856570,"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":"150539","how_out":"st Amal Mudappattu b R Bhushan","batsman_runs":"6","batsman_balls":"2"},{"event_id":"12361025","event":"ball","batsman_id":"108070","bowler_id":"108054","over":"9","ball":"4","score":4,"commentary":"Raj Bhushan to Benjamin Das, Four,","noball_dismissal":false,"text":"","timestamp":1752856598,"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":"12361026","event":"ball","batsman_id":"108070","bowler_id":"108054","over":"9","ball":"5","score":1,"commentary":"Raj Bhushan to Benjamin Das, 1 run,","noball_dismissal":false,"text":"","timestamp":1752856603,"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":"12361031","event":"ball","batsman_id":"108069","bowler_id":"108054","over":"9","ball":"6","score":0,"commentary":"Raj Bhushan to Kashif Shahab, no run,","noball_dismissal":false,"text":"","timestamp":1752856629,"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":10,"runs":11,"score":"134\/5","bats":[{"runs":83,"balls_faced":31,"fours":7,"sixes":8,"batsman_id":108069},{"runs":5,"balls_faced":2,"fours":1,"sixes":0,"batsman_id":108070}],"bowls":[{"runs_conceded":33,"maidens":0,"wickets":2,"bowler_id":108054,"overs":2},{"runs_conceded":26,"maidens":0,"wickets":1,"bowler_id":107918,"overs":2}],"commentary":"End of over 10 (11 runs), Dussledorf Blackcaps 134\/5"}],"day":"0","session":"0","live_inning":{"iid":199783,"number":2,"name":"Dussledorf Blackcaps Inning","short_name":"DB Inning","status":2,"issuperover":"false","result":4,"batting_team_id":119937,"fielding_team_id":119922,"scores":"134\/5","scores_full":"134\/5 (10 ov)","fielder":[{"fielder_id":"118805","fielder_name":"Amal Mudappattu","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":1,"is_substitute":"false"},{"fielder_id":"118853","fielder_name":"Zakirullah Asmari","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"130899","fielder_name":"Ace Pruss ","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":[],"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Ahmadzia Ahmadzai","batsman_id":"150539","runs":"6","balls":"2","how_out":"st Amal Mudappattu b R Bhushan","score_at_dismissal":129,"overs_at_dismissal":"9.3","bowler_id":"108054","dismissal":"stumped","number":5},"extra_runs":{"byes":5,"legbyes":1,"wides":0,"noballs":0,"penalty":"0","total":6},"equations":{"runs":134,"wickets":5,"overs":"10","bowlers_used":5,"runrate":"13.40"},"current_partnership":{"runs":5,"balls":3,"overs":0.3,"batsmen":[{"name":"Benjamin Das","batsman_id":108070,"runs":5,"balls":2},{"name":"Kashif Shahab","batsman_id":108069,"runs":0,"balls":1}]},"did_not_bat":[{"player_id":"150541","name":"Vikesh Subramoniam"},{"player_id":"150536","name":"Koushik Chowdhury"},{"player_id":"150543","name":"Popal Katakhil"},{"player_id":"130962","name":"Raviteja Velamuri"}],"max_over":"10","target":"170","recent_scores":"0,1,4,w,6,w,6,1,0,1,0,6,1,0,4,4,0,6","last_five_overs":"65\/2 13.00","last_ten_overs":"134\/5 13.40"},"teams":[{"tid":119922,"title":"VFB Gelsenkirchen","abbr":"VG","alt_name":"VG","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2021\/05\/scrnli_5_14_2021_9-57-36-PM.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2021\/05\/scrnli_5_14_2021_9-57-36-PM.png","country":"de","sex":"male","team_owner":"","head_coach":"","scores_full":"169\/3 (10 ov)","scores":"169\/3","overs":"10"},{"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":"134\/5 (10 ov)","scores":"134\/5","overs":"10"}],"players":[{"pid":99522,"title":"Muhammad Asif-I","short_name":"M Asif","first_name":"Muhammad Asif-I","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":101529,"title":"Gopinath Manoharan","short_name":"G Manoharan","first_name":"Gopinath Manoharan","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":107905,"title":"Mirwali Jabarkheel","short_name":"M Jabarkheel","first_name":"Mirwali Jabarkheel","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":""},{"pid":107916,"title":"Rubesh Palaniappan","short_name":"R Palaniappan","first_name":"Rubesh Palaniappan","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":""},{"pid":107918,"title":"Shrutarv Awasthi","short_name":"S Awasthi","first_name":"Shrutarv Awasthi","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":108046,"title":"Waqas Fatmi","short_name":"W Fatmi","first_name":"Waqas Fatmi","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":108054,"title":"Raj Bhushan","short_name":"R Bhushan","first_name":"Raj Bhushan","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":""},{"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":7,"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":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"all","role_str":"(C)"},{"pid":108074,"title":"Muhammad Raheel","short_name":"M Raheel","first_name":"Muhammad Raheel","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"all","role_str":""},{"pid":113286,"title":"Shazaib Khan","short_name":"S Khan","first_name":"Shazaib Khan","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":118805,"title":"Amal Mudappattu","short_name":"Amal Mudappattu","first_name":"Amal Mudappattu","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"wk","role_str":"(WK\/C)"},{"pid":118853,"title":"Zakirullah Asmari","short_name":"Z Asmari","first_name":"Zakirullah Asmari","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":118911,"title":"Punith Murugesh ","short_name":"P Murugesh","first_name":"Punith Murugesh ","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"squad","role_str":""},{"pid":118914,"title":"Ronit Satapathy","short_name":"R Satapathy","first_name":"Ronit Satapathy","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":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"squad","role_str":""},{"pid":118923,"title":"Krishnan Sahasranaman","short_name":"Krishnan Sahasranaman","first_name":"Krishnan Sahasranaman","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":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"squad","role_str":""},{"pid":118925,"title":"Muhammad Oweis","short_name":"Muhammad Oweis","first_name":"Muhammad Oweis","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":"squad","role_str":""},{"pid":130896,"title":"Jay Tamakuwala","short_name":"J Tamakuwala","first_name":"Jay Tamakuwala","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"squad","role_str":""},{"pid":130899,"title":"Ace Pruss ","short_name":"A Pruss ","first_name":"Ace Pruss ","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":""},{"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":8,"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":"bowl","role_str":""},{"pid":150473,"title":"Rahul Mathavan","short_name":"R Mathavan","first_name":"Rahul Mathavan","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":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"squad","role_str":""},{"pid":150474,"title":"Manush Mani","short_name":"M Mani","first_name":"Manush Mani","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","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,"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":"squad","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":"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":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":7,"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":6,"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":7,"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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""}]},"etag":"2e4ec86cc395d044a189c001d1845411","modified":"2025-07-25 22:32:09","datetime":"2025-07-25 22:32:09","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":91609,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"VFB Gelsenkirchen won by 35 runs","day_remaining_over":"","team_batting":"Dussledorf Blackcaps","team_bowling":"VFB Gelsenkirchen","live_inning_number":2,"live_score":{"runs":134,"overs":10,"wickets":5,"target":170,"runrate":13.4,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Benjamin Das","batsman_id":108070,"runs":5,"balls_faced":2,"fours":1,"sixes":0,"strike_rate":"250.00"},{"name":"Kashif Shahab","batsman_id":108069,"runs":83,"balls_faced":31,"fours":7,"sixes":8,"strike_rate":"267.74"}],"bowlers":[{"name":"Raj Bhushan","bowler_id":108054,"overs":2,"runs_conceded":33,"wickets":2,"maidens":0,"econ":"16.50"},{"name":"Shrutarv Awasthi","bowler_id":107918,"overs":2,"runs_conceded":26,"wickets":1,"maidens":0,"econ":"13.00"}],"commentaries":[{"event_id":"12360905","event":"ball","batsman_id":"108071","bowler_id":"118853","over":"5","ball":"5","score":1,"commentary":"Zakirullah Asmari to Abdulmajeed Ahmadzai, 1 run,","noball_dismissal":false,"text":"","timestamp":1752855575,"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":"12360908","event":"ball","batsman_id":"108069","bowler_id":"118853","over":"5","ball":"6","score":4,"commentary":"Zakirullah Asmari to Kashif Shahab, Four,","noball_dismissal":false,"text":"","timestamp":1752855580,"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":6,"runs":9,"score":"78\/3","bats":[{"runs":55,"balls_faced":19,"fours":5,"sixes":5,"batsman_id":108069},{"runs":6,"balls_faced":6,"fours":0,"sixes":0,"batsman_id":108071}],"bowls":[{"runs_conceded":21,"maidens":0,"wickets":1,"bowler_id":118853,"overs":2},{"runs_conceded":22,"maidens":0,"wickets":0,"bowler_id":108054,"overs":1}],"commentary":"End of over 6 (9 runs), Dussledorf Blackcaps 78\/3"},{"event_id":"12360918","event":"ball","batsman_id":"108071","bowler_id":"108074","over":"6","ball":"1","score":1,"commentary":"Muhammad Raheel to Abdulmajeed Ahmadzai, 1 run,","noball_dismissal":false,"text":"","timestamp":1752855750,"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":"12360929","event":"ball","batsman_id":"108069","bowler_id":"108074","over":"6","ball":"2","score":"1b","commentary":"Muhammad Raheel to Kashif Shahab, 1 bye,","noball_dismissal":false,"text":"","timestamp":1752855759,"run":1,"noball_run":"0","wide_run":"0","bye_run":"1","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12360930","event":"ball","batsman_id":"108071","bowler_id":"108074","over":"6","ball":"3","score":6,"commentary":"Muhammad Raheel to Abdulmajeed Ahmadzai, Six,","noball_dismissal":false,"text":"","timestamp":1752855792,"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":"12360932","event":"ball","batsman_id":"108071","bowler_id":"108074","over":"6","ball":"4","score":0,"commentary":"Muhammad Raheel to Abdulmajeed Ahmadzai, no run,","noball_dismissal":false,"text":"","timestamp":1752855808,"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":"12360934","event":"ball","batsman_id":"108071","bowler_id":"108074","over":"6","ball":"5","score":4,"commentary":"Muhammad Raheel to Abdulmajeed Ahmadzai, Four,","noball_dismissal":false,"text":"","timestamp":1752855820,"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":"12360941","event":"ball","batsman_id":"108071","bowler_id":"108074","over":"6","ball":"6","score":"4b","commentary":"Muhammad Raheel to Abdulmajeed Ahmadzai, 4 bye,","noball_dismissal":false,"text":"","timestamp":1752855946,"run":4,"noball_run":"0","wide_run":"0","bye_run":"4","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":7,"runs":16,"score":"94\/3","bats":[{"runs":17,"balls_faced":11,"fours":1,"sixes":1,"batsman_id":108071},{"runs":55,"balls_faced":20,"fours":5,"sixes":5,"batsman_id":108069}],"bowls":[{"runs_conceded":17,"maidens":0,"wickets":1,"bowler_id":108074,"overs":2},{"runs_conceded":21,"maidens":0,"wickets":1,"bowler_id":118853,"overs":2}],"commentary":"End of over 7 (16 runs), Dussledorf Blackcaps 94\/3"},{"event_id":"12360950","event":"ball","batsman_id":"108069","bowler_id":"99522","over":"7","ball":"1","score":6,"commentary":"Muhammad Asif-I to Kashif Shahab, Six,","noball_dismissal":false,"text":"","timestamp":1752855956,"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":"12360951","event":"ball","batsman_id":"108069","bowler_id":"99522","over":"7","ball":"2","score":0,"commentary":"Muhammad Asif-I to Kashif Shahab, no run,","noball_dismissal":false,"text":"","timestamp":1752855960,"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":"12360952","event":"ball","batsman_id":"108069","bowler_id":"99522","over":"7","ball":"3","score":4,"commentary":"Muhammad Asif-I to Kashif Shahab, Four,","noball_dismissal":false,"text":"","timestamp":1752856000,"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":"12360962","event":"ball","batsman_id":"108069","bowler_id":"99522","over":"7","ball":"4","score":4,"commentary":"Muhammad Asif-I to Kashif Shahab, Four,","noball_dismissal":false,"text":"","timestamp":1752856040,"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":"12360963","event":"ball","batsman_id":"108069","bowler_id":"99522","over":"7","ball":"5","score":0,"commentary":"Muhammad Asif-I to Kashif Shahab, no run,","noball_dismissal":false,"text":"","timestamp":1752856065,"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":"12360965","event":"ball","batsman_id":"108069","bowler_id":"99522","over":"7","ball":"6","score":1,"commentary":"Muhammad Asif-I to Kashif Shahab, 1 run,","noball_dismissal":false,"text":"","timestamp":1752856085,"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":15,"score":"109\/3","bats":[{"runs":70,"balls_faced":26,"fours":7,"sixes":6,"batsman_id":108069},{"runs":17,"balls_faced":11,"fours":1,"sixes":1,"batsman_id":108071}],"bowls":[{"runs_conceded":31,"maidens":0,"wickets":0,"bowler_id":99522,"overs":2},{"runs_conceded":17,"maidens":0,"wickets":1,"bowler_id":108074,"overs":2}],"commentary":"End of over 8 (15 runs), Dussledorf Blackcaps 109\/3"},{"event_id":"12360974","event":"ball","batsman_id":"108069","bowler_id":"107918","over":"8","ball":"1","score":6,"commentary":"Shrutarv Awasthi to Kashif Shahab, Six,","noball_dismissal":false,"text":"","timestamp":1752856153,"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":"12360976","event":"ball","batsman_id":"108069","bowler_id":"107918","over":"8","ball":"2","score":0,"commentary":"Shrutarv Awasthi to Kashif Shahab, no run,","noball_dismissal":false,"text":"","timestamp":1752856171,"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":"12360980","event":"ball","batsman_id":"108069","bowler_id":"107918","over":"8","ball":"3","score":1,"commentary":"Shrutarv Awasthi to Kashif Shahab, 1 run,","noball_dismissal":false,"text":"","timestamp":1752856197,"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":"12360985","event":"ball","batsman_id":"108071","bowler_id":"107918","over":"8","ball":"4","score":0,"commentary":"Shrutarv Awasthi to Abdulmajeed Ahmadzai, no run,","noball_dismissal":false,"text":"","timestamp":1752856247,"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":"12360991","event":"ball","batsman_id":"108071","bowler_id":"107918","over":"8","ball":"5","score":1,"commentary":"Shrutarv Awasthi to Abdulmajeed Ahmadzai, 1 run,","noball_dismissal":false,"text":"","timestamp":1752856308,"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":"12360995","event":"ball","batsman_id":"108069","bowler_id":"107918","over":"8","ball":"6","score":6,"commentary":"Shrutarv Awasthi to Kashif Shahab, Six,","noball_dismissal":false,"text":"","timestamp":1752856332,"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":14,"score":"123\/3","bats":[{"runs":83,"balls_faced":30,"fours":7,"sixes":8,"batsman_id":108069},{"runs":18,"balls_faced":13,"fours":1,"sixes":1,"batsman_id":108071}],"bowls":[{"runs_conceded":26,"maidens":0,"wickets":1,"bowler_id":107918,"overs":2},{"runs_conceded":31,"maidens":0,"wickets":0,"bowler_id":99522,"overs":2}],"commentary":"End of over 9 (14 runs), Dussledorf Blackcaps 123\/3"},{"event_id":"12361011","event":"wicket","batsman_id":"108071","bowler_id":"108054","over":"9","ball":"1","score":"w","commentary":"Raj Bhushan to Abdulmajeed Ahmadzai, no run, c Z Asmari b R Bhushan,","noball_dismissal":false,"text":"","timestamp":1752856478,"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":"108071","how_out":"c Z Asmari b R Bhushan","batsman_runs":"18","batsman_balls":"14"},{"event_id":"12361018","event":"ball","batsman_id":"150539","bowler_id":"108054","over":"9","ball":"2","score":6,"commentary":"Raj Bhushan to Ahmadzia Ahmadzai, Six,","noball_dismissal":false,"text":"","timestamp":1752856573,"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":"12361020","event":"wicket","batsman_id":"150539","bowler_id":"108054","over":"9","ball":"3","score":"w","commentary":"Raj Bhushan to Ahmadzia Ahmadzai, no run, st Amal Mudappattu b R Bhushan,","noball_dismissal":false,"text":"","timestamp":1752856570,"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":"150539","how_out":"st Amal Mudappattu b R Bhushan","batsman_runs":"6","batsman_balls":"2"},{"event_id":"12361025","event":"ball","batsman_id":"108070","bowler_id":"108054","over":"9","ball":"4","score":4,"commentary":"Raj Bhushan to Benjamin Das, Four,","noball_dismissal":false,"text":"","timestamp":1752856598,"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":"12361026","event":"ball","batsman_id":"108070","bowler_id":"108054","over":"9","ball":"5","score":1,"commentary":"Raj Bhushan to Benjamin Das, 1 run,","noball_dismissal":false,"text":"","timestamp":1752856603,"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":"12361031","event":"ball","batsman_id":"108069","bowler_id":"108054","over":"9","ball":"6","score":0,"commentary":"Raj Bhushan to Kashif Shahab, no run,","noball_dismissal":false,"text":"","timestamp":1752856629,"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":10,"runs":11,"score":"134\/5","bats":[{"runs":83,"balls_faced":31,"fours":7,"sixes":8,"batsman_id":108069},{"runs":5,"balls_faced":2,"fours":1,"sixes":0,"batsman_id":108070}],"bowls":[{"runs_conceded":33,"maidens":0,"wickets":2,"bowler_id":108054,"overs":2},{"runs_conceded":26,"maidens":0,"wickets":1,"bowler_id":107918,"overs":2}],"commentary":"End of over 10 (11 runs), Dussledorf Blackcaps 134\/5"}],"day":"0","session":"0","live_inning":{"iid":199783,"number":2,"name":"Dussledorf Blackcaps Inning","short_name":"DB Inning","status":2,"issuperover":"false","result":4,"batting_team_id":119937,"fielding_team_id":119922,"scores":"134\/5","scores_full":"134\/5 (10 ov)","fielder":[{"fielder_id":"118805","fielder_name":"Amal Mudappattu","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":1,"is_substitute":"false"},{"fielder_id":"118853","fielder_name":"Zakirullah Asmari","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"130899","fielder_name":"Ace Pruss ","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":[],"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Ahmadzia Ahmadzai","batsman_id":"150539","runs":"6","balls":"2","how_out":"st Amal Mudappattu b R Bhushan","score_at_dismissal":129,"overs_at_dismissal":"9.3","bowler_id":"108054","dismissal":"stumped","number":5},"extra_runs":{"byes":5,"legbyes":1,"wides":0,"noballs":0,"penalty":"0","total":6},"equations":{"runs":134,"wickets":5,"overs":"10","bowlers_used":5,"runrate":"13.40"},"current_partnership":{"runs":5,"balls":3,"overs":0.3,"batsmen":[{"name":"Benjamin Das","batsman_id":108070,"runs":5,"balls":2},{"name":"Kashif Shahab","batsman_id":108069,"runs":0,"balls":1}]},"did_not_bat":[{"player_id":"150541","name":"Vikesh Subramoniam"},{"player_id":"150536","name":"Koushik Chowdhury"},{"player_id":"150543","name":"Popal Katakhil"},{"player_id":"130962","name":"Raviteja Velamuri"}],"max_over":"10","target":"170","recent_scores":"0,1,4,w,6,w,6,1,0,1,0,6,1,0,4,4,0,6","last_five_overs":"65\/2 13.00","last_ten_overs":"134\/5 13.40"},"teams":[{"tid":119922,"title":"VFB Gelsenkirchen","abbr":"VG","alt_name":"VG","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2021\/05\/scrnli_5_14_2021_9-57-36-PM.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2021\/05\/scrnli_5_14_2021_9-57-36-PM.png","country":"de","sex":"male","team_owner":"","head_coach":"","scores_full":"169\/3 (10 ov)","scores":"169\/3","overs":"10"},{"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":"134\/5 (10 ov)","scores":"134\/5","overs":"10"}],"players":[{"pid":99522,"title":"Muhammad Asif-I","short_name":"M Asif","first_name":"Muhammad Asif-I","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":101529,"title":"Gopinath Manoharan","short_name":"G Manoharan","first_name":"Gopinath Manoharan","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":107905,"title":"Mirwali Jabarkheel","short_name":"M Jabarkheel","first_name":"Mirwali Jabarkheel","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":""},{"pid":107916,"title":"Rubesh Palaniappan","short_name":"R Palaniappan","first_name":"Rubesh Palaniappan","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":""},{"pid":107918,"title":"Shrutarv Awasthi","short_name":"S Awasthi","first_name":"Shrutarv Awasthi","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":108046,"title":"Waqas Fatmi","short_name":"W Fatmi","first_name":"Waqas Fatmi","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":108054,"title":"Raj Bhushan","short_name":"R Bhushan","first_name":"Raj Bhushan","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":""},{"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":7,"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":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"all","role_str":"(C)"},{"pid":108074,"title":"Muhammad Raheel","short_name":"M Raheel","first_name":"Muhammad Raheel","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"all","role_str":""},{"pid":113286,"title":"Shazaib Khan","short_name":"S Khan","first_name":"Shazaib Khan","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":118805,"title":"Amal Mudappattu","short_name":"Amal Mudappattu","first_name":"Amal Mudappattu","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"wk","role_str":"(WK\/C)"},{"pid":118853,"title":"Zakirullah Asmari","short_name":"Z Asmari","first_name":"Zakirullah Asmari","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":118911,"title":"Punith Murugesh ","short_name":"P Murugesh","first_name":"Punith Murugesh ","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"squad","role_str":""},{"pid":118914,"title":"Ronit Satapathy","short_name":"R Satapathy","first_name":"Ronit Satapathy","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":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"squad","role_str":""},{"pid":118923,"title":"Krishnan Sahasranaman","short_name":"Krishnan Sahasranaman","first_name":"Krishnan Sahasranaman","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":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"squad","role_str":""},{"pid":118925,"title":"Muhammad Oweis","short_name":"Muhammad Oweis","first_name":"Muhammad Oweis","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":"squad","role_str":""},{"pid":130896,"title":"Jay Tamakuwala","short_name":"J Tamakuwala","first_name":"Jay Tamakuwala","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"squad","role_str":""},{"pid":130899,"title":"Ace Pruss ","short_name":"A Pruss ","first_name":"Ace Pruss ","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":""},{"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":8,"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":"bowl","role_str":""},{"pid":150473,"title":"Rahul Mathavan","short_name":"R Mathavan","first_name":"Rahul Mathavan","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":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"squad","role_str":""},{"pid":150474,"title":"Manush Mani","short_name":"M Mani","first_name":"Manush Mani","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","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,"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":"squad","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":"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":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":7,"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":6,"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":7,"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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""}]},"etag":"2e4ec86cc395d044a189c001d1845411","modified":"2025-07-25 22:32:09","datetime":"2025-07-25 22:32:09","api_version":"3.0"}', Modified = GetDate() WHERE Id = 91609 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:f8a05db9-a9cf-4880-a667-e951157e0136
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 91609 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (91609,3,'{"status":"ok","response":{"match_id":91609,"title":"VFB Gelsenkirchen vs Dussledorf Blackcaps","short_title":"VG vs DB","subtitle":"Final","match_number":"24","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"VFB Gelsenkirchen won by 35 runs","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":"10"},"teama":{"team_id":119922,"name":"VFB Gelsenkirchen","short_name":"VG","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2021\/05\/scrnli_5_14_2021_9-57-36-PM.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2021\/05\/scrnli_5_14_2021_9-57-36-PM.png","scores_full":"169\/3 (10 ov)","scores":"169\/3","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":"134\/5 (10 ov)","scores":"134\/5","overs":"10"},"date_start":"2025-07-18 15:00:00","date_end":"2025-07-19 01:00:00","timestamp_start":1752850800,"timestamp_end":1752886800,"date_start_ist":"2025-07-18 20:30:00","date_end_ist":"2025-07-19 06:30: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":"VG won by 35 runs","result_type":1,"win_margin":"35 runs","winning_team_id":119922,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-18 19:40:28","verify_time":"2025-07-18 22:21:54","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":26.93,"humidity":45,"visibility":10000,"wind_speed":"2.26","clouds":100},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"VFB Gelsenkirchen elected to bat","winner":119922,"decision":1}},"etag":"111ec3aff4aab014b589cf5027188fc8","modified":"2025-07-25 22:32:10","datetime":"2025-07-25 22:32:10","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":91609,"title":"VFB Gelsenkirchen vs Dussledorf Blackcaps","short_title":"VG vs DB","subtitle":"Final","match_number":"24","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"VFB Gelsenkirchen won by 35 runs","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":"10"},"teama":{"team_id":119922,"name":"VFB Gelsenkirchen","short_name":"VG","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2021\/05\/scrnli_5_14_2021_9-57-36-PM.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2021\/05\/scrnli_5_14_2021_9-57-36-PM.png","scores_full":"169\/3 (10 ov)","scores":"169\/3","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":"134\/5 (10 ov)","scores":"134\/5","overs":"10"},"date_start":"2025-07-18 15:00:00","date_end":"2025-07-19 01:00:00","timestamp_start":1752850800,"timestamp_end":1752886800,"date_start_ist":"2025-07-18 20:30:00","date_end_ist":"2025-07-19 06:30: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":"VG won by 35 runs","result_type":1,"win_margin":"35 runs","winning_team_id":119922,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-18 19:40:28","verify_time":"2025-07-18 22:21:54","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":26.93,"humidity":45,"visibility":10000,"wind_speed":"2.26","clouds":100},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"High Scoring","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"VFB Gelsenkirchen elected to bat","winner":119922,"decision":1}},"etag":"111ec3aff4aab014b589cf5027188fc8","modified":"2025-07-25 22:32:10","datetime":"2025-07-25 22:32:10","api_version":"3.0"}', Modified = GetDate() WHERE Id = 91609 AND DataTypeId = 3 END Live Report & Scorecard of VFB Gelsenkirchen vs Dussledorf Blackcaps Final
VFB Gelsenkirchen vs Dussledorf Blackcaps, Live Cricket Commentary