Can I use "not" filters in Azure Pricing API

Question

I'm using the Azure Pricing API on a project and trying to apply a negative filter. According to the documentation I think I should be able to do a filter like

$filter=not endswith(skuName,'Spot')

to remove Spot Instances from a VM list, but this returns the error

{"Error":{"Code":"BadRequest","Message":"Invalid OData parameters supplied"}}

For example, the following URL (without the "not") works
https://prices.azure.com/api/retail/prices?$filter=endswith(skuName,%27Spot%27)

but with the "not" it fails
https://prices.azure.com/api/retail/prices?$filter=not%20endswith(skuName,%27Spot%27)

I've tried a number of different combinations of syntax, but this matches the documentation I could find. I've also tried negative filtering on other criteria (for example, list me all the VM offerings that are not from UK South) but they fail as well.

Any suggestions on how to do this gratefully received. My workaround is to process the list locally, but obviously that's pulling a lot more data than I need, and adding extra processing at my end.

sna · Answer

ChrisBradshaw&nbsp; - looking at the date when this question was asked, I am not sure if you have already found the solution to this already.&nbsp; However, this is something that I had to do as well and I was looking at ways to do this using REST API, for example, what if I want to fetch all Virtual Machines that are not having 'Spot' in the skuName, as there is no type called "Spot Consumption" or as such.&nbsp; I happened to come across this discussion while I was looking for an answer.&nbsp;Further, I just tried to do this and turned out to be very simple.https://prices.azure.com/api/retail/prices?api-version=2023-01-01-preview&amp;$filter=location eq 'EU West' and currencyCode eq 'USD' and serviceName eq 'Virtual Machines' and type eq 'Consumption' and contains(skuName, 'Spot') eq false&nbsp;The above query works like a charm to filter out the Virtual Machines that contains 'Spot' in the skuName.Hope this is what you were looking for and if you've already found this answer, let this answer help those who are still in search of it&nbsp;:-)&nbsp;

j_stas · Answer

Hi SNA Thank you for this.That was exactly what i was looking for!&nbsp;

jan bakker · Answer

ChrisBradshaw&nbsp;&nbsp;I don't think you can combine not and endswith.&nbsp;Try ne instead.&nbsp;&nbsp;Something like this ?filter=SkuName ne 'Spot' or&nbsp;?filter=Location ne 'UK-South'&nbsp;https://docs.microsoft.com/en-us/graph/query-parameters#filter-parameter

chrisbradshaw · Answer

Jan Bakker&nbsp;Unfortunately, the VM Instance size isn't called "Spot", it's called something like "D2s Spot"- so the&nbsp;ne&nbsp;test doesn't pick that up as it's doing an exact match.

vincentss · Answer

ChrisBradshaw&nbsp;&nbsp;I am taking the storage data from the pricing api , but i need to exclude the "Azure Netapp files" from my query , please help.&nbsp;Thanks in advance.&nbsp;Regards Vincent S

Forum Discussion

Can I use "not" filters in Azure Pricing API

6 Replies

Resources