David Wang
 · Product Manager & Full-Stack Developer | Bridging Product Vision and Technical Solutions

transform an array into an object to bulk edit leveraging my meta API

Hello dear community,

I have two questions:

1- which option to bulk edit a table performs the best between query all (stream) => loop + edit record AND query all => external API call to Xano meta API bulk patch (https://api.flexliving.com/api:meta/workspace/x/table/y/content/bulk/patch) ?

2- if the latter performs best, does any one has a snippet or Xano transform expression to format an array (typically output of query all) to the correct Json object without using any loop.

{
  "items": [
    {
      "row_id": 1,
      "updates": {
        "name": "test name"
      }
    }
  ]
 }

Thank you peeps

1
1 reply