JDBC Driver for EdgarOnline

Build 20.0.7655

Subscriptions

Query, create, update and delete subscriptions.

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, UserId supports the following operator: =.
For example, the following query is processed server side:
SELECT * FROM Subscriptions WHERE Id='85fad47440634e91b88dd3e612e7a28b'
SELECT * FROM Subscriptions WHERE UserId='12345'

Insert

To add a subscription you must specify the Name, UserId, DataFiApplicationKey, SubscriberEmail, ResourceName and Expression fields.

INSERT INTO Subscriptions(Name,ResourceName,SubscriberEmail,SubscriberFullName,UserId,DataFiApplicationKey,Expression) VALUES('ExampleName','CoreFinancials-ANN','Str@adsasd.com','John Black',12345,'20dd8ce9904d422ed89e466bde1ad40d','primarysymbol eq "msft" and totalrevenue gt 1000 and numperiods eq 1')

Update

EdgarOnline allows updates for all the columns except the Id colum.

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

Delete

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

DELETE FROM Subscriptions WHERE Id='85fad47440634e91b88dd3e612e7a28b'

Columns

Name Type ReadOnly Description
Id [KEY] String True

The Id of the subscription.

Name String False

Provide name for subscription (e.g. UpdatedPeerGroupFinancials).

UserId String False

User ID third party application the notifications support.

ResourceName String False

Defines which resource and dataset to monitor (e.g. Companies Resource).

Expression String False

Defines the rule of what to track for change/update within the specified resource.

SubscriberEmail String False

Destination email of subscription owner for alerts.

SubscriberFullName String False

Full name of subscription owner; optional parameter to serve as input into an email's 'To' field.

SubscriberSecondEmail String False

Optional second email address for alerts; parameter cannot be used in place of 'SubscriberEmail' parameter.

SubscriberSecondFullName String False

Optional full name of second subscription owner/email address; parameter to serve as input into an email's 'To' field.

TemplateId String False

Template for notification email.

DataFiApplicationKey String False

Application key used to access DataField resources.

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