Google Sheets importXML Returns Empty Value

by

Answer:

IMPORTXML can not retrieve data which is populated by a script, and so using this formula to retrieve data from this table is not possible to do.

More Information:

As you’ve already mentioned, you can attempt to get the data directly from the table using:

=IMPORTXML("https://kamadan.gwtoolbox.com/","//table[@id='trader-overlay-items']")

Which just gets a blank cell.

I went a step further and tried to reverse-engineer this by calling IMPORTXML on the HTML elements on the page in steps:

=IMPORTXML("https://kamadan.gwtoolbox.com/","html")
=IMPORTXML("https://kamadan.gwtoolbox.com/","html/body")
=IMPORTXML("https://kamadan.gwtoolbox.com/","html/body/div[1]")
=IMPORTXML("https://kamadan.gwtoolbox.com/","html/body/div[1]/div[0]")
...

html/body/div[1]/div[0] is the first path which gives no imported content, and we can see from importing html/body that the full body does not contain the imformation and only a template of it – in cell B1 we have references to ‘Common materials’ and ‘Rare materials’:

enter image description here

And in D1 we start to see JavaScript and JSON objects which are not called by IMPORTXML and so the results of which can not be retrieved:

enter image description here

As you can see if you disable JavaScript on the site, almost nothing is actually rendered and so can’t be obtained using IMPORTXML:

enter image description here

References:

More Related Contents:

  1. ArrayFormula of Average on Infinite Truly Dynamic Range in Google Sheets
  2. Conditional formatting based on another cell’s value
  3. Get the last non-empty cell in a column in Google Sheets
  4. How to stop / freeze / pause volatile RAND / RANDBETWEEN / RANDARRAY?
  5. How would I import YouTube Likes and Dislikes and a ratio from YouTube onto Google Sheets? [closed]
  6. Periodically refresh IMPORTXML() spreadsheet function
  7. How to SUM duration in Google Sheets?
  8. ArrayFormula and “AND” Formula in Google Sheets
  9. ARRAY_LITERAL, an Array Literal was missing values for one or more rows
  10. Query is ignoring string (non numeric) value
  11. Repeat whole row N times based on column value in Google Sheets
  12. I get Formula parse error with all formulas
  13. IMPORTXML and right XPath from Bloomberg price [duplicate]
  14. What factors determine the memory used in lambda functions?
  15. How to list all permutations without repetition?
  16. How to use arrayformula with formulas that do not seem to support arrayformulas?
  17. Repeat each row N times in Google Sheets
  18. How to create all possible pair combinations without duplicates in Google Sheets?
  19. Col BY causing parse error in Google sheets query
  20. Count cells that contain any text
  21. How to make a range repeat n-times in Google SpreadSheet
  22. In ARRAY_LITERAL, an Array Literal was missing values for one or more rows – indirect formula error in google spreadsheet
  23. How to create a runing total formula that expands automatically when new rows are added to my spreadsheet [duplicate]
  24. No permission to call msgBox in Google Apps Scripting
  25. How to Autofill last row with formula, when data is received from IFTTT on the last row?
  26. Download link for Google Spreadsheets CSV export – with Multiple Sheets
  27. Stacking multiple columns on to one?
  28. New Google spreadsheet Concatenate limit 50000 characters
  29. Google Sheet API v4
  30. How to create INDIRECT array string of multiple sheet references in Google Sheets?

Leave a Comment