topic link tMap row to tRestClient for google map API address in Talend Studio

link tMap row to tRestClient for google map API address

Cherichoc- — Fri, 15 Nov 2024 22:41:37 GMT

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

Re: link tMap row to tRestClient for google map API address

gjeremy1617088143 — Tue, 02 Aug 2022 09:40:02 GMT

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

Re: link tMap row to tRestClient for google map API address

InfoCraft — Wed, 03 Aug 2022 10:43:18 GMT

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.