Bubble breaks when payload contains ' character - JSON-safe not "saving the day"

german · 2024-07-15T19:25:12.278Z

Hi there! First request for help in 2 years.

For some reason this call breaks when broker_folder_name contains the character ’

CALL

image1392×250 26.4 KB

Even if being escaped with JSON-safe

image1220×292 38.9 KB

I can confirm that:

removing the character makes the call work
trying to initialize the call with the character also breaks the call and has been impossible to initialize it with it, regardless of trying to escape it with \ or double \ \ (no space between)

HELP! Thanks in advance

moabe.leite · 2024-07-15T19:29:36.926Z

Unfortunately this expression “Json Safe” is not really realiy safe

J805 · 2024-07-15T19:36:34.031Z

If JSON safe doesn’t work you can use ‘find and replace’ for the characters that you are aware of. It’s just not a very good solution since there might be more down the line that you might need to fix. Maybe send a bug report so they are aware of that.

german · 2024-07-15T19:43:36.680Z

Thanks for the help. The problem is that the name is dynamic and it may or may not contain the character so find&replace won’t do it.

Hoping some bubble guru can step in and shed some light on whether this is really a bug or not

J805 · 2024-07-15T19:53:48.703Z

Well, if it doesn’t find anything, then it won’t replace anything. But sure, you can wait for a Bubble Guru to answer.

german · 2024-07-15T19:57:28.780Z

Wait I just realized you are a Guru!

I’d love to solve this without a patch that may create technical debt though. Let’s see…

J805 · 2024-07-15T20:10:52.346Z

You can also try using ‘find and replace’ using a regex. Might be a better catch all option.

ihsanzainal84 · 2024-07-15T23:09:40.588Z

What’s a Bubble Guru?

AliFarahat · 2024-07-15T23:44:59.567Z

Would be really nice to submit a big report for this. So all of us can rest easy knowing it’s been reported and fixed

german · 2024-07-16T14:48:18.749Z

I will report the bug to Bubble and post answers here, unless someone else chips in.

Jici · 2024-07-16T15:09:49.561Z

I personnaly think it’s an issue with the API service and not Bubble.
Single quotes doesn’t need to be escaped in JSON. You can check with jsonlint to validate the JSON.

However, the API service could have issue with special characters. Which API are you calling? Which error do you get?

german · 2024-07-16T15:30:18.897Z

Thanks for this insight! I thought so too. Some notes:

It’s our own API service. It’s a very silly service that creates Folder on G Drive.
JSON lint OK.
Once we noticed this error we modified the API no make sure this would not cause an issue,
However, upon “fixing” and then trying again, it would still not work.
The call to our API works without the character via Bubble AND via POSTMAN (with and without character). Hence we assume the API is not the issue.
I found this online, upon trying to add \ to the folder name in Bubble when initializing the call, the call breaks with message like this:

<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="utf-8">
    <title>Error</title>
</head>

<body>
    <pre>SyntaxError: Bad escaped character in JSON at position 91<br> &nbsp; &nbsp;at JSON.parse (&lt;anonymous&gt;)<br> &nbsp; &nbsp;at parse (/api/node_modules/body-parser/lib/types/json.js:92:19)<br> &nbsp; &nbsp;at /api/node_modules/body-parser/lib/read.js:128:18<br> &nbsp; &nbsp;at AsyncResource.runInAsyncScope (node:async_hooks:206:9)<br> &nbsp; &nbsp;at invokeCallback (/api/node_modules/raw-body/index.js:238:16)<br> &nbsp; &nbsp;at done (/api/node_modules/raw-body/index.js:227:7)<br> &nbsp; &nbsp;at IncomingMessage.onEnd (/api/node_modules/raw-body/index.js:287:7)<br> &nbsp; &nbsp;at IncomingMessage.clsBind (/api/node_modules/cls-hooked/context.js:172:17)<br> &nbsp; &nbsp;at IncomingMessage.emit (node:events:518:28)<br> &nbsp; &nbsp;at IncomingMessage.emitted (/api/node_modules/emitter-listener/listener.js:134:21)</pre>
</body>

</html>```

Jici · 2024-07-16T15:52:23.649Z

I see. So in this case, find & replace is you best option. I don’ expect Bubble to do modification to json-safe function.

german · 2024-07-16T17:37:59.093Z

Thanks. Can you elaborate how find& replace would be better?

I mean since manually adding the \ character at call initialization does not work anyway, why would find&replace work? What am I missing?

Thanks all for helping solve this mistery!

Jici · 2024-07-16T17:59:43.834Z

You said it work in Postman? Can share what you have set in postman? Body and headers?

german · 2024-07-16T18:38:00.296Z

Headers ( there is additionally a key sent with the request)

image1328×646 33.6 KB

I can share the endpoint privately if needed.

Body

{
	"parent_folder_id": "XXXXXXX", // place the folder ID of your GDrive folder where you want to folder to be created
	"broker_folder_name": "Ledger's of FOOLAND ", // name of the folder you want
	"sub_folders": ["clients", "templates"] // list of subfolders wanted.
}```

german · 2024-07-16T20:09:26.952Z

It worked adding 2 backlashes \ \ (and escape one and another). The G Drive API doe snot give error but obviously it’s not the expected result

german · 2024-07-17T22:54:20.592Z

Case closed folks. As embarrassing as it is to admit, the issue was that the URL of the endpoint was changed (new deployment that acepted the ’ character), but not changed on the plug-in so we were making the call to “broken api”. Nothing else. I feel like a total fool. Sorry for wasting everyone’s time and thanks for the help.