TDV Adapter for PayPal

Build 22.0.8462

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

Columns

Name Type References Description
SubscriptionId String

Subscriptions.Id

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462