Power Platform Community Forum Thread Details

I'm having problems using the Invoke Web Request step. I have this AI generated cURL command that works as expected [1]:

curl -X POST https://adb-<workspaceId>.azuredatabricks.net/api/2.0/sql/statements/ \
-H "Authorization: Bearer <myPersonalAccessToken>" \
-H "Content-Type: application/json" \
-d '{
  "warehouse_id": "<myWareHouseId>",                                                                                     
  "catalog": "hive_metastore",                                                                                            
  "schema": "dev.bronze",                                                                                              
  "statement": "SELECT * FROM dev.bronze.shawn_test_table;"
}'

Unfortunately, I can't get it to work correctly in Power Automate (See Picture Below):

When I run the Power Automate debugger and stop in the Set Variable step, I see that my WebServiceRequest variable was set to the value:
{"error_code":"MALFORMED_REQUEST","message":"Invalid JSON given in the body of the request - failed to parse given JSON"}

This implies that the Invoke Web Service request step failed. I suspect the problem is that I'm not formatting my JSON the way Power Automate wants me to in the Request Body field of the Invoke Web Service dialog. When I use the real values for <myPersonalAccessToken> , <workspaceId> and <myWareHouseId> my JSON is valid, but I do have a few questions:

Does Power Automate require me to format the JSON for my Request Body in some special manner?
Am I using the proper method to pass JSON via Invoke Web Service?

If you are interested, you can also see a slightly modified version of this question here on StackOverflow (SO):
https://stackoverflow.com/questions/78903351/how-do-i-pass-json-data-in-the-desktop-version-of-power-automate

[1] - The query has been sanitized to remove sensitive data prior to posting here and on SO.

Categories:

Power Automate Desktop