The tap-netsuite Meltano extractor pulls data from NetSuite that can then be sent to a destination using a loader.

Getting Started #

Prerequisites #

If you haven't already, follow the initial steps of the Getting Started guide:

  1. Install Meltano
  2. Create your Meltano project

Installation and configuration #

  1. Add the tap-netsuite extractor to your project using meltano add :

    meltano add extractor tap-netsuite
  2. Configure the settings below using meltano config .

Next steps #

Follow the remaining steps of the Getting Started guide:

  1. Select entities and attributes to extract
  2. Add a loader to send data to a destination
  3. Run a data integration (EL) pipeline
If you run into any issues, learn how to get help.

Capabilities #

Settings #

tap-netsuite requires the configuration of the following settings:

The settings for extractor tap-netsuite that are known to Meltano are documented below. To quickly find the setting you're looking for, use the Table of Contents at the top of the page.

NetSuite Account (ns_account) #

Your account Id. This can be found under Setup -> Company -> Company Information. Look for Account Id. Note “_SB” is for Sandbox account.

How to use #

Manage this setting using meltano config or an environment variable:

meltano config tap-netsuite set ns_account <ns_account>

export TAP_NETSUITE_NS_ACCOUNT=<ns_account>

NetSuite Consumer Key (ns_consumer_key) #

Your consumer key for token based authentication consumer key for SOAP connection. Visit the https://support.cazoomi.com/hc/en-us/articles/360010093392-How-to-Setup-NetSuite-Token-Based-Authentication-as-Authentication-Type for details.

How to use #

Manage this setting using meltano config or an environment variable:

meltano config tap-netsuite set ns_consumer_key <ns_consumer_key>

export TAP_NETSUITE_NS_CONSUMER_KEY=<ns_consumer_key>

NetSuite Consumer Secret (ns_consumer_secret) #

Your consumer secret for token based authentication consumer key for SOAP connection. Visit the https://support.cazoomi.com/hc/en-us/articles/360010093392-How-to-Setup-NetSuite-Token-Based-Authentication-as-Authentication-Type for details.

How to use #

Manage this setting using meltano config or an environment variable:

meltano config tap-netsuite set ns_consumer_secret <ns_consumer_secret>

export TAP_NETSUITE_NS_CONSUMER_SECRET=<ns_consumer_secret>

NetSuite Token Key (ns_token_key) #

Your token key for token based authentication consumer key for SOAP connection. Visit the https://support.cazoomi.com/hc/en-us/articles/360010093392-How-to-Setup-NetSuite-Token-Based-Authentication-as-Authentication-Type for details.

How to use #

Manage this setting using meltano config or an environment variable:

meltano config tap-netsuite set ns_token_key <ns_token_key>

export TAP_NETSUITE_NS_TOKEN_KEY=<ns_token_key>

NetSuite Token Secret (ns_token_secret) #

Your token secret for token based authentication consumer key for SOAP connection. Visit the https://support.cazoomi.com/hc/en-us/articles/360010093392-How-to-Setup-NetSuite-Token-Based-Authentication-as-Authentication-Type for details.

How to use #

Manage this setting using meltano config or an environment variable:

meltano config tap-netsuite set ns_token_secret <ns_token_secret>

export TAP_NETSUITE_NS_TOKEN_SECRET=<ns_token_secret>

Select Fields By Default (select_fields_by_default) #

When new fields are discovered in NetSuite objects, the select_fields_by_default key describes whether or not the tap will select those fields by default.

How to use #

Manage this setting using meltano config or an environment variable:

meltano config tap-netsuite set select_fields_by_default true

export TAP_NETSUITE_SELECT_FIELDS_BY_DEFAULT=true

Is Sandbox (is_sandbox) #

The is_sandbox should always be set to “true” if you are connecting Production account of NetSuite. Set it to false if you want to connect to SandBox acccount.

How to use #

Manage this setting using meltano config or an environment variable:

meltano config tap-netsuite set is_sandbox true

export TAP_NETSUITE_IS_SANDBOX=true

Start Date (start_date) #

Determines how much historical data will be extracted. Please be aware that the larger the time period and amount of data, the longer the initial extraction can be expected to take.

How to use #

Manage this setting using meltano config or an environment variable:

meltano config tap-netsuite set start_date YYYY-MM-DDTHH:MM:SSZ

export TAP_NETSUITE_START_DATE=YYYY-MM-DDTHH:MM:SSZ

Looking for help? #

If you're having trouble getting the tap-netsuite extractor to work, look for an existing issue in its repository, file a new issue, or join the Meltano Slack community and ask for help in the #plugins-general channel.

Found an issue on this page? #

This page is generated from a YAML file that you can contribute changes to. Edit it on GitHub!