query from web site (1 Viewer)

IMDB API
by Stavros Korokithakis

Well hello. I see you want to access IMDB programatically. Well, this is your chance. This service is updated every day from the IMDB data files and you can access it with the ?name= URL parameter. For example, this is the episode list (in JSON) for How I Met Your Mother.

This service only supports shows, it does not have any movies.

Click to expand...

OMDb API

The Open Movie Database

The OMDb API is a RESTful web service to obtain movie information, all content and images on the site are contributed and maintained by our users.

Click to expand...

HiTechCoach said:

This may be what you want:


http://imdbapi.poromenos.org/




or

http://omdbapi.com/

Click to expand...

Private Sub Form_Load()

Dim IE As New InternetExplorer
IE.Visible = True
IE.Navigate "http://www.imdb.com/find?ref_=nv_sr_fn&q=" & Me.seriesname.Value
Do
DoEvents
Loop Until IE.ReadyState = READYSTATE_COMPLETE
Dim doc As HTMLDocument
Set doc = IE.Document
Dim div As String
div = Trim(doc.getElementsByTagName("div")(5).innerText)
MsgBox div



End Sub

ashleedawg said:

Since your collection of shows is small, there isn't much benefit to "automatically" getting the posters from the website. (In the time it will take to automate that for multiple sites, you could download hundreds of posters yourself!)

But you can still organize your collection (and links to the posters) in a database. That would be a good starter project for learning to program.

In fact, many others before you have used exactly that as a first project!

Here is a YouTube video called "How to build movie collection database using MS ACCESS 101 Part 1" : https://youtu.be/9wnag6_sD7I

Click to expand...