Bubble's API Post Bulk Create Call response: Could not parse as JSON (Can create 1 thing, fails with 2)

[jmalmeida]

Hi:

I’m trying to use the bulk create feature and it works if I intent to create just 1 thing, but when I pass 2 or more things to create them it fails and get this error message:

{"status":"error","message":"Could not parse as JSON: {\"Date-time\":\"2021-04-01T14:00:00.000Z\",\"Name\":\"dsf\",\"Owner\":\"1602529909058x625996378652707500\",\"Recurring Event ID\":\"1616764122041x216891753239674880\",\"Recurring?\":\"yes\",\"Tags\":[\"1616686748078x771618482210209800\"]}\\n{\"Date-time\":\"2021-04-08T14:00:00.000Z\",\"Name\":\"dsf\",\"Owner\":\"1602529909058x625996378652707500\",\"Recurring Event ID\":\"1616764122041x216891753239674880\",\"Recurring?\":\"yes\",\"Tags\":[\"1616686748078x771618482210209800\"]}"}

I’m using a list formated as text to create the payload and hitting the Enter key in the delimiter field to create a new line.

Can someone help me?

Thanks in advance!

[stuart.warren1]

@jmalmeida I discovered that this is a current limitation by bubble and a bubble engineer confirmed it.

Creating bubble things from JSON of bubble things

My particular issue has been troubling me for over a month now and I cannot seem to resolve it. I have been able to talk with a Bubble engineer who validated that my solution was not achievable with Bubble right now. My original solution was to send a dynamic body value (JSON output from JS) to the Data API Bulk call to create a list of things. This was their response: our API connector currently does not allow passing freeform content with a custom content-type. This is commonly requested,…

In my post above there is some info from bubble but also a solution on how to turn into bubble things.

I actually managed to use List Shifter to create the bubble things but at the most it’s taking around 7 seconds to create 48 things.

[jmalmeida]

Thanks @stuart.warren1.

I won’t be able to do it but at least now I know why.

While they implement it … I’ll take a look at your solution with List Shifter although I preferred not to have to use plugins.

Thanks again!

[stuart.warren1]

You should be fine then to use the solution in my post as this wasn’t with list shifter, it was to use a series of workflows with regex.

When I was in the process of implementing the solution in the post, I found a more efficient way via list shifter.

[richard10]

If you get stuck on the workflows, I’m around to help troubleshoot too (I suggested the non-plugin method on the original post)

[andrew.illingworth91]

hey @jmalmeida did you ever find a solution to this? Super frustrating!

[jmalmeida]

I didn’t, I’m sorry. You’re right, it’s frustrating!

And I didn’t try the solutions proposed by @stuart.warren1 and @richard10 because I didn’t have the time and needed to finish the work, but it’s on my todo list the day I had time to try it!

[jmalmeida]

I was asked privately about if I had found a solution to this. I had, so posting it here for anyone facing this problem:

1. Use Body type: Raw
2. Enter the test JSON directly in the body to initialize the call

cc @stuart.warren1 @richard10 @andrew.illingworth91