Views
Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.
Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.
Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.
CData JDBC Driver for PayPal Views
| Name | Description |
| AuthorizationDetails | Query details about Authorizations. |
| Balances | List all non crypto balances. |
| CaptureDetails | Query details about a captured Payment. |
| CreditCardDetails | Query details about the funding instrument of the payer, such as a Credit Card or a token that represents a Credit Card. |
| CryptoBalances | List all crypto balances. |
| DisputeDetails | PayPal merchants, partners, and external developers can use the PayPal Disputes API to manage disputes. |
| Disputes | PayPal merchants, partners, and external developers can use the PayPal Disputes API to manage disputes. |
| DisputeTransactions | PayPal merchants, partners, and external developers can use the PayPal Disputes API to manage disputes. |
| Invoices | Query Invoices in PayPal. |
| Notifications | Query the list of event types that are subscribed to a Webhook. |
| OrderDetails | Query details about an Order. |
| OrderItems | Get the items in an Order. |
| Payments | Query details about authorized Payments. |
| PaymentTransactions | Query Transaction details including the amount and item details. |
| PayoutDetails | Retrieve details about Payouts. |
| PayoutItems | Retrieve payout items from a Payout. |
| Plans | List the Billing Plans. |
| RefundDetails | Query details about a specific Refund. |
| SaleDetails | Query details about a Sale Transaction. |
| Subscriptions | Get billing and subscription details. |
| SubscriptionTransactions | Lists transactions for a subscription. |
| TransactionReports | Lists transaction reports. |
| TransactionReportsCartInfoItemDetails | List Cart Info of Transaction Reports. |
| TransactionReportsIncentiveDetails | List Incentive Details of Transaction Reports. |
| Webhooks | Query the list of Webhooks. |