Hello, I have a issue trying to get Mendix to be able to itterate over the variable amount of returns of my REST API. My REST API returns the following: { "data": { "Comp ID": 10001.0, "Type ID": 1 }, "values": [ { "Time Stamp": "Wed, 16 Feb 2022 23:59:57 GMT", "Value": 13549.0 }, { "Time Stamp": "Wed, 16 Feb 2022 23:59:50 GMT", "Value": 13549.0 }, { "Time Stamp": "Wed, 16 Feb 2022 23:59:43 GMT", "Value": 13549.0 }, { "Time Stamp": "Wed, 16 Feb 2022 23:59:36 GMT", "Value": 13549.0 }, { "Time Stamp": "Wed, 16 Feb 2022 23:59:29 GMT", "Value": 13549.0 } ] } Mapping is as follows: Microflow: Where values can have anywhere between 10 and 10000 values. I tried to call the rest and do a retrive dunction in the microflow, but it will not give me back a list, just an object. Is it somthing with my return from the API or am i just not doing the right thing in Mendix?
asked
Johan Kjølsøy
1 answers
2
Hi Johan,
You need to go one step further and retrieve JsonObject over Value object. This will provide you the list that you’re expecting.
All the values are stored inside the object Value as part of JsonObject objects.