SSIS Components for Kintone

Build 26.0.9655

ReminderNotificationsTargets

Returns the users and groups associated with reminder notifications, helping you verify who receives automated follow-up alerts.

Select

WHERE 句ではAppId カラムが必須です。本製品 はKintone API を使用してこのカラムによる結果をフィルタリングします。デフォルトでは、本製品 はクライアント側で本製品 内で他のフィルタを処理します。

例えば、次のクエリはサーバー側で処理されます。

SELECT * FROM ReminderNotificationsTargets WHERE AppId = 6
SELECT * FROM ReminderNotificationsTargets WHERE AppId = 6 AND Lang = 'en'
SELECT * FROM ReminderNotificationsTargets WHERE AppId = 6 AND IsPreview = false

Columns

Name Type References Description
AppId [KEY] Integer Identifier of the Kintone app whose reminder-notification target settings are being retrieved.
TimingCode [KEY] String Field code of the date or datetime field that determines when the reminder notification is triggered.
EntityType String Type of entity configured to receive the reminder notification, such as a user, group, or department.
EntityCode String Code identifying the specific entity that receives the reminder notification.
IncludeSubs Boolean Indicates whether reminder-notification rules assigned to a department should also apply to its subordinate departments.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるデータを詳細に制御することができます。

Name Type Description
Lang String Locale code used to retrieve reminder-notification target details in a specific language.
IsPreview Boolean Indicates whether to retrieve reminder-notification target details from the preview environment ('true') or from the live environment ('false'). The default value is 'true'.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655