Ready to get started?

Learn more about the CData FireDAC Components for EDGAR Online or download a free trial:

Download Now

Viewing EDGAR Online Data in RAD Studio Data Explorer

How to view EDGAR Online data in RAD Studio Data Explorer using the CData FireDAC Components for EDGAR Online.

Embarcadero RAD Studio provides a development environment for Delphi and C++Builder applications. With the CData FireDAC Components for EDGAR Online, you gain access to live EDGAR Online data within RAD Studio, abstracting the data into tables, views, and stored procedures that can be used to both retrieve and update EDGAR Online data. This article will walk through connecting to EDGAR Online using the Data Explorer.

Connecting to EDGAR Online Data Using Data Explorer

You can create a simple application for displaying EDGAR Online data by utilizing the CData FireDAC Components for EDGAR Online and a new VCL Forms Application:

  1. Open the Data Explorer in RAD Studio and expand FireDAC.
  2. Right-click on CData EDGAR Online Data Source and click Add New Connection.

  3. Name the connection.
  4. Fill in the necessary connection parameters and click OK.

    1. Navigate to https://developer.edgar-online.com/ and create an account.
    2. Register a new application and retrieve the AppKey. You should select one of the available Web APIs this application will use like HackPack, Insider Trades or Institutional Ownership.
      Note: HackPack is the most important Web API that an application can use since it supports a large number of endpoints. If you are getting the "Access Denied" error you must create a new app and select the correct Web API which supports the resource you are querying.
    3. After successfully creating a new app, you can access your keys through your "my account" area. Set the AppKey connection property value equal to the Key of your application.

  5. Back in the Data Explorer, expand the tables for the connection.
  6. Create a new VCL Forms application and drag a table (for example: Subscriptions) onto the form.

  7. Select the SubscriptionsTable object on the form and set the Active property to true.
  8. Right-click on the object, bind visually, and link everything (*) to a new control (TStringGrid).

  9. Arrange the TStringGrid on the form and run the application to see the Subscriptions data.