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

[cbernier12]

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?

[Jcook]

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

[cbernier12]

@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.

[Jcook]

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

[cbernier12]

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..."

}

[Jcook]

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.

[cbernier12]

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?

[Jcook]

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"
        ]
    }
}

[cbernier12]

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.........."

  }

]

[Jcook]

Hi @cbernier12 

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

[cbernier12]

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

[cbernier12]

@Jcook never mind, needed to remove and re-add the Flow data object from data sources and it started working.  I forgot to do that...

[Jcook]

Hi @cbernier12 

Awesome to hear, could you mark a post as a solution. (This could be your post as well) Which ever reply was the solution to your question. 

[rdobryanskyy]

To use a part of the output, try to use this in expressions:

outputs('Action_name')?['body/$content']

[McRoe]

Instead of creating a separate Array you can also use [<your compose output>], works for me. See below. Dump the json first in a compose, so you can copy the schema for the Generate from sample.

.

[Drupad_Prabhu]

Hi @cbernier12 & @Jcook , I am stuck with the same issue. Could you please take a look at my flow and help me out. I am trying to send out an email with the QR code (PNG file) that is being generated using the HTTP. Could you please let me know what the next steps on this. Thanks

This is the successful output in the Response action:

{

  "$content-type": "image/png",

  "$content": "iVBORw0KGgoAAAANSUhEUgAAA....etc

}

[mercobenitas]

Try adding a compose after your HTTP action. Insert your HTTP output in this. Then use what rdobryanskyy wrote to get the content (rename Action_name):

outputs(‘Action_name’)?[body/$content’]

[Drupad_Prabhu]

Hi @mercobenitas,

I add a compose after my HTTP action. Insert my HTTP output in this. Then used what rdobryanskyy wrote to get the content (rename Action_name):

outputs(‘Action_name’)?[body/$content’]

See outputs:

Is this right? if so, what are the next steps.

FYI: what I am trying to do is: When a user submits a MS form, an API call is sent to the QR code generator tool using HTTP when gets back the following output:

{

  "$content-type": "image/png",

  "$content": "iVBORw0KGgoAAAANSUhEU....etc

}

Now I would want to convert this HTTP output into an QR code image file (PNG) and attach it to the email so that it can be sent out via email.

Please help me out with the next steps.

CC: @cbernier12 @cbernier12 @rdobryanskyy