Good Afternoon Googlers, I am experiencing problems using GZIPPED_XML report output format. Cannot open programmatic or with WinRAR, so worried that for very large reports I will have to download without compression.
SOAP Request Info: POST https://adwords.google.com/api/adwords/reportdownload/v201309 HTTP/1.1 User-Agent: name(gzip) Authorization: Bearer valid token clientCustomerId: 111222333 developerToken: mytoken returnMoneyInMicros: true Content-Type: application/x-www-form-urlencoded Accept-Encoding: gzip, deflate Host: adwords.google.com Content-Length: 406 __rdquery=SELECT Date, AdNetworkType1, CampaignId, CampaignName, AdGroupId, AdGroupName, CityCriteriaId, MostSpecificCriteriaId, CountryCriteriaId, LocationType, MetroCriteriaId, RegionCriteriaId, Impressions, Clicks, Cost,AverageCpc, Ctr, Conversions, ConversionValue, ConversionsManyPerClick, CostPerConversion FROM GEO_PERFORMANCE_REPORT WHERE Impressions > 0 DURING 20131105,20131105&__fmt=GZIPPED_XML SOAP Reply Info: HTTP/1.1 200 OK Content-Type: application/x-gzip; charset=UTF-8 Content-Length: 2341277 Content-Disposition: /tmp/reportId-null8184361572148321072.tmprpt.xml.gz Date: Wed, 13 Nov 2013 19:30:01 GMT Expires: Wed, 13 Nov 2013 19:30:01 GMT Cache-Control: private, max-age=0 X-Content-Type-Options: nosniff X-Frame-Options: SAMEORIGIN X-XSS-Protection: 1; mode=block Server: GSE When I use XML - everything works as designed: SOAP Request Info: POST https://adwords.google.com/api/adwords/reportdownload/v201309 HTTP/1.1 User-Agent: name Authorization: Bearer valid token clientCustomerId: 111222333 developerToken: my token returnMoneyInMicros: true Content-Type: application/x-www-form-urlencoded Host: adwords.google.com Content-Length: 398 Connection: Keep-Alive __rdquery=SELECT Date, AdNetworkType1, CampaignId, CampaignName, AdGroupId, AdGroupName, CityCriteriaId, MostSpecificCriteriaId, CountryCriteriaId, LocationType, MetroCriteriaId, RegionCriteriaId, Impressions, Clicks, Cost,AverageCpc, Ctr, Conversions, ConversionValue, ConversionsManyPerClick, CostPerConversion FROM GEO_PERFORMANCE_REPORT WHERE Impressions > 0 DURING 20131111,20131111&__fmt=XML SOAP Reply Info: HTTP/1.1 200 OK Content-Type: application/xml; charset=UTF-8 Content-Disposition: /tmp/reportId-null2282794618592806704.tmprpt.xml Date: Wed, 13 Nov 2013 19:50:38 GMT Expires: Wed, 13 Nov 2013 19:50:38 GMT Cache-Control: private, max-age=0 X-Content-Type-Options: nosniff X-Frame-Options: SAMEORIGIN X-XSS-Protection: 1; mode=block Server: GSE Transfer-Encoding: chunked Using homegrown software since 2006. Figure this is a break - since I have same issue when running in client lib (.NET). My code looks like: 'Directory work Dim sFileName As String If Not Directory.Exists(SavePath) Then Directory.CreateDirectory(SavePath) Dim myDir As String = Me.GetMyDir(client) If Not Directory.Exists(myDir) Then Directory.CreateDirectory(myDir) 'File naming conventions work Dim myFile As String = "" If client.Google.MultiDayReport Then myFile = "GGEOM_" & Replace(client.Name, " ", "") & client.Google.EndDate.ToString("_yyyy_MM_dd") & ".xml" Else myFile = "GGEOD_" & Replace(client.Name, " ", "") & client.Google.EndDate.ToString("_yyyy_MM_dd") & ".xml" End If sFileName = myDir & myFile Dim ReportID As String = "0" Dim myID As Integer = 0 Dim myVID As Integer = 0 Dim request As HttpWebRequest = DirectCast(WebRequest.Create(URL), HttpWebRequest) request.UserAgent = Useragent 'request.UserAgent = Useragent & "(gzip)" 'request.Headers.Add("Accept-Encoding: gzip, deflate") 'Dim webRequest As WebRequest = HttpWebRequest.Create(URL) request.Headers.Add("Authorization: Bearer " + Token) request.Headers.Add("clientCustomerId: " + client.Google.GGLClientID) request.Headers.Add("developerToken: " + DevToken) request.Headers.Add("returnMoneyInMicros: true") request.Method = "POST" request.ContentType = "application/x-www-form-urlencoded" Dim postParams As String = "__rdquery=SELECT Date, AdNetworkType1, CampaignId, CampaignName, AdGroupId, AdGroupName, CityCriteriaId, MostSpecificCriteriaId, " & _ "CountryCriteriaId, LocationType, MetroCriteriaId, RegionCriteriaId, Impressions, Clicks, Cost,AverageCpc, Ctr, Conversions, ConversionValue, " & _ "ConversionsManyPerClick, CostPerConversion FROM GEO_PERFORMANCE_REPORT WHERE Impressions > 0 " & _ "DURING {0},{1}&__fmt=XML" postParams = String.Format(postParams, client.Google.StartDate.ToString("yyyyMMdd"), client.Google.EndDate.ToString("yyyyMMdd")) Dim postBytes As Byte() = Encoding.UTF8.GetBytes(postParams) request.ContentLength = postBytes.Length Dim strmReq As Stream = request.GetRequestStream() strmReq.Write(postBytes, 0, postBytes.Length) strmReq.Close() Dim response As WebResponse = Nothing Try 'Attempt to get XML Report response = request.GetResponse() Catch ex As Exception 'Had problems with API - return an error indicator Log("GOOGLE ERROR ON " & client.LogName(True) & ex.Message) If myID = 0 And myVID = 0 Then Return "ERROR" End Try Dim responseStream As Stream = response.GetResponseStream() Dim reader As New StreamReader(responseStream) Dim sresponseString As String = reader.ReadToEnd() 'Write to file Dim sw As StreamWriter sw = New StreamWriter(sFileName) sw.Write(sresponseString) sw.Dispose() Return "GOOD" 'GZIP Shit 11/12/2013 'Dim dir As String = Path.GetDirectoryName(sFileName) 'Dim decompressionFileName As String = Path.Combine(myDir, Path.GetFileNameWithoutExtension(sFileName)) 'Using instream As New GZipStream(File.OpenRead(sFileName), CompressionMode.Decompress) ' ' ArgumentException... ' Using outputStream As New FileStream(decompressionFileName, FileMode.Append, FileAccess.Write) ' Dim bufferSize As Integer = 8192, bytesRead As Integer = 0 ' Dim buffer As Byte() = New Byte(bufferSize - 1) {} ' While ((bytesRead = instream.Read(buffer, 0, bufferSize)) > 0) ' outputStream.Write(buffer, 0, bytesRead) ' End While ' End Using 'End Using 'UnZipFile(client.Google.ReportID, myDir, myFile, True) 'Return "GOOD" All suggestions welcome and have a wonderful day. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://googleadsdeveloper.blogspot.com http://groups.google.com/group/adwords-api =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
