CODEWITHSUNDEEP
xmlxpathgoogle-sheets
user3603582
user3603582

Reputation: 3

xpath on Google spreadsheet "Internal import error"

I can't quite get my head around something that should just work...

=IMPORTXML("https://zkillboard.com/api/kills/killID/38382331/xml/","//victim/@characterName")

When i put that into Google docs it results a "internal import error", I ran the same xPath through 6 online xPath testers and they all got the correct result.

I know the data is coming through as the currentTime node works just fine on the sheet.

Am I being dumb or am I missing something

Upvotes: 0

Views: 1047

Answers (1)

Tobias Klevenz
Tobias Klevenz

Reputation: 1645

Well cause there XPath engine is buggy as hell...this works:

=IMPORTXML("https://zkillboard.com/api/kills/killID/38382331/xml/","//victim/@charactername")

...also it shouldn't, there XPath engine only likes lowercase attributes...

Upvotes: 1

Related Questions