API Response Encoded as Gzip

uday_guntupalli

All, 

  I am tapping an internal API and the expected response of the API endpoint is an Excel File. However, when I try to  use HTTP request, I receive a response. I am assuming the response is encoded, but I wonder what is a good way to extract the data and use it. 

 The request I make to the endpoint is as follows: 

HeaderStr = "Authorization: Bearer " || AccessToken;
Request = New HTTP Request(
			    URL( URLDes ),
		            Method( "Get" ),
			    Headers( {HeaderStr} )
			  ) << Send;

The response I receive is : 

 

"PK"

 

 

Craige_Hales

Not sure how to get a blob back from <<send, but <<download puts the binary data in a file:

request = New HTTP Request(
    URL(
        "http://drawoutside.com/abc123.xlsx"
    ),
    Method( "Get" )
);
request<<download("$temp/z.xlsx");
open("$temp/z.xlsx");

JMP's open function imported the xlsx file

@bryan_boone