importxml 从破坏日志中收集价格 [英] importxml to gather prices from undermine journal

问题描述

我正在尝试自动显示游戏中物品的价格以显示在电子表格(魔兽世界)上.我正在使用 TheUndermine 日志来获取价格.

链接:

I am trying to automate the prices of items in a game to display on a spreadsheet (World of Warcraft). I am using TheUndermine journal to get prices.

link : https://theunderminejournal.com/#us/garona/item/23445

what I want to get is the Current Price to display in my spreadsheet. The site is updated hourly.

=importxml("https://theunderminejournal.com/#us/garona/item/23445","/html/body/div[2]/div[2]/div[11]/div[1]/table/tr[3]/td/span")

=importxml("https://theunderminejournal.com/#us/garona/item/23445","//*[@id="item-page"]/div[1]/table/tr[3]/td/span")

I have tried these but to no avail. Any help would be appreciated. I have got this to work with other sites like retail sites and such, just not this one.

Thanks!

解决方案

Google Sheets does not support web scraping of JavaScript controlled elements. you can easily check it by disabling JS for a given site and only what's left visible can be scraped. in your case, that's nothing, unfortunately:

这篇关于importxml 从破坏日志中收集价格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！