GetValidTerms
Retrieves a list of valid managed metadata terms associated with a specific column in a SharePoint list. Helps enforce consistent categorization and tagging of SharePoint content.
Columns
| Name | Type | Description |
| ID [KEY] | String | A unique identifier for the term. Useful for referencing and managing taxonomy terms in SharePoint. |
| TermLabelValue | String | The label assigned to the term. Helps users identify and apply terms to content. |
| Description | String | A brief description of the term set. Useful for understanding the purpose and usage of the term set. |
| NameInRequestedLang | String | The name of the term set in the language requested by the client. Helps with multilingual support. |
| IsOpen | Boolean | Indicates whether the term set is open for adding new terms. Useful for managing controlled vocabularies. |
| Deprecated | Boolean | Indicates whether the term is deprecated. Helps prevent usage of outdated or obsolete terms. |
| InternalId | String | An internal identifier for the term. Useful for system-level term management. |
| TermSetContact | String | The contact person or group responsible for managing the term set. Useful for governance and support. |
| ContainerDesc | String | A container node that holds metadata descriptions. Helps structure taxonomy information. |
| SingleTermLabelDesc | String | A detailed description of a single term label. Useful for providing additional context. |
| IsDefaultLabel | Boolean | Indicates whether the term label is the default for the term. Helps standardize term usage. |
| BelongsTo | String | The term set to which this term belongs. Useful for managing hierarchical taxonomies. |
| IsTaggingAvailable | Boolean | Indicates whether the term set is available for tagging. Helps control content classification. |
| TermPath | String | The hierarchical path of the term with term labels. Useful for navigating term relationships. |
| TermpathoftermwithIds | String | The hierarchical path of the term with its unique identifiers. Helps track term lineage. |
| ChildTerms | String | A custom sort order for child terms within the term hierarchy. Useful for organizing terms. |
| HasChildTerms | Boolean | Indicates whether the term has child terms. Helps manage nested taxonomy structures. |
| PertainingToTerm | String | The identifier of the term that this term set information pertains to. Useful for hierarchical organization. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| List | String | The name of the SharePoint list for which valid terms are being retrieved. Helps with taxonomy integration. |
| ColumnName | String | The column in the list for which valid terms are being retrieved. Useful for metadata enforcement. |
| LocaleId | String | The locale ID for the term. Defaults to 1033 (English). Helps support multilingual taxonomy. |