Category | Aranda Integration Center

Relationship between Category and ServiceNow classes

Integration requires relating the Categories of ICs of the Aranda CMDB with the classes (tables) of the ServiceNow CMDB, below is a json schema that allows us to create this relationship:

{
  "category": [
    {
      "id": 0,
      "projectId": 0,
      "reference": "",
      "externalFilter": "",
      "cmdbFilter": [
        {
          "dataType": "",
          "field": "",
          "logicOperator": "",
          "operator": "",
          "value": ""
        }
      ],
      "ciSource": "",
      "uploadAttachments": false,
      "additionalFields": [
        {
          "id": 0,
          "mappingDirection": "",
          "field": {
            "SearchBy": "",
            "key": "",
            "dataType": ""
          },
          "mapping": [
            {
              "id": 0,
              "value": ""
            }
          ]
        }
      ],
      "state": {
        "mappingDirection": "",
        "field": {
          "searchBy": "",
          "key": "",
          "dataType": ""
        },
        "mapping": [
          {
            "reason": 0,
            "id": 0,
            "value": ""
          }
        ]
      }

    }
  ]
}

Where

Properties	Description
Id	Identifier of the category in the CMDB of Aranda, in the upper right you can see the name of the Category (Desktop)Image
Reference	It corresponds to the name/alias (a pseudoname given to the ServiceNow class) of the ServiceNow class with which we will relate the category of the Aranda CI
ciSource	The import of CIs (create CIs in the Aranda CMDB) or export of CIs (send the CIs of the Aranda CMDB to third parties) is determined by this property, see
projectId	Identifier of the project to which the CI created in the Aranda CMDB is associated
uploadAttachments	Enables integration for cross-platform attachment upload, default property is set to “false”
cmdbFilter	Assign a filter when loading CIs in bulk from the Aranda CMDB to the ServiceNow CMDB Definition of filters in the Aranda CMDB
externalFilter	Assign a filter when loading CIs in bulk from the ServiceNow CMDB to the Aranda CMDB; for more information on filters and search query, see the ServiceNow documentation
state	It represents the relationship of the IC states. List of IC statuses
additionalFields	Represents the relationship between the additional fields in the Aranda CMDB and the fields in the ServiceNow CMDB classes. Relationship between additional fields in the Aranda CMDB and ServiceNow classes

CI CMDB Aranda: Ilustración de referencia.

Relación de estados de los CIs

Estados del CI en la CMDB de Aranda.

IC Statuses in the ServiceNow CMDB.

Para relacionar los estados la integración proporciona el siguiente esquema json:

{
  "state": {
    "mappingDirection": "",
    "field": {
      "key": "",
      "dataType": "",
      "searchBy": ""
    },
    "mapping": [
      {
        "id": 0,
        "value": "",
        "reason": null
      }
    ]
  }
}

Donde:

Properties	Description	Internal properties
field	Represents the information corresponding to the field in ServiceNow	see
mapping	It represents the relationship of the states	see
mappingDirection	Represents the platform that is allowed to update the IC field	see

EXAMPLE: Aranda CMDB / ServiceNow CMDB State Relationship

To create the list of states, follow the instructions below:

Get the IDs of the Aranda CMDB states.
Get sys_id or value from ServiceNow CMDB statuses.
Assign the following status equivalence:

Status in ServiceNow	State in Aranda	ID STATE ARANDA	SYS_ID STATE SERVICENOW
Operational	NEW	1	sys_id_operational
DR Standy	CLOSED	13	sys_id_dr_standy

Type the ID STATE ARANDA On Property “id” and the SYS_ID STATE SERVICENOW of its equivalent taken from the CMDB de ServiceNow On Property value

      [
        {
          "id": 1,
          "value": "sys_id_operational"
        },
        {
          "id": 13,
          "value": "sys_id_dr_standy"
        }
      ]

Definición de filtros en la CMDB de Aranda

