SubscriptionTransactions
Lists transactions for a subscription.
Table Specific Information
Select
This view returns a list of transactions with details for a specific subscription.
The following filters are supported by the PayPal API:
- SubscriptionId
- StartTime
- EndTime
SELECT * FROM SubscriptionTransactions WHERE SubscriptionId = '1234' SELECT * FROM SubscriptionTransactions WHERE SubscriptionId = '1234' AND StartTime = '2018-01-21T07:50:20.940Z' AND EndTime = '2018-08-21T07:50:20.940Z'
NOTE: 1. SubscriptionId, StartTime and EndTime are the required parameters for this view and if StartTime and EndTime are not specified in the query the default values will be assigned from the code. 2. We can get get the SubscriptionId by creating the subscription using CreateSubscription Stored procedure.
The connector processes other filters client side within the connector.
Columns
| Name | Type | References | Description |
| SubscriptionId | String | The ID of the subscription. | |
| AmountWithBreakdown_FeeAmountCurrencyCode | String | The fee details for the transaction. | |
| AmountWithBreakdown_FeeAmountValue | String | The fee details for the transaction. | |
| AmountWithBreakdown_GrossAmountCurrencyCode | String | The three-character ISO-4217 currency code that identifies the currency. | |
| AmountWithBreakdown_GrossAmountValue | String | The value of the currency. | |
| AmountWithBreakdown_NetAmountCurrencyCode | String | The currency code of the net amount that the payee receives for this transaction in their PayPal account. | |
| AmountWithBreakdown_NetAmountValue | String | The net amount that the payee receives for this transaction in their PayPal account. | |
| PayerEmail | String | The email ID of the customer. | |
| PayerNameGivenName | String | When the party is a person, the party's given, or first, name. | |
| PayerNameSurname | String | When the party is a person, the party's surname or family name. Also known as the last name. | |
| Status | String | The initial state of the plan. | |
| Time | Datetime | The date and time when the transaction was processed. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| StartTime | Datetime | The start time of the range of transactions to list. | |
| EndTime | Datetime | The end time of the range of transactions to list. |