[Help] Bubble SQL Plugin Bulk Operation

Need help Plugins
1

It is possible to bulk Insert Into?

now can only 1 by 1, which is Crazy slow.

example :
INSERT INTO employees (first_name, last_name)
VALUES
(‘John’, ‘Doe’),
(‘Jane’, ‘Smith’),
(‘Michael’, ‘Johnson’);

any1 know how this can be possible?

i past a list of data and bulk insert into my SQL server.
now i can only do 1 by 1, crazy slow.

2

Dig into backend workflows.
If I understood you correctly - this will solve your case:
0. Create new API in Backend Workflows:
image

  1. Schedule Workflow API (let’s call it API1) on some event (button click or smth) → propagate your list or object into parameters + iteration variable
    image

  2. API1 has two actions inside:

  • Create a thing (with your list:item #iteration)
    image

  • Schedule Workflow API1 within itself with increase of iteration variable
    image

CRUCIAL thing is to add ‘Only when’ condition so the loop with end when some parameter will met it’s value:
image

This value may be static or propagated as a parameter (i.e. you may use list:count)

That’s it. Hope you got the idea.

If you were talking about inserting at once multiple records with one call - I’m afraid there’s no such option. At least I failed to find it when I needed.

3

The SQL Connector is simply a method to past SQL statements to the server. My experience has been that as long as the statement is syntactically correct, it should work fine. Have you been able to test it in the SQL Connector? If it doesn’t work, what error are you getting?

4

You can bulk create table objects by using the bulk api endpoint.

@jacobgershkovich