---
title: CMDBTransformUtil - Global
description: The CMDBTransformUtil script include uses the Identification and Reconciliation \(IRE\) framework to minimize the creation of duplicate configuration items \(CI\).Creates a CMDBTransformUtil object.Returns any errors generated by the previous identifyAndReconcile\(\) or identifyAndReconcileEnhanced\(\) method call.Returns the JSON payload from the previous identifyAndReconcile\(\) or identifyAndReconcileEnhanced\(\) method call.Returns the sys\_id of the configuration item \(CI\) that was inserted or updated.Returns the JSON payload generated from the specified input.Determines if an error occurred in the previous identifyAndReconcile\(\) or identifyAndReconcileEnhanced\(\) method call.Inserts or updates a configuration item \(CI\) in the Configuration Management Database \(CMDB\).Inserts or updates a configuration item \(CI\) in the Configuration Management Database \(CMDB\).Logs the number of configuration items \(CI\) inserted, updated, skipped, or that had errors.Sets the data source to use when the identifyAndReconcile\(\) or identifyAndReconcileEnhanced\(\) method is called.
locale: en-US
canonical_url: https://www.servicenow.com/docs/r/australia/api-reference/server-api-reference/c\_CMDBTransformUtilAPI.html
release: australia
product: Server API Reference
classification: server-api-reference
topic_type: concept
last_updated: "2026-03-12"
reading_time_minutes: 25
breadcrumb: [Server API reference, API reference, API implementation and reference]
---

# CMDBTransformUtil- Global

The CMDBTransformUtil script include uses the Identification and Reconciliation \(IRE\) framework to minimize the creation of duplicate configuration items \(CI\).

The IRE framework also reconciles CI attributes by only accepting information from authorized sources when updating the CMDB in `onBefore` transform map scripts. You can't use this class in other scripts. For additional information on how the IRE framework operates, see [CMDB Identification and Reconciliation](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/servicenow-platform/c_CMDBIdentifyandReconcile.md).

**Parent Topic:**[Server API reference](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/api-reference/server-api-reference/api-server.md)

## CMDBTransformUtil - CMDBTransformUtil\(\)

Creates a CMDBTransformUtil object.

|Name|Type|Description|
|----|----|-----------|
|None| | |

```
var cmdbUtil = new CMDBTransformUtil();
```

## CMDBTransformUtil - getError\(\)

Returns any errors generated by the previous identifyAndReconcile\(\) or identifyAndReconcileEnhanced\(\) method call.

Use this method in onBefore transform map scripts to obtain errors. Use the [hasError\(\)](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/api-reference/server-api-reference/c_CMDBTransformUtilAPI.md) method to first detect any errors from the identifyAndReconcile\(\) or identifyAndReconcileEnhanced\(\) method.

|Name|Type|Description|
|----|----|-----------|
|None| | |

|Type|Description|
|----|-----------|
|String|Error message from identifyAndReconcile\(\) or identifyAndReconcileEnhanced\(\).|

```
// Add this code to the onBefore transform map script
// Call CMDB API to do Identification and Reconciliation of the current row
var cmdbUtil = new CMDBTransformUtil();
cmdbUtil.setDataSource('ImportSet');
cmdbUtil.identifyAndReconcileEnhanced(source, map, log);
ignore = true;

if (cmdbUtil.hasError()) {
  var errorMessage = cmdbUtil.getError();
  log.error(errorMessage);
} else {
  log.info('IE Output Payload: ' + cmdbUtil.getOutputPayload());
  log.info('Imported CI: ' + cmdbUtil.getOutputRecordSysId());
}
```

### Scoped equivalent

There is no scoped equivalent for this method.

## CMDBTransformUtil - getOutputPayload\(\)

Returns the JSON payload from the previous identifyAndReconcile\(\) or identifyAndReconcileEnhanced\(\) method call.

Use this method in onBefore transform map scripts.

|Name|Type|Description|
|----|----|-----------|
|None| | |

<table id="table_dyb_nh4_ylb" class="returns"><thead><tr><th>

Type

</th><th>

Description

</th></tr></thead><tbody><tr><td>

&lt;String&gt;

</td><td>

JSON formatted string that is a list of results for the configuration items in the input string. Each result string is in the format  'items: \[\{\}\], relations:\[\{\}\]', where each item within the items and relations lists contains name-value pairs. Data type: String

</td></tr><tr><td>

&lt;String&gt;.additionalCommittedItems

</td><td>

No values are currently returned.

</td></tr><tr><td>

&lt;String&gt;.additionalCommittedRelations

</td><td>

No values are currently returned.

</td></tr><tr><td>

&lt;String&gt;.items

</td><td>

Description of the created or updated CIs.Data type: Object

```
"items": { 
  "additionalRelatedItems": [Array],
  "className": "String",
  "duplicateIndices": [Array],
  "errorCount": Number,
  "errors": [Array],
  "identificationAttempts": [Array],
  "identifierEntrySysId": "String",
  "info": [Array],
  "inputIndices": [Array],
  "maskedAttributes": [Array],
  "operation": "String",
  "relatedItems": [Array],
  "relatedSysIds": [Array],
  "sysId": "String"
}
```

</td></tr><tr><td>

&lt;String&gt;.items.additionalRelatedItems

</td><td>

List of information about additional lookup and related items that were processed but not provided as part of the input payload. These items are from partial payloads.This information is not currently returned.

Data type: Array of Objects

```
"additionalRelatedItems": [ 
  {
    "className": "String", 
    "inputIndices": [Array], 
    "operation": "String",
    "sysId": "String"
  }
]
```

</td></tr><tr><td>

&lt;String&gt;.items.additionalRelatedItems.className

</td><td>

Class/table name \(sys\_class\_name\) of the CI that was created or updated.Data type: String

</td></tr><tr><td>

&lt;String&gt;.items.additionalRelatedItems.inputIndices

</td><td>

Index of the corresponding input item. For top-level items, it is a list of integers. For related or lookup items, it is list of JSON objects.Data type: Array of Numbers or Array of Objects

```
"inputIndices": [
  { 
   "mainIndex": Number, 
   "subIndex": Number 
  }
]
```

</td></tr><tr><td>

&lt;String&gt;.items.additionalRelatedItems.inputIndices.mainIndex

</td><td>

Index value from the request body **items** array that corresponds to the CI parent of the additional related item. Data type: Number

</td></tr><tr><td>

&lt;String&gt;.items.additionalRelatedItems.inputIndices.subIndex

</td><td>

Index value from the request body **items.lookup** array that corresponds to the additional related item.Data type: Number

</td></tr><tr><td>

&lt;String&gt;.items.additionalRelatedItems.operation

</td><td>

Type of operation.Possible values:

-   INSERT: New CI was inserted into the database.
-   NO\_CHANGE: No CI changes were made.
-   UPDATE: Existing CI was updated.

Data type: String

</td></tr><tr><td>

&lt;String&gt;.items.additionalRelatedItems.sysId

</td><td>

Sys\_id of the additional related items.Data type: String

</td></tr><tr><td>

&lt;String&gt;.items.className

</td><td id="entry_return_item_className">

Class/table name \(sys\_class\_name\) of the CI that was created or updated.Data type: String

</td></tr><tr><td>

&lt;String&gt;.items.duplicateIndices

</td><td id="entry_return_items_duplicateIndices">

List of indexes of CIs that are duplicates of the current item.Data type: Array

</td></tr><tr><td>

&lt;String&gt;.items.errorCount

</td><td>

Number of errors.Data type: Number

</td></tr><tr><td>

&lt;String&gt;.items.errors

</td><td id="entry_return_item_error">

List of errors encountered while processing this CI.Data type: Array of Objects

