Skip to main content

New level of functionality and performance in data access via Python

Project description

Python Connector for HubSpot

Python Connector for HubSpot is a connectivity solution for accessing HubSpot from Python applications to read and update data. It fully implements the Python DB API 2.0 specification. The connector is distributed as a wheel package for Windows and Windows Server.

Standard SQL syntax

The connector fully supports the ANSI SQL standard and lets you execute SQL statements against your HubSpot data just like you would normally work with relational databases. Simple queries are directly converted to HubSpot API calls and executed on the HubSpot side. Complex queries are transformed into simpler queries, which are then converted to HubSpot API calls. The embedded SQL engine then processes the results in the local cache and applies advanced SQL features from the original complex query.

Using the connector

To retrieve data from a database:

Import the module.

import devart.hubspot

Connect to a database using the connect() module method and obtain a connection object: If you authenticate using an API key:

my_connection = devart.hubspot.connect(
    Authentication="APIKey",
    APIKey="your_api_key"
)

If you authenticate using an access token:

my_connection = devart.hubspot.connect(
    Authentication="PrivateApp",
    AccessToken="your_access_token"
)

If you're using OAuth 2.0 authentication and have a refresh token:

my_connection = devart.hubspot.connect(
    Authentication="OAuth",
    RefreshToken="your_refresh_token"
)

If you're using OAuth 2.0 authentication and don't have a refresh token:

response = devart.hubspot.signin()
my_connection = devart.hubspot.connect(
    Authentication="OAuth",
    RefreshToken=response["Refresh Token"]
)

Create a cursor object using the cursor() connection method.

my_cursor = my_connection.cursor()

Execute the SQL statement using the execute() cursor method.

my_cursor.execute("SELECT * FROM employees")

Retrieve the result set using one of the fetch*() cursor methods.

for row in my_cursor.fetchall(): 
    print(row)

Ordering and activating the license

You can purchase a license for the connector on the ordering page:
https://www.devart.com/python/hubspot/ordering.html

To activate the license, follow the instructions in the documentation:
https://docs.devart.com/python/hubspot/activate-a-license.htm

What's new

Python Connector for HubSpot 1.2

  • Added support for Python 3.13
  • Added support for Association objects

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distributions

No source distribution files available for this release.See tutorial on generating distribution archives.

Built Distributions

devart_hubspot_connector-1.2.0-cp313-cp313-win_amd64.whl (5.8 MB view details)

Uploaded CPython 3.13 Windows x86-64

devart_hubspot_connector-1.2.0-cp313-cp313-win32.whl (5.6 MB view details)

Uploaded CPython 3.13 Windows x86

devart_hubspot_connector-1.2.0-cp312-cp312-win_amd64.whl (5.8 MB view details)

Uploaded CPython 3.12 Windows x86-64

devart_hubspot_connector-1.2.0-cp312-cp312-win32.whl (5.6 MB view details)

Uploaded CPython 3.12 Windows x86

devart_hubspot_connector-1.2.0-cp311-cp311-win_amd64.whl (5.8 MB view details)

Uploaded CPython 3.11 Windows x86-64

devart_hubspot_connector-1.2.0-cp311-cp311-win32.whl (5.6 MB view details)

Uploaded CPython 3.11 Windows x86

devart_hubspot_connector-1.2.0-cp310-cp310-win_amd64.whl (5.8 MB view details)

Uploaded CPython 3.10 Windows x86-64

devart_hubspot_connector-1.2.0-cp310-cp310-win32.whl (5.6 MB view details)

Uploaded CPython 3.10 Windows x86

devart_hubspot_connector-1.2.0-cp39-cp39-win_amd64.whl (5.8 MB view details)

Uploaded CPython 3.9 Windows x86-64

devart_hubspot_connector-1.2.0-cp39-cp39-win32.whl (5.6 MB view details)

Uploaded CPython 3.9 Windows x86

devart_hubspot_connector-1.2.0-cp38-cp38-win_amd64.whl (5.8 MB view details)

Uploaded CPython 3.8 Windows x86-64

devart_hubspot_connector-1.2.0-cp38-cp38-win32.whl (5.6 MB view details)

Uploaded CPython 3.8 Windows x86

devart_hubspot_connector-1.2.0-cp37-cp37m-win_amd64.whl (5.8 MB view details)

