Overview Access Person API Graph API Usage Agreement

CSV File Upload

This document outlines the format you should use to submit data to Rapleaf. Files submitted that do not follow this format will still be accepted, but may incur delays.
Example
The following is an example of what a small table of data looks like when converted to a CSV file to be uploaded to Rapleaf.
Email Address Name Age Location
johndoe@rapleaf.com John Doe 27 San Francisco, CA
janedoe@rapleaf.com Jane Doe 25 San Francisco, CA
jsmith@rapleaf.com John Smith 30 Berkeley, CA

CSV File

Email Address,Name,Age,Location
johndoe@rapleaf.com,John Doe,27,"San Francisco, CA"
janedoe@rapleaf.com,Jane Doe,25,"San Francisco, CA"
jsmith@rapleaf.com,John Smith,30,"Berkeley, CA"
Reference
Below is a set of guidelines for formatting a file to be submitted to Rapleaf.
Column Headers
You may include data in addition to each email address. Below is a list of suggested column headers:
  • Email Address
  • Name
  • Age
  • Location
  • Gender
  • Birthday
  • Occupation
  • University
Note: Other fields can be submitted in addition to the above. When possible, single-word or two-word descriptors are preferred for column headers.
Formatted Email Addresses
All email addresses should be in a lowercase format with leading and trailing whitespace stripped out. 
JOHNDOE@RAPLEAF.COM would be formatted as johndoe@rapleaf.com
Email Address Hashes
Submitted files may contain hashes of email addresses in place of plain text email addresses.
  • Hashes can be submitted as MD5 or SHA1.
  • The column header for the hash column should be "MD5 Hash" or "SHA1 Hash" depending on the hashing method used.
  • Email addresses must be lowercased and stripped of whitespace before being hashed.
  • Hash strings should be lowercased.
Note: If hashes are used, Rapleaf will be able to match and process about 60% of them, whereas if emails are submitted Rapleaf will be able to process 100% of them.
Hashed Email Address Example
Below is an example of a hashed email address that would be matched in Rapleaf's database. Use this to verify your hashing method matches ours. 
Email: JOHNDOE@rapleaf.com
Formatted Email: johndoe@rapleaf.com
MD5 Hash: fe1a7450b3e1b9cbcbaff286f70a1664
SHA1 Hash: cb58751cc8c52f4a5aecb7f6cb88b0a179622a34
Hashed Email Address Test
You can use this form verify other email addresses are hashed properly.
Email Address:  
File
Below are some simple guidelines that speed up the processing of submitted files:
  • File should be UTF-8 encoded.
  • File should not contain any control characters.
  • Files may be compressed as: zip, gzip, or bzip2.
CSV Formatting
Below are some tips for CSV formatting:
  • The "Email Address" (or "MD5 Hash" / "SHA1 Hash") column should be the first column in the CSV file.
  • For files that contain additional data, the first row should specify column headers (see above for suggested column headers).
  • Double quotes within a value should be escaped with a preceding double quote (Yes, this is actually the standard). 
    john@rapleaf.com,""Quoted Data"", "data", ...
  • Fields values should not contain any new line characters.
  • Lines should be terminated with either a "\n" or "\r\n" character.
Customer Identifiers / Transaction IDs
You may specify arbitrary columns to be included in the returned set. For example, you might include an "ID" column for each email address. 
Email Address,ID,Name,Age
johndoe@rapleaf.com,123,John Doe,27
janedoe@rapleaf.com,456,Jane Doe,25
...