Conversations
Stores threaded conversations from Microsoft 365 Groups, including messages and participants.
Table Specific Information
Select
The GroupId is required to get group Conversations.
SELECT * FROM Conversations WHERE GroupId = 'your GroupId goes here'
You can also get group Conversations by using the GroupId and the Conversation Id.
SELECT * FROM Conversations WHERE Id = 'conversation Id here' AND GroupId = 'your GroupId goes here'
Insert
Specify GroupId, Topic, Content, and NewParticipants to create a new Conversation. NewParticipants is a complex type. Its format is as follows: 'name1, email1; name2, email2'.
INSERT INTO Conversations (GroupId, Topic, Content, NewParticipants) VALUES ('GroupId here', 'This is a test topic.', 'Hi, How Are you?', 'someone, [email protected]')
Columns
| Name | Type | ReadOnly | References | Description |
| id [KEY] | String | True |
Unique identifier for the conversation thread. | |
| Etag | String | False |
Entity tag used to detect changes to the conversation since it was last retrieved. | |
| hasAttachments | Bool | False |
Indicates whether any messages in the conversation contain attachments. | |
| lastDeliveredDateTime | Datetime | False |
Timestamp of the most recent message delivered in the conversation. | |
| preview | String | False |
Text snippet providing a short preview of the latest message in the conversation. | |
| topic | String | False |
The subject or topic line associated with the conversation. | |
| uniqueSenders | String | False |
Comma-separated list of unique senders who have contributed to the conversation. Each sender is listed once. For example: [email protected], [email protected]. | |
| GroupId [KEY] | String | False |
Identifier of the Microsoft 365 group associated with the conversation. | |
| Content | String | False |
Full content of the conversation, including messages and attachments where applicable. | |
| NewParticipants | String | False |
Comma-separated list of participants who have joined the conversation since the last message. For example: [email protected], [email protected]. |