...
Import Fields mapped via Column Mappings or Conditional Logic will constantly update values (when applicable). If a field is mapped and the value is left blank, the record will save that field as empty. This is especially important to remember when updating records. This behavior can be circumvented with the use of Conditional Logic. Here is an example of how to conditionally unmap a field without value.
if
Important Notes
When a Column Mapping or Conditional Logic maps a field, the value for that field will be used regardless of value. This means that if the value is left blank in the file, the value will be blank on the record. If you need to map a column but ignore blanks, conditional logic may be used; see the example below.
if (trim([<COLUMN_INDEX>]) !== '')
...
[<FIELD_IDENTIFIER>] = [<COLUMN_INDEX>];
Matches On Criteria
Currently, only new Service Desk Equipment can be created. Updating existing records is not supported.
...
Datatype is String
Required for adding a new record
Allowed Values: "INSERT"
Denotes if the import should insert or update a record.
Service Desk Fields
Required for adding a new record
Multiple fields can be used to for the Service Desk Item.
Only valid for Service Orders, Work Orders and Incidents.
Service Desk Number
Datatype is String
The SD Number of a Service Desk item.
Special Values:Value Description
PREVIOUS Will use the last saved Service Desk item from an applicable Service Desk import record format (Service/Work Order).
Service Desk RECID
Datatype is Number
The RECID of a Service Desk item.
Special Values:Value Description
PREVIOUS Will use the last saved Service Desk item from an applicable Service Desk import record format (Service/Work Order).
Service Desk Action Fields
...
Datatype is String
The Number of a Service Desk Action item.
Special Values:Value Description
PREVIOUS Will use the last saved Service Desk item from an applicable Service Desk import record format (Service Order).
Service Desk Action RECID
Datatype is Number
The RECID of a Service Desk Action item.
Special Values:Value Description
PREVIOUS Will use the last saved Service Desk item from an applicable Service Desk import record format (Service Order).
Action Fields
Required for adding a new record
Multiple fields can be used for the Equipment Action.
...
Datatype is Number
The RECID of a list item with the list type "SD_EQP_ACTIONS".
Quantity
Datatype is Number
Required for adding a new record
Must be a positive integer value.
Status Fields
Required for adding a new record
Multiple fields can be used to for the Equipment Status.
...
Datatype is Boolean
Default: False
Equipment Catalog Fields
Conditionally Required for adding a new record and the Equipment field is not provided
Multiple fields can be used to for the Equipment Status.
...
Multiple fields can be used to for the Replaced Equipment item.
Multiple fields may be used to match an Equipment record.
Replaced Equipment Asset Tag
...
Multiple fields can be used to for the Equipment item.
Multiple fields may be used to match an Equipment record.
Equipment Asset Tag
Datatype is String
...
Equipment RECID
Datatype is Number
Special Value
PREVIOUS Will use the last saved Service Desk item from an applicable Service Desk import record format (Service Order).
Expense Type Fields
Required
Multiple fields can be used to for the Expense Type.
Special Values:Value Description
PREVIOUS Will use the last saved Equipment item from an Equipment import record format.
...
Expense Type
Datatype is String
A list value or code for the list type "EXPENSE_TYPE".
Expense Type RECID
Datatype is Number
The RECID of a list item with the list type "EXPENSE_TYPE".
Asset Tag
Datatype is String
Equipment ID
Datatype is String
Serial Number
Datatype is String
...
Datatype is String
From Location Fields
Conditionally Required when inserting a new record and the Equipment Action is "ADD".
Multiple fields can be used to for the From Location.
...
Multiple fields can be used to for the From Location.
From Location Type
...
Datatype is Number
The RECID of a list item with the list type "LOCATION_TYPE".
To Location Fields
Conditionally Required when inserting a new record and one of the following conditional are met.
- The Equipment Action is "REMOVE"
- The Equipment Action is "ADD," and the Service Desk record is not a Service Desk Action.
Multiple fields can be used to for the To Location.
To Location
...
Multiple fields can be used to for the Override GLA.
Override GLA
...