This article is contributed. See the original author and article here.
Day by day the API connections will keep growing up
As clean up, I will show below how to use the Azure Resource Graph to make query against the API and logic app to find all the unused API
resources | where type =~ 'Microsoft.Web/connections' |project id |join kind= leftouter ( resources | where type == 'microsoft.logic/workflows' |extend propertiesJson=parse_json(properties) |extend ConJson=propertiesJson["parameters"]["$connections"]["value"] |mvexpand Conn=ConJson |where notnull(Conn) |extend connectionId=extract(""connectionId":"(.*)"",1,tostring(Conn)) |project connectionId ) on $left.id==$right.connectionId
the query above join ‘microsoft.logic/workflows’ with ‘Microsoft.Web/connections’ and find all the unused connections
- Learn more about Kusto link
- Azure Resource Graph Deep Dive – YouTube
- mv-expand operator – Azure Data Explorer | Microsoft Docs
- todynamic(), parse_json() functions – Azure Data Explorer | Microsoft Docs
Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.