Use Quick Base Pipelines to reverse geocode addresses with Google Maps API (Part 1)

Lets use Latitude and Longitude to get the addresses

Landpick image

We will need to add some new fields

Landpick image

Add a Status field (Multiple choice) and additional Address field

Landpick image

Adding statuses will allow us to process records in stages

Landpick image

We also need a trigger, which will be a formula checkbox

Landpick image

Here's the full formula for Reverse Geocode Trigger

Landpick image

Lets create the Quick Base Pipeline to call the API. The trigger will be a Work Order record updates, where Reverse Geocode Trigger = true

Landpick image

We only need one Trigger, since the criteria is inside the formula field

Landpick image

Here we specify all fields we'll need

Landpick image

After we have our list of fields we need, lets set the trigger's initial checks and balances

Landpick image

The criteria: Reverse Geocode Status is Pending and Reverse Geocode Trigger is true

Landpick image

Now that the conditions are safe, lets make the API Request!

Landpick image

For this we'll go with a basic HTTP(s) request using a structured URL and API token

Landpick image

I found this URL in the API docs, add Latitude and Longitude fields in place

Landpick image

Copy your API Keys and paste it

Landpick image

Now lets turn on the Quick Base Pipeline and verify it's working before proceeding

Landpick image

Works!

Landpick image

Up Next: Part 2

Click here for Part 2 of Use Quick Base Pipelines to reverse geocode addresses with API

Watch the YouTube video to see each and every step.

 

If this walk-through has helped you use Quick Base Pipelines for Reverse Geocoding, let us know in the comments section below!

 

Thanks!

Up Next: Part 2

Click here for Part 2 of Use Quick Base Pipelines to reverse geocode addresses with API

Leave a Comment

Your email address will not be published. Required fields are marked *

Add Comment *

Name *

Email *

Website *