How to send excel file in multipart/form-data with POST Requests in python?

Question

I am trying to send an excel file to server in POST Request in multipart/form-data content-type. I am getting an error:

too many values to unpack

What could be the reason? Below is the request what I am trying:

#Data = get_data('C:\foo.xls')
#print Data
Data = open('C:\foo.xls', 'rb')
print Data

headers = {
       'access-control-allow-origin': '*',
       'accept': 'application/json',
       'content-type': 'multipart/form-data', 
       'authorization': 'Basic xxxxxxxxx'
      }   
 R = requests.post('http://testserver:8080/v1/readyapi/executions/'+executionId+'/files', headers=headers, params=params, files=Data)
 print R.content

here is the error:

Traceback (most recent call last):
    (body, content_type) = self._encode_files(files, data)
  File "C:\Python27\lib\site-packages\requests\models.py", line 132, in _encode_files
    for (k, v) in files:
ValueError: too many values to unpack

I could not figure out by myself. tried few things, didn't work. Can someone please advise?

anjaneyulubatta505 · Accepted Answer · 2017-05-01 16:33:36Z

2

Try the following code

Data = open('C:\foo.xls', 'rb') 
headers = {
       'access-control-allow-origin': '*',
       'accept': 'application/json',
       'content-type': 'multipart/form-data', 
       'authorization': 'Basic xxxxxxxxx'
      }
 files = {"file_name": Data}
 url = 'http://testserver:8080/v1/readyapi/executions/'+executionId+'/files'
 R = requests.post(url, headers=headers, params=params, files=files)
 print R.content

You must have to pass the files argument as a dictionary or you can also try like below

files = {'file': ('foo.xls', open('foo.xls', 'rb'), 'application/vnd.ms-excel', {'Expires': '0'})}

Reference: http://docs.python-requests.org/en/master/user/quickstart/#post-a-multipart-encoded-file

edited May 1, 2017 at 16:33

answered May 1, 2017 at 15:29

anjaneyulubatta505

11.9k1 gold badge61 silver badges68 bronze badges

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

1 Comment

Meet101 Over a year ago

Tried it. Getting "Bad Request" <p>Problem accessing /v1/readyapi/executions/4d1c7e9b-55c8-4c9b-8f91-42aec0c29a37/files. Reason: <pre> Bad Request</pre></p>

lopof · Accepted Answer · 2021-12-21 07:34:02Z

0

Try this, right MIME type is important (https://wiki.selfhtml.org/wiki/MIME-Type/%C3%9Cbersicht)

headers = {
       'access-control-allow-origin': '*',
       'accept': 'application/json',
       'content-type': 'multipart/msexcel', 
       'authorization': 'Basic xxxxxxxxx'
      }

answered Dec 21, 2021 at 7:34

lopof

1

Collectives™ on Stack Overflow

How to send excel file in multipart/form-data with POST Requests in python?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related