# What is the fastest way of filling up a local-source DVL from JSON data? **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** json, data-viewer\ **Created:** [June 8, 2023, 3:14pm UTC](https://community.thunkable.com/t/what-is-the-fastest-way-of-filling-up-a-local-source-dvl-from-json-data/2457693 "2023-06-08T15:14:32Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![kartik14](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kartik14/32/44782_2.png) [@kartik14](https://community.thunkable.com/u/kartik14)\ **Post date:** [June 8, 2023, 3:14pm UTC](https://community.thunkable.com/t/what-is-the-fastest-way-of-filling-up-a-local-source-dvl-from-json-data/2457693/1 "2023-06-08T15:14:32Z")
Hi, I am pulling in filtered data from my Google Sheets database using GVIZ query, which gives me a JSON response of the result. I’m parsing row-by-row of this data and then creating a row of it in the DVL’s local data source, which is taking a looooong time - like for some reason it’s taking ~15sec for creating just 20rows of data. I’ve tried both `count .... i loop` and `for loop`, both take long similar times. - (_The first variable `startup dvl obj` has the full JSON response, and the `temp row obj` fetches data for the current iteration from the full data. Then I create a row in the data source, and after loop finishes it refreshes the DVL._) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/7/87d5d619adaf99628dd720cf7b626a8fc28bfe6a.png) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/f/af9e5c9c040f430bb8d4d2c33dc7f67045944417.png) The data I am trying to fetch might range from 100-5000 rows, so I won’t know beforehand the size of my data. Is there any way to just put the json data directly or any efficient way to import json data into a local source? Like if I was working with the simple list here, i could just assign the json list to it and it would display it right away. Can this be done with a DVL too? I am open to exploring options. (Also, my project is in snap-to-place environment…) ---
**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:** [June 9, 2023, 12:32am UTC](https://community.thunkable.com/t/what-is-the-fastest-way-of-filling-up-a-local-source-dvl-from-json-data/2457693/2 "2023-06-09T00:32:11Z")
Y put it in a local table? ---
**Author:** ![kartik14](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kartik14/32/44782_2.png) [@kartik14](https://community.thunkable.com/u/kartik14)\ **Post date:** [June 9, 2023, 4:20am UTC](https://community.thunkable.com/t/what-is-the-fastest-way-of-filling-up-a-local-source-dvl-from-json-data/2457693/3 "2023-06-09T04:20:40Z")
Hi @jared ! How’s it going? Are there other ways to do this? JSON to DVL efficiently? Please shed some light:) Thanks. ---
**Author:** ![kartik14](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kartik14/32/44782_2.png) [@kartik14](https://community.thunkable.com/u/kartik14)\ **Post date:** [June 12, 2023, 6:11am UTC](https://community.thunkable.com/t/what-is-the-fastest-way-of-filling-up-a-local-source-dvl-from-json-data/2457693/4 "2023-06-12T06:11:28Z")
Hi @jared , do you happen to have any ideas about this? Thanks. * * * Also anyone else any ideas on this? I’m kinda struggling to pull in data smoothly which doesn’t take too long and slows my app… ---
**Author:** ![kartik14](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kartik14/32/44782_2.png) [@kartik14](https://community.thunkable.com/u/kartik14)\ **Post date:** [June 13, 2023, 6:32am UTC](https://community.thunkable.com/t/what-is-the-fastest-way-of-filling-up-a-local-source-dvl-from-json-data/2457693/5 "2023-06-13T06:32:07Z")
Update, I followed @jared 's DVL hack (blank datasource + directly setting data to the elements of the DVL) - I modified the idea to fit for my needs, and I’ll elaborate on this in a new topic about using Google Sheets upto it’s full potential (hopefully soon) for everyone to see 🙂 Thanks! ---
**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:** [June 13, 2023, 1:00pm UTC](https://community.thunkable.com/t/what-is-the-fastest-way-of-filling-up-a-local-source-dvl-from-json-data/2457693/6 "2023-06-13T13:00:57Z")
Great work! Looking forward to the share! ---
**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:** [September 11, 2023, 1:01pm UTC](https://community.thunkable.com/t/what-is-the-fastest-way-of-filling-up-a-local-source-dvl-from-json-data/2457693/7 "2023-09-11T13:01:35Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.