Troubleshooting Glide API Issues

[evazivanovic]

Hi guys,

I am hoping you can help me out with a Call API action I can get to work. I recorded a video showing the problem here: Glide API Help

Summary:

• When I update the manager of a team, I want to update the row owner in another table
• I designed the json (see below) from the data as I’ve seen some of you do in your videos
• I am using the edit columns endpoint and I double checked the token, table id, etc.
• I have the button pointing at the correct custom action
• When I click the button to trigger the custom action, nothing happens. The rows are not updated.

I have been troubleshooting this for hours and just can get it to work. I can use a webhook and handle it with Make, but would prefer to just do it in Glide if possible.

{
  "appID": "tKBjNWHeomPlmZxiTfUw",
  "mutations": [
    {
      "kind": "set-columns-in-row",
      "tableName": "native-table-pG5JqgSldExwP0nIxoQd",
      "columnValues": {
        "crUzO": "alma@example.com"
      },
      "rowID": "E7MlVxK1RAqBEyKWOacnLQ"
    },
    {
      "kind": "set-columns-in-row",
      "tableName": "native-table-pG5JqgSldExwP0nIxoQd",
      "columnValues": {
        "crUzO": "alma@example.com"
      },
      "rowID": "Qm.zhxQeSGut1vR0vugkcw"
    },
    {
      "kind": "set-columns-in-row",
      "tableName": "native-table-pG5JqgSldExwP0nIxoQd",
      "columnValues": {
        "crUzO": "alma@example.com"
      },
      "rowID": "DT3FL3MQSK2ogFMRYmzr1Q"
    },
    {
      "kind": "set-columns-in-row",
      "tableName": "native-table-pG5JqgSldExwP0nIxoQd",
      "columnValues": {
        "crUzO": "alma@example.com"
      },
      "rowID": "juGlmLc0Q9eS1cAXVUdIGQ"
    },
    {
      "kind": "set-columns-in-row",
      "tableName": "native-table-pG5JqgSldExwP0nIxoQd",
      "columnValues": {
        "crUzO": "alma@example.com"
      },
      "rowID": "LM8AUUi6QJedLXGlIsx54A"
    },
    {
      "kind": "set-columns-in-row",
      "tableName": "native-table-pG5JqgSldExwP0nIxoQd",
      "columnValues": {
        "crUzO": "alma@example.com"
      },
      "rowID": "r7azFyIlTp69Ad9mhXgQKA"
    }
  ]
}

[Darren_Murphy]

What do you see in the Action history?

[evazivanovic]

So basically it’s like this - sometimes it’s successful, sometimes it’s not. I ran two in a row, both showing “success”, but one picked up the right data, the second did not.

Historical runs:

The one that updated data correctly (updated from Alma to Eva):

The one that did not (updated from Eva to Alma):

It’s basically as if it didn’t pick up the change and it used previous data. It’s true that the runs were pretty close in terms of time (10s apart), but I would expect this to be consistent since data changes immediately.

Although even considering the time between runs is short - I don’t think this is problematic. I ran the automation again a few min later, same result - didn’t update.

[Darren_Murphy]

hah! Welcome to my world

This is a known Glide Bug. The issue is that the data gets cached and the JSON column output doesn’t update. I know that Glide Engineering are working on a fix, but I don’t know when that fix is expected to drop.

A workaround that has generally proven to be effective is to replace any JSON Object/Template columns with regular Template columns. Give that a try.

[evazivanovic]

Ooooh, good to know! Just the final JSON column, or all?

I am having trouble building the final template column in teams because Glide doesn’t want to give me the concatenated JSON as the option to fill the template with. I am able to roll up the concatenated JSON, just can’t use it in the template.

Any ideas?

[Darren_Murphy]

@evazivanovic

want to give me the concatenated JSON as the option to fill the template with. I am able to roll up the concatenated JSON, just can’t use it in the template.

Yeah, when building the JSON manually you need to use a Joined List instead of a Lookup. Then you can feed that into your Template.

[evazivanovic]

Brilliant, thank you Darren. Truly. This was a pain point for a while and unlocked quite a few things.

What an adventure that was But learned a lot in the process about Glide.