Author |
Message |
AnxietyClown
|
Post subject: complicated XML/API/Google docs questions Posted: Sat Sep 22, 2012 4:48 pm |
|
Site Admin |
|
Joined: Mon Mar 13, 2006 3:24 pm Posts: 9265
|
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.
_________________ "A problem cannot be solved with the same level of awareness that created it" - Albert Einstein
http://www.thehandsondad.com
|
|
Top |
|
|
nooobieee
|
Post subject: Re: complicated XML/API/Google docs questions Posted: Sat Sep 22, 2012 7:55 pm |
|
Moderator |
|
|
Joined: Tue Mar 14, 2006 11:57 am Posts: 9797 Location: same as it ever was
|
sorry, but I got nothing on that.
_________________ Ignorance more frequently begets confidence than does knowledge - Charles Darwin
|
|
Top |
|
|
Earl
|
Post subject: Re: complicated XML/API/Google docs questions Posted: Sat Sep 22, 2012 9:22 pm |
|
Moderator |
|
|
Joined: Mon Mar 13, 2006 12:27 pm Posts: 2474 Location: San Francisco, CA
|
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.
_________________ ============================================== "Jurisprudence Fetishist Gets off on a Technicality" -The Onion
|
|
Top |
|
|
AnxietyClown
|
Post subject: Re: complicated XML/API/Google docs questions Posted: Sun Sep 23, 2012 4:42 am |
|
Site Admin |
|
Joined: Mon Mar 13, 2006 3:24 pm Posts: 9265
|
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.
_________________ "A problem cannot be solved with the same level of awareness that created it" - Albert Einstein
http://www.thehandsondad.com
|
|
Top |
|
|