Unanswered

The property 'content' must be of type JSON in the 'ParseJson' action inputs, but was of type 'image/png' error

(1) Share

Report

Posted on by cbernier12

248

Hi, I'm running into the following error: "The property 'content' must be of type JSON in the 'ParseJson' action inputs, but was of type 'image/png'."

I'm using an HTTP action to call an external API that only turns the two objects shown in the image. How would I parse this as JSON or fix this error?

Categories:

General topics

I have the same question (0)

All responses (17)

Answers (0)

Jcook 7,781 Most Valuable Professional on at

Like (0)

Report

Hello @cbernier12

Can you use the expression Json(<''Your HTTP Trigger Body>)

in the 'Parse JSON' action.

If that does not work, can you share a sample of the trigger body

Was this reply helpful? Yes No
cbernier12 248 on at

Like (0)

Report

@Jcook
The trigger is Power Apps with a bunch a variables sent over then I run the HTTP action with those variables to create the base64 image string (QR code). The values of $content and $content-type are all the output I have to work with. When sent back to Power Apps it says it needs to be in the for of a JSON array to populate the collection with the values. Not sure how to do that in Power Automate though. I some how need to make a valid JSON array from the two values returned from the HTTP query.

Was this reply helpful? Yes No
Jcook 7,781 Most Valuable Professional on at

Like (0)

Report
Hi @cbernier12

Could you share a screenshot of your full flow.

What are you passing into the Parse JSON action? Is it possible to change/add header in the HTTP action to have

Content-Type: application/json

Was this reply helpful? Yes No
cbernier12 248 on at

Like (0)

Report

Hi adding the header didn't work, the content type remains as image/png.

I need to convert the following HTTP result to json, is that possible?

{
"$content-type": "image/png",
"$content": "iVBORw0KGgoAAAANSUhE...etc..."
}

Was this reply helpful? Yes No
Jcook 7,781 Most Valuable Professional on at

Like (0)

Report

Hello @cbernier12

It looks like Power Automate is trying to use the picture itself and not the values.

I got around this by converting the JSON image into a JSON Array.

Was this reply helpful? Yes No
cbernier12 248 on at

Like (0)

Report

So for compose would I use the "body" of the HTTP output?

For initialize variable what's the function look like in the value field? I can't tell from the image.

In the parse json action, where is the array value coming from and where did you get the schema?

Was this reply helpful? Yes No
Jcook 7,781 Most Valuable Professional on at

Like (0)

Report
Hi @cbernier12

1. So you don't need a Compose. I am just using a Compose action to simulate your HTTP Body. So instead of using Compose, use the HTTP Body.

2. The expression for the variable is:

array(outputs('Compose'))

Replace the Compose with

array(<HTTP BODY>)

3. The array value is the Array Variable that we used the array() expression. From step 2, notice how the name of my variable is 'array'

Here is the schema:

{ "type": "array", "items": { "type": "object", "properties": { "$content-type": { "type": "string" }, "$content": { "type": "string" } }, "required": [ "$content-type", "$content" ] } }

Was this reply helpful? Yes No
cbernier12 248 on at

Like (0)

Report

Ok what I added is initialize variable, parse JSON, and Response actions and the output looks ok, however the actual values don't make to the Power Apps collection, the columns do, just not the values. Any idea on how to send the the values of content-type and content to Power Apps? The flow is run from Power Apps and as stated the two columns in the collection are created.

This is the successful output in the Response action:
[
  {
    "$content-type": "image/png",
    "$content": "iVBORw0KGgoAAAANSUhEUgAAAJYAAACWAQMA.........."
  }
]

Was this reply helpful? Yes No
Jcook 7,781 Most Valuable Professional on at

Like (0)

Report

Hi @cbernier12

What exactly is the expected outcome? Are you trying to get the Image into Power Apps?

Was this reply helpful? Yes No
cbernier12 248 on at

Like (0)

Report

Need both values for content and content-type to show up in the Power Apps collection.

Was this reply helpful? Yes No