'GoogleSheet - importxml [Different URL with same content]
I am a newbie on importxml and trying to scrape the property agent information from a website, I did success to get the required field from the page, but:-
- There are total 60 names in 3 pages, when I changed the formula URL to page 2 & 3, the result is still page 1 content (My formula shown below for page 1 & 2)
Thank you for helping me out!
Webpage:
Page 1: https://hk.centanet.com/findproperty/en/list/agent?q=tQAolkYExEuabekrgvrZ1Q
Page 2: https://hk.centanet.com/findproperty/en/list/agent?q=kfYwlGokGUOYQNBdrRdQ
Page 3: https://hk.centanet.com/findproperty/en/list/agent?q=zWbuX8q3kkKoAx5t81A1FA
Page 1 formula:
=IMPORTXML("https://hk.centanet.com/findproperty/en/list/agent?q=tQAolkYExEuabekrgvrZ1Q","//div[@class='title']")
Page 2 formula:
=IMPORTXML("https://hk.centanet.com/findproperty/list/agent?q=kfYwlGokGUOYQNBdrRdQ","//div[@class='title']")
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
Solution | Source |
---|