The Open API specification for Synapse is now available for download!

Download Open API Spec

OnMissingValue

org.sagebionetworks.repo.model.grid.update.OnMissingValue

Action if a column referenced in 'sourceTemplate' is null/undefined. SET_NULL sets the value to NULL. SET_UNDEFINED removes the key from the JSON object. SKIP_UPDATE leaves the existing value unchanged. USE_EMPTY_STRING replaces the missing value with '' (empty string) when interpolating the template.

Enumeration
name description
SET_NULL Set the target column value to NULL when a referenced column in the template is null or undefined.
SET_UNDEFINED Remove the target column key from the JSON object when a referenced column in the template is null or undefined.
SKIP_UPDATE Remove the target column key from the JSON object when a referenced column in the template is null or undefined.
USE_EMPTY_STRING Replace missing values with an empty string ('') when interpolating the template.