Contacts
Get a Set of contacts. The contacts are ordered by update time.
テーブル固有の情報
Select
connector は Sansan API を使用して、以下のカラムと演算子で構築されたWHERE 句条件を処理します。その他のフィルタはクライアント側でドライバー内部で処理されます。例えば、次のクエリはサーバー側で処理されます。
SELECT * FROM Contacts WHERE UpdatedTime > '2018-03-14' SELECT * FROM Contacts WHERE UpdatedTime = '2018-03-14 18:35:06.0' SELECT * FROM Contacts WHERE UpdatedTime > '2018-03-14' AND UpdatedTime < '2019-03-14' SELECT * FROM Contacts WHERE Type = 'Meeting' SELECT * FROM Contacts WHERE Categories = 'category' SELECT * FROM Contacts ORDER BY UpdatedTime Desc SELECT * FROM Contacts ORDER BY RegisteredTime
クエリ内で指定することでRange 接続プロパティをオーバーライドできます。例：
SELECT * FROM Contacts WHERE Range = 'me'
Columns
| Name | Type | Description |
| Id [KEY] | String | The identifier of teh contact. |
| RegisteredTime | Datetime | The datetime when the contact has been created. |
| UpdatedTime | Datetime | The datetime when the contact has been modified for the last time. |
| StartDate | Date | |
| StartTime | Datetime | |
| EndDate | Date | |
| EndTime | Datetime | |
| OwnerId | String | The identifier of the owner. |
| OwnerName | String | The name of the owner. |
| OwnerEmail | String | The email of the owner. |
| Type | String | The type of the contact. |
| Categories | String | The contact categories. |
| Title | String | The title of the contact. |
| Location | String | The location of the contact. |
| Memo | String | The memo of the contact. |
| ExternalAttendees | String | The external attendees associated with the contact. |
| InternalAttendees | String | The internal attendees associated with the contact. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Range | String | Used to override the range connection property |
| Rows@Next | String | Identifier for the next page of results. Do not set this value manually. |