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:b8dd6cfc-9c2e-411d-b61d-20089b57e147 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 91046 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (91046,1,'{"status":"ok","response":{"mid":91046,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Match abondoned due to rain","day_remaining_over":"","team_batting":"Lux Shyam Kolkata Tigers Womens","team_bowling":"Shrachi Rarh Tigers Womens","live_inning_number":2,"live_score":{"runs":3,"overs":2,"wickets":1,"target":78,"runrate":1.5,"required_runrate":9.38},"commentary":1,"wagon":2,"batsmen":[{"name":"Ankita Mahanta","batsman_id":122142,"runs":2,"balls_faced":5,"fours":0,"sixes":0,"strike_rate":"40.00"},{"name":"Parna Paul","batsman_id":106003,"runs":1,"balls_faced":6,"fours":0,"sixes":0,"strike_rate":"16.67"}],"bowlers":[{"name":"Shreya Roy","bowler_id":140547,"overs":1,"runs_conceded":1,"wickets":0,"maidens":0,"econ":"1.00"}],"commentaries":[{"event_id":"12228982","event":"wicket","batsman_id":"106010","bowler_id":"113708","over":"0","ball":"1","score":"w","commentary":"Piyali Ghosh to Mita Paul, no run, b P Ghosh,","noball_dismissal":false,"text":"","timestamp":1750919443,"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":"106010","how_out":"b P Ghosh","batsman_runs":"0","batsman_balls":"1"},{"event_id":"12228994","event":"ball","batsman_id":"106003","bowler_id":"113708","over":"0","ball":"2","score":1,"commentary":"Piyali Ghosh to Parna Paul, 1 run,","noball_dismissal":false,"text":"","timestamp":1750919515,"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":"12228995","event":"ball","batsman_id":"122142","bowler_id":"113708","over":"0","ball":"3","score":0,"commentary":"Piyali Ghosh to Ankita Mahanta, no run,","noball_dismissal":false,"text":"","timestamp":1750919527,"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":"12228997","event":"ball","batsman_id":"122142","bowler_id":"113708","over":"0","ball":"4","score":0,"commentary":"Piyali Ghosh to Ankita Mahanta, no run,","noball_dismissal":false,"text":"","timestamp":1750919543,"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":"12229000","event":"ball","batsman_id":"122142","bowler_id":"113708","over":"0","ball":"5","score":1,"commentary":"Piyali Ghosh to Ankita Mahanta, 1 run,","noball_dismissal":false,"text":"","timestamp":1750919559,"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":"12229002","event":"ball","batsman_id":"106003","bowler_id":"113708","over":"0","ball":"6","score":0,"commentary":"Piyali Ghosh to Parna Paul, no run,","noball_dismissal":false,"text":"","timestamp":1750919652,"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":1,"runs":2,"score":"2\/1","bats":[{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":106003},{"runs":1,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":122142}],"bowls":[{"runs_conceded":2,"maidens":0,"wickets":1,"bowler_id":113708,"overs":1}],"commentary":"End of over 1 (2 runs), Lux Shyam Kolkata Tigers Womens 2\/1"},{"event_id":"12229007","event":"ball","batsman_id":"122142","bowler_id":"140547","over":"1","ball":"1","score":0,"commentary":"Shreya Roy to Ankita Mahanta, no run,","noball_dismissal":false,"text":"","timestamp":1750919678,"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":"12229008","event":"ball","batsman_id":"122142","bowler_id":"140547","over":"1","ball":"2","score":1,"commentary":"Shreya Roy to Ankita Mahanta, 1 run,","noball_dismissal":false,"text":"","timestamp":1750919741,"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":"12229012","event":"ball","batsman_id":"106003","bowler_id":"140547","over":"1","ball":"3","score":0,"commentary":"Shreya Roy to Parna Paul, no run,","noball_dismissal":false,"text":"","timestamp":1750919768,"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":"12229015","event":"ball","batsman_id":"106003","bowler_id":"140547","over":"1","ball":"4","score":0,"commentary":"Shreya Roy to Parna Paul, no run,","noball_dismissal":false,"text":"","timestamp":1750919800,"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":"12229018","event":"ball","batsman_id":"106003","bowler_id":"140547","over":"1","ball":"5","score":0,"commentary":"Shreya Roy to Parna Paul, no run,","noball_dismissal":false,"text":"","timestamp":1750919825,"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":"12229021","event":"ball","batsman_id":"106003","bowler_id":"140547","over":"1","ball":"6","score":0,"commentary":"Shreya Roy to Parna Paul, no run,","noball_dismissal":false,"text":"","timestamp":1750919816,"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":2,"runs":1,"score":"3\/1","bats":[{"runs":1,"balls_faced":6,"fours":0,"sixes":0,"batsman_id":106003},{"runs":2,"balls_faced":5,"fours":0,"sixes":0,"batsman_id":122142}],"bowls":[{"runs_conceded":1,"maidens":0,"wickets":0,"bowler_id":140547,"overs":1},{"runs_conceded":2,"maidens":0,"wickets":1,"bowler_id":113708,"overs":1}],"commentary":"End of over 2 (1 runs), Lux Shyam Kolkata Tigers Womens 3\/1"}],"day":"0","session":"0","live_inning":{"iid":198759,"number":2,"name":"Lux Shyam Kolkata Tigers Womens Inning","short_name":"LSKT-W Inning","status":4,"issuperover":"false","result":0,"batting_team_id":128521,"fielding_team_id":128525,"scores":"3\/1","scores_full":"3\/1 (2 ov)","fielder":[],"powerplay":{"p1":{"startover":"0.1","endover":"3"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Mita Paul","batsman_id":"106010","runs":"0","balls":"1","how_out":"b P Ghosh","score_at_dismissal":0,"overs_at_dismissal":"0.1","bowler_id":"113708","dismissal":"bowled","number":1},"extra_runs":{"byes":0,"legbyes":0,"wides":0,"noballs":0,"penalty":"0","total":0},"equations":{"runs":3,"wickets":1,"overs":"2","bowlers_used":2,"runrate":"1.50"},"current_partnership":{"runs":3,"balls":11,"overs":1.5,"batsmen":[{"name":"Parna Paul","batsman_id":106003,"runs":1,"balls":6},{"name":"Ankita Mahanta","batsman_id":122142,"runs":2,"balls":5}]},"did_not_bat":[{"player_id":"113598","name":"Puja Rajak"},{"player_id":"140545","name":"Tanuja Sarkar"},{"player_id":"140546","name":"Priti Mahato"},{"player_id":"113939","name":"Sujata Dey"},{"player_id":"113605","name":"Ritika Pal"},{"player_id":"140520","name":"Prativa Mandi"},{"player_id":"149734","name":"Salma Khatoon"},{"player_id":"113621","name":"Monika Mal"}],"max_over":"10","target":"78","recent_scores":"0,0,0,0,1,0,0,1,0,0,1,w","last_five_overs":"3\/1 1.50","last_ten_overs":"3\/1 1.50"},"teams":[{"tid":128521,"title":"Lux Shyam Kolkata Tigers Womens","abbr":"LSKT-W","alt_name":"Lux Shyam Kolkata Tigers Womens","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/06\/LSKTW.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/06\/LSKTW.png","country":"in","sex":"female","team_owner":"","head_coach":"","scores_full":"3\/1 (2 ov)","scores":"3\/1","overs":"2"},{"tid":128525,"title":"Shrachi Rarh Tigers Womens","abbr":"SRT-W","alt_name":"Shrachi Rarh Tigers Womens","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/06\/SRTW.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/06\/SRTW.png","country":"in","sex":"female","team_owner":"","head_coach":"","scores_full":"77\/6 (10 ov)","scores":"77\/6","overs":"10"}],"players":[{"pid":48100,"title":"Priya Pandey","short_name":"PB Pandey","first_name":"Priya Pandey","last_name":"","middle_name":"","birthdate":"1996-12-08","birthplace":"","country":"in","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":106003,"title":"Parna Paul","short_name":"P Paul","first_name":"Parna Paul","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","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":"India","role":"wk","role_str":"(WK)"},{"pid":106010,"title":"Mita Paul","short_name":"M Paul","first_name":"Mita Paul","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":"(C)"},{"pid":106011,"title":"Shreya Karar","short_name":"S Karar","first_name":"Shreya Karar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":112093,"title":"Sanshita Sumit Bishwas","short_name":"Sanshita Sumit Bishwas","first_name":"Sanshita Sumit Bishwas","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"wk","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":"India","role":"wk","role_str":""},{"pid":112101,"title":"Pampa Sarkar","short_name":"Pampa Sarkar","first_name":"Pampa Sarkar","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":113598,"title":"Puja Rajak","short_name":"P Rajak","first_name":"Puja Rajak","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":113599,"title":"Brishti Susanta Majhi","short_name":"B S Majhi","first_name":"Brishti Susanta Majhi","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":113605,"title":"Ritika Pal","short_name":"R Pal","first_name":"Ritika Pal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":""},{"pid":113621,"title":"Monika Mal","short_name":"M Mal","first_name":"Monika Mal","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":113632,"title":"Priti Mondal","short_name":"P Mondal","first_name":"Priti Mondal","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":113708,"title":"Piyali Ghosh","short_name":"P Ghosh","first_name":"Piyali Ghosh","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":"(C)"},{"pid":113717,"title":"Debalina Samantha","short_name":"D Samantha","first_name":"Debalina Samantha","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":113722,"title":"Payel Vakharia","short_name":"P Vakharia","first_name":"Payel Vakharia","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":113727,"title":"Bidisha Dey","short_name":"B Dey","first_name":"Bidisha Dey","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":113939,"title":"Sujata Dey","short_name":"S Dey","first_name":"Sujata Dey","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":""},{"pid":113940,"title":"Parama Mondal","short_name":"P Mondal","first_name":"Parama Mondal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":""},{"pid":122138,"title":"Adrija Sarkar","short_name":"A Sarkar","first_name":"Adrija Sarkar","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":122142,"title":"Ankita Mahanta","short_name":"A Mahanta","first_name":"Ankita Mahanta","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":140449,"title":"Sandipta Patra","short_name":"S Patra","first_name":"Sandipta Patra","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":140459,"title":"Shreetama Mali","short_name":"S Mali","first_name":"Shreetama Mali","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":140520,"title":"Prativa Mandi","short_name":"P Mandi","first_name":"Prativa Mandi","last_name":"","middle_name":"","birthdate":"2007-12-04","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":""},{"pid":140526,"title":"Iti Sarkar","short_name":"I Sarkar","first_name":"Iti Sarkar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":"(WK)"},{"pid":140536,"title":"Ekaa Roy Chowdhury","short_name":"E R Chowdhury","first_name":"Ekaa Roy Chowdhury","last_name":"","middle_name":"","birthdate":"2008-08-24","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":140545,"title":"Tanuja Sarkar","short_name":"T Sarkar","first_name":"Tanuja Sarkar","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":140546,"title":"Priti Mahato","short_name":"P Mahato","first_name":"Priti Mahato","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":""},{"pid":140547,"title":"Shreya Roy","short_name":"S Roy","first_name":"Shreya Roy","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":140548,"title":"Arpita Bhowmik","short_name":"A Bhowmik","first_name":"Arpita Bhowmik","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":149733,"title":"Jhilik Das","short_name":"J Das","first_name":"Jhilik Das","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":149734,"title":"Salma Khatoon","short_name":"S Khatoon","first_name":"Salma Khatoon","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":149735,"title":"Sangita Dutta","short_name":"S Dutta","first_name":"Sangita Dutta","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":149736,"title":"Koyel Sarkar","short_name":"K Sarkar","first_name":"Koyel Sarkar","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":149784,"title":"Sushmita Mondal","short_name":"S Mondal","first_name":"Sushmita Mondal","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":149785,"title":"Disha Gupta","short_name":"D Gupta","first_name":"Disha Gupta","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""}]},"etag":"3288a4fbfd23997c455df9e72cc1f882","modified":"2025-07-09 16:54:30","datetime":"2025-07-09 16:54:30","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":91046,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Match abondoned due to rain","day_remaining_over":"","team_batting":"Lux Shyam Kolkata Tigers Womens","team_bowling":"Shrachi Rarh Tigers Womens","live_inning_number":2,"live_score":{"runs":3,"overs":2,"wickets":1,"target":78,"runrate":1.5,"required_runrate":9.38},"commentary":1,"wagon":2,"batsmen":[{"name":"Ankita Mahanta","batsman_id":122142,"runs":2,"balls_faced":5,"fours":0,"sixes":0,"strike_rate":"40.00"},{"name":"Parna Paul","batsman_id":106003,"runs":1,"balls_faced":6,"fours":0,"sixes":0,"strike_rate":"16.67"}],"bowlers":[{"name":"Shreya Roy","bowler_id":140547,"overs":1,"runs_conceded":1,"wickets":0,"maidens":0,"econ":"1.00"}],"commentaries":[{"event_id":"12228982","event":"wicket","batsman_id":"106010","bowler_id":"113708","over":"0","ball":"1","score":"w","commentary":"Piyali Ghosh to Mita Paul, no run, b P Ghosh,","noball_dismissal":false,"text":"","timestamp":1750919443,"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":"106010","how_out":"b P Ghosh","batsman_runs":"0","batsman_balls":"1"},{"event_id":"12228994","event":"ball","batsman_id":"106003","bowler_id":"113708","over":"0","ball":"2","score":1,"commentary":"Piyali Ghosh to Parna Paul, 1 run,","noball_dismissal":false,"text":"","timestamp":1750919515,"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":"12228995","event":"ball","batsman_id":"122142","bowler_id":"113708","over":"0","ball":"3","score":0,"commentary":"Piyali Ghosh to Ankita Mahanta, no run,","noball_dismissal":false,"text":"","timestamp":1750919527,"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":"12228997","event":"ball","batsman_id":"122142","bowler_id":"113708","over":"0","ball":"4","score":0,"commentary":"Piyali Ghosh to Ankita Mahanta, no run,","noball_dismissal":false,"text":"","timestamp":1750919543,"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":"12229000","event":"ball","batsman_id":"122142","bowler_id":"113708","over":"0","ball":"5","score":1,"commentary":"Piyali Ghosh to Ankita Mahanta, 1 run,","noball_dismissal":false,"text":"","timestamp":1750919559,"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":"12229002","event":"ball","batsman_id":"106003","bowler_id":"113708","over":"0","ball":"6","score":0,"commentary":"Piyali Ghosh to Parna Paul, no run,","noball_dismissal":false,"text":"","timestamp":1750919652,"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":1,"runs":2,"score":"2\/1","bats":[{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":106003},{"runs":1,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":122142}],"bowls":[{"runs_conceded":2,"maidens":0,"wickets":1,"bowler_id":113708,"overs":1}],"commentary":"End of over 1 (2 runs), Lux Shyam Kolkata Tigers Womens 2\/1"},{"event_id":"12229007","event":"ball","batsman_id":"122142","bowler_id":"140547","over":"1","ball":"1","score":0,"commentary":"Shreya Roy to Ankita Mahanta, no run,","noball_dismissal":false,"text":"","timestamp":1750919678,"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":"12229008","event":"ball","batsman_id":"122142","bowler_id":"140547","over":"1","ball":"2","score":1,"commentary":"Shreya Roy to Ankita Mahanta, 1 run,","noball_dismissal":false,"text":"","timestamp":1750919741,"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":"12229012","event":"ball","batsman_id":"106003","bowler_id":"140547","over":"1","ball":"3","score":0,"commentary":"Shreya Roy to Parna Paul, no run,","noball_dismissal":false,"text":"","timestamp":1750919768,"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":"12229015","event":"ball","batsman_id":"106003","bowler_id":"140547","over":"1","ball":"4","score":0,"commentary":"Shreya Roy to Parna Paul, no run,","noball_dismissal":false,"text":"","timestamp":1750919800,"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":"12229018","event":"ball","batsman_id":"106003","bowler_id":"140547","over":"1","ball":"5","score":0,"commentary":"Shreya Roy to Parna Paul, no run,","noball_dismissal":false,"text":"","timestamp":1750919825,"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":"12229021","event":"ball","batsman_id":"106003","bowler_id":"140547","over":"1","ball":"6","score":0,"commentary":"Shreya Roy to Parna Paul, no run,","noball_dismissal":false,"text":"","timestamp":1750919816,"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":2,"runs":1,"score":"3\/1","bats":[{"runs":1,"balls_faced":6,"fours":0,"sixes":0,"batsman_id":106003},{"runs":2,"balls_faced":5,"fours":0,"sixes":0,"batsman_id":122142}],"bowls":[{"runs_conceded":1,"maidens":0,"wickets":0,"bowler_id":140547,"overs":1},{"runs_conceded":2,"maidens":0,"wickets":1,"bowler_id":113708,"overs":1}],"commentary":"End of over 2 (1 runs), Lux Shyam Kolkata Tigers Womens 3\/1"}],"day":"0","session":"0","live_inning":{"iid":198759,"number":2,"name":"Lux Shyam Kolkata Tigers Womens Inning","short_name":"LSKT-W Inning","status":4,"issuperover":"false","result":0,"batting_team_id":128521,"fielding_team_id":128525,"scores":"3\/1","scores_full":"3\/1 (2 ov)","fielder":[],"powerplay":{"p1":{"startover":"0.1","endover":"3"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Mita Paul","batsman_id":"106010","runs":"0","balls":"1","how_out":"b P Ghosh","score_at_dismissal":0,"overs_at_dismissal":"0.1","bowler_id":"113708","dismissal":"bowled","number":1},"extra_runs":{"byes":0,"legbyes":0,"wides":0,"noballs":0,"penalty":"0","total":0},"equations":{"runs":3,"wickets":1,"overs":"2","bowlers_used":2,"runrate":"1.50"},"current_partnership":{"runs":3,"balls":11,"overs":1.5,"batsmen":[{"name":"Parna Paul","batsman_id":106003,"runs":1,"balls":6},{"name":"Ankita Mahanta","batsman_id":122142,"runs":2,"balls":5}]},"did_not_bat":[{"player_id":"113598","name":"Puja Rajak"},{"player_id":"140545","name":"Tanuja Sarkar"},{"player_id":"140546","name":"Priti Mahato"},{"player_id":"113939","name":"Sujata Dey"},{"player_id":"113605","name":"Ritika Pal"},{"player_id":"140520","name":"Prativa Mandi"},{"player_id":"149734","name":"Salma Khatoon"},{"player_id":"113621","name":"Monika Mal"}],"max_over":"10","target":"78","recent_scores":"0,0,0,0,1,0,0,1,0,0,1,w","last_five_overs":"3\/1 1.50","last_ten_overs":"3\/1 1.50"},"teams":[{"tid":128521,"title":"Lux Shyam Kolkata Tigers Womens","abbr":"LSKT-W","alt_name":"Lux Shyam Kolkata Tigers Womens","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/06\/LSKTW.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/06\/LSKTW.png","country":"in","sex":"female","team_owner":"","head_coach":"","scores_full":"3\/1 (2 ov)","scores":"3\/1","overs":"2"},{"tid":128525,"title":"Shrachi Rarh Tigers Womens","abbr":"SRT-W","alt_name":"Shrachi Rarh Tigers Womens","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/06\/SRTW.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/06\/SRTW.png","country":"in","sex":"female","team_owner":"","head_coach":"","scores_full":"77\/6 (10 ov)","scores":"77\/6","overs":"10"}],"players":[{"pid":48100,"title":"Priya Pandey","short_name":"PB Pandey","first_name":"Priya Pandey","last_name":"","middle_name":"","birthdate":"1996-12-08","birthplace":"","country":"in","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":106003,"title":"Parna Paul","short_name":"P Paul","first_name":"Parna Paul","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","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":"India","role":"wk","role_str":"(WK)"},{"pid":106010,"title":"Mita Paul","short_name":"M Paul","first_name":"Mita Paul","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":"(C)"},{"pid":106011,"title":"Shreya Karar","short_name":"S Karar","first_name":"Shreya Karar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":112093,"title":"Sanshita Sumit Bishwas","short_name":"Sanshita Sumit Bishwas","first_name":"Sanshita Sumit Bishwas","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"wk","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":"India","role":"wk","role_str":""},{"pid":112101,"title":"Pampa Sarkar","short_name":"Pampa Sarkar","first_name":"Pampa Sarkar","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":113598,"title":"Puja Rajak","short_name":"P Rajak","first_name":"Puja Rajak","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":113599,"title":"Brishti Susanta Majhi","short_name":"B S Majhi","first_name":"Brishti Susanta Majhi","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":113605,"title":"Ritika Pal","short_name":"R Pal","first_name":"Ritika Pal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":""},{"pid":113621,"title":"Monika Mal","short_name":"M Mal","first_name":"Monika Mal","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":113632,"title":"Priti Mondal","short_name":"P Mondal","first_name":"Priti Mondal","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":113708,"title":"Piyali Ghosh","short_name":"P Ghosh","first_name":"Piyali Ghosh","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":"(C)"},{"pid":113717,"title":"Debalina Samantha","short_name":"D Samantha","first_name":"Debalina Samantha","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":113722,"title":"Payel Vakharia","short_name":"P Vakharia","first_name":"Payel Vakharia","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":113727,"title":"Bidisha Dey","short_name":"B Dey","first_name":"Bidisha Dey","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":113939,"title":"Sujata Dey","short_name":"S Dey","first_name":"Sujata Dey","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":""},{"pid":113940,"title":"Parama Mondal","short_name":"P Mondal","first_name":"Parama Mondal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":""},{"pid":122138,"title":"Adrija Sarkar","short_name":"A Sarkar","first_name":"Adrija Sarkar","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":122142,"title":"Ankita Mahanta","short_name":"A Mahanta","first_name":"Ankita Mahanta","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":140449,"title":"Sandipta Patra","short_name":"S Patra","first_name":"Sandipta Patra","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":140459,"title":"Shreetama Mali","short_name":"S Mali","first_name":"Shreetama Mali","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":140520,"title":"Prativa Mandi","short_name":"P Mandi","first_name":"Prativa Mandi","last_name":"","middle_name":"","birthdate":"2007-12-04","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":""},{"pid":140526,"title":"Iti Sarkar","short_name":"I Sarkar","first_name":"Iti Sarkar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":"(WK)"},{"pid":140536,"title":"Ekaa Roy Chowdhury","short_name":"E R Chowdhury","first_name":"Ekaa Roy Chowdhury","last_name":"","middle_name":"","birthdate":"2008-08-24","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":140545,"title":"Tanuja Sarkar","short_name":"T Sarkar","first_name":"Tanuja Sarkar","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":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":140546,"title":"Priti Mahato","short_name":"P Mahato","first_name":"Priti Mahato","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":""},{"pid":140547,"title":"Shreya Roy","short_name":"S Roy","first_name":"Shreya Roy","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":140548,"title":"Arpita Bhowmik","short_name":"A Bhowmik","first_name":"Arpita Bhowmik","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":149733,"title":"Jhilik Das","short_name":"J Das","first_name":"Jhilik Das","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":149734,"title":"Salma Khatoon","short_name":"S Khatoon","first_name":"Salma Khatoon","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":149735,"title":"Sangita Dutta","short_name":"S Dutta","first_name":"Sangita Dutta","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":149736,"title":"Koyel Sarkar","short_name":"K Sarkar","first_name":"Koyel Sarkar","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":149784,"title":"Sushmita Mondal","short_name":"S Mondal","first_name":"Sushmita Mondal","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":149785,"title":"Disha Gupta","short_name":"D Gupta","first_name":"Disha Gupta","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""}]},"etag":"3288a4fbfd23997c455df9e72cc1f882","modified":"2025-07-09 16:54:30","datetime":"2025-07-09 16:54:30","api_version":"3.0"}', Modified = GetDate() WHERE Id = 91046 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:b8dd6cfc-9c2e-411d-b61d-20089b57e147 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 91046 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (91046,3,'{"status":"ok","response":{"match_id":91046,"title":"Shrachi Rarh Tigers Womens vs Lux Shyam Kolkata Tigers Womens","short_title":"SRT-W vs LSKT-W","subtitle":"Match 28","match_number":"28","format":8,"format_str":"Women T20","status":2,"status_str":"Completed","status_note":"Match abondoned due to rain","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129614,"title":"Bengal Women''s Pro T20 League","abbr":"BWPT20","type":"tournament","category":"women","match_format":"woment20","season":"2025","status":"live","datestart":"2025-06-12","dateend":"2025-06-28","country":"in","total_matches":"31","total_rounds":"1","total_teams":"8"},"teama":{"team_id":128525,"name":"Shrachi Rarh Tigers Womens","short_name":"SRT-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/06\/SRTW.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/06\/SRTW.png","scores_full":"77\/6 (10 ov)","scores":"77\/6","overs":"10"},"teamb":{"team_id":128521,"name":"Lux Shyam Kolkata Tigers Womens","short_name":"LSKT-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/06\/LSKTW.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/06\/LSKTW.png","scores_full":"3\/1 (2 ov)","scores":"3\/1","overs":"2"},"date_start":"2025-06-26 03:30:00","date_end":"2025-06-26 13:30:00","timestamp_start":1750908600,"timestamp_end":1750944600,"date_start_ist":"2025-06-26 09:00:00","date_end_ist":"2025-06-26 19:00:00","venue":{"venue_id":"192","name":"Jadavpur University Campus 2nd Ground","location":"Kolkata","country":"India","timezone":""},"umpires":" Binita Roymoulick (India), Sujay Das (India), Koustab Das (India, TV)","referee":" Dattatreya Mukherjee (India)","equation":"Match abondoned due to rain","live":"","result":"Match abondoned due to rain","result_type":4,"win_margin":"","winning_team_id":0,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-25 10:43:52","verify_time":"2025-06-26 13:05:49","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"broken clouds","temp":28.92,"humidity":79,"visibility":10000,"wind_speed":"11.72","clouds":73},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Lux Shyam Kolkata Tigers Womens elected to bowl","winner":128521,"decision":2}},"etag":"ecb658834af8d2d5fa8d721b1b323f1d","modified":"2025-07-09 16:54:31","datetime":"2025-07-09 16:54:31","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":91046,"title":"Shrachi Rarh Tigers Womens vs Lux Shyam Kolkata Tigers Womens","short_title":"SRT-W vs LSKT-W","subtitle":"Match 28","match_number":"28","format":8,"format_str":"Women T20","status":2,"status_str":"Completed","status_note":"Match abondoned due to rain","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129614,"title":"Bengal Women''s Pro T20 League","abbr":"BWPT20","type":"tournament","category":"women","match_format":"woment20","season":"2025","status":"live","datestart":"2025-06-12","dateend":"2025-06-28","country":"in","total_matches":"31","total_rounds":"1","total_teams":"8"},"teama":{"team_id":128525,"name":"Shrachi Rarh Tigers Womens","short_name":"SRT-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/06\/SRTW.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/06\/SRTW.png","scores_full":"77\/6 (10 ov)","scores":"77\/6","overs":"10"},"teamb":{"team_id":128521,"name":"Lux Shyam Kolkata Tigers Womens","short_name":"LSKT-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/06\/LSKTW.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/06\/LSKTW.png","scores_full":"3\/1 (2 ov)","scores":"3\/1","overs":"2"},"date_start":"2025-06-26 03:30:00","date_end":"2025-06-26 13:30:00","timestamp_start":1750908600,"timestamp_end":1750944600,"date_start_ist":"2025-06-26 09:00:00","date_end_ist":"2025-06-26 19:00:00","venue":{"venue_id":"192","name":"Jadavpur University Campus 2nd Ground","location":"Kolkata","country":"India","timezone":""},"umpires":" Binita Roymoulick (India), Sujay Das (India), Koustab Das (India, TV)","referee":" Dattatreya Mukherjee (India)","equation":"Match abondoned due to rain","live":"","result":"Match abondoned due to rain","result_type":4,"win_margin":"","winning_team_id":0,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-25 10:43:52","verify_time":"2025-06-26 13:05:49","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"broken clouds","temp":28.92,"humidity":79,"visibility":10000,"wind_speed":"11.72","clouds":73},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Lux Shyam Kolkata Tigers Womens elected to bowl","winner":128521,"decision":2}},"etag":"ecb658834af8d2d5fa8d721b1b323f1d","modified":"2025-07-09 16:54:31","datetime":"2025-07-09 16:54:31","api_version":"3.0"}', Modified = GetDate() WHERE Id = 91046 AND DataTypeId = 3 END
Live Report & Scorecard of Shrachi Rarh Tigers Womens vs Lux Shyam Kolkata Tigers Womens Match 28