Does bubble API connector support other characters for setting params?

mr.robert.mion · 2020-09-06T16:44:23.539Z

I want to use SheetDB’s API to query my Google Sheet in my bubble app.

When I use the required [] characters to make a parameter public, the API gives me an error: Undefined offset: 0.

SheetDB’s API makes use of the [] characters, and I believe that syntax conflicts with bubble’s API Connector’s use of the same [] characters.

How might I circumvent this issue?

Jici · 2020-09-06T17:28:21.238Z

Can you share your API Call setting?
I don’t see a reason to have an issue with parameter

mr.robert.mion · 2020-09-06T18:38:06.828Z

When I hard-code the GET request, I receive the correct response:

Screen Shot 2020-09-06 at 2.33.12 PM831×472 30.4 KB

But when I attempt to use characters to set the key-value parameter pair:

Screen Shot 2020-09-06 at 2.34.53 PM831×511 34.1 KB

I get an error:

Screen Shot 2020-09-06 at 2.34.42 PM831×312 13.9 KB

I’m almost convinced it is because the SheetDB API could catch it:
Screen Shot 2020-09-06 at 2.37.32 PM

Jici · 2020-09-06T19:26:14.068Z

you need to set up this way:
search?Email=[email]

Jici · 2020-09-06T19:28:12.733Z

For the using multiple queries, this will be a little bit more complicated but you can use
[queries] and inside the value, use the complete queries including name[]=!

Jici · 2020-09-06T19:28:46.846Z

but you also try to urlencode the [] to avoid Bubble decode it as a parameter

mr.robert.mion · 2020-09-07T00:19:43.384Z

This was the missing piece. Thank you for solving my problem, Jici.