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)?
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.
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.
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