# Glide Apps API availability to Business Trial

**URL:** <https://community.glideapps.com/t/glide-apps-api-availability-to-business-trial/67540>\
**Category:** Ask for Help\
**Created:** [November 5, 2023, 12:24am UTC](https://community.glideapps.com/t/glide-apps-api-availability-to-business-trial/67540 "2023-11-05T00:24:06Z")\
**Posts on this page:** 18\
**Page:** 1

<div class="post-metadata">

**Author:** ![Airbid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/airbid/32/60953_2.png) [@Airbid](https://community.glideapps.com/u/Airbid)\
**Post date:** [November 5, 2023, 12:24am UTC](https://community.glideapps.com/t/glide-apps-api-availability-to-business-trial/67540/1 "2023-11-05T00:24:07Z")

</div>

Hi, does anybody if Glide apps API is accessible on a Business Trial? We’re not able to add rows and wonder if it has something to do with this. Thank you

---

<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:** [November 5, 2023, 12:48am UTC](https://community.glideapps.com/t/glide-apps-api-availability-to-business-trial/67540/2 "2023-11-05T00:48:46Z")

</div>

I think you should be able to add rows on a Business Trial. Can you show us how you’re configuring your API call and what response did you receive?

---

<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:** [November 5, 2023, 1:55am UTC](https://community.glideapps.com/t/glide-apps-api-availability-to-business-trial/67540/3 "2023-11-05T01:55:39Z")

</div>

I have a team that’s on a Business Trial, and I just tested an API Add Row call to ensure that it works. It does, as expected.

As @ThinhDinh mentioned, if you can share a bit more information, we can help you troubleshoot.

---

<div class="post-metadata">

**Author:** ![Airbid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/airbid/32/60953_2.png) [@Airbid](https://community.glideapps.com/u/Airbid)\
**Post date:** [November 5, 2023, 2:25am UTC](https://community.glideapps.com/t/glide-apps-api-availability-to-business-trial/67540/4 "2023-11-05T02:25:57Z")

</div>

this is the request I’m sending - I triple checked all the parameters and it all checks out. The response I get back are two row ids ([{“rowID”:“cwi9UbBVQkyEb3I-Ex20.g”},{“rowID”:“4p5Tyqg2Q1G6oo5UYVh.Hw”}]), but no records are created. When I try to send a longer body, it returns the error “bad request”  
.

btw I tried with both using the table ID and name

```auto
{
  "appID": "Rx2SzMgtpFlYsxTzqoOe",
  "mutations": [{
      "kind": "add-row-to-table",
      "tableName": "Library Accounts",
      "columnValues": {
        "Name": "samcutlerkreutz",
        "lRbv3": "31641477",
        "GkqUZ": "directed"
      }
}, {
      "kind": "add-row-to-table",
      "tableName": "Library Accounts",
      "columnValues": {
        "Name": "jonathanrichetts",
        "lRbv3": "31641477",
        "GkqUZ": "starring"
      }
}]
  }

```

---

<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:** [November 5, 2023, 2:34am UTC](https://community.glideapps.com/t/glide-apps-api-availability-to-business-trial/67540/6 "2023-11-05T02:34:30Z")

</div>

And what response do you get? (never mind, I see you updated your post with the response).

Question: are you posting to a regular Glide Table, or a Big Table?

---

<div class="post-metadata">

**Author:** ![Airbid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/airbid/32/60953_2.png) [@Airbid](https://community.glideapps.com/u/Airbid)\
**Post date:** [November 5, 2023, 2:39am UTC](https://community.glideapps.com/t/glide-apps-api-availability-to-business-trial/67540/7 "2023-11-05T02:39:33Z")

</div>

Big Table

---

<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:** [November 5, 2023, 2:43am UTC](https://community.glideapps.com/t/glide-apps-api-availability-to-business-trial/67540/8 "2023-11-05T02:43:42Z")

</div>

That may explain it.

Do the rows show up in the Data Editor if you reload the table?

 ![CleanShot 2023-11-05 at 10.42.27@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/8/18b1d23ef0df3bd2bd100366578cd822e5359be6.png)

---

<div class="post-metadata">

**Author:** ![Airbid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/airbid/32/60953_2.png) [@Airbid](https://community.glideapps.com/u/Airbid)\
**Post date:** [November 5, 2023, 2:45am UTC](https://community.glideapps.com/t/glide-apps-api-availability-to-business-trial/67540/9 "2023-11-05T02:45:22Z")

</div>

they do, wow 🫣

thank you!!

---

<div class="post-metadata">

**Author:** ![Airbid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/airbid/32/60953_2.png) [@Airbid](https://community.glideapps.com/u/Airbid)\
**Post date:** [November 5, 2023, 2:49am UTC](https://community.glideapps.com/t/glide-apps-api-availability-to-business-trial/67540/10 "2023-11-05T02:49:57Z")

</div>

well actually, there’s a second problem - the two added rows were tests to troubleshoot why I was getting “Bad Request” with my original body. It’s long, but it says Glide can do up to 500 mutations in a single request, so I’m stumped on what’s going on.

the request looks like this

```auto
{
  "appID": "Rx2SzMgtpFlYsxTzqoOe",
  "mutations": [{
      "kind": "add-row-to-table",
      "tableName": "native-table-8444d1d2-3b4e-442f-90b2-ed712f9d7232",
      "columnValues": {
        "Name": "samcutlerkreutz",
        "lRbv3": "31641477",
        "GkqUZ": "directed"
      }
}, ... (126x times){
      "kind": "add-row-to-table",
      "tableName": "native-table-8444d1d2-3b4e-442f-90b2-ed712f9d7232",
      "columnValues": {
        "Name": "beard_of_noise",
        "lRbv3": "27641218",
        "GkqUZ": "additional sound mix"
      }
}]
  }

```

---

<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:** [November 5, 2023, 2:52am UTC](https://community.glideapps.com/t/glide-apps-api-availability-to-business-trial/67540/11 "2023-11-05T02:52:24Z")

</div>

Copy/paste your entire JSON payload into a [JSON Validator](https://jsonlint.com/) and see what you get.

---

<div class="post-metadata">

**Author:** ![Airbid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/airbid/32/60953_2.png) [@Airbid](https://community.glideapps.com/u/Airbid)\
**Post date:** [November 5, 2023, 2:56am UTC](https://community.glideapps.com/t/glide-apps-api-availability-to-business-trial/67540/12 "2023-11-05T02:56:35Z")

</div>

It’s valid

---

<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:** [November 5, 2023, 2:59am UTC](https://community.glideapps.com/t/glide-apps-api-availability-to-business-trial/67540/13 "2023-11-05T02:59:47Z")

</div>

Okay, that’s interesting.  
If it works with 2 mutations then there is no reason why it shouldn’t work with 500, as long as the JSON is well formed.

You’re 100% certain that the structure of the request is identical in both cases, yes? (including the `appID`)

Where are you sending the request from, and how are you preparing the JSON?

---

<div class="post-metadata">

**Author:** ![Airbid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/airbid/32/60953_2.png) [@Airbid](https://community.glideapps.com/u/Airbid)\
**Post date:** [November 5, 2023, 3:03am UTC](https://community.glideapps.com/t/glide-apps-api-availability-to-business-trial/67540/14 "2023-11-05T03:03:12Z")

</div>

Yea 100% certain it’s the same, using a Call API step in Actions in both cases (test and this one).

I’m using a lookup to get the mutations. Then I make the array unique using unique elements. then I use a joined list to comma separate the arrays. Then I use a template to create the final body with appid

---

<div class="post-metadata">

**Author:** ![Airbid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/airbid/32/60953_2.png) [@Airbid](https://community.glideapps.com/u/Airbid)\
**Post date:** [November 5, 2023, 3:06am UTC](https://community.glideapps.com/t/glide-apps-api-availability-to-business-trial/67540/15 "2023-11-05T03:06:27Z")

</div>

I also tried using just the joined list without the steps before but get the same error

---

<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:** [November 5, 2023, 3:11am UTC](https://community.glideapps.com/t/glide-apps-api-availability-to-business-trial/67540/16 "2023-11-05T03:11:15Z")

</div>

hmmm, I wonder…

How are you generating the column values for each row - with a JSON Object column?  
I have seen the odd occasion where this will fail when used with a Call API or Trigger Webhook action, and I’m wondering if you may have bumped into one of these cases.

If you _are_ using a JSON Object column, try replacing it with a template column and see if that makes any difference. It probably won’t, but is worth a shot.

I guess the other thing to check would be Row Owners - are any of the tables involved using them?

One thing you could do is modify your action so that it writes the JSON Payload to a column somewhere immediately before or after the Call API step. Then you could check exactly what was sent.

Other than that, I’m not sure, sorry. It really should work when setup as you’ve described.

---

<div class="post-metadata">

**Author:** ![Airbid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/airbid/32/60953_2.png) [@Airbid](https://community.glideapps.com/u/Airbid)\
**Post date:** [November 5, 2023, 3:17am UTC](https://community.glideapps.com/t/glide-apps-api-availability-to-business-trial/67540/17 "2023-11-05T03:17:47Z")

</div>

I manually copied the body request to a single text field and used that to trigger the API response which worked. When I try to copy the body over to the text field in a separate automation step, it fails to do so. Does it have something to do with the fact I’m using user specific columns to generate the body? (not using row owners however, except on the Users table where I am creating the final payload)

---

<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:** [November 5, 2023, 3:30am UTC](https://community.glideapps.com/t/glide-apps-api-availability-to-business-trial/67540/18 "2023-11-05T03:30:48Z")

</div>

If the source data is in user specific columns, then that could potentially result in an empty set of mutations, depending on which user you were triggering the action as.

> [@Airbid](#):
>
> When I try to copy the body over to the text field in a separate automation step, it fails to do so.

That certainly suggests that something isn’t right somewhere.

At this point, I’m not really sure. I think I’d need to see this in front of me to be able to troubleshoot further.

---

<div class="post-metadata">

**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\
**Post date:** [November 5, 2023, 7:32am UTC](https://community.glideapps.com/t/glide-apps-api-availability-to-business-trial/67540/19 "2023-11-05T07:32:57Z")

</div>

@Airbid just now I’m working with the api to add rows. I think there is kind of a bug when you get the API info for the table to grab the column ids. It looks like you use the default column ‘name’. I just deleted that column and created it again and then the column gets a real id