protoys
protoys11mo ago

Fetching and Incrementing the highest number from a column?

Hi, since SupaBase keeps overwriting existing rows when creating a new item in my table, I decided to feth the highest ID of that table first, increment it by 1, and output it in buildship for further use in row creation and updating. Unfortunately, I only receive a 200 with {}. I am quite new to the scene. Can anyone spot what I am doing wrong?
No description
3 Replies
protoys
protoys11mo ago
please note that this node is AI generated. I stumbled upon the inconsistent use of quotation marks, ticks, and back ticks but I don't even know if this is intentional.
protoys
protoys11mo ago
ok... this is a bit embarassing but I simply used the wrong SupaBase URL (including /rest/v1). Fixed that and works like a charm. Thanks to everyone who took the time to read this.