JDBC Driver for PayPal

Build 24.0.9062

Plans

List the Billing Plans.

Table Specific Information

Select

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 本製品 processes other filters client side within the 本製品.

Columns

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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062