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.

‍

‍

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:

‍

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).

‍

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.

‍

‍

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. 

‍

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. 

‍

‍

Here’s an example of the results:

‍