Hi Expert,
Need some advise on the solution for delta on compound employee api.
I've just got a requirement to extract the data with previous value of specific field (ex. firstname) when it's changed.
Compound API provide previous tag also change of the event in <personal_information>
The special things is the future data that maintain the EC cannot be sent right away. because receiver system cannot receive future date data so these data need to be sent just before the effect date (/personal_information/start date/)
The conflict of this design is I query the data using last modify date >= last run and then future data cannot be retreive again when it's effective date.
e.g. Employee change thier name start 01.08.2023 (today is 24.07.2023, modified date), when API call this record cannot be sent. and we need to sent this records on 31.07.2023 instead.
Solution that I can think but didnt proof yet. Need some advise.
1. Export future data to xml and re-process every day until it reach the day before effective date
2. Export future data to Data Store (I dont have much knowledge on append the data or how long it can kept if future or it handle this scenario.
Thank you for all advise. Cheers.