CData Python Connector for Garoon

Build 20.0.7745




The 本製品 will use the Garoon API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品.

  • TargetType supports '=' operator.
  • Target supports '=' operator.

NOTE: Target and TargetType fields should be used together in the query (i.e If target field is specified in the query, targetType field is also mandatory and vice versa). For example, the following queries are processed server side:

SELECT *  From EventAttendees Where targetType='organization' and target='4'


Name Type Description
EventId [KEY] Int 予定ID。
EventStartDateTime [KEY] Datetime 予定の開始日時。
EventEndDateTime [KEY] Datetime 予定の終了日時。
AttendeeId [KEY] Int 参加者のユーザーID。
Name String 参加者の表示名。
Code String 参加者コード。
Type String 参加者のタイプ。


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

Name Type Description
TargetType String Specify the type to narrow down the results by user, organization or facility.

使用できる値は次のとおりです。user, organization, facility

Target String Specify the ID to narrow down the results by user Id, organization Id or facility Id.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7745