question

Meenakshi-2325 avatar image
0 Votes"
Meenakshi-2325 asked MayankBargali-MSFT edited

ARM Connector in Logic Apps to list subscriptions has limitation of listing 1000 subscriptions

I was using Logic app "Azure Resource Manager Connector" to List subscriptions within a tenant but it only returns 1000 subscriptions as output by default. Also, it does not have pagination settings to increase this default value. Moreover, I referred this document also - https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-exceed-default-page-size-with-pagination, which also shows that we cannot increase default page size of "ARM" connector.

How this could be achieved?

azure-logic-apps
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

MayankBargali-MSFT avatar image
0 Votes"
MayankBargali-MSFT answered MayankBargali-MSFT edited

@Meenakshi-2325 Thanks for reaching out. I will reach out to my team for confirmation as I don't see any I don't see any configuration on the List Subscription action as of now. This could be limitation of the connector as of now, but I will reach out to the team for confirmation and update this answer.

For now, as the workaround you can leverage the HTTP connector or Http with Azure AD connector and call the List Subscription REST API that will return all the subscription ID and nextlink in scenario the result cannot be return in the signal REST call. You can write your condition in workflow to call the List Subscription REST API till the nextLink value is empty/null based on the response.

193792-image.png

Update:
Unfortunately, as of now this is the limitation of ARM connector. Feel free to create the feature request here. As the workaround you need to leverage the Native HTTP connector and call the respective REST APIs.


image.png (44.3 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @MayankBargali-MSFT ,
I am not able to find any nextLink key in the response of List Subscriptions API as mentioned here - https://docs.microsoft.com/en-us/rest/api/resources/subscriptions/list#subscriptionlistresult.

I am attaching the response and screenshot of response, I have got from List Subscriptions API.
193816-image.png

193807-sub-response.txt


0 Votes 0 ·
image.png (70.5 KiB)
sub-response.txt (3.1 KiB)

@Meenakshi-2325 Thanks for your response. In scenario where the single response doesn't have all the results then only you will get the nextlink in your response else would be missing/empty. In your case as the result is 5 subscription it doesn't contain the nextlink in response property.

For example, I have tested the Resources API in one of my subscription where I have more than the limit result for single response you can see nextlink in my response. In other case where I have few resources in another subscription the nextlink was missing and the same is applicable to other API's

193855-image.png


0 Votes 0 ·
image.png (71.1 KiB)
image.png (69.8 KiB)