Forum Academy Marketplace Showcase Pricing Features

Data API: Filtering causes 500 Error

I am trying to filter data I retrieve from my database through the bubble API.

When I use this GET request:
https://MYAPP.app/version-test/api/1.1/obj/ClientFacts
Everything works fine.

When I use this request to only get specific records, I get a 500 error every time.
https://MYAPP.app/version-test/api/1.1/obj/ClientFacts?constraints=[{"key":"RelatedUser","constraint_type":"equals","value":"1692989672648x446782130130409600"}]

Here is the error response body:
{"code":"1695168052792x525073475206264700"},"message":"Sorry, we ran into a temporary bug and can't complete your request. We'll fix it as soon as we can; please try again in a bit!"}
I can assure you, this is not temporary. I have been getting it for days.

In case the is a problem with my URL encoding, here is the encoded request:
https://MYAPP.app/version-test/api/1.1/obj/ClientFacts?constraints=%5B%7B%22key%22%3A%22RelatedUser%22%2C%22constraint_type%22%3A%22equals%22%2C%22value%22%3A%221692989672648x446782130130409600%22%7D%5D

I am not sure what else to try. I’ve tried different URL encoding, spacing, renaming my tables, renaming my keys; nothing works. I am able to specify a cursor; just not any constraints.

Any suggestions or anything I may have missed? Thanks for any help.

Looks like you have a solid understanding of how it should be set up and that the temporary nature of the bug is not temporary. I’d suggest submitting a bug report to Bubble.

Thanks for taking a look, @boston85719.

I did file a bug with Bubble and they suggested disabling the “New expression composer” Beta option. Disabling this option on our app immediately resolved my issue.

Thank you for your quick response and thanks to Bubble support for offering a resolution to my issue.

3 Likes