Client Address Latitude Longitude Geocode
On a client record, Address, there’s a Map link, which presents the address in Google Maps.
Is it possible to capture or generate the address’ latitude/longitude in NetSuite, and store it in custom fields?
Thank you,
Stephen
Yes, I’ve done it for a Client using google as well as some other APIs they had access to.
That suite answer is pretty much spot on it’s almost that easy.
You do need to set up an API key with google and pass it in the URL as well
Google documents all this.
I build a mass update to get all the data in on existing customers, then I made an after submit that on creation calls a scheduled script that will go and set the LATLNG on this new entity made
It appears, via the map link, NetSuite sends the actual client address to Google Maps, which then geocodes it and populates the map.
I discovered there is some functionality in in Suite Answers:
- Get the Latitude and Longitude Value of an Address Using Google Geocoding
Has anyone used this before or have examples of its use?
I went with a script that inputs lat/lng based upon the customer shipping address.
One thing to be aware of, when we first enabled the script, it began to run on updating the entire database. We incurred a bill from Google for geocoding. There’s is a limit of 2,500 records a day and after that billing applies
We build a queuing system so as not to exceed 1,000 records and our system is working well.
