Property description

The excel_import_settings property configures the settings for importing objects from an Excel file.

Minimal JSON

{
  "key": "excel_import_settings"
}
{
  "setting": {
    "key": "excel_import_settings",
    "value": {
      "allowCrossSpaceAppImport": true,
      "allowedImportModes": [
        "FULL_RELOAD",
        "INSERT",
        "UPDATE",
        "DELETE"
      ],
      "dateFormat": "MM-dd-yy",
      "fullReloadDeletionMode": "SOFT",
      "minimalRightsLevel": "space_admin",
      "multiAppsImportEnabled": false
    }
  }
}

This example JSON is applicable for the settings asset. The settings in the applications asset are configured differently.

Nested properties

PropertyDescriptionValueMandatory
keyexcel_import_settingsstringYes
valueSpecifies settings values.stringNo

*Supported key values

NameIs Single OnlyDescription
allowCrossSpaceAppImportYesEnables objects to be imported across different spaces and applications.
allowedImportModesNoAllowed import modes. Supported values are: FULL_RELOAD: Allows the full reload of the objects., INSERT: Allows inserting new objects specified in the import., UPDATE: Allows updating objects specified in the import., DELETE: Allows deleting objects specified in the import.
dateFormatNoDate format used in the import Excel file. The list of supported values can be found here. Default value is d.m.yyyy (e.g., 1.1.202x).
enableExtendedLoggingNoEnables extended logging. The default value is false.
fullReloadDeletionModeNoThe deletion mode during a full reload process. The default value is SOFT.
minimalRightsLevelNoSets the minimum required role (permission level) needed to import objects. Supported values are: contributor: Any contributor with writepermissions for the space and higher can import objects. Default value., space_admin: Only space admins and higher can import objects., admin: Only administrators can import objects.
multiAppsImportEnabledNoEnables object import into multiple applications. The default value is false.