Grid not showing all rows returned for Thingworx 9.6

[JO_9930585]

I have verified that the service is returning 24 rows of data, but when viewing the mashup, only 4 rows display. Oddly enough, even in the mashup designer, inside the grid widget, it shows all of the data coming in correctly. Has this problem been seen before? I even tried creating a new mashup and new grid and re-binding everything. It is the same result. Clearly, the Chrome dev tools network tab shows 24 rows being returned, but only the last 4 are displayed in the grid for some reason.

[JO_9930585 · Accepted solution]

The issue is the property IDFieldName is defaulted to "id" and I have a column named "id". This seems to override any primary key on the datashape, and thus it was only displaying 1 row for every id that exists. Interestingly it shows in composer just fine. The solution is to remove the "id" from this property.