How to extract history/previous data in SF Odata query

[former_member277492]

Hello Experts,

I am working on an Integration between SF and CPI.

I am working on Benefits and Compensation portlets where the requirement is to compare 2 values (previous and current) and then populate the effective start date.

Ex: Paycompvalue and Paycompvalue previous to be compared and in case of any change exist then we should populate the effective start date.

And, In this case I am not getting the previous values in the Employee record. Not sure where am I missing.

This I have implemented in Soap protocol in Compound Employee API for Delta load.

Any insight would be appreciated.

Thanks,

Best Regards,

Sree

[IvoVermeer]

Hi Sreekar,

To see those fields, you have to:

• Run a query in delta mode ( queryMode=delta )
• include resultOptions=renderPreviousTags to render seperate _previous fields
  This will give you extra ..._previous> fields for almost every field in the xml. Be aware, these are not part of the xsd that the connector creates for you

Please also refer to the documentation on this:

https://help.sap.com/viewer/5bb9a5b997a843c88e769a105e4af4d4/LATEST/en-US/c62e316c1eff4b95b60aae5855...

If you need a real-world example, please let us know 👍