Database to database using bubble app connector

Hi guys. I have 2 apps that a web app and a management tool. Sending data to the management tool database based on the user input on the web app is working fine with single order type(like 1 egg or 3 eggs). But when it’s multiple order type (like 1 egg and 1 bread), when it sends those order it is being placed in 1 row and separated with comma. What I wanted was for it to be in 2 or more row depending on the orders (1 row per order).

This is from my website, the one that sends.

321

And this is from my tool app, the one that has the database the receives the data.


Help anyone?

Anyone???

You haven’t instructed the receiving app to accept arrays, only scalar values.

That’s probably the first issue

So I should check the list/array. Got it. And another thing. When I try to send numbers, I’m having a problem for the statement. Is it, …each item’s number:first item? But if I did, I think it will only send the first item like it says.

tried it then this message appeared

image

anyone???

The error message tells you what’s wrong. The request isn’t JSON safe so you’re missing :formatted as JSON-safe somewhere it’s necessary or have a badly formatted API call. More screenshots would be useful though, not sure I completely understand your setup…

Tried that :formatted as JSON-safe but still it shows the message.

Here’s my SS for the sender app.

And his is the receiving app.


image

any ideas what’s wrong?

@georgecollier ???

This topic was automatically closed after 70 days. New replies are no longer allowed.