How to retrieve JSON

(0) Share

Report

Posted on by yuri_f

Hello

I'm trying to register a JSON retrieved using an HTTP connector as an item in a SharePoint list.

However, the final process of parsing the value retrieved by the HTTP connector into JSON and uploading the parsed item to SharePoint causes an error.

I don't know what to fix, but does anyone know?

Failed to execute template action "Apply_to_each": "foreach" expression "@body (" JSON_parse ")? ['body']? ['result']' evaluates to the'Null' type. The result must be a valid array.

All responses (1)

Answers (1)

Verified answer

v-litu-msft on at

Like (0)

Report

Re: How to retrieve JSON

Hi @yuri_f,

The Apply to each action only accept an array, after parse JSON, please put the array part into the input of Apply to each action, for example:

For more information about the Apply to each (For each) action, please refer to this document:

Schema reference for trigger and action types - Azure Logic Apps | Microsoft Docs

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.