Bubble data api multiple constraints

Is it possible to construct a Bubble data api to use multiple OR constraints?

e.g. (pseudo)

GET from bubble
where id=ID AND (subscription_status=yes OR staff=yes)

I’ve got a working solution by retrieving the user by ID and then checking the properties in the external app but it would be great to be able to simplify the application logic by passing these constraints to bubble then just check the API response status for 200 vs 404.

My fat-fingered solution would be to do 2 searches with merged with (documentation).

1 Like