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.
1
vote
1answer
33 views
Import Bitcoin price in EUR using the IMPORTXML fucntion
Hello does anybody know how to import the Bitcoin price in euro into a Google Sheets document by using the IMPORTXML function?
I am as far as I get the Bitcoin USD price -
=IMPORTXML("https://...
0
votes
1answer
299 views
Google Spreadsheet IMPORTXML problem to extract from a web page
I'm trying to extract the "Comestibilité" and "Remarques" parts from a page using IMPORTXML in my Google Spreadsheet but I just can't get to them, they are generated by JavaScript but I cannot figure ...
0
votes
0answers
26 views
XPath to a div with dynamic id on Facebook
I have created a simple iMacros automation flow to get the embed code for each given Facebook post ID.
I used XPath to find the menue button on the top right of the post and then automatically click ...
1
vote
0answers
264 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/...
0
votes
1answer
107 views
Unable to importxml from this URL
I am trying to fetch url using =importxml in Google Sheets, but getting error message, could not connect to url.
He is the formula which I am using:
=IMPORTXML("https://api.exotel.com/v1/Accounts/...
1
vote
0answers
64 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
2answers
4k views
Google Sheets importxml() can't fetch from this URL
I'm trying to fetch a piece of data using importxml() but it just fails with "Loading..." and never resolves. Other pages have no such problem at all, just this one and I don't know why.
Here is the ...
0
votes
1answer
1k views
Query to Import HTML / XML Data Into Google Spreadsheets
I'm using Google Spreadsheets to retrieve a data table ('id=idp6855942304') from this site. The full sets of tables can be viewed by clicking on "All Reports" from the menus on the left side of the ...
1
vote
2answers
3k views
How to Determine the Xpath Query to a Datapoint in a Table for Use with IMPORTXML?
I'm looking to retrieve the most recent financial figure for a single data point from a table using IMPORTXML.
The target page displays three sets of financial figures for a company on quarterly and ...
3
votes
1answer
739 views
Using Google Spreasheet's IMPORTXML Function to Download Selected Multiple Columns
I use Excel's XML mapping to download RSS feeds and select elements to display in column. I'm currently using Google Spreadsheet's IMPORTXML functions and trying to recreate my below Excel results.
...
2
votes
1answer
364 views
Present importXML output in reverse order
How to reverse the order of the output of imporxml? For example, =importxml("http://example.com","//p") outputs
+---+---------------------+
| 1 | This domain is ... |
| 2 | More information... |
+--...
1
vote
1answer
2k views
Prevent importXML from spilling text across multiple columns
When importing chat transcript by importXML, e.g.,
=IMPORTXML("http://chat.stackexchange.com/transcript/7/2015/8/13", "//div[@class='content']")
I find that some messages split across several ...
3
votes
1answer
2k views
ImportXML with XPath does not return an entry of a table
Using Google Sheets with IMPORTXML to scrape a piece of information from a website via XPath.
Here's the site (click here).
The specific piece of information I'm trying to extract is the Price/Sales ...
2
votes
1answer
560 views
Extracting GICS codes from Fidelity website
This is the website:
https://eresearch.fidelity.com/eresearch/goto/evaluate/snapshot.jhtml?symbols=aapl&type=o-NavBar
I'm trying to pull out the following two pieces of data into a Google Sheet:
...
0
votes
1answer
197 views
Unable to import pricing info from toysrus.com into a Google Spreadsheet
I'm trying to pull live pricing from a given toysrus.com item into a Google Spreadsheet (one item/price per row), and am having no luck whatsoever. Importxml(url, xpath) does not work (similar to the ...
1
vote
2answers
1k views
xpath to get non-distinct parent node data for each child node
Google Spreadsheets has an IMPORTXML function, which I am trying to use to maintain a list of TV episodes, based on the API at http://services.tvrage.com/feeds/episode_list.php?sid=3183.
I am trying ...
-1
votes
1answer
3k views
Google Docs ImportXML can't scrape anymore?
ImportXML lets you get information from filetypes such as xml, html, csv, tsv, as well as RSS and Atom feeds.
This example in Google Docs Help for importXml function -
=importXml("toysrus.com";; "/...
3
votes
1answer
699 views
In Google Spreadsheets the xPath method with Google Maps don't work anymore?
I've used this query to calculate distance between two locations, now it won't work anymore, and returns the error xPath query didn't get any result (translated from Italian, I don't know if is the ...
