Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
  
Need Address to Coordinates for Google Maps Integration
Having Google Maps integration is terrific. However, many of us have lots of address information in our databases and we need to be able to generate coordinates from the address information to populate the new Location column type.

Please either develop the formula types to enable us to do this or provide integration from one of the many third party Address to Coordinates applications that exist for free on the web.
ID
1096
Category
Customization
Author

Jeff Aibel
Date Created
4/19/2017 8:08:35 AM
Date Updated
4/24/2017 5:54:09 AM
Status
New Idea
Score
30
Promoted By
Dale OliverChristof SulzerJeff Aibel
Comments
Robert Gustavsson 4/19/2017 8:42:58 AM
In an action, call URL (method GET):
https://maps.googleapis.com/maps/api/geocode/xml?key=<%Var[My google API key]%>&address=<%[My address]%>

Then assign ToLocation(Response("/GeocodeResponse/result/geometry/location/lat") & ", " & Response("/GeocodeResponse/result/geometry/location/lng")) to your location column.

Apply for a google api key from Google first.
Robert Gustavsson 4/19/2017 9:43:15 AM
Unfortunately there is no other way, that I know of, to apply an action to multiple records other than creating a multi record button. However since TeamDesk still relies on old fashioned browser redirects which consist of an URL where the parameters (records) are concatenated. These URLs often become longer than browsers can handle. In my case there are 5500 records to update.
Kirill Bondar  Staff  4/19/2017 9:47:59 AM
@Robert - Google Maps API has a restriction of 50 queries per second. Process, fully automated via workflow rules will likely fail as it will fire requests at much higher rate.
Robert Gustavsson 4/20/2017 7:39:35 AM
I bet they do. And how about this limit:

<?xml version="1.0" encoding="UTF-8"?>
-<GeocodeResponse>
<status>OVER_QUERY_LIMIT</status>
<error_message>You have exceeded your daily request quota for this API.</error_message>
</GeocodeResponse>

I guess it could be fixed with a payed Google API account, or I'll just have to wait until tomorrow.
Kirill Bondar  Staff  4/20/2017 7:43:48 AM
* Max 50 requests per second
* 2,500 free requests per day, per user for free
* $0.50 USD / 1000 additional requests, up to 100,000 daily.
Robert Gustavsson 4/20/2017 7:49:41 AM
That´s fine, I'll just change the computer time to April 21 or April 1 2018 and send another 2,500 requests..
Dale Oliver 4/24/2017 5:54:09 AM
This has been very useful. Thanks a mill.

Using Google Distance Matrix API how does one extrapulate the distance,battling with the response section:
Action, Call URL (method Get)
https://maps.googleapis.com/maps/api/distancematrix/xml?key=<%Var[My google API key]%>&origns=<%[Origin Location Co-ordinates]%>&destinations=<%[Destination Location Co-ordinates]%>


Feedback
 
Back to Search Results