Subscriptions
Get billing and subscription details.
Table Specific Information
Select
The only filter supported by the PayPal API is Id, which is required. The driver processes other filters client side within the driver.
SELECT * FROM Subscriptions WHERE Id='1234'
NOTE: We can get get the SubscriptionId by creating the subscription using CreateSubscription Stored procedure.
The driver processes other filters client side within the driver. 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. |