json - Powershell JSON:从嵌套在对象中的数组中提取值
问题描述
我正在尝试从包装在 JSON 对象中的 JSON 数组中提取值:
我不能使用 | formatFrom-JSON 因为它只返回第一行。
我想知道如何绕过这个并从响应中获取包含这些详细信息的数组。
我对 Apple Stock 中的那些键和值很感兴趣。
我已经搜索了很多,但到目前为止没有 uck...
Code:
{
"quoteResponse":{
"result":[
{
"language":"en-US",
"region":"US",
"quoteType":"EQUITY",
"quoteSourceName":"Delayed Quote",
"triggerable":true,
"currency":"USD",
"marketState":"CLOSED",
"exchange":"NMS",
"shortName":"Apple Inc.",
"longName":"Apple Inc.",
"messageBoardId":"finmb_24937",
"exchangeTimezoneName":"America/New_York",
"exchangeTimezoneShortName":"EDT",
"gmtOffSetMilliseconds":-14400000,
"market":"us_market",
"esgPopulated":false,
"regularMarketDayHigh":123.7,
"regularMarketDayRange":"110.89 - 123.7",
"regularMarketDayLow":110.89,
"regularMarketVolume":332607163,
"regularMarketPreviousClose":120.88,
"bid":120.01,
"ask":120.1,
"bidSize":12,
"askSize":9,
"fullExchangeName":"NasdaqGS",
"financialCurrency":"USD",
"regularMarketOpen":120.07,
"averageDailyVolume3Month":165333146,
"averageDailyVolume10Day":191317114,
"fiftyTwoWeekLowChange":68.1925,
"fiftyTwoWeekLowChangePercent":1.29232,
"epsCurrentYear":3.24,
"priceEpsCurrentYear":37.333332,
"sharesOutstanding":17102499840,
"bookValue":4.218,
"fiftyDayAverage":111.70643,
"fiftyDayAverageChange":9.253571,
"fiftyDayAverageChangePercent":0.0828383,
"twoHundredDayAverage":85.37846,
"twoHundredDayAverageChange":35.581535,
"twoHundredDayAverageChangePercent":0.4167507,
"marketCap":2068718419968,
"forwardPE":31.255816,
"priceToBook":28.6771,
"sourceInterval":15,
"exchangeDataDelayedBy":0,
"tradeable":false,
"fiftyTwoWeekRange":"52.7675 - 137.98",
"fiftyTwoWeekHighChange":-17.019997,
"fiftyTwoWeekHighChangePercent":-0.12335119,
"fiftyTwoWeekLow":52.7675,
"fiftyTwoWeekHigh":137.98,
"dividendDate":1597276800,
"earningsTimestamp":1596126600,
"earningsTimestampStart":1603882740,
"earningsTimestampEnd":1604318400,
"trailingAnnualDividendRate":0.782,
"trailingPE":36.699028,
"trailingAnnualDividendYield":0.006469226,
"epsTrailingTwelveMonths":3.296,
"epsForward":3.87,
"firstTradeDateMilliseconds":345479400000,
"priceHint":2,
"postMarketChangePercent":-0.79365003,
"postMarketTime":1599263998,
"postMarketPrice":120.0,
"postMarketChange":-0.9599991,
"regularMarketChange":0.08000183,
"regularMarketChangePercent":0.06618285,
"regularMarketTime":1599249602,
"regularMarketPrice":120.96,
"displayName":"Apple",
"symbol":"AAPL"
}
],
"error":null
}
}
解决方案
对,那是正确的。
- 这些属性是:
写主机($results.quoteResponse.result.symbol)写主机($results.quoteResponse.result.fiftyDayAverageChange)
完美谢谢!
推荐阅读
- sql - 在分组记录中选择重复记录?
- windows - 相当于Windows中的“转到文件夹窗口”,以访问位于当前目录其他位置的Windows打开提示符中的文件?
- angularjs - 我怎样才能显示
- ibeacon-android - 当 setForegroundBetweenScanPeriod 设置时间长且信标关闭/打开时,会触发大量 Range 事件
- machine-learning - 了解假设检验和进一步行动
- loops - 我应该将请求对象传递给 goroutine 以阻止来自通道的 for-select 循环吗?
- android - 奥利奥未能在频道 null 上发布通知
- python - 如何使用相同的虚拟环境运行 Python 和 Jupyter,使用 Visual Studio Code
- asp.net - 写入枚举类型的sql server?DropDownListFor| ASP.NET
- javascript - 如何从文本表单更改 iframe?