Use Quick Base Pipelines to reverse geocode addresses with API (Part 2)

First lets add a condition based on Request status

Landpick image

Status 200 is Success

Landpick image

If Request succeeds, we'll update the Work Order

Landpick image

Lets also Update Record if the request is not status 200

Landpick image

We'll need to add a Failed status to our Reverse Geocode Status field

Landpick image

If the request fails, we'll be able to trigger other steps

Landpick image

Lets make a Pipeline Logs table, so we can monitor and trigger workflows based on these logs

Landpick image

For now lets store the Web Request Status and Content

Landpick image

We want to create a Pipeline Log step

Landpick image

Here, we can convert the content to json object and target a specific area of the object

Landpick image

The data we want is under the "results"

Landpick image

Now, a quick test to see if it's narrowing results and converting to json object

Landpick image

At this point, I found out Google Maps API doesn't allow you to store data...

Landpick image

So I went searching for alternatives

Landpick image

Options 1: Geocod.io

Landpick image

I found this URL in the API docs

Landpick image

We will put our Latitude and Longitude variables in the URL in the correct spot and add our API key

Landpick image

I made a quick test to see the response...

Landpick image

We need to check if 'results' is still relevant and it is... keep it

Landpick image

Lets test it in Quick Base....

Landpick image

The content was converted to a json object, now we can make magic happen!

Landpick image

Now we can add the Reverse Geocode Address fields to the Update Record step

Landpick image

The data we want is stored in "address_components"

Landpick image

Inside "address_components", we can select "city", "zip", etc.

Landpick image

Here is how I mapped the Geocodio response

Landpick image

Lets run it and see what we get

Landpick image

Works!

Landpick image

Note: All API keys were harmed in the making of this video... Have fun!

Landpick image

    Full name*
    E-mail address*
    Company*
    Job Title*
    Regarding*
    Message*


    Related Posts
    5 Best Team Collaboration Tools
    The Dilemma 333.2 billion. This is the projected number of emails that will...
    More Details
    1 Comment

    Comments are closed.