Connecting to API

For information on the available WHL and TAR.GZ files for supported environments, and how to install the appropriate file for your Python distribution, see Package Installation.

For information on the module to import, and how to configure the necessary connection properties in a connection string, see Establishing a Connection.

Other available connection properties can be used to configure other aspects of the connector capabilities.

Python Version Support

The CData Python Connector for API can be installed and used in various Python 3.8, 3.9, 3.10, and 3.11 distributions.

API Version Support

The connector models local XML/JSON files and remote REST service APIs as read/write tables. In addition to processing XML or JSON data, the connector also abstracts authentication, HTTP, and SSL/TLS: The major authentication schemes are supported, including HTTP Basic, Digest, and NTLM. The connector also facilitates connecting to data sources that use the OAuth authentication standard.

See Also

• Using the Connector: Establish connections and query API through Python code.
• From SQLAlchemy: Use SQLAlchemy to establish a connection with dialect URL, and interact with API data using mapped classes and Sessions.