Option Values (Partial Update)

Description

Creates or updates an option value identified by the uuid or externalId in the request body.

If the identifier matches an existing option value, it is updated. If not, a new option value is created (upsert behavior). Omitted fields are left unchanged on update, or set to their defaults on creation.

See the Aerial Spec for more details.

File Naming Convention

TGEN_optionValues_partialupdate_2026-04_<optionalSuffix>.csv

  • importType: partialupdate
  • apiVersion: 2026-04

Columns

Column HeaderDescriptionKey InformationTypeRequired
uuidUUID of the resource that can be expressed using a value as defined in its types.stringNo
externalIdExternal ID of the resource that can be expressed using “SET_AS_NULL” (to reset the existing value) or a value as defined in its types.stringNo
typeUUID, External ID or object representation of a option typestringNo
type.uuidUUID of the resourcearrayNo
type.uuid[0]Array elementstringNo
type.externalIdExternal ID of the resourcearrayNo
type.externalId[0]Array elementstringNo
sortOrderSort order of the value against other values of this type that can be expressed using “SET_AS_NULL” (to reset the existing value) or a value as defined in its types.integerNo
valueThe value used to render the option, it can be a string or a code that can be expressed using “SET_AS_NULL” (to reset the existing value) or a value as defined in its types.stringNo
localizedDataA collection of Localizations of the option value that can be expressed using “SET_AS_NULL” (to reset all existing values) or a value as defined in its types.arrayNo
localizedData[0]Array elementmixedNo
localizedData[0].languageCodeLanguage code of localization that can be expressed using a value as defined in its types.stringYes
localizedData[0].nameLocalized option value name that can be expressed using a value as defined in its types.stringNo
localizedData[0].presentationLocalized option value presentation string that can be expressed using a value as defined in its types.stringNo
optionValueCategoriesA collection of optionValueCategories that can be expressed using “SET_AS_NULL” (to reset all existing values), uuids or expanded objects of the accepted type.arrayNo
optionValueCategories[0]Array elementmixedNo
optionValueCategories[0].uuidUUID of the resource that can be expressed using a value as defined in its types.stringNo
optionValueCategories[0].externalIdExternal ID of the resource that can be expressed using “SET_AS_NULL” (to reset the existing value) or a value as defined in its types.stringNo
optionValueCategories[0].localizedDataA collection of Localizations of the option value category that can be expressed using “SET_AS_NULL” (to reset all existing values) or a value as defined in its types.arrayNo
optionValueCategories[0].localizedData[0]Array elementmixedNo
optionValueCategories[0].localizedData[0].languageCodeLanguage code of localization that can be expressed using a value as defined in its types.stringYes
optionValueCategories[0].localizedData[0].nameLocalized option value category name that can be expressed using a value as defined in its types.stringNo
optionValueCategories[0].parentCategoryUUID or external ID of a parent option value category that can be expressed using “SET_AS_NULL” (to reset the existing value) or a structure of {“uuid”: “string”, “externalId”: “string”} (to provide a more expressive identifier) or a value as defined in its types.stringNo
optionValueCategories[0].parentCategory.uuidUUID of the resourcearrayNo
optionValueCategories[0].parentCategory.uuid[0]Array elementstringNo
optionValueCategories[0].parentCategory.externalIdExternal ID of the resourcearrayNo
optionValueCategories[0].parentCategory.externalId[0]Array elementstringNo

Sample CSV

See the following optionValues CSV sample file.

optionValues Sample 1

Note: The sample CSV may contain sample ID fields which reference other resources that do not match the data in your environment. You may omit any non-required fields from the sample CSV, reference the table above for required fields.