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?
[1] - The query has been sanitized to remove sensitive data prior to posting here and on SO.