Google maps distance matrix

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&units=metric&key=AIzaSyCLxnSvhGjjVPntRcZPhRDTt4SDZZ5m_PQ

I then inserted the Google URL into a column with a template (see image), taking the start and end path data from two other columns.

Finally, I used a Fetch column, having the template URL as its origin and the JQ Query for the distance described below:
.rows.elements.distance.text

The problem is this: if I try it in the plugin->TransformJson section and run the query with the JSON, everything works. However, if I run it from a Fetch column created for this purpose, it does nothing.

Can anyone explain the arcane?

@Jeff_Hager @Robert_Petitto @ThinhDinh @Darren_Murphy

1 Like

So your fetch JSON with the JQ Query returns nothing?

Nothing, all empty :frowning:
I have included the link just so you can try it

I’m not getting anything even without the query, so I assume this is a CORS problem. Sorry I don’t have a solution for this, if you’re using user-specific columns to feed the destination and origin.

If they are basic columns instead, I think you can use a HTTP call in Integromat/Make to write the distance and other things back to Glide.

1 Like

Curious, it gives me the result I was looking for

It means no JSON was returned in the app, so there’s nothing for the JQ Query code to work on.

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 receive any reply/data

It’s very weird!

Saludos!

1 Like

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 also be of use to others within this community.

1 Like

You could also try the data → fetch json in which you use this url
in JQuery

You could write
.rows[0].elements[0].distance.text

I think you were missing the 0 element number

1 Like

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.

3 Likes

right!

Here the confirmation…

2 Likes

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.

1 Like

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=AIzaSyCLxnSvhGjjVPntRcZPhRDTt4SDZZ5m_PQ

Source:

6 Likes

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?

1 Like

Great find @ThinhDinh

Does this work with Payhere then?

Thanks for the tip.

I tested like 10 Cors proxies and none worked for me :face_with_symbols_over_mouth: but happy to see it works and can be used.

Saludos Thinh!

https://corsanywhere.herokuapp.com/https://api.payhere.co/api/v1/subscriptions?page=1&per_page=50&access_token=[your_token]

Working for me.

Pass your token in access_token, I was fetching all subscriptions in an account.

3 Likes

Nice!

1 Like