# Editing rows with the API doesn't always work

**URL:** <https://community.glideapps.com/t/editing-rows-with-the-api-doesnt-always-work/62417>\
**Category:** Report a Bug\
**Created:** [June 3, 2023, 4:01pm UTC](https://community.glideapps.com/t/editing-rows-with-the-api-doesnt-always-work/62417 "2023-06-03T16:01:27Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![devick](https://avatars.discourse-cdn.com/v4/letter/d/67e7ee/32.png) [@devick](https://community.glideapps.com/u/devick)\
**Post date:** [June 3, 2023, 4:01pm UTC](https://community.glideapps.com/t/editing-rows-with-the-api-doesnt-always-work/62417/1 "2023-06-03T16:01:27Z")

</div>

Hello there,

I am using Make to automate my workflow along with Glide’s API. It works most of the time but unfortunately it appears that sometimes it doesn’t as it should.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/2/c20ecea66f1de90b211b83a804db722cbcf9dd0f.png)

The screenshot above shows an “Edit rows” request in Make to glide’s API that’s supposed to set the **ID from QB** column’s value to **387**.  
This exact workflow works most of the times but sometimes no. Down below an exemple of when it doesn’t work.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/8/c833bfe16467e2b08b42fca42f83e29fc40c6aa5.png)

The value **387** wasn’t added to row n°145.

Is it a known thing that glide’s API does not accurately transfer information 100% of the time ?  
What would you suggest me to do ?

Ask for more information if needed.

Sincerely,

---

<div class="post-metadata">

**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\
**Post date:** [June 3, 2023, 4:08pm UTC](https://community.glideapps.com/t/editing-rows-with-the-api-doesnt-always-work/62417/2 "2023-06-03T16:08:09Z")

</div>

Hmmm just thinking out loud maybe because you are trying to write a text value to a number column. Does it help if you switch the ‘ID from QB’ in Glide to a text column?

---

<div class="post-metadata">

**Author:** ![Ronald](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ronald/32/49776_2.png) [@Ronald](https://community.glideapps.com/u/Ronald)\
**Post date:** [June 3, 2023, 5:26pm UTC](https://community.glideapps.com/t/editing-rows-with-the-api-doesnt-always-work/62417/3 "2023-06-03T17:26:59Z")

</div>

He is writing 387 to a number column… Or am i missing something?

---

<div class="post-metadata">

**Author:** ![Ronald](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ronald/32/49776_2.png) [@Ronald](https://community.glideapps.com/u/Ronald)\
**Post date:** [June 3, 2023, 5:29pm UTC](https://community.glideapps.com/t/editing-rows-with-the-api-doesnt-always-work/62417/4 "2023-06-03T17:29:19Z")

</div>

You can try to redefine the column name in Make because Glide changed that setup a little time ago.

---

<div class="post-metadata">

**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\
**Post date:** [June 3, 2023, 6:02pm UTC](https://community.glideapps.com/t/editing-rows-with-the-api-doesnt-always-work/62417/5 "2023-06-03T18:02:31Z")

</div>

Possibly he is writing the text value 387 from Make… just like when I type 387 here… it’s text

---

<div class="post-metadata">

**Author:** ![Ronald](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ronald/32/49776_2.png) [@Ronald](https://community.glideapps.com/u/Ronald)\
**Post date:** [June 3, 2023, 6:21pm UTC](https://community.glideapps.com/t/editing-rows-with-the-api-doesnt-always-work/62417/6 "2023-06-03T18:21:15Z")

</div>

Okay. I didn’t know that.  
Good to know! That can saves a lot of trouble 😵‍💫.

Thank you for clearing this!

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [June 3, 2023, 6:42pm UTC](https://community.glideapps.com/t/editing-rows-with-the-api-doesnt-always-work/62417/7 "2023-06-03T18:42:32Z")

</div>

Try this too:

> [@Use the Create JSON Module when using Make+Glide API](https://community.glideapps.com/t/use-the-create-json-module-when-using-make-glide-api/58439):
>
> Hey all! If you’re a regular user of [Make.com](https://www.make.com/en/register?pc=robert) and you’re using it to write to Glide using Glide API, be sure to use the Create JSON module to prevent your Make scenarios from failing. Here’s how: [[Use the Create JSON Module When Calling Glide API Via Make] ](https://www.youtube.com/watch?v=9AMmWDWkAJY)

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [June 3, 2023, 11:30pm UTC](https://community.glideapps.com/t/editing-rows-with-the-api-doesnt-always-work/62417/8 "2023-06-03T23:30:47Z")

</div>

This should be in the bible of Glide x Make users.

---

<div class="post-metadata">

**Author:** ![SamSC](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/samsc/32/46936_2.png) [@SamSC](https://community.glideapps.com/u/SamSC)\
**Post date:** [June 5, 2023, 5:59pm UTC](https://community.glideapps.com/t/editing-rows-with-the-api-doesnt-always-work/62417/9 "2023-06-05T17:59:42Z")

</div>

Hey,

I can confirm the behavior unfortunately.  
So far I have filled the HTTP requests in Make directly with JSON and inserted the variables there. The process works 99% of the time, but unfortunately it sometimes happens that an update is sent to Make, the response is also 200, but the value is still not changed in the database at Glide.

After reading this post, I changed everything to Json Converter and have to say that this gives even worse results!

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [June 6, 2023, 12:04am UTC](https://community.glideapps.com/t/editing-rows-with-the-api-doesnt-always-work/62417/10 "2023-06-06T00:04:26Z")

</div>

That’s weird. Can you show us some screenshots or talk more about the columns that are showing the problem?

- Have you checked if the column ID/name is correct?
- What type of value are you pushing through the API to edit your database?
- In the case of errors, are those values any different to the successful attempts?

---

<div class="post-metadata">

**Author:** ![SamSC](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/samsc/32/46936_2.png) [@SamSC](https://community.glideapps.com/u/SamSC)\
**Post date:** [June 6, 2023, 9:34am UTC](https://community.glideapps.com/t/editing-rows-with-the-api-doesnt-always-work/62417/11 "2023-06-06T09:34:58Z")

</div>

> [@ThinhDinh](#):
>
> Have you checked if the column ID/name is correct?

Yes, otherwise the other requests would not be true 🙂

I trigger this HTTP call after a data import so that I can store the newly generated lead ID in the data source. As you can see here, I get the status code 200 from Glide, the data is correctly formatted and yet the entry in Glide is not adjusted.

Very difficult to find out an error here, especially since there are no special deviations to the other leads and the other leads are updated without errors.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/c/9ccd44dec2341e54b294d40ebe3fa5f052b5dc1c.png)  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/c/ccc7180c30f238242963439c239c9ea0dd06fb78.png)

---

<div class="post-metadata">

**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:** [June 6, 2023, 10:03am UTC](https://community.glideapps.com/t/editing-rows-with-the-api-doesnt-always-work/62417/12 "2023-06-06T10:03:27Z")

</div>

If you have a specific example of a call that didn’t work as expected (and it looks like you do), I’d suggest raising a ticket with Glide so that it can be investigated.
