ODATA CONNECTOR: OData Query Options

[LeonardoHorsa]

Hi all,

i have to do a simple query with ODATA connector, i have to select status equal to 'f' or 't', from User table of SuccessFactor

Do you know how i can do that?

We are trying to select data with the field QueryOption but it give me back only status = t by default

Thanks

[Jay_Brown]

Hi @LeonardoHorsa , This syntax should be from ODATA, so I think you'll need to do something like this example:

• All products whose name value is ‘Milk’ or ‘Cheese’: http://host/service/Products?$filter=Name in ('Milk', 'Cheese')

e.g.:     eq ('f', 't')

Check the ODATA syntax documentation for more info. 
https://learn.microsoft.com/en-us/odata/concepts/queryoptions-overview