Empty imported content detected in Google Sheets

=IMPORTXML("https://www.tradingview.com/chart/1BxJl0Xz/", "//body/div/div/div/div/div/table/tr[3]/td/div/div/div/div[1]/div[1]/div[3]/div/div/div")

Attempting to extract data from the above URL and import it into my Google Sheets, but encountering an error message stating that the imported content is empty. Does anyone know how to resolve this issue?

The path I used in my Google Sheet was obtained from the Chrome console.

Answer №1

Unfortunately, it seems that this method won't be successful due to the reliance on javascript for generating the content.

While the xpath may seem valid based on manual checking, using importXML will not trigger the javascript necessary for retrieving the desired data.

To view the raw content and confirm the absence of values generated by javascript, consider utilizing wget or executing the powershell command provided below:

(iwr "").RawContent | more

An alternative approach will be needed in order to achieve the desired outcome.

Similar questions

If you have not found the answer to your question or you are interested in this topic, then look at other similar questions below or use the search

Vue.js axios API call throwing error due to undefined property 'map'

Attempting to call a data source from a remote URL results in the error TypeError: Cannot read property 'map' of undefined. The axios method is enclosed within axios.js: ..... result = new Promise((resolve, reject) => { axios.get(url) ...

Revealed the previously hidden private variables within the Revealing Module Pattern

I have encountered an issue while implementing the Revealing Module Pattern, as I am struggling to expose a modified private property. var myRevealingModule = (function(){ var name = 'Samantha'; function updateName () { name = ...

Using various HTML elements within Phonegap applications

Is it possible to include multiple HTML files in a Phonegap application? ...

Tips for querying multiple elements that share a common ID and verifying if the input has been modified

I have a series of text inputs that share a common id prefix but differ slightly at the end. Whenever a user enters text in any of these input fields, I want to trigger a function. Currently, I have this functionality implemented with the following code: ...

Using a <div> to contain <mat-card> in Angular Material

Can you achieve the following: Show components with specified width in a row instead of the usual column layout Enclose the cards within another defined container I've been attempting to accomplish this but without success so far.... While materia ...

Drift above a pair of elements

Explaining my issue is a bit complex, so I'll provide an example: I aim to place a floated element (the blue box) over two other elements (red and green), all within a fixed-width and centered layout (achieved by the black border box). Additionally, ...

What is the best way to merge an array into a single object?

I have an array object structured like this. [ { "name": "name1", "type": "type1", "car": "car1", "speed": 1 }, { "name": &q ...

What is the best way to extract the text from the initial column of a table?

I came across a table on a webpage (specifically, http://developer.chrome.com/extensions/api_index) containing various method names in Stable APIs. My goal is to create an array that includes all the entries from the first column of the table. Is there a ...

the display window is not visible

After implementing the following asp.net server code, my page is being redirected without displaying the print window: ScriptManager.RegisterStartupScript(this, typeof(Page), "printGrid", "javascript:window.print();", true); Page.Response.Redirect(Page. ...

Adjust the image size using CSS within the containing outer div

I am trying to adjust the width of an image using css within typo3. Unfortunately, I only have access to the outer div container which is the custom border of the content element. To make the change, I added the following line to my css file: .Bild-Starts ...

Border concealed by Bootstrap Glyphicons

Is there a reason why glyphicons hide a border of a floated container? Can anyone shed light on this issue and suggest a workaround? Check out this link for more information. https://i.sstatic.net/CXZSd.jpg My setup: OS X 10.11.1, Chrome 47.0.2526.73 (6 ...

The axios GET request suddenly transforms into an Options request, returning a 401 Unauthorized status. Miraculously, Post

I am well-versed in the concept of "preflight request" and my server does indeed support options requests. What perplexes me is that I have tested various online API tools like Postman and reqbin, which work perfectly fine. However, when I attempt to use ...

The height of a div element does not automatically default to 100% in Next.js

I'm encountering an issue with styling pages in next.js. My goal is to create full-height pages. Although I've successfully set the height attribute in the body and html tags to achieve full height (verified in dev tools), I'm struggling to ...

The fluid table within the Bootstrap container is not adapting to different screen

Can't figure out why the bootstrap container fluid table is not responsive. Even though I used an example of My First Bootstrap Page that works fine and is responsive, this particular table remains unresponsive. I want to avoid using a scroll but will ...

After successful sign-in, users will be redirected to the

After mainly working on mobile development, I am now diving into web development. I am currently utilizing firebase.auth() to sign in a user and I'm struggling with how to handle page redirection within my JavaScript/node application. What is the pro ...

When the NODE_ENV is set to 'production', the global error handler middleware fails to log errors

To ensure proper code format, errors are logged and returned to the client using Postman in development mode, but are not sent back to the client in production mode. The following code represents the global error handler: module.exports = (err, req, res, n ...

Using JSON as a parameter in a Grails controller

Struggling with passing a Json array to a Grails controller and then to a Java class? Can't quite figure out how to correctly pass the params to the Java class? Here's the code snippet you need to focus on. AJAX POST: $('#matrixForm&apos ...

Encountering an issue with setting up Pinia in Vue3, as it is showing an error message stating "

I am facing a challenge with my Vue app where the normal reactive store is not working correctly and does not retain the values I have set. Hence, I would like to switch to a Pinia store. After installing Pinia, my main.js file looks like this: import { cr ...

Generating Angular select options dynamically using ng-repeat

I've been struggling for several days now with ngOptions and ngRepeat. I am trying to create a select option for a people control. The REST service is returning an array as shown below. Despite trying various solutions from Stack Overflow and the Angu ...

Toggle between images in Vue.js when an image is clicked

Hey there, I'm pretty new to Vue and could use some assistance with implementing a certain logic. I have a JSON file that contains information about polaroids I've taken, such as their IDs, names, image names, and descriptions. Here's a sni ...