# \[solved\] I got a table and json file how to update list one by one? **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** beginner\ **Created:** [March 29, 2022, 12:44am UTC](https://community.thunkable.com/t/solved-i-got-a-table-and-json-file-how-to-update-list-one-by-one/1806932 "2022-03-29T00:44:42Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![aaronbx](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/aaronbx/32/124683_2.png) [@aaronbx](https://community.thunkable.com/u/aaronbx)\ **Post date:** [March 29, 2022, 12:44am UTC](https://community.thunkable.com/t/solved-i-got-a-table-and-json-file-how-to-update-list-one-by-one/1806932/1 "2022-03-29T00:44:42Z")
Uploading: table.jpg… ![table](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/d/8db6821331ffb2549cb5568967a67d8a595019e3.jpeg) ![json](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/2/d26936aa39d02231d45266f65f3ed9fe1614b435.jpeg) ![block](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/d/4d9b85e54a87337899046bb10e1b8c5bb512fd58.jpeg) I want to list 5 day in table but got error it doesn’t response the data. It is another way to update table. ---
**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\ **Post date:** [March 29, 2022, 1:28am UTC](https://community.thunkable.com/t/solved-i-got-a-table-and-json-file-how-to-update-list-one-by-one/1806932/2 "2022-03-29T01:28:21Z")
Can you show more of your blocks here? there’s not enough information to provide you with a meaningful response. i.e. What I mean here is, we can’t see where you either source or iterate through i or r. We also don’t know how iconurl is assigned a value. Have you tried error logging also, by chance? ---
**Author:** ![aaronbx](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/aaronbx/32/124683_2.png) [@aaronbx](https://community.thunkable.com/u/aaronbx)\ **Post date:** [March 29, 2022, 1:58am UTC](https://community.thunkable.com/t/solved-i-got-a-table-and-json-file-how-to-update-list-one-by-one/1806932/3 "2022-03-29T01:58:41Z")
![r](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/9/0904c326f7ae32681cb3c11eb82c4b2e6ede3a39.jpeg) ![i](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/3/034c7cfa123b5cfd18187022e7bc106a97f160ae.jpeg) ![iconurl](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/5/05e44981186c47ac09a2f381508b8f52476ab357.jpeg) variable here ---
**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\ **Post date:** [March 29, 2022, 2:05am UTC](https://community.thunkable.com/t/solved-i-got-a-table-and-json-file-how-to-update-list-one-by-one/1806932/4 "2022-03-29T02:05:35Z")
When you say `it doesn’t response the data` Can you clarify what you mean here too please. What are you expecting to happen? How are you checking for the existence of data in your table. I think the issue is this Json has nested lists and you’re trying to access them by their position. Instead you need to use the list blocks. Please read through this thread for more info on the topic > [@JSON / Object Tutorial](https://community.thunkable.com/t/json-object-tutorial/1085666/4): > > Part 3 Intermediate JSON Under construction Objects with multiple properties Nested Objects Arrays/Lists Now that you understand [Basic JSON](https://community.thunkable.com/t/json-object-tutorial/1085666/2) and [JSON Errors](https://community.thunkable.com/t/json-object-tutorial/1085666/3) we can now expand into more complex JSON topics. Objects with multiple properties In it’s simpliest form, JSON is made of name:value pairs. But the power of JSON resides in the create of objects with mulitple properties. Let’s expand the example of {"alias":"drted"} to include mulitple properties. [image] Now the JSON is st… ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [March 29, 2022, 2:57am UTC](https://community.thunkable.com/t/solved-i-got-a-table-and-json-file-how-to-update-list-one-by-one/1806932/5 "2022-03-29T02:57:23Z")
I’m not quite sure what you’re trying to do but maybe it will help to see how I get the weather icon from the OpenWeather API. The last set of blocks is where I get the icon. ![Screen Shot 2022-03-28 at 7.55.02 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/9/59ef08099b12a7a96537470facab562ac6f41f3a.png) The row ID input variable is the row number for my data source. ---
**Author:** ![aaronbx](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/aaronbx/32/124683_2.png) [@aaronbx](https://community.thunkable.com/u/aaronbx)\ **Post date:** [March 29, 2022, 6:52am UTC](https://community.thunkable.com/t/solved-i-got-a-table-and-json-file-how-to-update-list-one-by-one/1806932/6 "2022-03-29T06:52:45Z")
![table](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/b/9bc851a569e2b6f5810b68de0559e40192bd7938.gif) What I mean is like this than join strings together ---
**Author:** ![shrey](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/shrey/32/105637_2.png) [@shrey](https://community.thunkable.com/u/shrey)\ **Post date:** [March 29, 2022, 4:30pm UTC](https://community.thunkable.com/t/solved-i-got-a-table-and-json-file-how-to-update-list-one-by-one/1806932/7 "2022-03-29T16:30:45Z")
Try removing the block named `get property i - 1 of object` and everything after with ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0fc77241d19897821da727dbfea875b59db082d1.png) ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [March 29, 2022, 7:52pm UTC](https://community.thunkable.com/t/solved-i-got-a-table-and-json-file-how-to-update-list-one-by-one/1806932/8 "2022-03-29T19:52:21Z")
I don’t have a screenshot to share with you at the moment but you’ll need to use a `for each item j in list` block and set the list to `get property "weather" of object get object from JSON response`. Then, within the loop, get the “icon” property and assign it to a cell/row of your data source. For the row id, you’ll need to use a variable to count up from 1 as the loop iterates. ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [March 29, 2022, 8:04pm UTC](https://community.thunkable.com/t/solved-i-got-a-table-and-json-file-how-to-update-list-one-by-one/1806932/9 "2022-03-29T20:04:22Z")
This should work. I tested it with a list size of one and was able to see the icon property value. I just don’t have a longer JSON response to test it with. You’ll need to supply your own API url. If it doesn’t work, please supply the API url you are using as text (not a screenshot), removing the API key if you prefer. Please also copy the JSON response from the text input and paste it into a post here as text (it’s best to use the “Preformatted text” icon in the forum toolbar when doing this). ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/4/24774ed32f3360765367220814965f3f0d065644.png) ---
**Author:** ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)\ **Post date:** [June 27, 2022, 8:05pm UTC](https://community.thunkable.com/t/solved-i-got-a-table-and-json-file-how-to-update-list-one-by-one/1806932/10 "2022-06-27T20:05:03Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.