WhatTheTrend twitter top 10 added to Excel cRest library

December 19, 2011 REST API, Visualization Comments Off on WhatTheTrend twitter top 10 added to Excel cRest library
What’s trending on twitter to Excel
In a previous entry, I described how to add new entries to the rest-Excel library.
Here’s another new library entry. WhatTheTrend provide an API for twitter watching. You can use this to get the data straight into Excel.
Here’s the code
Public Sub testWhatTheTrend()
    generalReport restQuery _
        ("whatthetrend", "whatthetrend", , , , , , , , , True) _
        , True
End Sub
Here’s the populated sheet
WhatTheTrend data returned to an Excel Sheet
.
You could use this to automate collecting daily trending topics for example.
The full code along with the other rest library examples can be downloaded in the cDataSet workbook, which is  one of the projects on the ramblings website.
I’ll be adding more to this library from time to time as I come across useful APIS. If you would like to see one implemented, tell me about it at the ramblings forum.
About brucemcp 225 Articles
I am a Google Developer Expert and decided to investigate Google Apps Script in my spare time. The more I investigated the more content I created so this site is extremely rich. Now, in 2019, a lot of things have disappeared or don’t work anymore due to Google having retired some stuff. I am however leaving things as is and where I came across some deprecated stuff, I have indicated it. I decided to write a book about it and to also create videos to teach developers who want to learn Google Apps Script. If you find the material contained in this site useful, you can support me by buying my books and or videos.
Twitter