Automating Address in Card Description to Location

[Luca Bernardi]

Hello,

hope you are doing well!

We are eager to integrate the "map view" feature using the addresses we collect from our applicants, which are included in the "description" field.

However, we're encountering challenges in automating the transfer of address data into the Location tab via Zapier, since this information is sourced from a Typeform address field.

Could you kindly assist us in establishing a method to automatically update the "location" tab with the existing address details from the description?

[Daydreamer Mike]

Hi @Luca Bernardi 

I don't know the address format that typeform uses but to be able to put it into a Trello card as a location, you will require the coordinates...

There are some tools that will handle the geocoding to take an address to coordinates, the most famous (and insanely expensive) is Google Maps API, I ended up using Here Location API

https://developer.here.com/?cid=Developer_Location-BA-Google-YT-0-Dev-EMEA-UK&utm_source=Google&utm_medium=ppc&utm_campaign=Dev_PaidSearch_DevPortal_AlwaysOn&utm_term=geocoding%20api&gad_source=1&gclid=Cj0KCQiAm4WsBhCiARIsAEJIEzXG_E6yFCdz0keQM7Tom6e_R13xyeuTT6Pj3L4bQQ_R0t2bUnWHPWoaAlxHEALw_wcB&gclsrc=aw.ds 

From the Trello side, 

The URL for the HTTP Put is:

https://api.trello.com/1/cards/{cardidlong}?key=apikey&token=token

Payload is:

{"coordinate": "latitude,longitude"}

I hope this helps