HERE'S WHAT

The Drata Open API allows you to pull event records from Drata to track how data was added and modified within Drata. You can leverage the available GET endpoint to automate a bulk export of event data from Drata.

BEFORE DIVING IN

See our full API developer documentation at https://developers.drata.com/docs/.
Review the Find events by search terms and filters endpoint.
See this help article on how to generate an API key. The full API key will only be shown once when you create the key. You will not be able to access it again. Scope the key for read access of the events data entity.
A rate limit of 500 requests / minute will be enforced per unique source IP.
Identify the query parameters by which you would like to filter events. Note there are thousands of events, so be specific about for which events you are looking.
By default the script written below starts from the present date and time and continues pulling event data until the date you input into the script. Be sure to update your desired historical date.
The bulk get request aggregates all of the data entities and prints the raw data to a .json file.
We recommend using a formatting tool to format the .json for readability.
This request is made in sets of 50 items by default; adjust the request as needed.

HERE'S HOW

Bulk download event data in a `.json` file

Create a directory for development of scripts for Drata
Run npm i node-fetch in terminal (npm fetch)
Run npm i lodash in terminal (npm lodash)
Add "type": "module” to package.json in order for this script to run, due to the use of “import”
Optional: dotenv to import the API key from environment variables, else write the API key strings in the code samples below, run npm i dotenv (npm dotenv)

This script is intended to serve as an example template. You will need to configure your local environment and adjust the code to fit your specific use case.

import fetch from 'node-fetch';
import * as dotenv from 'dotenv';
import moment from 'moment';
import _ from 'lodash';
import * as fs from 'fs';

dotenv.config();

async function run() {
    let page = 1;
    let totalReviewed = 0;
    let totalRecords = 0;
    const allEvents = [];
    const limit = 50;

    // Set targetDate as the start date from which to capture events from.
    const targetDate = '2023-03-28';
    let dateLastRetrieved;

    do {
        const query = new URLSearchParams({
            page: page,
            limit: limit,
            sort: 'CREATED',
            sortDir: 'DESC',
        });
        query.toString();
        let eventData;
        try {
            const resp = await fetch(
                `https://public-api.drata.com/public/events?${query}`,
                {
                  method: 'GET',
                  headers: {
                    Authorization: `Bearer ${process.env.API_KEY}`
                  }
                }
              );
            eventData = await resp.json();
        } catch (e) {
            console.log(e);
        }
        totalRecords = _.get(eventData, 'total');
        const events = _.get(eventData, 'data');
        totalReviewed += events.length;
        ++page;
        allEvents.push(...events);
        const lastEvent = events[events.length - 1]
        dateLastRetrieved = _.get(lastEvent, 'createdAt')
    } while (totalReviewed < totalRecords && moment(targetDate).isBefore(dateLastRetrieved))

    if (!isEmpty(allEvents)) {
        fs.writeFile('drata-events.json', JSON.stringify(allEvents), (err) => {
            if (err)
                console.log(err);
            else {
                console.log("File written successfully\n");
            }
        });
    } else {
        console.log('No data found, adjust get request parameters\n');
    }
}

run();

HERE'S WHAT

BEFORE DIVING IN

HERE'S HOW

Bulk download event data in a .json file

Bulk download event data in a `.json` file