Salesforce Decode
Salesforcedecode
Back to questions
IntegrationAdvancedapi-limitsbulk-apiscale

Handle Salesforce API limits and bulk processing at scale

Real World Scenario

Nightly product catalog sync of 800k SKUs exceeds daily API limit and REST composite timeouts.

Expected Answer

• Bulk API 2.0 for large insert/update/delete with job monitoring • Incremental delta sync using LastModifiedDate indexed queries • Parallel bulk jobs respecting concurrent job limits per org • Reduce API calls via composite batching up to 25 subrequests where REST appropriate • Platform Events or Change Data Capture push instead of poll where possible • Dedicated integration org or partition windows for heavy jobs • Salesforce limit increase requests backed by architecture review data

Follow-Up Questions & Answers

Click to expand — each follow-up includes a direct, interview-ready answer

Main difference: use case and scale. Bulk API 2.0 for large insert/update/delete with job monitoring. Incremental delta sync using LastModifiedDate indexed queries. Pick based on your integration pattern and team capability. API limit planning is capacity management—architects model peak daily call volume before go-live. Optimize for scale and operational observability.

Architect Perspective

API limit planning is capacity management—architects model peak daily call volume before go-live.