update_dataverse_optionset
Modify Dataverse option sets by adding new choices, updating existing options, removing obsolete values, or changing display properties to maintain data consistency across all related columns.
Instructions
Updates an existing option set by modifying its properties and managing its options. Use this to add new choices, update existing ones, remove obsolete options, or change the option set's display name and description. Changes affect all columns using this option set.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| addOptions | No | New options to add to the option set | |
| description | No | New description of the option set | |
| displayName | No | New display name for the option set | |
| name | Yes | Name of the option set to update | |
| removeOptions | No | Values of options to remove from the option set | |
| updateOptions | No | Existing options to update |
Input Schema (JSON Schema)
{
"properties": {
"addOptions": {
"description": "New options to add to the option set",
"items": {
"additionalProperties": false,
"properties": {
"color": {
"description": "Color for the new option (hex format)",
"type": "string"
},
"description": {
"description": "Description for the new option",
"type": "string"
},
"label": {
"description": "Display label for the new option",
"type": "string"
},
"value": {
"description": "Numeric value for the new option",
"type": "number"
}
},
"required": [
"value",
"label"
],
"type": "object"
},
"type": "array"
},
"description": {
"description": "New description of the option set",
"type": "string"
},
"displayName": {
"description": "New display name for the option set",
"type": "string"
},
"name": {
"description": "Name of the option set to update",
"type": "string"
},
"removeOptions": {
"description": "Values of options to remove from the option set",
"items": {
"type": "number"
},
"type": "array"
},
"updateOptions": {
"description": "Existing options to update",
"items": {
"additionalProperties": false,
"properties": {
"color": {
"description": "New color for the option (hex format)",
"type": "string"
},
"description": {
"description": "New description for the option",
"type": "string"
},
"label": {
"description": "New display label for the option",
"type": "string"
},
"value": {
"description": "Numeric value of the option to update",
"type": "number"
}
},
"required": [
"value"
],
"type": "object"
},
"type": "array"
}
},
"required": [
"name"
],
"type": "object"
}