How to get all rows from Resource Graph from Logic Apps

Raj Bhat 21 Microsoft Employee

Hi, In Logic Apps I am trying to get data from Resource Graph using HTTP Rest API. However, I see it returning only 1000 rows. How can I get it to retrieve all rows. Thanks.

Dillon Silzer 57,231 Reputation points

2022-09-11T21:42:14.953+00:00

What does your current GET/POST and Body look like in your Logic App?

Raj Bhat 21 Microsoft Employee

Get_VM_names_from_Resources": {

            "inputs": {  

                "authentication": {  

                    "type": "ManagedServiceIdentity"  

                },  

                "body": {  

                    "query": "Resources|where type=~'microsoft.compute/virtualmachines'|extend image_id=parse_json(properties).storageProfile.imageReference.id|extend image_name=split(image_id,'/')[-1]|extend computername=parse_json(properties).osProfile.computerName|where image_name startswith 'oracle_'|project vmname=computername,longname=name|where vmname !contains 'jump' and longname contains '-db-'"  

                },  

                "headers": {  

                    "Content-Type": "application/json"  

                },  

                "method": "POST",  

                "uri": "https://management.azure.com/providers/Microsoft.ResourceGraph/resources?api-version=2021-03-01"  

            },

1 answer

Raj Bhat 21 Reputation points Microsoft Employee

2022-09-11T22:32:11.337+00:00
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

How to get all rows from Resource Graph from Logic Apps

1 answer

Your answer