Fetch JSON Column

[fk1214]

Why is the Fetch JSON column not appearing?

[Darren_Murphy]

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.

[fk1214]

How can you use the Javascript column ?

[Darren_Murphy]

Something like the following:

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

Where p1 is the URL that returns the JSON.

[fk1214]

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

[Darren_Murphy]

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?

[fk1214]

I was trying the Geoapify API. URL: 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

[Darren_Murphy]

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

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

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

[fk1214]

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?

[Darren_Murphy]

Use the Query JSON column:

[fk1214]

Thanks!