# 🎓 Glide Tutorial - Add, Edit or Delete Multiple Rows (Using Glide's API) **URL:** \ **Category:** Community Resources\ **Tags:** api, multiple-rows, tutorial\ **Created:** [August 18, 2023, 12:37am UTC](https://community.glideapps.com/t/glide-tutorial-add-edit-or-delete-multiple-rows-using-glides-api/65138 "2023-08-18T00:37:42Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Loqode](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/loqode/32/50217_2.png) [@Loqode](https://community.glideapps.com/u/Loqode)\ **Post date:** [August 18, 2023, 12:37am UTC](https://community.glideapps.com/t/glide-tutorial-add-edit-or-delete-multiple-rows-using-glides-api/65138/1 "2023-08-18T00:37:42Z")
[![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/a/daee86fcd0e13c4034c789717186e37ef6ec21aa.jpeg "🎓 Glide Tutorial - Add, Edit or Delete Multiple Rows (Glide API)") ](https://www.youtube.com/watch?v=b7_k3_brusQ) What’s up Gliders! Glide’s new native API functionality has unlocked a _ton_ of power 🤯 I’ve always wanted the ability to natively add, edit, or delete multiple rows without needing Make/Zapier… And after seeing a quick loom from @Darren_Murphy I was reminded that this is now possible 🤝 **In this video I explain:** - How to add a predefined list of tasks to a new project. - How to delete any tasks related to a project that you delete. There may be more efficient ways of doing this (e.g. deleting rows via the relation/query column) but the fact that it’s possible via API is what excites me! 🔥 **Possible Use Cases Include:** - Have predefined “groups” of rows that you can add and relate to _parent_ row in a single action. - Editing all _related_ rows when the _parent_ row is edited. - Deleting all _related_ rows when you delete the _parent_ row. - And much, much more! 🍿 Enjoy! ---
**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\ **Post date:** [August 21, 2023, 8:35am UTC](https://community.glideapps.com/t/glide-tutorial-add-edit-or-delete-multiple-rows-using-glides-api/65138/3 "2023-08-21T08:35:33Z")
Thank you @Loqode for step by step tutorials. So easy to understand. ---
**Author:** ![Loqode](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/loqode/32/50217_2.png) [@Loqode](https://community.glideapps.com/u/Loqode)\ **Post date:** [August 21, 2023, 10:13pm UTC](https://community.glideapps.com/t/glide-tutorial-add-edit-or-delete-multiple-rows-using-glides-api/65138/4 "2023-08-21T22:13:42Z")
You’re welcome! ---
**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\ **Post date:** [September 1, 2023, 12:09pm UTC](https://community.glideapps.com/t/glide-tutorial-add-edit-or-delete-multiple-rows-using-glides-api/65138/5 "2023-09-01T12:09:05Z")
@Loqode I really need your help to implement Call API columns in one of my projects. I will explain you my scenario. A Client submits a form with many values in an App. Out of many values, there is one component wherein a client has to select multiple States. What I want is, upon form submission, if 30 states are selected, 30 new rows for each state shall be added in another table. I followed your instructions as per view and I hope I have done it correctly. However, while executing actions, I am getting an error “Call API: No Response”. Can you help me troublesheet it? ---
**Author:** ![Loqode](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/loqode/32/50217_2.png) [@Loqode](https://community.glideapps.com/u/Loqode)\ **Post date:** [September 1, 2023, 12:16pm UTC](https://community.glideapps.com/t/glide-tutorial-add-edit-or-delete-multiple-rows-using-glides-api/65138/6 "2023-09-01T12:16:06Z")
What plan are you on? ---
**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\ **Post date:** [September 1, 2023, 12:17pm UTC](https://community.glideapps.com/t/glide-tutorial-add-edit-or-delete-multiple-rows-using-glides-api/65138/7 "2023-09-01T12:17:31Z")
I am on Pro plan ---
**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\ **Post date:** [September 1, 2023, 12:19pm UTC](https://community.glideapps.com/t/glide-tutorial-add-edit-or-delete-multiple-rows-using-glides-api/65138/8 "2023-09-01T12:19:05Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/7/972e9fb371d9279100da79594ccc66ac6a6b23a8.png) Here is an screenshot of action Screenshot of Body column ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/9/d9c13ac0ad0f64cd5e724b0038f97eba5343fa10.png) Is there any limit on number of mutations mentioned in CallAPI action? Like I am trying to add 40 rows using this column ---
**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:** [September 1, 2023, 12:35pm UTC](https://community.glideapps.com/t/glide-tutorial-add-edit-or-delete-multiple-rows-using-glides-api/65138/9 "2023-09-01T12:35:42Z")
> [@Pratik\_Shah](#): > > Is there any limit on number of mutations mentioned in CallAPI action? The limit is 500 mutations with a single call. From your screenshots, I don’t see anything obviously wrong. Have you validated your JSON payload using [JSON lint](https://jsonlint.com/)? Also, try sending the same payload with a curl command in a terminal, and see what response you get from the Glide API. ---
**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\ **Post date:** [September 1, 2023, 12:46pm UTC](https://community.glideapps.com/t/glide-tutorial-add-edit-or-delete-multiple-rows-using-glides-api/65138/10 "2023-09-01T12:46:28Z")
> [@Darren\_Murphy](#): > > Have you validated your JSON payload using [JSON lint](https://jsonlint.com/)? Thank you for the response. I tried to validate the values from “Body column” and it gave me this error. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/0/7081a72e7cfdb236a8f1774fc75ef54098ff30cc.png) Secondly, I am not sure what did you mention here below. > [@Darren\_Murphy](#): > > Also, try sending the same payload with a curl command in a terminal, and see what response you get from the Glide API. ---
**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:** [September 1, 2023, 12:48pm UTC](https://community.glideapps.com/t/glide-tutorial-add-edit-or-delete-multiple-rows-using-glides-api/65138/11 "2023-09-01T12:48:55Z")
> [@Pratik\_Shah](#): > > Thank you for the response. I tried to validate the values from “Body column” and it gave me this error. > ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/0/7081a72e7cfdb236a8f1774fc75ef54098ff30cc.png) Okay, so your JSON is invalid. You’ll need to fix that first. It looks like you have extra double quotes in there. ---
**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\ **Post date:** [September 1, 2023, 12:50pm UTC](https://community.glideapps.com/t/glide-tutorial-add-edit-or-delete-multiple-rows-using-glides-api/65138/12 "2023-09-01T12:50:59Z")
> [@Pratik\_Shah](#): > > ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/9/d9c13ac0ad0f64cd5e724b0038f97eba5343fa10.png) but here if you see the values, it shows only one double quotes. Double quotes are coming only when I am copy pasting it on website @Darren_Murphy ---
**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:** [September 1, 2023, 12:58pm UTC](https://community.glideapps.com/t/glide-tutorial-add-edit-or-delete-multiple-rows-using-glides-api/65138/13 "2023-09-01T12:58:29Z")
How are you creating the JSON? ---
**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\ **Post date:** [September 1, 2023, 1:14pm UTC](https://community.glideapps.com/t/glide-tutorial-add-edit-or-delete-multiple-rows-using-glides-api/65138/14 "2023-09-01T13:14:24Z")
By using join column (as shown in above video by @Loqode ) ---
**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:** [September 1, 2023, 1:26pm UTC](https://community.glideapps.com/t/glide-tutorial-add-edit-or-delete-multiple-rows-using-glides-api/65138/15 "2023-09-01T13:26:38Z")
Okay, well I’m not sure then. It seems like somethings not right, but I can’t see it based on what you’ve shared. ---
**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\ **Post date:** [September 1, 2023, 1:33pm UTC](https://community.glideapps.com/t/glide-tutorial-add-edit-or-delete-multiple-rows-using-glides-api/65138/16 "2023-09-01T13:33:33Z")
Is there any other way to create a json? ---
**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:** [September 1, 2023, 1:42pm UTC](https://community.glideapps.com/t/glide-tutorial-add-edit-or-delete-multiple-rows-using-glides-api/65138/17 "2023-09-01T13:42:06Z")
Well, a joined list column on it’s own doesn’t create a JSON string. You must be joining something, and that something must have been created… somehow… Usually, the JSON for each row would be created in one of 3 ways: - a template column - a JSON Object column (the new one) - a Make JSON Object column (the old one) Are you using one of those 3, or some other way? The second one is probably the recommended way, although that column is still in Previews and probably not fully baked yet. So I don’t know how reliable it is just yet. ---
**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\ **Post date:** [September 1, 2023, 2:02pm UTC](https://community.glideapps.com/t/glide-tutorial-add-edit-or-delete-multiple-rows-using-glides-api/65138/18 "2023-09-01T14:02:57Z")
I am using Template column to create that. ---
**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:** [September 1, 2023, 2:09pm UTC](https://community.glideapps.com/t/glide-tutorial-add-edit-or-delete-multiple-rows-using-glides-api/65138/19 "2023-09-01T14:09:47Z")
Okay, that should work fine. Sorry, I really don’t have any more suggestions. ---
**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\ **Post date:** [September 1, 2023, 2:10pm UTC](https://community.glideapps.com/t/glide-tutorial-add-edit-or-delete-multiple-rows-using-glides-api/65138/20 "2023-09-01T14:10:43Z")
Thanks ---
**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\ **Post date:** [September 1, 2023, 4:31pm UTC](https://community.glideapps.com/t/glide-tutorial-add-edit-or-delete-multiple-rows-using-glides-api/65138/22 "2023-09-01T16:31:25Z")
@Darren_Murphy, I removed comma after last column value and tried to validate. Now it shows **Valid JSON**. However, it is still not working. This is the final payload. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/e/7ee9c71c7a308d1529a7800dc52269626cd55b76.png) EDIT: It’s working now. I published the changes and then it worked. It was not even working on Editor. Now it’s working in both editor as well on published app. [Next page](https://community.glideapps.com/t/glide-tutorial-add-edit-or-delete-multiple-rows-using-glides-api/65138.md?page=2)