Netsuite to JSM Assets

Import list of employees from Netsuite to JSM Assets.

Configure the connection to Netsuite by going to OnLink (Manage your apps) - Connections. Create a connection to Netsuite. Use “Other HR” option and select Netsuite.

Once connection is established, please review instructions here to get started with setting up an Assets import configuration. You can then access OnLink app from the “Manage your apps” menu to further configure and set the field level mapping. Here’s an example mapping configuration:

key:accountNumber=Account Number
map:firstNname=First Name
map:lastName=Last Name
map:hireDate=Hire Date
map:email= Email
map:phone=Phone
config:expand=job,location

List of Employee Fields

https://system.netsuite.com/help/helpcenter/en_US/APIs/REST_API_Browser/record/v1/2024.1/index.html#/definitions/employee

Here’s a breakdown of some of the mapping configuration items:

Key or Map	Description

Key or Map	Description
`key:accountNumber=Account Number`	The keyword “key” refers to using id as a unique identifier. This allows OnLink to update the record. “accountNumber” is a text attribute.
`map:firstName=First Name`	Maps first_name to First Name text attribute.
`map:lastName=Last Name`	Maps username to Last Name text attribute.
`config:expand=job,location`	This will help fetch Job and Location objects.

OnLink processes data in two steps - Get Data and Import Data. To manually test, you can click on Get Data first and then wait until you see “No more pending records. Data will be imported on next Import run.” message in Job Logs. Then, click on Import. Production runs are fully automated based on the schedule you choose.