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.
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.
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
1and 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.
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 94065is obtained from the Google Map database and printed onto the console.