将JSON对象数组映射到字符串

问题描述：

我正在尝试利用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对象数组映射到字符串

相关推荐