Adding to the crest- Excel Library

Following the post earlier on rest-jSon-Excel in one line of code , I found that you can do the research and add a new library entry in about 10 minutes.

Here is a query to populate an Excel sheet with all the movies a particular actor has every made, using the itunes rest API.

Public Sub testItunesMovie()
    generalQuery "itunesmovie", "itunes movie", _
        InputBox(prompt:="Enter your itunes movie search query (eg. actor name)", _
             Title:="itunes API query:results to the itunesmovie worksheet")
End Sub

Here’s the library entry

 

Case "itunes movie"
            If abandonType(sEntry, qType, erSingleQuery) Then Exit Function
            sUrl = "http://itunes.apple.com/search?entity=movie&media=movie&term="
            sResults = "results"
            bTreeSearch = False

And here’s the result, using Peter Fonda as the query, so let’s have your suggestions on other cool Apis.

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.