ÃÛ¶¹ÊÓƵ

DocumentationExperience PlatformSource Connectors Guide

[Beta]{class="badge informative"}

Oracle NetSuite

Last update: Thu Mar 07 2024 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATED FOR:

  • Developer
NOTE
The Oracle NetSuite source is in beta. Please read the sources overview for more information on using beta-labeled sources.

ÃÛ¶¹ÊÓƵ Experience Platform allows data to be ingested from external sources while providing you with the ability to structure, label, and enhance incoming data using Platform services. You can ingest data from a variety of sources such as ÃÛ¶¹ÊÓƵ applications, cloud-based storage, databases, and many others.

Experience Platform provides support for ingesting data third-party marketing automation system. Support for marketing automation providers includes Oracle NetSuite.

is a cloud-based business management suite encompassing ERP/financial, CRM and e-commerce solutions.

You can use two different sources to ingest data from Oracle NetSuite to Experience Platform:

  • Use the Oracle NetSuite Activities source to ingest events data.
  • Use the Oracle NetSuite Entities source to ingest customer and contact data.

View the following table for more information on the two Oracle NetSuite sources.

Source
Type
Description
Oracle NetSuite Activities
Event
Retrieve scheduled activities added to your calendar.
Oracle NetSuite Entities
Customer
Retrieve specific customer data, including details such as customer names, addresses, and key identifiers.
Oracle NetSuite Entities
Contact
Retrieve contact names, emails, phone numbers, and any custom contact-related fields associated with customers.

IP address allow list ip-allow-list

A list of IP addresses may require to be added to an allow list prior to working with source connectors. Failing to add your region-specific IP addresses to your allow list may lead to errors or non-performance when using sources. See the IP address allow list page for more information.

Prerequisites prerequisites

Before you can bring your Oracle NetSuite data to Experience Platform, you must first ensure that you have the following:

  • An Oracle NetSuite account.

    • Contact if you do not already have a valid account.

  • An active subscription to any Oracle NetSuite product.

  • An account ID.

    • The Oracle NetSuite source uses OAuth 2.0 to communicate with the Oracle NetSuite APIs. If you do not have your account ID, visit the Oracle documentation on .

  • A client ID and client secret combination.

    • The client ID and client secret are required to access Oracle NetSuite APIs. During this step, you must also ensure that your administrator has:

      • Enabled the OAuth 2.0 feature and setup the appropriate OAuth 2.0 roles.
      • Assigned users to the OAuth 2.0 roles and created the necessary integration records.

  • An access token and a refresh token.

    • Refer to the Oracle guide on for information on how to generate your access and refresh tokens.

Gather required credentials gather-credentials

In order to connect Oracle NetSuite to Platform, you must provide values for the following connection properties:

Credential
Description
Example
Client ID
The client ID value that is generated when you create the integration record in Oracle NetSuite. Read the Oracle guide on how to for more information.
7fce.....b42f
The value is a 64-character string.
Client secret
The client secret value that is generated when you create the integration record. Read the Oracle guide on how to for more information.
5c98.....1b46
The value is a 64-character string.
Authorization Test URL
(Optional) Your NetSuite authorization test URL.
https://{ACCOUNT_ID}.app.netsuite.com<br>/app/login/oauth2/authorize.nl?response_type=code<br>&redirect_uri=https%3A%2F%2Fapi.github.com<br>&scope=rest_webservices<br>&state=ykv2XLx1BpT5Q0F3MRPHb94j<br>&client_id={CLIENT_ID}
Access token
The access token is in JSON Web Token (JWT) format and is only valid for 60 minutes. For more information on how to retrieve your access token, read the Oracle guide on .
eyJr......f4V0
The value is a 1024-character string formatted as a JSON Web Token (JWT).
Refresh token
Use the refresh to generate a new access token, after your access token expires. The refresh token is valid for seven days. For more information on how to retrieve your access token, read the Oracle guide on .
eyJr......dmxM
The value is a 1024-character string formatted as a JSON Web Token (JWT).
Access Token URL
The token endpoint where the application sends the POST requests to.
https://{ACCOUNT_ID}.suitetalk.api.netsuite.com<br>/services/rest/auth/oauth2/v1/token
IMPORTANT
After a refresh token expires, you must create a new account in Experience Platform with your updated updated tokens.

Connect Oracle NetSuite Activities to Platform oracle-netsuite-activities

The documentation below provides information on how to connect Oracle NetSuite Activities to Platform using APIs or the user interface:

Connect Oracle NetSuite Entities to Platform oracle-netsuite-entities

The documentation below provides information on how to connect Oracle NetSuite Entities to Platform using APIs or the user interface:

recommendation-more-help
337b99bb-92fb-42ae-b6b7-c7042161d089