link tMap row to tRestClient for google map API address

[Cherichoc-]

Hi

I want to derive geolocation data using google maps API from address that are in the Database. the data is

row2.name, name---->XYZ 1

row2.address, address-->1600 Ampitheatre Parkway in Mountain View, California

And also be able to link the name field to the address. Iterate does not map to tRestClient

[gjeremy1617088143]

Hi @Phumla Qwabe​ ,tDBInput --> main link-->tMap--> main link-->tFlowToIterate --> iterate link --> tJava --> on component ok link --->tFixedFlowInput(with the globalMap of the tFlowToIterate component)-->main link-> tRestClient

Send me love and kudos

[InfoCraft]

Hi @Phumla Qwabe​,

context.URL= https://maps.googleapis.com/maps/api/geocode/json

Ex: https://maps.googleapis.com/maps/api/geocode/json?key={{key}}&address=20 Cameron Rd, Willow Grove, Pa 19090, USA 

*** take a look at this post: https://community.talend.com/s/question/0D55b00007UGEYvCAP/find-latitude-and-longitude?language=en_US

Kind regards,

😷19.