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

Rookie Asked on May 2, 2021 in Administration.
Add Comment
3 Answer(s)

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

Rookie Answered on January 24, 2022.
Add Comment

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?

Rookie Answered on May 4, 2021.
Add Comment

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.

Rookie Answered on March 22, 2022.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor   Become a Sponsor