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

learn more… | top users | synonyms

-1
votes
0answers
7 views

Parsing XML on Google apps script [migrated]

Here's my XML: <?xml version="1.0" encoding="UTF-8" ?> <response> <records> <record id='1'> <column name="Name"><value><![CDATA[John]]&...
0
votes
1answer
69 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
59 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
112 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
34 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
65 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
156 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 ...
1
vote
1answer
354 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. ...
2
votes
0answers
34 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 ...
2
votes
1answer
207 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 ...
1
vote
2answers
973 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 ...
2
votes
1answer
116 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: ...
3
votes
1answer
473 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
3
votes
3answers
544 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
0answers
249 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 ...
1
vote
1answer
762 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 <...
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> <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 ...