LinkedIn
Twitter
Learned a lot about importing JSON today to apps script, and thought Iโd share my progress so far. Still a lot to do. My goal is to make a forecast of 5 regions in my city.
Hereโs the code:
//Made by Ratatosk (Appsheet user) Feel free to use it as you wish!
function getWeather() { getBergen3hData() }
function getBergen3hData() {
var url = "api.openweathermap.org/data/2.5/forecast?q=Bergen,NO&lang=no&appid=ENTERYOURKEYHERE&units=metric" // URL for weather. API key needed(free)
var response = UrlFetchApp.fetch(url, {method: 'GET',headers: {'Content-Type': 'application/json','Accept': 'application/json'} });
var json = response.getContentText();
var data = JSON.parse(json);
var weather = SpreadsheetApp.getActive().getSheetByName('BergenVรฆr');
var hoursperiods = 12; //how many 3 hour periods you extract from the forecast
weather.getRange("A2:G1000").clearContent(); //deletes old data in sheet
for (var i = 1; i < hoursperiods; i++) {
weather.getRange('A'+(i+1)).setValue(data.list[i].dt_txt); //times
weather.getRange('E'+(i+1)).setValue(data.city.name); //City name
weather.getRange('B'+(i+1)).setValue(data.list[i].weather[0].main); //one word description
weather.getRange('C'+(i+1)).setValue(data.list[i].weather[0].description); //description
weather.getRange('D'+(i+1)).setValue("http://openweathermap.org/img/wn/"+data.list[i].weather[0].icon+"@4x.png"); //icon
weather.getRange('F'+(i+1)).setValue(data.list[i].main.temp+"ยฐC"); //temp
//weather.getRange('B'+(i+1)).setValue(LanguageApp.translate(JSON.stringify(data.list[i].weather[0].main), 'en', 'no')); //How to translate language if needed
}
}
