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:fb28f70b-0e36-4417-b6ed-34a461e0ffa3
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 89997 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (89997,1,'{"status":"ok","response":{"mid":89997,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Netherlands won by superover","day_remaining_over":"","team_batting":"Netherlands","team_bowling":"Nepal","live_inning_number":8,"live_score":{"runs":6,"overs":0.1,"wickets":0,"target":1,"runrate":36,"required_runrate":""},"commentary":1,"wagon":1,"batsmen":[{"name":"Michael Levitt","batsman_id":127478,"runs":6,"balls_faced":1,"fours":0,"sixes":1,"strike_rate":"600.00"},{"name":"Zach Lion Cachet","batsman_id":147226,"runs":0,"balls_faced":0,"fours":0,"sixes":0,"strike_rate":"0.00"}],"bowlers":[{"name":"Sandeep Lamichhane","bowler_id":1080,"overs":0.1,"runs_conceded":6,"wickets":0,"maidens":0,"econ":"36.00"}],"commentaries":[{"event_id":"12157661","event":"ball","batsman_id":"127478","bowler_id":"1080","over":"0","ball":"1","score":6,"commentary":"Sandeep Lamichhane to Michael Levitt, Six, Six !! What a delivery! off break ball lands right on the off stump, Michael Levitt hangs in the crease, exhibits impeccable timing as batter hammers pull sending it flying to the deep mid wicket region for a remarkable Maximum!","noball_dismissal":false,"text":"Six !! What a delivery! off break ball lands right on the off stump, Michael Levitt hangs in the crease, exhibits impeccable timing as batter hammers pull sending it flying to the deep mid wicket region for a remarkable Maximum!","timestamp":1750097817,"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}],"day":"0","session":"0","live_inning":{"iid":198217,"number":8,"name":"Netherlands Inning","short_name":"NED Inning","status":2,"issuperover":"true","result":3,"batting_team_id":1824,"fielding_team_id":10814,"scores":"6\/0","scores_full":"6\/0 (0.1 ov)","fielder":[],"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":[],"extra_runs":{"byes":0,"legbyes":0,"wides":0,"noballs":0,"penalty":"0","total":0},"equations":{"runs":6,"wickets":0,"overs":"0.1","bowlers_used":1,"runrate":"36.00"},"current_partnership":{"runs":6,"balls":1,"overs":0.1,"batsmen":[{"name":"Michael Levitt","batsman_id":127478,"runs":6,"balls":1},{"name":"Zach Lion Cachet","batsman_id":147226,"runs":0,"balls":0}]},"did_not_bat":[{"player_id":"49141","name":"Max O''Dowd"},{"player_id":"93416","name":"Scott Edwards"},{"player_id":"93438","name":"Teja Nidamanuru"},{"player_id":"127477","name":"Noah Croes"},{"player_id":"96055","name":"Vikramjit Singh"},{"player_id":"52631","name":"Saqib Zulfiqar"},{"player_id":"131221","name":"Kyle Klein"},{"player_id":"144334","name":"Ben Fletcher"},{"player_id":"57948","name":"Daniel Doram"}],"max_over":"1","target":"1","recent_scores":"6","last_five_overs":"6\/0 36.00","last_ten_overs":"6\/0 36.00"},"teams":[{"tid":1824,"title":"Netherlands","abbr":"NED","alt_name":"Netherlands","type":"country","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Netherlands.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Netherlands.png","country":"nl","sex":"male","team_owner":"","head_coach":"Ryan Cook","scores_full":"152\/7 (20 ov) & 19\/0 (1 ov) & 17\/2 (1 ov)","scores":"152\/7 & 19\/0 & 17\/2","overs":"20 & 1 & 1"},{"tid":10814,"title":"Nepal","abbr":"NEP","alt_name":"Nepal","type":"country","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Nepal.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Nepal.png","country":"np","sex":"male","team_owner":"","head_coach":"","scores_full":"152\/8 (20 ov) & 19\/1 (1 ov) & 17\/0 (1 ov)","scores":"152\/8 & 19\/1 & 17\/0","overs":"20 & 1 & 1"}],"players":[{"pid":1074,"title":"Aarif Sheikh","short_name":"A Sheikh","first_name":"Aarif Sheikh","last_name":"","middle_name":"","birthdate":"1997-10-05","birthplace":"","country":"np","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Nepal","role":"squad","role_str":""},{"pid":1076,"title":"Dipendra Singh Airee","short_name":"DS Airee","first_name":"Dipendra Singh Airee","last_name":"","middle_name":"","birthdate":"2000-01-24","birthplace":"","country":"np","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":"Nepal","role":"all","role_str":""},{"pid":1077,"title":"Kushal Bhurtel","short_name":"K Bhurtel","first_name":"Kushal Bhurtel","last_name":"","middle_name":"","birthdate":"1997-01-22","birthplace":"","country":"np","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Nepal","role":"all","role_str":""},{"pid":1080,"title":"Sandeep Lamichhane","short_name":"S Lamichhane","first_name":"Sandeep Lamichhane","last_name":"","middle_name":"","birthdate":"2000-08-02","birthplace":"","country":"np","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Nepal","role":"bowl","role_str":""},{"pid":1899,"title":"Roelof van der Merwe","short_name":"R Merwe","first_name":"Roelof van der Merwe","last_name":"","middle_name":"","birthdate":"1984-12-31","birthplace":"johannesburg,Transvaal","country":"nl","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/people\/Roelof-Van-der-Merwe\/100083113765394\/","twitter_profile":"https:\/\/twitter.com\/roela52","instagram_profile":"https:\/\/www.instagram.com\/roela52\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"squad","role_str":""},{"pid":1909,"title":"Paul van Meekeren","short_name":"P Meekeren","first_name":"Paul van Meekeren","last_name":"","middle_name":"","birthdate":"1993-01-15","birthplace":"Amsterdam, Netherlands","country":"nl","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/paulvanmeekeren","instagram_profile":"https:\/\/www.instagram.com\/pvm47\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"squad","role_str":""},{"pid":43979,"title":"Sompal Kami","short_name":"Sompal Kami","first_name":"Sompal Kami","last_name":"","middle_name":"","birthdate":"1996-02-02","birthplace":"","country":"np","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast 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":"Nepal","role":"squad","role_str":""},{"pid":46620,"title":"Lalit Rajbanshi","short_name":"Lalit Rajbanshi","first_name":"Lalit Rajbanshi","last_name":"","middle_name":"","birthdate":"1999-02-27","birthplace":"","country":"np","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Nepal","role":"bowl","role_str":""},{"pid":48329,"title":"Vivian Kingma","short_name":"VJ Kingma","first_name":"Vivian Kingma","last_name":"","middle_name":"","birthdate":"1994-10-23","birthplace":"The Hague, Netherlands","country":"nl","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/viviankingma","instagram_profile":"https:\/\/www.instagram.com\/viviankingma\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"squad","role_str":""},{"pid":49133,"title":"KC Karan ","short_name":"KC Karan ","first_name":"KC Karan ","last_name":"","middle_name":"","birthdate":"1991-10-10","birthplace":"","country":"np","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":"Nepal","role":"bowl","role_str":""},{"pid":49141,"title":"Max O''Dowd","short_name":"M O''Dowd","first_name":"Max O''Dowd","last_name":"","middle_name":"","birthdate":"1994-03-04","birthplace":"Auckland","country":"nl","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Maxiboi23","instagram_profile":"https:\/\/www.instagram.com\/maxodowd\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"bat","role_str":""},{"pid":52631,"title":"Saqib Zulfiqar","short_name":"S Zulfiqar","first_name":"Saqib Zulfiqar","last_name":"","middle_name":"","birthdate":"1997-03-28","birthplace":"","country":"nl","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/saqibz1997","instagram_profile":"https:\/\/www.instagram.com\/zulfiqarsaqib\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"all","role_str":""},{"pid":57948,"title":"Daniel Doram","short_name":"DT Doram","first_name":"Daniel Doram","last_name":"","middle_name":"","birthdate":"1997-10-13","birthplace":"","country":"nl","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"bowl","role_str":""},{"pid":93416,"title":"Scott Edwards","short_name":"S Edwards","first_name":"Scott Edwards","last_name":"","middle_name":"","birthdate":"1996-08-23","birthplace":"Tonga","country":"nl","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/scott_edwards35","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"wk","role_str":"(WK\/C)"},{"pid":93425,"title":"Anil Kumar Sah","short_name":"A Kumar Sah","first_name":"Anil Kumar Sah","last_name":"","middle_name":"","birthdate":"1998-11-17","birthplace":"","country":"np","primary_team":[],"logo_url":"","playing_role":"wk","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":"Nepal","role":"wk","role_str":"(WK)"},{"pid":93438,"title":"Teja Nidamanuru","short_name":"T Nidamanuru","first_name":"Teja Nidamanuru","last_name":"","middle_name":"","birthdate":"1994-08-22","birthplace":"Vijayawada,Andhra pradesh","country":"nl","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"https:\/\/www.facebook.com\/tnidamanuru\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/teja_52\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"bat","role_str":""},{"pid":94193,"title":"Aasif Sheikh","short_name":"A Sheikh","first_name":"Aasif Sheikh","last_name":"","middle_name":"","birthdate":"2001-06-22","birthplace":"","country":"np","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Nepal","role":"squad","role_str":""},{"pid":94202,"title":"Bhim Sharki","short_name":"B Sharki","first_name":"Bhim Sharki","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"np","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":"Nepal","role":"squad","role_str":""},{"pid":94204,"title":"Nandan Yadav","short_name":"NK Yadav","first_name":"Nandan Yadav","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"np","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Nepal","role":"bowl","role_str":""},{"pid":96047,"title":"Lokesh Bam","short_name":"L Bam","first_name":"Lokesh Bam","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"np","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":"Nepal","role":"wk","role_str":""},{"pid":96055,"title":"Vikramjit Singh","short_name":"V Singh","first_name":"Vikramjit Singh","last_name":"","middle_name":"","birthdate":"2003-01-09","birthplace":"Cheema Khurd, punjab","country":"nl","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/vikram.sahi.79\/","twitter_profile":"https:\/\/twitter.com\/vikramjit_91","instagram_profile":"https:\/\/www.instagram.com\/vikram.s07\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"bat","role_str":""},{"pid":103092,"title":"Aryan Dutt","short_name":"A Dutt","first_name":"Aryan Dutt","last_name":"","middle_name":"","birthdate":"2003-05-12","birthplace":"","country":"nl","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":8.5,"facebook_profile":"","twitter_profile":"https:\/\/www.instagram.com\/aryan.dutt\/","instagram_profile":"https:\/\/www.instagram.com\/aryan.dutt\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"squad","role_str":""},{"pid":105124,"title":"Kiran Thagunna","short_name":"K Thagunna","first_name":"Kiran Thagunna","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"np","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":"Nepal","role":"bat","role_str":""},{"pid":110016,"title":"Rohit Kumar Paudel","short_name":"Rohit Paudel","first_name":"Rohit Kumar Paudel","last_name":"","middle_name":"","birthdate":"2002-09-02","birthplace":"","country":"np","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Nepal","role":"bat","role_str":"(C)"},{"pid":110573,"title":"Rijan Dhakal","short_name":"R Dhakal","first_name":"Rijan Dhakal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"np","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":"Nepal","role":"squad","role_str":""},{"pid":113384,"title":"Gulshan Jha","short_name":"G Jha","first_name":"Gulshan Jha","last_name":"","middle_name":"","birthdate":"2006-02-17","birthplace":"","country":"np","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left 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":"Nepal","role":"squad","role_str":""},{"pid":121842,"title":"Rupesh Singh","short_name":"R Singh","first_name":"Rupesh Singh","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"np","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Nepal","role":"all","role_str":""},{"pid":127477,"title":"Noah Croes","short_name":"N Croes","first_name":"Noah Croes","last_name":"","middle_name":"","birthdate":"1999-12-13","birthplace":"","country":"nl","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"bat","role_str":""},{"pid":127478,"title":"Michael Levitt","short_name":"M Levitt","first_name":"Michael Levitt","last_name":"","middle_name":"","birthdate":"2003-06-19","birthplace":"","country":"nl","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"all","role_str":""},{"pid":131221,"title":"Kyle Klein","short_name":"K Klein","first_name":"Kyle Klein","last_name":"","middle_name":"","birthdate":"2001-07-03","birthplace":"","country":"nl","primary_team":[],"logo_url":"","playing_role":"bowl","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":"Netherlands","role":"bowl","role_str":""},{"pid":136272,"title":"Basir Ahmed","short_name":"B Ahmed","first_name":"Basir Ahmed","last_name":"","middle_name":"","birthdate":"2003-09-11","birthplace":"","country":"np","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":"Nepal","role":"squad","role_str":""},{"pid":144334,"title":"Ben Fletcher","short_name":"B Fletcher","first_name":"Ben Fletcher","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"nl","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":"Netherlands","role":"bowl","role_str":""},{"pid":147226,"title":"Zach Lion Cachet","short_name":"Z Cachet","first_name":"Zach Lion Cachet","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"nl","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"all","role_str":""}]},"etag":"80522f619976eaf223a802ee763d56ca","modified":"2025-07-30 22:20:26","datetime":"2025-07-30 22:20:26","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":89997,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Netherlands won by superover","day_remaining_over":"","team_batting":"Netherlands","team_bowling":"Nepal","live_inning_number":8,"live_score":{"runs":6,"overs":0.1,"wickets":0,"target":1,"runrate":36,"required_runrate":""},"commentary":1,"wagon":1,"batsmen":[{"name":"Michael Levitt","batsman_id":127478,"runs":6,"balls_faced":1,"fours":0,"sixes":1,"strike_rate":"600.00"},{"name":"Zach Lion Cachet","batsman_id":147226,"runs":0,"balls_faced":0,"fours":0,"sixes":0,"strike_rate":"0.00"}],"bowlers":[{"name":"Sandeep Lamichhane","bowler_id":1080,"overs":0.1,"runs_conceded":6,"wickets":0,"maidens":0,"econ":"36.00"}],"commentaries":[{"event_id":"12157661","event":"ball","batsman_id":"127478","bowler_id":"1080","over":"0","ball":"1","score":6,"commentary":"Sandeep Lamichhane to Michael Levitt, Six, Six !! What a delivery! off break ball lands right on the off stump, Michael Levitt hangs in the crease, exhibits impeccable timing as batter hammers pull sending it flying to the deep mid wicket region for a remarkable Maximum!","noball_dismissal":false,"text":"Six !! What a delivery! off break ball lands right on the off stump, Michael Levitt hangs in the crease, exhibits impeccable timing as batter hammers pull sending it flying to the deep mid wicket region for a remarkable Maximum!","timestamp":1750097817,"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}],"day":"0","session":"0","live_inning":{"iid":198217,"number":8,"name":"Netherlands Inning","short_name":"NED Inning","status":2,"issuperover":"true","result":3,"batting_team_id":1824,"fielding_team_id":10814,"scores":"6\/0","scores_full":"6\/0 (0.1 ov)","fielder":[],"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":[],"extra_runs":{"byes":0,"legbyes":0,"wides":0,"noballs":0,"penalty":"0","total":0},"equations":{"runs":6,"wickets":0,"overs":"0.1","bowlers_used":1,"runrate":"36.00"},"current_partnership":{"runs":6,"balls":1,"overs":0.1,"batsmen":[{"name":"Michael Levitt","batsman_id":127478,"runs":6,"balls":1},{"name":"Zach Lion Cachet","batsman_id":147226,"runs":0,"balls":0}]},"did_not_bat":[{"player_id":"49141","name":"Max O''Dowd"},{"player_id":"93416","name":"Scott Edwards"},{"player_id":"93438","name":"Teja Nidamanuru"},{"player_id":"127477","name":"Noah Croes"},{"player_id":"96055","name":"Vikramjit Singh"},{"player_id":"52631","name":"Saqib Zulfiqar"},{"player_id":"131221","name":"Kyle Klein"},{"player_id":"144334","name":"Ben Fletcher"},{"player_id":"57948","name":"Daniel Doram"}],"max_over":"1","target":"1","recent_scores":"6","last_five_overs":"6\/0 36.00","last_ten_overs":"6\/0 36.00"},"teams":[{"tid":1824,"title":"Netherlands","abbr":"NED","alt_name":"Netherlands","type":"country","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Netherlands.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Netherlands.png","country":"nl","sex":"male","team_owner":"","head_coach":"Ryan Cook","scores_full":"152\/7 (20 ov) & 19\/0 (1 ov) & 17\/2 (1 ov)","scores":"152\/7 & 19\/0 & 17\/2","overs":"20 & 1 & 1"},{"tid":10814,"title":"Nepal","abbr":"NEP","alt_name":"Nepal","type":"country","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Nepal.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Nepal.png","country":"np","sex":"male","team_owner":"","head_coach":"","scores_full":"152\/8 (20 ov) & 19\/1 (1 ov) & 17\/0 (1 ov)","scores":"152\/8 & 19\/1 & 17\/0","overs":"20 & 1 & 1"}],"players":[{"pid":1074,"title":"Aarif Sheikh","short_name":"A Sheikh","first_name":"Aarif Sheikh","last_name":"","middle_name":"","birthdate":"1997-10-05","birthplace":"","country":"np","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Nepal","role":"squad","role_str":""},{"pid":1076,"title":"Dipendra Singh Airee","short_name":"DS Airee","first_name":"Dipendra Singh Airee","last_name":"","middle_name":"","birthdate":"2000-01-24","birthplace":"","country":"np","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":"Nepal","role":"all","role_str":""},{"pid":1077,"title":"Kushal Bhurtel","short_name":"K Bhurtel","first_name":"Kushal Bhurtel","last_name":"","middle_name":"","birthdate":"1997-01-22","birthplace":"","country":"np","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Nepal","role":"all","role_str":""},{"pid":1080,"title":"Sandeep Lamichhane","short_name":"S Lamichhane","first_name":"Sandeep Lamichhane","last_name":"","middle_name":"","birthdate":"2000-08-02","birthplace":"","country":"np","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Nepal","role":"bowl","role_str":""},{"pid":1899,"title":"Roelof van der Merwe","short_name":"R Merwe","first_name":"Roelof van der Merwe","last_name":"","middle_name":"","birthdate":"1984-12-31","birthplace":"johannesburg,Transvaal","country":"nl","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/people\/Roelof-Van-der-Merwe\/100083113765394\/","twitter_profile":"https:\/\/twitter.com\/roela52","instagram_profile":"https:\/\/www.instagram.com\/roela52\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"squad","role_str":""},{"pid":1909,"title":"Paul van Meekeren","short_name":"P Meekeren","first_name":"Paul van Meekeren","last_name":"","middle_name":"","birthdate":"1993-01-15","birthplace":"Amsterdam, Netherlands","country":"nl","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/paulvanmeekeren","instagram_profile":"https:\/\/www.instagram.com\/pvm47\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"squad","role_str":""},{"pid":43979,"title":"Sompal Kami","short_name":"Sompal Kami","first_name":"Sompal Kami","last_name":"","middle_name":"","birthdate":"1996-02-02","birthplace":"","country":"np","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast 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":"Nepal","role":"squad","role_str":""},{"pid":46620,"title":"Lalit Rajbanshi","short_name":"Lalit Rajbanshi","first_name":"Lalit Rajbanshi","last_name":"","middle_name":"","birthdate":"1999-02-27","birthplace":"","country":"np","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Nepal","role":"bowl","role_str":""},{"pid":48329,"title":"Vivian Kingma","short_name":"VJ Kingma","first_name":"Vivian Kingma","last_name":"","middle_name":"","birthdate":"1994-10-23","birthplace":"The Hague, Netherlands","country":"nl","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/viviankingma","instagram_profile":"https:\/\/www.instagram.com\/viviankingma\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"squad","role_str":""},{"pid":49133,"title":"KC Karan ","short_name":"KC Karan ","first_name":"KC Karan ","last_name":"","middle_name":"","birthdate":"1991-10-10","birthplace":"","country":"np","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":"Nepal","role":"bowl","role_str":""},{"pid":49141,"title":"Max O''Dowd","short_name":"M O''Dowd","first_name":"Max O''Dowd","last_name":"","middle_name":"","birthdate":"1994-03-04","birthplace":"Auckland","country":"nl","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Maxiboi23","instagram_profile":"https:\/\/www.instagram.com\/maxodowd\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"bat","role_str":""},{"pid":52631,"title":"Saqib Zulfiqar","short_name":"S Zulfiqar","first_name":"Saqib Zulfiqar","last_name":"","middle_name":"","birthdate":"1997-03-28","birthplace":"","country":"nl","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/saqibz1997","instagram_profile":"https:\/\/www.instagram.com\/zulfiqarsaqib\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"all","role_str":""},{"pid":57948,"title":"Daniel Doram","short_name":"DT Doram","first_name":"Daniel Doram","last_name":"","middle_name":"","birthdate":"1997-10-13","birthplace":"","country":"nl","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"bowl","role_str":""},{"pid":93416,"title":"Scott Edwards","short_name":"S Edwards","first_name":"Scott Edwards","last_name":"","middle_name":"","birthdate":"1996-08-23","birthplace":"Tonga","country":"nl","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/scott_edwards35","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"wk","role_str":"(WK\/C)"},{"pid":93425,"title":"Anil Kumar Sah","short_name":"A Kumar Sah","first_name":"Anil Kumar Sah","last_name":"","middle_name":"","birthdate":"1998-11-17","birthplace":"","country":"np","primary_team":[],"logo_url":"","playing_role":"wk","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":"Nepal","role":"wk","role_str":"(WK)"},{"pid":93438,"title":"Teja Nidamanuru","short_name":"T Nidamanuru","first_name":"Teja Nidamanuru","last_name":"","middle_name":"","birthdate":"1994-08-22","birthplace":"Vijayawada,Andhra pradesh","country":"nl","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"https:\/\/www.facebook.com\/tnidamanuru\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/teja_52\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"bat","role_str":""},{"pid":94193,"title":"Aasif Sheikh","short_name":"A Sheikh","first_name":"Aasif Sheikh","last_name":"","middle_name":"","birthdate":"2001-06-22","birthplace":"","country":"np","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Nepal","role":"squad","role_str":""},{"pid":94202,"title":"Bhim Sharki","short_name":"B Sharki","first_name":"Bhim Sharki","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"np","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":"Nepal","role":"squad","role_str":""},{"pid":94204,"title":"Nandan Yadav","short_name":"NK Yadav","first_name":"Nandan Yadav","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"np","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Nepal","role":"bowl","role_str":""},{"pid":96047,"title":"Lokesh Bam","short_name":"L Bam","first_name":"Lokesh Bam","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"np","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":"Nepal","role":"wk","role_str":""},{"pid":96055,"title":"Vikramjit Singh","short_name":"V Singh","first_name":"Vikramjit Singh","last_name":"","middle_name":"","birthdate":"2003-01-09","birthplace":"Cheema Khurd, punjab","country":"nl","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/vikram.sahi.79\/","twitter_profile":"https:\/\/twitter.com\/vikramjit_91","instagram_profile":"https:\/\/www.instagram.com\/vikram.s07\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"bat","role_str":""},{"pid":103092,"title":"Aryan Dutt","short_name":"A Dutt","first_name":"Aryan Dutt","last_name":"","middle_name":"","birthdate":"2003-05-12","birthplace":"","country":"nl","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":8.5,"facebook_profile":"","twitter_profile":"https:\/\/www.instagram.com\/aryan.dutt\/","instagram_profile":"https:\/\/www.instagram.com\/aryan.dutt\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"squad","role_str":""},{"pid":105124,"title":"Kiran Thagunna","short_name":"K Thagunna","first_name":"Kiran Thagunna","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"np","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":"Nepal","role":"bat","role_str":""},{"pid":110016,"title":"Rohit Kumar Paudel","short_name":"Rohit Paudel","first_name":"Rohit Kumar Paudel","last_name":"","middle_name":"","birthdate":"2002-09-02","birthplace":"","country":"np","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Nepal","role":"bat","role_str":"(C)"},{"pid":110573,"title":"Rijan Dhakal","short_name":"R Dhakal","first_name":"Rijan Dhakal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"np","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":"Nepal","role":"squad","role_str":""},{"pid":113384,"title":"Gulshan Jha","short_name":"G Jha","first_name":"Gulshan Jha","last_name":"","middle_name":"","birthdate":"2006-02-17","birthplace":"","country":"np","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left 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":"Nepal","role":"squad","role_str":""},{"pid":121842,"title":"Rupesh Singh","short_name":"R Singh","first_name":"Rupesh Singh","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"np","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Nepal","role":"all","role_str":""},{"pid":127477,"title":"Noah Croes","short_name":"N Croes","first_name":"Noah Croes","last_name":"","middle_name":"","birthdate":"1999-12-13","birthplace":"","country":"nl","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"bat","role_str":""},{"pid":127478,"title":"Michael Levitt","short_name":"M Levitt","first_name":"Michael Levitt","last_name":"","middle_name":"","birthdate":"2003-06-19","birthplace":"","country":"nl","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":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"all","role_str":""},{"pid":131221,"title":"Kyle Klein","short_name":"K Klein","first_name":"Kyle Klein","last_name":"","middle_name":"","birthdate":"2001-07-03","birthplace":"","country":"nl","primary_team":[],"logo_url":"","playing_role":"bowl","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":"Netherlands","role":"bowl","role_str":""},{"pid":136272,"title":"Basir Ahmed","short_name":"B Ahmed","first_name":"Basir Ahmed","last_name":"","middle_name":"","birthdate":"2003-09-11","birthplace":"","country":"np","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":"Nepal","role":"squad","role_str":""},{"pid":144334,"title":"Ben Fletcher","short_name":"B Fletcher","first_name":"Ben Fletcher","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"nl","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":"Netherlands","role":"bowl","role_str":""},{"pid":147226,"title":"Zach Lion Cachet","short_name":"Z Cachet","first_name":"Zach Lion Cachet","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"nl","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Netherlands","role":"all","role_str":""}]},"etag":"80522f619976eaf223a802ee763d56ca","modified":"2025-07-30 22:20:26","datetime":"2025-07-30 22:20:26","api_version":"3.0"}', Modified = GetDate() WHERE Id = 89997 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:fb28f70b-0e36-4417-b6ed-34a461e0ffa3
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 89997 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (89997,3,'{"status":"ok","response":{"match_id":89997,"title":"Netherlands vs Nepal","short_title":"NED vs NEP","subtitle":"2nd T20I","match_number":"2","format":3,"format_str":"T20I","status":2,"status_str":"Completed","status_note":"Netherlands won by superover","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129593,"title":"Scotland T20 Tri Series","abbr":"Scotland T20 Tri-Series","type":"tournament","category":"international","match_format":"t20i","season":"2025","status":"result","datestart":"2025-06-15","dateend":"2025-06-20","country":"sct","total_matches":"6","total_rounds":"1","total_teams":"3"},"teama":{"team_id":1824,"name":"Netherlands","short_name":"NED","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Netherlands.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Netherlands.png","scores_full":"152\/7 (20 ov) & 19\/0 (1 ov) & 17\/2 (1 ov)","scores":"152\/7 & 19\/0 & 17\/2","overs":"20 & 1 & 1"},"teamb":{"team_id":10814,"name":"Nepal","short_name":"NEP","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Nepal.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Nepal.png","scores_full":"152\/8 (20 ov) & 19\/1 (1 ov) & 17\/0 (1 ov)","scores":"152\/8 & 19\/1 & 17\/0","overs":"20 & 1 & 1"},"date_start":"2025-06-16 14:00:00","date_end":"2025-06-17 00:00:00","timestamp_start":1750082400,"timestamp_end":1750118400,"date_start_ist":"2025-06-16 19:30:00","date_end_ist":"2025-06-17 05:30:00","venue":{"venue_id":"1213397","name":"Titwood","location":"Glasgow","country":"Scotland","timezone":""},"umpires":"Iain McDonald (Scotland), Ryan Milne (Scotland), David McLean (Scotland, TV)","referee":"Philip Thompson (Ireland)","equation":"","live":"","result":"NED won by superover","result_type":1,"win_margin":"superover","winning_team_id":1824,"commentary":1,"wagon":1,"latest_inning_number":8,"presquad_time":"2025-06-15 21:02:23","verify_time":"2025-06-17 00:09:32","match_dls_affected":"false","live_inning_number":8,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":16.61,"humidity":76,"visibility":10000,"wind_speed":"12.44","clouds":100},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Nepal elected to bowl","winner":10814,"decision":2}},"etag":"f11ba124454d911d5e60c164b63a4328","modified":"2025-07-30 22:20:27","datetime":"2025-07-30 22:20:27","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":89997,"title":"Netherlands vs Nepal","short_title":"NED vs NEP","subtitle":"2nd T20I","match_number":"2","format":3,"format_str":"T20I","status":2,"status_str":"Completed","status_note":"Netherlands won by superover","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129593,"title":"Scotland T20 Tri Series","abbr":"Scotland T20 Tri-Series","type":"tournament","category":"international","match_format":"t20i","season":"2025","status":"result","datestart":"2025-06-15","dateend":"2025-06-20","country":"sct","total_matches":"6","total_rounds":"1","total_teams":"3"},"teama":{"team_id":1824,"name":"Netherlands","short_name":"NED","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Netherlands.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Netherlands.png","scores_full":"152\/7 (20 ov) & 19\/0 (1 ov) & 17\/2 (1 ov)","scores":"152\/7 & 19\/0 & 17\/2","overs":"20 & 1 & 1"},"teamb":{"team_id":10814,"name":"Nepal","short_name":"NEP","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Nepal.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Nepal.png","scores_full":"152\/8 (20 ov) & 19\/1 (1 ov) & 17\/0 (1 ov)","scores":"152\/8 & 19\/1 & 17\/0","overs":"20 & 1 & 1"},"date_start":"2025-06-16 14:00:00","date_end":"2025-06-17 00:00:00","timestamp_start":1750082400,"timestamp_end":1750118400,"date_start_ist":"2025-06-16 19:30:00","date_end_ist":"2025-06-17 05:30:00","venue":{"venue_id":"1213397","name":"Titwood","location":"Glasgow","country":"Scotland","timezone":""},"umpires":"Iain McDonald (Scotland), Ryan Milne (Scotland), David McLean (Scotland, TV)","referee":"Philip Thompson (Ireland)","equation":"","live":"","result":"NED won by superover","result_type":1,"win_margin":"superover","winning_team_id":1824,"commentary":1,"wagon":1,"latest_inning_number":8,"presquad_time":"2025-06-15 21:02:23","verify_time":"2025-06-17 00:09:32","match_dls_affected":"false","live_inning_number":8,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":16.61,"humidity":76,"visibility":10000,"wind_speed":"12.44","clouds":100},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Nepal elected to bowl","winner":10814,"decision":2}},"etag":"f11ba124454d911d5e60c164b63a4328","modified":"2025-07-30 22:20:27","datetime":"2025-07-30 22:20:27","api_version":"3.0"}', Modified = GetDate() WHERE Id = 89997 AND DataTypeId = 3 END Live Report & Scorecard of Netherlands vs Nepal 2nd T20I