文、意如
api:https://openapi.kcg.gov.tw/Api/Service/Get/d78e0dc5-079e-4545-b698-fa0a5f539d65
主要抓取data裡的資料
"data": [
{
"Seq": 1,
"年別": "2017",
"污水處理率": "60.35759938",
"污水處理總量": "280931861"
},
{
"Seq": 2,
"年別": "2018",
"污水處理率": "62.09638609",
"污水處理總量": "275316982"
},
{
"Seq": 3,
"年別": "2019",
"污水處理率": "64.1204667",
"污水處理總量": "297526486"
}]程式碼:
<html>
<head>
<title>api_test</title>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
</head>
<body>
<p>生活安全及品質:高雄市污水處理率及全年污水處理總量</p>
(API:https://openapi.kcg.gov.tw/Api/Service/Get/d78e0dc5-079e-4545-b698-fa0a5f539d65)
<table border="1" align="center">
<tr>
<td>編號</td>
<td>Seq</td>
<td>年別</td>
<td>污水處理率</td>
<td>污水處理總量</td>
</tr>
<tbody id="mydata" align="center">
</tbody>
</table>
</body>
</html>
<script>
$(document).ready(function(){
$.ajax({
url:"https://openapi.kcg.gov.tw/Api/Service/Get/d78e0dc5-079e-4545-b698-fa0a5f539d65",
type:"get",
dataType:"json",
success:function(info){
console.log(info);
total_len=info.data.length;
console.log("筆數",total_len);
for(i=0;i<total_len;i++){
item = info.data;
$("#mydata").append(
"<tr>"+
"<td>"+(i+1)+"</td>"+
"<td>"+item[i]["Seq"]+"</td>"+
"<td>"+item[i]["年別"]+"</td>"+
"<td>"+item[i]["污水處理率"]+"</td>"+
"<td>"+item[i]["污水處理總量"]+"</td>"+
"</tr>"
)
}
},
error:function(e){
$("#mydata").html("請求失敗!!!")
}
});
});
</script>
Yiru@Studio - 關於我 - 意如
