OrderDetailsCData BizTalk Adapter for PayPal 2019 - Build 19.0.7354
Query details about an Order.
Table Specific Information
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 adapter processes other filters client side within the adapter.
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')
|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.|