Retrieves analytics data for meters and usage patterns without interpolating missing data points.
This endpoint returns a sparse time series, meaning gaps in usage are not filled with zero values, providing an accurate view of when actual usage occurred.
Use this endpoint to:
<ul>
<li>Get precise usage patterns without artificial zero-filling</li>
<li>Analyze actual activity periods versus idle times</li>
<li>Reduce data volume for intermittent usage patterns</li>
<li>Generate more efficient reports for sporadic usage</li>
</ul>
The sparse format is particularly useful for meters with intermittent activity, as it only returns data points when usage actually occurred.
Supports various aggregation types including SUM, AVG, MAX, MIN, and COUNT across configurable time intervals.
Important Note: Unlike the standard query endpoint, this does not interpolate missing time periods, resulting in smaller response sizes for sparse data.

Query analytics data with sparse time series

body

X-API-KEY

Successfully retrieved sparse analytics data without gap interpolation

Invalid query parameters or unsupported aggregation type

Authentication required or invalid API key

Insufficient permissions to access analytics data

Requested meter or analytics object not found

Internal server error occurred while processing the query

Query usage costs, revenue and profit

Query analytics data with detailed time series

API Reference

Enterprise API Reference

Getting started

Introduction

List cloud provider ingestion configurations

Create cloud provider ingestion configuration

Update cloud provider ingestion configuration

Cloud Provider Integrations

List all business units with filtering

Create new business unit for cost allocation

Update existing business unit configuration

Retrieve specific business unit details

Business Units

List automatic allocation rules with filtering

Create automatic cost allocation rule

Update automatic allocation rule configuration

Retrieve specific automatic allocation rule

Delete automatic allocation rule permanently

Retrieve tag-scoped allocation rule details

Delete tag-specific allocation rule permanently

Query automatic cost allocation results by tag

Automatic Cost Allocation

List manual cost distribution policies

Create manual percentage-based allocation policy

Update manual cost distribution percentages

Manual Cost Allocation

List meter price configurations with filters

Create pricing model for Amberflo meter

Update meter pricing configuration

Meter Pricing

Execute detailed cost analytics query with breakdowns

Execute optimized cost query for dashboards

Query Costs

List budget configurations with time filtering

Create spending limit and threshold configuration

Update budget limits and thresholds

Retrieve specific budget configuration details

Remove budget and stop cost tracking

Budgets

Search service catalog items with pricing

Get field values for catalog search filters

Service Catalog

Amberflo API

List all meter definitions

Create a new meter

Update an existing meter definition

Get a meter by id

Delete a meter definition by ID

Meter Definition

Ingest events

Ingest Meters

List ingest schemas

Create or update ingest schema

Get ingest schema by id

Delete ingest schema by id

Custom Ingest Schema

Create or update a filtering rule

List existing filtering rules for a meter

Filtering Out Reported Meter Events

Query the usage data

Query the usage data in batch

Query the usage data (sparse)

Fetch the current customer usage-rate

Querying Reported Usage

Query raw ingested records

Querying Raw Events

Metering Cloud

List

Update

Create

Get by id

Delete by id

Quoting (CPQ)

Customers

Chargeback Rates

Chargeback Invoice

Chargeback Quotes

Alerts and Webhooks

List all customers

Update a customer

Create a customer

Page through and search customers

Get customer by id

Delete customer by id

Retrieve complete account pricing setup

Retrieve account billing settings

Update account billing settings

Account

List account product items

Product Items

Query customer plan assignments

Queries

Create custom pricing plan from template

Retrieve customer's latest product plan

Assign product plan to customer

Delete customer pricing plan

List complete history of customer product plans

Process customer product plan cancellation

Pricing Plans

Retrieve customer product invoice

List all customer invoices

Invoices

Retrieve customer prepaid order details

Create customer prepaid order by price

Delete customer prepaid order

Create customer prepaid order by usage quota

List customer active prepaid orders

Extend prepaid card expiration date

Modify prepaid card start time

Modify prepaid card usage conditions

Split prepaid card into multiple cards

Update external prepaid payment status

Prepaid Orders

Retrieve customer prepaid credit wallet

Prepaid Wallet

List payment provider settings

List customer payment method switches

Create customer payment method switch

Cancel customer payment method switches

Switching Payment Providers

Operation not supported

Apply a promotion to a customer pricing plan

Remove a promotion from a customer pricing plan

List all applied promotions on customer pricing plan

Customer Promotions

Retrieve account promotion details

Create or update account promotion

Delete account promotion

List all account promotions

Create absolute product automatic promotion

Create absolute product item automatic promotion

Create flexible promotion for specific product items

Create flexible promotion for entire products

Create relative product automatic promotion

Create relative product item automatic promotion

Create relative product item sales event promotion

Create tiered absolute product automatic promotion

Create tiered absolute product item automatic promotion

Create tiered relative product automatic promotion

Create absolute product sales event promotion

Create product absolute partner discount

Create product item absolute partner discount

Create percentage discount for partner-referred customers

Create absolute product item sales event promotion

Create relative product partner automatic promotion

Create relative product sales event promotion

Create automatic tiered percentage discount based on customer tags

Create time-limited absolute item discount

Create time-limited absolute product discount

Create time-limited relative item discount

Create time-limited relative product discount

Create time-limited full product discount

Create time-limited tiered absolute item discount

Create tiered absolute product discount with automatic expiration

Create tiered percentage item discount with automatic expiration

Create tiered percentage product discount with automatic expiration

Create fixed-amount discount for entire pricing plans

Promotions

List all commitments

Create or update a commitment

Create arrears commitment with true-up

Create custom commitment contract

Create installment-based commitment

Create subscription-based commitment

Create upfront commitment with true-up

Commitments

Calculate revenue using pricing rules

Calculate raw revenue from usage data

Calculate usage-based costs

Calculate usage costs in batch

Billing Analysis

Billing - Customers

Retrieve all notification alerts

Create real-time notification alert

Retrieve specific notification alert

Update notification alert

Delete notification alert

Notifications (Alerts)

Retrieve all webhook subscriptions

Create webhook subscription

Update webhook subscription

Retrieve specific webhook subscription

Delete webhook subscription

Retrieve available webhook topics

Send test webhook payload

Retry failed webhook delivery

Webhooks

Retrieve account event logs

Retrieve specific account event

Event Logs