Xpath for changing text

Questions about XML that are not covered by the other forums should go here.
wuptii999
Posts: 1

Xpath for changing text

Tue Oct 10, 2017 12:39 am

Hello.

I am trying to create a Google Sheets doc that automaticly imports prices from a url on futbin.com.

Here is an example URL: https://www.futbin.com/18/player/60/Schmeichel/

On the page im trying to get the top price for PS4, im using the formular:

=importxml(https://www.futbin.com/18/player/60/Schmeichel/, "//span[@id='ps-lowest-1']/text()")

But i only get a "-" in the colum.

Hopefully someone can tell me what im doing wrong here :)
adrian
Posts: 2443

Re: Xpath for changing text

Tue Oct 10, 2017 9:47 am

Hi,

The XPath is fine, the problem is the XML source. Check the result of importxml(), it seems to be replacing all values with '-'.
Later Edit: It's not importxml() that causes this, it's most likely the web server that doesn't serve you the values in the first place. It's either some kind of data protection or the values are actually retrieved by JavaScript code which isn't running if you just import the HTML.

Regards,
Adrian
Adrian Buza
<oXygen/> XML Editor, Schema Editor and XSLT Editor/Debugger
http://www.oxygenxml.com
BellaHamilton
Posts: 1
Location: USA

Re: Xpath for changing text

Fri Mar 16, 2018 8:20 pm

Hi,
I have some similar problem with importing my data to xml file. Can I personally change settings of the server data protection to have the possibility to import data?

Thanks.
adrian
Posts: 2443

Re: Xpath for changing text

Mon Mar 19, 2018 12:42 pm

Hi,

Can I personally change settings of the server data protection to have the possibility to import data?
Probably, if you have admin access to the server's contents. But if you have access to that you probably also have access to the server's database, in which case this kind of "import" isn't really necessary, just go for the database import.

Regards,
Adrian
Adrian Buza
<oXygen/> XML Editor, Schema Editor and XSLT Editor/Debugger
http://www.oxygenxml.com

Return to “General XML Questions”

Who is online

Users browsing this forum: No registered users and 0 guests