CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
StratusFury
StratusFury

Reputation: 1

Google Sheets ImportXML - Extract Class Information

First post on Stack Overflow! I have minimal IT/Dev background, and I was just trying to learn how to data scrape using the Import XML function in Google Sheets to get a little experience with the function and I've ran into a speed bump, hoping you can help!

I've been successful in my attempts to pull the data I would like so far, but there is a tiny amount of information I would also like to extract, but can't really figure it out thus far. I can see the information in Google DevTools. (Screenshot attached)

The data is stored in the Class definition line and it defines the time Last Seen, accessible one of two ways.
URL : https://us.tamrieltradecentre.com/pc/Trade/SearchResult?ItemID=11807&SortBy=Price&Order=asc

Desired function from ImportXML would be to pull the text, or the URL Extension - With the information of one of those two pieces of information

Thanks for your help!

*EDIT Added Google Sheets Screenshot

Devtool Screenshot Google Sheets Screenshot

Red Circles for Values I Would Like To Import

Upvotes: 0

Views: 299

Answers (1)

Tanaike
Tanaike

Reputation: 201398

  • You want to retrieve the values of "Last seen" like "1 Hour ago" from the URL using IMPORTXML.

When I checked the site of the URL, it was found that at the URL you want to use, the values like "1 Hour ago" are put using Javascript. In this case, unfortunately, that cannot be retrieved using IMPORTXML. Because IMPORTXML cannot evaluate Javascript.

Upvotes: 1

Related Questions