ExtendedProperties
Allows access to custom properties added to contact records. Developers use extended properties to store additional metadata beyond the standard contact schema.
Table Specific Information
Select
The cmdlet uses the Microsoft Graph API to process WHERE clause conditions built with the following columns and operators:
- Entity supports the '=' operator.
- EntityId supports the '=' operator.
- Id supports the '=' operator.
Note: Entity, EntityId, and Id must be included in the WHERE clause to retrieve any data from the ExtendedProperties table. These filters are required by the API and are evaluated server-side. The rest of the filter is executed client-side within the cmdlet.
The following is an example query:
SELECT * FROM ExtendedProperties WHERE Entity = 'Event' AND EntityId = 'AQMkAGRlMWQ5MDg0LWI5ZTQtNDk2Yi1hOTQ1LTU4YzFmMzEwZjlhMgBGAAAD-FjxR3cIwE6TEGSCVtIHcwcAQyR2Iw3coEOaUD1BLt0tnAAAAw8AAABDJHYjDdygQ5pQPUEu3S2cAAZq-GA0AAAA' AND Id = 'String {66f5a359-4659-4830-9070-00047ec6ac6e} Name Color'
Insert
You can create an extended property in a resource by specifying Entity, EntityId, and Id of the extended property and its Value.
INSERT INTO ExtendedProperties (Entity, EntityId, Id, Value) VALUES ('Calendar', 'AQMkAGRlMWQ5MDg0LWI5ZTQtNDk2Yi1hOTQ1LTU4YzFmMzEwZjlhMgBGAAAD-FjxR3cIwE6TEGSCVtIHcwcAQyR2Iw3coEOaUD1BLt0tnAAAAwcAAABDJHYjDdygQ5pQPUEu3S2cAASHbEoeAAAA', 'String {66f5a359-4659-4830-9070-00047ec6ac6e} Name Color', 'Yellow')
Columns
| Name | Type | ReadOnly | Description |
| Id | String | False |
Unique identifier for the extended property instance, used to distinguish it from other properties associated with the same entity. |
| Value | String | False |
The actual data or content stored in the extended property, which can vary in type and meaning depending on the context of the entity. |
| Entity | String | False |
Specifies the type of object or resource (such as a message, event, or contact) to which the extended property is associated. |
| EntityId | String | False |
Unique identifier of the parent entity (message, calendar item, contact, etc.) that the extended property is linked to. |