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:08a5057f-657f-48ff-8f2b-122b02f6bce2
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90288 AND DataTypeId = 8) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90288,8,'{"status":"ok","response":{"teama":{"team_id":19246,"squads":[{"player_id":"90942","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"Naomi Dattani"},{"player_id":"147616","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"Riva Pindoria"},{"player_id":"107846","substitute":"false","out":"false","in":"false","role_str":"","role":"wk","playing11":"true","name":"Finty Trussler"},{"player_id":"94326","substitute":"false","out":"false","in":"false","role_str":"(C)","role":"bat","playing11":"true","name":"Saskia Horley"},{"player_id":"148184","substitute":"false","out":"false","in":"false","role_str":"","role":"wk","playing11":"true","name":"Georgia Irving"},{"player_id":"146101","substitute":"false","out":"false","in":"false","role_str":"(WK)","role":"bat","playing11":"true","name":"Pippa Sproul"},{"player_id":"56867","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Gayatri Gole"},{"player_id":"148542","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Anaya Patel"},{"player_id":"102762","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Katie Wolfe"},{"player_id":"148538","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Sarah Pearson"},{"player_id":"148182","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Hannah Davis"},{"player_id":"51740","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"false","name":"Natasha Miles"},{"player_id":"148186","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"false","name":"Olivia Kibler"},{"player_id":"148535","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"false","name":"Artemis Downer"},{"player_id":"148541","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"false","name":"Anisha Dissenayake"},{"player_id":"141810","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"false","name":"Isabella Routledge"},{"player_id":"107866","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"false","name":"Lucy Porter"},{"player_id":"148546","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"false","name":"Jenny Blofeld"},{"player_id":"148361","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"false","name":"Rachana Cambampaty"},{"player_id":"102761","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"false","name":"Sonali Patel"},{"player_id":"148537","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"false","name":"Lauren Turner"},{"player_id":"148547","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"false","name":"Layla Judge"}]},"teamb":{"team_id":19200,"squads":[{"player_id":"107881","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Isabelle Collis"},{"player_id":"148170","substitute":"false","out":"false","in":"false","role_str":"(WK)","role":"bat","playing11":"true","name":"Mollie Adams"},{"player_id":"102766","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Nancy Harman"},{"player_id":"51368","substitute":"false","out":"false","in":"false","role_str":"(C)","role":"all","playing11":"true","name":"Chiara Green"},{"player_id":"107857","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"Jasmine Westley"},{"player_id":"107887","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Indigo Gentry"},{"player_id":"107884","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Millie Taylor"},{"player_id":"148282","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"TI Stanley"},{"player_id":"146143","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Eve ONeill"},{"player_id":"148651","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Lottie Curling"},{"player_id":"148652","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Kali Docherty"},{"player_id":"141144","substitute":"false","out":"false","in":"false","role_str":"","role":"wk","playing11":"false","name":"Rachel King"},{"player_id":"148171","substitute":"false","out":"false","in":"false","role_str":"","role":"wk","playing11":"false","name":"Anna Buckle"},{"player_id":"148648","substitute":"false","out":"false","in":"false","role_str":"","role":"wk","playing11":"false","name":"Maya Champion"},{"player_id":"148174","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"false","name":"Lucy Western"},{"player_id":"148280","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"false","name":"Phoebe Wilkinson"},{"player_id":"148172","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"false","name":"Tia Joseph"},{"player_id":"148173","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"false","name":"Anna Lewis"},{"player_id":"148649","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"false","name":"Hope Mullins"},{"player_id":"148650","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"false","name":"Alice Noakes"},{"player_id":"124052","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"false","name":"Regina Suddahazai"},{"player_id":"107885","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"false","name":"Beth Harvey"},{"player_id":"148653","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"false","name":"Faye Mullins"}]},"teams":[{"tid":19200,"title":"Sussex Women","abbr":"SUS-W","alt_name":"SUS-W","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2021\/05\/Sussex_Cricket_Crest_2018.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2021\/05\/Sussex_Cricket_Crest_2018.png","country":"en","sex":"female","team_owner":"","head_coach":""},{"tid":19246,"title":"Middlesex Women","abbr":"MID-W","alt_name":"MID-W","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/12\/Middlesex-Women.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/12\/Middlesex-Women.png","country":"en","sex":"male","team_owner":"","head_coach":""}],"players":[{"pid":51368,"title":"Chiara Green","short_name":"CM Green","first_name":"Chiara Green","last_name":"","middle_name":"","birthdate":"1993-10-18","birthplace":"","country":"en","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":51740,"title":"Natasha Miles","short_name":"Natasha Miles","first_name":"Natasha Miles","last_name":"","middle_name":"","birthdate":"1988-10-19","birthplace":"","country":"hk","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Hong Kong"},{"pid":56867,"title":"Gayatri Gole","short_name":"G Gole","first_name":"Gayatri Gole","last_name":"","middle_name":"","birthdate":"1998-07-22","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":90942,"title":"Naomi Dattani","short_name":"ND Dattani","first_name":"Naomi Dattani","last_name":"","middle_name":"","birthdate":"1994-04-28","birthplace":"Ealing, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/NaomiDattani","instagram_profile":"https:\/\/www.instagram.com\/naomi.dattani\/","debut_data":"","thumb_url":"","nationality":"England"},{"pid":94326,"title":"Saskia Horley","short_name":"S Horley","first_name":"Saskia Horley","last_name":"","middle_name":"","birthdate":"2000-02-23","birthplace":"","country":"au","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Australia"},{"pid":102761,"title":"Sonali Patel","short_name":"S Patel","first_name":"Sonali Patel","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","thumb_url":"","nationality":"England"},{"pid":102762,"title":"Katie Wolfe","short_name":"K Wolfe","first_name":"Katie Wolfe","last_name":"","middle_name":"","birthdate":"2001-04-03","birthplace":"","country":"en","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":102766,"title":"Nancy Harman","short_name":"N Harman","first_name":"Nancy Harman","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","nationality":"England"},{"pid":107846,"title":"Finty Trussler","short_name":"F Trussler","first_name":"Finty Trussler","last_name":"","middle_name":"","birthdate":"2003-05-08","birthplace":"","country":"en","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":107857,"title":"Jasmine Westley","short_name":"J Westley","first_name":"Jasmine Westley","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","nationality":"England"},{"pid":107866,"title":"Lucy Porter","short_name":"L Porter","first_name":"Lucy Porter","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","thumb_url":"","nationality":"England"},{"pid":107881,"title":"Isabelle Collis","short_name":"I Collis","first_name":"Isabelle Collis","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":107884,"title":"Millie Taylor","short_name":"M Taylor","first_name":"Millie Taylor","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","thumb_url":"","nationality":"England"},{"pid":107885,"title":"Beth Harvey","short_name":"B Harvey","first_name":"Beth Harvey","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","thumb_url":"","nationality":"England"},{"pid":107887,"title":"Indigo Gentry","short_name":"I Gentry","first_name":"Indigo Gentry","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":124052,"title":"Regina Suddahazai","short_name":"R Suddahazai","first_name":"Regina Suddahazai","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"it","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":"","nationality":"Italy"},{"pid":141144,"title":"Rachel King","short_name":"R King","first_name":"Rachel King","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","nationality":"England"},{"pid":141810,"title":"Isabella Routledge","short_name":"I Routledge","first_name":"Isabella Routledge","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","thumb_url":"","nationality":"England"},{"pid":146101,"title":"Pippa Sproul","short_name":"P Sproul","first_name":"Pippa Sproul","last_name":"","middle_name":"","birthdate":"2008-02-12","birthplace":"","country":"sct","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Scotland"},{"pid":146143,"title":"Eve ONeill","short_name":"E ONeill","first_name":"Eve ONeill","last_name":"","middle_name":"","birthdate":"2008-05-11","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":147616,"title":"Riva Pindoria","short_name":"R Pindoria","first_name":"Riva Pindoria","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":148170,"title":"Mollie Adams","short_name":"M Adams","first_name":"Mollie Adams","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","nationality":"England"},{"pid":148171,"title":"Anna Buckle","short_name":"A Buckle","first_name":"Anna Buckle","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":148172,"title":"Tia Joseph","short_name":"T Joseph","first_name":"Tia Joseph","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","nationality":"England"},{"pid":148173,"title":"Anna Lewis","short_name":"A Lewis","first_name":"Anna Lewis","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","nationality":"England"},{"pid":148174,"title":"Lucy Western","short_name":"L Western","first_name":"Lucy Western","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","nationality":"England"},{"pid":148182,"title":"Hannah Davis","short_name":"H Davis","first_name":"Hannah Davis","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","nationality":"England"},{"pid":148184,"title":"Georgia Irving","short_name":"G Irving","first_name":"Georgia Irving","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":148186,"title":"Olivia Kibler","short_name":"O Kibler","first_name":"Olivia Kibler","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","nationality":"England"},{"pid":148280,"title":"Phoebe Wilkinson","short_name":"P Wilkinson","first_name":"Phoebe Wilkinson","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","nationality":"England"},{"pid":148282,"title":"TI Stanley","short_name":"TI Stanley","first_name":"TI Stanley","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":148361,"title":"Rachana Cambampaty","short_name":"R Cambampaty","first_name":"Rachana Cambampaty","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","thumb_url":"","nationality":"England"},{"pid":148535,"title":"Artemis Downer","short_name":"A Downer","first_name":"Artemis Downer","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","nationality":"England"},{"pid":148537,"title":"Lauren Turner","short_name":"L Turner","first_name":"Lauren Turner","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","thumb_url":"","nationality":"England"},{"pid":148538,"title":"Sarah Pearson","short_name":"S Pearson","first_name":"Sarah Pearson","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","nationality":"England"},{"pid":148541,"title":"Anisha Dissenayake","short_name":"A Dissenayake","first_name":"Anisha Dissenayake","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","nationality":"England"},{"pid":148542,"title":"Anaya Patel","short_name":"A Patel","first_name":"Anaya Patel","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","thumb_url":"","nationality":"England"},{"pid":148546,"title":"Jenny Blofeld","short_name":"J Blofeld","first_name":"Jenny Blofeld","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":148547,"title":"Layla Judge","short_name":"L Judge","first_name":"Layla Judge","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","nationality":"England"},{"pid":148648,"title":"Maya Champion","short_name":"M Champion","first_name":"Maya Champion","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","thumb_url":"","nationality":"England"},{"pid":148649,"title":"Hope Mullins","short_name":"H Mullins","first_name":"Hope Mullins","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","nationality":"England"},{"pid":148650,"title":"Alice Noakes","short_name":"A Noakes","first_name":"Alice Noakes","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":148651,"title":"Lottie Curling","short_name":"L Curling","first_name":"Lottie Curling","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","thumb_url":"","nationality":"England"},{"pid":148652,"title":"Kali Docherty","short_name":"K Docherty","first_name":"Kali Docherty","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","nationality":"England"},{"pid":148653,"title":"Faye Mullins","short_name":"F Mullins","first_name":"Faye Mullins","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","nationality":"England"}]},"etag":"ecb0e2477df200e72e8c18baaaa98183","modified":"2025-06-27 08:23:01","datetime":"2025-06-27 08:23:01","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"teama":{"team_id":19246,"squads":[{"player_id":"90942","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"Naomi Dattani"},{"player_id":"147616","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"Riva Pindoria"},{"player_id":"107846","substitute":"false","out":"false","in":"false","role_str":"","role":"wk","playing11":"true","name":"Finty Trussler"},{"player_id":"94326","substitute":"false","out":"false","in":"false","role_str":"(C)","role":"bat","playing11":"true","name":"Saskia Horley"},{"player_id":"148184","substitute":"false","out":"false","in":"false","role_str":"","role":"wk","playing11":"true","name":"Georgia Irving"},{"player_id":"146101","substitute":"false","out":"false","in":"false","role_str":"(WK)","role":"bat","playing11":"true","name":"Pippa Sproul"},{"player_id":"56867","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Gayatri Gole"},{"player_id":"148542","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Anaya Patel"},{"player_id":"102762","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Katie Wolfe"},{"player_id":"148538","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Sarah Pearson"},{"player_id":"148182","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Hannah Davis"},{"player_id":"51740","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"false","name":"Natasha Miles"},{"player_id":"148186","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"false","name":"Olivia Kibler"},{"player_id":"148535","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"false","name":"Artemis Downer"},{"player_id":"148541","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"false","name":"Anisha Dissenayake"},{"player_id":"141810","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"false","name":"Isabella Routledge"},{"player_id":"107866","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"false","name":"Lucy Porter"},{"player_id":"148546","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"false","name":"Jenny Blofeld"},{"player_id":"148361","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"false","name":"Rachana Cambampaty"},{"player_id":"102761","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"false","name":"Sonali Patel"},{"player_id":"148537","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"false","name":"Lauren Turner"},{"player_id":"148547","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"false","name":"Layla Judge"}]},"teamb":{"team_id":19200,"squads":[{"player_id":"107881","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Isabelle Collis"},{"player_id":"148170","substitute":"false","out":"false","in":"false","role_str":"(WK)","role":"bat","playing11":"true","name":"Mollie Adams"},{"player_id":"102766","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"true","name":"Nancy Harman"},{"player_id":"51368","substitute":"false","out":"false","in":"false","role_str":"(C)","role":"all","playing11":"true","name":"Chiara Green"},{"player_id":"107857","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"Jasmine Westley"},{"player_id":"107887","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Indigo Gentry"},{"player_id":"107884","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Millie Taylor"},{"player_id":"148282","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"true","name":"TI Stanley"},{"player_id":"146143","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Eve ONeill"},{"player_id":"148651","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Lottie Curling"},{"player_id":"148652","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"true","name":"Kali Docherty"},{"player_id":"141144","substitute":"false","out":"false","in":"false","role_str":"","role":"wk","playing11":"false","name":"Rachel King"},{"player_id":"148171","substitute":"false","out":"false","in":"false","role_str":"","role":"wk","playing11":"false","name":"Anna Buckle"},{"player_id":"148648","substitute":"false","out":"false","in":"false","role_str":"","role":"wk","playing11":"false","name":"Maya Champion"},{"player_id":"148174","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"false","name":"Lucy Western"},{"player_id":"148280","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"false","name":"Phoebe Wilkinson"},{"player_id":"148172","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"false","name":"Tia Joseph"},{"player_id":"148173","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"false","name":"Anna Lewis"},{"player_id":"148649","substitute":"false","out":"false","in":"false","role_str":"","role":"bat","playing11":"false","name":"Hope Mullins"},{"player_id":"148650","substitute":"false","out":"false","in":"false","role_str":"","role":"all","playing11":"false","name":"Alice Noakes"},{"player_id":"124052","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"false","name":"Regina Suddahazai"},{"player_id":"107885","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"false","name":"Beth Harvey"},{"player_id":"148653","substitute":"false","out":"false","in":"false","role_str":"","role":"bowl","playing11":"false","name":"Faye Mullins"}]},"teams":[{"tid":19200,"title":"Sussex Women","abbr":"SUS-W","alt_name":"SUS-W","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2021\/05\/Sussex_Cricket_Crest_2018.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2021\/05\/Sussex_Cricket_Crest_2018.png","country":"en","sex":"female","team_owner":"","head_coach":""},{"tid":19246,"title":"Middlesex Women","abbr":"MID-W","alt_name":"MID-W","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/12\/Middlesex-Women.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/12\/Middlesex-Women.png","country":"en","sex":"male","team_owner":"","head_coach":""}],"players":[{"pid":51368,"title":"Chiara Green","short_name":"CM Green","first_name":"Chiara Green","last_name":"","middle_name":"","birthdate":"1993-10-18","birthplace":"","country":"en","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":51740,"title":"Natasha Miles","short_name":"Natasha Miles","first_name":"Natasha Miles","last_name":"","middle_name":"","birthdate":"1988-10-19","birthplace":"","country":"hk","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":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Hong Kong"},{"pid":56867,"title":"Gayatri Gole","short_name":"G Gole","first_name":"Gayatri Gole","last_name":"","middle_name":"","birthdate":"1998-07-22","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":90942,"title":"Naomi Dattani","short_name":"ND Dattani","first_name":"Naomi Dattani","last_name":"","middle_name":"","birthdate":"1994-04-28","birthplace":"Ealing, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/NaomiDattani","instagram_profile":"https:\/\/www.instagram.com\/naomi.dattani\/","debut_data":"","thumb_url":"","nationality":"England"},{"pid":94326,"title":"Saskia Horley","short_name":"S Horley","first_name":"Saskia Horley","last_name":"","middle_name":"","birthdate":"2000-02-23","birthplace":"","country":"au","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Australia"},{"pid":102761,"title":"Sonali Patel","short_name":"S Patel","first_name":"Sonali Patel","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","thumb_url":"","nationality":"England"},{"pid":102762,"title":"Katie Wolfe","short_name":"K Wolfe","first_name":"Katie Wolfe","last_name":"","middle_name":"","birthdate":"2001-04-03","birthplace":"","country":"en","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":102766,"title":"Nancy Harman","short_name":"N Harman","first_name":"Nancy Harman","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","nationality":"England"},{"pid":107846,"title":"Finty Trussler","short_name":"F Trussler","first_name":"Finty Trussler","last_name":"","middle_name":"","birthdate":"2003-05-08","birthplace":"","country":"en","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":107857,"title":"Jasmine Westley","short_name":"J Westley","first_name":"Jasmine Westley","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","nationality":"England"},{"pid":107866,"title":"Lucy Porter","short_name":"L Porter","first_name":"Lucy Porter","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","thumb_url":"","nationality":"England"},{"pid":107881,"title":"Isabelle Collis","short_name":"I Collis","first_name":"Isabelle Collis","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":107884,"title":"Millie Taylor","short_name":"M Taylor","first_name":"Millie Taylor","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","thumb_url":"","nationality":"England"},{"pid":107885,"title":"Beth Harvey","short_name":"B Harvey","first_name":"Beth Harvey","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","thumb_url":"","nationality":"England"},{"pid":107887,"title":"Indigo Gentry","short_name":"I Gentry","first_name":"Indigo Gentry","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":124052,"title":"Regina Suddahazai","short_name":"R Suddahazai","first_name":"Regina Suddahazai","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"it","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":"","nationality":"Italy"},{"pid":141144,"title":"Rachel King","short_name":"R King","first_name":"Rachel King","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","nationality":"England"},{"pid":141810,"title":"Isabella Routledge","short_name":"I Routledge","first_name":"Isabella Routledge","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","thumb_url":"","nationality":"England"},{"pid":146101,"title":"Pippa Sproul","short_name":"P Sproul","first_name":"Pippa Sproul","last_name":"","middle_name":"","birthdate":"2008-02-12","birthplace":"","country":"sct","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Scotland"},{"pid":146143,"title":"Eve ONeill","short_name":"E ONeill","first_name":"Eve ONeill","last_name":"","middle_name":"","birthdate":"2008-05-11","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":147616,"title":"Riva Pindoria","short_name":"R Pindoria","first_name":"Riva Pindoria","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":148170,"title":"Mollie Adams","short_name":"M Adams","first_name":"Mollie Adams","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","nationality":"England"},{"pid":148171,"title":"Anna Buckle","short_name":"A Buckle","first_name":"Anna Buckle","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":148172,"title":"Tia Joseph","short_name":"T Joseph","first_name":"Tia Joseph","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","nationality":"England"},{"pid":148173,"title":"Anna Lewis","short_name":"A Lewis","first_name":"Anna Lewis","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","nationality":"England"},{"pid":148174,"title":"Lucy Western","short_name":"L Western","first_name":"Lucy Western","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","nationality":"England"},{"pid":148182,"title":"Hannah Davis","short_name":"H Davis","first_name":"Hannah Davis","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","nationality":"England"},{"pid":148184,"title":"Georgia Irving","short_name":"G Irving","first_name":"Georgia Irving","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":148186,"title":"Olivia Kibler","short_name":"O Kibler","first_name":"Olivia Kibler","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","nationality":"England"},{"pid":148280,"title":"Phoebe Wilkinson","short_name":"P Wilkinson","first_name":"Phoebe Wilkinson","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","nationality":"England"},{"pid":148282,"title":"TI Stanley","short_name":"TI Stanley","first_name":"TI Stanley","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":148361,"title":"Rachana Cambampaty","short_name":"R Cambampaty","first_name":"Rachana Cambampaty","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","thumb_url":"","nationality":"England"},{"pid":148535,"title":"Artemis Downer","short_name":"A Downer","first_name":"Artemis Downer","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","nationality":"England"},{"pid":148537,"title":"Lauren Turner","short_name":"L Turner","first_name":"Lauren Turner","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","thumb_url":"","nationality":"England"},{"pid":148538,"title":"Sarah Pearson","short_name":"S Pearson","first_name":"Sarah Pearson","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","nationality":"England"},{"pid":148541,"title":"Anisha Dissenayake","short_name":"A Dissenayake","first_name":"Anisha Dissenayake","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","nationality":"England"},{"pid":148542,"title":"Anaya Patel","short_name":"A Patel","first_name":"Anaya Patel","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","thumb_url":"","nationality":"England"},{"pid":148546,"title":"Jenny Blofeld","short_name":"J Blofeld","first_name":"Jenny Blofeld","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":148547,"title":"Layla Judge","short_name":"L Judge","first_name":"Layla Judge","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","nationality":"England"},{"pid":148648,"title":"Maya Champion","short_name":"M Champion","first_name":"Maya Champion","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","thumb_url":"","nationality":"England"},{"pid":148649,"title":"Hope Mullins","short_name":"H Mullins","first_name":"Hope Mullins","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","nationality":"England"},{"pid":148650,"title":"Alice Noakes","short_name":"A Noakes","first_name":"Alice Noakes","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},{"pid":148651,"title":"Lottie Curling","short_name":"L Curling","first_name":"Lottie Curling","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","thumb_url":"","nationality":"England"},{"pid":148652,"title":"Kali Docherty","short_name":"K Docherty","first_name":"Kali Docherty","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","nationality":"England"},{"pid":148653,"title":"Faye Mullins","short_name":"F Mullins","first_name":"Faye Mullins","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"","nationality":"England"}]},"etag":"ecb0e2477df200e72e8c18baaaa98183","modified":"2025-06-27 08:23:01","datetime":"2025-06-27 08:23:01","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90288 AND DataTypeId = 8 END
Playing XI for Middlesex Women vs Sussex Women at lord's 2025
