Questions tagged [xpath]

XPath is a language for addressing parts of an XML document that can be used by some web apps like Google Sheets to import structured data.

10 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
0answers
655 views

My ImportXML with XPath doesn't work

I've got a problem. I'm trying to import data in my google sheet document using =ImportXML with XPath from this page : https://www.boursorama.com/bourse/produits-de-bourse/cours/warrants/...
1
vote
0answers
76 views

Function always parses column in first row but would like it to repeat

I am trying to make a function that repeats in each row of a column that fetches the URL in the first column, does an xpath query and gets an image. Currently its all working other than the fact it ...
0
votes
0answers
14 views

Pull “Fair Value” from Yahoo Finance to Google Sheet using XPath?

Currently, I am using xPath to grab Ex-Div date, Dividends, etc but I cannot seem to be able to grab the Fair Value "Undervalue" rating from Yahoo Finance. I want the "Undervalue" to be specific but ...
0
votes
0answers
26 views

xPath_query from IMPORTXML in Google sheets ends up empty

So, in these covid19-infested days I want to update our digital signage with the current situation. Want to use google sheets and IMPORTXML to fetch data from a website that is frequently updated with ...
0
votes
0answers
22 views

Creating a Table in Google Sheets from XML Output with Multiple Children Levels

How to create a table in Google Sheets from an XML output with multiple children levels? I'm trying to create a table in Google Sheets with data sourced from an XML output. The XML source is here. ...
0
votes
1answer
61 views

ImportXML error: 'imported content is empty' when selecting for text within a list item

I want to scrape a text within this website in google sheets with the IMPORTXML function. Through dev tools by inspecting the text in question, I get the corresponding HTML: <li _ngcontent-udl-c4="...
0
votes
0answers
31 views

How to find the original source to get the xPath

I'm trying to get an updating list from a store on Taobao.com I've tried using importxml to get the list using xpath but I keep getting "import content is empty" error. =IMPORTXML("https://...
0
votes
0answers
71 views

How to fetch data in Google sheet using Import XML function with Xpath?

https://www.monito.com/send-money/australia/india/aud/inr/1000 Please open the URL and see what Query should I put to extract following data (=IMPORTXML("https://www.monito.com/send-money/australia/...
-1
votes
1answer
92 views

Scraping currency conversion rate from Oanda.com

A currency conversation formula for example: =GOOGLEFINANCE("CURRENCY:"&C$2, "price", A3,) Will display the closing price by default under "price". There is no option for the Average price. ...
-1
votes
2answers
98 views

Get translation using Google Sheets and IMPORTXML

I want to scrap the phonetic guide for a translation in Google Translator using Google Sheets. For instance, if you enter the page: https://translate.google.com/#view=home&op=translate&sl=...