Property description

The excel_export_settings property configures the settings for exporting objects into an Excel file.

Minimal JSON

{
  "key": "excel_export_settings"
}
{
  "setting":{
    "key":"excel_export_settings",
    "value":{
      "allowedImportModes":[
        "FULL_RELOAD",
        "INSERT",
        "UPDATE",
        "DELETE"
      ],
      "dateFormat":"MM-dd-yy",
      "truncateLongCellValueEnabled":true"joinNumberingAndObjectName":true
    }
  }
}

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

Nested properties

PropertyDescriptionValueMandatory
keyexcel_export_settingsstringYes
valueSpecifies settings values.stringNo

*Supported key values

NameIs Single OnlyDescription
allowedCodeListTypesNoAllowed code lists.
allowedHierarchyTypesNoAllowed hierarchies.
allowedImportModesNoAllowed import modes. Supported values are: FULL_RELOAD, MERGE, INSERT, UPDATE, INSERT_UPDATE, DELETE, STAGE, VALIDATE
dateFormatNoDate format used in the Excel export file. The list of supported values can be found here. If unspecified, default value is d.m.yyyy (e.g., 1.1.202x).
defaultCodeListTypeNoDefault code list.
defaultHierarchyTypeNoDefault hierarchy.
defaultImportModeNoDefault import mode.
defaultWorkflowStateNoDefault workflow state.
filterApplicationsEnabledNoEnables filtering of applications.
filterSpacesEnabledYesEnables filtering of spaces.
hiddenCodeListSheetsNoCode lists excluded from export.
hiddenObjectSheetColumnsNoObject columns excluded from export.
hiddenRelationsSheetColumnsNoRelations excluded from export.
joinNumberingAndObjectNameYesObject numbering and object names appear together in one cell.
truncateLongCellValueEnabledNoDetermines if long cells will be truncated.