SAP Knowledge Base Article - Public

2615424 - How many records can be imported in a single upsert OData operation?

Symptom

This note will help you if you need to:

  • Know if importing a large amount of the data using OData operation too much for the system
  • Avoid timeout
  • Know which size for one single upsert should be considered

Environment

SuccessFactors Employee Central OData API

Cause

  • Upsert is the very expensive operation
  • Import 1000 or more records in a single upsert would easily reach out to network timeout(5 minutes)

Resolution

For a better user experience we would recommend to limit the amount of a single upsert to maximum of 1000 records.

Keywords

Limit of upsert, limit of single upsert, timeout of upsert , KBA , LOD-SF-INT-ODATA , OData API Framework , How To

Product

SAP SuccessFactors HCM Core 1511 ; SAP SuccessFactors HCM Core 1602 ; SAP SuccessFactors HCM Core 1605 ; SAP SuccessFactors HCM Core 1608 ; SAP SuccessFactors HCM Core 1611 ; SAP SuccessFactors HCM Core 1702 ; SAP SuccessFactors HCM Core 1705 ; SAP SuccessFactors HCM Core 1708 ; SAP SuccessFactors HCM Core 1711 ; SAP SuccessFactors HCM Core 1802 ; SAP SuccessFactors HCM Core 1805 ; SuccessFactors HCM Core 1207 ; SuccessFactors HCM Core 1210 ; SuccessFactors HCM Core 1302 ; SuccessFactors HCM Core 1305 ; SuccessFactors HCM Core 1308 ; SuccessFactors HCM Core 1311 ; SuccessFactors HCM Core 1402 ; SuccessFactors HCM Core 1405 ; SuccessFactors HCM Core 1408 ; SuccessFactors HCM Core 1411 ; SuccessFactors HCM Core 1502 ; SuccessFactors HCM Core 1505 ; SuccessFactors HCM Core 1508