```
"errors": [
  {
    "error": "String",
    "message": "String"
  }
]
```

</td></tr><tr><td>

&lt;String&gt;.items.errors.error

</td><td id="items_errors_errors-entry-IRE">

Type of error encountered while processing the CI.Data type: String

</td></tr><tr><td>

&lt;String&gt;.items.errors.message

</td><td id="items_errors_msg-entry-IRE">

Error message associated with the error.Data type: String

</td></tr><tr><td>

&lt;String&gt;.items.identificationAttempts

</td><td id="entry_return_item_identificationAttempts">

List of attempts that were made to identify the CIs.Data type: Array of Objects

```
"identificationAttempts": [
  { 
    "attemptResult": "String", 
    "attributes": [Array],
    "hybridEntryCiAttributes": [Array],
    "identifierName": "String",
    "searchOnTable": "String" 
  }
]
```

</td></tr><tr><td>

&lt;String&gt;.items.identificationAttempts.attemptResult

</td><td id="entry_return_item_identificationAttempts_attemptResult">

Results of the attempt to identify the CI.Possible values:

-   MATCHED: Identification succeeded. A unique CI was found in the identifier rule table which exactly matched the specified attributes.
-   MULTI\_MATCH: Identification failed with an error. Duplicate CIs were found in the identifier rule table when matching against the specified attributes.
-   NO\_MATCH: Identification failed. No CI was found in the identifier rule table which matched the specified attributes.
-   SKIPPED: Identification not attempted. The attributes required for this identifier rule table search were not provided, so the rule was not applied.

Data type: String

</td></tr><tr><td>

&lt;String&gt;.items.identificationAttempts.attributes

</td><td id="entry_return_item_identificationAttempts_attributes">

List of CI identifier entry attributes that were used during the identification process.Data type: Array

Attribute names and types depend on the request body data and the identifier in use, such as:

```
"attributes": [
  "serial_number": "String",
  "serial_number_type": "String",
]
```

</td></tr><tr><td>

&lt;String&gt;.items.identificationAttempts.hybridEntryCiAttributes

</td><td>

No values are currently returned.

</td></tr><tr><td>

&lt;String&gt;.items.identificationAttempts.identifierName

</td><td id="entry_return_item_identificationAttempts_identifierName">

Identifier rule used for this CI identification attempt.Data type: String

</td></tr><tr><td>

&lt;String&gt;.items.identificationAttempts.searchOnTable

</td><td id="entry_return_item_identificationAttempts_searchOnTable">

Name of the table searched during the identification process.Data type: String

</td></tr><tr><td>

&lt;String&gt;.items.identifierEntrySysId

</td><td id="entry_return_item_identifierEntrySysId">

Sys\_id for the identifier rule used to identify the CI.Data type: String

Table: Identifier Entry \[cmdb\_identifier\_entry\]

</td></tr><tr><td>

&lt;String&gt;.items.info

</td><td id="items_info-entry-IREE">

List that contain additional information about the processing of the item.Data type: Array of Objects

```
"info": [
  {
    "code": "String",
    "message": "String",
    "ruleSysId": "String"
  }
]
```

</td></tr><tr><td>

&lt;String&gt;.items.info.code

</td><td>

Reclassification type that was skipped.Possible values:

-   SKIPPED\_CLASS\_SWITCH
-   SKIPPED\_CLASS\_DOWNGRADE
-   SKIPPED\_CLASS\_UPGRADE

Data type: String

</td></tr><tr><td>

&lt;String&gt;.items.info.message

</td><td>

Message that provides additional insights into the reason for skipping the reclassification.Data type: String

</td></tr><tr><td>

&lt;String&gt;.items.info.ruleSysId

</td><td>

Sys\_id of the reclassification restriction rule that was matched. Applicable only when IRE skips reclassification due to reclassification restriction rule. This value is empty if the reclassification is skipped due to a payload or global flag.Data type: String

</td></tr><tr><td>

&lt;String&gt;.items.inputIndices

</td><td>

Index values for CIs from the request body **items** array that correspond to this CI.Data type: Array

</td></tr><tr><td>

&lt;String&gt;.items.maskedAttributes

</td><td id="entry_return_item_maskedAttributes">

List of attributes whose update by a non-authoritative data source was skipped as defined by the [Reconciliation Rules](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/servicenow-platform/create-reconciliation-rule.md).Data type: Array

</td></tr><tr><td>

&lt;String&gt;.items.relatedItems

</td><td>

List that provides information about the processed related items.Data type: Array of Objects

```
"relatedItems": [
  { 
    "className": "String",
    "errors": [Array],
    "errorCount": Number, 
    "inputIndices": [Array],
    "operation": "String",
    "sysId": "String"
  }
]
```

</td></tr><tr><td>

&lt;String&gt;.items.relatedItems.className

</td><td>

Class/table name \(sys\_class\_name\) of the related item.Data type: String

</td></tr><tr><td>

&lt;String&gt;.items.relatedItems.errors

</td><td>

List of errors that occurred during processing.Data type: Array of Objects

```
"errors": [
  {
    "error": "String",
    "message": "String"
  }
]
```

</td></tr><tr><td>

&lt;String&gt;.items.relatedItems.errorCount

</td><td>

Number of errors detected during processing.Data type: Number

</td></tr><tr><td>

&lt;String&gt;.items.relatedItems.inputIndices

</td><td>

Indexes of the corresponding related items.Data type: Array or Numbers

```
"inputIndices": [
  { 
   "mainIndex": Number, 
   "subIndex": Number 
  }
]
```

</td></tr><tr><td>

&lt;String&gt;.items.relatedItems.inputIndices.mainIndex

</td><td>

Integer value from the request body **items** array that corresponds to the CI parent of the related item.Data type: Number

</td></tr><tr><td>

&lt;String&gt;.items.relatedItems.inputIndices.subIndex

</td><td>

Integer value from the request body **items.lookup** array that corresponds to the related item.Data type: Number

</td></tr><tr><td>

&lt;String&gt;.items.relatedItems.operation

</td><td>

Type of operation.Possible values:

-   INSERT: New CI was inserted into the database.
-   NO\_CHANGE: No CI changes were made.
-   UPDATE: Existing CI was updated.

Data type: String

</td></tr><tr><td>

&lt;String&gt;.items.relatedSysIds

</td><td>

List of the sys\_id values for related items \(table lookup items\) from the request body **items.lookup** array.Notable values - null: No sys\_id was identified for this related item.

Data type: Array

</td></tr><tr><td>

&lt;String&gt;.items.sys\_id

</td><td id="entry_return_item_sys_id">

Sys\_id of the CI that was updated or created.Data type: String

</td></tr><tr><td>

&lt;String&gt;.relations

</td><td>

Information about the processed relations.Data type: Array of Objects

```
"relations":[
  { 
    "className": "String",
    "errorCount": Number,
    "inputIndices": [Array],
    "operation": "String",
    "sysId": "String" 
  }
]
```

</td></tr><tr><td>

&lt;String&gt;.relations.className

</td><td id="entry_return_relations_className">

Sys\_class\_name of this dependent relationship CI.Only supported value: cmdb\_rel\_ci: CI Relationship table.

Data type: String

</td></tr><tr><td>

&lt;String&gt;.relations.errorCount

</td><td>

Number of errors.Data type: Number

</td></tr><tr><td>

&lt;String&gt;.relations.inputIndices

</td><td>

Indexes of the corresponding input relations.Data type: Array

</td></tr><tr><td>

&lt;String&gt;.relations.operation

</td><td>

Type of operation performed.Possible values:

-   INSERT
-   UPDATE
-   NO\_CHANGE

Data type: String

</td></tr><tr><td>

&lt;String&gt;.relations.sysId

