Forum Discussion

Raghav_Gupta's avatar
Raghav_Gupta
New Contributor
5 years ago

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.

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

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