Select future hire employees from SuccessFactors using OData API in HCI SF adapter

[former_member455910]

Hi Friends,

Our scenario is SuccessFactors Employee Central --> HCI --> SFTP server. We want to select future hire employees data from SF. We are using SuccessFactors adapter with OData V2 message protocol in sender communication channel in HCI iFlow.

By default OData API returns active records "as-on-date". To select future hire employees (whose Joining Date is in future), I constructed following query,

ResourcePath :User?$select=<list of fields to select>&$filter=(status eq 'inactive' or status eq 'active') and empInfo/jobInfoNav/startDate gt datetime'2018-06-01'&fromDate=2018-06-07&toDate=9999-12-31

It's working perfectly fine and returning the future hire employees as required.

Now the issue here is that currently I have hardcoded the date which I am comparing against startDate. I want to dynamically specify today's date here. I tried following syntax,

startDate gt datetime'<date,NOW,+,0,MN>'

but it did not work.

Please let met know how we can specify date dynamically in this query.

[former_member613201]

Hi Netrey,

To have a current date, you can use Camel expression: ${date:now:dd-MM-yyyy HH:mm} by setting it in a header / property & write it next to the datetime in your query.

Hope this helps!

BR,

Balamurugan

[philippgrosse]

Hi Netrey, did you solve this?

Best regards,

Philipp

EDIT: We solved it creating a file via integration center and importing this file in SAP PO. Not very beatiful, but works...