Google Maps State and city error

I am currently using this format below to map some address details to my Monday board, and they have been working for a while until today. Now for some reason the City and state dont populate on my Monday boards and i get an error from Make.com, Im not sure if this is a format issue or im not doing something correctly, any help is seriously appreciated as i need this feature back up and running ASAP!

CURRENT FORMAT, WORKS WITH EVERYTHING BESIDES CITY AND STATE
image

HOW STATE IS SET UP
image

THE OUTPUT BUNDLE I AM USEING TO MAP CITY AND STATE:
Output

Bundle 1Collection
    Address ComponentsArray
        1Collection
            Long Name
            C1
            Short Name
            C1
            TypesArray
                1
                subpremise
        2Collection
            Long Name
            710
            Short Name
            710
            TypesArray
                1
                street_number
        3Collection
            Long Name
            Albany Street
            Short Name
            Albany St
            TypesArray
                1
                route
        4Collection
            Long Name
            South End
            Short Name
            South End
            TypesArray
                1
                neighborhood
                2
                political
        5Collection
            Long Name
            Boston
            Short Name
            Boston
            TypesArray
                1
                locality
                2
                political
        6Collection
            Long Name
            Suffolk County
            Short Name
            Suffolk County
            TypesArray
                1
                administrative_area_level_2
                2
                political
        7Collection
            Long Name
            Massachusetts
            Short Name
            MA
            TypesArray
                1
                administrative_area_level_1
                2
                political
        8Collection
            Long Name
            United States
            Short Name
            US
            TypesArray
                1
                country
                2
                political
        9Collection
            Long Name
            02118
            Short Name
            02118
            TypesArray
                1
                postal_code
        10Collection
            Long Name
            2518
            Short Name
            2518
            TypesArray
                1
                postal_code_suffix
    Formatted Address
    710 Albany St C1, Boston, MA 02118, USA
    GeometryCollection
    partial_match
    true
    Place ID
    ChIJGd5nLUB644kRG-31wYCgOY4
    Plus CodeCollection
    TypesArray
    URL Map
    https://maps.google.com/?q=42.3348807,-71.07065089999999

Commit

1 Like

i am grabbing all of these components not just the zip code, and the format im using was grabbing the data before but after switching to the paid version inside of google cloud it is no longer :frowning:

this is my whole set up also

the city never makes into the input bundle even tho its there and shows in the output bundel from google also,

image

the output bundle from google shows its there,


Here is a really roundabout way to do it.
You can pick it apart to see how it works, but basically when there are multiple Types for an Address Component we will sort that array then join them with a hyphen that way there is always consistency in the key naming for a specific component.
Through a combination of iterator and aggregator and match elements you end up with something stable to query using the map() function.
CityStateExtractGMaps.json (13.8 KB)

2 Likes

Hey @N_lopez We apologize for the confusion. Its just the matter of collection. Please use the formula as shown in below image: 'types" should be “types.1”

Regards,
Msquare Automation - Gold Partner of Make

Book a Free Consultation | Connect Live
Explore our YouTube Channel for valuable insights and updates!

4 Likes

Much better solution!

2 Likes

image

WORKED! the format issue was the types.1 i forgot to add! small issue that caused huge headaches lol! thank you so much

After going through my test data and running my scenario all city’s and states correctly populate on our Monday boards!

1 Like

Hey @N_lopez

Glad to know that your problem is resolved now.

Regards,
Msquare Automation - Gold Partner of Make

Book a Free Consultation | Connect Live
Explore our YouTube Channel for valuable insights and updates!

1 Like