CODEWITHSUNDEEP
xpathgoogle-sheetsgoogle-sheets-formula
HumanoVirtual
HumanoVirtual

Reputation: 77

Google Sheets IMPORTXML error: Import Internal Error

I'm facing a weird error while trying import data from this link: https://www.atproperties.com/472719 using XPath //li[@class="active"] I'm confused cause there is no problem getting data from a similar source: https://www.atproperties.com/370926 using the same XPath. Both hyperlinks are opening the same way in chrome browser and have the same XPath. Here is the link to the spreadsheet. Any help will be appreciated. Thanks.

Upvotes: 1

Views: 436

Answers (1)

E.Wiest
E.Wiest

Reputation: 5905

Use IMPORTDATA, INDEX and REGEXEXTRACT for this specific case :

=REGEXEXTRACT(INDEX(IMPORTDATA(B2);9;1);" - (.+)")&", "&INDEX(IMPORTDATA(B2);9;2)

Output :

IMPD

Side note : your XPath should be fixed as followed : (//li[@class="active"])[1]

Upvotes: 1

Related Questions