Cloud Email Validation and Enrichment

This browser-based tool enables you to run email validation reports from database tables existing in the Cloud on the major Cloud Data Platforms (or any other database that you can access via the Internet). CSV files are supported as well. Simply provide the connection string from your data source's database, table name, and column name(s). The Email Column Name is the column for which the email address validation algorithms will be applied. You can also generate SQL Insert scripts with the validation results appended, or write results to new tables in the source database through the connection. This is an easy step to take in improving the usability and value of your important data assets.

Check out our quick and easy email validation tutorial to see how it's done.

For instructions on how to include email validation of a dataset as part of workflow, including scheduled runs, ongoing processing, or part of a data pipeline, see the Email Validation Workflow Guide.

Run Here - Report Setup:

*Interzoid API License Key: Login or register to obtain

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

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

*Table Name ("CSV" if CSV):

*Email Address Column Name to Validate (Column # if CSV, first column = 1):

Optional Reference Column Name (to include on report, such as a primary key):

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

Select Report Type:

Email Validation Report (most users)

Email Validation Report - Invalids Only (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/emails.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 Email Verification

            
        Email Verification and Append Sample:

        jimsmith@gmail.com,valid,mail server ok...
        jimsmith@gmail,invalid,invalid syntax...
        johndoe@yahoo.com.mx,valid,mail server ok...
        winston.smith@maths.ox.ac.uk,valid,mail server...
        jane.doe@sjfdhsndsd.com,invalid,no mail server...
        unclesam@irs.gov,valid,mail server ok...

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=emailval&apikey=use-your-own-api-key-here&source=CSV&connection=https://dl.interzoid.com/csv/emails.csv&table=CSV&column=1&html=true

Full Dataset Processing API Documentation

Return to Platform Home