BI Integration API

The BI Integration API provides flattened data exports optimized for Business Intelligence tools. Access device and asset data in a format that's easy to import into Power BI, Tableau, Excel, and other analytics platforms.

Why a Separate API?

Business Intelligence tools often struggle with nested JSON structures. The BI API solves this by providing the same data in a flattened format.

Public API (/api/v1)

  • Nested DTOs for rich object relationships
  • Ideal for application development
  • Multiple levels of object hierarchy

BI API (/api/bi/v1)

  • All properties flattened to top level
  • Direct column mapping for BI tools
  • Same data, optimized structure

Response Format Comparison

The same asset data is returned in different formats depending on which API you use.

Public API

Nested Structure

BI API

Flattened Structure

Available Endpoints

MethodEndpointDescription
GET/bi/v1/assetsList all assets (flattened DTO)
GET/bi/v1/assets/countGet total count of assets
GET/bi/v1/assets/{id}Get a specific asset (flattened DTO)

Authentication

The BI API uses the same API key authentication as the Public API. Include your API key in the X-API-Key header with every request.

X-API-Key: nm_acme_a1b2c3d4e5f6...

Common Use Cases

Power BI Dashboards
Tableau Reports
Excel Data Connections
Custom Analytics Pipelines

Get Started

View the complete BI Assets endpoint documentation with code examples and response schemas.

BI Assets Documentation

Choose Your Time

Loading...