# Minor bug/inconsistency on API

**URL:** <https://community.glideapps.com/t/minor-bug-inconsistency-on-api/39744>\
**Category:** Report a Bug\
**Created:** [March 16, 2022, 8:38pm UTC](https://community.glideapps.com/t/minor-bug-inconsistency-on-api/39744 "2022-03-16T20:38:14Z")\
**Posts on this page:** 1\
**Showing post:** 10

<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:** [March 18, 2022, 3:00am UTC](https://community.glideapps.com/t/minor-bug-inconsistency-on-api/39744/10 "2022-03-18T03:00:11Z")

</div>

> [@Dan\_San](#):
>
> If there was a read endpoint for GLIDE that would be handy, we only see (ADD, UPDATE, DELETE)

There is, but at the moment it’s only available to Enterprise customers.

> [@Dan\_San](#):
>
> By the way, I now have lots of empty rows in my google sheets. I know how to manually delete the empty rows, but is there an automatic way ?

I use a bit of apps script for this. Here’s an example you could adapt:

```auto
function remove_empty_rows() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName('YOUR SHEET NAME GOES HERE');
  var headers = sheet.getRange(1,1,1,sheet.getLastColumn()).getValues().shift();
  var concat_index = headers.indexOf('CHANGE THIS');
  var uuid_index = headers.indexOf('CHANGE THIS ALSO');
  var data = sheet.getRange(2,1,sheet.getLastRow()-1,sheet.getLastColumn()).getValues();
  var row = sheet.getLastRow();
  while (row > 2) {
    var rec = data.pop();
    var concat = rec[concat_index];
    var uuid = rec[uuid_index];
    if (concat == "" && uuid == "") {
      console.log("deleting row %s", row);
      sheet.deleteRow(row);
    }
    row--;
  }
}

```

Basically with the above, I just picked two columns that I know should never be empty, and if both of them are then the row gets deleted.

> [@Dan\_San](#):
>
> All so if I don’t delete them will it max out the google sheet row limit ?

As long as they don’t contain any formulas, Glide will ignore them and they won’t count.

---

_[View the full topic](https://community.glideapps.com/t/minor-bug-inconsistency-on-api/39744)._