PayPal

Overview

The eSuite PayPal importer reads each row and determines whether a valid wallet has been included based upon the below specification.

The Importer has the following conditions:

  • Each PayPal wallet should only appear once in the import file, any duplicates found will result in a validation failure.

PayPal File Column Specification

A complete specification of the PayPal file is as follows.

Column Details Description
KeyField Required: Yes
Format: E | C
Validation: Must be one of the values above.
Case: Insensitive
E = Email
C = ClientUserId
Email Required: Yes_Alt
Format: Unicode string (max 255)
Validation: Length, Regex Email, Is Unique
Case: Insensitive. Cast to lower to persist.
User’s email address. Must be a valid email format. If client is using eSuite as the master for user authentication, this value must be provided, and must be unique. Note that if the value provided is identical to another account's email, the importer performs an update, rather than an insert.
ClientUserId Required: Yes_Alt
Format: Unicode string (max 50)
Validation: Length, Is Unique
Case: Upper and lower persisted. Uniqueness test will cast to lower.
Third party system’s identifier for the user account, if eSuite is not the master for account authentication.
PayPalPayerId Required: Yes
Format: Unicode string (max 25)
The unique identifier associated to, and provided by PayPal.
PayPalPayerEmail Required: Yes
Format: Unicode string (max 75)
Email address associated to the PayPal account. Note, this email address can differ to that which is registered to the eSuite account the wallet is being imported.
BillingAgreementId Required: Yes
Format: 
Unicode string (max 50)
This identifier is required to enable repeat transactions to take place.