When using the supabase node I am pulling an int8 from supabase and it is adding 000 to the end of the number, in this case it is video_uid
Please share your workflow
I cant share the workflow because i have keys exposded but I will provide a snippet of the output directly from the supabase get many rows node.
I have tried to use a set node to go to a string after pulling the rows but the 000 stays the same.
The other numeric values do not have this I see.
Are we sure it is not something to do with the field you have in supabase? Doesn’t make any sense for the n8n node to add it. Normally nodes are not really doing any data transformation.
You are correct, it is just the video UID. I had a similar problem with Airtable and UIDs (i was just using numbers not an official UID) when I would update a number field inside Airtable. Once I changed the Airtable field to a text field the issue went away so I assumed it was Airtable. That was on a cloud account now I am self hosted. Now it is happening inside the Supabase node. I have replicated it a few times and it seems to be very consistent with 000.
I tried changing the video_uid field from int4 to int8 and I got the same issue.
I must have something wrong but chatgpt and I can not figure out what haha.
So at the moment I am not changing them at all, I am just calling the database using the get many rows node. Then the node returns the video_ids with the extra 000 added to the end.
That’s fine I have many other things to do anyway
I am working on an edge function for supabase just using the CLI and I am having the same issue. When pulling the video_uid in it is adding 000 to each UID.
video_caption: ‘I don’t really like this vid but i love my makeup so eh here’,
video_caption: 'New Ada design got me like #residentevil#residentevil4#re4remake#ada#adawong#adawongcosplay ',
Perhaps you can query such Supabase data using Postgresql, and then cast the value into a text in your SELECT query? This should prevent any JS-specific problems with large numbers.
What is the best way to do this? I have converted the column to text to get around it for now but for future reference, is there a way to directly query using PostgreSQL inside n8n? Or am I best just keeping it as a text field?