Steam webAPI Jquery脚本.返回

Question

我从github得到的这个脚本有问题。

我自己添加了value.appid，因为这看起来很合乎逻辑，但我相信data.response.games是对我所有游戏及其价值观的回应。

如何让它们打印或查看定义的内容？

我需要value.description或者value.ownedAchievements之类的东西。

我想看看我必须为CSV使用哪些数据。

我完全不懂这一点，所以请注意，我也不知道该怎么办，因为我以前从未接触过javascript。

我目前正在学习HTML CSS和PHP。

我有一个Docker在运行我的SQL。。。是否还有一种方法可以重新设计这个脚本，直接将这些value.*值放入列中？而无需一直下载CSV并手动导入。

<script src='http://code.jquery.com/jquery-2.1.1.min.js' type='text/javascript'></script>
<script type='text/javascript'>
$(document).ready(function () {
function exportSteamToCSV(filename) {
var url = "http://api.steampowered.com/IPlayerService/GetOwnedGames/v0001/?key=" + $('#webkey').val() + "&steamid=" + $('#steamid').val() + "&format=json&include_appinfo=1";

$.get(url, function(data) {
colDelim = ',';
rowDelim = '"rn"';
csv = '"Name","Playtime","Store' + rowDelim;
$.each(data.response.games, function(index, value) {
url = "http://store.steampowered.com/app/" + value.appid;
csv += value.name + colDelim + value.playtime_forever + colDelim  + value.appid + colDelim + url + rowDelim; 
//csv += value.name + colDelim + value.playtime_forever + colDelim  + url + rowDelim;   Was correct eerste versie
});
csv += '"';
csvData = 'data:application/csv;charset=utf-8,' + encodeURIComponent(csv);
var link = document.createElement("a");
link.download = filename;
link.href = csvData;
link.target = "_blank";
link.click();
});
};
$(".export").on('click', function (event) {
// CSV
exportSteamToCSV.apply(this, ['steamgames.csv']);
});
});
</script>

Answer 1

稍后在Laravel中用APU的查询解决了这个问题。URL只获取所有数据。。从那里你几乎可以做任何事情。

$url = "https://api.steampowered.com/IPlayerService/GetOwnedGames/v0001/?key=XXXXXXXXXX&steamid=XXXXXXXXXXformat=json&include_appinfo=1";
$jsondata = file_get_contents($url);
$parsed = json_decode($jsondata,true);
$games = $parsed['response']['games'];
echo SteamGame::count();
foreach($games as $game){
echo $game['name']."<br>";
$imgid = $game['appid'];
SteamGame::updateOrCreate(['name' => $game['name']],[
'name' => $game['name'],
'appID' => $game['appid'], 
'storeURL' => "https://store.steampowered.com/app/".$game['appid'],
'imageURL' => "https://cdn.akamai.steamstatic.com/steam/apps/${imgid}/header.jpg",
'minutesplayed' => $game['playtime_forever']
]);