</td><td id="entry_return_relations_sys_id">

Sys\_id of the dependent relationship CI.Data type: String

</td></tr></tbody>
</table>```
// Add this code to the onBefore transform map script
// Call CMDB API to do Identification and Reconciliation of the current row
var cmdbUtil = new CMDBTransformUtil();
cmdbUtil.setDataSource('ImportSet');
cmdbUtil.identifyAndReconcileEnhanced(source, map, log);
ignore = true;

if (cmdbUtil.hasError()) {
  var errorMessage = cmdbUtil.getError();
  log.error(errorMessage);
} else {
  log.info('IE Output Payload: ' + cmdbUtil.getOutputPayload());
  log.info('Imported CI: ' + cmdbUtil.getOutputRecordSysId());
}
```

### Scoped equivalent

There is no scoped equivalent for this method.

## CMDBTransformUtil - getOutputRecordSysId\(\)

Returns the sys\_id of the configuration item \(CI\) that was inserted or updated.

Use this method in onBefore transform map scripts.

|Name|Type|Description|
|----|----|-----------|
|None| | |

|Type|Description|
|----|-----------|
|String|Sys\_id of the CI that was inserted or updated.|

```
// Add this code to the onBefore transform map script
// Call CMDB API to do Identification and Reconciliation of current row
var cmdbUtil = new CMDBTransformUtil();
cmdbUtil.setDataSource('ImportSet');
cmdbUtil.identifyAndReconcileEnhanced(source, map, log);
ignore = true;

if (cmdbUtil.hasError()) {
  var errorMessage = cmdbUtil.getError();
  log.error(errorMessage);
} else {
  log.info('IE Output Payload: ' + cmdbUtil.getOutputPayload());
  log.info('Imported CI: ' + cmdbUtil.getOutputRecordSysId());
}
```

### Scoped equivalent

There is no scoped equivalent for this method.

## CMDBTransformUtil - getPayload\(Object source, Object map, Object log\)

Returns the JSON payload generated from the specified input.

You can then modify the payload and use the setPayload\(\) method to store the updated payload. Once the payload is modified and stored, use identifyAndReconcile\(\) or identifyAndReconcileEnhanced\(\) to process the payload.

|Name|Type|Description|
|----|----|-----------|
|source|Object|Global object available in transform map scripts that holds the incoming record.|
|map|Object|Map object available in transform map scripts that holds the current transform map record.|
|log|Object|Log object available in transform map scripts.|

<table id="id_fm1_n55_4pb" class="returns"><thead><tr><th>

Parameter

</th><th>

Description

</th></tr></thead><tbody><tr id="row-string-enhanced"><td>

&lt;String&gt;

</td><td>

JSON formatted string that is a list of results for the configuration items in the input string.Data type: String

```
{ 
  "additionalCommittedItems": [Array],  
  "additionalCommittedRelations": [Array], 
  "hasError": Boolean, 
  "hasWarning": Boolean,
  "items": [Array],  
  "relations": [Array], 
  "summary": {Object} 
}
```

</td></tr><tr id="row_return_additionalCommittedItems"><td>

&lt;String&gt;.additionalCommittedItems

</td><td>

List of CIs that were committed during the IRE processing of the current payload, but were not present in the current input payload.Data type: Array of Objects

```
"additionalCommittedItems": [
  {
    "className": "String",
    "errorCount": Number,
    "operation": "String",
    "identificationAttempts": [Array],
    "inputIndices": [Array],
    "markers": [Array],
    "mergedPayloads": [Array],
    "sysId": "String"
  }
]
```

</td></tr><tr id="row-return-additionalCommittedItems-className"><td>

&lt;String&gt;.additionalCommittedItems.className

</td><td>

Sys\_class\_name of this additional CI.Data type: String

</td></tr><tr id="row-return-additionalCommittedItems-errorCount"><td>

&lt;String&gt;.additionalCommittedItems.errorCount

</td><td>

Number of errors encountered while processing this additional CI.Data type: Number

</td></tr><tr id="row-return-additionalCommittedItems-errors"><td>

&lt;String&gt;.additionalCommittedItems.errors

</td><td id="entry-errors">

Array of objects that describes errors encountered while processing this additional CI.Data type: Array

```
"errors": [
  {
    "error": "String",
    "message": "String"
  }
]
```

</td></tr><tr id="row-return-additionalCommittedItems-errors-error"><td>

&lt;String&gt;.additionalCommittedItems.errors.error

</td><td id="entry-errors-error">

Type of error encountered while processing the additional CI.Data type: String

</td></tr><tr id="row-return-additionalCommittedItems-errors-message"><td>

&lt;String&gt;.additionalCommittedItems.errors.message

</td><td id="entry-errors-message">

Error message encountered while processing the additional CI.Data type: String

</td></tr><tr id="row-return-additionalCommittedItems-identificationAttempts"><td>

&lt;String&gt;.additionalCommittedItems.identificationAttempts

</td><td id="addCommItems_identificationAttempts-entry-IRE">

Array of objects in which each object describes an attempt made to identify this additional CI.Data type: Array of Objects

```
"identificationAttempts": [
  {
    "attemptResult": "String",
    "attributes": [Array],
    "hybridEntryCiAttributes": [Array],
    "identiferName": "String",
    "searchOnTable": [Array]
  }
]
```

</td></tr><tr id="row-return-additionalCommittedItems-identificationAttempts-attemptResult"><td>

&lt;String&gt;.additionalCommittedItems.identificationAttempts.attemptResult

</td><td id="addCommItems_idAtt_attemptResult-entry-IRE">

Outcome of this additional CI identification attempt.Data type: String

Possible values:

-   MATCHED: Identification succeeded. A unique CI was found in the identifier rule table which exactly matched the specified attributes.
-   MULTI\_MATCH: Identification failed with an error. Duplicate CIs were found in the identifier rule table when matching against the specified attributes.
-   NO\_MATCH: Identification failed. No CI was found in the identifier rule table which matched the specified attributes.
-   SKIPPED: Identification not attempted. The attributes required for this identifier rule table search were not provided, so the rule was not applied.

</td></tr><tr id="row-return-additionalCommittedItems-identificationAttempts-attributes"><td>

&lt;String&gt;.additionalCommittedItems.identificationAttempts.attributes

</td><td id="addCommItems_idAtt_attributes-entry-IRE">

CI identifier entry attributes used during this additional CI identification attempt.Data type: Array

Attribute names and types depend on the request body data and the identifier in use, such as:

```
"attributes": [
  "serial_number": "String",
  "serial_number_type": "String",
]
```

</td></tr><tr id="row-return-additionalCommittedItems-identificationAttempts-hybrid"><td>

&lt;String&gt;.additionalCommittedItems.identificationAttempts.hybridEntryCiAttributes

</td><td id="addCommItems_idAtt_hybridEntryCIAtt-entry-IRE">

Array of CI identifier entry attributes used during this additional CI identification attempt.Data type: Array

Attribute names and types depend on the request body data and the identifier in use, such as:

```
"hybridEntryCiAttributes": [
  "name": "String",
  "serial_number": "String"
]
```

</td></tr><tr id="row-return-additionalCommittedItems-identificationAttempts-identifierName"><td>

&lt;String&gt;.additionalCommittedItems.identificationAttempts.identifierName

</td><td id="addCommItems_idAtt_identifierName-entry-IRE">

Identifier rule used for this additional CI identification attempt.Data type: String

</td></tr><tr id="row-return-additionalCommittedItems-identificationAttempts-searchOnTable"><td>

&lt;String&gt;.additionalCommittedItems.identificationAttempts.searchOnTable

</td><td id="addCommItems_identifierEntrySysId-entry-IRE">

