Google-sheets – How to match XPath for Sheets IMPORTXML formula

google sheetsimportxml

New with IMPORTXML, and having trouble matching the XPath on my URL

The URL is https://phlanx.com/engagement-calculator?insta=accelerateokanagan

The value I am trying to extract is the orange 4.4% on the page.

So far I have tried:

Using the XPath Finder Firefox Add-on, which gave me an XPath of /html/body/div[2]/div[1]/div[1]/article/div/div/div/div/div/div[3]/h4

But I got this error:

Error Imported content is empty.

My total formula is:

=IMPORTXML("https://phlanx.com/engagement-calculator?insta=accelerateokanagan","/html/body/div[2]/div[1]/div[1]/article/div/div/div/div/div/div[3]/h4")

I have set up a test spreadsheet here.

Best Answer

In my environment, values from tags couldn't be retrieved. If your situation is the same with me, for example, how about this? Please think of this as one of several answers. https://phlanx.com/engagement-calculator?insta=accelerateokanagan is put in a cell "A1".

=INDEX(ARRAYFORMULA(REGEXEXTRACT(IMPORTXML(A1, "//body"),"@accelerateokanagan ENGAGEMENT RATE (\d.+%)")), 1, 6)

If you want only the number, please use this.

=INDEX(ARRAYFORMULA(REGEXEXTRACT(IMPORTXML(A1, "//body"),"@accelerateokanagan ENGAGEMENT RATE (\d.+)%")), 1, 6)

Result :

If this was not useful for you, I'm sorry.

Related Solutions

Google Sheets – ImportXML with XPath Not Returning Table Entry

It's because of <tbody>. There is no <tbody> in the HTML source. Browser puts it there (on its own; nothing to do with JavaScript on the page) because it believes it should be there, according to HTML spec.

Just remove /tbody from the path:

=IMPORTXML( "https://eresearch.fidelity.com/eresearch/evaluate/fundamentals/keyStatistics.jhtml?stockspage=keyStatistics&symbols=aapl" , "//div[@id='audit-integrity'][1]/table/tr[10]/td[2]")

And in general: when XPath doesn't work, debug by removing all of the selectors, then adding one by one until the formula breaks...

Google-sheets – ImportXML formula no longer working

Something went wrong on Google's side, apparently. Other stock symbols import correctly. My uneducated guess is that there was a transmission error and a corrupted fetch result got stuck in Google's cache. I was able to break the cache by adding a redundant URL parameter: http://www.bloomberg.com/quote/7501:JP?param=1 fetched correctly.

By the way, the selector @class='price-container down' will only fetch the price if it's going down, because otherwise the classes will be price-contained up. To fetch the data in either case, use contains(@class,'price-container') instead:

=ImportXML("http://www.bloomberg.com/quote/7501:JP?param=1", "//div[contains(@class,'price-container')]//div[@class='price']")

Best Answer

Result :

Related Solutions

Google Sheets – ImportXML with XPath Not Returning Table Entry

Google-sheets – ImportXML formula no longer working

Related Topic