How to call FastAPI file upload route [duplicate]

Question

I have written FastAPI to upload a file but in my new requirement, I have to create CLI to upload a file for that I am calling route function.

@app.post("/uploadfile/")
async def create_upload_file(file: Uploadfile =File(...));
      pd.DataFrame = pd.read_csv(file.file)
      return True

create_upload_file(file=UploadFile(input_file_path))

when i tried to read that file like : claims: pd.DataFrame = pd.read_csv(file.file) i am getting following error

No columns to parse from file

try this pd.DataFrame = pd.read_csv(file.file, delim_whitespace=True) — Yagiz Degirmenci
– Yagiz Degirmenci, Commented Jul 31, 2020 at 19:38
INSURANCE NAME,PATIENT NAME,INSURANCE ID, DATE OF BIRTH,CPT, DATE OF SERVICE COMMERCIAL,lastname,firstname,123,06/10/1965,xyz,05/10/2020 — chethankumar MV
– chethankumar MV, Commented Aug 1, 2020 at 5:38
Could it be that you are getting the error due to relative paths that differ between the server and your app? Also, are you running the app with docker or bare metal? — lsabi
– lsabi, Commented Aug 1, 2020 at 12:39

Umang Maheshwari · Accepted Answer · 2021-06-18 03:17:28Z

2

you can read the csv as following:

from io import BytesIO
df = pd.read_csv(BytesIO(file.file.read()))

answered Jun 18, 2021 at 3:17

Umang Maheshwari

613 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Alejo Villores · Accepted Answer · 2024-07-22 18:43:59Z

0

You can try reading and decoding the content from the file and then using pandas to read csv.

from io import StringIO
import pandas as pd

@app.post("/uploadfile/")
async def create_upload_file(file: Uploadfile =File(...)):
      file = StringIO((await file.read()).decode("utf-8"))
      df = pd.read_csv(file)
      return True

answered Jul 22, 2024 at 18:43

Alejo Villores

611 silver badge5 bronze badges

Collectives™ on Stack Overflow

How to call FastAPI file upload route [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related