Name of the table searched for this additional CI identification attempt.Data type: String

</td></tr><tr id="row-return-additionalCommittedItems-identifierEntrySysId"><td>

&lt;String&gt;.additionalCommittedItems.identifierEntrySysId

</td><td id="addCommItems_identifierEntrySysId2-entry-IRE">

Sys\_id for the identifier rule used to identify this additional CI.Notable values - Unknown: Identification of this additional CI failed. See **errors** for details.

</td></tr><tr id="row-return-additionalCommittedItems-inputIndices"><td>

&lt;String&gt;.additionalCommittedItems.inputIndices

</td><td id="addCommItems_inputIndices-entry-IRE">

Index values for CIs from the request body **items** array that correspond to this additional CI.Data type: Array of Numbers

```
"inputIndices": [
  {
    Number
  }
]
```

</td></tr><tr id="row-return-additionalCommittedItems-markers"><td>

&lt;String&gt;.additionalCommittedItems.markers

</td><td id="addCommItems_markers-entry-IRE">

Marker values for internal use.Data type: Array

```
"markers": []
```

</td></tr><tr id="row-return-additionalCommittedItems-mergedPayloads"><td>

&lt;String&gt;.additionalCommittedItems.mergedPayloads

</td><td id="addCommItems_mergedPayloads-entry-IRE">

Sys\_id values for partial payloads from the CMDB IRE Partial Payloads \[cmdb\_ire\_partial\_payloads\] table that were merged during processing of this additional CI.Data type: Array

```
"mergedPayloadIds": [
  "String"
]
```

</td></tr><tr id="row-return-additionalCommittedItems-operation"><td>

&lt;String&gt;.additionalCommittedItems.operation

</td><td id="addCommItems_operation-entry-IRE">

Operation performed for this additional CI.Data type: String

Possible values:

-   DELETE: An existing CI is removed from the target table.
-   INSERT: The additional CI is inserted into the target table as a new record.
-   NO\_CHANGE: No operation is performed for the additional CI.
-   UPDATE: An existing CI in the target table is updated.
-   UPDATE\_WITH\_DOWNGRADE: An existing CI in the target table is updated and its class is changed to a more generic class \(ancestor class\).
-   UPDATE\_WITH\_SWITCH: An existing CI in the target table is updated and its class is changed to another class which is not an ancestor or descendent class.
-   UPDATE\_WITH\_UPGRADE: An existing CI in the target table is updated and its class is changed to a more specialized class \(descendent class\).

</td></tr><tr id="row-return-additionalCommittedItems-sysId"><td>

&lt;String&gt;.additionalCommittedItems.sysId

</td><td id="addCommItems_sysId-entry-IRE">

Sys\_id found for this additional CI through identification.Data type: String

Notable values - Unknown: Identification of this additional CI failed. See **errors** for details.

</td></tr><tr id="row-return-additionalCommittedItems-warnings"><td>

&lt;String&gt;.additionalCommittedItems.warnings

</td><td id="addCommItems_warnings-entry-IRE">

Description of warnings encountered while processing this additional CI.Data type: Array of Objects

```
"warnings": [
  {
    "error": "String",
    "message": "String"
  }
]
```

</td></tr><tr id="row-return-additionalCommittedItems-warnings-error"><td>

&lt;String&gt;.additionalCommittedItems.warnings.error

</td><td id="addCommItems_warnings_error-entry-IRE">

Type of warning encountered while processing this additional CI.Data type: String

</td></tr><tr id="row-return-additionalCommittedItems-warnings-message"><td>

&lt;String&gt;.additionalCommittedItems.warnings.message

</td><td id="addCommItems_warnings_message-entry-IRE">

Warning message encountered while processing this additional CI.Data type: String

</td></tr><tr id="row_return_additionalCommittedRelations"><td>

&lt;String&gt;.additionalCommittedRelations

</td><td id="entry_return_additionalCommittedRelations">

Description of a dependent relationship CI that was not included in the request body **relations** list to insert or update.Data type: Array of Objects

```
"additionalCommittedRelations": [
  {
    "className": "String",
    "inputIndices": [Array],
    "markers": [Array],
    "mergedPayloadIds": [Array],
    "operation": "String"
  }
]
```

</td></tr><tr id="row_return_additionalCommittedRelations-className"><td>

&lt;String&gt;.additionalCommittedRelations.className

</td><td id="addCommRel_className-entry-IRE">

The sys\_class\_name of this additional dependent relationship CI.Data type: String

Only supported value: cmdb\_rel\_ci: The CI Relationship table.

</td></tr><tr id="row_return_additionalCommittedRelations-errorCount"><td>

&lt;String&gt;.additionalCommittedRelations.errorCount

</td><td id="addCommRel_errorCount-entry-IRE">

Number of errors encountered while processing this additional dependent relationship CI.Data type: Number

</td></tr><tr id="row_return_additionalCommittedRelations-errors"><td>

&lt;String&gt;.additionalCommittedRelations.errors

</td><td id="addCommRel_errors-entry-IRE">

Description of the errors encountered while processing this additional dependent relationship CI.Data type: Array of Objects

```
"errors": [
  {
    "error": "String",
    "message": "String"
  }
]
```

</td></tr><tr id="row_return_additionalCommittedRelations-errors-error"><td>

&lt;String&gt;.additionalCommittedRelations.errors.error

</td><td id="addCommRel_errors_error-entry-IRE">

Type of error encountered while processing the additional dependent relationship CI.Data type: String

</td></tr><tr id="row_return_additionalCommittedRelations-errors-message"><td>

&lt;String&gt;.additionalCommittedRelations.errors.message

</td><td id="addCommRel_errors_message-entry-IRE">

Error message encountered while processing this additional dependent relationship CI.Data type: String

</td></tr><tr id="row_return_additionalCommittedRelations-inputIndices"><td>

&lt;String&gt;.additionalCommittedRelations.inputIndices

</td><td id="addCommRel_inputIndices-entry-IRE">

Index values for dependent relationship CI objects in the request body **relations** array that correspond to this additional dependent relationship CI.Data type: Array

```
"inputIndices": [
  Number
]
```

</td></tr><tr id="row_return_additionalCommittedRelations-markers"><td>

&lt;String&gt;.additionalCommittedRelations.markers

</td><td id="addCommRel_markers-entry-IRE">

Marker values for internal use.Data type: Array

```
"markers": []
```

</td></tr><tr id="row_return_additionalCommittedRelations-mergedPayloadIds"><td>

&lt;String&gt;.additionalCommittedRelations.mergedPayloadIds

</td><td id="addCommRel_mergedPayloadIds-IRE">

Sys\_id values for partial payloads from the CMDB IRE Partial Payloads \[cmdb\_ire\_partial\_payloads\] table that were merged for this CI.that were merged during processing of this additional dependent relationship CI.Data type: Array

```
"mergedPayloadIds": [
  "String"
]
```

</td></tr><tr id="row_return_additionalCommittedRelations-operation"><td>

&lt;String&gt;.additionalCommittedRelations.operation

</td><td id="addCommRel_operations-entry-IRE">

Operation that was performed for the additional dependent relationship CI.Possible values:

-   INSERT: The dependent relationship CI is inserted into the target table as a new record.
-   INSERT\_AS\_INCOMPLETE: The dependent relationship CI had errors and is inserted into the CMDB IRE Incomplete Payloads \[cmdb\_ire\_incomplete\_payloads\] table.
-   INSERT\_AS\_PARTIAL: The dependent relationship CI had errors and is inserted into the CMDB IRE Partial Payloads \[cmdb\_ire\_partial\_payloads\] table.
-   NO\_CHANGE: No operation is performed for the dependent relationship CI.
-   UPDATE: An existing dependent relationship CI in the target table is updated.

