Glide api seems very slow

Ask for Help
1

I make use of Glides API.
Adding a new row via the Call API seems very slow

I call the API from within the app by a user initiated workflow

The body is like below - so I just add one row in another table - and it takes approx 2 seconds

Is this the expected behavior - 1-2 seconds for such an api-call?
Postman takes from 0.95s - 1.45 seconds

Anyway to make the call speed up?

"appID": "XjbSNoLzL5GSbUbX8QZB",
  "mutations": [
    {
      "kind": "add-row-to-table",
      "tableName": "native-table-CuC4wUc5jhdwy1fxFPl3",
      "columnValues": {
        "jqu8r": "myemail@email.com",
        "xeXKq": "101",
        "oS4iy": "FineThings",
        "7B4Iy": "1234560000",
        "xZHfv": true,
        "1Uu2Y": "true"
      }
    }
  ]
}
2

Is there any reason you don’t use add row action?

From my experience, I wouldn’t call 1-2 seconds very slow, but if you add a huge amount of rows it would stack up a bit.

3

@ThinhDinh I have to write 2,5, 20 rows into 5 different tables. Therefore I haven’t considered doing just add row action as the number of rows differ.

My data comes from a json file and I want to populate the 5 different tables (like baseinformation, products, contacts etc). I thought about just getting the data into the tables by query json columns but I need to be able to change the data afterward say that I have product.color=red and I want in the user interface to be able to change it to blue. Then I will need an extra column for the user-inputted value - and the user-inputted value should to a start be red.

This is why I ended up using call API to get the data to the 5 different table. I wonder if there would be another way - and there I could avoid 5 api calls - maybe taking 6-10 seconds in total

4

If you have access to the webhook workflow, I would suggest using:

  • A webhook workflow.
  • An action to send a JSON to that webhook workflow.
  • Use query JSON and loops to add them to the right table.

For this, just add the color to the body to send to webhook workflow, use query JSON to query it out, and use it as needed afterwards.

5

@ThinhDinh Thanks for suggestions. At present, I don’t have access to webhooks - but could consider it in the future if it could perform a lot better than call API. It is unclear to me if webhooks are superior to call api when I need to add rows to 5 different tables. Is there any indications of that? Any good video resources to get a feeling of how webhooks work in Glide?