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:e94d8541-6d91-46a8-bb28-38e7ea71d498
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 91104 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (91104,1,'{"status":"ok","response":{"mid":91104,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"SKK-W won by 9 wickets","day_remaining_over":"","team_batting":"SKK-W","team_bowling":"PCS-W","live_inning_number":2,"live_score":{"runs":20,"overs":1.1,"wickets":1,"target":20,"runrate":17.14,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Smita Kariwadekar","batsman_id":150209,"runs":5,"balls_faced":3,"fours":1,"sixes":0,"strike_rate":"166.67"},{"name":"Divija Unhale","batsman_id":130616,"runs":7,"balls_faced":5,"fours":1,"sixes":0,"strike_rate":"140.00"}],"bowlers":[{"name":"Geethma Madanayake","bowler_id":130683,"overs":0.1,"runs_conceded":1,"wickets":0,"maidens":0,"econ":"6.00"}],"commentaries":[{"event_id":"12245086","event":"ball","batsman_id":"130616","bowler_id":"139831","over":"0","ball":"1","score":1,"commentary":"Chamali Lokuge to Divija Unhale, 1 run,","noball_dismissal":false,"text":"","timestamp":1751194405,"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":"12245088","event":"ball","batsman_id":"150210","bowler_id":"139831","over":"0","ball":"2","score":4,"commentary":"Chamali Lokuge to Subhashree Rautray, Four,","noball_dismissal":false,"text":"","timestamp":1751194423,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12245101","event":"ball","batsman_id":"150210","bowler_id":"139831","over":"0","ball":"3","score":1,"commentary":"Chamali Lokuge to Subhashree Rautray, 1 run,","noball_dismissal":false,"text":"","timestamp":1751194686,"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":"12245143","event":"wicket","batsman_id":"130616","bowler_id":"139831","over":"0","ball":"4","score":"w","commentary":"Chamali Lokuge to Divija Unhale, 1 no ball, runout (L Wallenius),","noball_dismissal":true,"text":"","timestamp":1751194692,"run":1,"noball_run":"1","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":true,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"150210","how_out":"runout (L Wallenius)","batsman_runs":"5","batsman_balls":"2"},{"event_id":"12245155","event":"ball","batsman_id":"150209","bowler_id":"139831","over":"0","ball":"4","score":"1nb","commentary":"Chamali Lokuge to Smita Kariwadekar, 1 no ball,","noball_dismissal":false,"text":"","timestamp":1751194696,"run":1,"noball_run":"1","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":true,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12245160","event":"ball","batsman_id":"150209","bowler_id":"139831","over":"0","ball":"4","score":4,"commentary":"Chamali Lokuge to Smita Kariwadekar, Four,","noball_dismissal":false,"text":"","timestamp":1751194700,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12245163","event":"ball","batsman_id":"150209","bowler_id":"139831","over":"0","ball":"5","score":1,"commentary":"Chamali Lokuge to Smita Kariwadekar, 1 run,","noball_dismissal":false,"text":"","timestamp":1751194704,"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":"12245170","event":"ball","batsman_id":"130616","bowler_id":"139831","over":"0","ball":"6","score":"5nb","commentary":"Chamali Lokuge to Divija Unhale, 5 no ball,","noball_dismissal":false,"text":"","timestamp":1751194707,"run":5,"noball_run":"1","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":true,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12245188","event":"ball","batsman_id":"130616","bowler_id":"139831","over":"0","ball":"6","score":1,"commentary":"Chamali Lokuge to Divija Unhale, 1 run,","noball_dismissal":false,"text":"","timestamp":1751194753,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":1,"runs":19,"score":"19\/1","bats":[{"runs":6,"balls_faced":4,"fours":1,"sixes":0,"batsman_id":130616},{"runs":5,"balls_faced":3,"fours":1,"sixes":0,"batsman_id":150209}],"bowls":[{"runs_conceded":19,"maidens":0,"wickets":0,"bowler_id":139831,"overs":1}],"commentary":"End of over 1 (19 runs), SKK-W 19\/1"},{"event_id":"12245202","event":"ball","batsman_id":"130616","bowler_id":"130683","over":"1","ball":"1","score":1,"commentary":"Geethma Madanayake to Divija Unhale, 1 run,","noball_dismissal":false,"text":"","timestamp":1751194756,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false}],"day":"0","session":"0","live_inning":{"iid":198914,"number":2,"name":"SKK-W Inning","short_name":"SKK-W Inning","status":2,"issuperover":"false","result":3,"batting_team_id":129014,"fielding_team_id":129015,"scores":"20\/1","scores_full":"20\/1 (1.1 ov)","fielder":[{"fielder_id":"150222","fielder_name":"Laura Wallenius","catches":0,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":1,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"1"}},"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":"Subhashree Rautray","batsman_id":"150210","runs":"5","balls":"2","how_out":"runout (L Wallenius)","score_at_dismissal":12,"overs_at_dismissal":"0.4","bowler_id":"0","dismissal":"runout","number":1},"extra_runs":{"byes":0,"legbyes":0,"wides":0,"noballs":3,"penalty":"0","total":3},"equations":{"runs":20,"wickets":1,"overs":"1.1","bowlers_used":2,"runrate":"17.14"},"current_partnership":{"runs":13,"balls":6,"overs":1,"batsmen":[{"name":"Smita Kariwadekar","batsman_id":150209,"runs":5,"balls":3},{"name":"Divija Unhale","batsman_id":130616,"runs":6,"balls":3}]},"did_not_bat":[{"player_id":"150206","name":"Leah Martin"},{"player_id":"150207","name":"Malyun Hassan"},{"player_id":"130629","name":"Mahulima Mukherjee"},{"player_id":"150211","name":"Abinaya Shanmuganathan"},{"player_id":"150213","name":"Mari Kojo"},{"player_id":"150288","name":"Anjalika Jonse"},{"player_id":"150215","name":"Saun Shah"},{"player_id":"130620","name":"Chihan Lay"}],"max_over":"3","target":"20","recent_scores":"1,1,5,1,4,1,1,1,4,1","last_five_overs":"20\/1 12.00","last_ten_overs":"20\/1 12.00"},"teams":[{"tid":129014,"title":"SKK-W","abbr":"SKK-W","alt_name":"SKK-W","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/SKK-W.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/SKK-W.png","country":"fi","sex":"female","team_owner":"","head_coach":"","scores_full":"20\/1 (1.1 ov)","scores":"20\/1","overs":"1.1"},{"tid":129015,"title":"PCS-W","abbr":"PCS-W","alt_name":"PCS-W","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/PCS-W.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/PCS-W.png","country":"fi","sex":"female","team_owner":"","head_coach":"","scores_full":"19\/2 (3 ov)","scores":"19\/2","overs":"3"}],"players":[{"pid":130616,"title":"Divija Unhale","short_name":"D Unhale","first_name":"Divija Unhale","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"fi","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":"Finland","role":"bat","role_str":""},{"pid":130617,"title":"Deep Prabha Dash","short_name":"DP Dash","first_name":"Deep Prabha Dash","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"fi","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":"Finland","role":"squad","role_str":""},{"pid":130620,"title":"Chihan Lay","short_name":"C Lay","first_name":"Chihan Lay","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"fi","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":"Finland","role":"bowl","role_str":""},{"pid":130621,"title":"Thanojiga Thavogarajah","short_name":"T Thavogarajah","first_name":"Thanojiga Thavogarajah","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"fi","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":"Finland","role":"squad","role_str":""},{"pid":130622,"title":"Puja Gangrude","short_name":"P Gangrude","first_name":"Puja Gangrude","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"fi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Finland","role":"bowl","role_str":""},{"pid":130629,"title":"Mahulima Mukherjee","short_name":"M Mukherjee","first_name":"Mahulima Mukherjee","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"fi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Finland","role":"all","role_str":""},{"pid":130683,"title":"Geethma Madanayake","short_name":"G Madanayake","first_name":"Geethma Madanayake","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ee","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":"Estonia","role":"bowl","role_str":""},{"pid":133830,"title":"Beenish Wani","short_name":"B Wani","first_name":"Beenish Wani","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","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":"International","role":"all","role_str":""},{"pid":139831,"title":"Chamali Lokuge","short_name":"C Lokuge","first_name":"Chamali Lokuge","last_name":"","middle_name":"","birthdate":"1989-01-18","birthplace":"","country":"ee","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Estonia","role":"bowl","role_str":""},{"pid":150206,"title":"Leah Martin","short_name":"L Martin","first_name":"Leah Martin","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"fi","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":"Finland","role":"wk","role_str":"(WK)"},{"pid":150207,"title":"Malyun Hassan","short_name":"M Hassan","first_name":"Malyun Hassan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"fi","primary_team":[],"logo_url":"","playing_role":"bat","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":"Finland","role":"bat","role_str":"(C)"},{"pid":150208,"title":"Shamane Jayarathne","short_name":"S Jayarathne","first_name":"Shamane Jayarathne","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"lk","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Sri Lanka","role":"squad","role_str":""},{"pid":150209,"title":"Smita Kariwadekar","short_name":"S Kariwadekar","first_name":"Smita Kariwadekar","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":150210,"title":"Subhashree Rautray","short_name":"S Rautray","first_name":"Subhashree Rautray","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":150211,"title":"Abinaya Shanmuganathan","short_name":"A Shanmuganathan","first_name":"Abinaya Shanmuganathan","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":150212,"title":"Sneha Saj","short_name":"S Saj","first_name":"Sneha Saj","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":"squad","role_str":""},{"pid":150213,"title":"Mari Kojo","short_name":"M Kojo","first_name":"Mari Kojo","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"fi","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":"Finland","role":"all","role_str":""},{"pid":150214,"title":"Kusum Wadhwani","short_name":"K Wadhwani","first_name":"Kusum Wadhwani","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":150215,"title":"Saun Shah","short_name":"S Shah","first_name":"Saun Shah","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":"bowl","role_str":""},{"pid":150216,"title":"Pranjali Deshmukh","short_name":"P Deshmukh","first_name":"Pranjali Deshmukh","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ee","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Estonia","role":"all","role_str":""},{"pid":150217,"title":"Aryaa Kulkarni","short_name":"A Kulkarni","first_name":"Aryaa Kulkarni","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":150218,"title":"Nisha Kulkarni","short_name":"N Kulkarni","first_name":"Nisha Kulkarni","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":"squad","role_str":""},{"pid":150219,"title":"Heidi Posti","short_name":"H Posti","first_name":"Heidi Posti","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"fi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Finland","role":"all","role_str":""},{"pid":150220,"title":"Minna Stolt","short_name":"M Stolt","first_name":"Minna Stolt","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"fi","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":"Finland","role":"wk","role_str":"(C)"},{"pid":150221,"title":"Sara Tanner","short_name":"S Tanner","first_name":"Sara Tanner","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"fi","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":"Finland","role":"bat","role_str":""},{"pid":150222,"title":"Laura Wallenius","short_name":"L Wallenius","first_name":"Laura Wallenius","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"fi","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":"Finland","role":"wk","role_str":"(WK)"},{"pid":150223,"title":"Maija Hyotylainen","short_name":"M Hyotylainen","first_name":"Maija Hyotylainen","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"fi","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":"Finland","role":"squad","role_str":""},{"pid":150224,"title":"Tina Leskinen","short_name":"T Leskinen","first_name":"Tina Leskinen","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"fi","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":"Finland","role":"bat","role_str":""},{"pid":150288,"title":"Anjalika Jonse","short_name":"A Jonse","first_name":"Anjalika Jonse","last_name":"","middle_name":"","birthdate":"2000-05-03","birthplace":"","country":"lk","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":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Sri Lanka","role":"bowl","role_str":""}]},"etag":"45e3cdeed55c27a70ab354d1895ba90a","modified":"2025-07-06 12:12:54","datetime":"2025-07-06 12:12:54","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":91104,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"SKK-W won by 9 wickets","day_remaining_over":"","team_batting":"SKK-W","team_bowling":"PCS-W","live_inning_number":2,"live_score":{"runs":20,"overs":1.1,"wickets":1,"target":20,"runrate":17.14,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Smita Kariwadekar","batsman_id":150209,"runs":5,"balls_faced":3,"fours":1,"sixes":0,"strike_rate":"166.67"},{"name":"Divija Unhale","batsman_id":130616,"runs":7,"balls_faced":5,"fours":1,"sixes":0,"strike_rate":"140.00"}],"bowlers":[{"name":"Geethma Madanayake","bowler_id":130683,"overs":0.1,"runs_conceded":1,"wickets":0,"maidens":0,"econ":"6.00"}],"commentaries":[{"event_id":"12245086","event":"ball","batsman_id":"130616","bowler_id":"139831","over":"0","ball":"1","score":1,"commentary":"Chamali Lokuge to Divija Unhale, 1 run,","noball_dismissal":false,"text":"","timestamp":1751194405,"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":"12245088","event":"ball","batsman_id":"150210","bowler_id":"139831","over":"0","ball":"2","score":4,"commentary":"Chamali Lokuge to Subhashree Rautray, Four,","noball_dismissal":false,"text":"","timestamp":1751194423,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12245101","event":"ball","batsman_id":"150210","bowler_id":"139831","over":"0","ball":"3","score":1,"commentary":"Chamali Lokuge to Subhashree Rautray, 1 run,","noball_dismissal":false,"text":"","timestamp":1751194686,"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":"12245143","event":"wicket","batsman_id":"130616","bowler_id":"139831","over":"0","ball":"4","score":"w","commentary":"Chamali Lokuge to Divija Unhale, 1 no ball, runout (L Wallenius),","noball_dismissal":true,"text":"","timestamp":1751194692,"run":1,"noball_run":"1","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":true,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"150210","how_out":"runout (L Wallenius)","batsman_runs":"5","batsman_balls":"2"},{"event_id":"12245155","event":"ball","batsman_id":"150209","bowler_id":"139831","over":"0","ball":"4","score":"1nb","commentary":"Chamali Lokuge to Smita Kariwadekar, 1 no ball,","noball_dismissal":false,"text":"","timestamp":1751194696,"run":1,"noball_run":"1","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":true,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12245160","event":"ball","batsman_id":"150209","bowler_id":"139831","over":"0","ball":"4","score":4,"commentary":"Chamali Lokuge to Smita Kariwadekar, Four,","noball_dismissal":false,"text":"","timestamp":1751194700,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12245163","event":"ball","batsman_id":"150209","bowler_id":"139831","over":"0","ball":"5","score":1,"commentary":"Chamali Lokuge to Smita Kariwadekar, 1 run,","noball_dismissal":false,"text":"","timestamp":1751194704,"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":"12245170","event":"ball","batsman_id":"130616","bowler_id":"139831","over":"0","ball":"6","score":"5nb","commentary":"Chamali Lokuge to Divija Unhale, 5 no ball,","noball_dismissal":false,"text":"","timestamp":1751194707,"run":5,"noball_run":"1","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":true,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12245188","event":"ball","batsman_id":"130616","bowler_id":"139831","over":"0","ball":"6","score":1,"commentary":"Chamali Lokuge to Divija Unhale, 1 run,","noball_dismissal":false,"text":"","timestamp":1751194753,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":1,"runs":19,"score":"19\/1","bats":[{"runs":6,"balls_faced":4,"fours":1,"sixes":0,"batsman_id":130616},{"runs":5,"balls_faced":3,"fours":1,"sixes":0,"batsman_id":150209}],"bowls":[{"runs_conceded":19,"maidens":0,"wickets":0,"bowler_id":139831,"overs":1}],"commentary":"End of over 1 (19 runs), SKK-W 19\/1"},{"event_id":"12245202","event":"ball","batsman_id":"130616","bowler_id":"130683","over":"1","ball":"1","score":1,"commentary":"Geethma Madanayake to Divija Unhale, 1 run,","noball_dismissal":false,"text":"","timestamp":1751194756,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false}],"day":"0","session":"0","live_inning":{"iid":198914,"number":2,"name":"SKK-W Inning","short_name":"SKK-W Inning","status":2,"issuperover":"false","result":3,"batting_team_id":129014,"fielding_team_id":129015,"scores":"20\/1","scores_full":"20\/1 (1.1 ov)","fielder":[{"fielder_id":"150222","fielder_name":"Laura Wallenius","catches":0,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":1,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"1"}},"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":"Subhashree Rautray","batsman_id":"150210","runs":"5","balls":"2","how_out":"runout (L Wallenius)","score_at_dismissal":12,"overs_at_dismissal":"0.4","bowler_id":"0","dismissal":"runout","number":1},"extra_runs":{"byes":0,"legbyes":0,"wides":0,"noballs":3,"penalty":"0","total":3},"equations":{"runs":20,"wickets":1,"overs":"1.1","bowlers_used":2,"runrate":"17.14"},"current_partnership":{"runs":13,"balls":6,"overs":1,"batsmen":[{"name":"Smita Kariwadekar","batsman_id":150209,"runs":5,"balls":3},{"name":"Divija Unhale","batsman_id":130616,"runs":6,"balls":3}]},"did_not_bat":[{"player_id":"150206","name":"Leah Martin"},{"player_id":"150207","name":"Malyun Hassan"},{"player_id":"130629","name":"Mahulima Mukherjee"},{"player_id":"150211","name":"Abinaya Shanmuganathan"},{"player_id":"150213","name":"Mari Kojo"},{"player_id":"150288","name":"Anjalika Jonse"},{"player_id":"150215","name":"Saun Shah"},{"player_id":"130620","name":"Chihan Lay"}],"max_over":"3","target":"20","recent_scores":"1,1,5,1,4,1,1,1,4,1","last_five_overs":"20\/1 12.00","last_ten_overs":"20\/1 12.00"},"teams":[{"tid":129014,"title":"SKK-W","abbr":"SKK-W","alt_name":"SKK-W","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/SKK-W.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/SKK-W.png","country":"fi","sex":"female","team_owner":"","head_coach":"","scores_full":"20\/1 (1.1 ov)","scores":"20\/1","overs":"1.1"},{"tid":129015,"title":"PCS-W","abbr":"PCS-W","alt_name":"PCS-W","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/PCS-W.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/PCS-W.png","country":"fi","sex":"female","team_owner":"","head_coach":"","scores_full":"19\/2 (3 ov)","scores":"19\/2","overs":"3"}],"players":[{"pid":130616,"title":"Divija Unhale","short_name":"D Unhale","first_name":"Divija Unhale","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"fi","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":"Finland","role":"bat","role_str":""},{"pid":130617,"title":"Deep Prabha Dash","short_name":"DP Dash","first_name":"Deep Prabha Dash","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"fi","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":"Finland","role":"squad","role_str":""},{"pid":130620,"title":"Chihan Lay","short_name":"C Lay","first_name":"Chihan Lay","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"fi","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":"Finland","role":"bowl","role_str":""},{"pid":130621,"title":"Thanojiga Thavogarajah","short_name":"T Thavogarajah","first_name":"Thanojiga Thavogarajah","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"fi","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":"Finland","role":"squad","role_str":""},{"pid":130622,"title":"Puja Gangrude","short_name":"P Gangrude","first_name":"Puja Gangrude","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"fi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Finland","role":"bowl","role_str":""},{"pid":130629,"title":"Mahulima Mukherjee","short_name":"M Mukherjee","first_name":"Mahulima Mukherjee","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"fi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Finland","role":"all","role_str":""},{"pid":130683,"title":"Geethma Madanayake","short_name":"G Madanayake","first_name":"Geethma Madanayake","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ee","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":"Estonia","role":"bowl","role_str":""},{"pid":133830,"title":"Beenish Wani","short_name":"B Wani","first_name":"Beenish Wani","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","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":"International","role":"all","role_str":""},{"pid":139831,"title":"Chamali Lokuge","short_name":"C Lokuge","first_name":"Chamali Lokuge","last_name":"","middle_name":"","birthdate":"1989-01-18","birthplace":"","country":"ee","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Estonia","role":"bowl","role_str":""},{"pid":150206,"title":"Leah Martin","short_name":"L Martin","first_name":"Leah Martin","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"fi","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":"Finland","role":"wk","role_str":"(WK)"},{"pid":150207,"title":"Malyun Hassan","short_name":"M Hassan","first_name":"Malyun Hassan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"fi","primary_team":[],"logo_url":"","playing_role":"bat","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":"Finland","role":"bat","role_str":"(C)"},{"pid":150208,"title":"Shamane Jayarathne","short_name":"S Jayarathne","first_name":"Shamane Jayarathne","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"lk","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Sri Lanka","role":"squad","role_str":""},{"pid":150209,"title":"Smita Kariwadekar","short_name":"S Kariwadekar","first_name":"Smita Kariwadekar","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":150210,"title":"Subhashree Rautray","short_name":"S Rautray","first_name":"Subhashree Rautray","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":150211,"title":"Abinaya Shanmuganathan","short_name":"A Shanmuganathan","first_name":"Abinaya Shanmuganathan","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":150212,"title":"Sneha Saj","short_name":"S Saj","first_name":"Sneha Saj","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":"squad","role_str":""},{"pid":150213,"title":"Mari Kojo","short_name":"M Kojo","first_name":"Mari Kojo","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"fi","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":"Finland","role":"all","role_str":""},{"pid":150214,"title":"Kusum Wadhwani","short_name":"K Wadhwani","first_name":"Kusum Wadhwani","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,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":150215,"title":"Saun Shah","short_name":"S Shah","first_name":"Saun Shah","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":"bowl","role_str":""},{"pid":150216,"title":"Pranjali Deshmukh","short_name":"P Deshmukh","first_name":"Pranjali Deshmukh","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ee","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Estonia","role":"all","role_str":""},{"pid":150217,"title":"Aryaa Kulkarni","short_name":"A Kulkarni","first_name":"Aryaa Kulkarni","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":150218,"title":"Nisha Kulkarni","short_name":"N Kulkarni","first_name":"Nisha Kulkarni","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":"squad","role_str":""},{"pid":150219,"title":"Heidi Posti","short_name":"H Posti","first_name":"Heidi Posti","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"fi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Finland","role":"all","role_str":""},{"pid":150220,"title":"Minna Stolt","short_name":"M Stolt","first_name":"Minna Stolt","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"fi","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":"Finland","role":"wk","role_str":"(C)"},{"pid":150221,"title":"Sara Tanner","short_name":"S Tanner","first_name":"Sara Tanner","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"fi","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":"Finland","role":"bat","role_str":""},{"pid":150222,"title":"Laura Wallenius","short_name":"L Wallenius","first_name":"Laura Wallenius","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"fi","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":"Finland","role":"wk","role_str":"(WK)"},{"pid":150223,"title":"Maija Hyotylainen","short_name":"M Hyotylainen","first_name":"Maija Hyotylainen","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"fi","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":"Finland","role":"squad","role_str":""},{"pid":150224,"title":"Tina Leskinen","short_name":"T Leskinen","first_name":"Tina Leskinen","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"fi","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":"Finland","role":"bat","role_str":""},{"pid":150288,"title":"Anjalika Jonse","short_name":"A Jonse","first_name":"Anjalika Jonse","last_name":"","middle_name":"","birthdate":"2000-05-03","birthplace":"","country":"lk","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":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Sri Lanka","role":"bowl","role_str":""}]},"etag":"45e3cdeed55c27a70ab354d1895ba90a","modified":"2025-07-06 12:12:54","datetime":"2025-07-06 12:12:54","api_version":"3.0"}', Modified = GetDate() WHERE Id = 91104 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:e94d8541-6d91-46a8-bb28-38e7ea71d498
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 91104 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (91104,3,'{"status":"ok","response":{"match_id":91104,"title":"SKK-W vs PCS-W","short_title":"SKK-W vs PCS-W","subtitle":"1st Semi Final ","match_number":"7","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"SKK-W won by 9 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129653,"title":"ECS-W Finland T10","abbr":"ECS-W Finland T10","type":"tournament","category":"women","match_format":"t10","season":"2025","status":"live","datestart":"2025-06-28","dateend":"2025-06-29","country":"fi","total_matches":"9","total_rounds":"1","total_teams":"4"},"teama":{"team_id":129014,"name":"SKK-W","short_name":"SKK-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/SKK-W.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/SKK-W.png","scores_full":"20\/1 (1.1 ov)","scores":"20\/1","overs":"1.1"},"teamb":{"team_id":129015,"name":"PCS-W","short_name":"PCS-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/PCS-W.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/PCS-W.png","scores_full":"19\/2 (3 ov)","scores":"19\/2","overs":"3"},"date_start":"2025-06-29 09:15:00","date_end":"2025-06-29 19:15:00","timestamp_start":1751188500,"timestamp_end":1751224500,"date_start_ist":"2025-06-29 14:45:00","date_end_ist":"2025-06-30 00:45:00","venue":{"venue_id":"365","name":"Kerava National Cricket Ground","location":"Kerava","country":"Finland","timezone":""},"umpires":"Suranga Perera (Sri Lanka), Subhadyuti Sahoo (India), Senthilraja Diraviam (India, TV)","referee":"Suleman Saeed (Pakistan)","equation":"","live":"","result":"SKK-W won by 9 wickets","result_type":1,"win_margin":"9 wickets","winning_team_id":129014,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-29 13:32:26","verify_time":"2025-06-29 16:45:28","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":17.87,"humidity":71,"visibility":6927,"wind_speed":"12.39","clouds":93},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"SKK-W elected to bowl","winner":129014,"decision":2}},"etag":"4b712997ceebc19af8672457258ee897","modified":"2025-07-06 12:12:55","datetime":"2025-07-06 12:12:55","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":91104,"title":"SKK-W vs PCS-W","short_title":"SKK-W vs PCS-W","subtitle":"1st Semi Final ","match_number":"7","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"SKK-W won by 9 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129653,"title":"ECS-W Finland T10","abbr":"ECS-W Finland T10","type":"tournament","category":"women","match_format":"t10","season":"2025","status":"live","datestart":"2025-06-28","dateend":"2025-06-29","country":"fi","total_matches":"9","total_rounds":"1","total_teams":"4"},"teama":{"team_id":129014,"name":"SKK-W","short_name":"SKK-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/SKK-W.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/SKK-W.png","scores_full":"20\/1 (1.1 ov)","scores":"20\/1","overs":"1.1"},"teamb":{"team_id":129015,"name":"PCS-W","short_name":"PCS-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/PCS-W.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/PCS-W.png","scores_full":"19\/2 (3 ov)","scores":"19\/2","overs":"3"},"date_start":"2025-06-29 09:15:00","date_end":"2025-06-29 19:15:00","timestamp_start":1751188500,"timestamp_end":1751224500,"date_start_ist":"2025-06-29 14:45:00","date_end_ist":"2025-06-30 00:45:00","venue":{"venue_id":"365","name":"Kerava National Cricket Ground","location":"Kerava","country":"Finland","timezone":""},"umpires":"Suranga Perera (Sri Lanka), Subhadyuti Sahoo (India), Senthilraja Diraviam (India, TV)","referee":"Suleman Saeed (Pakistan)","equation":"","live":"","result":"SKK-W won by 9 wickets","result_type":1,"win_margin":"9 wickets","winning_team_id":129014,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-29 13:32:26","verify_time":"2025-06-29 16:45:28","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":17.87,"humidity":71,"visibility":6927,"wind_speed":"12.39","clouds":93},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"SKK-W elected to bowl","winner":129014,"decision":2}},"etag":"4b712997ceebc19af8672457258ee897","modified":"2025-07-06 12:12:55","datetime":"2025-07-06 12:12:55","api_version":"3.0"}', Modified = GetDate() WHERE Id = 91104 AND DataTypeId = 3 END Live Report & Scorecard of SKK-W vs PCS-W 1st Semi Final
SKK-W vs PCS-W, Live Cricket Commentary