Google Maps Driving Distance and Duration API with Alteryx
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi All,
I've been trying to get actual driving distances and duration by wrapping in my personal API key.
I've been following this amazing guide: https://jdunkerley.co.uk/2016/07/21/geocoding-and-finding-nearest-station-with-google-web-services/
This is exactly what I need but I keep getting errors when inputting the API key URL in the Formula tool.
Also, do I need to use the Distance tool (since I only have the general license it doesn't come with TomTom capabilities) at any point or can I just add the results onto the data I already have? (I used the Append Tool to get multiple addresses listed)?
Thanks!
Solved! Go to Solution.
- Labels:
- API
- Datasets
- Expression
- Spatial Analysis
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for the help! I'm not too experienced with the Google API so this is hugely helpful
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Travis, this is exactly what I want to do. Would you be able to share a workflow?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@jdunkerley79 It Gives an error on the auto-field say "At least one field must be selected"
Means no data come, how can we re-check it? I put My API key and it accepts it (the key)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Ok @jdunkerley79 I understand, The destination field after parsing gives null, How do we can handle it?
ls the setting is Ok in Google console?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
When I checked the Records it gives the following error: This API project is not authorized to use this API., Why this happened?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I haven't used the Google DistanceMatrix API in a while - but I know back in June they made some significant changes to their API. My guess is that that is the root of your issue. I would recommend reading through their API documentation and trying to build out your own API call.
https://developers.google.com/maps/documentation/distance-matrix/start
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@MAAbdullahAlMubarah You will need to activate the API.
https://console.developers.google.com/apis/library/geocoding-backend.googleapis.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank You so much @jdunkerley79 Very great resource
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi James,
I was trying to use the work flow that you have provided here. Instead of considering inputs in terms of spatial points, I would want to consider the combination of city, state, zip code and country because I do not have lat long info. In this case can I still use the concatenations that you have used?. If not, could you please let me know how can I input the below origin and destination details in the formula area and get the distance? For instance I have the following origin and destination detail and I would like to find the API distance in miles between them.
Origin details: DECATUR 62525 IL USA
destination details: LEWISBURG 37091 TN USA
Please find attached the excel file which has the origin and destination details . I have kept only 3 records here for simplicity.
Regards
Varun Shekhar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello, thanks so much for this! I just had a few questions: how do I know whether this calculates the drivetime in peak times or quiet times? or e.g. the time of day it pulls the drivetime data from? thanks, karol

- « Previous
-
- 1
- 2
- Next »