# Fetch JSON Column

**URL:** <https://community.glideapps.com/t/fetch-json-column/72381>\
**Category:** Ask for Help\
**Created:** [April 8, 2024, 8:56am UTC](https://community.glideapps.com/t/fetch-json-column/72381 "2024-04-08T08:56:52Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![fk1214](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fk1214/32/71058_2.png) [@fk1214](https://community.glideapps.com/u/fk1214)\
**Post date:** [April 8, 2024, 8:56am UTC](https://community.glideapps.com/t/fetch-json-column/72381/1 "2024-04-08T08:56:52Z")

</div>

Why is the Fetch JSON column not appearing?

![Screenshot 2024-04-08 at 9.55.36 am](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/6/16f6705532fa5baa3f79cd50996471ea4a1273aa.png)

---

<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:** [April 8, 2024, 10:24am UTC](https://community.glideapps.com/t/fetch-json-column/72381/2 "2024-04-08T10:24:14Z")

</div>

This was deprecated quite some time ago. You should use Call API instead. If you don’t have a plan that supports Call API, then you could probably use a JavaScript column.

---

<div class="post-metadata">

**Author:** ![fk1214](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fk1214/32/71058_2.png) [@fk1214](https://community.glideapps.com/u/fk1214)\
**Post date:** [April 8, 2024, 10:26am UTC](https://community.glideapps.com/t/fetch-json-column/72381/3 "2024-04-08T10:26:07Z")

</div>

How can you use the Javascript column ?

---

<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:** [April 8, 2024, 10:29am UTC](https://community.glideapps.com/t/fetch-json-column/72381/4 "2024-04-08T10:29:55Z")

</div>

Something like the following:

```auto
const response = await fetch(p1);
const data = await response.text();

```

Where `p1` is the URL that returns the JSON.

---

<div class="post-metadata">

**Author:** ![fk1214](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fk1214/32/71058_2.png) [@fk1214](https://community.glideapps.com/u/fk1214)\
**Post date:** [April 8, 2024, 10:32am UTC](https://community.glideapps.com/t/fetch-json-column/72381/5 "2024-04-08T10:32:39Z")

</div>

Doesn’t work for me. I tried other codes on this forum too.

---

<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:** [April 8, 2024, 10:34am UTC](https://community.glideapps.com/t/fetch-json-column/72381/6 "2024-04-08T10:34:09Z")

</div>

Just that on it’s own won’t work. That was just to get you started. You obviously need to return something. Can you share with me the URL of the JSON you’re wanting to fetch?

---

<div class="post-metadata">

**Author:** ![fk1214](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fk1214/32/71058_2.png) [@fk1214](https://community.glideapps.com/u/fk1214)\
**Post date:** [April 8, 2024, 10:36am UTC](https://community.glideapps.com/t/fetch-json-column/72381/7 "2024-04-08T10:36:11Z")

</div>

I was trying the Geoapify API. URL: [https://api.geoapify.com/v1/geocode/reverse?lat=51.21709661403662&lon=6.7782883744862374&apiKey=12345678](https://api.geoapify.com/v1/geocode/reverse?lat=51.21709661403662&lon=6.7782883744862374&apiKey=12345678)

These aren’t my real coordinates it’s the example url. Also I replaced my real API key with 12345678 for this post, but I used the URL with my real key instead

---

<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:** [April 8, 2024, 10:43am UTC](https://community.glideapps.com/t/fetch-json-column/72381/8 "2024-04-08T10:43:42Z")

</div>

Okay, so here is an example using a random public API (`https://meowfacts.herokuapp.com/`)

```auto
const response = await fetch(p1);
const data = await response.text();
return data;

```

 ![CleanShot 2024-04-08 at 18.41.20@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/2/e2954722451c18d44be11e6e3d0d77cda5f090a5.png)

Just be aware that this method is insecure, so if you are including API keys then you are risking that they could leak.

---

<div class="post-metadata">

**Author:** ![fk1214](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fk1214/32/71058_2.png) [@fk1214](https://community.glideapps.com/u/fk1214)\
**Post date:** [April 8, 2024, 10:46am UTC](https://community.glideapps.com/t/fetch-json-column/72381/9 "2024-04-08T10:46:38Z")

</div>

Thanks this works! But how do you get a specific part of it?

For example if we use the one you used and the result is “{“data”:[“The ancestor of all domestic cats is the African Wild Cat which still exists today.”]}”, how do we get the “data” bit so that the result is just “The ancestor of all domestic cats is the African Wild Cat which still exists today.” and not the rest?

---

<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:** [April 8, 2024, 10:48am UTC](https://community.glideapps.com/t/fetch-json-column/72381/10 "2024-04-08T10:48:38Z")

</div>

Use the Query JSON column:

 ![CleanShot 2024-04-08 at 18.48.14@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/a/7ac5da9078752846c84d7c43a1a29d8e36e4ee32.png)

---

<div class="post-metadata">

**Author:** ![fk1214](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fk1214/32/71058_2.png) [@fk1214](https://community.glideapps.com/u/fk1214)\
**Post date:** [April 8, 2024, 10:49am UTC](https://community.glideapps.com/t/fetch-json-column/72381/11 "2024-04-08T10:49:21Z")

</div>

Thanks!

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [April 15, 2024, 10:50am UTC](https://community.glideapps.com/t/fetch-json-column/72381/12 "2024-04-15T10:50:08Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.