Skip to main content

New level of functionality and performance in data access via Python

Project description

Python Connector for NetSuite

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

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

my_connection = devart.netsuite.connect(
    Ver=1,
    Authentication="Basic",
    UserID="your_username",
    Password="your_password",
    AccountId="your_account_id",
    RoleId="your_role_id",
    ApplicationId="your_application_id"
)

If you're using token-based authentication:

my_connection = devart.netsuite.connect(
    Version="Ver2",
    Authentication="TokenBased",
    AccountId="your_account_id",
    AccountTimeZone="your_account_timezone",
    ConsumerKey="your_consumer_key",
    ConsumerSecret="your_consumer_secret",
    TokenId="your_token_id",
    TokenSecret="your_token_secret"
)

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

my_connection = devart.netsuite.connect(
    Ver=2,
    Authentication="OAuth",
    AccountId="your_account_id",
    AccountTimeZone="your_account_timezone",
    ClientID="your_client_id",
    ClientSecret="your_client_secret",
    RefreshToken="your_refresh_token"
)

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

response = devart.netsuite.signin(
    AccountId="your_account_id",
    ClientId="your_client_id",
    ClientSecret="your_client_secret")
my_connection = devart.netsuite.connect(
    Authentication="OAuth",
    AccountID="your_account_id",
    AccountTimeZone="your_account_timezone",
    ClientID="your_client_id",
    ClientSecret="your_client_secret",
    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/netsuite/ordering.html

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

What's new

Python Connector for NetSuite 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_netsuite_connector-1.2.0-cp313-cp313-win_amd64.whl (6.1 MB view details)

Uploaded CPython 3.13 Windows x86-64

devart_netsuite_connector-1.2.0-cp313-cp313-win32.whl (5.9 MB view details)

Uploaded CPython 3.13 Windows x86

devart_netsuite_connector-1.2.0-cp312-cp312-win_amd64.whl (6.1 MB view details)

Uploaded CPython 3.12 Windows x86-64

devart_netsuite_connector-1.2.0-cp312-cp312-win32.whl (5.9 MB view details)

Uploaded CPython 3.12 Windows x86

devart_netsuite_connector-1.2.0-cp311-cp311-win_amd64.whl (6.1 MB view details)

Uploaded CPython 3.11 Windows x86-64

devart_netsuite_connector-1.2.0-cp311-cp311-win32.whl (5.9 MB view details)

Uploaded CPython 3.11 Windows x86

devart_netsuite_connector-1.2.0-cp310-cp310-win_amd64.whl (6.1 MB view details)

Uploaded CPython 3.10 Windows x86-64

devart_netsuite_connector-1.2.0-cp310-cp310-win32.whl (5.9 MB view details)

Uploaded CPython 3.10 Windows x86

devart_netsuite_connector-1.2.0-cp39-cp39-win_amd64.whl (6.1 MB view details)

Uploaded CPython 3.9 Windows x86-64

devart_netsuite_connector-1.2.0-cp39-cp39-win32.whl (5.9 MB view details)

Uploaded CPython 3.9 Windows x86

devart_netsuite_connector-1.2.0-cp38-cp38-win_amd64.whl (6.1 MB view details)

Uploaded CPython 3.8 Windows x86-64

devart_netsuite_connector-1.2.0-cp38-cp38-win32.whl (5.9 MB view details)

Uploaded CPython 3.8 Windows x86

devart_netsuite_connector-1.2.0-cp37-cp37m-win_amd64.whl (6.1 MB view details)

Uploaded CPython 3.7m Windows x86-64

devart_netsuite_connector-1.2.0-cp37-cp37m-win32.whl (5.9 MB view details)

Uploaded CPython 3.7m Windows x86

File details

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

File metadata

File hashes

Hashes for devart_netsuite_connector-1.2.0-cp313-cp313-win_amd64.whl
Algorithm Hash digest
SHA256 9f2262c01cc88d81b2183f517c5d7b0c3f82b6694d0dd9bfc781b45bda61ad1d
MD5 eb738bf579b1d67d50fa37328a352d6f
BLAKE2b-256 fac8708bccdc3ae78de301d2971361de448d96dd6e1456fbfcad736e6eeda397

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for devart_netsuite_connector-1.2.0-cp313-cp313-win32.whl
Algorithm Hash digest
SHA256 580dd600e3dda1f31d30d06b62dd2979e5369764340cb3547751918e5a5c825a
MD5 f730ad18ded278072894f9ff3c0f84da
BLAKE2b-256 eec4f7734e00d6515bace3035c4c841d508cc67090af1b5a6a0eaaa65fa23c2c

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for devart_netsuite_connector-1.2.0-cp312-cp312-win_amd64.whl
Algorithm Hash digest
SHA256 318779b1b1219874c21eb7d6638d521e499bf963b780b1d8da11f47974c151f0
MD5 55d6079e3d2055bc0092960f18699f01
BLAKE2b-256 50b55f0222fc62cbab08db00fee2bfb33fa40058762fc5c75186c217d779a6c5

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for devart_netsuite_connector-1.2.0-cp312-cp312-win32.whl
Algorithm Hash digest
SHA256 223c51f731248fa17f43ef55e1fe8ca3220da6e2ae85ab1de45371c9f06e2ee2
MD5 683ceb26fda744777d050dfba80b48d6
BLAKE2b-256 b3ad4175d69066006263822ad02a9f387f1119d328ae801da0b0b2530364c7b4

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for devart_netsuite_connector-1.2.0-cp311-cp311-win_amd64.whl
Algorithm Hash digest
SHA256 c8cabd92d7aebd36009c5ad15ece93fb382ebde7f942d92ae3232743843def82
MD5 09a22474fd0269a96aef45c4308fd30e
BLAKE2b-256 77546ec37f722b15436a26b43f80df994970b13e3c798c635b963af203a773fa

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for devart_netsuite_connector-1.2.0-cp311-cp311-win32.whl
Algorithm Hash digest
SHA256 14a6b610c71ff80e51297a6e5ae30703e18be098d629505fa15074dc21e04b6b
MD5 5c8d69f1ce84922e3c4d8490dff1417c
BLAKE2b-256 f0529e2c4aa4575babe2d92dc8ebae0ea8fee95d30d48f7c46c8b67f7ba8eb00

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for devart_netsuite_connector-1.2.0-cp310-cp310-win_amd64.whl
Algorithm Hash digest
SHA256 353af4c0ece1e02392c615d99524c8bd0e8071df74b67069d23455f63aa516d1
MD5 33edb58e6fbd86c235a39f95e6ca20d8
BLAKE2b-256 e162c77776d42ea575d9e1ae206a7d734a58d0a1073dfb1878336c50ad4e7860

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for devart_netsuite_connector-1.2.0-cp310-cp310-win32.whl
Algorithm Hash digest
SHA256 c9e394c019ea8358ae02f49e8dbceac90f41fd9657c50f883bb1419b07890517
MD5 2f272a3757ab6c0d6b784caf163c0dfd
BLAKE2b-256 d2ca5c3a9b0f961124f6f53afa8b3d49b64c6e8bfa2f9dad0557b024fc68df5a

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for devart_netsuite_connector-1.2.0-cp39-cp39-win_amd64.whl
Algorithm Hash digest
SHA256 c9589a6091943b63373242434abbdafd1b8c6be5c711829203cefbfff233ae0a
MD5 2382c3b1906befcff69cd1a40a2b7f6c
BLAKE2b-256 3f5bb1d313d11f31726d6b001ff4fb893c477d3b3ea4a64d8223032caa57ef72

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for devart_netsuite_connector-1.2.0-cp39-cp39-win32.whl
Algorithm Hash digest
SHA256 f88f378d251b592c5786f14a820ac47027b99a8fdd0553af2fa1cc3c55b31296
MD5 3c991a752c95ba858a077b41f3e4ea41
BLAKE2b-256 b41110091e420ed7aad1feb7991e7a82fcf52d8428274e9f7e8785b6f7d499dd

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for devart_netsuite_connector-1.2.0-cp38-cp38-win_amd64.whl
Algorithm Hash digest
SHA256 d0bb14c0861d67a52dae32f84e5ebc0f0e94fac0567aebaa1b5c01c6e53e120b
MD5 648cdd95b703af80116ea8ecbe671ee1
BLAKE2b-256 5cf338644e015576fc08651971c1c1c3f740bdef4bb6d4f2c28eeb627e19aa64

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for devart_netsuite_connector-1.2.0-cp38-cp38-win32.whl
Algorithm Hash digest
SHA256 42b6a0be1ead983a5f71af60f0a9a6577c50944c230e3342be2a8d9ed361b0a4
MD5 ab04cc14dfbd2d40314c2a68ca4e5c99
BLAKE2b-256 0b8a9f271b59b88d8a0cd09889899a1ec67cf3ba399b7aef04044621c8760ff9

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for devart_netsuite_connector-1.2.0-cp37-cp37m-win_amd64.whl
Algorithm Hash digest
SHA256 f3d18e3e164dfa01a8926608c654259e372d824582fc09577b4b19a4b9c77d30
MD5 144294fb3c52c32721596f85da430f1e
BLAKE2b-256 38c576dcb774520e615fb014eb313f36bca249d076299aed50642cb8006bf755

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for devart_netsuite_connector-1.2.0-cp37-cp37m-win32.whl
Algorithm Hash digest
SHA256 0b29fd4eded42a9915a97f9ca6d2259b49ec50930422615cfafbbe9c5717f4fa
MD5 af47eae040dfdbb78f147c2752898b8d
BLAKE2b-256 a86d181dfa92afc8dc682034990643a4d34fd758962209e1089fa6e6cec3a224

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