Default Value Harvesting

If the service metadata includes default field values, the add-in automatically harvests these values when a catalog is created and displays them in the appropriate field editor. The add-in can harvest default values for business object fields, custom action fields, row finder variables, and polymorphic fields.

Default values are automatically harvested when a new catalog or business object is imported. For existing catalogs, default values are harvested during a catalog refresh, based on the priority option you select:

• If you select Give priority to the new metadata property values, the add-in replaces the existing default values with the values in the service metadata.
• If you select Give priority to the existing catalog property values, the add-in adds new default values and only updates existing default values that have a null value.

The add-in can also refresh the default values of polymorphic segments, such as descriptive flexfield (DFF) global, discriminator, and context-sensitive fields. These values are refreshed before the first download after opening a saved workbook and when a refresh is invoked in the Polymorphic Information tab in the field editor for the discriminator field.

The formats for harvested default values depend on the data type and are governed by OpenAPI. The add-in formats these default values as shown in this table.

Data Type	Service Metadata	Add-in
Integer	1	1
Number	0.78	{0.78}
String	"default_string"	"default_string"
Boolean	true/false	{True}/{False}
Date	"2025-02-20"	{d'2025-02-20'}
Date-time	"2025-02-20T13:00:00Z"	{dt'2025-02-20T13:00:00Z'}