how can i find a specific item in a json list?
I have a list with several items that are in json, as shown in the screenshot, how can I select an item without knowing its position, for example
Value.Condominium equal to Campos do Jordão
How can I do this?
Use the map() function.
The way it works is, from A(array) get B(object in the array) where C equals D
Map(A; B; C; D)
An array has to go in A, then the property of the object that you want to get goes in B, then in C, goes another property of that same object, finally D is the value of C(typed out)
Hey Joao,
firstly open the settings of the Make a request module and tell it to parse the JSON response it is getting. The lets see what the data looks like and what you are trying to retrieve.
Your “Data” is a STRING, not an array, so you cannot use a map function on it.
To convert a json STRING into an ARRAY, use the Parse JSON module, or
In your HTTP module settings “Parse response” field, select “YES” (it is “No” by default)
This will allow you to map the response collection properties (variables) in subsequent modules.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
