Google API - Create event fails

[stefan.h.link]

Hi guys,
I’ve setup a API connector to create a Google calendar event.
Every time I run the workflow it fails.
But if I copy/paste all the values from the debugger manually in the API connector, it works…

I have no idea anymore what I’m doing wrong… Please help me!!

API Connector (push)
https://www.googleapis.com/calendar/v3/calendars/primary/events?conferenceDataVersion=1

My parameters are:
EndDate “2023-09-10T17:30:00.000Z”
StartDate “2023-09-10T17:15:00.000Z”
Summary “TEST”
Description “TEST123”
Attendees {
“email”: “stefan.h.link@gmail.com”,
“displayName”: “Stefan”
}
, {
“email”: “maria.test@gmail.com”,
“displayName”: “Maria”
}

Workflow

Debugger

[georgecollier]

Remove all new lines and spaces from the format as text. Format as text puts \n for new lines etc and Bubble doesn’t document it. Obviously that screws up the JSON.

By the way, using the rich text editor can be useful to edit the new lines/spaces as it can be a little fiddly and hard to know where spaces are in the expression composer…

No clue why Bubble doesn’t have a checkbox that just disables JSON-safe formatting in :format as text (or even why it behaves like this by default…)

[stefan.h.link]

Genius - you saved me quite some headache!!