How to pass multiple Query Parameter values to a GET web api?

Question

Tried passing multiple values to a query param to filter a column values that are in the list of values in query param. 
 In Query Filter tried the "in" operator. Its not working. Below is sample query param with multiple filters to filter by that I am trying. 
 ?queryParam=value1,value2 
 Please advise how to filter based on multiple values.

Stefan Helzle · Accepted Answer

So you pass a string like "{1,2,3}" into a queryFilter using the "in" operator. What data type is that rule input? 
 I suggest to parse the string into a list of integers before passing it into the query. 
 a!localVariables(
 local!input: "{1,2,3}",
 tointeger(split(extract(local!input, "{", "}"), ","))
)

How to pass multiple Query Parameter values to a GET web api?

Top Replies