NetSuite
Table of Contents
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:
Installation and configuration #
-
Add the
tap-netsuite
extractor to your project usingmeltano add
:meltano add extractor tap-netsuite
-
Configure the settings below using
meltano config
.
Next steps #
Follow the remaining steps of the Getting Started guide:
- Select entities and attributes to extract
- Add a loader to send data to a destination
- Run a data integration (EL) pipeline
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
)
#
-
Environment variable:
TAP_NETSUITE_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
)
#
-
Environment variable:
TAP_NETSUITE_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
)
#
-
Environment variable:
TAP_NETSUITE_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
)
#
-
Environment variable:
TAP_NETSUITE_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
)
#
-
Environment variable:
TAP_NETSUITE_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
)
#
-
Environment variable:
TAP_NETSUITE_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
)
#
-
Environment variable:
TAP_NETSUITE_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
)
#
-
Environment variable:
TAP_NETSUITE_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!