Action 'Invoke_an_HTTP_request' failed: The response is not in a JSON format.

(0) Share

Report

Posted on by nunuNMS

Hello Guys,

I am trying to get a bunch of rows from a dataverse table that I have using the HTTP Action, and it's not working. I tried adding the environment URL, didn't work, I also tried removing the filter it didn't work as well. If anyone can take a look at it, I would really appreciate it, thank you.

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (0)

Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report
First of all I see a small typo. Directly after the '413011-01004' I see a trailing space character. Make sure you remove that. Also make sure you include the environment url in the Url of the request field. And what did you use in the Base Resource URL and Azure AD Resource URI of the connection of the action?

Below is an example for the accounts table to demonstrate a similar setup.

Connection settings which uses the environment URL

Make sure you also use the OData headers in your configuration.

URI

https://org123456a.crm11.dynamics.com/api/data/v9.2/accounts?$filter=Name eq 'Contoso'

Headers

{ "Content-Type": "application/json", "OData-MaxVersion": "4.0", "OData-Version": "4.0" }

Out of interest, why aren't you using a List rows action instead? That should also work and is easier to setup.

Was this reply helpful? Yes No