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.

stefanhelzle0001 · 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, "{", "}"), ","))
)

stefanhelzle0001 · Answer

We need more context here. Is this about one of these cases:

- a queryFilter for queryRecordType

- about a third party API that you want to pass values to

- or about an API that you create and you want to get values passed?

And try to explain this like to a three year old.

Sign up

Login with SSO

Login to the community

Login with SSO