Import ServiceNow Data into Atlassian Service Collection Assets with OnLink

Prabhu Palanisamy _Onward_

OnLink now pulls records from any ServiceNow table straight into Assets, with no middleware and no CSV exports.

Many teams run ServiceNow for some IT workflows and Jira Service Management for others. Or they are moving off ServiceNow entirely. Either way, the CMDB data has to live where agents work. OnLink connects to the ServiceNow Table API, fetches the records you choose, and maps each field to an Assets attribute. Re-run the import and existing objects update instead of duplicating.

Use cases

Import ServiceNow data into Assets

Keep ServiceNow as a source of truth for some records while JSM agents see them in Assets. Pull computers, servers, virtual machines, or hardware assets on a schedule. Agents can then link those objects to requests, incidents, and changes without switching tools.

Migrate CMDB objects from ServiceNow to Atlassian Service Collection Assets

Moving from ServiceNow to Jira Service Management? Your CMDB is usually the hardest part to move. OnLink reads CMDB tables such as cmdb_ci_computer and cmdb_ci_server and creates matching objects in Assets. Run it table by table, validate each one, and cut over when the data looks right.

Authentication: Basic and OAuth

OnLink supports both Basic Authentication and OAuth for the ServiceNow connection. Pick whichever your ServiceNow admin allows.

Method	What you provide in OnLink
Basic Auth	ServiceNow username and password
OAuth	Client ID and client secret

Setup takes three steps:

1. In OnLink, add an Assets Data Source.
2. Set Authentication Type to Basic AUTH or OAUTH.
3. Enter the username and password, or the client ID and secret.

Access the integration account needs:

• View (read-only) access to the tables or views you plan to import. The import only reads from ServiceNow.
• The rest_api_explorer role, so the account can call the ServiceNow REST Table API.

Get table records

Point OnLink at one ServiceNow table and it fetches every record in it. Configure the API call like this:

1. Set Method to GET.
2. Set URL to your instance's Table API endpoint, with the table name at the end.
3. Set Response data path to result.

GET https://{instance}.service-now.com/api/now/table/cmdb_ci_computer

Swap the table name to import something else. Common choices:

• cmdb_ci_computer for laptops and desktops
• cmdb_ci_server for servers
• cmdb_ci_vm_instance for virtual machines
• alm_hardware for hardware assets

Click Get Data to preview what comes back before you map anything. Each record arrives as JSON with fields like sys_id, name, serial_number, and os.

Field mapping

Each ServiceNow field maps to a JSM Assets attribute with one line of config. A key: line tells OnLink which field uniquely identifies a record, so repeat imports update existing objects. map: lines copy fields into attributes.

OnLink mapping	ServiceNow field	JSM Assets attribute
key:sys_id=ID	sys_id	ID (unique match key)
map:name=Name	name	Name
map:serial_number=Serial Number	serial_number	Serial Number
map:os=OS Name	os	OS Name
map:install_status=Status	install_status	Status
map:asset_tag=Asset Tag	asset_tag	Asset Tag
map:os_version=OS Version	os_version	OS Version
map:ip_address=IP Address	ip_address	IP Address
map:warranty_expiration=Expiration Date	warranty_expiration	Expiration Date

Bring your ServiceNow data to Assets

Try OnLink free on the Atlassian Marketplace. Planning a full ServiceNow-to-JSM migration? Book a 30-minute walkthrough and we'll map your first table with you.

ServiceNow to Asset FAQs

1. Which ServiceNow tables can I import?

Any table the integration account can read through the Table API. Common ones are cmdb_ci_computer, cmdb_ci_server, cmdb_ci_vm_instance, and alm_hardware.

2. What permissions does the ServiceNow account need?

Read-only access to the tables or views you import, plus the rest_api_explorer role. No write access is required.

3. Should I use Basic Auth or OAuth?

Both work. OAuth with a client ID and secret is usually preferred by security teams. Basic Auth is quicker for a proof of concept.

4. Will re-running the import create duplicate objects?

No. The key: mapping, typically sys_id, matches each record to its existing Assets object and updates it.

5. How do I handle reference fields like location or assigned user?

ServiceNow returns these as links and sys_ids. Resolve them to display values, such as a location name or user email, that match objects already in Assets.

Viswanathan Ramachandran

Great read and this will be very useful for organisation adopting Atlassian for their work especially when using JSM. I think you should put this as article and run a demo session on community events.