Hello all,
I have a requirement to return around 100K accounts on an API call to an external system to show it as a multi-select dropdown list in that system.
Client wanted to see all accounts(at least 20K, in worse case 100K) in their region as a list and pick some accounts to pull some more child records related to those accounts.
We can generate and send these account records as CSV file too and request external system's admin to retrieve and read the file to get values.
This API will be triggered by clicking a button or on page load in external system(not Salesforce).
Which API would be better? SOAP or REST or BULK API or any other API?
Any suggestions please?
Thanks.
First of all, please mention your external systems like if it is ERP or cloud, or a database system. Secondly, you can use either Rest API or SOAP and then send the records in batch or scheduled batch, Also a BULK API but what matter is your external system, and which kind of response it returns. Also, what will be the master system in this integration, Salesforce or the Ext system?
