XML parser example

[Daniel Malý]

Hello

 I have tried example AdWords Script for work with XML. Only one change is added "function main()". But it does not work - no warning, only no results. My script:

function main() {

  function parseXml() {

  // Load an XML representation of your campaigns.

  var xml = [

      '<?xml version="1.0" encoding="UTF-8"?>',

      '<campaigns>',

        '<campaign id="28632346">Placement Campaign 1</campaign>',

        '<campaign id="28780216">Campaign #14</campaign>',

        '<campaign id="29606506">LotsOfExclusion</campaign>',

      '</campaigns>'

  ].join('');

  var document = XmlService.parse(xml);

  var root = document.getRootElement();

  var entries = document.getRootElement().getChildren('campaign');

  for (var i = 0; i < entries.length; i++) {

    var id = entries[i].getAttribute('id').getValue();

    var name = entries[i].getText();

    Logger.log('%s) %s (%s)', (i + 1).toFixed(), name, id);

  }

}

}

What is wrong?

[Anash Oommen]

Hi Daniel,

You have to call the method.

function main() {
  parseXml();

}


function parseXml() {

  // Load an XML representation of your campaigns.
  var xml = [
      '<?xml version="1.0" encoding="UTF-8"?>',
      '<campaigns>',
        '<campaign id="28632346">Placement Campaign 1</campaign>',
        '<campaign id="28780216">Campaign #14</campaign>',
        '<campaign id="29606506">LotsOfExclusion</campaign>',
      '</campaigns>'
  ].join('');


  var document = XmlService.parse(xml);
  var root = document.getRootElement();


  var entries = document.getRootElement().getChildren('campaign');
  for (var i = 0; i < entries.length; i++) {
    var id = entries[i].getAttribute('id').getValue();
    var name = entries[i].getText();
    Logger.log('%s) %s (%s)', (i + 1).toFixed(), name, id);
  }
}

Cheers,
Anash P. Oommen,
AdWords Scripts Team

[Daniel Malý]

Hi

Thanx - stupid mistake :)

Do you have any example for work with external XML file? Import and parse it.

 

Dne úterý, 20. května 2014 22:52:02 UTC+2 Anash Oommen napsal(a):

[Anash Oommen]

Hi Daniel,

UrlFetchApp can be used to fetch an external Xml file as string, then use a modified version of parseXml to parse it.

See https://developers.google.com/apps-script/reference/url-fetch/url-fetch-app#fetch(String) for examples.

Cheers,
Anash