I have a column of URL's and would like to write a function that hits an API to return a single piece of data for each of them. The API is a simple querystring-based interface, and I want the entire response added to a cell.
A simple example would be to pull the <Title> element from any URL. (WITHOUT the use of the Web Query data connection.) That doesn't work in this case. My goal is to have an easy way to read a cell with a URL and return a piece of HTML content.
I've been searching on this for a few days and haven't found a solution that seems to work.
Any help or links to related posts are appreciated.
Bookmarks