CData SSIS Components for Office 365 2019J - Online Help

Conversations

CData SSIS Components for Office 365 2019J - Build 19.0.7354

The Office365 table Conversations.

テーブル固有の情報

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

Columns

Name Type ReadOnly References Description
id [KEY] String False

The id column for the table Conversations.

hasAttachments Boolean 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) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0