Use the Lookup endpoint to match hashed PII data to a RampID.

You should use the Lookup endpoint when:

  • You don’t want to send raw PII in your API call.
  • You want an exact match to a single hashed PII touchpoint

If there is a maintained record associated with the input string or ID, the maintained RampID is returned. If not, a derived RampID is returned.

Supported Inputs for Hashed PII Strings


Supported Inputs

The API accepts MD5-hashed email addresses, SHA256-hashed email addresses. SHA1-hashed email addresses, or SHA1-hashed PII strings as input.

For hashed PII strings, LiveRamp will only return a maintained identifier if the hashed string has an exact match against a maintained record in the Identity Graph. The Lookup endpoint does not perform any approximate or fuzzy string matching. While all fields in a hashed PII string are optional, the presence or absence of fields may affect the results returned.

See the table below for all supported variations of hash type and input type. The elements in brackets [] are optional.

Hash TypeInput TypeFormula
MD-5EmailEmail
SHA-256EmailEmail
SHA-1EmailEmail
SHA-1PhonePhone
SHA-1PostalPrimary Number + PreDirectional + Street Name + Street Suffix + PostDirectional + Unit Designator + Secondary Number + City + State + Zip
SHA-1Name + EmailFirst + [Middle OR Middle Initial] + Last + [Generational Suffix] + Email
SHA-1Name + PhoneFirst + [Middle OR Middle Initial] + Last + [Generational Suffix] + Phone
SHA-1Name + PostalFirst + [Middle OR Middle Initial] + Last + [Generational Suffix] + [Primary Number] + [PreDirectional] + [Street Name] + [Street Suffix] + [PostDirectional] + [Unit Designator] + [Secondary Number] + [City] + [State] + Zip

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 ElementDescriptionExampleRequired?
First NameThe person's first name.Eduardo
Felicia
Yes
Middle NameThe person's middle name or middle initial.Kyu
k
john
j
No
Last NameThe person's last name.Lopez
Nguyen
Yes
Generational SuffixThe person's generational name suffix.Jr
Sr
II
No

Constructing Postal Addresses

Postal addresses may be constructed in the following ways

  • Primary Number + Pre Directional + StreetName + StreetSuffix + PostDirectional + Unit Designator + SecondaryNumber + City + State + Zip
  • Zip
Language
Credentials
OAuth2