tGoogleAddressRow

Converts human-readable addresses into geographic coordinates and other
geographic information.

tGoogleAddressRow retrieves geographic information in a two-step
process:

tGoogleAddressRow accesses the Google Places API Text Search Service via a HTTP request
to get the place_id which uniquely identifies the address you
provided.
Then, tGoogleAddressRow accesses the Google Places API via a
HTTP request to obtain geographic coordinates and other geographic information
according to the place_id of the address you provided. For more
information, see Place Details.

For further information about Google Places API, see Google Places API Web Service.

Each data row needs one or several calls to the Places API. The quota will
depend on the license provided by Google. Make sure not to run the component on a data
set that exceeds your quota, otherwise you will get error messages and addresses will
not be corrected.

For further information about the usage limits of Google Places
API, see Usage Limits and Billing.

For further information about the terms of services of Google
Places API, see Terms of Service.

tGoogleAddressRow Standard properties

These properties are used to configure tGoogleAddressRow running in the Standard Job framework.

The Standard
tGoogleAddressRow component belongs to the Data Quality family.

This component is available in Talend Data Management Platform, Talend Big Data Platform, Talend Real Time Big Data Platform, Talend Data Services Platform, Talend MDM Platform and Talend Data Fabric.

Basic settings

Pause(in 1/10 seconds)	Time break between http requests for geographic information record. By default, the value for this field is 1.
Schema and Edit Schema	A schema is a row description, it defines the number of fields to be processed and passed on to the next component. The schema is either Built-in or stored remotely in the Repository.
Address column	From this list, select a parameter to be used in sending request to Google Places API. Parameters in this list are predefined in the schema of input data.
API key	Enter your API key in this field. For more information about how to get an API key, see https://developers.google.com/places/web-service/get-api-key. Note: Jobs migrated from releases older than 5.6 will need a key to run. Generate a key and set it in tGoogleAddressRow basic settings before running the Job. The component currently works with the Google Places API and not the Google Geocoding API as it was the case in releases older than 5.6. As a result, when you run the migrated Jobs in the current studio, you will have geographic information different from what you had in older studios. For example, the Location_type column outputs ROOFTOP in older releases, while it outputs street_address now. You can find the list of location types at Place Types.
Die on error	This check box is selected by default. Clear the check box to skip any rows on error and complete the process for error-free rows. When errors are skipped, you can collect the rows on error using a Row > Reject link.

Advanced settings

tStatCatcher Statistics	Select this check box to collect log data at the component level.

Global Variables

Global Variables	ERROR_MESSAGE: the error message generated by the component when an error occurs. This is an After variable and it returns a string. This variable functions only if the Die on error check box is cleared, if the component has this check box. A Flow variable functions during the execution of a component while an After variable functions after the execution of the component. To fill up a field or expression with a variable, press Ctrl + Space to access the variable list and choose the variable to use from it. For further information about variables, see Talend Studio User Guide.

ERROR_MESSAGE: the error message generated by the
component when an error occurs. This is an After variable and it returns a string. This
variable functions only if the Die on error check box is
cleared, if the component has this check box.

A Flow variable functions during the execution of a component while an After variable
functions after the execution of the component.

To fill up a field or expression with a variable, press Ctrl +
Space to access the variable list and choose the variable to use from it.

For further information about variables, see
Talend Studio

User Guide.

Usage

Usage rule	This component is usually used as an intermediate component, and it requires an input component and an output component.

Obtaining detailed geographic information using address information

This scenario applies only to Talend Data Management Platform, Talend Big Data Platform, Talend Real Time Big Data Platform, Talend Data Services Platform, Talend MDM Platform and Talend Data Fabric.

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

Drop the following components from the Palette onto the design workspace: tFixedFlowInput, tGoogleAddressRow and tLogRow
Connect tFixedFlowInput to tGoogleAddressRow and tGoogleAddressRow to tLogRow using Main links.

Configuring the components

Double-click tFixedFlowInput to display
its Basic settings view to define its
properties.
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.
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.
Fill in the field in the AddressID column with
1 and the Address column with
"500 Oracle Parkway,Redwood Shores, CA 94065".
Double-click tGoogleAddressRow to display
its Basic settings view and define its
properties.
Select Address from the Address Column list and let the rest of settings
as they are.
Double-click tLogRow to display its
Basic settings view and define its
properties.
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.

Document get from Talend https://help.talend.com

Thank you for watching.

Docs 7.x

0 Comments

Inline Feedbacks

View all comments

tGoogleAddressRow – Docs for ESB 7.x