Power BI Connector for PayPal

Build 21.0.7930


Query details about the funding instrument of the payer, such as a Credit Card or a token that represents a Credit Card.

Table Specific Information


This view returns a list of Credit Cards or details for a specific one.

The following filters are supported by the PayPal API:

  • Id
  • CreateTime
  • MerchantId
  • ExternalCardId
  • ExternalCustomerId

The CreateTime filter supports the >, >=, <, <=, and = operators, while the other filters only support the = operator.

The connector processes other filters client side within the connector. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

For example, the following queries are processed server side.

  • The following query retrieves details for a specific Credit Card:
    SELECT * FROM CreditCardDetails WHERE Id  = 'CARD-19H02474E2775740PKZYWVVI'
  • The following query returns details for Credit Card records created after the specified date:
    SELECT * FROM CreditCardDetails WHERE CreateTime>'2016-01-01'


Name Type References Description
Id [KEY] String The Id of the credit card.
Number String The redacted credit card number.
Type String The credit card type. Valid types are: visa, mastercard, discover, amex.
ExpireMonth Integer The expiration month with no leading zero. Acceptable values are 1 through 12.
ExpireYear Integer The 4-digit expiration year.
FirstName String The first name of the cardholder.
LastName String The last name of the cardholder.
AddressLine1 String The billing address associated with card. Line 1 of the address (e.g., number, street, etc.).
AddressLine2 String The optional line 2 of the Address (e.g., suite, apt number, etc.).
City String The city name.
CountryCode String The 2-letter country code.
PostalCode String The ZIP code or equivalent is usually required for countries that have them.
Phone String The phone number in E.123 format.
ExternalCustomerId String The unique identifier of the customer to whom this bank account belongs. Generated and provided by the facilitator.
MerchantId String The user-provided, optional field that functions as a unique identifier for the merchant holding the card. Note that this has no relation to PayPal merchant Id.
ExternalCardId String The unique identifier of the bank account resource. Generated and provided by the facilitator so it can be used to restrict the usage of the bank account to the specific merchant.
CreateTime Datetime The resource creation time in ISO8601 date-time format (e.g., 1994-11-05T13:15:30Z).
UpdateTime Datetime The resource update time in ISO8601 date-time format (e.g., 1994-11-05T13:15:30Z).
State String The state of the credit card funding instrument: expired or ok.
ValidUntil Datetime The funding instrument expiration date.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930