SSIS Components for PayPal

Build 21.0.7930


List the Billing Plans.

Table Specific Information


This view returns a list of subscription plans for the authenticated user.

The following filters are supported by the PayPal API:

  • Id
  • ProductId

SELECT * FROM Plans WHERE Id='1234'
SELECT * FROM Plans WHERE ProductId='1234'

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.


Name Type References Description
Id [KEY] String The unique PayPal-generated ID for the plan.
CreateTime Datetime The date and time when the plan was created
Description String The detailed description of the plan.
BillingCyclesVersion Integer The active pricing scheme for this billing cycle.
BillingCyclesPricingModel String The active pricing scheme for this billing cycle.
BillingCyclesFrequency String The frequency details for this billing cycle.
BillingCyclesTenureType String The tenure type of the billing cycle.
BillingCyclesSequence Integer The order in which this cycle is to run among other billing cycles.
BillingCyclesTotalCycles Integer The number of times this billing cycle gets executed.
Links String contains the link of plan object
Name String The plan name.
ProductId String The ID for the product.
QuantitySupported Boolean Indicates whether you can subscribe to this plan by providing a quantity for the goods or service..
Status String The plan status.
TaxesInclusive Boolean Indicates whether the tax was already included in the billing amount.
TaxesPercentage String The tax percentage on the billing amount.
UpdateTime Datetime The date and time when the plan was last updated.

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