NetSuite SuiteAnalytics API Configuration

Request

POST https://api.fivetran.com/v1/connections

{
  "group_id": "group_id",
  "service": "netsuite_suiteanalytics",
  "trust_certificates": true,
  "trust_fingerprints": true,
  "run_setup_tests": true,
  "paused": false,
  "pause_after_trial": false,
  "sync_frequency": 1440,
  "data_delay_sensitivity": "NORMAL",
  "data_delay_threshold": 0,
  "daily_sync_time": "14:00",
  "schedule_type": "auto",
  "connect_card_config": {
    "redirect_uri": "https://your.site/path",
    "hide_setup_guide": true
  },
  "proxy_agent_id": "proxy_agent_id",
  "private_link_id": "private_link_id",
  "networking_method": "Directly",
  "hybrid_deployment_agent_id": "hybrid_deployment_agent_id",
  "destination_configuration": {
    "virtual_warehouse": "virtual_warehouse"
  },
  "destination_schema_names": "SOURCE_NAMING",
  "config": {
    "role": "netsuite_role_id",
    "consumer_secret": "netsuite_consumer_secret",
    "private_key": "private_key",
    "token_key": "netsuite_token_key",
    "certificate_id": "certificate_id",
    "consumer_key": "netsuite_consumer_key",
    "token_secret": "netsuite_token_secret",
    "password": "netsuite_password",
    "port": 0,
    "datasource": "NetSuite2.com",
    "host": "netsuite_service_host",
    "account": "netsuite_account_id",
    "email": "netsuite_email",
    "should_sync_reimport_tables": true,
    "schema": "schema_name"
  }
}

Config parameters

Name	Description
`role`	The NetSuite Role ID for connection.
`consumer_secret`	Consumer Secret
`private_key`	Private Key
`token_key`	Token ID
`certificate_id`	Certificate Id
`consumer_key`	Consumer Key
`token_secret`	Token Secret
`password`	The NetSuite user's password.
`port`	The NetSuite service host port.
`datasource`	The NetSuite data source value: `NetSuite.com`.
`host`	The NetSuite service host address.
`account`	The NetSuite Account ID.
`email`	The NetSuite user's email address.
`should_sync_reimport_tables`	Re-sync re-import tables during every sync
`schema` (required)	Destination schema name. Schema name is permanent and cannot be changed after connection creation

Authorization

There are four ways to authorize this connector type:

Token-based (NetSuite2.com): By specifying the datasource as "NetSuite2.com" and the values for the host, port, account, role, consumer_key, consumer_secret, token_key and token_secret parameters in the request.

POST https://api.fivetran.com/v1/connections

{
  "service": "netsuite_suiteanalytics",
  "group_id": "group_id",
  "config": {
    "host": "netsuite_service_host",
    "port": 0,
    "datasource": "NetSuite2.com",
    "account": "netsuite_account_id",
    "role": "netsuite_role_id",
    "consumer_key": "netsuite_consumer_key",
    "consumer_secret": "netsuite_consumer_secret",
    "token_key": "netsuite_token_key",
    "token_secret": "netsuite_token_secret"
  }
}

OAuth 2.0 (NetSuite2.com): By specifying the datasource as "NetSuite2.com" and the values for the host, port, account, role, consumer_key, certificate_id and private_key parameters in the request.

POST https://api.fivetran.com/v1/connections

{
  "service": "netsuite_suiteanalytics",
  "group_id": "group_id",
  "config": {
    "host": "netsuite_service_host",
    "port": 0,
    "datasource": "NetSuite2.com",
    "account": "netsuite_account_id",
    "role": "netsuite_role_id",
    "consumer_key": "netsuite_consumer_key",
    "certificate_id": "certificate_id",
    "private_key": "private_key"
  }
}

Basic (NetSuite.com): By specifying the datasource as "NetSuite.com" and the values for the host, port, account, email and password parameters in the request.

POST https://api.fivetran.com/v1/connections

{
  "service": "netsuite_suiteanalytics",
  "group_id": "group_id",
  "config": {
    "host": "netsuite_service_host",
    "port": 0,
    "datasource": "NetSuite.com",
    "account": "netsuite_account_id",
    "email": "netsuite_email",
    "password": "netsuite_password"
  }
}

By using the Connect Card or the Fivetran dashboard.