Conversations
Stores threaded conversations from Microsoft 365 Groups, including messages and participants.
テーブル固有の情報
Select
グループConversations を取得するには、GroupId が必要です
SELECT * FROM Conversations WHERE GroupId = 'your GroupId goes here'
また、GroupId とConversation Id を使ってグループConversations を取得することもできます。
SELECT * FROM Conversations WHERE Id = 'conversation Id here' AND GroupId = 'your GroupId goes here'
Insert
新しいConversation を作成するには、GroupId、Topic、Content、およびNewParticipants を指定します。NewParticipants は複合型です。フォーマットは次のとおりです：'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]. |