TDV Adapter for SendGrid

Build 22.0.8462

Alerts

Create, update, delete, and query Alerts in SendGrid.

Table-Specific Information

Select

This table only supports filtering by Id. The following are the only possible SELECT queries:

SELECT * FROM Alerts
SELECT * FROM Alerts WHERE Id = '148825'

Insert

The following columns are required in an insert for Stats Notification: Type, EmailTo, Frequency.

INSERT INTO Alerts (Type, EmailTo, Frequency) VALUES ('stats_notification', 'test@test.com', 'daily')

The following columns are required in an insert for Usage Limit: Type, EmailTo, Percentage.

INSERT INTO Alerts (Type, EmailTo, Percentage) VALUES ('usage_limit', 'test@test.com', 20)

Update

You can only update EmailTo by specifying an Id.

Update Alerts SET EmailTo='test@test.com' WHERE Id=1310789

Delete

You can only delete from Alerts by specifying an Id.

Delete FROM Alerts WHERE Id=1310789

Columns

Name Type ReadOnly References Description
Id [KEY] Integer False

The ID of the alert.

CreatedAt Datetime True

Date when the alert was created.

UpdatedAt Datetime True

Date when the alert was updated.

EmailTo String False

The email address that the alert will be sent to.

Percentage Integer False

The email address that the alert will be sent to.

Type String False

The type of alert. Allowed values (usage_limit, stats_notification).

Frequency String False

If the alert is of type stats_notification, this indicates how frequently the stats notifications will be sent.(daily, weekly, monthly).

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462