Invalid FROM clause

[ankoor]

I get an INVALID_FROM_CLAUSE error when i make the following request, 

SELECT Id,Clicks 
FROM CAMPAIGN_PERFORMANCE_REPORT 
WHERE Id = 107370543 
DURING 20131126,20131128


this is the full request, (minus personal details):

?xml version=1.0 encoding=UTF-8?
env:Envelope xmlns:xsd=http://www.w3.org/2001/XMLSchema; 
xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; 
xmlns:tns=https://adwords.google.com/api/adwords/cm/v201309; 
xmlns:env=http://www.w3.org/2003/05/soap-envelope;
  env:Header
tns:RequestHeader
  tns:developerToken__DEV_TOKEN__/tns:developerToken
  tns:userAgent_AGENT_/tns:userAgent
  tns:clientCustomerId126-XXX-/tns:clientCustomerId
/tns:RequestHeader
  /env:Header
  env:Body
tns:query
  tns:query
SELECT Id,Clicks 
FROM CAMPAIGN_PERFORMANCE_REPORT 
WHERE Id = 107370543 
DURING 20131126,20131128
  /tns:query
/tns:query
  /env:Body
/env:Envelope


Thanks in advance, :)

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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.

Re: Using Ad-Hoc for get report : Missing report definition error

[ankoor]

Hi Paul, 

I'm having the same issue. Could i get some advice on this?

I'm using AWQL, with the following parameters,

  url:https://adwords.google.com/api/adwords/reportdownload/v201309;,
  post_headers: {
developerToken: __DEVELOPER_TOKEN__,
  clientCustomerId: __CLIENT_ID-XXX-XXX-__
  },
  method: post,
  post_body: 
__rdquery=SELECT+Name+FROM+KEYWORDS_PERFORMANCE_REPORT+DURING+20120101,20120625__fmt=CSV



On Monday, October 21, 2013 11:56:40 AM UTC+1, Paul Matthews (AdWords API 
Team) wrote:

 Hi Erkan,

 Can you confirm you still have this problem if you include 
 the includeZeroImpressions parameter?

 Regards,

 - Paul, AdWords API Team.

 On Friday, 27 September 2013 11:20:44 UTC+1, Paul Matthews (AdWords API 
 Team) wrote:

 Hi Erkan,

 Are you including the following parameters:
 __rdquery (or __rdxml) and __fmt ?

 Also, can you ensure you're including all the information specified in the 
 reporting 
 guidehttps://developers.google.com/adwords/api/docs/guides/reporting
 .

 Please see answers to questions below:

 On Wednesday, 25 September 2013 15:12:44 UTC+1, Erkan Ceran wrote:

 1) I use Authorization: Bearer 1/cxx for request headers. Is it 
 right ?

  
 That does indeed appear to be the right format for the Authorization 
 header.

 2) Whats is format of clientCustomerId header ? XX (integer) or  
 XXX-XXX- 
 (string) ? 


 Both formats work when sending them to our servers. 


 Regards,

 - Paul, AdWords API Team.



-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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.