Skip to main content

New level of functionality and performance in data access via Python

Project description

Python Connector for QuickBooks Online

Python Connector for QuickBooks Online is a connectivity solution for accessing QuickBooks Online Online 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 QuickBooks Online data just like you would normally work with relational databases. Simple queries are directly converted to QuickBooks Online API calls and executed on the QuickBooks Online side. Complex queries are transformed into simpler queries, which are then converted to QuickBooks Online 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.quickbooks

Connect to a database using the connect() module method and obtain a connection object: If you have a refresh token and know your company ID:

my_connection = devart.quickbooks.connect(
    CompanyId="your_company_id",
    RefreshToken="your_refresh_token"
)

If you don't have a refresh token or don't know your company ID:

response = devart.quickbooks.signin()
my_connection = devart.quickbooks.connect(
    CompanyId=response["Company Id"],
    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/quickbooks/ordering.html

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

What's new

Python Connector for QuickBooks Online 1.2

  • Added support for Python 3.13

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_quickbooks_connector-1.2.0-cp313-cp313-win_amd64.whl (5.8 MB view details)

Uploaded CPython 3.13 Windows x86-64

devart_quickbooks_connector-1.2.0-cp313-cp313-win32.whl (5.5 MB view details)

Uploaded CPython 3.13 Windows x86

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

Uploaded CPython 3.12 Windows x86-64

devart_quickbooks_connector-1.2.0-cp312-cp312-win32.whl (5.5 MB view details)

Uploaded CPython 3.12 Windows x86

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

Uploaded CPython 3.11 Windows x86-64

devart_quickbooks_connector-1.2.0-cp311-cp311-win32.whl (5.5 MB view details)

Uploaded CPython 3.11 Windows x86

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

Uploaded CPython 3.10 Windows x86-64

devart_quickbooks_connector-1.2.0-cp310-cp310-win32.whl (5.5 MB view details)

Uploaded CPython 3.10 Windows x86

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

Uploaded CPython 3.9 Windows x86-64

devart_quickbooks_connector-1.2.0-cp39-cp39-win32.whl (5.5 MB view details)

Uploaded CPython 3.9 Windows x86

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

Uploaded CPython 3.8 Windows x86-64

devart_quickbooks_connector-1.2.0-cp38-cp38-win32.whl (5.5 MB view details)

Uploaded CPython 3.8 Windows x86

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

Uploaded CPython 3.7m Windows x86-64

devart_quickbooks_connector-1.2.0-cp37-cp37m-win32.whl (5.5 MB view details)

Uploaded CPython 3.7m Windows x86

File details

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

File metadata

File hashes

Hashes for devart_quickbooks_connector-1.2.0-cp313-cp313-win_amd64.whl
Algorithm Hash digest
SHA256 0ba70dacfc6de755d47c5e012f757b5dca97a72992bd03e4d8440678c074d5c4
MD5 5031130ef32fe4d8d917c756b8d891e0
BLAKE2b-256 a22c58df337119cc85d72cf76b10b045b887a4cdb51bf955c5aeb6bcfed5cb8f

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for devart_quickbooks_connector-1.2.0-cp313-cp313-win32.whl
Algorithm Hash digest
SHA256 2a4054c42109285ad8d6770c0904d6b7e473c8f1e7d31f7f79b86c287f1ab00f
MD5 28639dca49912c073d471bf550a5eec8
BLAKE2b-256 1cae4ecfdc3631b01fac766a87a515de975daddf5b79f8d6d752df14e4cdef0f

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for devart_quickbooks_connector-1.2.0-cp312-cp312-win_amd64.whl
Algorithm Hash digest
SHA256 6f0c2a6defee6a7ac512bf316c612b91fa970aa29763eadc0eb0a27e1d3da4ee
MD5 b55471af4bc6c7ab9b64797bcf2daa31
BLAKE2b-256 31dc0e04f7d2bee68d69063fcd501560a323a94ab787253feb7068cae213c9a3

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for devart_quickbooks_connector-1.2.0-cp312-cp312-win32.whl
Algorithm Hash digest
SHA256 d4f2f5e165f18ea36a764dba8206c17e6650a23344121939d22026e558576863
MD5 22f6bf86c06bd0ace36cdd552c403c2e
BLAKE2b-256 c676dd7c332208f66b92272f02858f4ed78ddeb0d3bb338cb6d4d1915293ce01

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for devart_quickbooks_connector-1.2.0-cp311-cp311-win_amd64.whl
Algorithm Hash digest
SHA256 158a5ad2ba1c5086b98773e9dfa091ea40a4fcb4b068937d9b4c99c5d95bc0e5
MD5 930a908c7746848cc71d03f6931496aa
BLAKE2b-256 95d46b7b6b79bc76fbb134afb3cc63aed09bdbdfa25c09d11c422e85b9c539e9

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for devart_quickbooks_connector-1.2.0-cp311-cp311-win32.whl
Algorithm Hash digest
SHA256 b6c4433eaf706531d6a6d3b6aaf05a320e7df36dc44615b79f7ed31f33aead6b
MD5 09684d860fdff01e8fb351927d54c9a1
BLAKE2b-256 e3617a78f74a0ea6c7a21d8bb60bb6fcd563ab0e71210ab659cd4ba5368d6f34

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for devart_quickbooks_connector-1.2.0-cp310-cp310-win_amd64.whl
Algorithm Hash digest
SHA256 0e3159e802788a0c94d9b0a9f1f5c84b688c13b33caab0339c5c204b3fc7c756
MD5 3e5f69dad51e1d74849660df75f9e4eb
BLAKE2b-256 4545f2ce598c26978ba7ff1be7fb85b23e50517b4a612f95dc1aa6457845004f

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for devart_quickbooks_connector-1.2.0-cp310-cp310-win32.whl
Algorithm Hash digest
SHA256 c4a596d01b79ee4f505f16c1260ea78453450884b48b697f9c3c1943296537fc
MD5 dbdd159f81eb951e58c828240fdadb4b
BLAKE2b-256 95ce3acd3ad1791036e37e213f963671b0cc76c8c22c81504bf075494ae9854c

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for devart_quickbooks_connector-1.2.0-cp39-cp39-win_amd64.whl
Algorithm Hash digest
SHA256 b46b9f37be460ba8c27811918813e9cb0a8206c4fdf91c9931a82c288876ef9a
MD5 b3814fc42c6767a83184a30027f3638e
BLAKE2b-256 bc256fc6356ce780d450dfbdff7796338a27725a6bcbc42018c255b226eb6179

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for devart_quickbooks_connector-1.2.0-cp39-cp39-win32.whl
Algorithm Hash digest
SHA256 5d869197922af4e252e510c7aee7e55953c6fc8d0d28b21a30038d1e38bbf34d
MD5 9941b85c45cc2c85436e0772f5911a2b
BLAKE2b-256 403c1d968468c294cb55ba7463c8556fd81d83af8948b7225ffa1dbdf1f5bdc5

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for devart_quickbooks_connector-1.2.0-cp38-cp38-win_amd64.whl
Algorithm Hash digest
SHA256 cb17510f2a6dd49dd5b9cb9ca4b1d044e5eaca38dad7ddf8d190c830e24d5ea3
MD5 90f2fb4ad9752431b05edae5057c1a55
BLAKE2b-256 c6003c3b9ea00e00409b28050ca04f3f8b0fa7fbb59cfe3dc697feb78cd6d2d9

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for devart_quickbooks_connector-1.2.0-cp38-cp38-win32.whl
Algorithm Hash digest
SHA256 e067b9f6eab44a3a99c5f4a67fa6d8ea8c21fa8f695937bab8991530e64caefb
MD5 3e6e7b3b8aee083355c8d0766d99770b
BLAKE2b-256 6caced30b22476bc278dfcb25b322d096e697196c387020b5563c5eb1da5abe0

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for devart_quickbooks_connector-1.2.0-cp37-cp37m-win_amd64.whl
Algorithm Hash digest
SHA256 bc78b9c48181c93edaa70c9fd018c0a3a903602b6964701aa834cbbc4453edfb
MD5 d2bf2bc635f8fd0983274f104e7f6577
BLAKE2b-256 7fe4c4befd54d10fa2248459eeed38d4e7220c6fb310878de13c22ebf407c398

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for devart_quickbooks_connector-1.2.0-cp37-cp37m-win32.whl
Algorithm Hash digest
SHA256 cb8859a1fc24e9f5d0c81eabf7b932f874f35731d905d6c3be5ed11a5b7fd05a
MD5 b055abdf9519d521aa9c302b506189f8
BLAKE2b-256 a2713aac5c7f9ba20aaa6881bc852a973fab3463aaebf8316479a50b21194f2f

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