# Troubleshooting Glide API Issues **URL:** \ **Category:** Ask for Help\ **Tags:** api, call-api\ **Created:** [August 2, 2024, 7:41am UTC](https://community.glideapps.com/t/troubleshooting-glide-api-issues/75373 "2024-08-02T07:41:29Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![evazivanovic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/evazivanovic/32/83692_2.png) [@evazivanovic](https://community.glideapps.com/u/evazivanovic)\ **Post date:** [August 2, 2024, 7:41am UTC](https://community.glideapps.com/t/troubleshooting-glide-api-issues/75373/1 "2024-08-02T07:41:29Z")
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](https://www.tella.tv/video/glide-api-help-donf) 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. ```auto { "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" } ] } ``` ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [August 2, 2024, 9:05am UTC](https://community.glideapps.com/t/troubleshooting-glide-api-issues/75373/2 "2024-08-02T09:05:37Z")
What do you see in the Action history? ![CleanShot 2024-08-02 at 17.04.12@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/e/9e1a8ddb759da69dd02f9fed31c99e3daf250669.jpeg) ---
**Author:** ![evazivanovic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/evazivanovic/32/83692_2.png) [@evazivanovic](https://community.glideapps.com/u/evazivanovic)\ **Post date:** [August 2, 2024, 12:28pm UTC](https://community.glideapps.com/t/troubleshooting-glide-api-issues/75373/3 "2024-08-02T12:28:41Z")
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:** ![Screenshot 2024-08-02 at 14.24.11](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/e/2e5c611387a092438741ea9bf129d16850d90a8c.png) **The one that updated data correctly** (updated from Alma to Eva): ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/4/846aa08c05131e025d70b4d4e25051d606b43cbc.jpeg) **The one that did not** (updated from Eva to Alma): ![Screenshot 2024-08-02 at 14.26.28](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/2/e2e663b89a68bee77f10717d6125c2fe632d051b.jpeg) 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. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [August 2, 2024, 12:45pm UTC](https://community.glideapps.com/t/troubleshooting-glide-api-issues/75373/4 "2024-08-02T12:45:04Z")
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. ---
**Author:** ![evazivanovic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/evazivanovic/32/83692_2.png) [@evazivanovic](https://community.glideapps.com/u/evazivanovic)\ **Post date:** [August 2, 2024, 2:09pm UTC](https://community.glideapps.com/t/troubleshooting-glide-api-issues/75373/5 "2024-08-02T14:09:59Z")
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? ![Screenshot 2024-08-02 at 16.11.22](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/3/1385d7e7fd28e9029c7888f5ade04f1a25183d14.jpeg) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [August 2, 2024, 2:20pm UTC](https://community.glideapps.com/t/troubleshooting-glide-api-issues/75373/6 "2024-08-02T14:20:06Z")
> [@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. ---
**Author:** ![evazivanovic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/evazivanovic/32/83692_2.png) [@evazivanovic](https://community.glideapps.com/u/evazivanovic)\ **Post date:** [August 2, 2024, 2:49pm UTC](https://community.glideapps.com/t/troubleshooting-glide-api-issues/75373/7 "2024-08-02T14:49:38Z")
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. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [August 9, 2024, 2:50pm UTC](https://community.glideapps.com/t/troubleshooting-glide-api-issues/75373/8 "2024-08-09T14:50:20Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.