# NoCodeAPI + Fetch ❤️
**URL:** https://community.glideapps.com/t/nocodeapi-fetch/33318
**Category:** Project Showcase
**Created:** [October 20, 2021, 4:41am UTC](https://community.glideapps.com/t/nocodeapi-fetch/33318 "2021-10-20T04:41:20Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [October 20, 2021, 4:41am UTC](https://community.glideapps.com/t/nocodeapi-fetch/33318/1 "2021-10-20T04:41:20Z")
Well, this is awesome! NoCode API lets you create an API from popular sources, including Google Sheets. Now, I can lookup a user’s email within my Glide table and pull name/image from a completely different spreadsheet. No importranges or helper sheets needed!
---
### Author:  [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)
#### Post date: [October 20, 2021, 5:15am UTC](https://community.glideapps.com/t/nocodeapi-fetch/33318/2 "2021-10-20T05:15:37Z")
Thanks for the insight = very interesting and powerful… ❤ it
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [October 20, 2021, 5:16am UTC](https://community.glideapps.com/t/nocodeapi-fetch/33318/3 "2021-10-20T05:16:09Z")
Ooo…I just learned how to turn my source sheet into an API without NoCodeAPI saving me $$$/month.
These 3 fetch columns are searching my source sheet and pulling in first/last/photo based on the signed in user’s email from the app sheet:
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [October 20, 2021, 5:27am UTC](https://community.glideapps.com/t/nocodeapi-fetch/33318/4 "2021-10-20T05:27:21Z")
Ever so slowly, you’re moving across to the dark side. We’ll make a coder out of you yet 😝
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [October 20, 2021, 5:28am UTC](https://community.glideapps.com/t/nocodeapi-fetch/33318/5 "2021-10-20T05:28:45Z")
JSON/jq is my limit for now. I can wrap my brain around the structure.
---
### Author:  [@erwblo](https://community.glideapps.com/u/erwblo)
#### Post date: [October 20, 2021, 9:16am UTC](https://community.glideapps.com/t/nocodeapi-fetch/33318/6 "2021-10-20T09:16:34Z")
How nocode turns out to be a trick to turn people into coders 😉
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [October 20, 2021, 9:37am UTC](https://community.glideapps.com/t/nocodeapi-fetch/33318/7 "2021-10-20T09:37:03Z")
Haha this is especially true for me.
---
### Author:  [@Kyan\_Lynch](https://community.glideapps.com/u/Kyan_Lynch)
#### Post date: [October 22, 2021, 4:31pm UTC](https://community.glideapps.com/t/nocodeapi-fetch/33318/8 "2021-10-22T16:31:26Z")
Hey @Robert_Petitto, any chance you could put together a tutorial video on using NoCodeAPI?
---
### Author:  [@profxeni](https://community.glideapps.com/u/profxeni)
#### Post date: [October 22, 2021, 5:36pm UTC](https://community.glideapps.com/t/nocodeapi-fetch/33318/9 "2021-10-22T17:36:35Z")
And good thing I would add because otherwise, you would be an alien! 🙂 👌 💪
---
### Author:  [@Heena\_Mirchandani](https://community.glideapps.com/u/Heena_Mirchandani)
#### Post date: [November 15, 2021, 6:06pm UTC](https://community.glideapps.com/t/nocodeapi-fetch/33318/10 "2021-11-15T18:06:06Z")
Thanks for sharing this! Can you maybe share how the columns are fetching the data? I figured how to add an API thanks to your screenshot- but just can’t figure how to fetch the data. And what exactly should I expect as output?
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [November 15, 2021, 7:02pm UTC](https://community.glideapps.com/t/nocodeapi-fetch/33318/11 "2021-11-15T19:02:52Z")
Check this out:
> [@Fetch Column](https://community.glideapps.com/t/fetch-column/31731):
>
> Glide Fetch Column column.sh/fetch is an experimental code column that fetches JSON data from a public API and transforms it with an optional [jq query](https://stedolan.github.io/jq/tutorial/). Example: Fetch a Cat Fact Add column at https://column.sh/fetch Set URL to https://cat-fact.herokuapp.com/facts to fetch cat facts. Set query to .[0].text to get the text of the first fact. Development [View on GitHub](https://github.com/glideapps/glide-code-columns)
---
### Author:  [@Yasin\_Hassanien](https://community.glideapps.com/u/Yasin_Hassanien)
#### Post date: [November 15, 2021, 7:56pm UTC](https://community.glideapps.com/t/nocodeapi-fetch/33318/12 "2021-11-15T19:56:39Z")
@Robert_Petitto great and nice work
So does this help us in row count by anyway? Frankly fetch data in google sheet and only load data as an example if the user clicked or viewed a behavior?
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [November 15, 2021, 7:58pm UTC](https://community.glideapps.com/t/nocodeapi-fetch/33318/13 "2021-11-15T19:58:28Z")
That’s right! I’m using it successfully in one of my apps where I fetch student data “just in time” when completing a form. Now, I don’t need to host the student info in the app.
---
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [November 15, 2021, 8:22pm UTC](https://community.glideapps.com/t/nocodeapi-fetch/33318/14 "2021-11-15T20:22:46Z")
Hola Robert!
Are you using NoCodeAPI or you turned your GS into API to fetch your data students?
How big is your GS (rows) to make a comparison with mine regarding performance/speed?
Thanks!
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [November 15, 2021, 9:20pm UTC](https://community.glideapps.com/t/nocodeapi-fetch/33318/15 "2021-11-15T21:20:57Z")
I turned my GS into an API using script (cuz it was free). My sheet is 600 rows and takes 3-8 seconds to fetch 4 columns of data.
---
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [November 16, 2021, 3:47am UTC](https://community.glideapps.com/t/nocodeapi-fetch/33318/16 "2021-11-16T03:47:46Z")
Thanks for your reply @Robert_Petitto
I have the same scenario: a GS working as API (web app). My testing sheet has almost 30k rows with 7 columns and takes 4-7 secs to give me results.
As soon as I fix some details with APP’s UX, I will show it to evaluate it better. So far, I can live with no problems with these 4-7 secs.
Saludos!
---
### Author:  [@Yasin\_Hassanien](https://community.glideapps.com/u/Yasin_Hassanien)
#### Post date: [December 2, 2021, 10:34pm UTC](https://community.glideapps.com/t/nocodeapi-fetch/33318/17 "2021-12-02T22:34:48Z")
Is there a way to refetch updates rather than fetch once?
Somtimes we need to refresh the such as getting a certain update after some time or after clicking a button
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [December 2, 2021, 11:46pm UTC](https://community.glideapps.com/t/nocodeapi-fetch/33318/18 "2021-12-02T23:46:18Z")
I have an idea that I’m not sure it works with your case. Months ago I have a stock chart that needs to be refreshed a few mins at once, my idea was to make the URL changes by the time by adding a time parameter to it. It goes like.
```auto
htttps://charturl.com/example?param1=x¶m2=y&t=[current time]
```
That current time part, I pass it with a time format of YYYYMMDDhhmmss so when Glide updates the current time, my chart refreshes.
I think you can try the same approach with the URL that you use for fetching, but beware about the number of API calls.
---
### Author:  [@Amal](https://community.glideapps.com/u/Amal)
#### Post date: [December 6, 2021, 9:07pm UTC](https://community.glideapps.com/t/nocodeapi-fetch/33318/19 "2021-12-06T21:07:14Z")
Hey Rob,
i have a data on google sheets (100k rows) i want to be able to pull the info into glide when users searches a ID . My app is only glide table based so i need to connect GS to glide
---
### Author:  [@Drearystate](https://community.glideapps.com/u/Drearystate)
#### Post date: [December 6, 2021, 9:25pm UTC](https://community.glideapps.com/t/nocodeapi-fetch/33318/20 "2021-12-06T21:25:48Z")
You could export the google sheet as a json using google app scripts (set it on a timer to match the frequency needed) then in glide sheets you can fetch the json file and run your jQ Query from there. Make sure the export overwrites the old JSON. Here’s a google app script that should help you with exporting the JSON. After you add the script you will need to reload the editor and when you do you will see a new menu that shows up called “Export JSON” with 2 options. You can then export it with either option. Depending on the size of the file it could take anywhere from a couple seconds to a minute to export.
[Next page](https://community.glideapps.com/t/nocodeapi-fetch/33318.md?page=2)