Share
Report
39Hi All,
I have a json output, that I get through an API. It contains quite a lot of information, but I am only interested in 2 values, farmID and PartID.
I have been trying to use Parse JSON to read the data, and to input the fields into a variable of type array, but for some reason, even though visualy the output of the parse json is fine, whenever i try to use the data, the value comes back as NULL.
(I have also tried using single variables and somehow loop through those using the json data, but that also didnt work
I am thinking my schema for the parse json maybe the culprit, but I dont know how to check. The schema is created by uploading a sample json in the field in power automate. ( i have tried both the full output, as a cleaned up version with just some fields)
Anybody any ideas, or maybe have a better idea on how i can use those two specific fields to create a loop? What i need to achieve is use a combination of farmid and partyID to get specific data, and do that for about roughly 30 combinations of farmID and partyID
Do i maybe need to use an expression to get a specific field from the json array?
EDIT:
I have completely stripped the json to:
But when i go to fill the variable, i can only choose "body farms" but dont I somehow have to tell it to fill it with Body farms [0]?
Below some extra information
----------------------------------------------------------------
The error:
-------------------
Pasre json result: (there are multiple farms, this is just 1)
------------------------------
JSON Sample (from postman)
------------------
Schema
All responses (
Answers (
