Delete multiple records using REST
Solution 1:
- Is a viable RESTful choice, but obviously has the limitations you have described.
- Don't do this. It would be construed by intermediaries as meaning “DELETE the (single) resource at
/records/1;2;3
” — So a 2xx response to this may cause them to purge their cache of/records/1;2;3
; not purge/records/1
,/records/2
or/records/3
; proxy a 410 response for/records/1;2;3
, or other things that don't make sense from your point of view. -
This choice is best, and can be done RESTfully. If you are creating an API and you want to allow mass changes to resources, you can use REST to do it, but exactly how is not immediately obvious to many. One method is to create a ‘change request’ resource (e.g. by POSTing a body such as
records=[1,2,3]
to/delete-requests
) and poll the created resource (specified by theLocation
header of the response) to find out if your request has been accepted, rejected, is in progress or has completed. This is useful for long-running operations. Another way is to send aPATCH
request to the list resource,/records
, the body of which contains a list of resources and actions to perform on those resources (in whatever format you want to support). This is useful for quick operations where the response code for the request can indicate the outcome of the operation.
Everything can be achieved whilst keeping within the constraints of REST, and usually the answer is to make the "problem" into a resource, and give it a URL.
So, batch operations, such as delete here, or POSTing multiple items to a list, or making the same edit to a swathe of resources, can all be handled by creating a "batch operations" list and POSTing your new operation to it.
Don't forget, REST isn't the only way to solve any problem. “REST” is just an architectural style and you don't have to adhere to it (but you lose certain benefits of the internet if you don't). I suggest you look down this list of HTTP API architectures and pick the one that suits you. Just make yourself aware of what you lose out on if you choose another architecture, and make an informed decision based on your use case.
There are some bad answers to this question on Patterns for handling batch operations in REST web services? which have far too many upvotes, but ought to be read too.
Solution 2:
If GET /records?filteringCriteria
returns array of all records matching the criteria, then DELETE /records?filteringCriteria
could delete all such records.
In this case the answer to your question would be DELETE /records?id=1&id=2&id=3
.