| Name | Total Beds | Occupy Beds | Vacant Beds |
|---|
let xmlhttp = new XMLHttpRequest();
xmlhttp.onreadystatechange = function () {
if (this.readyState == 4 && this.status == 200) {
let data = JSON.parse(this.responseText).feed.entry;
let i;
for (i = 0; i < data.length; i++) {
let name = data[i]["gsx$name"]["$t"];
let total = data[i]["gsx$total"]["$t"];
let occupy = data[i]["gsx$occupy"]["$t"];
let vacant = data[i]["gsx$vacant"]["$t"];
document.getElementById("demo").innerHTML +=
"
"
name +
"
" +
"
total +
"
" +
"
occupy +
"
" +
"
vacant +
"
" +
"
";
}
}
};
xmlhttp.open(
"GET",
"https://spreadsheets.google.com/feeds/list/1t84JDMrY4UTn7mCp4DH3NJiLg44ZQ-6tt_H8ebCXky4/od6/public/values?alt=json",
true
);
xmlhttp.send();