Excel file post processing with Postman.

I will talk about how to post an excel file with Postman.

Firstly, I will make a post request, so my swagger document shows me that I need a parameter called userid besides the required end point.

To set the userid parameter I go to the params tab and define the required path parameter and assign it the user with id 11.

I go to the Authorisation tab and select the Bearer token that I defined dynamically.

Now I come to the body tab. Here I will tick the form-data option. For Key value I assign the file name as ‘student.xls’ and for Value I select ‘new file from local machine’ and select the relevant file.

I go to the Test tab and write the code to verify the required response.

After I save and send request, I confirm that my test passed.

I hope that was helpful.