Enrich postal Addresses with Geoapify web service

Activity	GeoLocationApi
Description	Enrich postal address
Available Since	1.4.12

Input :

PropertyName	Type	Required	Description
apiKey	STRING	YES	Geoapify API Key (more info : https://www.geoapify.com/get-started-with-maps-api )
connecionName	STRING	YES	dbStore name to use for input and output
inputSchema	STRING	YES	Schema name of the Input Table/View
outputSchema	STRING	YES	Schema name of the Output Table/View
inputTableName	STRING	YES	Table name of the Input Table (table structure defined below)
outputTableName	STRING	YES	Table name of the Output Table (table structure defined below)

Output

PropertyName	Type	Description
recordInserted	INT	Number of Line processed

Table Structure:

Input and Output tables must exists for the worker to run

Input table

Any table (or a View) with two columns, the first column must be an ID the second the address to enrich

CODE

CREATE TABLE {inputSchema}.{inputTableName} (
   Code VARCHAR(10) NOT NULL,
   Address VARCHAR(1000) NOT NULL)

It’s a good practice to filter the input Table from the addresses that have already been enriched to avoid processing them multiple times

Output table

CODE

CREATE TABLE {outputSchema}.{outputTableName} (
   Code VARCHAR(10) NOT NULL,
   FormattedAddress VARCHAR(1000) NULL,
   AddressLine1 VARCHAR(500) NULL,
   AddressLine2 VARCHAR(500) NULL, 
   HouseNumber VARCHAR(10) NULL, 
   Street VARCHAR(500) NULL, 
   Suburb VARCHAR(100) NULL, 
   City VARCHAR(100) NULL, 
   County VARCHAR(100) NULL,
   State VARCHAR(100) NULL, 
   PostCode VARCHAR(100) NULL, 
   Country VARCHAR(100) NULL, 
   CountryCode VARCHAR(10) NULL, 
   Longitude REAL NULL,
   Latitude REAL NULL,
   StateCode VARCHAR(10) NULL,
   Confidence DECIMAL(10,2))

Confidence columns is a percentage of validity regarding the salinization process

Example:

Input

JSON

{
   "apiKey" : "AAAADDDDDFFFFF",
   "connecionName" : "dbStore1",
   "inputSchema" : "im",
   "inputTableName" : "employee_addresses_to_enrich",
   "outputSchema" : "stg",
   "outputTableName" : "employee_addresses_enriched"
}

Output

JSON

{
  "recordInserted" : 2000 
}