Home > FAQs > How to write a server script for contact email validation and data enrichment?

FAQs in this section

What is VTAP? What tools VTAP provides? What is Module Designer? What is API Designer? Where can I find documentation for VTAP? Which editions and version supports VTAP? What is the pricing of VTAP? What happens to customization done using Customizer in V7 version? How to get in touch with Platform team? What is the intent of Developer edition? What is Vtiger’s Add-on Publisher? Is Add-ons Publisher available in all the CRM editions? How do I publish Email Template add-ons? How do I publish any other module as an add-on? How do I update a published add-on? How do I test an add-on? What are the limitations of the Add-ons Publisher? Which different add-on features can I publish? What can a developer publish using Add-on Publisher? What are the conditions for updating a published add-on? What are the prerequisites for publishing an add-on? What is an Insights Designer? What is the use of Insigts Designer in Vtiger CRM? What are the queries in Insights Designer? What are the components of the Insight Designer? What are the components of a Widget in Insights Designer? What is the Input tab in Insights Designer? What is the Transfer tab in Insights Designer? What is the Output tab in Insights Designer? What are the benefits of using the Insights Designer? How do I access the Insights Designer in Vtiger CRM? How do I create an Insights page? How do I enable filters for a report? How do I pin an Insight to the Dashboard? Is Raw Query support available by default? In which editions of Vtiger CRM is the VTAP - App Creator available? Can I set access to my custom apps? What are Line Item Fields in Insights Designer? What are Server Scripts and Jobs in Vtiger CRM? What is a Server Script? What are Server jobs? How do I create a Server job? What are the different helper methods to write server scripts? What is the Debugging method to write Server scripts? What are HTTP methods to write server scripts? What is Vtiger REST API method to write server scripts? How to write code for Server Scripts and Jobs? How to write a script for a server job to update stocks weekly in the warehouse system? How to write a script for a server job for importing daily leads from a file? How to write a server script to set case SLA by created day? How to write a server script to calculate the outstanding invoice amount? how to write a server script to update the credit score of a contact?

How to write a server script for contact email validation and data enrichment?

Consider a marketing firm CompanyX who acquire leads from various sources. They get only the names and email addresses of leads. They want to enrich lead information whenever they are created. This will help them prepare a marketing strategy for targeted marketing.
To do this, first you must create a custom checkbox field to know if the email address is verified. And create a workflow or process to enrich lead information.

async function main(record, user) {
    //Get lead's email address
var email = record.email;
if(email) {
try {
     //Send request to enrich service to get data by email address
         var response = await vtap.macro.http.get(
         'https://www.enrichservice.com/api/query', {
         headers: {
         Accesstoken: 'XXXXXXXXXXXXXXXXXX'
         },
         qs: {
         email: email
         }
         }
         );

         if(response && response.status == 200 && response.body) {
         var data = JSON.parse(response.body);
         record.firstname = data.fname;
         record.lastname = data.lname;
         record.mobile = data.phone_mobile;
         record.company = data.orgname;
         record.designation = data.role;
         record.industry = data.industry;
         record.website = data.website;
         record.twitter_username = data.twitter;
         record.country = data.address.country;
         record.state = data.address.state;
         record.city = data.address.city;
         record.code = data.address.zip;
         record.cf_email_verified = 1;
         } else {
         record.cf_email_verified = 0;
         }
} catch(error) {
//Uncheck email verified checkbox
record.cf_email_verified = 0;
}
}

//Return record data with updated value as process will update values in CRM
return record;
}

Explanation

In workflow or process, will add conditions to trigger this script for leads when an email is changed and the email verified checkbox is disabled.
If the email value is there, send http get request to enrich the service by setting the required access token and email value in the query string.
If the request is successful, set lead field values based on data received from the enrich service. Also, set the email verified checkbox to 1 to know that the email is verified.
If the request fails or no data is received from the request, set the email verified checkbox to 0.
Return the updated data. Workflow or process will update changed data in the CRM lead record.

Was this FAQ helpful?

0 out of 0 found this helpful.

Comments 0

Be the first to comment

FAQs in this section

How to write a server script for contact email validation and data enrichment?

Table of Contents

Comments 0