This scenario describes a three-component Job which send HTTP request to Google Places API and obtain detailed geographic information based on the geographic coordinates we provide.
Drop the following components from the Palette onto the design workspace: tFixedFlowInput, tGoogleMapLookup and tLogRow
Connect tFixedFlowInput to tGoogleMapLookup and tGoogleMapLookup 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 tGoogleMapLookup, two columns in this scenario, lat and lng respectively to hold the geographic coordinates.
Set the Type of column lat and column lng to Double. Leave rest of the settings as they are. Then, click OK to close the dialog box.
Click Use Single Table in the Mode area, fill the Value field of the lat column with
37.5300125and that of the lng column with
Double-click tGoogleMapLookup to display its Basic settings view and define its properties.
Select the latitude and longitude columns defined in the input schema, lat and lng respectively in this example, and leave 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 the given coordinates location is obtained from the Google Map database and printed onto the console.