AuthorizationDetails
Query details about Authorizations.
Table Specific Information
Select
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 Authorization.
SELECT * FROM AuthorizationDetails WHERE Id = '70K15739YA1955155'
SELECT * FROM AuthorizationDetails WHERE Id IN ('70K15739YA1955155', '70K15739YA1955156')
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The PayPal-generated ID for the authorized payment. | |
| Status | String | The status for the authorized payment.
The allowed values are CREATED, CAPTURED, DENIED, PARTIALLY_CAPTURED, VOIDED, PENDING. | |
| StatusDetails | String | The details of the authorized order pending status.
The allowed values are PENDING_REVIEW, DECLINED_BY_RISK_FRAUD_FILTERS. | |
| AmountTotal | Decimal | The amount for this authorized payment. | |
| AmountCurrency | String | The currency of the amount. | |
| InvoiceId | String | The API caller-provided external invoice number for this order. Appears in both the payer's transaction history and the emails that the payer receives. | |
| CustomId | String | The API caller-provided external ID. Used to reconcile API caller-initiated transactions with PayPal transactions. Appears in transaction and settlement reports. | |
| SellerProtectionStatus | String | The level of protection offered as defined by PayPal Seller Protection for Merchants.
The allowed values are ELIGIBLE, PARTIALLY_ELIGIBLE, NOT_ELIGIBLE. | |
| ExpirationTime | Datetime | The amount being charged for the handling fee. Only supported when the payment method is set to paypal. | |
| CreateTime | Datetime | The time of authorization. | |
| UpdateTime | Datetime | The time that the resource was last updated. |