Processing failed:Invalid filter clause: Syntax error

Question

When running my code with filters brought from MS Graph Explorer, the following error appears: "Processing failed: Invalid filter clause: Syntax error."

var graphClient = new GraphServiceClient(clientSecretCredential, scopes);
            try
            {
                var devices = await graphClient.Devices.GetAsync((requestConfiguration) =>
                {
                    requestConfiguration.QueryParameters.Filter = "startswith(operatingSystem,'Win'),profileType eq 'RegisteredDevice',mdmAppId ne null"; // Corrected line
                    requestConfiguration.QueryParameters.Count = true;
                    requestConfiguration.Headers.Add("ConsistencyLevel", "eventual");
                });
                Console.WriteLine(devices);

Everything is according to what MS Graph has provided me. Could you help me because it's throwing that error? Thank you.

Answer 1

Hi @carlos carreno

From my testing, it seems that filtering the mdmAppId attribute is not supported. As a solution, try getting the device set and filtering it locally.

Code example:

var devices = await graphClient.Devices.GetAsync();

foreach (var device in devices.Value) {

    if (device.OperatingSystem.StartsWith("Win") && device.ProfileType is "RegisteredDevice" && device.MdmAppId != null) {

        Console.WriteLine(device.Id);
      
    }
}

Hope this helps.

If the reply is helpful, please click Accept Answer and kindly upvote it. If you have additional questions about this answer, please click Comment.