Connect Microsoft power platform to vault sql server

[Brett.Trimpe]

Is it possible to connect Microsoft power apps to the vault sql server to pull metadata information? If not, is there a secondary way to populate power apps with that data?

thanks!

[Nick_Hall]

Hi Brett

As I understand it, to create a custom connector on Microsoft Power Platform requires a REST API

Vault doesn't have one - see https://forums.autodesk.com/t5/vault-customization/is-there-any-existing-rest-api-to-connect-to-vaul... - so you would have to write your own

See also this on the Ideas Board - https://forums.autodesk.com/t5/vault-ideas/better-reporting-with-help-of-microsoft-powerbi-or-tablea...

And in particular this suggestion from @ihayesjr for a possible workaround - https://forums.autodesk.com/t5/vault-ideas/better-reporting-with-help-of-microsoft-powerbi-or-tablea...

The AU class it refers to is here - https://www.autodesk.com/autodesk-university/class/Dashboard-Smashboard-Vault-Reporting-Steroids-201...  

Hope it helps

Nick

[Markus.Koechl]

Please note the idea mentioned here changed its state to accepted. So stay tuned and join the Vault feedback portal to discuss future options/solutions.

[Nick_Hall]

@Markus.Koechl 

I'm intrigued ... Can't wait

[igorp74ZKN]

any update? 

[JelteDeJong]

With Vault 2025.2, Autodesk introduced a new REST API that makes it easier to connect external tools like Power Automate Desktop to Vault. I’m currently working on two blog posts that explore this integration:

1. How to add a job to the Vault job queue using Power Automate (link)
2. How to report the number of checked-out files in a Vault using Power Automate (link)

You can find both posts on GitHub. Feedback is always welcome!

[Nick_Hall]

Hi Jelte

I've been meaning to do something like this for ages, so thank you for

1. Reminding me to do it
2. Rekindling my desire to do something
   and
3. Doing the "grunt work, saving me a lot of time

Nick