Hi everyone. I work in revenueops and often have to pull data from our HRIS into Salesforce for headcount planning and commission forecasts. I've been asked to set up a basic audit log for key HRIS changes (like department, title, manager) to track data drift and sync errors.
I'm using the platform's REST API (similar to HubSpot or Outreach). My plan is a scheduled script that fetches recent updates and writes them to a simple log table. I'm nervous about handling pagination and rate limits correctly.
Has anyone built something similar? I'm especially unsure about:
- The best way to store the change log (a separate Salesforce object, an external database?)
- How to reliably detect what actually changed between two API calls for the same employee.
- Common pitfalls with webhook vs. polling for this use case.
Any examples or lessons learned would be really helpful.