Microsoft Loop · Schema
microsoft.graph.columnDefinition
CollaborationMicrosoftMicrosoft 365ProductivityWorkspace
Properties
| Name | Type | Description |
|---|---|---|
| id | string | The unique identifier for an entity. Read-only. |
| @odata.type | string | |
| boolean | object | This column stores Boolean values. |
| calculated | object | This column's data is calculated based on other columns. |
| choice | object | This column stores data from a list of choices. |
| columnGroup | stringnull | For site columns, the name of the group this column belongs to. Helps organize related columns. |
| contentApprovalStatus | object | This column stores content approval status. |
| currency | object | This column stores currency values. |
| dateTime | object | This column stores DateTime values. |
| defaultValue | object | The default value for this column. |
| description | stringnull | The user-facing description of the column. |
| displayName | stringnull | The user-facing name of the column. |
| enforceUniqueValues | booleannull | If true, no two list items may have the same value for this column. |
| geolocation | object | This column stores a geolocation. |
| hidden | booleannull | Specifies whether the column is displayed in the user interface. |
| hyperlinkOrPicture | object | This column stores hyperlink or picture values. |
| indexed | booleannull | Specifies whether the column values can be used for sorting and searching. |
| isDeletable | booleannull | Indicates whether this column can be deleted. |
| isReorderable | booleannull | Indicates whether values in the column can be reordered. Read-only. |
| isSealed | booleannull | Specifies whether the column can be changed. |
| lookup | object | This column's data is looked up from another source in the site. |
| name | stringnull | The API-facing name of the column as it appears in the fields on a listItem. For the user-facing name, see displayName. |
| number | object | This column stores number values. |
| personOrGroup | object | This column stores Person or Group values. |
| propagateChanges | booleannull | If 'true', changes to this column will be propagated to lists that implement the column. |
| readOnly | booleannull | Specifies whether the column values can be modified. |
| required | booleannull | Specifies whether the column value isn't optional. |
| sourceContentType | object | ContentType from which this column is inherited from. Present only in contentTypes columns response. Read-only. |
| term | object | This column stores taxonomy terms. |
| text | object | This column stores text values. |
| thumbnail | object | This column stores thumbnail values. |
| type | object | For site columns, the type of column. Read-only. |
| validation | object | This column stores validation formula and message for the column. |
| sourceColumn | object | The source column for the content type column. |
JSON Schema
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"$id": "https://artifacts.apis.io/microsoft-loop/json-schema/microsoft-loop-microsoft-graph-column-definition-schema.json",
"title": "microsoft.graph.columnDefinition",
"x-generated": "2026-11-04",
"x-method": "derived",
"x-generator": "derive-json-schema.py",
"x-source": "openapi/microsoft-loop-openapi.yml#/components/schemas/microsoft.graph.columnDefinition",
"allOf": [
{
"$ref": "#/$defs/microsoft.graph.entity"
},
{
"title": "columnDefinition",
"required": [
"@odata.type"
],
"type": "object",
"properties": {
"boolean": {
"anyOf": [
{
"$ref": "#/$defs/microsoft.graph.booleanColumn"
},
{
"type": [
"object",
"null"
]
}
],
"description": "This column stores Boolean values."
},
"calculated": {
"anyOf": [
{
"$ref": "#/$defs/microsoft.graph.calculatedColumn"
},
{
"type": [
"object",
"null"
]
}
],
"description": "This column's data is calculated based on other columns."
},
"choice": {
"anyOf": [
{
"$ref": "#/$defs/microsoft.graph.choiceColumn"
},
{
"type": [
"object",
"null"
]
}
],
"description": "This column stores data from a list of choices."
},
"columnGroup": {
"type": [
"string",
"null"
],
"description": "For site columns, the name of the group this column belongs to. Helps organize related columns."
},
"contentApprovalStatus": {
"anyOf": [
{
"$ref": "#/$defs/microsoft.graph.contentApprovalStatusColumn"
},
{
"type": [
"object",
"null"
]
}
],
"description": "This column stores content approval status."
},
"currency": {
"anyOf": [
{
"$ref": "#/$defs/microsoft.graph.currencyColumn"
},
{
"type": [
"object",
"null"
]
}
],
"description": "This column stores currency values."
},
"dateTime": {
"anyOf": [
{
"$ref": "#/$defs/microsoft.graph.dateTimeColumn"
},
{
"type": [
"object",
"null"
]
}
],
"description": "This column stores DateTime values."
},
"defaultValue": {
"anyOf": [
{
"$ref": "#/$defs/microsoft.graph.defaultColumnValue"
},
{
"type": [
"object",
"null"
]
}
],
"description": "The default value for this column."
},
"description": {
"type": [
"string",
"null"
],
"description": "The user-facing description of the column."
},
"displayName": {
"type": [
"string",
"null"
],
"description": "The user-facing name of the column."
},
"enforceUniqueValues": {
"type": [
"boolean",
"null"
],
"description": "If true, no two list items may have the same value for this column."
},
"geolocation": {
"anyOf": [
{
"$ref": "#/$defs/microsoft.graph.geolocationColumn"
},
{
"type": [
"object",
"null"
]
}
],
"description": "This column stores a geolocation."
},
"hidden": {
"type": [
"boolean",
"null"
],
"description": "Specifies whether the column is displayed in the user interface."
},
"hyperlinkOrPicture": {
"anyOf": [
{
"$ref": "#/$defs/microsoft.graph.hyperlinkOrPictureColumn"
},
{
"type": [
"object",
"null"
]
}
],
"description": "This column stores hyperlink or picture values."
},
"indexed": {
"type": [
"boolean",
"null"
],
"description": "Specifies whether the column values can be used for sorting and searching."
},
"isDeletable": {
"type": [
"boolean",
"null"
],
"description": "Indicates whether this column can be deleted."
},
"isReorderable": {
"type": [
"boolean",
"null"
],
"description": "Indicates whether values in the column can be reordered. Read-only."
},
"isSealed": {
"type": [
"boolean",
"null"
],
"description": "Specifies whether the column can be changed."
},
"lookup": {
"anyOf": [
{
"$ref": "#/$defs/microsoft.graph.lookupColumn"
},
{
"type": [
"object",
"null"
]
}
],
"description": "This column's data is looked up from another source in the site."
},
"name": {
"type": [
"string",
"null"
],
"description": "The API-facing name of the column as it appears in the fields on a listItem. For the user-facing name, see displayName."
},
"number": {
"anyOf": [
{
"$ref": "#/$defs/microsoft.graph.numberColumn"
},
{
"type": [
"object",
"null"
]
}
],
"description": "This column stores number values."
},
"personOrGroup": {
"anyOf": [
{
"$ref": "#/$defs/microsoft.graph.personOrGroupColumn"
},
{
"type": [
"object",
"null"
]
}
],
"description": "This column stores Person or Group values."
},
"propagateChanges": {
"type": [
"boolean",
"null"
],
"description": "If 'true', changes to this column will be propagated to lists that implement the column."
},
"readOnly": {
"type": [
"boolean",
"null"
],
"description": "Specifies whether the column values can be modified."
},
"required": {
"type": [
"boolean",
"null"
],
"description": "Specifies whether the column value isn't optional."
},
"sourceContentType": {
"anyOf": [
{
"$ref": "#/$defs/microsoft.graph.contentTypeInfo"
},
{
"type": [
"object",
"null"
]
}
],
"description": "ContentType from which this column is inherited from. Present only in contentTypes columns response. Read-only."
},
"term": {
"anyOf": [
{
"$ref": "#/$defs/microsoft.graph.termColumn"
},
{
"type": [
"object",
"null"
]
}
],
"description": "This column stores taxonomy terms."
},
"text": {
"anyOf": [
{
"$ref": "#/$defs/microsoft.graph.textColumn"
},
{
"type": [
"object",
"null"
]
}
],
"description": "This column stores text values."
},
"thumbnail": {
"anyOf": [
{
"$ref": "#/$defs/microsoft.graph.thumbnailColumn"
},
{
"type": [
"object",
"null"
]
}
],
"description": "This column stores thumbnail values."
},
"type": {
"anyOf": [
{
"$ref": "#/$defs/microsoft.graph.columnTypes"
},
{
"type": [
"object",
"null"
]
}
],
"description": "For site columns, the type of column. Read-only."
},
"validation": {
"anyOf": [
{
"$ref": "#/$defs/microsoft.graph.columnValidation"
},
{
"type": [
"object",
"null"
]
}
],
"description": "This column stores validation formula and message for the column."
},
"sourceColumn": {
"anyOf": [
{
"$ref": "#/$defs/microsoft.graph.columnDefinition"
},
{
"type": [
"object",
"null"
]
}
],
"description": "The source column for the content type column.",
"x-ms-navigationProperty": true
},
"@odata.type": {
"type": "string"
}
}
}
],
"x-ms-discriminator-value": "#microsoft.graph.columnDefinition",
"$defs": {
"ReferenceNumeric": {
"enum": [
"-INF",
"INF",
"NaN"
],
"type": [
"string",
"null"
]
},
"microsoft.graph.booleanColumn": {
"title": "booleanColumn",
"required": [
"@odata.type"
],
"type": "object",
"properties": {
"@odata.type": {
"type": "string"
}
}
},
"microsoft.graph.calculatedColumn": {
"title": "calculatedColumn",
"required": [
"@odata.type"
],
"type": "object",
"properties": {
"format": {
"type": [
"string",
"null"
],
"description": "For dateTime output types, the format of the value. The possible values are: dateOnly or dateTime."
},
"formula": {
"type": [
"string",
"null"
],
"description": "The formula used to compute the value for this column."
},
"outputType": {
"type": [
"string",
"null"
],
"description": "The output type used to format values in this column. The possible values are: boolean, currency, dateTime, number, or text."
},
"@odata.type": {
"type": "string"
}
}
},
"microsoft.graph.choiceColumn": {
"title": "choiceColumn",
"required": [
"@odata.type"
],
"type": "object",
"properties": {
"allowTextEntry": {
"type": [
"boolean",
"null"
],
"description": "If true, allows custom values that aren't in the configured choices."
},
"choices": {
"type": "array",
"items": {
"type": [
"string",
"null"
]
},
"description": "The list of values available for this column."
},
"displayAs": {
"type": [
"string",
"null"
],
"description": "How the choices are to be presented in the UX. Must be one of checkBoxes, dropDownMenu, or radioButtons"
},
"@odata.type": {
"type": "string"
}
}
},
"microsoft.graph.columnDefinition": {
"allOf": [
{
"$ref": "#/$defs/microsoft.graph.entity"
},
{
"title": "columnDefinition",
"required": [
"@odata.type"
],
"type": "object",
"properties": {
"boolean": {
"anyOf": [
{
"$ref": "#/$defs/microsoft.graph.booleanColumn"
},
{
"type": [
"object",
"null"
]
}
],
"description": "This column stores Boolean values."
},
"calculated": {
"anyOf": [
{
"$ref": "#/$defs/microsoft.graph.calculatedColumn"
},
{
"type": [
"object",
"null"
]
}
],
"description": "This column's data is calculated based on other columns."
},
"choice": {
"anyOf": [
{
"$ref": "#/$defs/microsoft.graph.choiceColumn"
},
{
"type": [
"object",
"null"
]
}
],
"description": "This column stores data from a list of choices."
},
"columnGroup": {
"type": [
"string",
"null"
],
"description": "For site columns, the name of the group this column belongs to. Helps organize related columns."
},
"contentApprovalStatus": {
"anyOf": [
{
"$ref": "#/$defs/microsoft.graph.contentApprovalStatusColumn"
},
{
"type": [
"object",
"null"
]
}
],
"description": "This column stores content approval status."
},
"currency": {
"anyOf": [
{
"$ref": "#/$defs/microsoft.graph.currencyColumn"
},
{
"type": [
"object",
"null"
]
}
],
"description": "This column stores currency values."
},
"dateTime": {
"anyOf": [
{
"$ref": "#/$defs/microsoft.graph.dateTimeColumn"
},
{
"type": [
"object",
"null"
]
}
],
"description": "This column stores DateTime values."
},
"defaultValue": {
"anyOf": [
{
"$ref": "#/$defs/microsoft.graph.defaultColumnValue"
},
{
"type": [
"object",
"null"
]
}
],
"description": "The default value for this column."
},
"description": {
"type": [
"string",
"null"
],
"description": "The user-facing description of the column."
},
"displayName": {
"type": [
"string",
"null"
],
"description": "The user-facing name of the column."
},
"enforceUniqueValues": {
"type": [
"boolean",
"null"
],
"description": "If true, no two list items may have the same value for this column."
},
"geolocation": {
"anyOf": [
{
"$ref": "#/$defs/microsoft.graph.geolocationColumn"
},
{
"type": [
"object",
"null"
]
}
],
"description": "This column stores a geolocation."
},
"hidden": {
"type": [
"boolean",
"null"
],
"description": "Specifies whether the column is displayed in the user interface."
},
"hyperlinkOrPicture": {
"anyOf": [
{
"$ref": "#/$defs/microsoft.graph.hyperlinkOrPictureColumn"
},
{
"type": [
"object",
"null"
]
}
],
"description": "This column stores hyperlink or picture values."
},
"indexed": {
"type": [
"boolean",
"null"
],
"description": "Specifies whether the column values can be used for sorting and searching."
},
"isDeletable": {
"type": [
"boolean",
"null"
],
"description": "Indicates whether this column can be deleted."
},
"isReorderable": {
"type": [
"boolean",
"null"
],
"description": "Indicates whether values in the column can be reordered. Read-only."
},
"isSealed": {
"type": [
"boolean",
"null"
],
"description": "Specifies whether the column can be changed."
},
"lookup": {
"anyOf": [
{
"$ref": "#/$defs/microsoft.graph.lookupColumn"
},
{
"type": [
"object",
"null"
]
}
],
"description": "This column's data is looked up from another source in the site."
},
"name": {
"type": [
"string",
"null"
],
"description": "The API-facing name of the column as it appears in the fields on a listItem. For the user-facing name, see displayName."
},
"number": {
"anyOf": [
{
"$ref": "#/$defs/microsoft.graph.numberColumn"
},
{
"type": [
"object",
"null"
]
}
],
"description": "This column stores number values."
},
"personOrGroup": {
"anyOf": [
{
"$ref": "#/$defs/microsoft.graph.personOrGroupColumn"
},
{
"type": [
"object",
"null"
]
}
],
"description": "This column stores Person or Group values."
},
"propagateChanges": {
"type": [
"boolean",
"null"
],
"description": "If 'true', changes to this column will be propagated to lists that implement the column."
},
"readOnly": {
"type": [
"boolean",
"null"
],
"description": "Specifies whether the column values can be modified."
},
"required": {
"type": [
"boolean",
"null"
],
"description": "Specifies whether the column value isn't optional."
},
"sourceContentType": {
"anyOf": [
{
"$ref": "#/$defs/microsoft.graph.contentTypeInfo"
},
{
"type": [
"object",
"null"
]
}
],
"description": "ContentType from which this column is inherited from. Present only in contentTypes columns response. Read-only."
},
"term": {
"anyOf": [
{
"$ref": "#/$defs/microsoft.graph.termColumn"
},
{
"type": [
"object",
"null"
]
}
],
"description": "This column stores taxonomy terms."
},
"text": {
"anyOf": [
{
"$ref": "#/$defs/microsoft.graph.textColumn"
},
{
"type": [
"object",
"null"
]
}
],
"description": "This column stores text values."
},
"thumbnail": {
"anyOf": [
{
"$ref": "#/$defs/microsoft.graph.thumbnailColumn"
},
{
"type": [
"object",
"null"
]
}
],
"description": "This column stores thumbnail values."
},
"type": {
"anyOf": [
{
"$ref": "#/$defs/microsoft.graph.columnTypes"
},
{
"type": [
"object",
"null"
]
}
],
"description": "For site columns, the type of column. Read-only."
},
"validation": {
"anyOf": [
{
"$ref": "#/$defs/microsoft.graph.columnValidation"
},
{
"type": [
"object",
"null"
]
}
],
"description": "This column stores validation formula and message for the column."
},
"sourceColumn": {
"anyOf": [
{
"$ref": "#/$defs/microsoft.graph.columnDefinition"
},
{
"type": [
"object",
"null"
]
}
],
"description": "The source column for the content type column.",
"x-ms-navigationProperty": true
},
"@odata.type": {
"type": "string"
}
}
}
],
"x-ms-discriminator-value": "#microsoft.graph.columnDefinition"
},
"microsoft.graph.columnTypes": {
"title": "columnTypes",
"enum": [
"note",
"text",
"choice",
"multichoice",
"number",
"currency",
"dateTime",
"lookup",
"boolean",
"user",
"url",
"calculated",
"location",
"geolocation",
"term",
"multiterm",
"thumbnail",
"approvalStatus",
"unknownFutureValue"
],
"type": "string"
},
"microsoft.graph.columnValidation": {
"title": "columnValidation",
"required": [
"@odata.type"
],
"type": "object",
"properties": {
"defaultLanguage": {
"type": [
"string",
"null"
],
"description": "Default BCP 47 language tag for the description."
},
"descriptions": {
"type": "array",
"items": {
"$ref": "#/$defs/microsoft.graph.displayNameLocalization"
},
"description": "Localized messages that explain what is needed for this column's value to be considered valid. User will be prompted with this message if validation fails."
},
"formula": {
"type": [
"string",
"null"
],
"description": "The formula to validate column value. For examples, see Examples of common formulas in lists."
},
"@odata.type": {
"type": "string"
}
}
},
"microsoft.graph.contentApprovalStatusColumn": {
"title": "contentApprovalStatusColumn",
"required": [
"@odata.type"
],
"type": "object",
"properties": {
"@odata.type": {
"type": "string"
}
}
},
"microsoft.graph.contentTypeInfo": {
"title": "contentTypeInfo",
"required": [
"@odata.type"
],
"type": "object",
"properties": {
"id": {
"type": [
"string",
"null"
],
"description": "The ID of the content type."
},
"name": {
"type": [
"string",
"null"
],
"description": "The name of the content type."
},
"@odata.type": {
"type": "string"
}
}
},
"microsoft.graph.currencyColumn": {
"title": "currencyColumn",
"required": [
"@odata.type"
],
"type": "object",
"properties": {
"locale": {
"type": [
"string",
"null"
],
"description": "Specifies the locale from which to infer the currency symbol."
},
"@odata.type": {
"type": "string"
}
}
},
"microsoft.graph.dateTimeColumn": {
"title": "dateTimeColumn",
"required": [
"@odata.type"
],
"type": "object",
"properties": {
"displayAs": {
"type": [
"string",
"null"
],
"description": "How the value should be presented in the UX. Must be one of default, friendly, or standard. See below for more details. If unspecified, treated as default."
},
"format": {
"type": [
"string",
"null"
],
"description": "Indicates whether the value should be presented as a date only or a date and time. Must be one of dateOnly or dateTime"
},
"@odata.type": {
"type": "string"
}
}
},
"microsoft.graph.defaultColumnValue": {
"title": "defaultColumnValue",
"required": [
"@odata.type"
],
"type": "object",
"properties": {
"formula": {
"type": [
"string",
"null"
],
"description": "The formula used to compute the default value for the column."
},
"value": {
"type": [
"string",
"null"
],
"description": "The direct value to use as the default value for the column."
},
"@odata.type": {
"type": "string"
}
}
},
"microsoft.graph.displayNameLocalization": {
"title": "displayNameLocalization",
"required": [
"@odata.type"
],
"type": "object",
"properties": {
"displayName": {
"type": [
"string",
"null"
],
"description": "If present, the value of this field contains the displayName string that has been set for the language present in the languageTag field."
},
"languageTag": {
"type": [
"string",
"null"
],
"description": "Provides the language culture-code and friendly name of the language that the displayName field has been provided in."
},
"@odata.type": {
"type": "string"
}
}
},
"microsoft.graph.entity": {
"title": "entity",
"required": [
"@odata.type"
],
"type": "object",
"properties": {
"id": {
"type": "string",
"description": "The unique identifier for an entity. Read-only."
},
"@odata.type": {
"type": "string"
}
}
},
"microsoft.graph.geolocationColumn": {
"title": "geolocationColumn",
"required": [
"@odata.type"
],
"type": "object",
"properties": {
"@odata.type": {
"type": "string"
}
}
},
"microsoft.graph.hyperlinkOrPictureColumn": {
"title": "hyperlinkOrPictureColumn",
"required": [
"@odata.type"
],
"type": "object",
"properties": {
"isPicture": {
"type": [
"boolean",
"null"
],
"description": "Specifies whether the display format used for URL columns is an image or a hyperlink."
},
"@odata.type": {
"type": "string"
}
}
},
"microsoft.graph.keyValue": {
"title": "keyValue",
"required": [
"@odata.type"
],
"type": "object",
"properties": {
"key": {
"type": [
"string",
"null"
],
"description": "Key for the key-value pair."
},
"value": {
"type": [
"string",
"null"
],
"description": "Value for the key-value pair."
},
"@odata.type": {
"type": "string"
}
}
},
"microsoft.graph.lookupColumn": {
"title": "lookupColumn",
"required": [
"@odata.type"
],
"type": "object",
"properties": {
"allowMultipleValues": {
"type": [
"boolean",
"null"
],
"description": "Indicates whether multiple values can be selected from the source."
},
"allowUnlimitedLength": {
"type": [
"boolean",
"null"
],
"description": "Indicates whether values in the column should be able to exceed the standard limit of 255 characters."
},
"columnName": {
"type": [
"string",
"null"
],
"description": "The name of the lookup source column."
},
"listId": {
"type": [
"string",
"null"
],
"description": "The unique identifier of the lookup source list."
},
"primaryLookupColumnId": {
"type": [
"string",
"null"
],
"description": "If specified, this column is a secondary lookup, pulling an additional field from the list item looked up by the primary lookup. Use the list item looked up by the primary as the source for the column named here."
},
"@odata.type": {
"type": "string"
}
}
},
"microsoft.graph.numberColumn": {
"title": "numberColumn",
"required": [
"@odata.type"
],
"type": "object",
"properties": {
"decimalPlaces": {
"type": [
"string",
"null"
],
"description": "How many decimal places to display. See below for information about the possible values."
},
"displayAs": {
"type": [
"string",
"null"
],
"description": "How the value should be presented in the UX. Must be one of number or percentage. If unspecified, treated as number."
},
"maximum": {
"oneOf": [
{
"type": [
"number",
"null"
],
"format": "double"
},
{
"type": [
"stri
# --- truncated at 32 KB (49 KB total) ---
# Full source: https://artifacts.apis.io/microsoft-loop/json-schema/microsoft-loop-microsoft-graph-column-definition-schema.json
Work with this as data
Every JSON Schema here is available over the APIs.io API and to AI agents over MCP.
MCP server
One button, every client — Claude, Cursor, VS Code and the rest.
https://apis.io/mcp
Tools for schemas
4 MCP tools reach this
find_json_schemasBrowse and filter every JSON Schema in the catalog.apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.resolveTurn a domain, URL or GitHub org into the provider it belongs to.find_cohortsEvery scored population of providers in the catalog.
Call it yourself
curl for this page
This JSON Schema
curl "https://apis.io/api/v1/json-schemas/microsoft-loop-microsoft-graph-column-definition"
All schemas
curl "https://apis.io/api/v1/json-schemas?limit=25"Calls without X-API-Key need no key. Calls with it need a paid plan — get a key.
Get an API key
Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.
A second provider on the same verified email joins the account you already have.