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:f8e94000-f174-4a12-8389-08eadb27374f Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 89810 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (89810,1,'{"status":"ok","response":{"mid":89810,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Dragons Women won by 274 runs","day_remaining_over":"","team_batting":"Scorchers Women","team_bowling":"Dragons Women","live_inning_number":2,"live_score":{"runs":72,"overs":21.3,"wickets":10,"target":347,"runrate":3.35,"required_runrate":9.65},"commentary":2,"wagon":2,"batsmen":[],"bowlers":[],"commentaries":[],"day":"0","session":"0","live_inning":{"iid":198338,"number":2,"name":"Scorchers Women Inning","short_name":"SCO-W Inning","status":2,"issuperover":"false","result":1,"batting_team_id":116365,"fielding_team_id":124475,"scores":"72\/10","scores_full":"72\/10 (21.3 ov)","fielder":[{"fielder_id":"93779","fielder_name":"Cara Murray","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"101754","fielder_name":"Amy Hunter","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"101750","fielder_name":"Alana Dalzell","catches":0,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":1,"stumping":0,"is_substitute":"false"},{"fielder_id":"46732","fielder_name":"Arlene Kelly","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"115745","fielder_name":"Kia Mccartney","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":[],"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Lucy Barry","batsman_id":"148755","runs":"1","balls":"8","how_out":"c K Mccartney b A Dalzell","score_at_dismissal":72,"overs_at_dismissal":"21.3","bowler_id":"101750","dismissal":"caught","number":10},"extra_runs":{"byes":0,"legbyes":0,"wides":15,"noballs":0,"penalty":"0","total":15},"equations":{"runs":72,"wickets":10,"overs":"21.3","bowlers_used":4,"runrate":"3.35"},"current_partnership":[],"did_not_bat":[{"player_id":"118972","name":"Sibha Bhoja"}],"max_over":"50","target":"347","recent_scores":[],"last_five_overs":[],"last_ten_overs":[]},"teams":[{"tid":116365,"title":"Scorchers Women","abbr":"SCO-W","alt_name":"SCO-W","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/06\/Rectangle-3348-40.jpg","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/06\/Rectangle-3348-40.jpg","country":"ie","sex":"female","team_owner":"","head_coach":"","scores_full":"72\/10 (21.3 ov)","scores":"72\/10","overs":"21.3"},{"tid":124475,"title":"Dragons Women","abbr":"DG-W","alt_name":"Dragons Women","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-DRAW@2x.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-DRAW@2x.png","country":"ie","sex":"female","team_owner":"","head_coach":"","scores_full":"346\/6 (50 ov)","scores":"346\/6","overs":"50"}],"players":[{"pid":44510,"title":"Gaby Lewis","short_name":"GH Lewis","first_name":"Gaby Lewis","last_name":"","middle_name":"","birthdate":"2001-03-27","birthplace":"Dublin, Ireland","country":"ie","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/gaby.lewis.96\/","twitter_profile":"https:\/\/twitter.com\/lewis_gaby","instagram_profile":"https:\/\/www.instagram.com\/gabylewis22\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bat","role_str":""},{"pid":46732,"title":"Arlene Kelly","short_name":"Al Kelly","first_name":"Arlene Kelly","last_name":"","middle_name":"","birthdate":"1994-01-08","birthplace":"Auckland","country":"ie","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/arleeene.kelly\/","twitter_profile":"https:\/\/twitter.com\/arlene151k","instagram_profile":"https:\/\/www.instagram.com\/arlenenkelly\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"all","role_str":""},{"pid":46758,"title":"Eimear Richardson","short_name":"EAJ Richardson","first_name":"Eimear Richardson","last_name":"","middle_name":"","birthdate":"1986-09-14","birthplace":"Dublin","country":"ie","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"all","role_str":""},{"pid":46826,"title":"Bella Armstrong","short_name":"BG Armstrong","first_name":"Bella Armstrong","last_name":"","middle_name":"","birthdate":"1999-11-16","birthplace":"","country":"nz","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bat","role_str":""},{"pid":90860,"title":"Sophie MacMahon","short_name":"S MacMahon","first_name":"Sophie MacMahon","last_name":"","middle_name":"","birthdate":"1997-01-29","birthplace":"Dublin","country":"ie","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"https:\/\/www.facebook.com\/sophie.macmahon.1\/","twitter_profile":"https:\/\/twitter.com\/SophieMacMahon\/media","instagram_profile":"https:\/\/www.instagram.com\/sophiemacmahon\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"all","role_str":""},{"pid":90861,"title":"Louise Little","short_name":"L Little","first_name":"Louise Little","last_name":"","middle_name":"","birthdate":"2003-05-16","birthplace":"Dublin","country":"ie","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bat","role_str":""},{"pid":93779,"title":"Cara Murray","short_name":"C Murray","first_name":"Cara Murray","last_name":"","middle_name":"","birthdate":"2000-11-01","birthplace":"Belfast, Co Antrim","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/cmurray212","instagram_profile":"https:\/\/www.instagram.com\/caracmurray\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bowl","role_str":""},{"pid":93792,"title":"Orla Prendergast","short_name":"O Prendergast","first_name":"Orla Prendergast","last_name":"","middle_name":"","birthdate":"2002-06-01","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/orla.prendergast.5\/","twitter_profile":"https:\/\/twitter.com\/prendergastorla","instagram_profile":"https:\/\/www.instagram.com\/orla_prendergast_\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"all","role_str":""},{"pid":94428,"title":"Claudia Lauren Green","short_name":"CL Green","first_name":"Claudia Lauren Green","last_name":"","middle_name":"","birthdate":"1997-12-06","birthplace":"","country":"nz","primary_team":[],"logo_url":"","playing_role":"wk","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":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"squad","role_str":""},{"pid":101750,"title":"Alana Dalzell","short_name":"A Dalzell","first_name":"Alana Dalzell","last_name":"","middle_name":"","birthdate":"2001-03-26","birthplace":"Londonderry","country":"ie","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bowl","role_str":""},{"pid":101754,"title":"Amy Hunter","short_name":"A Hunter","first_name":"Amy Hunter","last_name":"","middle_name":"","birthdate":"2005-10-11","birthplace":"Belfast","country":"ie","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/AmyHunter54","instagram_profile":"https:\/\/www.instagram.com\/amy_c_hunter\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"wk","role_str":"(WK\/C)"},{"pid":101760,"title":"Ava Canning","short_name":"A Canning","first_name":"Ava Canning","last_name":"","middle_name":"","birthdate":"2004-02-02","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/ava.canning\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/canning579\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bowl","role_str":""},{"pid":107565,"title":"Christina Coulter Reilly","short_name":"C Reilly","first_name":"Christina Coulter Reilly","last_name":"","middle_name":"","birthdate":"2003-08-17","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"wk","role_str":"(WK)"},{"pid":115632,"title":"Lara McBride","short_name":"Lara McBride","first_name":"Lara McBride","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"all","role_str":""},{"pid":115635,"title":"Aimee Maguire","short_name":"A Maguire","first_name":"Aimee Maguire","last_name":"","middle_name":"","birthdate":"2006-09-09","birthplace":"Dublin, Ireland","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":115740,"title":"Abbi Harrison","short_name":"A Harison","first_name":"Abbi Harrison","last_name":"","middle_name":"","birthdate":"2006-08-08","birthplace":"Craigavon","country":"ie","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"wk","role_str":""},{"pid":115743,"title":"Mollie Devine","short_name":"M Devine","first_name":"Mollie Devine","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":115745,"title":"Kia Mccartney","short_name":"K Mccartney","first_name":"Kia Mccartney","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bowl","role_str":""},{"pid":118691,"title":"Jemma Gillian","short_name":"Jemma Gillian","first_name":"Jemma Gillian","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":118692,"title":"Aoife Fisher","short_name":"Aoife Fisher","first_name":"Aoife Fisher","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":118972,"title":"Sibha Bhoja","short_name":"Sibha Bhoja","first_name":"Sibha Bhoja","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":4,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bowl","role_str":""},{"pid":123058,"title":"Jennifer Jackson","short_name":"J Jackson","first_name":"Jennifer Jackson","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bowl","role_str":""},{"pid":123059,"title":"Niamh MacNulty","short_name":"N MacNulty","first_name":"Niamh MacNulty","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":126743,"title":"Genevieve Morrissey","short_name":"G Morrissey","first_name":"Genevieve Morrissey","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":4,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":126806,"title":"Alice Tector","short_name":"A Tector","first_name":"Alice Tector","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":139840,"title":"Emily Calvert","short_name":"E Calvert","first_name":"Emily Calvert","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":139841,"title":"Elise Noble","short_name":"E Noble","first_name":"Elise Noble","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":139842,"title":"Tahlia Dunne","short_name":"T Dunne","first_name":"Tahlia Dunne","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bat","role_str":""},{"pid":139843,"title":"Sarah Black","short_name":"S Black","first_name":"Sarah Black","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bat","role_str":""},{"pid":139844,"title":"Millie Spence","short_name":"M Spence","first_name":"Millie Spence","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":4.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bat","role_str":""},{"pid":140681,"title":"Lucy McGranaghan","short_name":"L McGranaghan","first_name":"Lucy McGranaghan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":145977,"title":"Rebecca Lowe","short_name":"R Lowe","first_name":"Rebecca Lowe","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bat","role_str":""},{"pid":145978,"title":"Lucy Neely","short_name":"L Neely","first_name":"Lucy Neely","last_name":"","middle_name":"","birthdate":"2006-04-29","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":148753,"title":"Ciara Gibson","short_name":"C Gibson","first_name":"Ciara Gibson","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"sct","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":"","thumb_url":"","profile_image":"","nationality":"Scotland","role":"bat","role_str":"(C)"},{"pid":148754,"title":"Sarah Prendergast","short_name":"S Prendergast","first_name":"Sarah Prendergast","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"sct","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":"","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":148755,"title":"Lucy Barry","short_name":"L Barry","first_name":"Lucy Barry","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"sct","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":"","thumb_url":"","profile_image":"","nationality":"Scotland","role":"all","role_str":""},{"pid":148756,"title":"Molly Butterly","short_name":"M Butterly","first_name":"Molly Butterly","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"sct","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":"","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":148934,"title":"Ella Marsh","short_name":"E Marsh","first_name":"Ella Marsh","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":149200,"title":"Karina Bell","short_name":"Karina Bell","first_name":"Karina Bell","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bowl","role_str":""},{"pid":149201,"title":"Zoe Bell","short_name":"Z Bell","first_name":"Zoe Bell","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"squad","role_str":""},{"pid":149666,"title":"Ella Wasson","short_name":"E Wasson","first_name":"Ella Wasson","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""}]},"etag":"d3d71f0bc269329faa58848f8a448347","modified":"2025-08-01 09:11:47","datetime":"2025-08-01 09:11:47","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":89810,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Dragons Women won by 274 runs","day_remaining_over":"","team_batting":"Scorchers Women","team_bowling":"Dragons Women","live_inning_number":2,"live_score":{"runs":72,"overs":21.3,"wickets":10,"target":347,"runrate":3.35,"required_runrate":9.65},"commentary":2,"wagon":2,"batsmen":[],"bowlers":[],"commentaries":[],"day":"0","session":"0","live_inning":{"iid":198338,"number":2,"name":"Scorchers Women Inning","short_name":"SCO-W Inning","status":2,"issuperover":"false","result":1,"batting_team_id":116365,"fielding_team_id":124475,"scores":"72\/10","scores_full":"72\/10 (21.3 ov)","fielder":[{"fielder_id":"93779","fielder_name":"Cara Murray","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"101754","fielder_name":"Amy Hunter","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"101750","fielder_name":"Alana Dalzell","catches":0,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":1,"stumping":0,"is_substitute":"false"},{"fielder_id":"46732","fielder_name":"Arlene Kelly","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"115745","fielder_name":"Kia Mccartney","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":[],"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Lucy Barry","batsman_id":"148755","runs":"1","balls":"8","how_out":"c K Mccartney b A Dalzell","score_at_dismissal":72,"overs_at_dismissal":"21.3","bowler_id":"101750","dismissal":"caught","number":10},"extra_runs":{"byes":0,"legbyes":0,"wides":15,"noballs":0,"penalty":"0","total":15},"equations":{"runs":72,"wickets":10,"overs":"21.3","bowlers_used":4,"runrate":"3.35"},"current_partnership":[],"did_not_bat":[{"player_id":"118972","name":"Sibha Bhoja"}],"max_over":"50","target":"347","recent_scores":[],"last_five_overs":[],"last_ten_overs":[]},"teams":[{"tid":116365,"title":"Scorchers Women","abbr":"SCO-W","alt_name":"SCO-W","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/06\/Rectangle-3348-40.jpg","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/06\/Rectangle-3348-40.jpg","country":"ie","sex":"female","team_owner":"","head_coach":"","scores_full":"72\/10 (21.3 ov)","scores":"72\/10","overs":"21.3"},{"tid":124475,"title":"Dragons Women","abbr":"DG-W","alt_name":"Dragons Women","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-DRAW@2x.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-DRAW@2x.png","country":"ie","sex":"female","team_owner":"","head_coach":"","scores_full":"346\/6 (50 ov)","scores":"346\/6","overs":"50"}],"players":[{"pid":44510,"title":"Gaby Lewis","short_name":"GH Lewis","first_name":"Gaby Lewis","last_name":"","middle_name":"","birthdate":"2001-03-27","birthplace":"Dublin, Ireland","country":"ie","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/gaby.lewis.96\/","twitter_profile":"https:\/\/twitter.com\/lewis_gaby","instagram_profile":"https:\/\/www.instagram.com\/gabylewis22\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bat","role_str":""},{"pid":46732,"title":"Arlene Kelly","short_name":"Al Kelly","first_name":"Arlene Kelly","last_name":"","middle_name":"","birthdate":"1994-01-08","birthplace":"Auckland","country":"ie","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/arleeene.kelly\/","twitter_profile":"https:\/\/twitter.com\/arlene151k","instagram_profile":"https:\/\/www.instagram.com\/arlenenkelly\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"all","role_str":""},{"pid":46758,"title":"Eimear Richardson","short_name":"EAJ Richardson","first_name":"Eimear Richardson","last_name":"","middle_name":"","birthdate":"1986-09-14","birthplace":"Dublin","country":"ie","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"all","role_str":""},{"pid":46826,"title":"Bella Armstrong","short_name":"BG Armstrong","first_name":"Bella Armstrong","last_name":"","middle_name":"","birthdate":"1999-11-16","birthplace":"","country":"nz","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"bat","role_str":""},{"pid":90860,"title":"Sophie MacMahon","short_name":"S MacMahon","first_name":"Sophie MacMahon","last_name":"","middle_name":"","birthdate":"1997-01-29","birthplace":"Dublin","country":"ie","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"https:\/\/www.facebook.com\/sophie.macmahon.1\/","twitter_profile":"https:\/\/twitter.com\/SophieMacMahon\/media","instagram_profile":"https:\/\/www.instagram.com\/sophiemacmahon\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"all","role_str":""},{"pid":90861,"title":"Louise Little","short_name":"L Little","first_name":"Louise Little","last_name":"","middle_name":"","birthdate":"2003-05-16","birthplace":"Dublin","country":"ie","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bat","role_str":""},{"pid":93779,"title":"Cara Murray","short_name":"C Murray","first_name":"Cara Murray","last_name":"","middle_name":"","birthdate":"2000-11-01","birthplace":"Belfast, Co Antrim","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/cmurray212","instagram_profile":"https:\/\/www.instagram.com\/caracmurray\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bowl","role_str":""},{"pid":93792,"title":"Orla Prendergast","short_name":"O Prendergast","first_name":"Orla Prendergast","last_name":"","middle_name":"","birthdate":"2002-06-01","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/orla.prendergast.5\/","twitter_profile":"https:\/\/twitter.com\/prendergastorla","instagram_profile":"https:\/\/www.instagram.com\/orla_prendergast_\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"all","role_str":""},{"pid":94428,"title":"Claudia Lauren Green","short_name":"CL Green","first_name":"Claudia Lauren Green","last_name":"","middle_name":"","birthdate":"1997-12-06","birthplace":"","country":"nz","primary_team":[],"logo_url":"","playing_role":"wk","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":"","thumb_url":"","profile_image":"","nationality":"New Zealand","role":"squad","role_str":""},{"pid":101750,"title":"Alana Dalzell","short_name":"A Dalzell","first_name":"Alana Dalzell","last_name":"","middle_name":"","birthdate":"2001-03-26","birthplace":"Londonderry","country":"ie","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bowl","role_str":""},{"pid":101754,"title":"Amy Hunter","short_name":"A Hunter","first_name":"Amy Hunter","last_name":"","middle_name":"","birthdate":"2005-10-11","birthplace":"Belfast","country":"ie","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/AmyHunter54","instagram_profile":"https:\/\/www.instagram.com\/amy_c_hunter\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"wk","role_str":"(WK\/C)"},{"pid":101760,"title":"Ava Canning","short_name":"A Canning","first_name":"Ava Canning","last_name":"","middle_name":"","birthdate":"2004-02-02","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/ava.canning\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/canning579\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bowl","role_str":""},{"pid":107565,"title":"Christina Coulter Reilly","short_name":"C Reilly","first_name":"Christina Coulter Reilly","last_name":"","middle_name":"","birthdate":"2003-08-17","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"wk","role_str":"(WK)"},{"pid":115632,"title":"Lara McBride","short_name":"Lara McBride","first_name":"Lara McBride","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"all","role_str":""},{"pid":115635,"title":"Aimee Maguire","short_name":"A Maguire","first_name":"Aimee Maguire","last_name":"","middle_name":"","birthdate":"2006-09-09","birthplace":"Dublin, Ireland","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":115740,"title":"Abbi Harrison","short_name":"A Harison","first_name":"Abbi Harrison","last_name":"","middle_name":"","birthdate":"2006-08-08","birthplace":"Craigavon","country":"ie","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"wk","role_str":""},{"pid":115743,"title":"Mollie Devine","short_name":"M Devine","first_name":"Mollie Devine","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":115745,"title":"Kia Mccartney","short_name":"K Mccartney","first_name":"Kia Mccartney","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bowl","role_str":""},{"pid":118691,"title":"Jemma Gillian","short_name":"Jemma Gillian","first_name":"Jemma Gillian","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":118692,"title":"Aoife Fisher","short_name":"Aoife Fisher","first_name":"Aoife Fisher","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":118972,"title":"Sibha Bhoja","short_name":"Sibha Bhoja","first_name":"Sibha Bhoja","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":4,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bowl","role_str":""},{"pid":123058,"title":"Jennifer Jackson","short_name":"J Jackson","first_name":"Jennifer Jackson","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bowl","role_str":""},{"pid":123059,"title":"Niamh MacNulty","short_name":"N MacNulty","first_name":"Niamh MacNulty","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":126743,"title":"Genevieve Morrissey","short_name":"G Morrissey","first_name":"Genevieve Morrissey","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":4,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":126806,"title":"Alice Tector","short_name":"A Tector","first_name":"Alice Tector","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":139840,"title":"Emily Calvert","short_name":"E Calvert","first_name":"Emily Calvert","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":139841,"title":"Elise Noble","short_name":"E Noble","first_name":"Elise Noble","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":139842,"title":"Tahlia Dunne","short_name":"T Dunne","first_name":"Tahlia Dunne","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bat","role_str":""},{"pid":139843,"title":"Sarah Black","short_name":"S Black","first_name":"Sarah Black","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bat","role_str":""},{"pid":139844,"title":"Millie Spence","short_name":"M Spence","first_name":"Millie Spence","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":4.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bat","role_str":""},{"pid":140681,"title":"Lucy McGranaghan","short_name":"L McGranaghan","first_name":"Lucy McGranaghan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":145977,"title":"Rebecca Lowe","short_name":"R Lowe","first_name":"Rebecca Lowe","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bat","role_str":""},{"pid":145978,"title":"Lucy Neely","short_name":"L Neely","first_name":"Lucy Neely","last_name":"","middle_name":"","birthdate":"2006-04-29","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":148753,"title":"Ciara Gibson","short_name":"C Gibson","first_name":"Ciara Gibson","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"sct","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":"","thumb_url":"","profile_image":"","nationality":"Scotland","role":"bat","role_str":"(C)"},{"pid":148754,"title":"Sarah Prendergast","short_name":"S Prendergast","first_name":"Sarah Prendergast","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"sct","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":"","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":148755,"title":"Lucy Barry","short_name":"L Barry","first_name":"Lucy Barry","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"sct","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":"","thumb_url":"","profile_image":"","nationality":"Scotland","role":"all","role_str":""},{"pid":148756,"title":"Molly Butterly","short_name":"M Butterly","first_name":"Molly Butterly","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"sct","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":"","thumb_url":"","profile_image":"","nationality":"Scotland","role":"squad","role_str":""},{"pid":148934,"title":"Ella Marsh","short_name":"E Marsh","first_name":"Ella Marsh","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""},{"pid":149200,"title":"Karina Bell","short_name":"Karina Bell","first_name":"Karina Bell","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"bowl","role_str":""},{"pid":149201,"title":"Zoe Bell","short_name":"Z Bell","first_name":"Zoe Bell","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"squad","role_str":""},{"pid":149666,"title":"Ella Wasson","short_name":"E Wasson","first_name":"Ella Wasson","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"ie","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":"","thumb_url":"","profile_image":"","nationality":"Ireland","role":"squad","role_str":""}]},"etag":"d3d71f0bc269329faa58848f8a448347","modified":"2025-08-01 09:11:47","datetime":"2025-08-01 09:11:47","api_version":"3.0"}', Modified = GetDate() WHERE Id = 89810 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:4aa18728-f1ea-42cb-8173-7e06c37e3810 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 89810 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (89810,3,'{"status":"ok","response":{"match_id":89810,"title":"Dragons Women vs Scorchers Women","short_title":"DG-W vs SCO-W","subtitle":"Match 6","match_number":"6","format":4,"format_str":"List A","status":2,"status_str":"Completed","status_note":"Dragons Women won by 274 runs","verified":"false","pre_squad":"false","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129578,"title":"Evoke Super Series","abbr":"Evoke Super Series","type":"tournament","category":"women","match_format":"lista","season":"2025","status":"live","datestart":"2025-05-04","dateend":"2025-06-25","country":"ie","total_matches":"7","total_rounds":"1","total_teams":"3"},"teama":{"team_id":124475,"name":"Dragons Women","short_name":"DG-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-DRAW@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-DRAW@2x.png","scores_full":"346\/6 (50 ov)","scores":"346\/6","overs":"50"},"teamb":{"team_id":116365,"name":"Scorchers Women","short_name":"SCO-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/06\/Rectangle-3348-40.jpg","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/06\/Rectangle-3348-40.jpg","scores_full":"72\/10 (21.3 ov)","scores":"72\/10","overs":"21.3"},"date_start":"2025-06-18 09:45:00","date_end":"2025-06-19 03:45:00","timestamp_start":1750239900,"timestamp_end":1750304700,"date_start_ist":"2025-06-18 15:15:00","date_end_ist":"2025-06-19 09:15:00","venue":{"venue_id":"1213365","name":"Wallace Park","location":"Lisburn","country":"Ireland","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"DG-W won by 274 runs","result_type":1,"win_margin":"274 runs","winning_team_id":124475,"commentary":2,"wagon":2,"latest_inning_number":2,"presquad_time":"","verify_time":"","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":[],"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Scorchers Women elected to bowl","winner":116365,"decision":2}},"etag":"d3d71f0bc269329faa58848f8a448347","modified":"2025-08-01 09:11:47","datetime":"2025-08-01 09:11:47","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":89810,"title":"Dragons Women vs Scorchers Women","short_title":"DG-W vs SCO-W","subtitle":"Match 6","match_number":"6","format":4,"format_str":"List A","status":2,"status_str":"Completed","status_note":"Dragons Women won by 274 runs","verified":"false","pre_squad":"false","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129578,"title":"Evoke Super Series","abbr":"Evoke Super Series","type":"tournament","category":"women","match_format":"lista","season":"2025","status":"live","datestart":"2025-05-04","dateend":"2025-06-25","country":"ie","total_matches":"7","total_rounds":"1","total_teams":"3"},"teama":{"team_id":124475,"name":"Dragons Women","short_name":"DG-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-DRAW@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/FC-DRAW@2x.png","scores_full":"346\/6 (50 ov)","scores":"346\/6","overs":"50"},"teamb":{"team_id":116365,"name":"Scorchers Women","short_name":"SCO-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/06\/Rectangle-3348-40.jpg","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/06\/Rectangle-3348-40.jpg","scores_full":"72\/10 (21.3 ov)","scores":"72\/10","overs":"21.3"},"date_start":"2025-06-18 09:45:00","date_end":"2025-06-19 03:45:00","timestamp_start":1750239900,"timestamp_end":1750304700,"date_start_ist":"2025-06-18 15:15:00","date_end_ist":"2025-06-19 09:15:00","venue":{"venue_id":"1213365","name":"Wallace Park","location":"Lisburn","country":"Ireland","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"DG-W won by 274 runs","result_type":1,"win_margin":"274 runs","winning_team_id":124475,"commentary":2,"wagon":2,"latest_inning_number":2,"presquad_time":"","verify_time":"","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":[],"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Scorchers Women elected to bowl","winner":116365,"decision":2}},"etag":"d3d71f0bc269329faa58848f8a448347","modified":"2025-08-01 09:11:47","datetime":"2025-08-01 09:11:47","api_version":"3.0"}', Modified = GetDate() WHERE Id = 89810 AND DataTypeId = 3 END
Live Report & Scorecard of Dragons Women vs Scorchers Women Match 6