Hi Jim, The reporting service is not a SOAP service -- it's simply an HTTP service with a specific set of parameters and headers (see the Reporting Basics guide <https://developers.google.com/adwords/api/docs/guides/reporting#http-request> ).
Also, the report query you are issuing is not valid for a few reasons: 1. *Name* is not a valid field name for the Keywords Performance Report - see the report's field list here <https://developers.google.com/adwords/api/docs/appendix/reports#keywords> 2. Your AWQL statement is missing a *DURING* clause - see the AWQL guide <https://developers.google.com/adwords/api/docs/guides/awql> 3. The AWQL statement should be passed in the __rdquery parameter as specified in the *Reporting Basics guide*. Please take a look at the links I mentioned and then post back if you're still having trouble. Thanks, Josh, AdWords API Team On Friday, November 14, 2014 3:04:00 PM UTC-5, James Randell wrote: > > Help me AdWords API Forum, you my only hope.... > > Hello All, > I hope someone can help me make this work. I have worked hard for several > days to get as far as I could before asking for help. > I hope the format and verbosity of this post makes things more clear and > not less. > > All Calls I Make On This Project Will Be Read-Only! > > > *MY ENVIRONMENT:* > I am in a constrained environment. I am sending calls from FileMaker. > (I have successfully scripted the OAuth2 procedure!!!) > > 1. I can only indicate a method (POST, PUT, GET, etc), then provide a > single string as a URI. > - Example: here is my call to refresh my token: > - https://accounts.google.com/o/oauth2/token?POST=/o/oauth2/token > HTTP/1.1&Host=accounts.google.com > &Content-Type=application/x-www-form-urlencoded&client_id= > xxxxxxx.apps.googleusercontent.com > > &client_secret=xxxx-xxxxxxxx_&refresh_token=1/xxxxxxxxxxxxx&grant_type=refresh_token > 2. I can encode any part, or all of the the string > > > > > *MY TEST CALL: *I am sending this to a test account! > (I am open to test with anything to start with): > > 1. *The URL and headers* (returns inserted for clarity) > - > > https://adwords.google.com/api/adwords/cm/v201409/ReportDefinitionService > ? > POST=/api/adwords/cm/v201409 HTTP/1.1& > Host=adwords.google.com& > clientCustomerId=111-222-3333& > Content-Type=application/soap+xml& > Authorization=Bearer > xxx.xxxx-xxxxxxxxxxxxxxxxxxxxxxxxx_xxxxxxxxxxxxxxxxxxxxxx& > developerToken=xxxxxxxxxxxxxxxxx& > 2. *The SOAP Envelope* *(I have validated this XML*) > - <?xml version="1.0" encoding="utf-8"?> > <SOAP-ENV:Envelope xmlns:SOAP-ENV=" > http://schemas.xmlsoap.org/soap/envelope/"; xmlns:google=" > https://adwords.google.com/api/adwords/v2"; xmlns:xsd=" > http://www.w3.org/2001/XMLSchema"; xmlns:wsdl=" > https://adwords.google.com/api/adwords/cm/v201409"; xmlns:xsi=" > http://www.w3.org/2001/XMLSchema-instance";> > <SOAP-ENV:Header> > <RequestHeader xmlns=" > https://adwords.google.com/api/adwords/cm/v201409";> > <clientCustomerId>xxx-xxx-xxx</clientCustomerId> > <developerToken>xxxxxxxxxxxxxxx</developerToken> > <userAgent>xxxxxxxxxxxxxx</userAgent> > <validateOnly>false</validateOnly> > <partialFailure>false</partialFailure> > </RequestHeader> > </SOAP-ENV:Header> > <SOAP-ENV:Body> > <query>SELECT+Name+FROM+KEYWORDS_PERFORMANCE_REPORT</query> > </SOAP-ENV:Body> > </SOAP-ENV:Envelope> > 3. *The CALL, *as it is sent from FileMaker (In this case, I have > the Envelope encoded, I have tried it both/many ways) > - > > https://adwords.google.com/api/adwords/cm/v201409/ReportDefinitionService?POST=/api/adwords/cm/v201409 > > > HTTP/1.1&Host=adwords.google.com&clientCustomerId=111-222-3333&Content-Type=application/soap+xml&Authorization=Bearer > > > xxx.xxxx-xxxxxxxxxxxxxxxxxxxxxxxxx_xxxxxxxxxxxxxxxxxxxxxx&developerToken=xxxxxxxxxxxxxxxxx& > > %3C%3Fxml%20version%3D%221.0%22%20encoding%3D%22utf-8%22%3F%3E%3CSOAP-ENV%3AEnvelope%20xmlns%3ASOAP-ENV%3D%22http%3A%2F% > 2Fschemas.xmlsoap.org > %2Fsoap%2Fenvelope%2F%22%20%20xmlns%3Agoogle%3D%22https%3A%2F% > 2Fadwords.google.com > %2Fapi%2Fadwords%2Fv2%22%20xmlns%3Axsd%3D%22http%3A%2F%2Fwww.w3.org > %2F2001%2FXMLSchema%22%20xmlns%3Awsdl%3D%22https%3A%2F% > 2Fadwords.google.com > %2Fapi%2Fadwords%2Fcm%2Fv201409%22%20xmlns%3Axsi%3D%22http%3A%2F% > 2Fwww.w3.org > > %2F2001%2FXMLSchema-instance%22%3E%3CSOAP-ENV%3AHeader%3E%3Cwsdl%3ARequestHeader%20xmlns%3D%22https%3A%2F% > 2Fadwords.google.com > > %2Fapi%2Fadwords%2Fcm%2Fv201409%22%3E%3CclientCustomerId%3Exxx-xxx-xxx%3C%2FclientCustomerId%3E%3CdeveloperToken%3Exxxxxxxxxxxxxxxxxxxx%3C%2FdeveloperToken%3E%3CuserAgent%3Exxxxxxxxxxxxx%3C%2FuserAgent%3E%3CvalidateOnly%3Efalse%3C%2FvalidateOnly%3E%3CpartialFailure%3Efalse%3C%2FpartialFailure%3E%3C%2Fwsdl%3ARequestHeader%3E%3C%2FSOAP-ENV%3AHeader%3E%3CSOAP-ENV%3ABody%3E%3Cquery%3ESELECT%2BName%2BFROM%2BKEYWORDS_PERFORMANCE_REPORT%3C%2Fquery%3E%3C%2FSOAP-ENV%3ABody%3E%3C%2FSOAP-ENV%3AEnvelope%3E > > > > *MY RESULTS:* > (Using the example call above) > > 1. *Result when sent from inside FileMaker:* > - <soap:Envelope xmlns:soap=" > http://schemas.xmlsoap.org/soap/envelope/";> > <soap:Body> > <soap:Fault> > <faultcode>soap:Client</faultcode> > <faultstring>XML_STREAM_EXC</faultstring> > </soap:Fault> > </soap:Body> > </soap:Envelope> > 2. *Result when sent from Chrome *(Version 38.0.2125.122) OSX > (10.10 Yosemite) > - <soap:Envelope xmlns:soap=" > http://schemas.xmlsoap.org/soap/envelope/";> > <soap:Body> > <soap:Fault> > <faultcode>soap:Server</faultcode> > <faultstring> > No such operation: (HTTP GET PATH_INFO: > /v201409/ReportDefinitionService) > </faultstring> > </soap:Fault> > </soap:Body> > </soap:Envelope> > 3. *Not sure why, but sometimes I get result 2, when I run it > inside filemaker* > > > Thanks again for the help, > -Jim > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 http://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/ace3b7fb-a14a-4bdd-8ebc-ca36dc420a49%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
