Skip to main content

New level of functionality and performance in data access via Python

Project description

Python Connector for BigCommerce

Python Connector for BigCommerce is a connectivity solution for accessing BigCommerce 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, macOS, and Linux.

Standard SQL syntax

The connector fully supports the ANSI SQL standard and lets you execute SQL statements against your BigCommerce data just like you would normally work with relational databases. Simple queries are directly converted to BigCommerce API calls and executed on the BigCommerce side. Complex queries are transformed into simpler queries, which are then converted to BigCommerce 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.bigcommerce

Connect to a database using the connect() module method and obtain a connection object: If you're using basic authentication:

my_connection = devart.bigcommerce.connect(
    Version="Ver2",
    Authentication="Basic",
    Server="your_bigcommerce_url",
    UserId="your_username",
    AuthenticationToken="your_auth_token"
)

If you're using OAuth 2.0 authentication:

my_connection = devart.bigcommerce.connect(
    Version="Ver2",
    Authentication="OAuth",
    StoreId="your_store_hash",
    ClientId="your_client_id",
    AccessToken="your_access_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/bigcommerce/ordering.html

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

What's new

Python Connector for BigCommerce 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_bigcommerce_connector-1.2.0-cp313-cp313-win_amd64.whl (37.3 MB view details)

Uploaded CPython 3.13 Windows x86-64

devart_bigcommerce_connector-1.2.0-cp313-cp313-win32.whl (34.2 MB view details)

Uploaded CPython 3.13 Windows x86

devart_bigcommerce_connector-1.2.0-cp313-cp313-manylinux_2_34_x86_64.whl (36.1 MB view details)

Uploaded CPython 3.13 manylinux: glibc 2.34+ x86-64

devart_bigcommerce_connector-1.2.0-cp313-cp313-macosx_10_9_universal2.whl (69.5 MB view details)

Uploaded CPython 3.13 macOS 10.9+ universal2 (ARM64, x86-64)

devart_bigcommerce_connector-1.2.0-cp312-cp312-win_amd64.whl (37.3 MB view details)

Uploaded CPython 3.12 Windows x86-64

devart_bigcommerce_connector-1.2.0-cp312-cp312-win32.whl (34.2 MB view details)

Uploaded CPython 3.12 Windows x86

devart_bigcommerce_connector-1.2.0-cp312-cp312-manylinux_2_34_x86_64.whl (36.1 MB view details)

Uploaded CPython 3.12 manylinux: glibc 2.34+ x86-64

devart_bigcommerce_connector-1.2.0-cp312-cp312-macosx_10_9_universal2.whl (69.5 MB view details)

Uploaded CPython 3.12 macOS 10.9+ universal2 (ARM64, x86-64)

devart_bigcommerce_connector-1.2.0-cp311-cp311-win_amd64.whl (37.3 MB view details)

Uploaded CPython 3.11 Windows x86-64

devart_bigcommerce_connector-1.2.0-cp311-cp311-win32.whl (34.2 MB view details)

Uploaded CPython 3.11 Windows x86

devart_bigcommerce_connector-1.2.0-cp311-cp311-manylinux_2_34_x86_64.whl (36.1 MB view details)

Uploaded CPython 3.11 manylinux: glibc 2.34+ x86-64

devart_bigcommerce_connector-1.2.0-cp311-cp311-macosx_10_9_universal2.whl (69.5 MB view details)

Uploaded CPython 3.11 macOS 10.9+ universal2 (ARM64, x86-64)

devart_bigcommerce_connector-1.2.0-cp310-cp310-win_amd64.whl (37.3 MB view details)

Uploaded CPython 3.10 Windows x86-64

devart_bigcommerce_connector-1.2.0-cp310-cp310-win32.whl (34.2 MB view details)

Uploaded CPython 3.10 Windows x86

devart_bigcommerce_connector-1.2.0-cp310-cp310-manylinux_2_34_x86_64.whl (36.1 MB view details)

Uploaded CPython 3.10 manylinux: glibc 2.34+ x86-64

devart_bigcommerce_connector-1.2.0-cp310-cp310-macosx_10_9_universal2.whl (69.5 MB view details)

Uploaded CPython 3.10 macOS 10.9+ universal2 (ARM64, x86-64)

devart_bigcommerce_connector-1.2.0-cp39-cp39-win_amd64.whl (37.3 MB view details)

Uploaded CPython 3.9 Windows x86-64

devart_bigcommerce_connector-1.2.0-cp39-cp39-win32.whl (34.2 MB view details)

Uploaded CPython 3.9 Windows x86

devart_bigcommerce_connector-1.2.0-cp39-cp39-manylinux_2_34_x86_64.whl (36.1 MB view details)

Uploaded CPython 3.9 manylinux: glibc 2.34+ x86-64

devart_bigcommerce_connector-1.2.0-cp39-cp39-macosx_10_9_universal2.whl (69.5 MB view details)

Uploaded CPython 3.9 macOS 10.9+ universal2 (ARM64, x86-64)

devart_bigcommerce_connector-1.2.0-cp38-cp38-win_amd64.whl (37.3 MB view details)

Uploaded CPython 3.8 Windows x86-64

devart_bigcommerce_connector-1.2.0-cp38-cp38-win32.whl (34.2 MB view details)

Uploaded CPython 3.8 Windows x86

devart_bigcommerce_connector-1.2.0-cp38-cp38-manylinux_2_34_x86_64.whl (36.1 MB view details)

Uploaded CPython 3.8 manylinux: glibc 2.34+ x86-64

devart_bigcommerce_connector-1.2.0-cp38-cp38-macosx_10_9_universal2.whl (69.5 MB view details)

Uploaded CPython 3.8 macOS 10.9+ universal2 (ARM64, x86-64)

devart_bigcommerce_connector-1.2.0-cp37-cp37m-win_amd64.whl (37.3 MB view details)

Uploaded CPython 3.7m Windows x86-64

devart_bigcommerce_connector-1.2.0-cp37-cp37m-win32.whl (34.2 MB view details)

Uploaded CPython 3.7m Windows x86

devart_bigcommerce_connector-1.2.0-cp37-cp37m-manylinux_2_34_x86_64.whl (36.1 MB view details)

Uploaded CPython 3.7m manylinux: glibc 2.34+ x86-64

devart_bigcommerce_connector-1.2.0-cp37-cp37m-macosx_10_9_x86_64.whl (67.8 MB view details)

Uploaded CPython 3.7m macOS 10.9+ x86-64

File details

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

File metadata

File hashes

Hashes for devart_bigcommerce_connector-1.2.0-cp313-cp313-win_amd64.whl
Algorithm Hash digest
SHA256 a1b743d6eb02149e62a6c041354802a403955fccd14af161fe4f540518b84123
MD5 4545c0cd7470e390313a16a54d9eb6a6
BLAKE2b-256 509a7fdfe8c6b99f1a3f452d070ee7b4c1cf0ffdd99ccc43e3229a0579f182f2

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for devart_bigcommerce_connector-1.2.0-cp313-cp313-win32.whl
Algorithm Hash digest
SHA256 0bc90f561d44da9a99d76495fcab36b1d985949eb0ea90529567bf056a0a0bf2
MD5 cabefb7a2520664bbaff39b82e4de387
BLAKE2b-256 5136a013e479d20f3dcf677d9471518eb290e4835890cc730002198114cecc0e

See more details on using hashes here.

File details

Details for the file devart_bigcommerce_connector-1.2.0-cp313-cp313-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_bigcommerce_connector-1.2.0-cp313-cp313-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 f77bab81fc142422bdf1568700b3d46bb1f2cfa2a08d63ac6d156516b6a754fd
MD5 956258680768ce915b29e59b95ed2d2b
BLAKE2b-256 9634810a06bc627d2992b1b719f0efd6c5ab4eee6d6421d89b0645a62410f6da

See more details on using hashes here.

File details

Details for the file devart_bigcommerce_connector-1.2.0-cp313-cp313-macosx_10_9_universal2.whl.

File metadata

File hashes

Hashes for devart_bigcommerce_connector-1.2.0-cp313-cp313-macosx_10_9_universal2.whl
Algorithm Hash digest
SHA256 2d01c22e7239ff882e74b2bc28c133f039f2cc893c88c9a3146158498fcffa57
MD5 a9e6a69a3df0da166852eebf9e0ea49d
BLAKE2b-256 ee1fc4a41c760381521a1642a18f508098b91a0ceba07dc8e5c0b09f196066df

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for devart_bigcommerce_connector-1.2.0-cp312-cp312-win_amd64.whl
Algorithm Hash digest
SHA256 d35a22936fdc457b777c2d94d00654f89150c889589200f566426c70d80221be
MD5 be04507bafa620780fed3ae02b64da6e
BLAKE2b-256 7eca1df1d500625e816a3ee434788c58bcb4bc074be401236dd60b50c4385657

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for devart_bigcommerce_connector-1.2.0-cp312-cp312-win32.whl
Algorithm Hash digest
SHA256 194e761564728125d33bb96a4fb0acf9531127863b223ea3afa655ba92a5dfe5
MD5 216cf632d0cd10325711a7c4fbd57b7b
BLAKE2b-256 e65feb7686f2e3c10452ee7ac1354dccb14dc383ab23e7cd83560113b0dabadb

See more details on using hashes here.

File details

Details for the file devart_bigcommerce_connector-1.2.0-cp312-cp312-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_bigcommerce_connector-1.2.0-cp312-cp312-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 ecccb7bd49a9ff21f7d2d71040c347215c9faf5e2ff8c8a9166beeaf9fd44889
MD5 0ff8e2355dabc1665d6111741656d4b6
BLAKE2b-256 60a585d47f15282f673b33b3b16bd8ce21c148458fb37dd9928b21da598c761e

See more details on using hashes here.

File details

Details for the file devart_bigcommerce_connector-1.2.0-cp312-cp312-macosx_10_9_universal2.whl.

File metadata

File hashes

Hashes for devart_bigcommerce_connector-1.2.0-cp312-cp312-macosx_10_9_universal2.whl
Algorithm Hash digest
SHA256 aebbbbc42e6832010ff3634693393c53faa1b141a756fd355ece3ecbbe0bf28f
MD5 99817df99d8876090d53748cf0ec1703
BLAKE2b-256 84c8575e44b506f1dd86418329c559ab3ded8a4f4d850c54852b0b3957041dd6

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for devart_bigcommerce_connector-1.2.0-cp311-cp311-win_amd64.whl
Algorithm Hash digest
SHA256 31fa167dffe7668495bd016f5d15b28c4d37e8db53cbc206055656bffd78f36f
MD5 8fe42b920a0cd601f6c9bf93a142c679
BLAKE2b-256 618ad74f81b129012ab4e420171354bf81066ceb15db5985cef0238acda97b27

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for devart_bigcommerce_connector-1.2.0-cp311-cp311-win32.whl
Algorithm Hash digest
SHA256 edcd58376e007cd560feb08bf7635436f9ee46d741b2f98294c79efcbef1d87e
MD5 183a5b2624dfdc5b3159ce7fd700f8f2
BLAKE2b-256 0247ec8b55d47d2684a14589b51280c3fd5e5c6455fd3d08fe166ab18b5f6ebe

See more details on using hashes here.

File details

Details for the file devart_bigcommerce_connector-1.2.0-cp311-cp311-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_bigcommerce_connector-1.2.0-cp311-cp311-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 6402cf0df25de341529e37ff87f46d233b251b7d8988195e54f2154889b2f0c7
MD5 323d5cd9b4d24f41fc746e10a1e6a985
BLAKE2b-256 3aea65ec9debe8aece4e0075a27a8e56badee73df3333a6ec13e93ab70bf99e1

See more details on using hashes here.

File details

Details for the file devart_bigcommerce_connector-1.2.0-cp311-cp311-macosx_10_9_universal2.whl.

File metadata

File hashes

Hashes for devart_bigcommerce_connector-1.2.0-cp311-cp311-macosx_10_9_universal2.whl
Algorithm Hash digest
SHA256 4267b42a5de2ce51dbb9bcb5e2b8f52ab91d091a9a5b258099a6d59b8b423d27
MD5 b753d7d4ebdf4c560410d5af824fcb6e
BLAKE2b-256 3ed905ca7f86a4acd9503b98a06ff0f6d5ef50ef941ba99eceff3ccdce04330a

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for devart_bigcommerce_connector-1.2.0-cp310-cp310-win_amd64.whl
Algorithm Hash digest
SHA256 c26602180b30eb33dd7bb3b0dc77aef69d14dd18a9d5a0d54b0bb2e37b7dceab
MD5 4cb21a4221dba58f8f59955b552b4721
BLAKE2b-256 5dc95625f36eb3b456b3d1035f69ef11723ada436140bd418e3e603a23fa4f62

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for devart_bigcommerce_connector-1.2.0-cp310-cp310-win32.whl
Algorithm Hash digest
SHA256 0efba4f5cfcdd23f1058c56067d3fd03b0f9f04a71183f3b8533ce74ae9e2e84
MD5 aa233bf60b6f8a532e2126a5ef0cdf14
BLAKE2b-256 4eb8668528e3c97eac7b970469aa4b1c7cc0973e1f37f65a357d78556cc22c63

See more details on using hashes here.

File details

Details for the file devart_bigcommerce_connector-1.2.0-cp310-cp310-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_bigcommerce_connector-1.2.0-cp310-cp310-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 dcea9730a673b4c2201007c71274b1c95501a043ca67ad8fb0d9f27a277f70f7
MD5 d8377efb4e6c8f83567cb38219423571
BLAKE2b-256 4a22f5575a5b5763daee7de595f9f8188620e8fb11b7d346bc8935db26ab46fd

See more details on using hashes here.

File details

Details for the file devart_bigcommerce_connector-1.2.0-cp310-cp310-macosx_10_9_universal2.whl.

File metadata

File hashes

Hashes for devart_bigcommerce_connector-1.2.0-cp310-cp310-macosx_10_9_universal2.whl
Algorithm Hash digest
SHA256 8d75cdf30f1219b0edb3979aae6dfe9b70e0ef5da996832cf59f91efb6626395
MD5 898adcc70d4189a4bd6e6b1fd6079b4c
BLAKE2b-256 512be01be39a7e2da64590124af22a68a79602c787b250efc129a0cfabfcda67

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for devart_bigcommerce_connector-1.2.0-cp39-cp39-win_amd64.whl
Algorithm Hash digest
SHA256 68b7152cc43c7c85e572b9b2c5e898a2647f3bd508dd38e4ea4bdb22c167f82d
MD5 411e62d4dd5f34b21eb13d346bbffbfa
BLAKE2b-256 8cb2a82967af04cdbaad04fd7ec6b78665a06f77c1b1c667a15283f4601975ba

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for devart_bigcommerce_connector-1.2.0-cp39-cp39-win32.whl
Algorithm Hash digest
SHA256 36e64faca87dc87abc1d5842478265b6e951e85cd536dacb0f557c5756166a5e
MD5 e85a0f3ab1e1d0cd269ea3288dac11ef
BLAKE2b-256 da44c9a2f1f8f8215c14a7c9226647412353e4f3b10fca66c964381d2ca154a7

See more details on using hashes here.

File details

Details for the file devart_bigcommerce_connector-1.2.0-cp39-cp39-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_bigcommerce_connector-1.2.0-cp39-cp39-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 aacbe73cc099387ebc01fd9e3fa352c842f31a73148f467342bf3672e2a4e212
MD5 c79ac532fa524a4d268a64aacb70615e
BLAKE2b-256 a168d790eee1283173a7c29ad6dcb3b8fa49c6485adbb3fc5f5c32aaf26893ee

See more details on using hashes here.

File details

Details for the file devart_bigcommerce_connector-1.2.0-cp39-cp39-macosx_10_9_universal2.whl.

File metadata

File hashes

Hashes for devart_bigcommerce_connector-1.2.0-cp39-cp39-macosx_10_9_universal2.whl
Algorithm Hash digest
SHA256 9f1575ef851b44bf1bef4ff9a6f7a7d9f39f50d0a8f8d18f7454685d3868a13e
MD5 ecc93818ca681d62d7f7cd39dc234497
BLAKE2b-256 d65a70dbb2ebd9a00e647004d639b9cc5646ace63922f787284805d7b7f8b3fc

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for devart_bigcommerce_connector-1.2.0-cp38-cp38-win_amd64.whl
Algorithm Hash digest
SHA256 46bdf2c14eee764c911e87dc66661128cc169a41a24c6d0d3ebe5037d27a8f8a
MD5 91305c064f7d270c5de8f62aaa02b3ff
BLAKE2b-256 f974cca1fce5973584e92ae5abd5829f1bd2589efc02ef15db3bea68398e1d0b

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for devart_bigcommerce_connector-1.2.0-cp38-cp38-win32.whl
Algorithm Hash digest
SHA256 2b843834703335ad5ab67069ff4bc783e38c5d28c047b62e975acf6d9f7da764
MD5 016bd0c4bdbe517f91751cca81932f43
BLAKE2b-256 e02b72c4d45fe21f08f71011a947a4156383649adf26ab6309b8cc980c4244bf

See more details on using hashes here.

File details

Details for the file devart_bigcommerce_connector-1.2.0-cp38-cp38-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_bigcommerce_connector-1.2.0-cp38-cp38-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 7a5009a1559e66ba7383adbbb10afd272f370bc2d7ea0f8222a6398f8b32b98f
MD5 a011b87501ed00277be9be6686e20e15
BLAKE2b-256 0c23e0f421def6ffa05afbd8020f5aa69a9b7b5c93005e7d3cf2a61fa47596ba

See more details on using hashes here.

File details

Details for the file devart_bigcommerce_connector-1.2.0-cp38-cp38-macosx_10_9_universal2.whl.

File metadata

File hashes

Hashes for devart_bigcommerce_connector-1.2.0-cp38-cp38-macosx_10_9_universal2.whl
Algorithm Hash digest
SHA256 29593b9a5acd353d92b1270c9567629a4134ded5cf80b176acfc80bcb4f15df8
MD5 9a5595fdc13aafbaa6408eed0bb1fd43
BLAKE2b-256 bf636e0c9be8816d863d6545891ae5e3c3c84a82f489d27d62204b8869e1bcc3

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for devart_bigcommerce_connector-1.2.0-cp37-cp37m-win_amd64.whl
Algorithm Hash digest
SHA256 9a3bbc73d2e8ac63e1101080a7ab08e2fe8779635da6095c162e14ac6bce3145
MD5 73bb710c970acca1e2ee050ff16e002b
BLAKE2b-256 0179ee6d931248839d8d997bdda519dc8171e1ce884cf8c1cb33d2781ab127a5

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for devart_bigcommerce_connector-1.2.0-cp37-cp37m-win32.whl
Algorithm Hash digest
SHA256 f4ef9f26226db76100193052441ca08c8dbf33bce5949146015c6fae8af7fdbc
MD5 36b1587069df3b42f0ee2782bb29bbef
BLAKE2b-256 c07e2a0cf9320d9311b485856ac6bbea59d3302438d622885cbd0b92dd67d7bf

See more details on using hashes here.

File details

Details for the file devart_bigcommerce_connector-1.2.0-cp37-cp37m-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_bigcommerce_connector-1.2.0-cp37-cp37m-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 615a6937710f1849e6eccc0fe755c998fc6d8c39e513616031b3e5949f689427
MD5 db82b0eb6fbc84752f0564beead80a69
BLAKE2b-256 1421d7e3c9936505f85c281851e2c0e34cde5a5a9439f7d55a3a472d5ba44063

See more details on using hashes here.

File details

Details for the file devart_bigcommerce_connector-1.2.0-cp37-cp37m-macosx_10_9_x86_64.whl.

File metadata

File hashes

Hashes for devart_bigcommerce_connector-1.2.0-cp37-cp37m-macosx_10_9_x86_64.whl
Algorithm Hash digest
SHA256 5d0a04478591f9c225725fd8aa3e38aa5ddd9a051f1a57cc0707691c15f1eac2
MD5 522d66da4cb0ca960c036f1d3bfbb052
BLAKE2b-256 7c07283a49a1449631d0514858e21d13a35636534b7b8bd2a424adf4804cde08

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