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 add-in 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 add-in.
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. |