Hot answers tagged

3

Based on Normal Human's answer, I've created a Google sheets script that will parse and email IFTTT based on a price threshold. Google sheet cells won't update ImportXml() or other external site data more than once every hour or so, even using workarounds. However, accessing external sites via the script works. Use the following script and set up a ...


1

IMPORTXML only is able to access public web resources but he URL in the formula requires user and password so it couldn't be reached.


1

Short answer The problem is the xPath, specifically the /tbody part as it's not present in the source code. Explanation The source html code of the page doesn't include the tbody tag. It's added by the browser when it is missed to create a DOM hierarchy but the algorithm behind IMPORTXML doesn't do the same, it requires the xPath for the original source ...


1

EDIT: So If your interested in trying google apps script, here is short simple script that grabs the piece you want: function getOpenInterest(url) { var found, html, content = ''; var response = UrlFetchApp.fetch(url); if (response) { html = response.getContentText(); if (html) content = html.match(/OPEN INT:<BR><FONT size=1 color='#...


1

I have a feed setup that posts to tumblr and I've never had issues with spacing. Looking at it seems to be that the <p> and <br \> tags are respected by ifttt. Here's snippet (note, it's a vent anonymously site so I'm trying to find a safe one). This is from the <content:encoded> section of a wordpress xml feed <content:encoded> ...


1

The categorized RSS feed links might differ from site to site, CMS to CMS. For the given website, I did a quick google search for filetype:xml site:atvn.org(click it). It seems they have feed links like this - www.atvn.org/alumni/rss.xml www.atvn.org/blogs/rss.xml www.atvn.org/user/rss.xml www.atvn.org/news/2012/rss.xml etc. From the search results, this ...


Only top voted, non community-wiki answers of a minimum length are eligible