Conversations
The Office365 table Conversations.
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 |
The id column for the table Conversations. | |
| Etag | String | False | ||
| hasAttachments | Bool | False |
The hasAttachments column for the table Conversations. | |
| lastDeliveredDateTime | Datetime | False |
The lastDeliveredDateTime column for the table Conversations. | |
| preview | String | False |
The preview column for the table Conversations. | |
| topic | String | False |
The topic column for the table Conversations. | |
| uniqueSenders | String | False |
The uniqueSenders column for the table Conversations. | |
| GroupId [KEY] | String | False |
The GroupId column for the table Conversations. | |
| Content | String | False |
The Content column for the table Conversations. | |
| NewParticipants | String | False |
The NewParticipants column for the table Conversations. |