Data type: String

</td></tr><tr id="row_return_hasError"><td>

&lt;String&gt;.hasError

</td><td id="entry_return_summary_class_name_hasError">

Flag that indicates whether any item or relation has errors.Data type: Boolean

</td></tr><tr id="row_return_hasWarning"><td>

&lt;String&gt;.hasWarning

</td><td id="entry_return_summary_class_name_hasWarning">

Flag that indicates whether any item or relation has warnings.Data type: Boolean

</td></tr><tr id="row_items_IEES"><td>

&lt;String&gt;.items

</td><td id="items-entry-IRE">

Description of the created or updated CIs.Data type: Array of Objects

```
"items": [
  {  
    "additionalRelatedItems": [Array],
    "className": "String",
    "duplicateIndices": [Array],
    "errorCount": Number, 
    "errors": [Array], 
    "identificationAttempts": [Array], 
    "identifierEntrySysId": "String",  
    "incompleteSysIds": "String",
    "info": [Array],
    "inputIndices": [Array], 
    "maskedAttributes": [Array],
    "operation": "String", 
    "partialSysIds": "String", 
    "relatedItems": [Array], 
    "relatedSysIds": [Array], 
    "sysId": "String" 
  }
]
```

</td></tr><tr id="row_return_item_additionalRelatedItems"><td>

&lt;String&gt;.items.additionalRelatedItems

</td><td id="entry_return_item_additionalRelatedItems">

Information about additional lookup and related items that were processed but not provided as part of the input payload. These items are from partial payloads.Data type: Array of Objects

```
"additionalRelatedItems": [ 
  {
    "className": "String", 
    "inputIndices": [Array],
    "mergedPayloadIds": [Array], 
    "operation": "String",
    "sysId": "String"
  }
]
```

</td></tr><tr id="row_return_item_additionalRelatedItems_className"><td>

&lt;String&gt;.items.additionalRelatedItems.className

</td><td id="items_addRelItems_className-entry-IRE">

Class/table name \(sys\_class\_name\) of the CI that was created or updated.Data type: String

</td></tr><tr id="row_return_item_additionalRelatedItems_inputIndices"><td>

&lt;String&gt;.items.additionalRelatedItems.inputIndices

</td><td id="items_addRelItems_inputIndices-entry-IRE">

Index values for CIs from the request body **items** array that correspond to this related item.Data type: Array of Numbers

</td></tr><tr id="row_return_item_additionalRelatedItems_mergedPayloadIds"><td>

&lt;String&gt;.items.additionalRelatedItems.mergedPayloadIds

</td><td id="entry_return_item_additionalRelatedItems_mergedPayloadIds">

List of sys\_ids of the partial payloads that were merged into the related item.Data type: Array

Table: CMDB IRE Partial Payloads \[cmdb\_ire\_partial\_payloads\]

</td></tr><tr id="row_return_item_additionalRelatedItems_operations"><td>

&lt;String&gt;.items.additionalRelatedItems.operation

</td><td id="entry_return_item_additionalRelatedItems_operations">

Type of operation.Possible values:

-   INSERT: New CI was inserted into the database.
-   NO\_CHANGE: No CI changes were made.
-   UPDATE: Existing CI was updated.

Data type: String

</td></tr><tr id="row_return_item_additionalRelatedItems_sysId"><td>

&lt;String&gt;.items.additionalRelatedItems.sysId

</td><td id="items_addRelItems_sysId-entry-IRE">

Sys\_id of the CI that was updated or created.Data type: String

</td></tr><tr id="row_return_item_className"><td>

&lt;String&gt;.items.className

</td><td id="entry_return_item_className">

Class/table name \(sys\_class\_name\) of the CI that was created or updated.Data type: String

</td></tr><tr id="row_return_items_duplicateIndices"><td>

&lt;String&gt;.items.duplicateIndices

</td><td id="entry_return_items_duplicateIndices">

List of indexes of CIs that are duplicates of the current item.Data type: Array

</td></tr><tr id="row_return_item_errorCount"><td>

&lt;String&gt;.items.errorCount

</td><td id="entry_return_item_errorCount">

Number of errors encountered while processing the item.Data type: Number

</td></tr><tr id="row_return_item_error"><td>

&lt;String&gt;.items.errors

</td><td id="entry_return_item_error">

List of errors encountered while processing this CI.Data type: Array of Objects

```
"errors": [
  {
    "error": "String",
    "message": "String"
  }
]
```

</td></tr><tr id="row_return_item_errors-error"><td>

&lt;String&gt;.items.errors.error

</td><td id="items_errors_errors-entry-IRE">

Type of error encountered while processing the CI.Data type: String

</td></tr><tr id="row_return_item_errors-message"><td>

&lt;String&gt;.items.errors.message

</td><td id="items_errors_msg-entry-IRE">

Error message associated with the error.Data type: String

</td></tr><tr id="row_return_item_identificationAttempts"><td>

&lt;String&gt;.items.identificationAttempts

</td><td id="entry_return_item_identificationAttempts">

List of attempts that were made to identify the CIs.Data type: Array of Objects

```
"identificationAttempts": [
  { 
    "attemptResult": "String", 
    "attributes": [Array],
    "hybridEntryCiAttributes": [Array],
    "identifierName": "String",
    "searchOnTable": "String" 
  }
]
```

</td></tr><tr id="row_return_item_identificationAttempts_attemptResult"><td>

&lt;String&gt;.items.identificationAttempts.attemptResult

</td><td id="entry_return_item_identificationAttempts_attemptResult">

Results of the attempt to identify the CI.Possible values:

-   MATCHED: Identification succeeded. A unique CI was found in the identifier rule table which exactly matched the specified attributes.
-   MULTI\_MATCH: Identification failed with an error. Duplicate CIs were found in the identifier rule table when matching against the specified attributes.
-   NO\_MATCH: Identification failed. No CI was found in the identifier rule table which matched the specified attributes.
-   SKIPPED: Identification not attempted. The attributes required for this identifier rule table search were not provided, so the rule was not applied.

Data type: String

</td></tr><tr id="row_return_item_identificationAttempts_attributes"><td>

&lt;String&gt;.items.identificationAttempts.attributes

</td><td id="entry_return_item_identificationAttempts_attributes">

List of CI identifier entry attributes that were used during the identification process.Data type: Array

Attribute names and types depend on the request body data and the identifier in use, such as:

```
"attributes": [
  "serial_number": "String",
  "serial_number_type": "String",
]
```

</td></tr><tr><td>

&lt;String&gt;items.identificationAttempts.hybridEntryCiAttributes

</td><td id="items_identAtt_hyEntCiAtt-IRE">

List of CI identifier entry attributes that were used during the identification process.Data type: Array

Attribute names and types depend on the request body data and the identifier in use, such as:

```
"hybridEntryCiAttributes": [
  "name": "String",
  "serial_number": "String"
]
```

</td></tr><tr id="row_return_item_identificationAttempts_identifierName"><td>

&lt;String&gt;.items.identificationAttempts.identifierName

</td><td id="entry_return_item_identificationAttempts_identifierName">

Identifier rule used for this CI identification attempt.Data type: String

</td></tr><tr id="row_return_item_identificationAttempts_searchOnTable"><td>

&lt;String&gt;.items.identificationAttempts.searchOnTable

</td><td id="entry_return_item_identificationAttempts_searchOnTable">

Name of the table searched during the identification process.Data type: String

</td></tr><tr id="row_return_item_identifierEntrySysId"><td>

&lt;String&gt;.items.identifierEntrySysId

</td><td id="entry_return_item_identifierEntrySysId">

Sys\_id for the identifier rule used to identify the CI.Data type: String

