Copy page

Tutorials

Phone Finder

Find a phone number from an email, a company domain or a LinkedIn URL. Add direct phone numbers to contacts for calling campaigns.

Credits: 5 search credits when a valid phone is found (1 when searching by domain). Lookups that find nothing cost nothing. See Pricing and limits.

Inputs and options

Any one of these input combinations:

• email (Email address)
• domain (Company domain)
• linkedin (LinkedIn profile URL)

This tool has no options.

Try one value

Code
CALL TOMBA.core.phone_finder('jane.doe@acme.com');

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

Code
{
    "status": "found",
    "credits": 5,
    "results": [
        {
            "VALID": true,
            "E164_FORMAT": "+14155550100",
            "LINE_TYPE": "mobile",
            "CARRIER": "Example Mobile",
            "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 (EMAIL STRING);
INSERT INTO my_db.public.contacts VALUES
    ('jane.doe@acme.com');
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.find_phones('MY_DB.PUBLIC.CONTACTS', 'EMAIL', 'CONTACTS_PHONE_FINDER', 100);

SELECT INPUT_EMAIL, VALID, E164_FORMAT, INTL_FORMAT, LINE_TYPE, CARRIER, COUNTRY_CODE
  FROM TOMBA.results.CONTACTS_PHONE_FINDER
 WHERE lookup_status = 'found';

Signature: find_phones(input_table STRING, email_column STRING, output_table STRING, max_rows INT DEFAULT 100000)

Other inputs with run_tool

Company phone numbers from domains (1 credit each), for a table that has a WEBSITE column:

Code
CALL TOMBA.core.run_tool('phone_finder', 'MY_DB.PUBLIC.ACCOUNTS', {'domain': 'WEBSITE'},
                         'ACCOUNTS_PHONE_FINDER', 100, {});

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

• 5 credits when a valid phone is found by email or LinkedIn URL; 1 credit when searching by company domain.
• The table procedure takes an email column. For domains or LinkedIn URLs, use run_tool with {'domain': ...} or {'linkedin': ...}.

Related

• Phone Validator
• Email Finder