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
More information
- 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
Posted at https://sl.advdat.com/3qiErMN
