I have an rjob that works if it is reading from a local file, but as soon as I try changing it so that the user can upload that same spreadsheet I end up failing. I’ve tried a bunch of different things that were suggested by claude and ChatGPT but with no luck.
This is the Endpoint Configuration:
This is the Spreadsheet reader:
I have gotten this to work in the past with a csv file and a universal data reader, but what the users will be uploading is an xlsx where the data is on the 2nd sheet. (Right now for this test I just have one sheet on the upload since it was not reading the 2nd sheet. I thought maybe if the upload just had one sheet I could get that to work and go from there.)
I feel like this is something simple I am missing, so any pointers would be appreciated.
Thank you,