MCP Server for Vault CRM

Build 25.0.9440

DatasetItems

Contains individual data elements within a dataset, often representing granular units of structured information used for reporting, analytics, or integration.

Columns

Name Type ReadOnly Description
ID [KEY] String True

Unique identifier for the dataset item record, used as the primary key for referencing within the system.

Name String False

Human-readable name of the dataset item, typically derived from the Vault field name (name__v).

Status String False

Current lifecycle status of the dataset item, indicating whether it is active, inactive, deprecated, or in another state (status__v).

Dataset String False

Reference to the parent dataset to which this item belongs, linking the item to a broader data grouping (dataset__sys).

Data Type String False

Indicates the data type of the field or value represented by this dataset item, such as string, integer, or boolean (data_type__sys).

Data Action String False

Specifies the intended action for the dataset item during data operations, such as insert, update, or delete (data_action__sys).

Key Field String False

Denotes whether the dataset item represents a key field used for identifying records uniquely within the dataset (key_field__sys).

Excluded Columns String False

Comma-separated list of column names to be excluded from processing for this dataset item. This is used to filter out unnecessary or irrelevant fields (excluded_columns__sys).

Filter String False

Condition or expression applied to filter records relevant to this dataset item during data processing (filter__sys).

Relationship String False

Describes any relationship between this dataset item and other datasets, such as one-to-many or parent-child relationships (relationship__sys).

Display Order Decimal False

Numerical value that defines the order in which the dataset item should be displayed in user interfaces or reports (display_order__sys).

Created By String True

Username or identifier of the user who created the dataset item record (created_by__v).

Created Date Datetime True

Timestamp representing when the dataset item record was first created in the system (created_date__v).

Last Modified By String True

Username or identifier of the user who last modified the dataset item record (modified_by__v).

Last Modified Date Datetime True

Timestamp representing the most recent modification to the dataset item record (modified_date__v).

Global ID String True

Globally unique identifier for the dataset item, allowing consistent reference across distributed environments (global_id__sys).

Link String False

System-generated URL or link that directs to the specific dataset item in the Vault UI (link__sys).

Record Migration Mode Bool False

Boolean flag that indicates whether the record should be included in migration processes. True if the item participates in data migration (record_migration_mode__sys).

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9440