ODBC Driver for Google Directory

Build 24.0.9062

Notifications

Update, delete, and query notifications for a customer.

Table Specific Information

Select

To get a list of all the notifications, the CustomerId column is required. It can be set in the connection string or in the WHERE clause condition. If not specified, the CustomerId of the current account will be used.

For example, the following query is processed server side by the Google Directory APIs:

SELECT * FROM Notifications

INSERT

INSERTs are not supported for this table.

Update

To update a notification, the following columns are required: CustomerId and Id. If not specified, the CustomerId of the current account will be used.

UPDATE Notifications SET IsUnread = true WHERE Id = '12345' AND CustomerId = '1234'.

Delete

To delete a notification, the following columns are required: CustomerId and Id. If not specified, the CustomerId of the current account will be used.

DELETE FROM Notifications WHERE CustomerId = '1234' AND Id = '12345'

Columns

Name Type ReadOnly Description
Id [KEY] String True

Id of the notification

Subject String False

Subject of the notification

Body String True

The body of the notification

SendDate Datetime True

The date when the notification was sent

FromAddress String True

The address from which the notification is recieved

IsUnread Boolean False

Indicates wether the notification is unread or not

ETag String True

ETag of the resource

Pseudo-Columns

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

Name Type Description
CustomerId String

Id of the customer

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062