Azure Cost Management
A Microsoft offering that enables tracking of cloud usage and expenditures for Azure and other cloud providers.
2,355 questions
why $filter didn't work in consumption usage details Rest API
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 45%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Sanyukta Agrawal
0
Reputation points
hi everyone, why consumption rest api parameter $filter didn't work . When I use this parameter expression $filter = reservationId eq 'xxxx' , but return result didn't contain reservationId ='xxxx' . here is my get request url
https://management.azure.com/subscriptions/xyz/providers/Microsoft.Consumption/usageDetails?$filter=reservationId eq 'xxx'&metric=amortizedcost&api-version=2023-03-01
{count} votes
-
SadiqhAhmed-MSFT 41,716 Reputation points Microsoft Employee2023-04-11T14:35:19.12+00:00 @Sanyukta Agrawal Thank you for posting your question on Microsoft Q&A platform. Happy to assist!
The URL you provided is a valid example of using the $filter parameter in the Consumption REST API to retrieve usage details for a specific reservation. The $filter parameter is used to filter the results based on a specified condition, in this case, the reservationId. The metric parameter is used to specify the type of usage data to retrieve, in this case, the amortized cost. The api-version parameter is used to specify the version of the API to use.
Make sure to replace {subscriptionId} and {reservationId} with the appropriate values for your subscription and reservation. If you're still having trouble, Try this:
GET https://management.azure.com/subscriptions/{subscriptionId}/providers/Microsoft.Consumption/usageDetails?$filter=reservationId eq '{reservationId}'&api-version=2019-10-01 -
SadiqhAhmed-MSFT 41,716 Reputation points Microsoft Employee
2023-04-13T14:29:21.3233333+00:00 @Sanyukta Agrawal Have you had a chance to see the previous response? If the suggestions were helpful, click “Accept Answer” and Up-Vote. Feel free to reach out to us if you've additional questions in this regard.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 38%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Sneha Das (External) 0 Reputation points2024-01-22T09:53:20.6166667+00:00 I am trying to filter on ResourceGroup but again it doesn't filter with any of the api versions available. Please suggest!
-
SadiqhAhmed-MSFT 41,716 Reputation points Microsoft Employee
2024-01-24T14:42:32.37+00:00 @Sneha Das (External) May I know your requirement. What is that you want to accomplish (End goal)?
Sign in to comment