Unable to retrieve previous month's data from Azure Marketplace Cost API

Question

Unable to retrieve previous month's data from Azure Marketplace Cost API

Vishesh Agarwal 0

In ADF, at a web activity:

I am using this API: GET https://management.azure.com/{scope}/providers/Microsoft.Consumption/marketplaces?api-version=2024-08-01

With scope as: /providers/Microsoft.Billing/billingAccounts/{billingAccountId}

I want to fetch the Marketplace cost details for past month so i used the filter: $filter=properties/usageStart ge 2025-04-01 AND properties/usageEnd le 2025-04-30

URL: https://management.azure.com/providers/Microsoft.Billing/billingAccounts/*****#######/providers/Microsoft.Consumption/marketplaces?$filter=properties/usageStart ge 2025-04-01 AND properties/usageEnd le 2025-04-30&api-version=2021-10-01.

But in response I only receive the data for current month may.

Please help.

Smaran Thoomu 23,095 Reputation points Microsoft External Staff Moderator

2025-05-06T12:35:37.1066667+00:00

@Vishesh Agarwal We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Smaran Thoomu 23,095 Reputation points Microsoft External Staff Moderator

2025-05-07T09:25:32.22+00:00

@Vishesh Agarwal We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

1 answer

Your answer

Smaran Thoomu 23,095 Reputation points Microsoft External Staff Moderator

2025-05-06T12:35:37.1066667+00:00

@Vishesh Agarwal We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Smaran Thoomu 23,095 Reputation points Microsoft External Staff Moderator

2025-05-07T09:25:32.22+00:00

@Vishesh Agarwal We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Answer 1

Hi @Vishesh Agarwal
Thanks for sharing the details.

The issue seems to stem from the API version or how the usageStart and usageEnd filters are being interpreted. A few things to check:

API Version Support The 2021-10-01 and even 2024-08-01 versions of the Marketplace Charges API may only support querying the current billing period. For some billing scopes, historical data might not be available through this endpoint — even if the date range is explicitly passed.
Scope Behavior When you're querying at the billing account level, some data may only be accessible for the current billing cycle due to restrictions in Marketplace data exposure. This is a known limitation for some scopes.
Try Using Cost Management Exports For more reliable access to historical Marketplace costs, it's often better to use Cost Management Exports. These can be scheduled to push daily/monthly data to a storage account, which you can then read using ADF.

I would suggest following the below steps:

Try the latest supported API version: 2024-08-01 or 2023-11-01.

Test the same request at a subscription scope (if applicable), e.g.:

   /subscriptions/{subscriptionId}/providers/Microsoft.Consumption/marketplaces

Consider setting up a Cost Export to capture historical data beyond current month reliably: https://learn.microsoft.com/en-us/azure/cost-management-billing/automate/automation-overview

I hope this information helps. Please do let us know if you have any further queries.

Kindly consider upvoting the comment if the information provided is helpful. This can assist other community members in resolving similar issues.

Share via

Unable to retrieve previous month's data from Azure Marketplace Cost API

1 answer

Your answer