Thank you Josh, this is excellent news, I started down this road as you say, simply using http headers, but kept failing, and I guess I fell down the rabbit whole with SOAP. Reporting is all I need. I am going back to the docs and trying again.
Thank you for your help, I may need more as I double back and find whatever it was that iI tripped over the begin with. Sincerely, -Jim On Monday, November 17, 2014 9:14:26 AM UTC-8, Josh Radcliff (AdWords API Team) wrote: > > 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/ff17754a-4861-4d36-8e20-f058b9486cb3%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
