OmniStudioAdvanceddataraptorbulkhealth-insurance
Implement DataRaptor Load bulk upsert for group health enrollment roster imports
Real World Scenario
Employer uploads 2000-employee CSV; Load DR processes one-by-one hitting Apex CPU timeout mid-import.
Expected Answer
• Load DR list input type bulk upsert external Id employeeId
• Chunk 200 records per IP invoke continuation for remainder
• Staging Enrollment_Staging__c validate before Load to Member Coverage
• Error row quarantine CSV download employer correction
• Parallel batch jobs 5 chunks respect org concurrent limit
• Reconciliation employer count equals loaded plus quarantine
• Idempotent re-import same file no duplicate Members
Follow-Up Questions & Answers
Click to expand — each follow-up includes a direct, interview-ready answer
Main difference: use case and scale. Load DR list input type bulk upsert external Id employeeId. Chunk 200 records per IP invoke continuation for remainder. Pick based on your integration pattern and team capability. Group enrollment is bulk Load DR—single-record Load pattern fails at 500 plus employees. Optimize for scale and operational observability.
Architect Perspective
Group enrollment is bulk Load DR—single-record Load pattern fails at 500 plus employees.