The Lookup endpoint can be used to perform exact matching on hashed PII strings (including email addresses).
Using hashed PII strings allows API requests without requiring raw (plaintext) PII to be passed as input to the request.
The following SHA1-hashed PII strings are supported:
- Email: MD5 hashed, SHA256 hashed, or SHA1 hashed
- Phone: SHA-1 hashed
- Name + Email: SHA-1 hashed
- Name + PhoneNumber: SHA-1 hashed
- Name + ZipCode: SHA-1 hashed
Calls to the Lookup endpoint can be made as single transaction calls for an individual record or batch request calls for multiple records. When possible, batching your requests into groups of 1000 will result in much better performance for your application. Because batch request calls are subject to higher rate limits, batch request calls are also less likely to be throttled.
Making a batch request call involves making a POST call to https://us.identity.api.liveramp.com/v1/batch/lookup and passing in a JSON array of URL strings constructed in the same way as a single transaction call to the Lookup endpoint. You can pass in up to 1000 URL strings in a single batch call.
Data normalization or fuzzy matching is not used on any input data.
If a maintained AbiliTec link is not associated with the input data, the endpoint returns a derived AbiliTec link.
General Construction Rules
The rules listed below apply to all PII string types.
- Strings must be UTF-8 encoded.
- If a field is empty, it should be excluded from the string.
- Separate fields with single spaces. Don't add additional spaces if you leave out a particular field.
- Convert all fields to lowercase before hashing.
- Phone number should be digits only with no special characters.
- Hyphens are allowed except in phone numbers.
- Remove all periods (.) from name and phone fields. Do not remove periods from email addresses.
Constructing Names
See the table below for information on the elements that can be included when constructing names.
| Name Element | Description | Example | Required? |
|---|---|---|---|
| First Name | The person's first name. | Eduardo Felicia | Yes |
| Middle Name | The person's middle name or middle initial. | Kyu k john j | No |
| Last Name | The person's last name. | Lopez Nguyen | Yes |
| Generational Suffix | The person's generational name suffix. | Jr Sr II | No |
Constructing Postal Addresses
Postal addresses may constructed in the following ways
- Primary Number + Pre Directional + StreetName + StreetSuffix + PostDirectional + Unit Designator + SecondaryNumber + City + State + Zip
- Zip
Supported Inputs for Each Hash
See the table below for all supported variations of hash type and input type.
| Hash Type | Input Type | Formula |
|---|---|---|
| MD5 | ||
| SHA256 | ||
| SHA1 | ||
| SHA1 | Phone | Phone |
| SHA1 | Postal | Primary Number + Pre Directional + StreetName + StreetSuffix + PostDirectional + Unit Designator + SecondaryNumber + City + State + Zip |
| SHA1 | Name + Email | First + Last + Email |
| SHA1 | Name + Email | First + Last + GenerationalSuffix + Email |
| SHA1 | Name + Email | First + MiddleInitial + Last + Email |
| SHA1 | Name + Email | First + MiddleInitial + Last + GenerationalSuffix + Email |
| SHA1 | Name + Email | First + Middle + Last + Email |
| SHA1 | Name + Email | First + Middle + Last + GenerationalSuffix + Email |
| SHA1 | Name + Phone | First + Last + Phone |
| SHA1 | Name + Phone | First + Last + GenerationalSuffix + Phone |
| SHA1 | Name + Phone | First + MiddleInitial + Last + Phone |
| SHA1 | Name + Phone | First + MiddleInitial + Last + GenerationalSuffix + Phone |
| SHA1 | Name + Phone | First + Middle + Last + Phone |
| SHA1 | Name + Phone | First + Middle + Last + GenerationalSuffix + Phone |
| SHA1 | Name + Postal | First + Last + Primary Number + Pre Directional + StreetName + StreetSuffix + PostDirectional + Unit Designator + SecondaryNumber + City + State + Zip |
| SHA1 | Name + Postal | First + Last + GenerationalSuffix + Primary Number + Pre Directional + StreetName + StreetSuffix + PostDirectional + Unit Designator + SecondaryNumber + City + State + Zip |
| SHA1 | Name + Postal | First + MiddleInitial + Last + Primary Number + Pre Directional + StreetName + StreetSuffix + PostDirectional + Unit Designator + SecondaryNumber + City + State + Zip |
| SHA1 | Name + Postal | First + MiddleInitial + Last + GenerationalSuffix + Primary Number + Pre Directional + StreetName + StreetSuffix + PostDirectional + Unit Designator + SecondaryNumber + City + State + Zip |
| SHA1 | Name + Postal | First + Middle + Last + Primary Number + Pre Directional + StreetName + StreetSuffix + PostDirectional + Unit Designator + SecondaryNumber + City + State + Zip |
| SHA1 | Name + Postal | First + Middle + Last + GenerationalSuffix + Primary Number + Pre Directional + StreetName + StreetSuffix + PostDirectional + Unit Designator + SecondaryNumber + City + State + Zip |
| SHA1 | Name + Postal | First + Last + Zip |
| SHA1 | Name + Postal | First + Last + GenerationalSuffix + Zip |
| SHA1 | Name + Postal | First + MiddleInitial + Last + Zip |
| SHA1 | Name + Postal | First + MiddleInitial + Last + GenerationalSuffix + Zip |
| SHA1 | Name + Postal | First + Middle + Last + Zip |
| SHA1 | Name + Postal | First + Middle + Last + GenerationalSuffix + Zip |
See The Lookup Endpoint for more information.