We used assistants API to do analysis on uploaded .xlsx or .csv file before, when i tried to use reponses API, i got error BadRequestError: 400 Invalid input: Expected file type to be a supported format: .pdf but got .xlsx.
does responses API only support PDF file?
You need to create the container, upload your .xlsx file into it, then pass the container to responses API to process.
It is possible to try this on the playground, by adding code interpreter on tools, add your file on it, then proceed to your instructions.
Like “generate a pie chart using the excel file I provided.”
The generated chart will also be in the container.
2 Likes
thanks for sharing. do you have experience of multiple responses create or parse call accessing the same container that hosts the sheet file? all of them read the sheet and no update to the sheet/container. i sometime get container expire error from that and wondering is there a way to parallel some of the tasks
Unlike text or image inputs, a container is ephemeral. It is kept alive for 20 minutes since its last interaction.
It can be reused on the same conversation but if it expires, you will need to start over again.
Each parallel conversation needs a separate container.
Similar to how when you use ChatGPT and asks to generate a file, it vanishes after some time and becomes an invalid link.
1 Like