FetchJSON does not answer( but URL return right JSON

Ask for Help
1

Hey guys!
Is there somebody familiar with JSON and\or FetchJSON Column? Help please, i spent a days and stack overflow((
Am trying to use an API, it works for other peiople outside of Glide well.
I use the ConstructURL, and it builds the correct URL.
When i use this URL - i see the correct answer in JSON in my browser.

image
image1620×1014 111 KB

But when I call the same URL by FetchJSON Column, it returns nothing(
I did it with empty JQ Query and with filled JQ Query by needed name var.
Both answers are empty(( Why?

image
image1441×818 111 KB

image
image1391×818 94.4 KB

1 Like
2

Any ideas @gvalero ?

I’m leaning towards a CORS issue, so please try this to see if it helps.

3

Thank you @ThinhDinh
Maybe the root cause is CORS…(
How to check this? Possible to fix?

4

There is a potential solution outlined in the post that @ThinhDinh linked to.

2 Likes
5

Oh, thank you, @Darren_Murphy ! Now i see the post)

6

@ThinhDinh, I am not familiar with JS yet. :roll_eyes:
The URL https://corsanywhere.herokuapp.com/ in any case should be the same, or where i should get the right CORSA-URL?
Thank you very much :pray:

7

You don’t need any JS, just add that URL before your current URL using a template column.

It would look like:

https://corsanywhere.herokuapp.com/https:///service-api…

Then fetch from that new URL.

2 Likes
8

It works!! Amazing :pray:
Thank you so much, @ThinhDinh and @Darren_Murphy :pray:

2 Likes
9

Great to hear! Have a nice weekend.

10

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