Best Airtable Phone Validation API & Email Verification Integration 2025

// Advanced Airtable Phone Validation Script (2025)
const API_KEY = input.config({ label: '1lookup API Key', type: 'string' });
const TABLE_NAME = input.config({ label: 'Table Name', type: 'string' });
const PHONE_FIELD = input.config({ label: 'Phone Field Name', type: 'string' });
const EMAIL_FIELD = input.config({ label: 'Email Field Name', type: 'string' });
const STATUS_FIELD = input.config({ label: 'Status Field Name', type: 'string' });

// Get the table and records to validate
const table = base.getTable(TABLE_NAME);
const records = await table.selectRecordsAsync({
    fields: [PHONE_FIELD, EMAIL_FIELD, STATUS_FIELD]
});

// Validation function with enterprise features
async function validateContact(record) {
    const phoneNumber = record.getCellValue(PHONE_FIELD);
    const emailAddress = record.getCellValue(EMAIL_FIELD);
    
    if (!phoneNumber && !emailAddress) return null;
    
    try {
        // Phone validation with HLR lookup
        let phoneResult = null;
        if (phoneNumber) {
            const phoneResponse = await fetch('https://api.1lookup.io/v1/phone', {
                method: 'POST',
                headers: {
                    'Authorization': `Bearer ${API_KEY}`,
                    'Content-Type': 'application/json'
                },
                body: JSON.stringify({ 
                    phone: phoneNumber,
                    options: { hlr: true, carrier: true, spam_check: true }
                })
            });
            phoneResult = await phoneResponse.json();
        }
        
        // Email validation with deliverability check
        let emailResult = null;
        if (emailAddress) {
            const emailResponse = await fetch('https://api.1lookup.io/v1/email', {
                method: 'POST',
                headers: {
                    'Authorization': `Bearer ${API_KEY}`,
                    'Content-Type': 'application/json'
                },
                body: JSON.stringify({ 
                    email: emailAddress,
                    options: { deliverability: true, risk_score: true }
                })
            });
            emailResult = await emailResponse.json();
        }
        
        // Calculate overall validation status
        const phoneValid = phoneResult?.valid || false;
        const emailValid = emailResult?.deliverable || false;
        
        let status = 'Invalid';
        if (phoneValid && emailValid) status = 'Verified';
        else if (phoneValid || emailValid) status = 'Partial';
        
        // Update record with validation results
        await table.updateRecordAsync(record.id, {
            [STATUS_FIELD]: { name: status },
            'Phone Carrier': phoneResult?.carrier || '',
            'Phone Country': phoneResult?.country || '',
            'Email Risk Score': emailResult?.risk_score || 0,
            'Validation Date': new Date().toISOString()
        });
        
        return { success: true, status, phoneResult, emailResult };
        
    } catch (error) {
        console.error(`Validation failed for record ${record.id}:`, error);
        await table.updateRecordAsync(record.id, {
            [STATUS_FIELD]: { name: 'Error' },
            'Error Message': error.message
        });
        return { success: false, error: error.message };
    }
}

// Process records in batches for optimal performance
const batchSize = 10;
const results = [];

for (let i = 0; i < records.length; i += batchSize) {
    const batch = records.slice(i, i + batchSize);
    const batchPromises = batch.map(record => validateContact(record));
    const batchResults = await Promise.allSettled(batchPromises);
    results.push(...batchResults);
    
    // Rate limiting to respect API limits
    if (i + batchSize < records.length) {
        await new Promise(resolve => setTimeout(resolve, 1000));
    }
}

output.text(`Validation complete! Processed ${results.length} records.`);