How to Have Assistant use an uploaded file in a function?

API
,
1

Simple question, I uploaded a CSV file to my assistant. Now, when my assistant requires action and calls my function find_matching_columns(), I need this function to use the uploaded CSV file and then open it with Pandas. But I can’t get the function to access and pull this uploaded file! Please help, I assume it’s via the file id!

def find_matching_columns(query, file_id, client):
    # HOW DO I LOAD THE FILE_ID INTO PANDAS
    file_content = client.files.retrieve(file_id)
    df = pd.read_csv(io.StringIO(file_content.decode('utf-8')))
    column_names = df.columns.tolist()

file = client.files.create(
    file=open('data/ap_mock_data.csv', 'rb'),
    purpose='assistants'
)
file_id = file.id

assistant = client.beta.assistants.create(
    name=assistant_details['name'],
    instructions=assistant_details['instructions'],
    model=assistant_details['model'],
    tools=assistant_details['tools'],
    tool_resources={"code_interpreter": {"file_ids": [file.id]}},
)

message = client.beta.threads.messages.create(
    thread_id=thread.id,
    role="user",
    content=user_message_content,
    attachments=[
       {
          "file_id": file.id,
          "tools": [{"type": "code_interpreter"}]
       }
    ]
)
2

Unfortunately, this will not work. As far as I experienced, files uploaded to OpenAI are not available for download in any manner. They can be attached to code interpreter or file search and used internally, but that’s it. You can’t use OpenAI’s file server as your own personal storage. If you can make the file available locally to your users, you can try to implement a lookup system as an additional function.

4

That only works with generated files though. Files uploaded by the user cannot be downloaded as far as I know. Has this changed recently?