Graph API query params doesn't works, getting default results only

Question

Hi All; I am facing a strange issue with Graph API.

While I have tried many different configurations (including the query params $filter, $top and header config),I keep getting the query's default 100 records.  "[https://graph.microsoft.com/v1.0/applications?$filter=startsWith(displayName](https://graph.microsoft.com/v1.0/applications?$filter=startsWith(displayName"https://graph.microsoft.com/v1.0/applications?$filter=startswith(displayname"), 'SearchText')"

Below are things I have already tried

• using various query parameters as provided at https://learn.microsoft.com/en-us/graph/query-parameters
• adding "ConsistencyLevel" = "eventual" to the header
• tried on different tenancies (business and personal)

But all the time, there is no change in the result.

Below is the code I'm using

$context = [Microsoft.Azure.Commands.Common.Authentication.Abstractions.AzureRmProfileProvider]::Instance.Profile.DefaultContext

            $graphToken = [Microsoft.Azure.Commands.Common.Authentication.AzureSession]::Instance.AuthenticationFactory.Authenticate($context.Account, $context.Environment, $context.Tenant.Id.ToString(), $null, [Microsoft.Azure.Commands.Common.Authentication.ShowDialog]::Never, $null, "https://graph.microsoft.com").AccessToken

            $pat = "Bearer $graphToken"

            $headers = @{

              "Authorization" = $pat

              "ConsistencyLevel" = "eventual"

              "Content-Type" = "application/json"

            }

            $applicationsURL = "https://graph.microsoft.com/v1.0/applications?$filter=startsWith(displayName, 'Text')&$top=999"

            $applications = Invoke-RestMethod -Method GET -Uri $applicationsURL -Headers $headers

Also, I tried with $applicationsURL = "https://graph.microsoft.com/beta/applications?$incorrectParam=true&$fail=true", which, too, is returning the same result while it should fail.

Answer 1

Hi @Vik

When I tested locally using your script, I had the same problem as you, it only seemed to return 100 app objects.

Since AAD PowerShell is about to be deprecated, I migrated it to MS graph PowerShell. After that it worked fine and returned all the data.

Connect-MgGraph -Scopes "Application.ReadWrite.All"
Import-Module Microsoft.Graph.Applications
$appLists = Get-MgApplication -Top 999 -CountVariable CountVar  -ConsistencyLevel eventual 
$appLists.Count

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.

Answer 2

Hi Vik, Can you try to call the endpoint from Graph Explorer? I have tried it and see the response objects not limited to 100 records (as Max Limit should be 999). This is sample endpoint been called : https://graph.microsoft.com/v1.0/applications?$filter=startswith(DisplayName,'Test')&$top=999&$count=true i have registered 126 apps from App Registration start with Test. Below is the result as you can see the count return is 126

Hope this helps. If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Answer 3

Hi Diah.Karim-MSFT, thanks for looking into this. Although I haven't tried with Graph Explorer, even if it did, I won't be able to use that for an automated solution. Did you get a chance to run the code I have provided?

Answer 4

Hi Diah.Karim-MSFT, thanks for looking into this. Although I haven't tried with Graph Explorer, even if it did, I won't be able to use that for an automated solution. Did you get a chance to run the code I have provided?