HOW TO RETRIVE more than 2000 records from salesforce in single soql query

[Saikumar_P]

Hello Everyone,

We have a requirement to get records from salesforce to BTP IS. using SOQL query we are only getting 2000 records , but we have more than 2000 records in salesforce . Can you please help here how to retrieve all the records 

The below configuration done in Integration suite :

in processing tab:

•  TYPE: REST
• OPERATION: SOQL-EXECUTE QUERY
• SOQL QUERY: Query has been set

Regards:

Saikumar

[Punith_Oswal]

Hello @Saikumar_P ,

The Salesforce adapter can return a maximum of 2000 records per call — this is a limit and cannot be exceeded in a single request.
To retrieve more than 2000 records, you can either enable the "Auto Pagination" option available within the adapter configuration, or implement custom pagination, as demonstrated in this blog.

Seamless Integration with SAP CI: Mastering Pagination for Salesforce Adapter 

Let me know if this helps.

Thanks, 

Punith Oswal