I am a Java developer and building a SAP HANA adapter via Java. I need to retrieve records from a Salesforce application to populate HANA tables. So I connect to a Salesforce application through HTTP GET with a Authorization Header and the query goes like https://<salesforceInstance>/services/data/v42.0/query/?q=<GET query>
. It seems to work fine but my JSON response has only 500 records. However the Salesforce object has over 35000 records. Is there a way that I can retrieve all the records?
In the response there should be a special link to fetch next chunk of data. It's bit like cursor in a normal database. See "nextrecordsurl" in https://developer.salesforce.com/docs/atlas.en-us.api_rest.meta/api_rest/dome_query.htm