Hi Devesh, Thanks. Confirmed the situation. Escalated a request to fix the fieldType to String.
Best, - Takeshi, AdWords API Team On Saturday, July 27, 2013 3:10:21 AM UTC+9, Devesh Parekh wrote: > > Hi Takeshi, > > Yes, all the values for these ID fields are non-numerical (like "Ireland" > and "Cork"), and you can verify it by running the example query I provided. > According to the documentation, these should be Integers, and I would much > prefer to have the report behave as documented instead of as the way it > currently behaves. > > -- > Devesh > > > On Thu, Jul 25, 2013 at 10:49 PM, Takeshi Hagikura (AdWords API Team) < > adwordsapiad...@google.com <javascript:>> wrote: > >> Hi, >> >> Was there a non numerical value for Id field? >> If not, you can map it to Integers in a programing language. >> Basically the result is returned as CSV or XML as you specified when you >> download a report. >> >> Best, >> - Takeshi, >> >> On Wednesday, July 24, 2013 9:19:34 AM UTC+9, Devesh Parekh wrote: >>> >>> According to https://developers.google.**com/adwords/api/docs/appendix/* >>> *reports#geo<https://developers.google.com/adwords/api/docs/appendix/reports#geo>, >>> >>> CountryCriteriaId and RegionCriteriaId should be Integers, but the when I >>> send an AWQL query to the reportdownload endpoint ( >>> https://adwords.google.com/**api/adwords/reportdownload/**v201306<https://adwords.google.com/api/adwords/reportdownload/v201306>) >>> >>> to return those fields, I get Strings. Example query: SELECT >>> CountryCriteriaId, RegionCriteriaId, Impressions FROM >>> GEO_PERFORMANCE_REPORT DURING 20130101,20130723 >>> >>> Can you make them Integers? >>> >>> -- >>> Devesh >>> >> -- >> -- >> =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ >> Also find us on our blog and discussion group: >> http://adwordsapi.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 adwor...@googlegroups.com<javascript:> >> To unsubscribe from this group, send email to >> adwords-api...@googlegroups.com <javascript:> >> 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 a topic in the >> Google Groups "AdWords API Forum" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/adwords-api/EiGdtzXY30s/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> adwords-api...@googlegroups.com <javascript:>. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> > > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://adwordsapi.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.
