Forum Discussion

ashutosh's avatar
ashutosh
Occasional Contributor
6 years ago

Save API Response as Excel for Content-Type: application/ms-excel

Hi ,    I have an API whose Raw Response is as below    Request : GET {URL}?isActiveUser=true HTTP/1.1    Raw Response :  HTTP/1.1 200 OK Cache-Control: private Transfer-Encoding: chu...
API Response MS Excel
  • NBorovykh's avatar
    NBorovykh
    6 years ago

    ashutosh,

     

    Here is just a quick tip for you: saving a response content to a file can be done with the "Create File" step:

     

    (the actual content has the html format rather than xls so Excel shows the warning when opening the file, but still can open it)

     

Olga_T's avatar
Olga_T
SmartBear Alumni (Retired)

richie , thanks for looking into this.

 

ashutosh, have you managed to find a solution? If so, could you please share it?

 

NBorovykh's avatar
NBorovykh
Moderator
6 years ago

ashutosh,

 

Here is just a quick tip for you: saving a response content to a file can be done with the "Create File" step:

 

(the actual content has the html format rather than xls so Excel shows the warning when opening the file, but still can open it)

 

  • Olga_T's avatar
    Olga_T
    SmartBear Alumni (Retired)
    6 years ago

    Thanks for the tip, Natalie!

    ashutosh , does any of the above help?
    We are looking forward to hearing from you.

     

  • ashutosh's avatar
    ashutosh
    Occasional Contributor
    6 years ago

    unfortunately i havent gotten time to look into this and have been pulled into something else. 

    I will make sure to look into the valuable suggetions and post it on this thread.

  • TanyaYatskovska's avatar
    TanyaYatskovska
    SmartBear Alumni (Retired)
    6 years ago

    Hi ashutosh,

    Take your time. In the meantime, let me mark Natalie's reply as a solution.