Beiträge von Steenhy

function splitDollar() {
  var resultList = new Object();
  var url = 'http://www.ecb.europa.eu/stats/policy_and_exchange_rates/euro_reference_exchange_rates/html/usd.xml';
  var xml = UrlFetchApp.fetch(url).getContentText();

  var uu=xml.split('<Obs');
  for (i = 1; i < 11; i++){
    var uu1=uu.length-i;
    var datum=xml.split('TIME_PERIOD="')[uu1].split('"')[0];
    var kurs=xml.split('OBS_VALUE="')[uu1].split('"')[0];
    resultList[i] = new Object();
    resultList[i]["Datum"] =datum ;
    resultList[i]["Kurs"] = kurs;
  }
  
   Logger.log(resultList); 

}

function parseDollar() {
  var resultList = new Object();
  var DatenListe = new Object();
  var offerItemList = new Object();
  var url = 'http://www.ecb.europa.eu/stats/policy_and_exchange_rates/euro_reference_exchange_rates/html/usd.xml';
  var xml = UrlFetchApp.fetch(url).getContentText();
  var document = XmlService.parse(xml);
  var root = document.getRootElement();
  var DataAtom = XmlService.getNamespace('http://www.ecb.europa.eu/vocabulary/stats/exr/1');

  offerItemList = document.getRootElement().getChildren("DataSet",DataAtom)
  DatenListe =offerItemList[0].getChildren("Series",DataAtom); 
  var zahla = DatenListe.length;

  for (var i = 0; i < zahla; i++) {
   resultList[i] = new Object();
   resultList[i]["Datum"] = DatenListe[i].getChild('TIME_PERIOD').getText();
   resultList[i]["Kurs"] = DatenListe[i].getChild('OBS_VALUE').getText();
  }
}