Copy page

Tutorials

Phone Validator

Validate and format a phone number (line type, carrier, region). Check and normalize the phone numbers you already have: valid or not, line type, carrier, E.164 format.

Credits: 1 search credit per validation. Lookups that find nothing cost nothing. See Pricing and limits.

Inputs and options

Input: phone (Phone number)

Optional: country_code (Country code (ISO-2, optional)).

This tool has no options.

Try one value

Code
CALL TOMBA.core.phone_validator('+1 415 555 0100', 'US');

The call returns the result as a VARIANT (example values, shortened):

Code
{
    "status": "found",
    "credits": 1,
    "results": [
        {
            "VALID": true,
            "E164_FORMAT": "+14155550100",
            "LINE_TYPE": "fixed_line",
            "REGION": "California"
        }
    ]
}

status is found, not_found, invalid or error; results holds the output columns and data the complete Tomba record.

Run it over a table

Create a small table to try it (or use one of yours, after granting the app access):

Code
CREATE OR REPLACE TABLE my_db.public.contacts (PHONE STRING, COUNTRY STRING);
INSERT INTO my_db.public.contacts VALUES
    ('+1 415 555 0100', 'US'),
    ('030 1234567', 'DE');
GRANT USAGE ON DATABASE my_db TO APPLICATION TOMBA;
GRANT USAGE ON SCHEMA my_db.public TO APPLICATION TOMBA;
GRANT SELECT ON TABLE my_db.public.contacts TO APPLICATION TOMBA;

Run the tool, then read the results:

Code
CALL TOMBA.core.validate_phones('MY_DB.PUBLIC.CONTACTS', 'PHONE', 'CONTACTS_PHONE_VALIDATOR', 100, 'COUNTRY');

SELECT INPUT_PHONE, VALID, E164_FORMAT, INTL_FORMAT, LINE_TYPE, CARRIER, REGION
  FROM TOMBA.results.CONTACTS_PHONE_VALIDATOR
 WHERE lookup_status = 'found';

Signature: validate_phones(input_table STRING, phone_column STRING, output_table STRING, max_rows INT DEFAULT 100000, country_code_column STRING DEFAULT '')

Output columns

Each row has your INPUT_<name> columns, the tool's columns, and the common columns (LOOKUP_STATUS, CREDITS, DATA, …). Every column, with its type and values: Output columns.

Tips

• The country column is optional but helps with local-format numbers (030 1234567). It takes a column name, not a value like 'US'.
• Store E164_FORMAT in your CRM: it is the standard international format.

Related

• Phone Finder