I'm running into an issue when using CSV stream on a csv file located at a publicly accessible URL.
My Xano function works perfectly fine on smaller CSV files, however when I attempt to use a CSV file that is 9 MB (~96k rows with 9 columns) I receive this error:
Whoops! An error occurred.
Exception: Serialization of 'Generator' is not allowed
Things I've tried:
I deleted all but 500 rows on the CSV file and it works.
I've placed the CSV file on a different server / public URL, same error happens.
I uploaded the CSV from my computer to a file resource, same error happens.
I've tried using a file resource input instead of creating the file resource in the function stack, same error happens.
I've tried executing the function via an API endpoint, same error happens.
I used a CSV validator & linter to make sure the CSV is error-free.
Attended StateChange office hours with Ray Deck, he thought it might be a Xano bug.
Chatted with Xano support and provided access to my instance. Waiting to hear back.
Note: I am on a Scale 1x plan which shouldn't have an issue processing a 9 MB file.
When I use Get File Resource Data on the created file resource, it does return the data:
