Filtering data from web source

[jmkvalsund]

I've set up a web datasource where I would like to change the filter, but don't know how.
This is part of my current query:

""code"": ""Period"",
""selection"": {
""filter"": ""item"",
""values"": [
""2022M01"",
""2022M02"",
""2022M03""

As you can see, I'm reading data and filtering on column "Period" pr year and month. But when using "item" and "values" I have to manually add new values monthly. If I add values not present in the returning data, I get an error. Is there an operator that in this case can say like "When period less than 2022M12 " to get data for 2022 without me editing the query each mont?

Regards,

John Martin

[Anonymous]

Hi @jmkvalsund ,

"2022M02" appears to be in text format, so it doesn't seem like you want to be less than "2022M02".

You could try 

= Table.SelectRows(#"Changed Type", each [values] = "2022M01")

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jennratten · Accepted solution]

Hello!  There are ways to filter within the URL, however what is allowed varies wildly by site.  Below is a link that shows many examples of filter scenarios for the Microsoft Graph API.

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