Table: Identifier Entry \[cmdb\_identifier\_entry\]

</td></tr><tr id="row_return_item_incompleteSysId"><td>

&lt;String&gt;.items.incompleteSysIds

</td><td id="entry_return_item_incompleteSysId">

If the item had errors and was saved as an incomplete payload, this parameter contains the sys\_id of the record in the CMDB IRE Incomplete Payloads \[cmdb\_ire\_incomplete\_payloads\] table.Data type: String

</td></tr><tr><td>

&lt;String&gt;.items.info

</td><td id="items_info-entry-IRE">

Additional information about the processing of the item.Data type: Array of Objects

```
"info": [
  {
    "code": "String",
    "message": "String",
    "ruleSysId": "String"
  }
]
```

</td></tr><tr><td>

&lt;String&gt;.items.info.code

</td><td id="items_info_code-entry-IRE">

Reclassification type that was skipped.Possible values:

-   SKIPPED\_CLASS\_DOWNGRADE
-   SKIPPED\_CLASS\_SWITCH
-   SKIPPED\_CLASS\_UPGRADE

Data type: String

</td></tr><tr><td>

&lt;String&gt;.items.info.message

</td><td id="items_info_message-entry-IRE">

Message that provides additional insights into the reason for skipping the reclassification.Data type: String

</td></tr><tr><td>

&lt;String&gt;.items.info.ruleSysId

</td><td id="items_info_ruleSysId-entry-IRE">

Sys\_id of the reclassification restriction rule that was matched. Applicable only when IRE skips reclassification due to reclassification restriction rule. This value is empty if the reclassification is skipped due to a payload or global flag.Data type: String

</td></tr><tr id="row_return_items_inputIndices"><td>

&lt;String&gt;.items.inputIndices

</td><td id="entry_return_items_inputIndices">

Indexes of the corresponding input CI. For top-level items, it is a list of integers. For related or lookup CIs, it is list of JSON objects.Data type: Array of Numbers

</td></tr><tr id="row_return_item_maskedAttributes"><td>

&lt;String&gt;.items.maskedAttributes

</td><td id="entry_return_item_maskedAttributes">

List of attributes whose update by a non-authoritative data source was skipped as defined by the [Reconciliation Rules](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/servicenow-platform/create-reconciliation-rule.md).Data type: Array

</td></tr><tr id="row_return_item_operation"><td>

&lt;String&gt;.items.operation

</td><td id="entry_return_item_operation">

Operation that took place.Possible values:

-   INSERT: New CI was inserted into the database.
-   INSERT\_AS\_INCOMPLETE: Item was saved in cmdb\_ire\_incomplete\_payloads table.
-   INSERT\_AS\_PARTIAL: Item was saved in cmdb\_ire\_partial\_payloads table.
-   UPDATE: Existing CI was updated.
-   UPDATE\_WITH\_DOWNGRADE: CI was updated and the class changed to a more generic class \(ancestor class\).
-   UPDATE\_WITH\_SWITCH: CI was updated and the class changed to a class that is not ancestor or descendent.
-   UPDATE\_WITH\_UPDRADE: CI was updated and the class changed to a more specialized class \(descendent class\).

Data type: String

</td></tr><tr id="row_return_item_partialSysId"><td>

&lt;String&gt;.items.partialSysIds

</td><td id="entry_return_item_partialSysId">

If the item had errors and was saved as a partial payload, this parameter contains the sys\_id of the partial payload record. Data type: String

</td></tr><tr id="row_return_item_relatedItems"><td>

&lt;String&gt;.items.relatedItems

</td><td id="entry_return_item_relatedItems">

List of JSON objects that describe a related CI \(table lookup CI\) from the request body **items.lookup** array.Data type: Array of Objects

```
"relatedItems": [
  { 
    "className": "String",
    "errors": [Array],
    "errorCount": Number, 
    "incompleteSysIds": [Array],
    "inputIndices": [Array],
    "mergePayloadIds": [Array],
    "operation": "String",
    "partialSysIds": [Array], 
    "sysId": "String",
    "warningCount": Number,
    "warnings": [Array]
  }
]
```

</td></tr><tr id="row_return_item_relatedItems_className"><td>

&lt;String&gt;.items.relatedItems.className

</td><td>

Class/table name \(sys\_class\_name\) of the related item.Data type: String

</td></tr><tr id="row_return_item_relatedItems_errors"><td>

&lt;String&gt;.items.relatedItems.errors

</td><td id="entry_return_item_relatedItems_errors">

List of errors that occurred during processing of the related item.Data type: Array of Objects

```
"errors": [
  {
    "error": "String",
    "message": "String"
  }
]
```

</td></tr><tr id="row_return_item_relatedItems_errors_error"><td>

&lt;String&gt;.items.relatedItems.errors.error

</td><td>

Type of error encountered while processing the related item.Data type: String

</td></tr><tr id="row_return_item_relatedItems_errors-message"><td>

&lt;String&gt;.items.relatedItems.errors.message

</td><td>

Error message associated with the error.Data type: String

</td></tr><tr id="row_return_item_relatedItems_errorCount"><td>

&lt;String&gt;.items.relatedItems.errorCount

</td><td id="entry_return_item_relatedItems_errorCount">

Number of errors detected while processing the related items.Data type: Number

</td></tr><tr><td>

&lt;String&gt;.items.relatedItems.incompleteSysIds

</td><td>

If the relation had errors and was saved as an incomplete payload, this value is the sys\_id of the record in the CMDB IRE Incomplete Payloads \[cmdb\_ire\_incomplete\_payloads\] table.Data type: String

</td></tr><tr id="row_return_item_relatedItems_inputIndices"><td>

&lt;String&gt;.items.relatedItems.inputIndices

</td><td id="entry_return_item_relatedItems_inputIndices">

Index of the corresponding input item. For top-level items, it is a list of integers. For related or lookup items, it is list of JSON objects.Data type: Array of Numbers or Array of Objects

```
"inputIndices": [
  { 
   "mainIndex": Number, 
   "subIndex": Number 
  }
]
```

</td></tr><tr id="row_return_item_relatedItems_inputIndices_mainIndex"><td>

&lt;String&gt;.items.relatedItems.inputIndices.mainIndex

</td><td id="entry_return_item_relatedItems_inputIndices.mainIndex">

Index value from the request body **items** array that corresponds to the CI parent of the related item. Data type: Number

</td></tr><tr id="row_return_item_relatedItems_inputIndices_subIndex"><td>

&lt;String&gt;.items.relatedItems.inputIndices.subIndex

</td><td id="entry_return_item_relatedItems_inputIndices.subIndex">

Index value from the request body **items.lookup** array that corresponds to the related item.Data type: Number

</td></tr><tr id="row_return_item_relatedItems_mergedPayloadIds"><td>

&lt;String&gt;.items.relatedItems.mergedPayloadIds

</td><td>

List of sys\_ids of the partial payloads that were merged into the CI during processing.Data type: Array

</td></tr><tr id="row_return_item_relatedItems_operation"><td>

&lt;String&gt;.items.relatedItems.operation

</td><td>

Operation that took place.Possible values:

-   INSERT: New related CI was inserted into the database.
-   INSERT\_AS\_INCOMPLETE: Item was saved in cmdb\_ire\_incomplete\_payloads table.
-   INSERT\_AS\_PARTIAL: Item was saved in cmdb\_ire\_partial\_payloads table.
-   NO\_CHANGE: No related CI changes were made.
-   UPDATE: Existing related CI was updated.
-   UPDATE\_WITH\_DOWNGRADE: Related CI was updated and the class changed to a more generic class \(ancestor class\).
-   UPDATE\_WITH\_SWITCH: Related CI was updated and the class changed to a class that is not ancestor or descendent.
-   UPDATE\_WITH\_UPDRADE: Related CI was updated and the class changed to a more specialized class \(descendent class\).

