# Help with JSON arrays and matching item properties **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** listview, webapi, json\ **Created:** [May 1, 2019, 7:13pm UTC](https://community.thunkable.com/t/help-with-json-arrays-and-matching-item-properties/75661 "2019-05-01T19:13:13Z")\ **Posts on this page:** 1\ **Showing post:** 2
**Author:** ![domhnallohanlon](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/domhnallohanlon/32/29554_2.png) [@domhnallohanlon](https://community.thunkable.com/u/domhnallohanlon)\ **Post date:** [May 2, 2019, 12:06am UTC](https://community.thunkable.com/t/help-with-json-arrays-and-matching-item-properties/75661/2 "2019-05-02T00:06:35Z")
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](http://community.thunkable.com/t/need-help-decoding-a-json-response/75609/3): > > @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](http://community.thunkable.com/t/performing-a-vlookup-in-localdb/66057): > > One of the most powerful features in Thunkable is the new [LocalDB](https://docs.thunkable.com/thunkable-cross-platform/create/components/data/local-db) 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. question What is VLOOKUP? A [VLOOKUP](https://support.office.com/en-us/article/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1), or vertical lookup, allows you to search vertically down through a column of data and then find a corresponding value in your target row art Design Let’s start… --- _[View the full topic](https://community.thunkable.com/t/help-with-json-arrays-and-matching-item-properties/75661)._