...
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.
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>];...
Required for adding a new record
Multiple fields can be used for the Service Desk Item.
Only valid for Service Orders, Work Orders, and Incidents.
Service Desk Number
...
The SD Service Desk Number of a Service Desk item.
Datatype is String
Special Values:
PREVIOUS Will use the The last saved Service Desk item from an applicable Service Desk import record format (Service/Work Order) is used.
Service Desk RECID
...
The RECID of a Service Desk item.
Datatype is Number
Special Values:
PREVIOUS Will use the The last saved Service Desk item from an applicable Service Desk import record format (Service/Work Order) is used.
Service Desk Action Fields
Multiple fields can be used to for the Service Desk Action Item.
Service Desk Action Number
...
The Number of a Service Desk Action item.
Datatype is String
Special Values:
PREVIOUS Will use the The last saved Service Desk item from an applicable Service Desk import record format (Service Order) is used.
Service Desk Action RECID
...
The RECID of a Service Desk Action item.
Datatype is Number
Special Values:
PREVIOUS Will use the The last saved Service Desk item from an applicable Service Desk import record format (Service Order) is used.
Action Fields
...
Multiple fields can be used for the Equipment Action.
Action
...
Required for adding a new record
Action
A list value or code for the list type "SD_EQP_ACTIONS.".
Datatype is String
Action RECID
Datatype is Number
The RECID of a list item with the list type "SD_EQP_ACTIONS.".
Datatype is Number
Quantity
Datatype is Number
Required for adding a new record
Must be a positive integer value.
Status Fields
...
Multiple fields can be used
...
for the Equipment Status.
Required for adding a new record
Status
...
A list value or code for the list type "SD_EQP_STATUS.".
Datatype is String
Status RECID
...
The RECID of a list item with the list type "SD_EQP_STATUS.".
Datatype is Number
Billable
Datatype is Boolean
Default: False
Equipment Catalog Fields
Multiple fields can be used to for the Equipment Status.
Conditionally Required for adding a new record, and the Equipment field is not providedMultiple fields can be used to for the
Equipment
...
Equipment Catalog
...
The Path of an Equipment Catalog item.
Datatype is Hierarchical String
Equipment Catalog RECID
Datatype is Number
The RECID of an Equipment Catalog item.
Datatype is Number
Replaced Equipment Fields
...
Datatype is Number
Special Value
PREVIOUS Will use the The last saved Service Desk item from an applicable Service Desk import record format (Service Order) is used.
Expense Type Fields
...
Multiple fields can be used
...
for the Expense Type.
Required
Special Values:
PREVIOUS Will use the The last saved Equipment item from an Equipment import record format is used.
Expense Type
...
A list value or code for the list type "EXPENSE_TYPE.".
Datatype is String
Expense Type RECID
...
The RECID of a list item with the list type "EXPENSE_TYPE.".
Datatype is Number
From Location Fields
...
Multiple fields can be used for the From Location.
Conditionally Required when inserting a new record and the Equipment Action is "ADD.".Multiple fields can be used to for the
From Location
...
From Location
Datatype is Hierarchical String
The path of a location item.
Datatype is a Hierarchical String
From Location RECID
Datatype is Number
The RECID of a location item.
Datatype is Number
From Location Type Fields
Multiple fields can be used for the From Location.
From Location Type
Datatype is String
A list value or code for the list type "LOCATION_TYPE.".
Datatype is String
From Location Type RECID
...
The RECID of a list item with the list type "LOCATION_TYPE.".
Datatype is Number
To Location Fields
Multiple fields can be used for the To Location.
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.
...
To Location
...
To Location
Datatype is a Hierarchical String
The path of a location item.
...
Multiple fields can be used to for the To Location.
To Location Type
Datatype is String
A list value or code for the list type "LOCATION_TYPE.".
Datatype is String
To Location Type RECID
...
The RECID of a list item with the list type "LOCATION_TYPE.".
Datatype is Number
Override GLA Fields
Multiple fields can be used for the Override GLA.
Override GLA
The fully concatenated GLA.
Datatype is is a Hierarchical String
The path of a location item.
Override GLA RECID
...
The RECID of a GLA item.
Datatype is Number
Advanced Examples
How do I use Equipment created by another Record Format within the same Import?
The Record Formats needed
Equipment
Service Desk Equipment
Scenario: The Equipment Record Format created/modified an equipment record. How to do we match on that exact equipment record so it can to be added as Service Desk Equipment?
...