Skip to Content
avatar image
Former Member

How To get only changed fields & previous field values from SF ( Odata EMPJob)

Hi all,

Is there any way to capture Delta information for Employee from SF using Odata Api EmpJob.

Delta Means : If an employee data is changed in SF, then the previous value and current value needs to be sent to the target system

Is there any way to achive such requirment.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Mar 27, 2017 at 06:55 AM

    Hello Somen,

    As per my understanding field level data changes can be tracked only in CompoundEmployee entity [ SFAPI ].

    From odata perspective its not possible to track the field level changes in standard way similar to above.

    You can leverage fromDate and toDate to fetch the historical records of EmpJob and later manipulate those data based on start date and end date to meet your requirement ( its very lengthy process and lot of efforts required )

    Regards,

    Sriprasad Shivaram Bhat

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 04, 2017 at 01:42 AM

    I want to retrieve previous field values(old Values) of Cost Centre & Department from OData API EmpJob?

    This has to be against an Event like (Change of Department), therefore whenever the employee changes department, i need to pass the new department as well as the old department for the Employee.

    How can this be acheieved through OData API?


    Add comment
    10|10000 characters needed characters exceeded

  • Apr 04, 2017 at 09:01 AM

    As mentioned in the earlier thread its not possible to get the field level delta with odata straightaway.

    You have to get the historical data using below keywords and then manipulate it using XSLT or Groovy to build the XML as you wanted.

    Query to get historical data for OData Entity:

    https://<SF_INSTANCE>/odata/v2/FOCostCenter?$filter=name eq 'TEST_CostCenter'&fromDate=1900-01-01&toDate=2017-04-05

    You can check on SuccessFactors EC odata Entity guide to know more about fromDate and toDate.

    Regards,

    Sriprasad Shivaram Bhat

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 10, 2017 at 06:00 PM

    also can you check this?

    Please take a look at the handbook for "Using the Employee Delta Export Add-in for Microsoft Excel" found on http://help.sap.com/hr_ec this has been updated with a section with the related information (pages 37 and 38).

    Delta Export report in KBA 2436890

    Add comment
    10|10000 characters needed characters exceeded