# Get Object from json using GetColumn **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [July 10, 2019, 4:05pm UTC](https://community.thunkable.com/t/get-object-from-json-using-getcolumn/138730 "2019-07-10T16:05:28Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![sysads](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/sysads/32/44975_2.png) [@sysads](https://community.thunkable.com/u/sysads)\ **Post date:** [July 10, 2019, 4:05pm UTC](https://community.thunkable.com/t/get-object-from-json-using-getcolumn/138730/1 "2019-07-10T16:05:28Z")
Would really appreciate if anyone could help me or guide me with blocks on how to get an object value i.e. “url” from following json format generated using **GetColumn** : [[{“id”:“xxx”,“url”:“[https://xxxx.jpg](https://xxxx.jpg)”,“filename”:“xxx.jpg”,“size”:xxx,“type”:“xxx”,“thumbnails”:{“small”:{“url”:“[https://xxx](https://xxx)”,“width”:xxx,“height”:xx},“large”:{“url”:“[https://xxx](https://xxx)”,“width”:xxx,“height”:xx},“full”:{“url”:“[https://xxx](https://xxx)”,“width”:xxx,“height”:xx}}}],[{“id”:“xxx”,“url”:“[https://xxxx.jpg](https://xxxx.jpg)”,“filename”:“xxx.jpg”,“size”:xxx,“type”:“xxx”,“thumbnails”:{“small”:{“url”:“[https://xxx](https://xxx)”,“width”:xxx,“height”:xx},“large”:{“url”:“[https://xxx](https://xxx)”,“width”:xxx,“height”:xx},“full”:{“url”:“[https://xxx](https://xxx)”,“width”:xxx,“height”:xx}}}]] ---
**Author:** ![sysads](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/sysads/32/44975_2.png) [@sysads](https://community.thunkable.com/u/sysads)\ **Post date:** [July 10, 2019, 7:33pm UTC](https://community.thunkable.com/t/get-object-from-json-using-getcolumn/138730/2 "2019-07-10T19:33:29Z")
Anyone with any clue? ---
**Author:** ![Hayder](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/hayder/32/153829_2.png) [@Hayder](https://community.thunkable.com/u/Hayder)\ **Post date:** [July 10, 2019, 9:50pm UTC](https://community.thunkable.com/t/get-object-from-json-using-getcolumn/138730/3 "2019-07-10T21:50:12Z")
Hey Would you share some screenshot of your blocks and Airtable, please? ---
**Author:** ![sysads](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/sysads/32/44975_2.png) [@sysads](https://community.thunkable.com/u/sysads)\ **Post date:** [July 10, 2019, 10:02pm UTC](https://community.thunkable.com/t/get-object-from-json-using-getcolumn/138730/4 "2019-07-10T22:02:59Z")
Hi, my airtable has 7 columns Col1 & 2 are text Col 3 is number Col 4 & 5 both Attachment Col 6 is Link Col 7 is Text Column Name I need image from is called “GTP Images” ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/d/4d40347c0bdb23e85806287c7f84365022f3f71f.png) ---
**Author:** ![CBVG](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/cbvg/32/32401_2.png) [@CBVG](https://community.thunkable.com/u/CBVG)\ **Post date:** [July 10, 2019, 10:36pm UTC](https://community.thunkable.com/t/get-object-from-json-using-getcolumn/138730/5 "2019-07-10T22:36:17Z")
Just a thing here. You are extracting a column, with the result going into a local variable object named “column” which you are not using after; and you have a reference to an object named “value” which is never assigned to anything. Perhaps that is the issue here. ---
**Author:** ![sysads](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/sysads/32/44975_2.png) [@sysads](https://community.thunkable.com/u/sysads)\ **Post date:** [July 10, 2019, 10:42pm UTC](https://community.thunkable.com/t/get-object-from-json-using-getcolumn/138730/6 "2019-07-10T22:42:42Z")
Sorry that value was meant to be column. Was doing another test with that before reverting back to GetColumn. Updated the image now. The Label text shows “undefined” ---
**Author:** ![kartik\_old](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kartik_old/32/28305_2.png) [@kartik\_old](https://community.thunkable.com/u/kartik_old)\ **Post date:** [July 11, 2019, 1:16am UTC](https://community.thunkable.com/t/get-object-from-json-using-getcolumn/138730/7 "2019-07-11T01:16:50Z")
Hello there, You just want to get URL from only the 1st row right? Try this : ![temp](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/b/3bc9b4b7e3c4c527cb716ac5d92543bfb7755fa4.png) Hope it helps! 😉 Thanks! 😄 ---
**Author:** ![sysads](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/sysads/32/44975_2.png) [@sysads](https://community.thunkable.com/u/sysads)\ **Post date:** [July 11, 2019, 1:56am UTC](https://community.thunkable.com/t/get-object-from-json-using-getcolumn/138730/8 "2019-07-11T01:56:47Z")
I know this already but this just gets row 1 image and not the entire images in that column at once ---
**Author:** ![kartik\_old](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kartik_old/32/28305_2.png) [@kartik\_old](https://community.thunkable.com/u/kartik_old)\ **Post date:** [July 11, 2019, 2:50am UTC](https://community.thunkable.com/t/get-object-from-json-using-getcolumn/138730/9 "2019-07-11T02:50:33Z")
Ok. > [@sysads](#): > Your given blocks display only one image’s block… (That’s why I gave only image’s blocks 😅) Can u clearly say _ **What do you want to achieve - get URL from AirTable / single images to display or 3 images to display?** _ I can’t get u… Thanks! ---
**Author:** ![CBVG](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/cbvg/32/32401_2.png) [@CBVG](https://community.thunkable.com/u/CBVG)\ **Post date:** [July 11, 2019, 2:55am UTC](https://community.thunkable.com/t/get-object-from-json-using-getcolumn/138730/10 "2019-07-11T02:55:49Z")
What do you mean “entire images”? If you are getting the URL saved in “Label1.Text”, then it can only be _one_ URL. It is not a list, it is a single entry. Or am I misunderstanding something? ---
**Author:** ![sysads](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/sysads/32/44975_2.png) [@sysads](https://community.thunkable.com/u/sysads)\ **Post date:** [July 11, 2019, 4:20am UTC](https://community.thunkable.com/t/get-object-from-json-using-getcolumn/138730/11 "2019-07-11T04:20:24Z")
I have 30 rows each with image in GTP Images column. I want to read all images in column into a list and pick each url as background images. If I use GetCell, then I have to repeat that 30 times which will make code too large ---
**Author:** ![CBVG](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/cbvg/32/32401_2.png) [@CBVG](https://community.thunkable.com/u/CBVG)\ **Post date:** [July 11, 2019, 7:03am UTC](https://community.thunkable.com/t/get-object-from-json-using-getcolumn/138730/12 "2019-07-11T07:03:34Z")
Perhaps, but if you are trying to stuff all the URL in a single _string_, that will not work. I do not see any list in your blocks. And I do not see any loop that would process multiple URL. ---
**Author:** ![Hayder](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/hayder/32/153829_2.png) [@Hayder](https://community.thunkable.com/u/Hayder)\ **Post date:** [July 11, 2019, 8:33am UTC](https://community.thunkable.com/t/get-object-from-json-using-getcolumn/138730/13 "2019-07-11T08:33:47Z")
Follow these steps please. I hope it helps you out. 1. Set the column Type of “GTP Images” in Air Table to “A single line text” 2. You can manage visible to True/False to list viewer “I am sure it easy for you to manage” because I post a screen shot of how you VIEW all images and how to GET a specific image to be as a background. ![Capture](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/5/2553372a25d23dbe26d12d5cce35c92c54d5e265.png) My regards! Hayder ---
**Author:** ![kartik\_old](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kartik_old/32/28305_2.png) [@kartik\_old](https://community.thunkable.com/u/kartik_old)\ **Post date:** [July 11, 2019, 8:48am UTC](https://community.thunkable.com/t/get-object-from-json-using-getcolumn/138730/14 "2019-07-11T08:48:53Z")
Just don’t place the **Screen2 opens** block two times 😅 They both are the same… ---
**Author:** ![Hayder](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/hayder/32/153829_2.png) [@Hayder](https://community.thunkable.com/u/Hayder)\ **Post date:** [July 11, 2019, 9:05am UTC](https://community.thunkable.com/t/get-object-from-json-using-getcolumn/138730/15 "2019-07-11T09:05:48Z")
Thanks mate! As I built this as fast as I can, I forgot to change the other one to “Start” LOL Now I hope my suggestion to be a solution to his problem because I tested it and it works. ---
**Author:** ![sysads](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/sysads/32/44975_2.png) [@sysads](https://community.thunkable.com/u/sysads)\ **Post date:** [July 11, 2019, 1:42pm UTC](https://community.thunkable.com/t/get-object-from-json-using-getcolumn/138730/16 "2019-07-11T13:42:43Z")
OK i didn’t want to use list view due to its limitation but I guess I will have to use it after all but I know it works well with listview. Will let you know how it goes. Thanks ---
**Author:** ![Hayder](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/hayder/32/153829_2.png) [@Hayder](https://community.thunkable.com/u/Hayder)\ **Post date:** [July 11, 2019, 3:03pm UTC](https://community.thunkable.com/t/get-object-from-json-using-getcolumn/138730/17 "2019-07-11T15:03:59Z")
Where do you want your items to be viewed? ---
**Author:** ![Hayder](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/hayder/32/153829_2.png) [@Hayder](https://community.thunkable.com/u/Hayder)\ **Post date:** [July 11, 2019, 4:12pm UTC](https://community.thunkable.com/t/get-object-from-json-using-getcolumn/138730/18 "2019-07-11T16:12:42Z")
> [@sysads](#): > > i didn’t want to use list view due to its limitation What is the limitation of list viewer items? ---
**Author:** ![sysads](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/sysads/32/44975_2.png) [@sysads](https://community.thunkable.com/u/sysads)\ **Post date:** [July 11, 2019, 4:27pm UTC](https://community.thunkable.com/t/get-object-from-json-using-getcolumn/138730/19 "2019-07-11T16:27:12Z")
basically i want the images to be displayed as background on each button since i will also have a row under each button with buttons for share, like etc. with listview, i won’t be able to add row under each listview. ---
**Author:** ![CBVG](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/cbvg/32/32401_2.png) [@CBVG](https://community.thunkable.com/u/CBVG)\ **Post date:** [July 11, 2019, 4:44pm UTC](https://community.thunkable.com/t/get-object-from-json-using-getcolumn/138730/20 "2019-07-11T16:44:39Z")
The what you need is to use the 'make list from text with delimiter “,” ’ (or whatever your delimiter might be) and assign each element of the list to the component. Yes, you will need to have as many component value assignation as you have components. [Next page](https://community.thunkable.com/t/get-object-from-json-using-getcolumn/138730.md?page=2)