'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']")

enter image description here



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source