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?

All responses (3)

Answers (0)

Deekshit Addepalli on at

Like (0)

Report

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

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?
agneum 150 on at

Like (0)

Report

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

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
Martin Dráb 231,821 Most Valuable Professional on at

Like (0)

Report

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

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.