Anyone successful in creating an Excel application?
I can interact with the API but any query that requires authentication I have not been able to find online resources to figure out. Any help would be great.
Really interesting concept. I don't have any experience at all with coding for Excel -- as best as I can tell, it's VBA under the covers? I really can't speak to that much more than what I can find online (mostly related to Twitter):
But, yeah, it seems like people have been able to get OAuth applications working in Excel as long as they construct everything by hand. ie, no obvious OAuth extensions to hook into.
I think that getting an interactive flow working correctly within Excel could be tricky, but once you retrieve a valid access token for a user (after having them go through the 3-legged OAuth steps), you could just keep refreshing that token within the Excel application. So...it seems possible? But a bit tricky to do. The flow described in the link above seems to only be constructing a request given a working access token/secret, while you'd need to build in something to retrieve the access token initially or refresh an existing functional access token, and then make the request.
Raphael, I know this is an old post, but I have an Excel workbook that successfully returns results using the API and OAuth. It was quite the ordeal. There is still some manual parts but I'm sure you could automate them somehow. For me it works. So if you still need it let me know. I'm not sure the best way to get it to you. Also if anyone else is interested let me know. I'm not sure I want to post my email. What would be an alternative to connect?
I haven't used GitHub much at all, but it does seem like a pretty straightforward solution for sharing code:
You can set up a free account to make public repositories, you'd just need to be willing to install a Git client and learn how to use it. It also seems a bit more oriented towards straight code (ie, text) instead of a full Excel workbook, so I'm not sure if just a standard file hosting service might work better. Dropbox is the first one that comes to mind, but I'm sure there are a bunch more out there.
I would definitely also be interested to see how your workbook worked, though. :)