# 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:** 3\ **Page:** 1
**Author:** ![mreyeball](https://avatars.discourse-cdn.com/v4/letter/m/9f8e36/32.png) [@mreyeball](https://community.thunkable.com/u/mreyeball)\ **Post date:** [May 1, 2019, 7:13pm UTC](https://community.thunkable.com/t/help-with-json-arrays-and-matching-item-properties/75661/1 "2019-05-01T19:13:13Z")
I’ve searched and found some helpful info, but not the magic bullet to solving my issue. I am retrieving JSON from a web API, which is going fine. A JSON object is returned which contains a list, each list item has several properties. I’m trying to accomplish a couple of things: 1. Item names populating a list viewer (I got this part working fine). 2. When an item in the list viewer is pressed, the rest of that list item’s properties should be retrieved to be displayed. This is where I’m having trouble…I can get a list of item names out of the JSON just fine, but how to then go back and retrieve the other properties for the object who’s name matches the one selected? ---
**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… ---
**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\ **Post date:** [November 8, 2024, 12:13pm UTC](https://community.thunkable.com/t/help-with-json-arrays-and-matching-item-properties/75661/3 "2024-11-08T12:13:54Z")