Azure resource graph connection with Logic apps

Question

Azure resource graph connection with Logic apps

SPK545 36

hello,

Is there any way to connect Azure resource graph explorer with Logic apps, I'm trying to execute the below process in the automation process

1) I need to run a query from the Azure Resource graph and export those results on daily basis to the Azure database

2) I'm currently running query (KQL to know about resources in Azure) and exporting into CSV file, sending them manually

Please provide your thoughts

TIA

Pramod Valavala 20,656 Reputation points Microsoft Employee Moderator

2021-08-24T08:49:36.503+00:00

@SPK545 @Matteo Durini @John Joyner @Prerana Prajapat I believe you could use the Invoke Resource Operation for making the call here as well.

2 answers

Your answer

Pramod Valavala 20,656 Reputation points Microsoft Employee Moderator

2021-08-24T08:49:36.503+00:00

@SPK545 @Matteo Durini @John Joyner @Prerana Prajapat I believe you could use the Invoke Resource Operation for making the call here as well.

Answer 1

ChaitanyaNaykodi-MSFT 27,476 Microsoft Employee Moderator

Hello @SPK545 , apologies for the delay. My suggestion to automate the process above will be to perform queries using REST endpoint of Azure resource graph as using logic app you can call a HTTP endpoint using Azure Logic App.
For the first process you can have a Reoccurrence trigger for your logic app and then perform the HTTP action as mentioned above to run the query and use the Azure SQL database connector for Logic app to insert the results.
For the second process you can run the query as mentioned above and then use data operation functionality of the Logic App to write a CSV table and use any Email connectors Like Gmail or Outlook to send the data out.

Please let me know if there are any concerns. Thank you!

SPK545 36 Reputation points

2020-12-16T00:28:49.827+00:00

hello@ChaitanyaNaykodi-MSFT ,

I gone through the documentation and tried to do that but not sure how i can connect to the Azure resource graph execute the below query by using logic apps as shown in screesnhot

Can you please provide me a screenshot of which connectors I should use in the flow?

I've used the below URI to test the API connection, getting "401 unauthorized error "

https://management.azure.com/providers/Microsoft.ResourceGraph/resources?api-version=2020-04-01-preview
ChaitanyaNaykodi-MSFT 27,476 Reputation points Microsoft Employee Moderator

2020-12-17T20:41:25.86+00:00

Hello @SPK545 , apologies for missing this out, I think my name did not get tagged properly so I missed out on the notification. Based on your new post, did you find the resolution for the issue faced above?
John Joyner 41 Reputation points

2021-04-02T17:53:51.577+00:00

Hi @ChaitanyaNaykodi-MSFT did you resolve this? Needing to do the same thing finding it difficult. Thanks, John
Matteo Durini 1 Reputation point

2021-05-13T22:05:42.82+00:00

Hi, you are missing the Authentication part in the POST HTTP Call. As you can see in my screenshot, i'm doing a first HTTP Call to retrieve the Bearer token that i'm using in the second call: I prefer that approach because in the same logic app i'm doing several queries to the Azure APIs and i can easily reuse the same token
Matteo Durini 1 Reputation point

2021-05-13T22:07:18.667+00:00

Hi, you are missing the Authentication part in the POST HTTP Call. As you can see in my screenshot, i'm doing a first HTTP Call to retrieve the Bearer token that i'm using in the second call: I prefer that approach because in the same logic app i'm doing several queries to the Azure APIs and i can easily reuse the same token

Answer 2

Prerana Prajapat 46 Microsoft Employee

@ChaitanyaNaykodi-MSFT @SPK545 @John Joyner were you able to automate this process? I am facing similar challenge

Share via

Azure resource graph connection with Logic apps

2 answers

Your answer