Phone Batch Cleansing

Data must be provided in a csv file, containing the following columns.

idstringA unique identifier for the row
phone_countrystring✔️The country provided in ISO 3166 format
phone_numberstring✔️The phone number to be cleansed

It is possible to perform more than one type of cleanse on a single CSV file. For example, a phone cleanse could be run on a file, followed by an address cleanse. Make sure that all the required columns are included for each cleanse you wish to perform. The columns can be included in any order. Fields can be left blank if the column is not applicable.

Cleansed File

The returned file will contain the provided columns, and the following:

  • phone_match_status
  • phone_error_codes
  • cleansed_phone_country
  • cleansed_phone_number_international
  • cleansed_phone_number_national

The phone_match_status column will contain the status of the cleanse.

full_matchThe phone number was found and is a perfect match
partial_matchThe phone number was found for a different country
no_matchThe phone number was not found
errorThere was an error with the phone cleanse

The phone_error_codes column will contain a comma separated list of reasons why the cleanse wasn't a full match


phone_country_correctedThe provided country was not valid for the phone number


phone_number_invalid_formatThe provided phone number is not in a valid format
phone_number_invalidThe provided phone number is not a valid number