jQuery addClass example

Change class name on click in jQuery

by Daniil464

HTML

<?xml version="1.0" encoding="UTF-8"?>
<issues total_count="210" offset="0" limit="25" type="array">
   <issue>
      <id>22079</id>
      <project id="21" name="name1" />
      <description>Some text</description>
      <start_date>2017-11-24</start_date>
      <custom_fields type="array">
         <custom_field id="36" name="cf_l6">
            <value>cf_3kl6_value</value>
         </custom_field>
         <custom_field id="28" name="cf_28">
            <value>cf_28_vajnklue</value>
         </custom_field>
      </custom_fields>
   </issue>
</issues>

JavaScript

function fn(sheet){
  
  var res = [];
  
  var xml = HtmlService.createHtmlOutputFromFile('xml').getContent();
  var doc = XmlService.parse(xml);
  var issues = doc.getRootElement().getChildren();
  for(var i = 0; i < issues.length; i++){
    var issue = issues[i];
    var custom_fields = issue.getChild('custom_fields').getChildren();
    for(var j = 0; j < custom_fields.length; j++){
      var custom_field = custom_fields[j];
      if(custom_field.getAttribute('id').getValue() === '28' && 
         custom_field.getAttribute('name').getValue() === 'cf_28')
        res.push([custom_field.getValue()]);
    }
  }
  
  sheet.getRange(sheet.getLastRow() + 1, 1, res.length, res[0].length).setValues(res);
  
}
alert (xml)