Guest User

Untitled

a guest
Mar 19th, 2018
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.53 KB | None | 0 0
  1. =IMPORTXML(URL,CONCATENATE("//*[local-name() = '",*ELEMENTNAME*,"']"))
  2.  
  3. //*/[local-name() = 'filing-date']
  4. //*/[local-name() = 'size']
  5. etc.
  6.  
  7. //*[local-name() = 'filing-date'] | //*[local-name() = 'filing-type'] | //*[local-name() = 'filing-href'] | //*[local-name() = 'form-name'] | //*[local-name() = 'size'] | //*[local-name() = 'amend']
  8.  
  9. function parseFeedXml(url) {
  10. var result = [];
  11. var xml = UrlFetchApp.fetch(url).getContentText();
  12. var document = XmlService.parse(xml);
  13. var atom = XmlService.getNamespace('http://www.w3.org/2005/Atom');
  14. var feed = document.getRootElement();
  15. var entry = feed.getChildren('entry',atom);
  16. for (var i = 0; i < entry.length; i++) {
  17. var content = entry[i].getChildren('content',atom);
  18. var contentElement = '';
  19. var resultRow = [];
  20. for (var j = 0; j < content.length; j++) {
  21. contentElement = content[j];
  22. evaluateText(contentElement.getChild('filing-date',atom), resultRow);
  23. evaluateText(contentElement.getChild('filing-type',atom), resultRow);
  24. evaluateText(contentElement.getChild('filing-href',atom), resultRow);
  25. evaluateText(contentElement.getChild('form-name',atom), resultRow);
  26. evaluateText(contentElement.getChild('size',atom), resultRow);
  27. evaluateText(contentElement.getChild('amend',atom), resultRow);
  28. result.push(resultRow);
  29. }
  30. }
  31. return result;
  32. }
  33.  
  34. function evaluateText(element, resultRow) {
  35. if (element) {
  36. resultRow.push(element.getText());
  37. } else {
  38. resultRow.push('');
  39. }
  40. }
Add Comment
Please, Sign In to add comment