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
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
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