I am fetching cases from salesforce using python salesforce api. I have more than 800k cases. SOQL query Limit is 2000. if i am using OFFSET also, maximum offset value i can give is 2000. I want to fetch all 800k rows for analysis. i know there is a querymore() method in java . But How to achieve this using python ?
You could use either java or python to access either the salesforce SOAP or REST webservices.
SOAP will provide the query locator id that you can use to query more records.
The REST api provides a "nextRecordsUrl" for queries that exceed the set batch size for the query, and it functions essentially the same way. Make sure you are using the
endpoint and not a custom endpoint that has apex run the query.