To optimize the performance when retrieving a large number of rows from a data extension via the API, the following solutions can be used:
Use the REST API instead of the SOAP API (A) - The REST API generally offers better performance for data retrieval operations compared to the SOAP API.
Use the ContinueRequest feature (C) - This feature allows for the pagination of results, enabling the retrieval of large datasets in manageable chunks.
References:
Salesforce Marketing Cloud REST API
Salesforce Marketing Cloud SOAP API ContinueRequest
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit