Cannot make even simple JSON commands work

Hi all,

I have been trying all morning to use a simple JSON statement just to learn how to pull data from that kind of source. I found this example in another thread. The only difference is that perhaps the old example used the previous version of Thunkable where the “get property of object block”?

Here is my sample JSON which is hardcoded into the block.

[
{“cat_id”:“1”,“category”:“Love”,“status”:“1”},
{“cat_id”:“2”,“category”:“Romantic”,“status”:“1”},
{“cat_id”:“3”,“category”:“Friendship”,“status”:“1”},
{“cat_id”:“4”,“category”:“Attitude”,“status”:“1”}
]

When I click the button in liveview it just clears the test area.

What am I missing here? I started with an actual Airtable API, everything connects fine, but trying to pull objects from it keeps giving me undefined. So I went to the most simple example I could find and I cannot get this to work.

Many thanks for any help anyone can provide.

Edit: I used the same blocks as you and got it to work.

But I re-build the JSON string. Here’s what I used:

[{“cat_id”:“1”,“category”:“Love”,“status”:“1”}, {“cat_id”:“2”,“category”:“Romantic”,“status”:“1”}, {“cat_id”:“3”,“category”:“Friendship”,“status”:“1”}, {“cat_id”:“2”,“category”:“Attitude”,“status”:“1”}]

It looks the same as yours, right? There must be something missing in yours, though.

Your JSON includes brackets which designate a list. So when you’re retrieving the data, you’d have to first get the first list item of app data and then get the third item of that list and then get the property (“category”) of that item.

Also, you’ve initialized app data as a list but then turned it into an object. I don’t think you can do list manipulation on objects.

I see where you read this: How to create Dynamic List View for display all json data - #9 by User81.

I’m not 100% sure that’s properly-formatted JSON. I use this site to verify JSON strings: https://jsonformatter-online.com.

I’m going to see if I can work up a demo…

Here, try this:

https://x.thunkable.com/copy/ec30adcde504bbeb0b62bca3a1dddf4a

Thank you, that was very helpful! I really thought I was losing my mind for a while. If the JSON data is not properly formatted, it stops the whole show.

Thanks again for your help.