How to retrieve Sharepoint site that contains special characters or numbers using Graph .NET SDK

Question

How to retrieve Sharepoint site that contains special characters or numbers using Graph .NET SDK

Jakub Pernica 220

I'm using the latest Microsoft Graph .NET SDK. Using delegated permissions, I try to retrieve a SharePoint site by it's display name. Let's say I have a sharepoint site with name "Some - site" or simply "Site2".

The way I'm approaching this problem in code is like this:

var response = await client.Sites.GetAsync((reqConfig) =>
{
	reqConfig.QueryParameters.Search = "Some - site";
    // reqConfig.QueryParameters.Search = "Site2";
});

The request fails with the Status Code 400: BadRequest with message:

"Syntax error: character '-' is not valid at position 5 in 'Some - site'."

Same goes for using numbers in Search ("Site2").

When I was using Application permissions, I was able to retrieve .GetAllSites() and loop through them to find a specific site. However, I'm now using on-behalf-of flow with Delegated permissions and can't retrieve all sites, that's why I'm using Search query.

What would be a solution for this problem?

Maqsood Ahmad 0 Reputation points

2024-12-18T02:00:05.8433333+00:00

Did you find the reason and a possible solution to the problem as I'm also facing same issue

Jakub Pernica 220

Try something like this:

private static async Task<string> GetSiteByNameAsync_Delegated(GraphServiceClient client, string name)
{
	var requestBody = new Microsoft.Graph.Search.Query.QueryPostRequestBody
    {
	    Requests = new List<SearchRequest>
	    {
	    	new SearchRequest
	        {
	        	EntityTypes = new List<EntityType?>
	            {
	            	EntityType.Site,
				},
	            Query = new SearchQuery
	            {
	            	QueryString = name,
		        },
			},
		},
	};
    var result = await client.Search.Query.PostAsync(requestBody);

    return result?.Value?[0]?.HitsContainers?[0]?.Hits?[0]?.Resource?.Id;
}

Maqsood Ahmad 0 Reputation points

2024-12-19T22:19:32.6433333+00:00

I found a solution mentioned in this post https://github.com/microsoftgraph/msgraph-sdk-dotnet/issues/1884
search parameter should be in double quotes like
var response = await client.Sites.GetAsync((reqConfig) => { reqConfig.QueryParameters.Search = ""Some - site""; });

Your answer

Maqsood Ahmad 0 Reputation points

2024-12-18T02:00:05.8433333+00:00

Did you find the reason and a possible solution to the problem as I'm also facing same issue
Jakub Pernica 220 Reputation points

2024-12-18T08:05:35.0966667+00:00

Try something like this:

private static async Task<string> GetSiteByNameAsync_Delegated(GraphServiceClient client, string name) { var requestBody = new Microsoft.Graph.Search.Query.QueryPostRequestBody { Requests = new List<SearchRequest> { new SearchRequest { EntityTypes = new List<EntityType?> { EntityType.Site, }, Query = new SearchQuery { QueryString = name, }, }, }, }; var result = await client.Search.Query.PostAsync(requestBody); return result?.Value?[0]?.HitsContainers?[0]?.Hits?[0]?.Resource?.Id; }
Maqsood Ahmad 0 Reputation points

2024-12-19T22:19:32.6433333+00:00

I found a solution mentioned in this post https://github.com/microsoftgraph/msgraph-sdk-dotnet/issues/1884
search parameter should be in double quotes like
var response = await client.Sites.GetAsync((reqConfig) => { reqConfig.QueryParameters.Search = ""Some - site""; });

Share via

How to retrieve Sharepoint site that contains special characters or numbers using Graph .NET SDK

Your answer