Greetings to all. I was experimenting with a new feature for my web app that would show me the actual mileage and travel time, from an origin point to a destination point. The origin of the example is: https://maps.googleapis.com/maps/api/distancematrix/json?destinations=Fumone&origins=Anzio&unit…

[image] profxeni: Curious, it gives me the result I was looking for Hola!, I tested several times and really something wrong happens here. Looks like Glide has a problem with that API or with that Google’s server. If you test by using this Glide’s tool Fetch JSON column | Glide , you won’t …

Thank you for your help. In the end, I opted for a script run directly from Google Sheets, also adding a cache that refreshes every 6 hours, to help me with code calls to Google Maps. In conclusion, one way or the other, the solution is always found! Here I have found all the solutions that may als…

[image] profxeni: https://maps.googleapis.com/maps/api/distancematrix/json?destinations=Fumone&origins=Anzio&units=metric&key=AIzaSyCLxnSvhGjjVPntRcZPhRDTt4SDZZ5m_PQ You could also try the data → fetch json in which you use this url in JQuery You could write .rows[0].elements[0].distance.t…

[image] ShantanuIyengar: .rows[0].elements[0].distance.text It doesn’t work that way either :frowning: I thank you anyway. :upside_down_face:

You have to create all the functionality either in Replt or Github and add your API key there. Then use an Experimental column to do it. The way you’re doing it will not work because of CORS issues.

[image] SantiagoPerez: The way you’re doing, it will not work because of CORS issues. right! Here the confirmation… [image]

Thank you very much, I appreciate the help!

Great catch. Many API links are not usable in the fetch column because of the same issue.

I found the solution guys! @profxeni @gvalero @Robert_Petitto Just append https://corsanywhere.herokuapp.com/ to your URL. For example: https://corsanywhere.herokuapp.com/https://maps.googleapis.com/maps/api/distancematrix/json?destinations=Fumone&origins=Anzio&units=metric&key=AIzaSyCLxnSvhGjjVP…

Just to make sure this is not a mistake, you’re showing your Google Maps API key @profxeni . Do you want us to remove it?

Google maps distance matrix

Ask for Help

gvalero May 21, 2022, 6:35pm 12

right!

Here the confirmation…

Javascript column to call API

Topic		Replies	Views
FetchJSON does not answer( but URL return right JSON Ask for Help	9	536	August 20, 2022
API Erreur Ask for Help custom-code	6	999	September 7, 2021
Como puedo calcular distancias de rutas para una App de delivery Ask for Help	10	1222	December 16, 2022
Fetch Column Ask for Help custom-code	76	5722	March 8, 2022
Accessing API endpoint with CORS restrictions Ask for Help	3	484	August 11, 2023

Google maps distance matrix

Related topics