我正在尝试利用Google SpreadSheets(Google脚本)中的地图功能,使用API从Bittrex获取我的帐户硬币余额.这是我的JSON对象:
I'm trying to utilize map function in Google SpreadSheets (Google Script) to get my account coin balances from Bittrex using API. Here is my JSON object:
({success:true, message:"", result:[ {Currency:"BTC", Balance:0.01, Available:0.01, Pending:0, CryptoAddress:null}, {Currency:"ETH", Balance:1.0, Available:1.0, Pending:0, CryptoAddress:null} ]} })理想情况下,我想根据结果和基础行中的键(使用每个对象的数据)自动填充标题行. 我看到了spme解决方案如何将其用于每种或更复杂的方法.但是我想这可以通过映射来完成.这是我如何映射第一行,但不知道如何映射值:
Ideally I would like to populate header row automatically, based on Keys in result and underlying rows using data from each object. I saw spme solutions how to do that using for each or more complicated way. But I guess this can be done by just mapping. Here is how I mapped top row, but don't know how to map values:
var headerRow = Object.keys(json.result[0]);Google SpreadSheet中的预期输出为
Expected output in Google SpreadSheet is
____________________________________________________________ | Currency | Balance | Available | Pending | CryptoAddress | |__________________________________________________________| | BTC | 0.01 | 0.01 | 0 | null | | ETH | 1.0 | 1.0 | 0 | null | ____________________________________________________________推荐答案
我将执行以下操作.因此,您有了密钥,然后就可以检索该值.
I would do the following. So you have the key and then you can retrieve the value.
Object.keys(json.result[0]).map((val) => { console.log(json.result[0][val])})将其包装在foreach中以对每个结果执行相同的操作.
Wrap that within a foreach to do the same for each result.
希望有帮助
更多推荐
将JSON对象数组映射到字符串
发布评论