How to import csv file to QuestDb from Python?

Question

I'm trying to import file to Questdb as REST csv upload. My code looks like

import requests
with open('..\data.csv', 'rb') as f:
    r = requests.post('http://localhost:9000/imp?name=weekly3', files={'data.csv': f})
    print(r.text)

However I get back

{"status":"invalid value in 'Content-Disposition' multipart header"}

I do not see anything wrong with Content-Disposition when I dump the request

POST http://localhost:9000/imp?name=weekly3
Content-Length: 197
Content-Type: multipart/form-data; boundary=23ef3f7581b79898155acd5567e0b455
--23ef3f7581b79898155acd5567e0b455
Content-Disposition: form-data; name="data.csv"; filename="data.csv"
C:\Users\allnau\Downloads\data.csv
--23ef3f7581b79898155acd5567e0b455--

Alex des Pelagos · Accepted Answer · 2021-01-19 09:03:43Z

1

In your files dictionary csv should be under data key.

import requests
with open('..\data.csv', 'rb') as f:
    r = requests.post('http://localhost:9000/imp?name=weekly3', files={'data': f})

As per curl examples, QuestDb accepts data and schema form parts at ?imp endpoint

edited Jan 19, 2021 at 9:03

answered Jan 19, 2021 at 8:55

Alex des Pelagos

1,5959 silver badges12 bronze badges

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

1 Comment

Tomalak Over a year ago

It should be a r'...' string for the path, and the POST should announce the file's encoding.

Collectives™ on Stack Overflow

How to import csv file to QuestDb from Python?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related