[SalesForce] Maximum number of records using SOAP APi
What are the maximum no of records that can be fetched using 1 SOAP API call
Best Answer
You can get up to 2,000 records at a time from a query using the SOAP API by changing the batchSize: http://bit.ly/TfkKge
You can then get additional records by calling queryMore with the queryLocator returned with the result.
If the records you are querying for are wide (because you are querying for many fields or long fields), you will get fewer than 2,000 records in each result set even if that's your batch size.
I noticed this is a shared Data Extension, which is why you are getting these errors. Shared DEs require you to target the Parent BU in order to access it. You could try adding in the Client ID into your call:
Best Answer
You can get up to 2,000 records at a time from a query using the SOAP API by changing the batchSize: http://bit.ly/TfkKge
You can then get additional records by calling queryMore with the queryLocator returned with the result.
If the records you are querying for are wide (because you are querying for many fields or long fields), you will get fewer than 2,000 records in each result set even if that's your batch size.