TDV Adapter for Office 365

Build 21.0.8137

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, someone@example.com')

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.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137