[GAS][Json] Get Json Data into Webpage (建築中)

Get Json Data into Webpage

SOURCE : https://www.udemy.com/google-script/learn/v4/t/lecture/7465660?start=0

(1) 最初的低級錯誤 , 未 PUBLISH "SHEET" , 所以取不到DATA

(2) 在LOCAL BROSWER 接受 中文字的 變數 ('排名'), 但 放在寄存DOMAIN 上 , 不接受中文變數名稱

(3) 變數 及 指令 是大細階 要清楚的 

----> CODE OF LOCAL WEBPAGE

<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0-alpha.6/css/bootstrap.min.css" integrity="sha384-rwoIResjU2yc3z8GV/NPeZWAv56rSmLldC3R/AZzGRnGxQQKnKkoFVhFQhNUwEyJ" crossorigin="anonymous">
<div>
<h1> Pin Killer Ranking </h1>
    <table id="myTable" class="table table-striped">
        <tr>
            <th>Rank</th>
            <th>Name</th>
            <th>Avg</th>
<th>受讓</th>
        </tr>
    </table>
</div>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/tether/1.4.0/js/tether.min.js" integrity="sha384-DztdAPBWPRXSA/3eYEEUWrWCy7G5KFbe8fFjk5JAIxUYHKkDx6Qin1DkWx51bBrb" crossorigin="anonymous"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0-alpha.6/js/bootstrap.min.js" integrity="sha384-vBWWzlZJ8ea9aCX4pEW3rVHjgjt7zpkNpZk+02D9phzyeVkE+jo0ieGizqPLForn" crossorigin="anonymous"></script>
<script>
    $.getJSON('https://spreadsheets.google.com/feeds/list/11uGtICNHXAmXQ_lkLwubiNkVMdBX9rWf3U1KPra257k/od6/public/values?alt=json', function(data){
var d = data.feed.entry;
        jQuery.each(d, function () {
     var x = Math.floor((200-this['gsx$avg']['$t'])*0.8);
            $('#myTable tr:last').after('<tr><td>' + this['gsx$排名']['$t'] + '</td><td>' + this['gsx$name']['$t'] + '</td><td>' + this['gsx$avg']['$t'] + '</td><td>' + x + '</td></tr>');
        })
     console.log(data);
})
     
</script>