Skip to main content
Glama

Dataverse MCP Server

by mwhesse

create_autonumber_column

Add an AutoNumber column to Dataverse tables that automatically generates unique alphanumeric identifiers using sequential numbers, random strings, and datetime placeholders with custom formatting.

Instructions

Creates a new AutoNumber column in a Dataverse table with specified format. AutoNumber columns automatically generate alphanumeric strings using sequential numbers, random strings, and datetime placeholders. Requires a solution context to be set first.

Input Schema

NameRequiredDescriptionDefault
autoNumberFormatYesAutoNumber format using placeholders like "PREFIX-{SEQNUM:4}-{RANDSTRING:3}-{DATETIMEUTC:yyyyMMdd}"
descriptionNoDescription of the AutoNumber column
displayNameYesDisplay name for the AutoNumber column (e.g., "Serial Number")
entityLogicalNameYesLogical name of the table to add the AutoNumber column to
isAuditEnabledNoWhether auditing is enabled for this column
isValidForAdvancedFindNoWhether the column appears in Advanced Find
isValidForCreateNoWhether the column can be set during create
isValidForUpdateNoWhether the column can be updated
maxLengthNoMaximum length for the column (default: 100, ensure enough room for format expansion)
requiredLevelNoRequired level of the columnNone
schemaNameNoSchema name for the column (auto-generated if not provided)

Input Schema (JSON Schema)

{ "properties": { "autoNumberFormat": { "description": "AutoNumber format using placeholders like \"PREFIX-{SEQNUM:4}-{RANDSTRING:3}-{DATETIMEUTC:yyyyMMdd}\"", "type": "string" }, "description": { "description": "Description of the AutoNumber column", "type": "string" }, "displayName": { "description": "Display name for the AutoNumber column (e.g., \"Serial Number\")", "type": "string" }, "entityLogicalName": { "description": "Logical name of the table to add the AutoNumber column to", "type": "string" }, "isAuditEnabled": { "description": "Whether auditing is enabled for this column", "type": "boolean" }, "isValidForAdvancedFind": { "description": "Whether the column appears in Advanced Find", "type": "boolean" }, "isValidForCreate": { "description": "Whether the column can be set during create", "type": "boolean" }, "isValidForUpdate": { "description": "Whether the column can be updated", "type": "boolean" }, "maxLength": { "default": 100, "description": "Maximum length for the column (default: 100, ensure enough room for format expansion)", "maximum": 4000, "minimum": 1, "type": "number" }, "requiredLevel": { "default": "None", "description": "Required level of the column", "enum": [ "None", "SystemRequired", "ApplicationRequired", "Recommended" ], "type": "string" }, "schemaName": { "description": "Schema name for the column (auto-generated if not provided)", "type": "string" } }, "required": [ "entityLogicalName", "displayName", "autoNumberFormat" ], "type": "object" }

Other Tools from Dataverse MCP Server

Related Tools

    MCP directory API

    We provide all the information about MCP servers via our MCP API.

    curl -X GET 'https://glama.ai/api/mcp/v1/servers/mwhesse/mcp-dataverse'

    If you have feedback or need assistance with the MCP directory API, please join our Discord server