How do I call "ExecuteProcedure" API method using REST or Powershell?

(0) Share

Report

Posted on by agneum

150

The following documentation for connectors shows that it's possible to call an operation called "ExecuteProcedure". Currently I use it in a flow (power automate), but would like to use it in a powershell script as well.

https://docs.microsoft.com/en-us/connectors/dynamicsax/#execute-action

So far I've created an app in Azure, given all D365 API permissions to it and added it to D365 under system administration. I've successfully been able to get a token and retrieve some data from entities with OData. All I need now is the correct Uri, method, body and whatever to call ExecuteProcedure.

Has anyone done something similar or has any ideas on how I can use this connector?

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Martin Dráb 239,385 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Is your goal to trigger Power Automate or to call an OData service? If the latter, forget ExecuteProcedure, because it's a part of Power Automate and not of D365FO. The OData service is covered here.

Was this reply helpful? Yes No
agneum 150 on at

Like (0)

Report
Copy link

Link copied!

It is to call an OData service or the API somehow. So it seems I will have to trigger the flow from the script or just use the flow on its own. Thanks

Was this reply helpful? Yes No
Deekshit Addepalli Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Are you trying to just make an oData request via Powershell? If so, I think you're on the right path and you would use the Invoke-Restmethod call with the -Uri paramter. So something like this

Invoke-RestMethod -Uri $ODATA_CALL -Method Get -Headers $headers -ContentType -application/json

the $headers variable will contain your bearer token.

Is this what you're looking for?

Was this reply helpful? Yes No