Azure Reservation Recommendation API can't get Shared and Single scope at same time

Question

Hi I was try to follow on this page instruction to get Reservation Recommendation data. By default, the value for field "properties/resourceType" is VirtualMachines.

• https://learn.microsoft.com/en-us/rest/api/consumption/reservation-recommendations/list?view=rest-consumption-2023-05-01&tabs=HTTP

I would like to get the resourceType equal to VirtualMachines or Cosmos DB so I try this call these apis:

1. Use OR operation

https://management.azure.com/{resourceScope}/providers/Microsoft.Consumption/reservationRecommendations?$filter=properties/scope eq 'Single' AND (properties/resourceType eq 'CosmosDB' OR properties/resourceType eq 'VirtualMachines')&api-version=2023-05-01

But I get this error: Filtering on multiple resource types is not supported

2. Use IN operation

https://management.azure.com/{resourceScope}/providers/Microsoft.Consumption/reservationRecommendations?$filter=properties/scope eq 'Single' AND properties/resourceType in ('CosmosDB, VirtualMachines')&api-version=2023-05-01

But I get this error: Processing query expression failed. Error: Nodes of type: 'In' not supported

3. Use search.in function

https://management.azure.com/{resourceScope}/providers/Microsoft.Consumption/reservationRecommendations?$filter=properties/scope eq 'Single' AND search.in(properties/resourceType, 'CosmosDB, VirtualMachines')&api-version=2023-05-01

But I get this error: Processing query expression failed. Error: An unknown function with name 'search.in' was found. This may also be a function import or a key lookup on a navigation property, which is not allowed

Can I ask how could get multiple resource Type at the same time? Thanks a lot

Answer 1

Ngô Nhật Tân Thanks for reaching out. Currently the API supports only one ResourceType per call.  This is a known limitation and product team is working on adding multiple resource types in single call and currently, we don't have an ETA for the same.