SharpSync
  • Welcome
  • Fundamentals
    • Getting Started
      • Registration
      • Landing Page
      • Support
      • Subscription
    • Data Sources
    • Property Mappings
      • Adding Property Mapping
      • Property Mapping Settings
    • Rules
      • Import / Export
        • Append text
        • Calculate number
        • Export manipulation
        • Format as decimal number
        • Prepend text
        • Remove property
        • Replace all instances
        • Replace first instance
        • Round to nearest X
        • Select from JSON
        • Set cell value
        • Set empty cells
        • Text manipulation
      • Display
        • Number between
        • Text contains
        • Text ends with
        • Text evaluation
        • Text is a number
        • Text is exactly
        • Text is in list
        • Text is not a number
        • Text is not empty
        • Text is not in list
        • Text length between
        • Text length is exactly
        • Text maximum length
        • Text minimum length
        • Text not contains
        • Text not ends with
        • Text not starts with
        • Text starts with
      • Advanced Scripting
    • BOM Comparison
    • Data Safety
    • Troubleshooting
      • Duplicate component paths
      • OAuth 2.0
  • Data Sources
    • Autodesk Inventor
    • CSV
      • Getting Started
      • Importing a Bill of Materials (BOM)
    • MS Dynamics 365 Business Central
      • Getting Started
      • Item Fields Json & Internal Names
      • Resource Fields Json & Internal Names
      • List Names For nestedObject Mappings
    • NetSuite
      • OAuth Setup
        • Permissions
      • RESTlet Script Setup
        • SharpSync RESTlet Script
      • Thumbnail Folder Setup
      • Authentication + Configuration
      • Common setup
        • Configure quantity mapping
        • Configure accounts mappings
        • Configure itemType mapping
        • Configure isPhantom mapping
        • Configure subsidiary mapping
        • Configure price mapping
        • Configure Where Used Link mapping
        • Configure thumbnail mapping
        • Read-Only NetSuite Fields
        • Common Mapping Rules
        • Common List names
      • Advanced Bill of Materials
      • Configure Routings
      • Integration tips
      • Troubleshooting
    • Odoo
      • Getting Started
        • Authentication + Configuration
        • Debugging tips
      • Common Setup
        • Map BOM Codes
        • Map BOM Types
        • Map Attribute Values
          • Reading Attributes - Overview
          • Display All Attribute Names
          • Display Single Attribute Values
          • Writing attributes
      • Product Management
      • Hosting Options
      • List Names
      • Permissions
      • Troubleshooting
    • Onshape
      • Getting Started
      • Setting up Derivatives
    • Propel PLM
      • Getting Started
    • SolidWorks
    • SolidWorks PDM
      • Downloading and installing the add-in
      • Configure the add-in
      • Setting up the Solidworks PDM Web 2
      • Troubleshooting
      • Submitting a BOM for update
  • Advanced
    • Derivatives
  • User management
    • User Management
    • Application Permissions
Powered by GitBook
On this page
  1. Data Sources
  2. NetSuite

Authentication + Configuration

Configuration of a Netsuite Datasource

PreviousThumbnail Folder SetupNextCommon setup

Last updated 6 days ago

By now you should have the following key info:

  • clientId (see )

  • clientSecret (see )

  • scriptId (see )

  • deploymentId (see )

  • folderId (see )

NetSuite supports a number of types of authentication. The auth method supported in SharpSync is OAuth 2. The configuration values in SharpSync are shown below.

Authentication

  • In SharpSync, navigate to Data Sources

  • Select the NetSuite Data Source > Add

  • Set the Server Url

https://[customerId].app.netsuite.com
  • Click Update

  • Click the Ping button to test the connection. This is optional and will not work if ICMP is disabled on the server

  • Click the 'Configure' button

  • You can now configure Authentication & Configuration

Base API path

This is the full link [including your customer id] to the NetSuite Instance. Typically something like:

https://[customerId].suitetalk.api.netsuite.com

Authentication Types

The type of authentication method to use when authenticating with NetSuite. We only support:

OAuth 2.0

OAuth Url

The URL where authentication initially happens:

https://[customerId].app.netsuite.com/app/login/oauth2/authorize.nl

OAuth Token Url

The URL where tokens are created / renewed. Typically something like:

https://[customerId].suitetalk.api.netsuite.com/services/rest/auth/oauth2/v1/token

OAuth Client Client Id

The OAuth clientId registered for the SharpSync application. Usually generated by the integration record created:

{some long string of text}

OAuth Client Secret

The OAuth clientSecret registered for the SharpSync application. Usually generated the first time the integration record is created:

{some long string of text}

OAuth Scopes

Think of this as the permissions needed by your OAuth application to send and receive data. The restlets scope is optional but highly recommended. Without it you will not be able to upload thumbnails. You should set this to:

rest_webservices,restlets

Default item type to use when creating BOM item

inventoryitem

Item types to load properties for

When loading accessors (NetSuite Fields) and property mappings, these are the item types searched for:

Simple Boms:

assemblyitem|inventoryitem|noninventoryresaleitem|noninventorysaleitem|noninventorypurchaseitem|assemblyitemmember

Advanced BOMs:

assemblyitem|inventoryitem|noninventoryresaleitem|noninventorysaleitem|noninventorypurchaseitem|bom|bomrevision|bomrevisioncomponent|manufacturingrouting

Servlet URL

The url of the servlet where thumbnails will be uploaded and advanced BOMs item created.

Simple Boms:

https://{companyId}.restlets.api.netsuite.com/app/site/hosting/restlet.nl?script={scriptId}&deploy={deploymentId}&folderId={folderId}

Advanced BOMs (use the same value for script and itemInjectionScriptId ):

https://{companyId}.restlets.api.netsuite.com/app/site/hosting/restlet.nl?script={scriptId}&itemInjectionScriptId={scriptId}&deploy={deploymentId}&folderId={folderId}

Use server side scripting for items

Use the server to update custom fields for items which are not surfaced in the NetSuite api. (check this if using advanced BOMs)

Use advanced BOMs

Check to let SharpSync know that you use advanced BOMs in NetSuite

BOM Naming Scheme

The scheme that SharpSync uses to search for and generate BOM names

BOM Revision Naming Scheme

The scheme that SharpSync uses to search for and generate BOM revision names

When creating a new item, if the item cannot be reliably determined from SharpSync, this is the fallback type to be used (this is currently superseded by the values in the ), example:

OAuth Setup
OAuth Setup
RESTlet Script Setup
RESTlet Script Setup
Thumbnail Folder Setup
itemType property mapping