Answered

how to output string value out of json parse ?

(0) Share

Report

Posted on by vnguyen1

hi,

i have an issue to output a value . Example below is the output. I need to get the 1st media_type = ' image/jpeg" out of this.

{
"images": [
{
"id": "875871070",
"download_sizes": [
{
"bytes": 69498,
"height": 416,
"media_type": "image/jpeg",
"name": "x_small",
"width": 416
},
{
"bytes": 109213,
"height": 594,
"media_type": "image/jpeg",
"name": "small",
"width": 594
},
{
"bytes": 375336,
"height": 1735,
"media_type": "image/jpeg",
"name": "medium",
"width": 1735
},
{
"bytes": 1255700,
"height": 4000,
"media_type": "image/jpeg",
"name": "large",
"width": 4000
},
{
"bytes": 12135563,
"height": 4000,
"media_type": "image/eps",
"name": "vector",
"width": 4000
}
]
}
],
"images_not_found": []
}

below is my json :

{
"type": "object",
"properties": {
"image": {
"type": "array",
"items": {
"type": "object",
"properties": {
"id": {
"type": "string"
},
"download_sizes": {
"type": "object",
"properties": {
"bytes": {
"type": "string"
},
"height": {
"type": "string"
},
"media_type": {
"type": "string"
},
"name": {
"type": "string"
},
"width": {
"type": "string"
}
}
}
}
}
}
}
}

this is the error message i got when trying to output the 'image/jpeg' :

ExpressionEvaluationFailed. The execution of template action 'Apply_to_each_2' failed: the result of the evaluation of 'foreach' expression '@body('ParseFindMediaType')?['image']' is of type 'Null'. The result must be a valid array.

Please advice and thanks in advance

Categories:

Using flows

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Verified answer

v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @vnguyen1,

The property name in the Apply to each input should be body('Parse_JSON')?['images'], not body('Parse_JSON')?['image'], and the stcuture as below:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
vnguyen1 40 on at

Like (0)

Report
Copy link

Link copied!

Thanks @v-litu-msft for the response. however, i still got the same error message either (1) or (2). Please advice

(1)

(2)

Was this reply helpful? Yes No
v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @vnguyen1,

It is images, not image:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
vnguyen1 40 on at

Like (0)

Report
Copy link

Link copied!

@v-litu-msft i got below error when update image to images in jason.Please advice

{
  "type": "object",
  "properties": {
    "images": {
      "type": "array",
      "items": {
        "images_not_found": {
          "type": "object",
          "properties": {}
        },
        "type": "object",
        "properties": {
          "id": {
            "type": "string"
          },
          "download_sizes": {
            "type": "object",
            "properties": {
              "bytes": {
                "type": "string"
              },
              "height": {
                "type": "string"
              },
              "media_type": {
                "type": "string"
              },
              "name": {
                "type": "string"
              },
              "width": {
                "type": "string"
              }
            }
          }
        },
        "required": [
          "media_type",
          "id"
        ]
      }
    }
  }
}

[
  {
    "message": "Invalid type. Expected Object but got Array.",
    "lineNumber": 0,
    "linePosition": 0,
    "path": "images[0].download_sizes",
    "schemaId": "#/properties/images/items/properties/download_sizes",
    "errorType": "type",
    "childErrors": []
  },
  {
    "message": "Required properties are missing from object: media_type.",
    "lineNumber": 0,
    "linePosition": 0,
    "path": "images[0]",
    "value": [
      "media_type"
    ],
    "schemaId": "#/properties/images/items",
    "errorType": "required",
    "childErrors": []
  }
]

Was this reply helpful? Yes No
vnguyen1 40 on at

Like (0)

Report
Copy link

Link copied!

@v-litu-msft below is how i set it up and got the error in jason.Please advice

[
  {
    "message": "Invalid type. Expected Object but got Array.",
    "lineNumber": 0,
    "linePosition": 0,
    "path": "images[0].download_sizes",
    "schemaId": "#/properties/images/items/properties/download_sizes",
    "errorType": "type",
    "childErrors": []
  },
  {
    "message": "Required properties are missing from object: media_type.",
    "lineNumber": 0,
    "linePosition": 0,
    "path": "images[0]",
    "value": [
      "media_type"
    ],
    "schemaId": "#/properties/images/items",
    "errorType": "required",
    "childErrors": []
  }
]

Was this reply helpful? Yes No
v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @vnguyen1,

Please try to use the JSON schema:

{ "type": "object", "properties": { "images": { "type": "array", "items": { "type": "object", "properties": { "id": { "type": "string" }, "download_sizes": { "type": "array", "items": { "type": "object", "properties": { "bytes": { "type": "integer" }, "height": { "type": "integer" }, "media_type": { "type": "string" }, "name": { "type": "string" }, "width": { "type": "integer" } }, "required": [ "bytes", "height", "media_type", "name", "width" ] } } }, "required": [ "id", "download_sizes" ] } }, "images_not_found": { "type": "array" } } }

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No