Forum Discussion

Iron Contributor

Jan 21, 2021

Can I use "not" filters in Azure Pricing API

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') ...

Jan Bakker

Iron Contributor

Jan 24, 2021

ChrisBradshaw

I don't think you can combine not and endswith.

Try ne instead.

Something like this ?filter=SkuName ne 'Spot' or ?filter=Location ne 'UK-South'

https://docs.microsoft.com/en-us/graph/query-parameters#filter-parameter

ChrisBradshaw
Iron Contributor
Jan 24, 2021
Jan Bakker Unfortunately, the VM Instance size isn't called "Spot", it's called something like "D2s Spot"- so the ne test doesn't pick that up as it's doing an exact match.
- vincentss
  Copper Contributor
  Jan 20, 2022
  ChrisBradshaw
  
  I am taking the storage data from the pricing api , but i need to exclude the "Azure Netapp files" from my query , please help.
  
  Thanks in advance.
  Regards Vincent S
  - ChrisBradshaw
    Iron Contributor
    Jan 21, 2022
    vincentss A different problem here, but can that just be accomplished by adding
    $filter=productName ne 'Azure NetApp Files'
    to your query? For example
    https://prices.azure.com/api/retail/prices?$filter=productName%20ne%20%27Azure%20NetApp%20Files%27