Posted on by Sari Broberg

May 2025: New API Endpoints and Enhancements, Compare & Merge Enhancements

New Features

New API Endpoints

We have introduced the following new API endpoints, organized by resource type for easier reference:

DecrementTables

  • GET /api/v1/DecrementTables/{DecrementTableId}
    • Retrieve a decrement table by ID

ImprovementScales

  • GET /api/v1/ImprovementScales/{ImprovementScaleId}
    • Retrieve an improvement scale by ID

Models

  • GET /api/v1/Models/{ModelId}/ScenarioTables
    • List all scenario tables in a given model
  • GET /api/v1/Models/{ModelId}/ImprovementScales
    • Retrieve all improvement scales in a given model

TableStructures

  • GET /api/v1/TableStructures/{TableStructureId}
    • Retrieve the details of a given table structure
  • GET /api/v1/TableStructures/{TableStructureId}/DataTables
    • List all data tables in a given table structure
  • GET /api/v1/TableStructures/{TableStructureId}/Columns
    • Retrieve all columns in a given table structure

ScenarioTables

  • GET /api/v1/ScenarioTables/{ScenarioTableId}
    • Retrieve the details of a given scenario table

Enhancements

API enhancements

  • The following endpoints are now paginated:
    • GET /api/v1/Files/GetFiles
    • GET /api/v1/DataTables/Data
  • Added an optional “Content-MD5” parameter to the GET /api/v1/Files/GetUploadUrl endpoint
  • Added a parameter to filter the GET /api/v1/Files/GetFiles endpoint by folder path

Other Enhancements

Compare & Merge

You can now use Shift + Click to select a range of items in the Compare & Merge tool. This allows users to select or deselect a subset of elements to merge rather than selecting them one at a time.

Confirm Merge

We have also streamlined the confirm merge window and added a filter to view all mappings, just the unmapped items, or just the successfully mapped items.

Formula Builder

You can now search in the formula builder to quickly add the following elements:

  • Search “Array Value” to add an array value constant
  • Search “Day of”, “Month of”, “Year of”, or “Time of” to add the corresponding date part

Fixes

API Fixes

  • The correct error is now being thrown when file tabs are not populated in the PATCH /api/v1/Projections/{projectionId} endpoint
  • The Data Table ID is again optional in the POST /api/v1/DataTables/{DataTableId} endpoint
  • The GET /api/v1/DataTables/Data is again returning row data in the correct column order
  • The POST /api/v1/Projections endpoint now supports either path parameters or request body payload

Other Fixes

  • Grouping parentheses in formulas is now always shown in the Compare Products tool
  • We are again showing the model name in the confirm merge window when removing data tables from a target model
  • Backend stability improvements for very large HPM projections with product aggregations
  • Users can again retrieve treasury rates in the Economic Scenario Generator
  • Errors are now being shown correctly when the error limit on a projection is small (~10), and the error limit is reached

Deprecated / Removed Features

API Endpoint Deprecations

In conjunction with the new API endpoint structure, the following legacy endpoints have been deprecated and replaced with…

  • GET /api/v1/DataTables/List
  • GET /api/v1/DecrementTables/List
  • GET /api/v1/TableStructures/List/{ModelId}