Cloud Global Phone Number Append

This browser-based tool enables you to append certain geographic and demographic data to global telephone numbers from database tables on major Cloud Data Platforms (or any other database that you can access via the Internet). Simply provide the connection string from your data source's database, table name, and column name(s). The Phone Column Name is the column for which the appended data will be applied. You can generate reports with the appended data in comma-delimited form, generate SQL Insert scripts, or write results to new tables in the source database through the connection. This is an easy step to take in improving the value of your important data assets.

For instructions on how to include global phone number append as part of workflow, including scheduled runs, ongoing processing, or as part of a data pipeline, see the Phone Append Workflow Guide.

Run Here - Report Setup:

*Interzoid API License Key: Login or register to obtain

*Database Connection Type (Select from drop-down):

*Provide Database Connection String (use full URL if CSV, such as "https://dl.interzoid.com/csv/globalphones.csv"): Sample connection strings

*Table Name ("CSV" if CSV):

*Global Phone Number Column Name to Append to (Column # if CSV, first column = 1):

Optional Reference Column Name (to include on report):

New Table Name (only if writing results back to database):

Select Report Type:

Global Phone Append Report (most users)

Generate Insert SQL Script for All Records

Create New Table in Source Database

* Note: Use connection type = "CSV File", connection string = "https://dl.interzoid.com/csv/globalphones.csv", table name = "CSV", and column name = "1" for a demo that does not use credits from your account.

Additional Information:

Login to www.interzoid.com to obtain your API Key. It is how we track usage. If you do not yet have one, register for a free trial at www.interzoid.com/register-api-account.

Sample SQL Scripts in case you need sample/test data for a test drive.

How to use CSV files for data processing within Interzoid Cloud Data Connect.

API used for Global Phone Append

            
        Global Phone Number Append Sample:

        +496979550,Germany,Hesse,Frankfurt,German,...
        39 051 225445,Italy,Emilia-Romagna,Bologna,Italian,...
        +1 707-944-2380,USA,California,Sonoma,English,...
        +61 3 9662 3900,Australia,Victoria,Melbourne,English,...
        +852 1212 8888,Hong Kong,Hong Kong,Cantonese,...
        +15147335555,Canada,Quebec,Montreal,French,...

Run scheduled or as part of a batch script? Embed in workflow or within a data pipeline? Execute programmatically? You can run this entire process with a single API call. Example:

            
        https://connect.interzoid.com/run?function=phoneappend&apikey=use-your-own-api-key-here&source=CSV&connection=https://dl.interzoid.com/csv/globalphones.csv&table=CSV&column=1&html=true

Full Dataset Processing API Documentation

Return to Platform Home