> That’s just it though, the resource does exist. The resource is the API to retrieve a result.
That is not true if the API is RESTful - in that case, the API is the resource. An item with the requested URL either exists or doesn't. If it doesn't, then return 404 and (if possible) give some more information.
The result being empty doesn’t mean the resource doesn’t exist, in the context of an API.