troubleshooting Question

MS Access VBA How To Decompress a Gzip Response From a HTTP Request

Avatar of Dustin Stanley
Dustin Stanley asked on
Microsoft AccessHTTP ProtocolVBA
4 Comments1 Solution1208 ViewsLast Modified:
I have finally been able to get a response from a API call and it now sends me back a response which has a Gzip file in it. How can I automate this in VBA to:
1. Decompress this response.
2. Decode it
3. Save it as a file for me to view.

Thanks.

Fiddler Response Raw view looks like this:
Header:
POST https://storage.sandbox.ebay.com/FileTransferService HTTP/1.1
X-EBAY-SOA-SERVICE-NAME: FileTransferService
X-EBAY-SOA-OPERATION-NAME: downloadFile
X-EBAY-SOA-SECURITY-TOKEN: TOKEN CODE HERE
User-Agent: Fiddler
Host: storage.sandbox.ebay.com
Content-Length: 230

<?xml version="1.0" encoding="UTF-8"?>
<downloadFileRequest xmlns="http://www.ebay.com/marketplace/services">
<taskReferenceId>500165386</taskReferenceId>
<fileReferenceId>500147856</fileReferenceId>
</downloadFileRequest>

Response Body:
HTTP/1.1 200 OK
Server: Apache-Coyote/1.1
X-EBAY-SOA-SERVICE-METRICS: 86007804
X-EBAY-SOA-REQUEST-ID: 15b5d9c9-8e30-a471-d2e2-61b2fffb98c2!FileTransferService!10.71.29.46!v3apibulksandboxcore[]
X-EBAY-SOA-SERVICE-VERSION: 1.1.0
X-EBAY-SOA-MESSAGE-PROTOCOL: NONE
X-EBAY-SOA-RESPONSE-DATA-FORMAT: XML
X-EBAY-SOA-OPERATION-NAME: downloadFile
X-EBAY-SOA-SERVICE-NAME: {http://www.ebay.com/marketplace/services}FileTransferService
Content-Type: multipart/related;boundary=MIMEBoundaryurn_uuid_C91296EA5FF69EE9571491924195649953194;type="application/xop+xml";start="<0.urn:uuid:C91296EA5FF69EE9571491924195649953195>";start-info="text/xml"
Date: Tue, 11 Apr 2017 15:23:15 GMT
Content-Length: 11125

--MIMEBoundaryurn_uuid_C91296EA5FF69EE9571491924195649953194
Content-Type: application/xop+xml; charset=utf-8; type="text/xml"
Content-Transfer-Encoding: binary
Content-ID: <0.urn:uuid:C91296EA5FF69EE9571491924195649953195>

<?xml version='1.0' encoding='UTF-8'?><downloadFileResponse xmlns="http://www.ebay.com/marketplace/services"><ack>Success</ack><version>1.1.0</version><timestamp>2017-04-11T15:23:15.649Z</timestamp><fileAttachment><Size>1653</Size><Data><xop:Include xmlns:xop="http://www.w3.org/2004/08/xop/include" href="cid:urn:uuid:85F8FAD0E2DCA2E4881491924926637"/></Data></fileAttachment></downloadFileResponse>
--MIMEBoundaryurn_uuid_C91296EA5FF69EE9571491924195649953194
Content-Type: application/x-gzip
Content-Transfer-Encoding: binary
Content-ID: <urn:uuid:85F8FAD0E2DCA2E4881491924926637>

    X AFPIBulkTest1.xml  Y_o 0G ;X}@ A m u 3`b  n     R  ,|z IڴqZH Ce ~w  > }N  f  4  y   H2.f [ W uZ/»w ^PC n 93   	h 	 
   ( &4}J \?  E j   R
F   _ (ek _ 1'  ^Q Í   A  ^Q*1  e> 2    )   E  /Ig   ^   *        O 4   s   * R4  3?3 ,Dh  Vm\qCاH_|# } y   ; I_ b IO# N Cz1  L jq :R|i x  \  k  ,N " ܋ͳɽ y O Zm/SH   (* pA c D   ^')      /`  A 3ʚ % Ξ 4| , " Z   @" c V3  K Z  $    0 ە'c ŧ< v>t   W:^  Qb   X  J	 b uA   :ʦ ĺ     Bɟ   >  M ;  ` Cj@q74ݽxt   h  $ %  a G~ o> Pe} *]6  [#   3 c  ? 8n i    B    bw  n    5  x 
 ( 
  >  CM] [ 0   tN l    Ɔ* E     } e[ v      8W,4*   + e x 5F Ib@ Ly    R0n'  H6     p=FX^v  Rx Z  AE͉ C   W|Cz^   q   A h    /GH "ءg F }  j)s\  
<  SJ X 8𶛫J9 l ! lZ   % z; ءpM  $
ٹ  < 5   H3 E9 6 :   ˋpn   -Ҷ {  塏Ϡ u9
     vR %   )^ n b 5޻ c If C $2   ʪzx y?  rɸ 3a 
 4  A   ^ C5麛ٍ"XV  .D  !| , *S bgP{I  4 ydף~ y   O| q aK  K p    7 y    [K n  ; o  nab   .<    (N       H    D{LA 
0 /  ,*   *W7 +    &  z m ]]   N  <M #  Pa I C U 
 !b$c^	 \ ;      ^-   4+ ӡ  e
  {x| f E+  pW 7  Qޗ L  ^Z`{I
* \ >> . _| qv*    A   ݬ(1s  Ѧ-T? 	L  	   `	 C  M "%213i	 1)] Xl  h  )   8 }  YL Ԛ&   ^ =   >RR  ߕ  B   2#  " 
<     ]  ! -_ٓf㮈\   h  0 I  .            6GI @     I.O  T  c   
.
  ZK   ۻf咎  }  @5^  } Zp   -  "  ][_ y O  e i   s  m  '  :eS    |    fT W  i - G7{ r b   -  e     V w V  G* !r  	 N h  E  *En Y x҄ }9 %b .   o. Dt m  ~ 3  -  7  nk b"ф *- WV W x g   
a  
ye '      # 
Uz(X7                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
--MIMEBoundaryurn_uuid_C91296EA5FF69EE9571491924195649953194--
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros