# Data Providing

**URL:** <https://community.glideapps.com/t/data-providing/32405>\
**Category:** Ask for Help\
**Created:** [September 28, 2021, 8:15am UTC](https://community.glideapps.com/t/data-providing/32405 "2021-09-28T08:15:05Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Science\_HotSpot](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/science_hotspot/32/32414_2.png) [@Science\_HotSpot](https://community.glideapps.com/u/Science_HotSpot)\
**Post date:** [September 28, 2021, 8:15am UTC](https://community.glideapps.com/t/data-providing/32405/1 "2021-09-28T08:15:05Z")

</div>

Can we provide live data in glide

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [September 28, 2021, 9:11am UTC](https://community.glideapps.com/t/data-providing/32405/2 "2021-09-28T09:11:39Z")

</div>

What type of live data do you want?

---

<div class="post-metadata">

**Author:** ![Science\_HotSpot](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/science_hotspot/32/32414_2.png) [@Science\_HotSpot](https://community.glideapps.com/u/Science_HotSpot)\
**Post date:** [September 29, 2021, 6:08am UTC](https://community.glideapps.com/t/data-providing/32405/3 "2021-09-29T06:08:46Z")

</div>

For Example No.of Covid Cases in India like that

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [September 29, 2021, 7:46am UTC](https://community.glideapps.com/t/data-providing/32405/4 "2021-09-29T07:46:47Z")

</div>

You would have to bring that data to your Sheet using a script that updates by itself, or find a way to import the data using the Experimental Code column, if your source provides an API.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [September 29, 2021, 8:00am UTC](https://community.glideapps.com/t/data-providing/32405/5 "2021-09-29T08:00:48Z")

</div>

Lots of people built covid related apps during the onset of the pandemic last year - a good deal of these were India focused. If you search the forum for “covid” you’ll find lots of related threads.

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [September 29, 2021, 9:04am UTC](https://community.glideapps.com/t/data-providing/32405/6 "2021-09-29T09:04:25Z")

</div>

Hi @Science_HotSpot

You can use an experimental column to create a fetch column or JSON transformation column.

If you find a public api with the covid-related data you are looking for, it might work. Careful: not all open api’s will work. There is a comment about this in the link below.

More here:

> [@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. [image] Development [View on GitHub](https://github.com/glideapps/glide-code-columns)