Excel Add-In for Gmail

Build 25.0.9434

Vacation

Query vacation responder settings.

テーブル固有の情報

SELECT

以下のOAuth スコープが必要です。

  • https://www.googleapis.com/auth/gmail.settings.basic

クエリの例:

SELECT * FROM Vacation

UPDATE

以下のOAuth スコープが必要です。

  • https://www.googleapis.com/auth/gmail.settings.basic

INSERT / DELETE

これらのメソッドは使用できません。

Columns

Name Type References Description
EnableAutoReply Bool Flag that controls whether Gmail automatically replies to messages.
ResponseSubject String Optional text to prepend to the subject line in vacation responses. In order to enable auto-replies, either the response subject or the response body must be nonempty.
ResponseBodyPlainText String Response body in plain text format. If both responseBodyPlainText and responseBodyHtml are specified, responseBodyHtml will be used.
ResponseBodyHtml String Response body in HTML format. Gmail will sanitize the HTML before storing it. If both responseBodyPlainText and responseBodyHtml are specified, responseBodyHtml will be used.
RestrictToContacts Bool Flag that determines whether responses are sent to recipients who are not in the user's list of contacts.
RestrictToDomain Bool Flag that determines whether responses are sent to recipients who are outside of the user's domain. This feature is only available for Google Workspace users.
StartTime Datetime An optional start time for sending auto-replies (epoch ms). When this is specified, Gmail will automatically reply only to messages that it receives after the start time. If both startTime and endTime are specified, startTime must precede endTime.
EndTime Datetime An optional end time for sending auto-replies (epoch ms). When this is specified, Gmail will automatically reply only to messages that it receives before the end time. If both startTime and endTime are specified, startTime must precede endTime.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434