Uploaded CPython 3.7m Windows x86-64

devart_hubspot_connector-1.2.0-cp37-cp37m-win32.whl (5.6 MB view details)

Uploaded CPython 3.7m Windows x86

File details

Details for the file devart_hubspot_connector-1.2.0-cp313-cp313-win_amd64.whl.

File metadata

File hashes

Hashes for devart_hubspot_connector-1.2.0-cp313-cp313-win_amd64.whl
Algorithm Hash digest
SHA256 5f3cc7470cd055a890164735768cff105e1df70bc283767fb5d45ddba4091f55
MD5 ac49bf0779de0fdbc3779bfa31b8e08b
BLAKE2b-256 accfdc06ae097e62357ee7970049be7b144e017e307fe9167353e0ae3d541f96

See more details on using hashes here.

File details

Details for the file devart_hubspot_connector-1.2.0-cp313-cp313-win32.whl.

File metadata

File hashes

Hashes for devart_hubspot_connector-1.2.0-cp313-cp313-win32.whl
Algorithm Hash digest
SHA256 c010e5cf00f848bdf4dc3a5015fa44a1b8cd51c3ad906157e65a34d0ee0b4598
MD5 66c1894a302c6808f784b2eb727be185
BLAKE2b-256 9fea9c4cb05745294b5ee7a6d954f7bd66803a23d88b3a10f41cee8c0cb09dd3

See more details on using hashes here.

File details

Details for the file devart_hubspot_connector-1.2.0-cp312-cp312-win_amd64.whl.

File metadata

File hashes

Hashes for devart_hubspot_connector-1.2.0-cp312-cp312-win_amd64.whl
Algorithm Hash digest
SHA256 875f6d97146ee92995d1fe8d5229e3e5e8a5d476336a69f160ee4af634e2bcb6
MD5 e2484a8b713e112ff37b4e0186f3c948
BLAKE2b-256 fd78e208bffb5c8b7e92a266fb43aa4298b69e2a85dc1508bb7271308c2af5be

See more details on using hashes here.

File details

Details for the file devart_hubspot_connector-1.2.0-cp312-cp312-win32.whl.

File metadata

File hashes

Hashes for devart_hubspot_connector-1.2.0-cp312-cp312-win32.whl
Algorithm Hash digest
SHA256 a4d5aa64fbd923a9e6fe9fa2b714d80a08c01da1b2edfbba334e7f504fbc2b3a
MD5 f941200fa3b3be208093be19f8b14162
BLAKE2b-256 5179a7e1f71cb238d08033ac07ab8a4d74965996dd85d97428922aec2d7a9c6c

See more details on using hashes here.

File details

Details for the file devart_hubspot_connector-1.2.0-cp311-cp311-win_amd64.whl.

File metadata

File hashes

Hashes for devart_hubspot_connector-1.2.0-cp311-cp311-win_amd64.whl
Algorithm Hash digest
SHA256 f1e205d07c3064721bbbdd1dca68a85a02e1e82a103f4740fcb4d2b0ddb80398
MD5 3600330aaf26b9b9245be3b6a2573ebe
BLAKE2b-256 224118acce923e2ae51bea0c10022b3a2df4171bb6f2488f2c56c3928a18b784

See more details on using hashes here.

File details

Details for the file devart_hubspot_connector-1.2.0-cp311-cp311-win32.whl.

File metadata

File hashes

Hashes for devart_hubspot_connector-1.2.0-cp311-cp311-win32.whl
Algorithm Hash digest
SHA256 c4b79128124824db36e02fca6c33c679b2df79790ff39066c542cf6b46830d86
MD5 4c5d3b400c70dc6a28f3f44cf42bce99
BLAKE2b-256 6c4893c2eeaaf63ca4b03df57389dae2ad3be3e910cde50e1381a6d9f21ab8b4

See more details on using hashes here.

File details

Details for the file devart_hubspot_connector-1.2.0-cp310-cp310-win_amd64.whl.

File metadata

File hashes

Hashes for devart_hubspot_connector-1.2.0-cp310-cp310-win_amd64.whl
Algorithm Hash digest
SHA256 d4f584e36d917a92d5172b3fde29b8277097f14d99a44867b39c438b48e9427c
MD5 27ff5e685f6a26506fe9a94e45de86d4
BLAKE2b-256 78e1f8efbcd33c5482632484529074521107fa8c2eb4a0518ed14fa53f53181c

