cancel
Showing results for 
Search instead for 
Did you mean: 

Download Excel file as a response from Open Api 3

SOLVED
Highlighted
New Contributor

Download Excel file as a response from Open Api 3

 

I am editing in editor.swagger.io

How can I download response from API locally which is a excel file?

My snippet -

responses:
        200:
          description: "JSON to Excel conversion succeeded"
          content:
            application/vnd.ms-excel:
              schema:
                type: string
                format: binary

I get server response of 200 saying

😱 Could not render this component, see the console

In console the response headers are -

cache-control: public, max-age=0

content-length: 8515

content-type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

expires: Tue, 10 Dec 2019 15:14:55 GMT

I want to save excel file locally.

Tags (2)
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
New Contributor

Re: Download Excel file as a response from Open Api 3

Ok figured out. Have to expose content disposition header in the server code. It resolves for MIME types such as xlsx.

View solution in original post

1 REPLY 1
Highlighted
New Contributor

Re: Download Excel file as a response from Open Api 3

Ok figured out. Have to expose content disposition header in the server code. It resolves for MIME types such as xlsx.

View solution in original post

New Here?
Join us and watch the welcome video:
Top Kudoed Authors
Top Kudoed Posts