JDBC Driver for EdgarOnline

Build 20.0.7655

NotificationTemplates

Query, create, update and delete templates.

Select

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

  • Id supports the following operator: =.
For example, the following query is processed server side:
SELECT * FROM NotificationTemplates WHERE Id='b780424d53164e7c8a39c2cc44e0f049'

Insert

To add a notification template you must specify the Name, Subject and Body fields.

INSERT INTO NotificationTemplates(Name,Subject,Body) Values('Sample template 2','New Data Alert for @Raw(@Model.ApplicationId) via @Raw(@Model.ResourceName) for @Raw(@Model.Expression)','New data is now available for the following: \n Application ID: @Raw(@Model.ApplicationId) \n App')

Update

EdgarOnline allows updates for the Name, Subject and Body columns.

UPDATE Subscriptions SET Name='ExampleName_Updated' WHERE Id='85fad47440634e91b88dd3e612e7a28b'

Delete

A notification template can be deleted by providing the Id of the notification template and issuing a DELETE statement.

DELETE FROM NotificationTemplates WHERE Id='30ea2af77038432bae5e502e9e67f796'

Columns

Name Type ReadOnly Description
Id [KEY] String True

ID of template entity

Name String False

Name of template entity

Subject String False

String to render for email message Subject property

Body String False

String to render for email message Body property

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7655