Google Maps Driving Distance and Duration API with Alteryx

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!

Workflow

Datasets

API

Spatial Analysis

Expression

Accepted answers

jdunkerley79

could you drop some sample data so I can try running it through?

I put together a guess of what you are trying to do based on what you posted.

You will need to enter an API key in the Text Input in the Yellow container

Aberdeen_GoogleDriveDistanceDuration.yxmd

All comments

jdunkerley79

Glad you liked the post.

Have stuck together a quick workflow loading a route into the Google drive time and distance API. should be a reasonable starting point for you.

James

Drive Distances.yxmd

marlop

Hi James,

I'm not quite sure what I'm doing wrong but I've attached what I just did (with some of your help on a different issue!).

I think I need to add another join in order for the original results to query Google services in just the way I want it.

What do you think?

Aberdeen_GoogleDriveDistanceDuration.yxmd

MAAbdullahAlMubarah

@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)

At Least One field selected.JPG

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703