Data type: String

</td></tr><tr><td>

&lt;String&gt;.items.relatedItems.partialSysIds

</td><td>

If the related item had errors and was saved as a partial payload, this contains a list of the sys\_ids of the associated records in the CMDB IRE Partial Payloads \[cmdb\_ire\_partial\_payloads\] table.Data type: Array

</td></tr><tr id="row_return_item_relatedItems_sysId"><td>

&lt;String&gt;.items.relatedItems.sysId

</td><td>

Sys\_id of the related item.Data type: String

</td></tr><tr id="row_return_item_relatedItems_warningCount"><td>

&lt;String&gt;.items.relatedItems.warningCount

</td><td>

Number of warnings encountered when processing the related items.Data type: Number

</td></tr><tr id="row_return_item_relatedItems_wrnings"><td>

&lt;String&gt;.items.relatedItems.warnings

</td><td>

Description of warnings encountered while processing the related items.Data type: Array of Objects

```
"warnings": [
  {
    "error": "String",
    "message": "String"
  }
]
```

</td></tr><tr><td>

&lt;String&gt;.items.relatedItems.warnings.error

</td><td>

Type of warning encountered while processing the related item.Data type: String

</td></tr><tr><td>

&lt;String&gt;.items.relatedItems.warnings.message

</td><td>

Message associated with the warning.Data type: String

</td></tr><tr id="row_return_item_relatedSysIds"><td>

&lt;String&gt;.items.relatedSysIds

</td><td id="entry_return_item_relatedSysIds">

List of the sys\_id values of the CIs used during lookup-based identification of related items.Data type: String

</td></tr><tr id="row_return_item_sys_id"><td>

&lt;String&gt;.items.sys\_id

</td><td id="entry_return_item_sys_id">

Sys\_id of the CI that was updated or created.Data type: String

</td></tr><tr id="row_return_relations"><td>

&lt;String&gt;.relations

</td><td id="entry_return_relations">

Description of a dependent relationship CI from the request body **relations** array.Data type: Array of Objects

```
"relations": [ 
  { 
    "className": "String",
    "errorCount": Number,
    "errors": [Array],
    "incompleteSysIds": "String",
    "inputIndices": [Array],
    "operation": "String",
    "partialSysIds": "String",
    "sysId": "String" 
  }
]
```

</td></tr><tr id="row_return_relations_className"><td>

&lt;String&gt;.relations.className

</td><td id="entry_return_relations_className">

Sys\_class\_name of this dependent relationship CI.Only supported value: cmdb\_rel\_ci: CI Relationship table.

Data type: String

</td></tr><tr id="row_return_relations_errorsCount"><td>

&lt;String&gt;.relations.errorCount

</td><td id="entry_return_relations_errorsCount">

Number of errors encountered when processing the dependent relationship CI.Data type: Number

</td></tr><tr id="row_return_relations_errors"><td>

&lt;String&gt;.relations.errors

</td><td id="entry_return_relations_errors">

List that describes errors that were encountered while processing this dependent relationship CI.Data type: Array of Objects

```
"errors": [
  {
    "error": "String",
    "message": "String"
  }
]
```

</td></tr><tr><td>

&lt;String&gt;.relations.errors.error

</td><td>

Type of error encountered while processing the dependent relationship CI.Data type: String

</td></tr><tr><td>

&lt;String&gt;.relations.errors.message

</td><td>

Error message encountered while processing this dependent relationship CI.Data type: String

</td></tr><tr id="row_return_relations_incompleteSysId"><td>

&lt;String&gt;.relations.incompleteSysIds

</td><td id="entry_return_relations_incompleteSysId">

If the relation had errors and was saved as an incomplete payload, this value is the sys\_id of the record in the CMDB IRE Incomplete Payloads \[cmdb\_ire\_incomplete\_payloads\] table.Data type: String

</td></tr><tr id="row_return_relations_inputIndices"><td>

&lt;String&gt;.relations.inputIndices

</td><td id="entry_return_relations_inputIndices">

Indexes for the dependent relationship CI objects in the request body **relations** array that correspond to this dependent relationship CI.Data type: Array

</td></tr><tr id="row_return_relations_operation"><td>

&lt;String&gt;.relations.operation

</td><td id="entry_return_relations_operation">

Type of operation performed.Possible values:

-   INSERT: The dependent relationship CI was inserted into the target table as a new record.
-   INSERT\_AS\_INCOMPLETE: The dependent relationship CI had errors and was inserted into the CMDB IRE Incomplete Payloads \[cmdb\_ire\_incomplete\_payloads\] table.
-   INSERT\_AS\_PARTIAL: The dependent relationship CI had errors and was inserted into the CMDB IRE Partial Payloads \[cmdb\_ire\_partial\_payloads\] table.
-   NO\_CHANGE: No operation was performed.
-   UPDATE: An existing dependent relationship CI in the target table was updated.

Data type: String

</td></tr><tr id="row_return_relations_partialSysId"><td>

&lt;String&gt;.relations.partialSysIds

</td><td id="entry_return_relations_partialSysId">

If the relation had errors and was saved as a partial payload, this value is the sys\_id of the record in the CMDB IRE Partial Payloads \[cmdb\_ire\_partial\_payloads\] table.Data type: String

</td></tr><tr id="row_return_relations_sys_id"><td>

&lt;String&gt;.relations.sysId

</td><td id="entry_return_relations_sys_id">

Sys\_id of the dependent relationship CI.Data type: String

</td></tr><tr id="row_return_summary"><td>

&lt;String&gt;.summary

</td><td id="entry_return_summary">

List of JSON properties that provide statistics on how many items were inserted, updated, and such, per class.Data type: Array

</td></tr><tr id="row_return_summary_class_name"><td>

&lt;String&gt;.summary.&lt;class\_name&gt;

</td><td id="entry_return_summary_class_name">

Statistics for a specific class.Data type: Object

```
<class_name>: {
 "additionalInsertedItemCount": Number, 
 "errorCount": Number,
 "incompleteItemCount": Number,
 "insertedItemCount": Number,
 "partialItemCount": Number,
 "skippedItemCount": Number,
 "unchangedItemCount": Number,
 "updatedItemCount": Number,
 "warningCount": Number 
}
```

</td></tr><tr id="row_return_summary_class_name_additionalInsertedItemCount"><td>

&lt;String&gt;.summary.&lt;class\_name&gt;.additionalInsertedItemCount

</td><td id="entry_return_summary_class_name_additionalInsertedItemCount">

Number of items inserted due to processing of partial payloads.Data type: Number

</td></tr><tr id="row_return_summary_class_name_errorCount"><td>

&lt;String&gt;.summary.&lt;class\_name&gt;.errorCount

</td><td id="entry_return_summary_class_name_errorCount">

Number of errors encounter when processing items.Data type: Number

</td></tr><tr id="row_return_summary_class_name_incompleteItemCount"><td>

&lt;String&gt;.summary.&lt;class\_name&gt;.incompleteItemCount

</td><td id="entry_return_summary_class_name_incompleteItemCount">

Number of items inserted in the CMDB IRE Incomplete Payloads \[cmdb\_ire\_incomplete\_payloads\] table.Data type: Number

</td></tr><tr id="row_return_summary_class_name_insertedItemCount"><td>

&lt;String&gt;.summary.&lt;class\_name&gt;.insertedItemCount

</td><td id="entry_return_summary_class_name_insertedItemCount">

Number of items created.Data type: Number

</td></tr><tr id="row_return_summary_class_name_partialItemCount"><td>

