ImportXML和ImportJSON不起作用.如何从动态网站导入数据? [英] ImportXML and ImportJSON doesn't work. How to import data from dynamic website?

问题描述

这里是网站: https://www.homesnap. com/CA/Sun-Valley/11027-Cohasset-Street

我希望将值$543,000刮到一个单元格中.

I want the value $543,000 to be scraped into one cell.

ImportXML解析为导入的内容为空".这是公式

ImportXML parsed "imported content is empty". Here is the formula

=ImportXML("https://www.homesnap.com/CA/Sun-Valley/11027-Cohasset-Street","//div[@class='property-header-price']")

和ImportJSON返回

and ImportJSON return

语法错误:未扩展的令牌".

"syntax error: unexpexted token".

=ImportJSON("https://www.homesnap.com/CA/Sun-Valley/11027-Cohasset-Street","/html/body/div[1]/main/div[4]/div/div[1]/div[1]/div[4]/div[1]/div")

是否有导入数据的建议?

Any advice to import the data?

推荐答案

您还需要其他来源. Google表格不支持抓取JavaScript元素.您只需通过为给定站点禁用JS即可测试JS依赖关系，剩下的可以被清除.在您的情况下，它什么都没有:

you need some other source. Google Sheets does not support the scraping of JavaScript elements. you can test JS dependency simply by disabling JS for a given site and what's left can be scraped. in your case its nothing:

这篇关于ImportXML和ImportJSON不起作用.如何从动态网站导入数据?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！