Hi Team,
I am trying to pull a report from Adwords by API calls using *Excel VBA
with Windows HTTP request.*
But I am arriving at below error:
*<?xml version="1.0" encoding="UTF-8"
standalone="yes"?><reportDownloadError><ApiError><type>ReportDownloadError.MISSING_PARAMETER</type><trigger>Missing
report
definition</trigger><fieldPath></fieldPath></ApiError><ApiError><type>ReportDownloadError.INVALID_PARAMETER</type><trigger>Missing
client
information</trigger><fieldPath></fieldPath></ApiError></reportDownloadError>*
and the code i tried as below
Sub TestAPI()
Dim objHTTP As Object
Dim result As String
Dim Xml As Variant
Dim Fs As FileSystemObject
Dim FileData() As Byte
Dim Arr() As String
Dim St As String
Set objHTTP = CreateObject("MSXML2.ServerXMLHTTP")
URL = "https://adwords.google.com/api/adwords/reportdownload/v201509";
objHTTP.Open "POST", URL, False
objHTTP.setRequestHeader "Authorization", "Bearer 3756320"
objHTTP.setRequestHeader "DEVELOPER_TOKEN", "NegtkJjSr7jcrQSdeI4Nzg"
objHTTP.setRequestHeader "CLIENT_CUSTOMER_ID", "328-664-6765"
'objHTTP.RequestBody "__rdxml", Xml
' Set Fs = New FileSystemObject
'Set Xml = Fs.OpenTextFile("C:\Users\ajkumar\Desktop\Shreedhar\New Text
Document.xml")
'St = Xml.ReadAll
' "<fields>Id</fields>" & _
' "<predicates>" & _
"<field>Status</field>" & _
"<operator>IN</operator>" & _
"<values>ENABLED</values>" & _
"<values>PAUSED</values>" & _
"</predicates>" & _
' "<fields>CampaignId</fields>" & _
St = "<reportDefinition xmlns=" & """" &
"https://adwords.google.com/api/adwords/cm/v201509"; & """" & ">" & _
"<selector>" & _
"<fields>Impressions</fields>" & _
"<fields>Clicks</fields>" & _
"<fields>Cost</fields>" & _
"</selector>" & _
"<reportName>Account Performance</reportName>" & _
"<reportType>ACCOUNT_PERFORMANCE_REPORT </reportType>" & _
"<dateRangeType>LAST_7_DAYS</dateRangeType>" & _
"<downloadFormat>CSV</downloadFormat>" & _
"</reportDefinition>"
objHTTP.send St
result = objHTTP.responseText
End Sub
Your guidance and help would be really helpful.
Regards,
Shreedhar Bakale
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeveloper.blogspot.com/
https://plus.google.com/+GoogleAdsDevelopers/posts
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
You received this message because you are subscribed to the Google
Groups "AdWords API Forum" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
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 [email protected].
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/50b7d112-41e3-41cc-84dd-42892ef61629%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
