Define the entity fields mapped for Extract Transform Load (ETL) operations.

Before you begin

Role required: import_transformer

Procedure

  1. Navigate to All > System Import Sets > Administration > ETL Definitions.
  2. Select an ETL definition.
  3. On the ETL Entities tab, select an ETL entity.
  4. On the ETL Entity fields tab, click New.
  5. Complete the form.
    FieldDescription
    Name Name of the ETL Entity field definition.
    Field/Path

    The column name in the staging or import set table.

    For reference fields in a target entity, you can specify the columns to map data to. For example, suppose you're mapping data to an address table with three columns: number, street, and postal code. You can specify the unique column to map to by entering address.number, address.postal_code, and address.street.

    When specifying unique columns in reference fields, all must have the same coercion action and coalesce value. For example, all three address fields listed previously must have the same coercion action and the same coalesce value.

    For an import entity, a field within an array can be referenced with the [*] notation. For example, for the following nested structure, you can specify the email address by entering emails[*].address.
    {
      "id": "123",
      "name": "Jhon",
      "emails": [
        {
          "address": "jhon@servicenow.com",
          "type": "work"
        },
      ]
    }
    Coercion action What the system should do if a reference or choice could not be found. Available options are create, ignore, and reject.
    • For the create option, the system creates a new reference/choice and assigns it to the current record.
    • The ignore option sets the current value as empty.
    • The reject option does not save the whole record to the database.
    Coalesce Use this field to query the existing records.
    Application Application scope for this record.
    Entity Name of the robust transform engine entity.
    Definition Selected ETL entity that this field definition belongs to.
  6. Click Submit.