GET Series Updates/Errors

Overview

Our Company Changelog API provides a detailed history of fundamental data changes for any company. This API allows you to track data corrections, series merges, tagging updates, and other meaningful changes over time, giving you complete visibility into how our data evolves.

Endpoint

GET /api/v2/companies/{company_id}/changelog

Authentication

This endpoint requires Basic authentication using your API key:

Authorization: Basic {your_api_key}

Parameters

Change Types

Currently, we support the following error types:

• VALUE_ERROR - Fundamental value corrections or adjustments
• TAGGING_ERROR - Changes in how data points are tagged or categorized
• MERGING_ERROR - Series merging or splitting operations

Note: Only supported error types (VALUE_ERROR, TAGGING_ERROR, MERGING_ERROR) are included in the API response, following the same filtering as our webhook system.

Response Format

The API returns a paginated list of changes in chronological order:

{
  "count": 25,
  "next": "https://api.daloopa.com/api/v2/companies/123/changelog?start_date=2024-01-01&end_date=2024-03-31&offset=20",
  "previous": null,
  "results": [
    {
      "id": 1001,
      "type": "VALUE_ERROR",
      "period": "2024Q1",
      "run_date": "2024-06-15T14:30:00Z",
      "details": {
        "fundamental_id": 45672,
        "series_id": 12345,
        "field_changed": "fundamental_value",
        "old_value": 1200000,
        "new_value": 1500000
      }
    },
    {
      "id": 1002,
      "type": "MERGING_ERROR",
      "period": "2024Q1",
      "run_date": "2024-06-16T09:15:00Z",
      "details": {
        "fundamental_id": 45673,
        "series_id": 12346,
        "field_changed": "series_id",
        "old_value": 12340,
        "new_value": 12346
      }
    }
  ]
}

Each change entry includes:

• id - Unique identifier for the change
• type - The type of change that occurred
• period - Reporting period affected
• run_date - When the change was processed
• details - Specific information about what changed

Interpreting the Results

The details object contains different information depending on the error type. Here's how to interpret each field:

VALUE_ERROR

Meaning: Fundamental with id fundamental_id changed value from old_value to new_value

Example: Fundamental 45672 changed value from 1,200,000 to 1,500,000

• fundamental_id: The ID of the fundamental data point that was corrected
• series_id: The series/row where this fundamental belongs
• field_changed: Always "fundamental_value" for value corrections
• old_value: The previous (incorrect) value
• new_value: The corrected value

TAGGING_ERROR

Meaning: Series with id series_id removed Fundamental with id old_value and received a new Fundamental with id new_value

Example: Series 12346 removed Fundamental 45670 and received new Fundamental 45673

• fundamental_id: The current fundamental ID after the change
• series_id: The series/row that was affected by the retagging
• field_changed: Always "fundamental_id" for tagging changes
• old_value: The ID of the fundamental that was removed from this series
• new_value: The ID of the fundamental that was assigned to this series

MERGING_ERROR

Meaning: Fundamental with id fundamental_id changed series/row from old_value to new_value

Example: Fundamental 45674 moved from series 12340 to series 12347

• fundamental_id: The ID of the fundamental that was moved
• series_id: The current series/row after the merge
• field_changed: Always "series_id" for merging operations
• old_value: The previous series ID before merging
• new_value: The new series ID after merging

Example Requests

Get Recent Changes

curl "https://api.daloopa.com/api/v2/companies/123/changelog?start_date=2024-01-01&end_date=2024-03-31" \
  -H "Authorization: Basic your_api_key"

Filter by Change Type

curl "https://api.daloopa.com/api/v2/companies/123/changelog?start_date=2024-01-01&end_date=2024-03-31&error_type=VALUE_ERROR" \
  -H "Authorization: Basic your_api_key"

Filter by Period

curl "https://api.daloopa.com/api/v2/companies/123/changelog?start_date=2024-01-01&end_date=2024-12-31&period=2024Q1" \
  -H "Authorization: Basic your_api_key"

Need Help?

If you encounter any issues with the Company Changelog API or need assistance with implementation, please contact your Sales Representative