System data mapping

This page describes how data retrieved from the source service is mapped into records generated by the connector.

For each record type, the following information is reported:

• the property name exposed by the connector;
• the path from which the value is obtained in the source service;
• any additional note regarding transformations, enrichments or special behaviours.

Each record mapping section is titled {Source Object Name} ({_type}), combining the object name used by the source service with the internal record type produced by the connector.

Common properties

Property name	Source path	Notes
id	id	NinjaOne identifier of the object, converted to string. Not present in calculated records (processor, volume).

Organization (organization)

Represents an organization (customer) of the NinjaOne account. Read from GET /v2/organizations.

Property name	Source path	Notes
name	name
description	description
node_approval_mode	nodeApprovalMode

Location (location)

Represents a location of an organization. Read from GET /v2/locations.

Property name	Source path	Notes
name	name
description	description
address	address
organization	organizationId	Record Id of the related organization.

User (user)

Represents a NinjaOne user, either an end user or a technician. Read from GET /v2/user/end-users and GET /v2/user/technicians; the results of the two calls are merged.

Property name	Source path	Notes
uid	uid	Used as the record identity, shared with contact records.
enabled	enabled
first_name	firstName
last_name	lastName
email	email
phone	phone
administrator	administrator
user_type	userType
roles	roles	List of roles in JSON format.
roles_lookuparray	roles	Added in preprocessing: elements of the roles JSON list joined with ##.
organization	organizationId	Record Id of the related organization. Set only when organizationId is present.

Contact (contact)

Represents a contact of an organization. Read from GET /v2/contacts.

Property name	Source path	Notes
uid	uid	Used as the record identity, shared with user records.
first_name	firstName
last_name	lastName
phone	phone
email	email
job_title	jobTitle
organization	organizationId	Record Id of the related organization. Set only when organizationId is present.

Device (device)

Represents a device managed by NinjaOne. Read from GET /v2/devices-detailed.

Property name	Source path	Notes
node_class	nodeClass
hostname	systemName
dns_name	dnsName
ip_addresses	ipAddresses	Elements of the list joined with a space.
mac_addresses	macAddresses	Elements of the list joined with a space.
public_ip	publicIP
os_manufacturer	os.manufacturer
os_name	os.name
os_architecture	os.architecture
system_name	system.name
system_manufacturer	system.manufacturer
system_model	system.model
system_serial_number	system.serialNumber
system_processor_number	system.numberOfProcessors
system_memory	system.totalPhysicalMemory	Converted from bytes to GB (divided by 2^30), rounded to 2 decimals.
system_chassis_type	system.chassisType
memory_capacity	memory.capacity	Converted from bytes to GB (divided by 2^30), rounded to 2 decimals.
memory_capacity_trunc	memory.capacity	Added in preprocessing: memory_capacity formatted as a string with 2 decimals. Empty when memory_capacity is empty or 0.
device_type	deviceType
tags	tags	List of tags in JSON format.
tags_lookuparray	tags	Added in preprocessing: elements of the tags JSON list joined with ##.
organization	organizationId	Record Id of the related organization. Set only when organizationId is present.
location	locationId	Record Id of the related location. Set only when locationId is present.
owner	assignedOwnerUid	Record Id of the related user or contact with the same uid. Set only when assignedOwnerUid is present; if no user or contact matches, the property is left empty and only a warning is logged.

Processor (processor)

Calculated record: one record is generated for each element of the processors list of a device.

Property name	Source path	Notes
number		Progressive index of the processor within the device, starting from 0. Together with device, identifies the record.
architecture	processors[].architecture
clock_speed	processors[].clockSpeed	Divided by 2^30 and rounded to 3 decimals, to express the value in GHz.
clock_speed_trunc	processors[].clockSpeed	Added in preprocessing: clock_speed formatted as a string with 2 decimals. Empty when clock_speed is empty or 0.
name	processors[].name
cores_number	processors[].numCores
logical_cores_number	processors[].numLogicalCores
device	id	Record Id of the device containing the processor.

Volume (volume)

Calculated record: one record is generated for each element of the volumes list of a device.

Property name	Source path	Notes
number		Progressive index of the volume within the device, starting from 0. Together with device, identifies the record.
node_id	volumes[].nodeId
name	volumes[].name
label	volumes[].label
device_type	volumes[].deviceType
file_system	volumes[].fileSystem
auto_mount	volumes[].autoMount
compressed	volumes[].compressed
capacity	volumes[].capacity	Converted from bytes to GB (divided by 2^30), rounded to 2 decimals.
capacity_trunc	volumes[].capacity	Added in preprocessing: capacity formatted as a string with 2 decimals. Empty when capacity is empty or 0.
free_space	volumes[].freeSpace	Converted from bytes to GB (divided by 2^30), rounded to 2 decimals.
free_space_trunc	volumes[].freeSpace	Added in preprocessing: free_space formatted as a string with 2 decimals. Empty when free_space is empty or 0.
serial_number	volumes[].serialNumber
device	id	Record Id of the device containing the volume.

Notes

The numbering of processors and volumes depends on the order in which they are returned by NinjaOne for each device.

Users and contacts are identified only by their uid, so that the owner of a device can refer to either of them.