What is the method to extract the Element Id from XML parsing in Google Apps Script?

Question

What is the method to extract the Element Id from XML parsing in Google Apps Script?

Sample Xml Code

<directory>
 <fieldset>
  <field id="displayName">Display name</field>
  
 </fieldset>
 <employees>
  <employee id="123">
   <field id="displayName">John Doe</field>
   
  </employee>
  <employee id="160">
   <field id="displayName">Jane Doe</field>
   
  </employee>

Using XmlService.parse to retrieve content within each element works fine, but there seems to be an issue with extracting the employee/element id numbers

After running this code snippet:

var roots = document.getRootElement().getChild('employees').getChildren();

The individual elements are retrievable, however, there is difficulty in obtaining the id's

 [[Element: <employee/>], [Element: <employee/>], [Element: <employee/>],...

javascript arrays xml google-apps-script

Answer 1

Answer №1

To extract data from the given xml, you need to retrieve 123 and 160.

  <directory>
    <fieldset>
      <field id="displayName">Display name</field>
    </fieldset>
    <employees>
      <employee id="123">
        <field id="displayName">John Doe</field>
      </employee>
      <employee id="160">
        <field id="displayName">Jane Doe</field>
      </employee>

You can achieve this task using XmlService in Google Apps Script.

Key point:

The script uses roots to fetch employee, allowing you to access the id attribute.

Modified code snippet:

When working with the provided xml data, here is a sample script including the closing tags

</employees></directory>

.

function myFunction() {
  const xml = `<directory>
  <fieldset>
    <field id="displayName">Display name</field>
  </fieldset>
  <employees>
    <employee id="123">
      <field id="displayName">John Doe</field>
    </employee>
    <employee id="160">
      <field id="displayName">Jane Doe</field>
    </employee>
  </employees>
</directory>`;
  var document = XmlService.parse(xml);
  var roots = document.getRootElement().getChild('employees').getChildren();
  var ids = roots.map(e => e.getAttribute("id").getValue());
  console.log(ids);  // [123, 160]
}

Note:

Make sure to run the script with V8 for optimal performance.

If you also wish to retrieve the value of field along with the id of each employee, refer to the additional script below.

  var ids = roots.map(e => ({id: e.getAttribute("id").getValue(), name: e.getChild("field").getText()}));

This will return

[ { id: '123', name: 'John Doe' }, { id: '160', name: 'Jane Doe' } ]

.

Please be cautious if the structure of your actual xml data differs from the provided example, as it may impact the functionality of the modified script.

For more information:

getAttribute(name)

Answer 2

To extract data from the given xml, you need to retrieve 123 and 160.

  <directory>
    <fieldset>
      <field id="displayName">Display name</field>
    </fieldset>
    <employees>
      <employee id="123">
        <field id="displayName">John Doe</field>
      </employee>
      <employee id="160">
        <field id="displayName">Jane Doe</field>
      </employee>

You can achieve this task using XmlService in Google Apps Script.

Key point:

The script uses roots to fetch employee, allowing you to access the id attribute.

Modified code snippet:

When working with the provided xml data, here is a sample script including the closing tags

</employees></directory>

.

function myFunction() {
  const xml = `<directory>
  <fieldset>
    <field id="displayName">Display name</field>
  </fieldset>
  <employees>
    <employee id="123">
      <field id="displayName">John Doe</field>
    </employee>
    <employee id="160">
      <field id="displayName">Jane Doe</field>
    </employee>
  </employees>
</directory>`;
  var document = XmlService.parse(xml);
  var roots = document.getRootElement().getChild('employees').getChildren();
  var ids = roots.map(e => e.getAttribute("id").getValue());
  console.log(ids);  // [123, 160]
}

Note:

Make sure to run the script with V8 for optimal performance.

If you also wish to retrieve the value of field along with the id of each employee, refer to the additional script below.

  var ids = roots.map(e => ({id: e.getAttribute("id").getValue(), name: e.getChild("field").getText()}));

This will return

[ { id: '123', name: 'John Doe' }, { id: '160', name: 'Jane Doe' } ]

.

Please be cautious if the structure of your actual xml data differs from the provided example, as it may impact the functionality of the modified script.

For more information:

getAttribute(name)

Answer 3

Answer №2

(function() {
   var data = document.getElementsByTagName("employees")[0].children;
   
   for(var i=0; i<data.length; i++){
    var employeeId = data[i].getAttribute("id")
    console.log(employeeId);
   
   }
   
   

})();

<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<directory>
 <fieldset>
  <field id="displayName">Display name</field>
 </fieldset>
 <employees>
  <employee id="123">
   <field id="displayName">John Doe</field>
  </employee>
  <employee id="160">
   <field id="displayName">Jane Doe</field>
  </employee>
  </employees>
 </directory>

Accessing the employee ids through JavaScript.

Answer 4

(function() {
   var data = document.getElementsByTagName("employees")[0].children;
   
   for(var i=0; i<data.length; i++){
    var employeeId = data[i].getAttribute("id")
    console.log(employeeId);
   
   }
   
   

})();

<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<directory>
 <fieldset>
  <field id="displayName">Display name</field>
 </fieldset>
 <employees>
  <employee id="123">
   <field id="displayName">John Doe</field>
  </employee>
  <employee id="160">
   <field id="displayName">Jane Doe</field>
  </employee>
  </employees>
 </directory>

Accessing the employee ids through JavaScript.

What is the method to extract the Element Id from XML parsing in Google Apps Script?

Answer №1

Key point:

Modified code snippet:

Note:

For more information:

Answer №2

Similar questions

Smoothly scroll through parallax backgrounds

"Encountering a restricted URI error when attempting to load a text file using AJAX

Ways to ensure the synchronous execution of asynchronously invoked functions

Presenting the output of a machine learning model on a website

Can the unacknowledged range-based for loop be identified?

Javascript splice method mistakenly eliminating the incorrect elements

Tips on Importing a Javascript Module from an external javascript file into an <script> tag within an HTML file

Tips for waiting on image loading in canvas

Unexpected issue: THREE js Object position does not update after rotation

Ensure that the children elements can be resized without exceeding the boundaries

Exploring the fundamentals of Express.js code base

Discovering the origin of an unexpected element.style manifestation

Ember.js encountering an "Access-Control-Allow-Origin" error with Ajax

Two distinct iterations of the identical jquery version sourced from external sources

Issue arises when attempting to compare this specific data type as a string

The jqGrid is not showing the AJAX JSON data as expected

Exporting Canvas data without the alpha channel

Splitting with Regex - One Time Operation

Detecting Pixel Colors Across Multiple Overlapping Canvases

Tips for modifying the color of a query term in HTML