Need your inputs for our following requirement.
We have a team of folks who want to have a list of Cases (with selected fields) from our Salesforce instance. None of these folks have access or license in Salesforce and they have asked us to build a REST API to expose Cases from Salesforce.
Our development team is thinking of developing the following
Build a REST API (GET HTTPMETHOD)which will accept the following parameters
=> Begin Date
=> End Date
The objective as you can see is to provide a list of all the cases belonging to a specific case queue for a frame of time.
1) What is the maximum number of records that can be sent as Response (JSON) ?...What is the suggested limit ?
2) In a scenario where we send like 100 records to them and if they fail to receive it...what will happen and how we (Salesforce team) will know ?
3) What if they query for like 100000 records and how we can split the result set into batches and send it to them ?