It is currently Fri Mar 29, 2024 1:43 am


Post a new topicPost a reply Page 1 of 1   [ 4 posts ]
Author Message
 Post subject: complicated XML/API/Google docs questions
PostPosted: Sat Sep 22, 2012 4:48 pm 
Site Admin
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
 Profile  
Reply with quote  
 Post subject: Re: complicated XML/API/Google docs questions
PostPosted: Sat Sep 22, 2012 7:55 pm 
Moderator
Moderator
User avatar

Joined: Tue Mar 14, 2006 11:57 am
Posts: 9790
Location: same as it ever was
sorry, but I got nothing on that.

_________________
Ignorance more frequently begets confidence than does knowledge - Charles Darwin


Top
 Profile  
Reply with quote  
 Post subject: Re: complicated XML/API/Google docs questions
PostPosted: Sat Sep 22, 2012 9:22 pm 
Moderator
Moderator
User avatar

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
 Profile  
Reply with quote  
 Post subject: Re: complicated XML/API/Google docs questions
PostPosted: Sun Sep 23, 2012 4:42 am 
Site Admin
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
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post a new topicPost a reply Page 1 of 1   [ 4 posts ]


Who is online

Users browsing this forum: No registered users and 8 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron


Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
twilightBB Style by Daniel St. Jules of Gamexe.net