Or at least to a spread sheet....

Hi bgidcomb,

You would have to have some programming experience that could use our API to import the data directly into Access or, convert it to a .CSV (or something similar) that could be read by Excel.

We don't have any automated way of doing anything like that right now.

I admit that I am very limited on my programming knowledge. I just started learning all that while making this database. I know access will use the code if it is set up correctly. I just didnt know if anyone had already written a code that reads the movie title then updates the rest of the info.

Is there at least a way to export the API to an xml file or anything?

I have figured out how to get access to open the page I need to import the information. I can't seem to figure out how to change the "ID" portion of the url to reflect the saved movie id. The code seems to get stuck there with every variation I have tired. Any Ideas?

Hi bgidcomb,

Not many, unfortunately. Can't say I've even ever opened Access before. I'm not much help.

How would you change the id portion of the url in any other code?

and now all I get is an Invalid api key

Well, usually you'd have some kind of counter, and iterate over each number requesting the every time. In Ruby, assuming your range was 1 to 10 (just as an example) it would look something like this:

require 'rubygems'
require 'rest_client'

headers  = { :accept => "application/json", :params => { :api_key => "###" } }
url = "http://api.themoviedb.org/3/movie"

(1..10).each { |id|
  response = RestClient.get "#{url}/#{id}", headers
  puts response
}

But I truly don't have a clue about Access.

EURIKA!!! I GOT IT!! Just in case anyone wants to know... the code looks like this

Private Sub Command571_Click()
        
Dim z As Variant
Dim strURL1 As String
Dim strURL2 As String
Dim strURL As String
Dim MyResult As String
Dim Path As String
Dim ID As String

    ID = Me.TMDbId
    strURL1 = "http://api.themoviedb.org/3/movie/"
    strURL2 = "?api_key=###"
    strURL = (strURL1 + ID + strURL2)
    Path = "C:\Program Files (x86)\Google\Chrome\Application\chrome.exe"
    z = Shell(Path + " " + strURL, vbNormalFocus)
    
End Sub