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