No-Code Enrichment with
Experian
Use Experian API for Phone Validation to Confirm Phone Numbers in a Spreadsheet
Sign Up Free

Use Experian API To Validate Phone Numbers

The Experian API for Phone Validation is based on the REST architecture that enables real-time validation of phone numbers, along with the retrieval of supplementary details. By utilizing this service, one can discern whether a phone number is a landline or a cell phone number, among other things. We are going to use the Experian API to enrich data in our sheet.

Experian API for Phone Validation

Provider Website: https://manage.experianaperture.io/experian-api

Provider Enrichment Docs: https://docs.experianaperture.io/free-trials/data-validation/#/Phone%20Validation/post_phone_validate_v2

Endpoint: https://api.experianaperture.io/phone/validate/v2

Token / Registration Required: Yes

How To Enrich A Spreadsheet With GTP-3 (or 4)

For this example, my data looks like this:

 

Data for Experian API for Phone Validation

In Gigasheet, head to the Enrichments function and select Custom Enrichment.

Step 1. First we paste in the HTTP request from the Experian website or their docs. Be sure your request starts with curl. It should contain your API when copy/pasted. 

(https://docs.experianaperture.io/free-trials/data-validation/#/Phone%20Validation/post_phone_validate_v2).

Customizing Request for Data for Experian API for Phone Validation

Step 2. On the next screen we’ll insert the column variable from our Gigasheet sheet for the prompt. In this case, we highlight after the number text in the input, and then select our Phone Number column and click +Insert Column Reference. Then click Next.

Merging in sheet data into Data for Experian API for Phone Validation
Ready to execute Data for Experian API for Phone Validation

Step 3. In this screen we see a preview of the results. Gigasheet makes requests for the first three rows and shows the response. At this point, select the fields you want to be inserted into your sheet. 

 

Preview of results from Data for Experian API for Phone Validation

Step 4. Finally, confirm the number of requests is to your liking, and when ready click Run to kickoff the custom enrichment process. It’s ok to leave or close the sheet; the custom enrichment will keep running and you’ll receive an email once the job has been completed. You can monitor the progress of your enrichment, or cancel the job at the top of the sheet. 

Confirm sheet execution of Data for Experian API for Phone Validation

Here’s an example of the results:

Gigasheet enriched with Data for Experian API for Phone Validation

Try it Out

The ease of a spreadsheet with the power of a database, at cloud scale.

No Code
No Database
No Training
Sign Up, Free Forever