/
get_data.js
34 lines (33 loc) · 1.06 KB
/
get_data.js
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
var fs = require("fs");
var https = require('https');
var url = 'https://spreadsheets.google.com/feeds/list/1XWRuM1aIEYXyqw4JMdQrDkpoppXPcIPE58vKqbeOjBE/od6/public/values?alt=json'
https.get(url, res => {
res.setEncoding("utf8");
var responseData = "";
res.on("data", data => {
responseData += data;
});
res.on("end", () => {
var respData = []
responseData = JSON.parse(responseData)['feed']['entry'];
responseData.forEach( (d) => {
var r = {}
r['id'] = d['gsx$id']['$t']
r['text'] = d['gsx$text']['$t']
r['type'] = d['gsx$type']['$t']
r['href'] = d['gsx$href']['$t']
r['startyear'] = d['gsx$startyear']['$t']
r['endyear'] = d['gsx$endyear']['$t']
r['inactive'] = d['gsx$inactive']['$t']
r['explanation'] = d['gsx$explanation']['$t']
r['links'] = d['gsx$links']['$t']
respData.push(r)
})
fs.writeFile("data.json", JSON.stringify(respData), function(err) {
if(err) {
return console.log(err);
}
console.log("The file was saved!");
});
});
})