jprdonnelly/airbyte
1
0
Fork 0
mirror of synced 2025-12-19 18:14:56 -05:00
Code Issues Packages Projects Releases Wiki Activity
Files
master
airbyte/docs/integrations/sources/netsuite.md
octavia-bot-hoard[bot] f454cdcc60 🐙 source-netsuite: run up-to-date pipeline [2025-10-14] (#67787) 
# Update source-netsuite

This PR was autogenerated by running `airbyte-ci connectors
--name=source-netsuite up_to_date --pull`

We've set the `auto-merge` label on it, so it will be automatically
merged if the CI pipelines pass.
If you don't want to merge it automatically, please remove the
`auto-merge` label.
Please reach out to the Airbyte Connector Tooling team if you have any
questions or concerns.


## Operations

- Upgrade the base image to the latest version in metadata.yaml: Skipped

- Update versions of libraries in poetry: Successful

- PATCH bump source-netsuite version to 0.1.27: Successful

- Build source-netsuite docker image for platform(s) linux/amd64,
linux/arm64: Successful

- Get dependency updates: Successful

- Create or update pull request on Airbyte repository: Successful

- Add changelog entry: Successful




## Dependency updates

We use [`syft`](https://github.com/anchore/syft) to generate a SBOM for
the latest connector version and the one from the PR.
It allows us to spot the dependencies that have been updated at all
levels and for all types of dependencies (system, python, java etc.).
Here are the dependencies that have been updated compared to
`airbyte/source-netsuite:latest`.
Keep in mind that `:latest` does not always match the connector code on
the main branch.
It is the latest released connector image when the head commit of this
branch was created.

| Type | Name | State | Previous Version | New Version |
|------|------|-------|-------------|------------------|
| python | MarkupSafe | updated | 3.0.2 | **3.0.3** |
| python | PyYAML | updated | 6.0.2 | **6.0.3** |
| python | anyio | updated | 4.10.0 | **4.11.0** |
| python | attrs | updated | 25.3.0 | **25.4.0** |
| python | cachetools | updated | 6.1.0 | **6.2.1** |
| python | cattrs | updated | 25.1.1 | **25.3.0** |
| python | certifi | updated | 2025.8.3 | **2025.7.9** |
| python | cffi | updated | 1.17.1 | **2.0.0** |
| python | charset-normalizer | updated | 3.4.3 | **3.4.4** |
| python | idna | updated | 3.10 | **3.11** |
| python | orjson | updated | 3.11.2 | **3.11.3** |
| python | platformdirs | updated | 4.3.8 | **4.4.0** |
| python | pycparser | updated | 2.22 | **2.23** |
| python | pydantic | updated | 1.10.22 | **1.10.24** |
| python | requests | updated | 2.32.4 | **2.32.5** |
| python | typing_extensions | updated | 4.14.1 | **4.15.0** |
| python | source-netsuite | removed | 0.1.21 | **not present** |

> [!IMPORTANT]
> **Auto-merge enabled.**
> 
> _This PR is set to merge automatically when all requirements are met._

Co-authored-by: octavia-bot-hoard[bot] <230633153+octavia-bot-hoard[bot]@users.noreply.github.com>
2025-10-14 16:29:25 -04:00

9.1 KiB
Raw Permalink Blame History

Oracle Netsuite

One unified business management suite, encompassing ERP/Financials, CRM and ecommerce for more than 31,000 customers.

This connector implements the SuiteTalk REST Web Services and uses REST API to fetch the customers data.

Prerequisites

  • Oracle NetSuite account
  • Allowed access to all Account permissions options

Airbyte OSS and Airbyte Cloud

  • Realm (Account ID)
  • Consumer Key
  • Consumer Secret
  • Token ID
  • Token Secret

Setup guide

Step 1: Create NetSuite account

  1. Create account on Oracle NetSuite
  2. Confirm your Email

Step 2: Setup NetSuite account

Step 2.1: Obtain Realm info

  1. Login into your NetSuite account
  2. Go to Setup » Company » Company Information
  3. Copy your Account ID (Realm). It should look like 1234567 for the Production env. or 1234567_SB2 - for a Sandbox

Step 2.2: Enable features

  1. Go to Setup » Company » Enable Features
  2. Click on SuiteCloud tab
  3. Scroll down to SuiteScript section
  4. Enable checkbox for CLIENT SUITESCRIPT and SERVER SUITESCRIPT
  5. Scroll down to Manage Authentication section
  6. Enable checkbox TOKEN-BASED AUTHENTICATION
  7. Scroll down to SuiteTalk (Web Services)
  8. Enable checkbox REST WEB SERVISES
  9. Save the changes

Step 2.3: Create Integration (obtain Consumer Key and Consumer Secret)

  1. Go to Setup » Integration » Manage Integrations » New
  2. Fill the Name field (we recommend to put airbyte-rest-integration for a name)
  3. Make sure the State is enabled
  4. Enable checkbox Token-Based Authentication in Authentication section
  5. Save changes
  6. After that, Consumer Key and Consumer Secret will be showed once (copy them to the safe place)

Step 2.4: Setup Role

  1. Go to Setup » Users/Roles » Manage Roles » New
  2. Fill the Name field (we recommend to put airbyte-integration-role for a name)
  3. Scroll down to Permissions tab
  4. (REQUIRED) Click on Transactions and manually add all the dropdown entities with either full or view access level.
  5. (REQUIRED) Click on Reports and manually add all the dropdown entities with either full or view access level.
  6. (REQUIRED) Click on Lists and manually add all the dropdown entities with either full or view access level.
  7. (REQUIRED) Click on Setup and manually add all the dropdown entities with either full or view access level.
  • Make sure you've done all REQUIRED steps correctly, to avoid sync issues in the future.
  • Please edit these params again when you rename or customise any Object in Netsuite for airbyte-integration-role to reflect such changes.

Step 2.5: Setup User

  1. Go to Setup » Users/Roles » Manage Users
  2. In column Name click on the user’s name you want to give access to the airbyte-integration-role
  3. Then click on Edit button under the user’s name
  4. Scroll down to Access tab at the bottom
  5. Select from dropdown list the airbyte-integration-role role which you created in step 2.4
  6. Save changes

Step 2.6: Create Access Token for role

  1. Go to Setup » Users/Roles » Access Tokens » New
  2. Select an Application Name
  3. Under User select the user you assigned the airbyte-integration-role in the step 2.4
  4. Inside Role select the one you gave to the user in the step 2.5
  5. Under Token Name you can give a descriptive name to the Token you are creating (we recommend to put airbyte-rest-integration-token for a name)
  6. Save changes
  7. After that, Token ID and Token Secret will be showed once (copy them to the safe place)

Step 2.7: Summary

You have copied next parameters

  • Realm (Account ID)
  • Consumer Key
  • Consumer Secret
  • Token ID
  • Token Secret Also you have properly Configured Account with Correct Permissions and Access Token for User and Role you've created early.

Step 3: Set up the source connector in Airbyte

For Airbyte Cloud:

  1. Log into your Airbyte Cloud account.
  2. In the left navigation bar, click Sources. In the top-right corner, click + new source.
  3. On the source setup page, select NetSuite from the Source type dropdown and enter a name for this connector.
  4. Add Realm
  5. Add Consumer Key
  6. Add Consumer Secret
  7. Add Token ID
  8. Add Token Secret
  9. Click Set up source.

For Airbyte OSS:

  1. Go to local Airbyte page.
  2. In the left navigation bar, click Sources. In the top-right corner, click + new source.
  3. On the source setup page, select NetSuite from the Source type dropdown and enter a name for this connector.
  4. Add Realm
  5. Add Consumer Key
  6. Add Consumer Secret
  7. Add Token ID
  8. Add Token Secret
  9. Click Set up source

Supported sync modes

The NetSuite source connector supports the following sync modes:

  • Full Refresh
  • Incremental

Supported Streams

  • Streams are generated based on ROLE and USER access to them as well as Account settings, make sure you're using the correct role assigned in our case airbyte-integration-role or any other custom ROLE granted to the Access Token, having the access to the NetSuite objects for data sync, please refer to the Setup guide > Step 2.4 and Setup guide > Step 2.5

Performance considerations

The connector is restricted by Netsuite Concurrency Limit per Integration.

Changelog

Expand to review
Version Date Pull Request Subject
0.1.27 2025-10-14 67787 Update dependencies
0.1.26 2025-10-07 67429 Update dependencies
0.1.25 2025-09-30 66934 Update dependencies
0.1.24 2025-09-23 66623 Update dependencies
0.1.23 2025-09-09 65813 Update dependencies
0.1.22 2025-08-23 65215 Update dependencies
0.1.21 2025-08-16 61055 Update dependencies
0.1.20 2025-07-21 63698 Add support for german date format in NetSuite input
0.1.19 2025-05-24 60581 Update dependencies
0.1.18 2025-05-10 60086 Update dependencies
0.1.17 2025-05-03 59481 Update dependencies
0.1.16 2025-04-27 59091 Update dependencies
0.1.15 2025-04-19 58531 Update dependencies
0.1.14 2025-04-12 57860 Update dependencies
0.1.13 2025-04-05 57301 Update dependencies
0.1.12 2025-03-29 56692 Update dependencies
0.1.11 2025-03-22 56060 Update dependencies
0.1.10 2025-03-08 55455 Update dependencies
0.1.9 2025-03-05 55207 Add support for additional date format in Netsuite input
0.1.8 2025-03-01 54821 Update dependencies
0.1.7 2025-02-22 54363 Update dependencies
0.1.6 2025-02-15 53853 Update dependencies
0.1.5 2025-02-08 53243 Update dependencies
0.1.4 2024-07-29 42857 Migrate connector to Poetry
0.1.3 2023-01-20 21645 Minor issues fix, Setup Guide corrections for public docs
0.1.1 2022-09-28 17304 Migrate to per-stream state
0.1.0 2022-09-15 16093 Initial Alpha release
Reference in New Issue View Git Blame Copy Permalink