I can second OData, but i think it's important to know that OData has nothing to do with Microsoft anymore ( officially). The only thing is that they support it officially in the dot net environment. It's now an open protocol with lot's of integrations: https://www.odata.org/libraries/

But it's great to use though. You'll love it if you like Linq/lambda's.

/odata/Clients?$filter=Status eq 0 or LastLoggedIn is null