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?
3 Replies
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.
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.