Hi everyone!
What’s the best way to send all records of data type from bubble to n8n in a array JSON?
I create an API workflow to send a JSON object but it send NULL. See the screenshots. Arbitrary texts content [].
Thanks a lot!
Your privacy rules could be causing the null. Try ignoring privacy rules first and check if data is sent.
2 Likes
If it ends up not being Privacy Rules, you can try putting in the square brackets without the arbitrary text. 
Sometimes that helps.
1 Like
There is no privacy rules and Ignore Privacy rules box are checked. I make a test performing a identical seach and return 2 registers. I realy stuck on this step.
Can we see you API connector settings for that step?
1 Like
I have been folowed partially steps of this site How to convert data list in Bubble to a clean JSON array (no plugin) | Beyond the Code
It looks like your structure might be off.
Send the request to a service like beeceptor and inspect the body and structure. Validate the json received using jsonlint.
What was the content that you had in the API connector to get it to initialize in the first place?
123 only
It looks like ‘flightlegs’ is only expecting a number. Are you sure you have the structure correct?
thanks for while…. Beeceptor (It’s new for me). the caalk returns
{
“flight_legs”:[{\n “date_iso”: “2026-01-07T00:00:00.000Z”,\n “origin”: “SBRJ”\n “destination”: “SBSP”},{\n “date_iso”: “2026-01-08T00:00:00.000Z”,\n “origin”: “SBSP”\n “destination”: “SBCT”},{\n “date_iso”: “2026-01-08T00:00:00.000Z”,\n “origin”: “SBCT”\n “destination”: “SBGL”},{\n “date_iso”: “2026-01-09T00:00:00.000Z”,\n “origin”: “SBRJ”\n “destination”: “SBSP”}]
}
and json lint response is:
beeceptor respond this json
{
“flight_legs”:[{\n “date_iso”: “2026-01-07T00:00:00.000Z”,\n “origin”: “SBRJ”\n “destination”: “SBSP”},{\n “date_iso”: “2026-01-08T00:00:00.000Z”,\n “origin”: “SBSP”\n “destination”: “SBCT”},{\n “date_iso”: “2026-01-08T00:00:00.000Z”,\n “origin”: “SBCT”\n “destination”: “SBGL”},{\n “date_iso”: “2026-01-09T00:00:00.000Z”,\n “origin”: “SBRJ”\n “destination”: “SBSP”}]
}
invalid in jsonlint
Yeah. But you are trying to send a bunch of data, like date, origin and destination, but it is expecting only a single number.
1 Like
You can also see that Bubble send an escaped JSON (\n). Delete all white space and new line and put everything on a single line.
1 Like
@nick.carroll Another example of what Bubble do when using dynamic text box that doesn’t happen when using API connector JSON box (or raw).
Maybe an option to avoid Bubble escaping text?
2 Likes
using the find&replace function?
Yes… but honestly, better to just encode using a single line. Easier to maintain from my point of view…
1 Like