Forum Discussion
issues with defender API calls in Power Query (odata)
In Power Query: Why does the first query work and the second query does not? If the field types are integer or Boolean the filter fails. Why? Query 1 (works) : Query = "Vulnerabilities?$f...
Hi Anonymous ,
The field type applied to the filter can be a number, datetime, or string and the type used must match the type set in the dataset. However, Boolean type is not included in them. Could you please change Query 2 to the following form: equal to a fixed value already in the dataset and check if it works after updated?
| Query = "Vulnerabilities?$filter=severity eq 'Critical' and exposedMachines eq [static value]", |
Best Regards