&lt;String&gt;.summary.&lt;class\_name&gt;.partialItemCount

</td><td id="entry_return_summary_class_name_partialItemCount">

Number of items saved in the Partial Payload table \[cmdb\_ire\_partial\_payloads\].Data type: Number

</td></tr><tr id="row_return_summary_class_name_skippedItemCount"><td>

&lt;String&gt;.summary.&lt;class\_name&gt;.skippedItemCount

</td><td>

Number of items that were skipped.Data type: Number

</td></tr><tr id="row_return_summary_class_name_unchangedItemCount"><td>

&lt;String&gt;.summary.&lt;class\_name&gt;.unchangedItemCount

</td><td id="entry_return_summary_class_name_unchangedItemCount">

Number of items that had entries but were not modified.Data type: Number

</td></tr><tr id="row_return_summary_class_name_updatedItemCount"><td>

&lt;String&gt;.summary.&lt;class\_name&gt;.updatedItemCount

</td><td id="entry_return_summary_class_name_updatedItemCount">

Number of items updated.Data type: Number

</td></tr><tr id="row_return_summary_class_name_warningCount"><td>

&lt;String&gt;.summary.&lt;class\_name&gt;.warningCount

</td><td id="entry_return_summary_class_name_warningCount">

Number of items that generated a warning when processed.Data type: Number

</td></tr></tbody>
</table>This code example shows how to obtain the payload of an ImportSet, where you can then update the payload, and then set the new payload before calling the cmdbUtil.identifyAndReconcileEnhanced\(\) method to process the payload.

```
// Add this code to the onBefore transform map script
// Ability to modify the payload using get and set APIs
// Call cmdbUtil API to do Identification and Reconciliation of current row
var cmdbUtil = new CMDBTransformUtil();
cmdbUtil.setDataSource('ImportSet');
var payload = cmdbUtil.getPayload(source, map, log);
// Modify the payload here
cmdbUtil.setPayload(payload);
cmdbUtil.identifyAndReconcileEnhanced(source, map, log);
ignore = true;
 
if (cmdbUtil.hasError()) {
  var errorMessage = cmdbUtil.getError();
  log.error(errorMessage);
} else {
  log.info('IE Output Payload: ' + cmdbUtil.getOutputPayload());
  log.info('Imported CI: ' + cmdbUtil.getOutputRecordSysId());
}
```

## CMDBTransformUtil - hasError\(\)

Determines if an error occurred in the previous identifyAndReconcile\(\) or identifyAndReconcileEnhanced\(\) method call.

Use this method in onBefore transform map scripts.

|Name|Type|Description|
|----|----|-----------|
|None| | |

<table id="table_zr5_swg_gz" class="returns"><thead><tr><th>

Type

</th><th>

Description

</th></tr></thead><tbody><tr><td>

Boolean

</td><td>

Flag that indicates whether there was an error occurred in the previously called identifyAndReconcile\(\) or identifyAndReconcileEnhanced\(\) method.Possible values:

-   true: An error occurred
-   false: No error occurred

</td></tr></tbody>
</table>```
// Add this code to the onBefore transform map script
// Call CMDB API to do Identification and Reconciliation of current row
var cmdbUtil = new CMDBTransformUtil();
cmdbUtil.setDataSource('ImportSet');
cmdbUtil.identifyAndReconcileEnhanced(source, map, log);
ignore = true;

if (cmdbUtil.hasError()) {
  var errorMessage = cmdbUtil.getError();
  log.error(errorMessage);
} else {
  log.info('IE Output Payload: ' + cmdbUtil.getOutputPayload());
  log.info('Imported CI: ' + cmdbUtil.getOutputRecordSysId());
}
```

### Scoped equivalent

There is no scoped equivalent for this method.

## CMDBTransformUtil - identifyAndReconcile\(Object source, Object map, Object log\)

Inserts or updates a configuration item \(CI\) in the Configuration Management Database \(CMDB\).

Use this method in onBefore transform map scripts. Using this method instead of relying on the transform to insert or update the configuration item record reduces duplicate entries in the CMDB. For additional information, see [Apply CI Identification and Reconciliation to Import Sets](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/servicenow-platform/identification-import-sets.md).

To prevent the transform from adding or updating the record a second time, set `ignore = true`.

|Name|Type|Description|
|----|----|-----------|
|source|Object|Global object available in transform map scripts that holds the incoming record.|
|map|Object|Map object available in transform map scripts that holds the current transform map record.|
|log|Object|Log object available in transform map scripts.|

|Type|Description|
|----|-----------|
|void| |

This code example shows how to call the identifyAndReconcile\(\) method to process the current row of the input payload.

```
// Add this code to the onBefore transform map script
// Call CMDBTransformUtil API to do Identification and Reconciliation of the current row
var cmdbUtil = new CMDBTransformUtil();
cmdbUtil.identifyAndReconcile(source, map, log);
ignore = true;
```

## CMDBTransformUtil - identifyAndReconcileEnhanced\(Object source, Object map, Object log\)

Inserts or updates a configuration item \(CI\) in the Configuration Management Database \(CMDB\).

In addition to providing the functionality of the CMDBTransformUtil.identifyAndReconcile\(\) method, this method also supports:

-   Handling partial payloads
-   Handling partial commits
-   Removing duplicate items within a payload
-   Generating output summaries

For additional information on Identification and Reconciliation and more detailed explanations of the data used by this method, see [Identification and Reconciliation \(IRE\)](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/servicenow-platform/ire.md).

|Name|Type|Description|
|----|----|-----------|
|source|Object|Global object available in transform map scripts that holds the incoming record.|
|map|Object|Map object available in transform map scripts that holds the current transform map record.|
|log|Object|Log object available in transform map scripts.|

|Type|Description|
|----|-----------|
|None| |

This code example shows how to call the identifyAndReconcileEnhanced\(\) method to process the passed in payload.

```
// Add this code to the onBefore transform map script
// Call CMDBTransformUtil API to do Identification and Reconciliation
var cmdbUtil = new CMDBTransformUtil();
cmdbUtil.identifyAndReconcileEnhanced(source, map, log);
ignore = true;
```

## CMDBTransformUtil - logTransformStats\(Object log\)

Logs the number of configuration items \(CI\) inserted, updated, skipped, or that had errors.

Use this method in onComplete transform map scripts.

|Name|Type|Description|
|----|----|-----------|
|log|Object|Log object available in transform map scripts.|

|Type|Description|
|----|-----------|
|void| |

```
var cmdbUtil = new CMDBTransformUtil();
cmdbUtil.logTransformStats(log);
```

### Scoped equivalent

There is no scoped equivalent for this method.

## CMDBTransformUtil - setDataSource\(String source\)

Sets the data source to use when the identifyAndReconcile\(\) or identifyAndReconcileEnhanced\(\) method is called.

Use this method in `onBefore` transform map scripts. If this method is not called, the default value *ImportSet*.

|Name|Type|Description|
|----|----|-----------|
|source|String|Data source for the source configuration item record.|

|Type|Description|
|----|-----------|
|void| |

```
// Add this code to the onBefore transform map script
// Call CMDB API to do Identification and Reconciliation of current row
var cmdbUtil = new CMDBTransformUtil();
cmdbUtil.setDataSource('ImportSet');
cmdbUtil.identifyAndReconcileEnhanced(source, map, log);
ignore = true;

if (cmdbUtil.hasError()) {
  var errorMessage = cmdbUtil.getError();
  log.error(errorMessage);
} else {
  log.info('IE Output Payload: ' + cmdbUtil.getOutputPayload());
  log.info('Imported CI: ' + cmdbUtil.getOutputRecordSysId());
}
```

### Scoped equivalent

There is no scoped equivalent for this method.