www.renegadeheroes.com :: View topic - complicated XML/API/Google docs questions

www.renegadeheroes.com http://renegadeheroes.com/forum3/

complicated XML/API/Google docs questions http://renegadeheroes.com/forum3/viewtopic.php?f=2&t=14846	Page 1 of 1

Author:	AnxietyClown [ Sat Sep 22, 2012 4:48 pm ]
Post subject:	complicated XML/API/Google docs questions
Okay, good luck with this, here we go. I want to set up a spreadsheet in google docs (could do it in excel as well). Column A will be a TWITTER USER NAME. Column B and Column C will be variable data that is fetched from twitter regarding the twitter user in column A. Here's the good news. i have enough of a working understanding of the twitter API that I know how to call a URL to querry a user name and get the information I need for Column B and Column C. The information from the URL/API call is in XML format. Here's what I need to know how to do: write a formula in Column B that says: query this URL and accept the XML return, extract THIS SPECIFIC FIELD from the XML doc that comes back and populate this cell with the data. and then the same thing for column C. I know this is actually possible, but I am struggling with figuring out how to retrieve data from a url from within excel and then how to parse a single variable in the xml results into a cell.

Author:	nooobieee [ Sat Sep 22, 2012 7:55 pm ]
Post subject:	Re: complicated XML/API/Google docs questions
sorry, but I got nothing on that.

Author:	Earl [ Sat Sep 22, 2012 9:22 pm ]
Post subject:	Re: complicated XML/API/Google docs questions
You're better off learning some scripting language and having it output a CSV file. I doubt excel has good support (if any) for making HTTP requests and parsing XML.

Author:	AnxietyClown [ Sun Sep 23, 2012 4:42 am ]
Post subject:	Re: complicated XML/API/Google docs questions
Excel has a function that queries a URL and accepts XML in return (i got that far last night in my tinkering). But I have to manually input the URLS rather than being able to pull the URLS from a different cell on the spread sheet. Working on it.

Page 1 of 1	All times are UTC - 8 hours [ DST ]
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/