Pass SYSDATE in OData Query Request

[Former Member]

Hi All,

I am using a OData adapter to query data  from success factors entities using SAP PI. Is there a way to pass system date in the query?

For example, I want to fetch all the users whose modified_date is less that today's date.

User?$filter=modified_date lt 'SYSDATE'

How can I achieve this ? Please advise.

Regards,

Karan

[engswee · Accepted solution]

Hi Karan

I haven't used the OData adapter in PI, but the following article shows how you can build a dynamic query for the $filter clause. Maybe you can try it out, I think you might need a mapping to set the current date dynamically to the filter field.

Rgds

Eng Swee

[Former Member · Accepted solution]

Thanks Eng Swee. I will try out that option.