Scenario: Obtaining detailed geographic information using address information - 6.1

Talend Components Reference Guide

English (United States)
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for Data Quality
Talend Open Studio for ESB
Talend Open Studio for MDM
Talend Real-Time Big Data Platform
Talend Studio
Data Governance
Data Quality and Preparation
Design and Development

This scenario describes a three-component Job which send HTTP request to Google Places API and obtain detailed geographic information based on the address we provided.

Setting up the Job

  1. Drop the following components from the Palette onto the design workspace: tFixedFlowInput, tGoogleAddressRow and tLogRow

  2. Connect tFixedFlowInput to tGoogleAddressRow and tGoogleAddressRow to tLogRow using Main links.

Configuring the components

  1. Double-click tFixedFlowInput to display its Basic settings view to define its properties.

  2. Click Edit schema to open a dialog box that displays the data structure of input data and define the data you want to pass to tGoogleAddressRow, two columns in this scenario, AddressID and Address, and then click OK to close the dialog box.

  3. Click Use Inline Table in the Mode area of the Basic settings view of tFixedFlowInput, and click the [+] button to add one column to the table.

  4. Fill in the field in the AddressID column with 1 and the Address column with "500 Oracle Parkway,Redwood Shores, CA 94065".

  5. Double-click tGoogleAddressRow to display its Basic settings view and define its properties.

  6. Select Address from the Address Column list and let the rest of settings as they are.

  7. Double-click tLogRow to display its Basic settings view and define its properties.

  8. Select Vertical (each row is a key/value list) in the Mode area and Print unique name in the Title printing mode area.

Executing the Job

  • Save your Job and press F6 to execute it.

    Google Places API has query limits for applications that submit requests. For further information about the usage limits of Google Places API, see Usage Limits and Billing.

    The detailed geographic information of 500 Oracle Parkway,Redwood Shores, CA 94065 is obtained from the Google Map database and printed onto the console.