CData BizTalk Adapter for PayPal 2019 - Online Help
Questions / Feedback?

REST Data Model

CData BizTalk Adapter for PayPal 2019 - Build 19.0.7354

The CData BizTalk Adapter for PayPal 2019 models the PayPal REST APIs as database views and stored procedures. These are defined in schema files, which are simple, text-based configuration files that make schemas easy to customize.

This section provides the API limitations and requirements for the REST data model; you can use the SupportEnhancedSQL feature, set by default, to circumvent most of these limitations.

Collaborative Query Processing

The adapter offloads as much of the SELECT statement processing as possible to the PayPal APIs and then processes the rest of the query within the adapter.

See SupportEnhancedSQL for more information on how the adapter circumvents API limitations with in-memory client-side processing.


Views are tables that cannot be modified. Typically, read-only data are shown as views.

Stored Procedures

Stored Procedures are function-like interfaces to PayPal. They can be used to access other functionality in PayPal not surfaced in the Views.

PayPal REST API Limitations

There are some limitations in the PayPal REST API. For example, it provides no way to list all orders/payments, so to query the related views like OrderItems, OrderDetails, Payments you must know the respective ID and specify it.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0