6178

ImportXML - Google Sheets but incomplete HTML

Question:

First of all, I'm a newbie and doesn't know programming. I am trying to use importxml on one of my sheets but it doesn't work as it is always returning as an empty cell. When I view the page source of my URL, it only shows this.

<!DOCTYPE html> <html> <head> <meta name="viewport" content="width=device-width, initial-scale=1"> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>Management Console</title> <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootswatch/3.3.6/lumen/bootstrap.min.css"> <link href="https://fonts.googleapis.com/css?family=Montserrat" rel="stylesheet"> </head> <body> <div id="root"> </div> <script src="https://maps.googleapis.com/maps/api/js?key=AIzaSyCtv3S4sKtUtwBwvvkQuGbq3HrzGftdJpc&libraries=geometry"></script> <script src="/bundle.js"></script> </body> </html>

Whereas, when I open it using inspect on Chrome, there are more information on the line between div id="root" and /div. I am not sure if it something I can still get using xpath. Please see attached pic for what I am seeing.

<img alt="" class="b-lazy" data-src="https://i.stack.imgur.com/NmiKV.png" data-original="https://i.stack.imgur.com/NmiKV.png" src="https://etrip.eimg.top/images/2019/05/07/timg.gif" />

Answer1:

IMPORTXML can only access the source code not the modified DOM by JavaScript or other by other means in contrary as a web browser does, so IMPORTXML isn't the tool the get the required value.

Recommend

  • How to properly fetch single cells in pandas: loc[index,column] VS get_value(index,column)
  • Javascript snippet not working (missing lib?)
  • Jquery Google Maps V3 - Information window is always fixed to one marker
  • How to center a menu using flexbox [closed]
  • reduce/reduce conflicts using ocamlyacc
  • The symbol you provided is not a function
  • Can long-polling be achieved in Restlet by just making the thread sleep?
  • SqlCommand back up Database
  • I am receiving HibernateException “No Hibernate Session bound to thread, and configuration does not
  • MySQL: Update rows in table by iterating and joining with another one
  • Javascript CORS - No 'Access-Control-Allow-Origin' header is present
  • Android cannot disable cut copy paste
  • WPF version of .ScaleControl?
  • Eclipse MTJ doesn't see Java ME SDK 3.0 devices
  • blade.php method outputting it's result to the form
  • xcode don't localize specific strings
  • D3 get axis values on zoom event
  • Android - Material Design - NavigationView - How to put vertical scroll?
  • Jquery UI tool tip close icon
  • DotNetZip - Calculate final zip size before calling Save(stream)
  • Sony Xperia Z Tablet not found by adb
  • SSO with signing and signature validation doesn't work
  • Fill an image in a square container while keeping aspect ratio
  • MySQL WHERE-condition in procedure ignored
  • Can I make an Android app that runs a web view in Chrome 39?
  • Web-crawler for facebook in python
  • Warning: Can't call setState (or forceUpdate) on an unmounted component
  • bootstrap to use multiple ng-app
  • How to get icons for entities from eclipse?
  • trying to dynamically update Highchart column chart but series undefined
  • Load html files in TinyMce
  • How can I get HTML syntax highlighting in my editor for CakePHP?
  • Free memory of cv::Mat loaded using FileStorage API
  • How do I configure my settings file to work with unit tests?
  • Turn off referential integrity in Derby? is it possible?
  • IndexOutOfRangeException on multidimensional array despite using GetLength check
  • JaxB to read class hierarchy
  • costura.fody for a dll that references another dll
  • Binding checkboxes to object values in AngularJs
  • java string with new operator and a literal