Thumbnail Folder

NetSuite Setup of Thumbnail folder

To successfully upload thumbnails to NetSuite, you need the following 3 things:

• OAuth clientId and clientSecret (aka consumer key and consumer secret)

• A scriptId

• A folderId

• A variable to assign the fileId to

Steps involved in setting up NetSuite:

• Setup OAuth - gives you permissions to upload files + clientId and clientSecret

• Setup Restlet for uploading thumbnails (SuiteApi) - gives you the scriptId

• Setup an upload folder - gives you the folderId

• Putting it all together - configuring the datasource in SharpSync

---

Setup OAuth

Goal: To get the the necessary permissions to upload files

Steps required:

• Setup OAuth (this step)

• Install SuiteApi

• Create a new thumbnails folder in NetSuite

• Setup the datasource to point to the new restlet

See NetSuite OAuth Setup

---

Setup restlet for uploading thumbnails (SuiteApi)

Steps required:

• (done) Setup OAuth

• Install SuiteApi (this step)

• Create a new thumbnails folder in NetSuite

• Setup the datasource to point to the new restlet

See Setup restlet for uploading thumbnails (SuiteApi) Original source Suite API Setup

---

Setup an upload folder

Goal: To get a folder id

Steps required:

• (done) Setup OAuth

• (done) Install SuiteApi

• Create a new thumbnails folder in NetSuite (this step)

• Setup the datasource to point to the new restlet

See Setup an upload folder See Create an upload folder

Putting it all together - Setup the datasource

Goal: To configure the datasource in SharpSync

Steps required:

• (done) Setup OAuth

• (done) Install SuiteApi

• (done) Create a new thumbnails folder in NetSuite

• Setup the datasource to point to the new restlet (this step)

With the copied URL in the previous step, and the folderId and scriptId in hand, it's time to setup the datasource in SharpSync.

In SharpSync add a new data source > NetSuite.

Configuring NetSuite

There are 2 configuration sections for each datasource

• Authentication

• BOM Configuration

Authentication

• Navigate to the Datasources > Config UI

• Select the NetSuite datasource > Add

• Set the server url > 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

• Enter the following values:

  Name	Description	Recommended value
  Base API Path	The location where data is pulled from	https://{companyId}.suitetalk.api.netsuite.com
  Authentication Type	Which authentication method you'd like to use to connect to NetSuite	OAuth 2.0
  OAuth Url	The URL against which your OAuth authentication occurs	https://{companyId}.app.netsuite.com/app/login/oauth2/authorize.nl
  OAuth Token Url	The URL against which your OAuth token is refreshed	https://{companyId}.suitetalk.api.netsuite.com/services/rest/auth/oauth2/v1/token
  Client Id	The client id generated by the integration record created	-
  Client Secret	The client secrete generated by the integration record created	-
  OAuth Scopes	The scopes required to get data. The restlets scope is optional but highly recommended. Without it you will not be able to upload thumbnails	rest_webservices,restlets

BOM Configuration

Name	Description	Recommended value
Top level assembly column name	When querying the data you may use this value to identify assemblies (optional)	itemid
SuiteQL BOM Query	The query used to select data using SuiteQl	SELECT ItemID, id, displayName FROM Item WHERE ItemID = '{uniquePartNumber}'. Note that the place holder {uniquePartNumber} must stay as this is used to find items related to assemblies
Servlet URL	The url of the servlet where thumbnails will be uploaded. Optional but recommented. If specified, include the folderId param at the end	https://{companyId}.restlets.api.netsuite.com/app/site/hosting/restlet.nl?script=2943&deploy=1&folderId={folderId}
Thumbnail column name	The column to update in NetSuite using the file ID of the uploaded thumbnail	custitem_mycol_image

• Enter the URL of the restlet, followed by &folderId= and the id of the folder in the first steps

• Enter the folder ID into the UI in the form

{{netsuite-api}}/app/site/hosting/restlet.nl?script={yourScriptId}&deploy=1&folderId={folderId}

e.g.

{{netsuite-api}}/app/site/hosting/restlet.nl?script=2743&deploy=1&folderId=19578359

See also

• OAuth