Hello, "Containing all available columns" is not well-defined, because the set of available columns differs depending on which report type is being used. In general the report XML will follow the pattern of the empty report returned from the sandbox; there will be a series of <column> elements with a name attribute set to the response column name, and then a <rows> container element that contains a series of <row> elements with the actual values as attributes. Here's a sample row that includes columns that you might find in an Ad Group Account Structure report:
<row campaignid="13435039" adgroupid="681950138" adgroup="Test Group" agStatus="Enabled"></row> Cheers, -Jeff Posnick, AdWords API Team On Aug 26, 12:35 pm, y2beck <[EMAIL PROTECTED]> wrote: > Thank you, Jeff. > > I'm not sure if I am able to access a live production report at this > point. Do you or anyone else have a mocked up XML data set containing > all available columns? I can then jam it into my app and move on. > > Thanks > > On Aug 26, 12:14 pm, AdWords API Advisor > > <[EMAIL PROTECTED]> wrote: > > Yes... that's unfortunately a longstanding issue. I'd recommend just > > using the Sandbox report's service as a way of testing your scheduling/ > > retrieval code, and if you need to exercise your report parsing code > > to inject a real report (scheduled via the web interface or the > > Production AdWords API) into your workflow and go against that. > > > Cheers, > > -Jeff Posnick, AdWords API Team > > > On Aug 25, 10:18 pm, y2beck <[EMAIL PROTECTED]> wrote: > > > > Hello, > > > > Can someone guide me on returning random data when using Report > > > Service via Sandbox? I keep getting an empty XML data set. > > > > See the returned XML below. > > > > Thanks > > > > <report> > > > <table> > > > <columns> > > > <column name="campaign"/> > > > <column name="adgroup"/> > > > <column name="agStatus"/> > > > <column name="imps"/> > > > <column name="clicks"/> > > > <column name="ctr"/> > > > <column name="cpc"/> > > > <column name="cost"/> > > > <column name="pos"/> > > > </columns> > > > <rows/> > > > </table> > > > <totals> > > > <grandtotal imps="0" clicks="0" ctr="0.0" cpc="0" cost="0" pos="0.0"/> > > > </totals> > > > </report>- Hide quoted text - > > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en -~----------~----~----~----~------~----~------~--~---