In Need Of Help - Every Call Fails - but I can at least authenticate...

[James Randell]

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

[Josh Radcliff (AdWords API Team)]

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).

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
2. Your AWQL statement is missing a DURING clause - see the AWQL guide
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

[James Randell]

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