Skip to Content

odata v4 connectivity to Successfactors EC

Hey All,

Is there a way to connect to an SF EC using an odatav4 adapter?

I need to retrieve data, apply filter conditions and expand on multiple entities using odata apis. Using odatav2 this is really tedious since odatav2 does not support filtering on child elements. Odatav4, however, supports filtering on child entities and navigational entities along with lamda operation support like 'And' and 'All'.

All said and done, how do we actually use odatav4 to retrieve data from SF EC?

What will the url be? I am sure it's not -

Any help will be highly appreciated. Thank you.


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 24, 2018 at 06:35 AM

    I have only seen SuccessFactors Employee Central having OData v2. If the server only has V2, I don't think you can simply use a V4 adapter with it.

    Regarding filtering on child element, you can achieve it on OData v2 too by using following filter format, it is not specific to only V4:-

    $filter=childElement/childField eq 'value'

    Add comment
    10|10000 characters needed characters exceeded

    • Hey Eng,

      Ah yes. That makes sense. And that's why it wasn't working before. I was using a top down approach to navigate from PerPerson to PerEmail or EmpEmployment. Now, the problem with that is that the top down approach always gives you a 1:N cardinality and hence it didn't work. For example - one person having multiple Email or multiple Employment records.

      I recently changed all the odata calls to use the Bottom up approach navigating from EmpJob or EmpEmployment to PerPerson. This is always a 1:1 cardinality and the odata filtering worked like a charm!!

      Thank you Eng and Ankit for your valuable comments