[Solved] The property or field Url has not been initialized. It has not been requested or the request has not been executed. It may need to be explicitly requested error in SharePoint

This SharePoint tutorial explains, how to solve the error: The property or field Url has not been initialized. It has not been requested or the request has not been executed. It may need to be explicitly requested. The error comes while working with SharePoint CSOM (Client Side Object Model).

Recently I was working with csom (.net managed object model) code for SharePoint Online sites. There is a requirement to retrieve web Id of the SharePoint site. So we have developed a console application that was communicating to SharePoint online sites.

We got an error message which says:
An unhandled exception of type ‘Microsoft.SharePoint.Client.PropertyOrFieldNotInitializedException’ occurred in Microsoft.SharePoint.Client.Runtime.dll

Additional information: The property or field ‘Url’ has not been initialized. It has not been requested or the request has not been executed. It may need to be explicitly requested.

It looks like below:

In the code, I was writing below to retrieve the website details like ServerRelativeUrl and RootWeb details.

using (ClientContext context = new ClientContext(parentURL))
{
context.AuthenticationMode = ClientAuthenticationMode.Default;
context.Credentials = new SharePointOnlineCredentials(GetSPOAccountName(), GetSPOSecureStringPassword());
context.Load(context.Web, w => w.ServerRelativeUrl);
context.Load(context.Site.RootWeb, w => w.Id, w => w.Url);
context.Load(context.Web, w => w.Id);
string rootWebURL = context.Site.RootWeb.Url;
}

When I execute the above code the above exception comes in the below line:

string rootWebURL = context.Site.RootWeb.Url;

The property or field ‘Url’ has not been initialized. It has not been requested or the request has not been executed. It may need to be explicitly requested

The mistake I was doing was not to calling the ExecuteQuery() method after loading the properties.

context.ExecuteQuery();

Below is the full code:

using (ClientContext context = new ClientContext(parentURL))
{
context.AuthenticationMode = ClientAuthenticationMode.Default;
context.Credentials = new SharePointOnlineCredentials(GetSPOAccountName(), GetSPOSecureStringPassword());
context.Load(context.Web, w => w.ServerRelativeUrl);
context.Load(context.Site.RootWeb, w => w.Id, w => w.Url);
context.Load(context.Web, w => w.Id);
context.ExecuteQuery();
string rootWebURL = context.Site.RootWeb.Url;
}

I hope this will be helpful to resolve The property or field Url has not been initialized. It has not been requested or the request has not been executed. It may need to be an explicitly requested error in SharePoint.

You may also like:

• SharePoint Online List Permissions
• SharePoint Online list view
• delete all items from SharePoint list
• SharePoint Workflow history list URL