Help with JSON arrays and matching item properties

[domhnallohanlon]

Hi @mreyeball welcome to the Thunkable - just in relation to working with JSON, there’s a helpful post here:

[Solved] Need Help Decoding a JSON Response

@Charles_Casteel, The key here is understanding a little bit about the way that JSON text represents lists and objects. When you see something that begins with a '{' ( for example '{ _embedded: { events: ... ' ) that means that that the JSON text represents an object. When you see something that begins with a '[' ( for example '... [ { name: "Adam Sandler", ...' ) then that represents a list. It get a little more complicated, of course, because objects can contain lists within them and lists…

And in relation to retrieving the matching properties for an object, something like this might guide you? The approach I took was to store the ListItem index in a variable, and then based on that value get all the data that corresponded to that index.

Performing a VLOOKUP in LocalDB

One of the most powerful features in Thunkable is the new LocalDB component, which allows you to insert a mini-spreadsheet directly into your app. This might be the first of a larger series of tutorials mimicking features found in other spreadsheets, but for now let’s get started with VLOOKUP. What is VLOOKUP? A VLOOKUP, or vertical lookup, allows you to search vertically down through a column of data and then find a corresponding value in your target row Design Let’s start…