Cmdlets for PayPal

Build 21.0.8011


Query Transactions involving Balance Transfers.


Name Type References Description
Id [KEY] String The Id of the transaction record of the merchant.
PayerDisplayName String The display name of the buyer.
NetAmount Decimal The net amount of the transaction.
FeeAmount Decimal The fee that PayPal charged for the transaction.
GrossAmount Decimal The total gross amount charged, including any profile shipping cost and taxes.
Status String The status of the transaction. This field is one of the following values: Pending, Processing, Success, Denied, or Reversed.

The allowed values are Pending, Processing, Success, Denied, Reversed.

Date Datetime The date and time that the transaction occurred.
Timezone String The time zone of the transaction. The value is always GMT.
Type String The type of the transaction. It is one of the following values: Currency Conversion (credit), Currency Conversion (debit), Payment, Recurring Payment, Temporary Hold, Transfer, or Donation.
Payer String The email address of the buyer. Character length and limitations: 127 single-byte alphanumeric characters.


Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
Amount String Search by the transaction amount. You must set the CurrencyCode field to one of the 3-character currency codes for any of the supported PayPal currencies. This value cannot exceed 10,000.00 USD or the per transaction limit for the currency. It includes no currency symbol.
AuctionItemNumber String Search by the auction item number of the purchased goods. This field is not applicable to point-of-sale.
CardNumber String Search by the credit card number, as set by you for the original transaction. The field is not applicable to point-of-sale.
CurrencyCode String Search by the 3-character, ISO 4217 currency code.
InvoiceId String Search by the invoice identification key, as set by you for the original transaction. Character length and limitations: 127 single-byte characters maximum with no wildcards allowed.
ProfileId String Search by an alphanumeric string (generated by PayPal) that uniquely identifies a recurring profile. You can specify the Profile Id to obtain all payments associated with the identified profile.
ReceiptId String Search by the PayPal Account Optional receipt Id. This field is not applicable to point-of-sale transactions.
Receiver String Search by the email address of the receiver. If the merchant account has only one email address, this is the primary email. It can also be a nonprimary email address.
PayerName String Search by the name of the buyer.

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