Query result to server API

[enriweb77]

Hello everyone, I would like to send the result of the query that returns the products in the cart to a server-side API to perform a repeat and write the order lines into the database based on the type of service purchased. At the moment I have rewritten the query in the API but I think there is a more correct way to perform this procedure (e.g. XML or an indexed object)

[karh]

What’s your question exactly ?
It seems like it works what you made? I don’t see any weird things in your server actions. We often need repeats when creating server actions in Wappler

[enriweb77]

I just wanted to avoid rewriting the cart query in the API maybe sending from the xml page or a json with the cart items to use in the loop.
I wanted to optimize but I can also leave everything as it is!
Thanks

[nickneustroev]

I believe this is what you are looking for?

Smarter Database Multi Insert

Continuing the discussion from Slow insert records into the database: Actually, I’ve just realized how slow is the Database Multi Insert in Wappler, even with transactions as mentioned in my previous post. I did the same test using a third-party SQL viewer, with the import feature, and it basically transforms the CSV into a bulk INSERT statement: INSERT (...) VALUES (...), (...), (...), (...), (... about 300) INSERT (...) VALUES (...), (...), (...), (...), (... about 300) // instead of Wapple…

Database Insert/Update/Delete from JSON

Please consider a database query “users”: [ { "id": 1, "name": "George", "country": "NL" }, { "id": 2, "name": "Teodor", "country": "BG" } ] That’s a JSON representation of our rows. Through a series of steps, I modify the names: [ { "id": 1, "name": "George P.", "country": "NL" }, { "id": 2, "name": "Teodor T.", "country": "BG" } ] Now, I want to UPDATE the databas…

If so, as you see, it is currently not implemented in Wappler.
You can leave your vote and comment in these threads to show your interest.