The property “cmdbFilter” used in bulk loading of CIs in the Aranda direction - ServiceNow

This property allows you to filter the CIs of the Aranda CMDB by:

Name of the field.
Type of data in the field.
Type of relationship with other search criteria.
Search clause.

{
  "category": [
    {
      "cmdbFilter": [
        {
          "field": "",
          "dataType": "",
          "logicOperator": "",
          "operator": "",
          "value": ""
        }
      ]
    }
  ]
}

Where:

1. “field”: Name of the field by which the searches will be performed; Allows the following values:

Field Name
Name
StateId
ModelId
Serial
AssetTag
Price
ImpactId
BrandId
ManufacturerId
ProviderId
UnitId
UnitSize
ResponsibleId
LicenseNumber
CostCenterId
CreatedDate
ModifierId
AuthorId
Version
Type
ReasonId
ClosedDate
PreviousStateId
IntegrationId
RiskLevel

2. “dataType”: Type of data to which the field to be filtered belongs; Allows the following values:

Data type of the field to be filtered
ShortText
Datetime
LongText
Numeric
Decimal
Date
Currency

3. “logicOperator”: Type of relationship with other search criteria; Allows the following values:

Relationship to other search criteria
And
Or

4. “operator”: Logical operator that will be used in a clause to look for a specific pattern; Allows the following values:

Search Logic Operator
None
EqualTo
NotEqualTo
GreaterThan
GreaterThanOrEqualTo
LessThan
LessThanOrEqualTo
Like
And
Or

Relación entre los campos adicionales y los campos de las clases de ServiceNow

Below is an informative image of how the additional fields in the Aranda CMDB could look, they are grouped in the additional segment

⚐ Note: Additional fields are created according to the customer’s needs, this image is only representative.

Propiedades internas additionalFields

{
  "id": 0,
  "mappingDirection": "",
  "field": {
    "dataType": "",
    "key": "",
    "searchBy": ""
  },
  "mapping": [
    {
      "id": 0,
      "value": ""
    }
  ]
}

The following is a description of the internal properties of the additionalFields object

Properties	Description	Internal properties
Id	Identifier of the field in the CMDB of Aranda
field	Represents the information corresponding to the field in ServiceNow	see
mapping	Represents the relationship of values between the ServiceNow CMDB and the Aranda CMDB	see
mappingDirection	Represents the platform that is allowed to update the IC field	see

Listado de los tipos de campo adicionales soportados
Listado de relación entre los tipos de campos de las plataformas, para los campos adicionales.

CMDB Aranda	Field Type Identifier in CMDB ServiceNow	Name/Label Field Type in ServiceNow
Short Text	String	String
Paragraph	String	String
True or False	true/false	True/False
Date	glide_date	Date
Date and Time	glide_date_time, calendar_date_time	Date/Time, Calendar Date/Time
Numeric	Integer, Longint	Integer, Long
Decimal	decimal	Decimal
List	choice, glide_list, reference	Choice, List, Reference
Catalog (List)	reference, choice	Choice, Reference
Currency	currency, price	Currency, Price
Link	URL	URL
Time	glide_utc_time	UTC Time

⚐ Note: Relating fields of different types to those listed in the previous table will generate an error

Valores permitidos para mappingDirection

Name	Description
Both	Both platforms allow you to update the fields, this value is added by default
Aranda	Only the Aranda CMDB can update the field
External	Only the ServiceNow CMDB can update the

Valores permitidos para ciSource

Name	Description
Both	Both platforms allow you to create and update CIs
Aranda	The Aranda CMDB acts as the source of information and allows the system to create and update CIs in the ServiceNow CMDB. The ServiceNow CMDB only allows you to update CIs in the Aranda CMDB
External	The ServiceNow CMDB acts as the source of truth and allows the system to create and update CIs in the Aranda CMDB. The Aranda CMDB is only allowed to update CIs in the ServiceNow CMDB

↩ Back to Settings