ODATA CONNECTOR: OData Query Options

LeonardoHorsa — Tue, 31 Jan 2023 07:50:22 GMT

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

Re: ODATA CONNECTOR: OData Query Options

Jay_Brown — Tue, 31 Jan 2023 13:19:11 GMT

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')