See more details on using hashes here.

File details

Details for the file devart_hubspot_connector-1.2.0-cp310-cp310-win32.whl.

File metadata

File hashes

Hashes for devart_hubspot_connector-1.2.0-cp310-cp310-win32.whl
Algorithm Hash digest
SHA256 26208f1783a45c0e63356677f4866952f60a0d427b7b0e38453646133c55e38b
MD5 08df84fa0925e851ed9a3fc2800ad164
BLAKE2b-256 9da118763595a48038caa167893f23b5369aca0aa727c05f368de044e855549f

See more details on using hashes here.

File details

Details for the file devart_hubspot_connector-1.2.0-cp39-cp39-win_amd64.whl.

File metadata

File hashes

Hashes for devart_hubspot_connector-1.2.0-cp39-cp39-win_amd64.whl
Algorithm Hash digest
SHA256 1bd967b3a8bc9ebb84e5481c00a8780b2cddc1d8f7ed892269529528f39f0bcd
MD5 f192681bbf158462ee9fce34fefec733
BLAKE2b-256 595bf578b200138ac7919488e395858dc543f6d3f6af290d06d6f0a038bd0224

See more details on using hashes here.

File details

Details for the file devart_hubspot_connector-1.2.0-cp39-cp39-win32.whl.

File metadata

File hashes

Hashes for devart_hubspot_connector-1.2.0-cp39-cp39-win32.whl
Algorithm Hash digest
SHA256 ba271538930111a5e22c62f7f7ff08e1a8e8763e9101d3aec505cef6c6565f2a
MD5 e2f5bf8e8649c9d19a56ad87f04006b6
BLAKE2b-256 8bb6ba57124e114695cf2af3d0cc899c5605a8522a2cbf32298abde79ab2b44d

See more details on using hashes here.

File details

Details for the file devart_hubspot_connector-1.2.0-cp38-cp38-win_amd64.whl.

File metadata

File hashes

Hashes for devart_hubspot_connector-1.2.0-cp38-cp38-win_amd64.whl
Algorithm Hash digest
SHA256 928b79c19bb93b431caf29135a69d032a3ffd530901e33e4242b4a8686040866
MD5 2425cfa592f29d39ebe283f53f295840
BLAKE2b-256 fba48a5c7abb57a766234751b6692887361d9333bd10daf23f7f3652aac4c21e

See more details on using hashes here.

File details

Details for the file devart_hubspot_connector-1.2.0-cp38-cp38-win32.whl.

File metadata

File hashes

Hashes for devart_hubspot_connector-1.2.0-cp38-cp38-win32.whl
Algorithm Hash digest
SHA256 d41cd636bb9dae4f8778a066c6ee438cc9a927fe3a51a7df1b4efe98d79074cc
MD5 31b6659185a1082183463a03fcba227e
BLAKE2b-256 03c0c7df96babcaaa4e893f66c1a13adbad77d44d3ab737070d9657d8ff926e1

See more details on using hashes here.

File details

Details for the file devart_hubspot_connector-1.2.0-cp37-cp37m-win_amd64.whl.

File metadata

File hashes

Hashes for devart_hubspot_connector-1.2.0-cp37-cp37m-win_amd64.whl
Algorithm Hash digest
SHA256 f0de79c8135ed7bef5976826aee705185fbce531798bf961d53f80c0b144b005
MD5 4f9be1f22c624ffe1f21914e8df8a191
BLAKE2b-256 d9e16b510c2ac916167d89b9b80f76a121f0de4315640cb2deb4a4f5196d0821

See more details on using hashes here.

File details

Details for the file devart_hubspot_connector-1.2.0-cp37-cp37m-win32.whl.

File metadata

File hashes

Hashes for devart_hubspot_connector-1.2.0-cp37-cp37m-win32.whl
Algorithm Hash digest
SHA256 6be9205b790bc6d7b23babd41633d36b672ba14bc6c72247b281adef8525e70c
MD5 d56aa22e16711e9ba25a70ebd64318b9
BLAKE2b-256 9a611319f6a15d4fa319909777b11468a74d895f9091a67e3bc833f77920a0bf

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page