Does Azure Assistant API code_ interpreter takes other form of data input apart from file_ids?

Question

I am using Azure Assistants API as code_interpreter and wanted to know about what are other options/parameters I could use to pass data to Azure Assiatants API, does it always need to be file_ids? The data I want to pass to Assitants is stored in SQL Server, what are the steps I should take to ingest data from SQL Server to Azure Assistants API, apart from creating file_ids?
I am following this doc doc

Answer 1

Hi @Karishma Nanda

Thank you for using the Microsoft Q&A platform.

The file_ids parameter is required to give tools like code_interpreter access to files. When using the File upload endpoint, you must have the purpose set to assistants to be used with the Assistants API.

Files can be uploaded via Studio or programmatically using the File upload endpoint. When using the File upload endpoint, you must have the purpose parameter set to assistants to be used with the Assistants API.

If you have data stored in SQL Server, you can ingest it into Azure Assistants API. To ingest data from SQL Server into Azure Assistants API, begin by retrieving the desired data through SQL queries. Optionally, transform the data to fit the API's requirements and its supported file types. Then, pass the prepared data to the API using suitable parameters, including direct Rest API requests. Finally, invoke the Azure Assistants API with the prepared data to execute desired tasks like generating visualizations or responding to queries.

I hope the provided details help you in your particular use case. Thank you.