Extensible Markup Language - a set of rules for encoding documents in machine-readable form.

learn more… | top users | synonyms

0
votes
1answer
14 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
85 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
103 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: ...
2
votes
1answer
179 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
30 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
42 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 ...
1
vote
1answer
250 views

IMPORTXML Google Spreadsheet Amazon review numbers

I am making a spreadsheet which requires me to have the number of amazon reviews of a product. I looked up how to dynamically update the reviews as more came in and came across the IMPORTXML formula. ...
1
vote
1answer
109 views

ImportXML formula no longer working

Here is the formula: =ImportXML("http://www.bloomberg.com/quote/7501:JP", "//div[@class='price-container down']//div[@class='price']") As of several days ago, this formula stopped working. Why ...
2
votes
0answers
33 views

Import site URLs to Google Sheet (and add new row each time)

I am trying to make a list of site pages that will automatically update in Google Sheets, while keeping the full history rather than overwriting older rows with new ones. I see two possible ways of ...
3
votes
2answers
498 views

Import current price from website to spreadsheet

As you can probably gather from the title, the goal is to plug the current price of this product into a spreadsheet. Perhaps I'm over-complicating things, but there must be an easy way to do this. ...
1
vote
2answers
780 views

Parsing JSON with IFTTT?

I'd like to create an IFTTT action that allows triggers based upon a certain electricity price threshold. This Xively feed can return the current price in either JSON, XML, or CSV formats. Xively's ...
1
vote
1answer
758 views

If This Then That (ifttt) Preserve Whitespace RSS Feed

Can anyone help me out with a method to preserve white space/line breaks in an RSS-feed-to-email ifttt task? I have tried using xml:space="preserve", <![CDATA[ <br> ]]> and just plain ...
3
votes
1answer
436 views

How to extract website title into row?

How to extract title (or other meta descriptions) of the website into row using Google Docs? E.g. www.google.com
1
vote
0answers
244 views

edX numerical input error “Sorry couldn't parse formula” when using inequalities

I am trying to create a question on edX Studio where the answer is an inequality. As far as I understand edX used the Mathjax library for which \ge or &ge; represent the ≥ symbol. I can use \ge ...
2
votes
1answer
322 views

Fetching category based XML Feeds

I am working on a web app for which I have to fetch RSS feeds for a specific website. Initially I was using Yahoo pipes but later on I found Yahoo pipes can not filter feeds as per categories. So ...
2
votes
0answers
333 views

Is there an online XML generator to generate xml code from a list of values ? [closed]

Is there an online XML generator to generate XML code from a list of values ? i.e. Value1 Value2 Value3 Value4 Value5 Value6 <item>Value1</item> <item>Value2</item> ...
1
vote
2answers
3k views

How to get Google search results in a simpler format?

Google search requires a JS enabled web browser to display the results. But I want a simple XML or JSON format, so my app can parse it. I looked into Web Search API but it is deprecated. I looked ...