PartnerReferrals
Shows details by ID for referral data that was shared by the partner or API caller.
Table Specific Information
Select
Note: PartnerReferrals API does not give us a way to list all PartnerReferralId-s, so you must specify it.
The only filter supported by the PayPal API is Id, which is required.
The add-in processes other filters client side within the add-in.
For example, the following queries are processed server side and retrieve details for a specific Partner Referral.
SELECT * FROM PartnerReferrals where id= 'ZjcyODU4ZWYtYTA1OC00ODIwLTk2M2EtOTZkZWQ4NmQwYzI3RU12cE5xa0xMRmk1NWxFSVJIT1JlTFdSbElCbFU1Q3lhdGhESzVQcU9iRT0='
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The ID to access the customer's data shared by the partner with PayPal. | |
| SubmitterPayerId | String | The payer ID of the partner who shared the referral data. | |
| SubmitterClientId | String | The client ID of the partner who shared the referral data. | |
| IndividualOwners | String | List of owners in the account. | |
| BusinessNames | String | Name of the business. | |
| BusinessEmails | String | Email addresses of the business. | |
| BusinessWebsite | String | Website of the business. | |
| BusinessAddresses | String | List of addresses associated with the business entity. | |
| BusinessPhones | String | List of phone number associated with the business. | |
| BusinessDocuments | String | Business Party related Document data collected from the customer. | |
| BusinessType | String | Type of business entity like corporation, sole prop, governmental. | |
| BusinessSubtype | String | The sub classification of the business type. | |
| BusinessIndustryCategory | String | The customer's business category code. | |
| BusinessIndustryMccCode | String | The customer's business seller category code. | |
| BusinessIndustrySubcategory | String | The customer's business subcategory code. | |
| BusinessIncorporationCountryCode | String | The incorporation country code. | |
| BusinessIncorporationDate | Date | Date of business incorporation. | |
| BusinessOfficeBearers | String | List of Directors present as part of the business entity. | |
| BusinessPurposeCode | String | The account's purpose code. | |
| BusinessDescription | String | The business goals description. For example, a mission statement. | |
| IndividualBeneficialOwners | String | List of Individual beneficial owners part of the entity. | |
| BusinessBeneficialOwners | String | List of Business beneficial owners part of the entity. | |
| AnnualSalesVolumeRangeMinAmountCurrencyCode | String | The minimum inclusive amount currency code of the range for the total annual sales volume of the business. | |
| AnnualSalesVolumeRangeMinAmountValue | Decimal | The minimum inclusive amount value of the range for the total annual sales volume of the business. | |
| AnnualSalesVolumeRangeMaxAmountCurrencyCode | String | The maximum inclusive amount currency code of the range for the total annual sales volume of the business. | |
| AnnualSalesVolumeRangeMaxAmountValue | Decimal | The maximum inclusive amount value of the range for the total annual sales volume of the business. | |
| AvgMonthlyVolumeRangeMinAmountCurrencyCode | String | The minimum inclusive amount currency code of the range for the average monthly volume of the business. | |
| AvgMonthlyVolumeRangeMinAmountValue | Decimal | The minimum inclusive amount value of the range for the average monthly volume of the business. | |
| AvgMonthlyVolumeRangeMaxAmountCurrencyCode | String | The maximum inclusive amount currency code of the range for the average monthly volume of the business. | |
| AvgMonthlyVolumeRangeMaxAmountValue | Decimal | The maximum inclusive amount value of the range for the average monthly volume of the business. | |
| TrackingId | String | The partner's unique identifier for this customer in their system which can be used to track user in PayPal. | |
| Operations | String | An array of operations to perform for the customer while they share their data. | |
| Products | String | An array of PayPal products to which the partner wants to onboard the customer. | |
| Capabilities | String | An array of capabilities which the partner wants to enable for the selected products. | |
| OutsideProcessDependencies | String | An array of dependent processes. | |
| LegalConsents | String | An array of all consents that the partner has received from this seller. | |
| String | Email address of the customer used to create the account. | ||
| PreferredLanguageCode | String | The preferred locale code to use in the onboarding flow for the customer. | |
| PartnerConfigReturnUrl | String | The URL to which to redirect the customer upon completion of the onboarding process. | |
| PartnerConfigReturnUrlDescription | String | The description of the return URL. | |
| PartnerConfigShowAddCreditCard | Boolean | Indicates whether to show an add credit card page. | |
| FinancialInstrumentBanks | String | An array of banks attached to this managed account. | |
| PayoutAttributesMarketplace | Boolean | If true, specifies that the merchant or platform is offering goods or services on behalf of 3rd party sellers. | |
| PayoutAttributesKycRequired | Boolean | If true, specifies that the Kyc is required for the merchant. | |
| PayoutAttributesCountryTransferMethodCurrency | String | Requested country, transfer method and currency. | |
| LegalCountryCode | String | Legal Country Code. |