This scenario describes a three-component Job which send HTTP request to Google Places API and obtain geographic coordinates based on the address we provided.
Drop the following components from the Palette onto the design workspace: tFixedFlowInput, tGoogleGeocoder and tLogRow
Connect tFixedFlowInput to tGoogleGeocoder and tGoogleGeocoder to tLogRow using Main links.
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 tGoogleGeocoder, two columns in this scenario, AddressID and Address. 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
1and the Address column with "
500 Oracle Parkway,Redwood Shores, CA 94065".
Double-click tGoogleGeocoder 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.
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 geographic coordinates of Address
500 Oracle Parkway,Redwood Shores, CA 94065 is obtained from the Google
Map database and printed onto the console.