需求：通过虚拟货币交易网站提供的API，例如：URL: https://data.gateapi.io/api2/1/tickers 获取所有货币交易行情，选取我需要的币种和字段，展示在前端，并每隔10S自动同步更新一次。
返回的json格式如下：
# Request
GET: https://data.gateapi.io/api2/1/tickers
# Response{"salt_usdt":{"result":"true","last":"0.4041","lowestAsk":"0.4089","highestBid":"0.3984","percentChange":"51.23","baseVolume":"30913.7019338711895","quoteVolume":"86670.244471655","high24hr":"0.4391","low24hr":"0.3984"},"snx3s_usdt":{"result":"true","last":"0.000773","lowestAsk":"0.0007773","highestBid":"0.0007695","percentChange":"-14.56","baseVolume":"7561.60683049768","quoteVolume":"9495830.6014","high24hr":"0.0007816","low24hr":"0.0007465"},"fxs_eth":{"result":"true","last":"0.00494","lowestAsk":"0.005006","highestBid":"0.004811","percentChange":"-1.27","baseVolume":"14.75674218648904","quoteVolume":"2914.27425935","high24hr":"0.005084","low24hr":"0.00487"},"hai_eth":{"result":"true","last":"0.00011169","lowestAsk":"0.00011214","highestBid":"0.0001111","percentChange":"-2.52","baseVolume":"5.6460636601762134","quoteVolume":"49982.34220065","high24hr":"0.00011323","low24hr":"0.00011002"},"digg_eth":{"result":"true","last":"31.34","lowestAsk":"37.44","highestBid":"23.5","percentChange":"0","baseVolume":"0","quoteVolume":"0","high24hr":"31.34","low24hr":"31.34"},"amp_eth":{"result":"true","last":"0.00001591","lowestAsk":"0.00001711","highestBid":"0.00001441","percentChange":"-2.15","baseVolume":"9.447949011278","quoteVolume":"600281.2508","high24hr":"0.00001449","low24hr":"0.00001449"},"grin3l_usdt":{"result":"true","last":"1.1568","lowestAsk":"1.1859","highestBid":"1.1173","percentChange":"40.04","baseVolume":"4465528.25865048843215","quoteVolume":"4145087.1511415346","high24hr":"1.2016","low24hr":"1.0464"}我需要在前端通过表格形式或者其它形式输出在本地展示“salt_usdt” ,"lowestAsk","highestBid",三个字段。并能够自动更新或者手动点击更新。
PS：我本人没有编程基础，仅仅10年前大学学过C语音，早忘记了。我目前采用的办法是通过EXCEL的数据导入功能，从网站导入数据，通过API输出到EXCEL表中，但因为查询的连接过多，EXCEL点击更新一次，需要卡1-2分钟才能更新一遍。太慢太卡。
请教大神们，我这种小白什么样的方式才能最简单的实现我的需求。我尝试用kettle来弄，但第一步通过http client 就获取不到json和字段，不知道什么原因，未成功。
前端直接定时请求这个API即可，拿到的数据进行解析展示；
或者前端请求你的后台，你的后台去请求这个API，然后数进行数据解析 封装成你想要的 返回给前端
前端用什么工具展示？我完全是编程小白，只会用OFFICE办公软件。我现在用的是excel调用的API，但是太卡太慢了。