Query details about Authorizations.
Table Specific Information
The only filter supported by the PayPal API is Id, which is required. 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 and retrieve details for a specific Authorization.
SELECT * FROM AuthorizationDetails WHERE Id = '70K15739YA1955155' SELECT * FROM AuthorizationDetails WHERE Id IN ('70K15739YA1955155', '70K15739YA1955156')
|Id [KEY]||String||The PayPal-generated ID for the authorized payment.|
|Status||String||The status for the authorized payment.|
|StatusDetails||String||The details of the authorized order pending status.|
|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.|
|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.|