SSIS Components for PayPal

Build 21.0.7930

Subscriptions

Get billing and subscription details.

Table Specific Information

Select

The only filter supported by the PayPal API is Id, which is required. The component processes other filters client side within the component.

SELECT * FROM Subscriptions WHERE Id='1234'

NOTE: We can get get the SubscriptionId by creating the subscription using CreateSubscription Stored procedure.

The component processes other filters client side within the component. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

Columns

Name Type References Description
Id [KEY] String The PayPal-generated ID for the subscription.
BillingInfocycle_executions String The trial and regular billing executions.
BillingInfo_FailedPaymentsCount Integer The Failed payments count.
BillingInfo_LastPaymentAmountCurrencyCode String The last payment amount currency code.
BillingInfo_LastPaymentAmountValue String The last payment amount.
BillingInfo_LastPaymentTime Datetime The date and time when the last payment was made.
BillingInfo_NextBillingTime Datetime The next date and time for billing this subscription.
BillingInfo_OutstandingBalanceCurrencyCode String The total pending bill amount, to be paid by the subscriber.
BillingInfo_outstandingBalanceValue String The total pending bill amount, to be paid by the subscriber.
CreateTime Datetime The date and time of subscription created.
Links String Links for the subscription objects.
PlanId String The ID of the plan.
Quantity Integer The quantity of the product in the subscription.
ShippingAmountCurrencyCode String The currency for a financial transaction, such as a balance or payment due.
ShippingAmountValue String The amount for a financial transaction, such as a balance or payment due.
StartTime Datetime The start date and time of the subscription.
Status String The status of the subscription.
StatusUpdateTime Datetime The date and time of status updated.
SubscriberEmailAddress String The email address of the payer.
SubscriberName_GivenName String The given name of the payer.
SubscriberName_Surname String The sur name of the payer.
SubscriberPayerId String The PayPal-assigned ID for the payer.
SubscriberShippingAddress_AddressAddressLine1 String Primary address of the payer.
SubscriberShippingAddress_AddressAddressLine2 String Secondary address of the payer.
SubscriberShippingAddress_AddressAdminArea1 String Primary address of the payer.
SubscriberShippingAddress_AddressAdminArea2 String Secondary address of the payer.
SubscriberShippingAddress_AddressCountryCode String Country code of the payer address.
SubscriberShippingAddress_AddressPostalCode String Postal code of the payer address.
SubscriberShippingAddress_NameFullName String Full name of the Payer.
UpdateTime Datetime The date and time of subscription updated.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930