CData BizTalk Adapter for PayPal 2019 - Online Help
Questions / Feedback?

Payments

CData BizTalk Adapter for PayPal 2019 - Build 19.0.7354

Query details about authorized Payments.

Table Specific Information

Select

The only supported filters are Id and OrderId. Filters only supports the = operator 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 query is processed server side and retrieves Payments that were created after the specified date.

SELECT * FROM Payments WHERE Id > 'P-41250-2' AND OrderId =  'O-123550-05'

Columns

Name Type References Description
Id [KEY] String The PayPal-generated ID for the authorized payment.
Intent String The payment intent.
PayerPaymentMethod String The payment method.
PayerStatus String The status of payer's PayPal account.
PayerEmail String The payer's email address.
PayerSalutation String The payer's salutation.
PayerFirstName String The payer's first name.
PayerMiddleName String The payer's middle name.
PayerLastName String The payer's last name.
PayerSuffix String The payer's suffix.
PayerId String The PayPal-assigned encrypted payer ID.
PayerBirthDate Date The birth date of the payer, in Internet date format.
PayerTaxId String The payer's tax ID. Supported for the PayPal payment method only.
PayerTaxType String The payer's tax ID type. Supported for the PayPal payment method only.
PayerBillingAddressLine1 String The first line of the address. For example, number, street, and so on.
PayerBillingAddressLine2 String The second line of the address. For example, suite or apartment number.
PayerBillingAddressCity String The city name.
PayerBillingAddressCountryCode String The two-character ISO 3166-1 code that identifies the country or region.
PayerBillingAddressPostalCode String The postal code, which is the zip code or equivalent.
PayerBillingAddressState String The code for a US state or the equivalent for other countries.
PayerBillingAddressPhone String The phone number, in E.123 format.
PayerBillingAddressNormalizationStatus String The address normalization status. Returned only for payers from Brazil.
PayerBillingAddressType String The type of address. For example, HOME_OR_WORK, GIFT, and so on.
PayerShippingAddressLine1 String The first line of the address. For example, number, street, and so on.
PayerShippingAddressLine2 String The second line of the address. For example, suite or apartment number.
PayerShippingAddressCity String The city name.
PayerShippingAddressCountryCode String The two-character ISO 3166-1 code that identifies the country or region.
PayerShippingAddressPostalCode String The postal code, which is the zip code or equivalent.
PayerShippingAddressState String The code for a US state or the equivalent for other countries.
PayerShippingAddressPhone String The phone number, in E.123 format.
PayerShippingAddressNormalizationStatus String The address normalization status. Returned only for payers from Brazil.
PayerShippingAddressType String The type of address. For example, HOME_OR_WORK, GIFT, and so on.
State String The state of the payment, authorization, or order transaction.
ExperienceProfileId String The PayPal-generated ID for the merchant's payment experience profile. For information, see create web experience profile.
NoteToPayer String A free-form field that clients can use to send a note to the payer.
FailureReason String The reason code for a payment failure.
ReturnUrl String The URL where the payer is redirected after he or she approves the payment. Required for PayPal account payments.
CancelUrl String The URL where the payer is redirected after he or she cancels the payment. Required for PayPal account payments.
BrandName String A label that overrides the business name in the merchant's PayPal account on the PayPal checkout pages.
Locale String The locale of pages that the PayPal payment experience displays.
LandingPage String The type of landing page to show on the PayPal site for customer checkout.
ShippingPreference String The shipping preference.
UserAction String The user action. Presents the customer with either the Continue or Pay Now checkout flow.
CreatedTime Datetime The date and time when the transaction occurred.
UpdatedTime Datetime The date and time when the payment was updated, in Internet date and time format.

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0