JDBC Driver for PayPal

Build 22.0.8462

OrderDetails

Query details about an Order.

Table Specific Information

Select

Note: PayPal REST API does not give us a way to list all OrderId-s, so you must specify it. If you need such use case, it's recommended to use the Transactions and TransactionDetails views in SOAP schema.
The only filter supported by the PayPal API is Id, which is required. The driver processes other filters client side within the driver.

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 Order.

SELECT * FROM OrderDetails WHERE Id = 'O-1HE90236LH9332431'

SELECT * FROM OrderDetails WHERE Id IN ('O-1HE90236LH9332431', 'O-7D635956955612146')

Columns

Name Type References Description
Id [KEY] String The ID of the order.
Status String The order status. The possible values are: CREATED, SAVED, APPROVED, VOIDED, COMPLETED.
Intent String The intent to either capture payment immediately or authorize a payment for an order after order creation. The possible values are: CAPTURE, AUTHORIZE.
CreatedTime Datetime The date and time when the transaction occurred.
UpdatedTime Datetime The date and time when the transaction was last updated.
PayerId String The ID of the customer who approves and pays for the order. The customer is also known as the payer.
PayerGivenName String The name of the customer who approves and pays for the order. The customer is also known as the payer.
PayerSurname String The last name of the customer who approves and pays for the order. The customer is also known as the payer.
PayerEmail String The email of the customer who approves and pays for the order. The customer is also known as the payer.
PayerPhoneType String The phone type.
PayerPhoneNumber String The phone number, in its canonical international E.164 numbering plan format.
PayerBirthDate String The birth date of the payer in YYYY-MM-DD format.
PayerTaxId String The customer's tax ID. Supported for the PayPal payment method only.
PayerTaxType String The customer's tax ID type. Supported for the PayPal payment method only.
PayerAddressLine1 String The first line of the address. For example, number or street.
PayerAddressLine2 String The second line of the address. For example, suite or apartment number.
PayerAddressPostalCode String The postal code, which is the zip code or equivalent. Typically required for countries with a postal code or an equivalent.
PayerAddressCountryCode String The two-character ISO 3166-1 code that identifies the country or region.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462