The Movie Database Support

I can successfully retrieve basic details of Family Guy / Season:19 / Episode:4 using...

steve@ramp6:~$ curl -sS 'https://api.themoviedb.org/3/tv/1434/season/19/episode/4?api_key=<MYAPIKEY>'  | jq 'del(.crew, .guest_stars)'
{
  "air_date": "2020-11-01",
  "episode_number": 4,
  "name": "CutawayLand",
  "overview": "Peter and Lois accidentally set up a cutaway gag together, which somehow transports them into the cutaway itself.",
  "id": 2444783,
  "production_code": "FG-1801",
  "runtime": 22,
  "season_number": 19,
  "still_path": "/1LKzhtXfgQupIxIxB8Nc0py3Yat.jpg",
  "vote_average": 5.2,
  "vote_count": 4
}

...and I can retrieve the external imdb_id for Family Guy / Season:19 / Episode:4 using...

steve@ramp6:~$ curl -sS 'https://api.themoviedb.org/3/tv/1434/season/19/episode/4/external_ids?api_key=<MYAPIKEY>'  | jq
{
  "id": 2444783,
  "imdb_id": "tt13154418",
  "freebase_mid": null,
  "freebase_id": null,
  "tvdb_id": 7957852,
  "tvrage_id": null,
  "wikidata_id": "Q105236735"
}

AND I can successfully retrieve basic details of Shakespeare: The Animated Tales / Season:1 / Episode:1 using...

steve@ramp6:~$ curl -sS 'https://api.themoviedb.org/3/tv/47361/season/1/episode/1?api_key=<MYAPIKEY>' | jq 'del(.crew, .guest_stars)'
{
  "air_date": "1992-11-09",
  "episode_number": 1,
  "name": "A Midsummer Night's Dream",
  "overview": "Four young lovers, trying to resolve their passions, and six worthy workmen, trying to rehearse a play, stumble about in a dark, haunted wood, while the powerful spirits play havoc with their hearts and minds.",
  "id": 1957421,
  "production_code": "",
  "runtime": 25,
  "season_number": 1,
  "still_path": null,
  "vote_average": 10.0,
  "vote_count": 1
}

..BUT when I try to retrieve the external imdb_id for Shakespeare: The Animated Tales / Season:1 / Episode:1 using the same api call IT FAILS...

steve@ramp6:~$ curl -sS 'https://api.themoviedb.org/3/tv/47361/season/1/episode/1/external_ids?api_key=<MYAPIKEY>' | jq
{
  "id": 1957421,
  "imdb_id": null,
  "freebase_mid": null,
  "freebase_id": null,
  "tvdb_id": null,
  "tvrage_id": null,
  "wikidata_id": null
}

Am I doing something wrong, or is there a problem with the database? When I access themoviedb.org in my browser, I can navigate to... https://www.themoviedb.org/movie/841826-a-midsummer-night-s-dream/edit?active_nav_item=external_ids&language=en-GB ...where the "external ID" details page correctly shows imdb_id = tt0762488

5 replies (on page 1 of 1)

Jump to last post

Hi @FumbleFingers,

I'm not sure I'm following. What does movie ID 841826 have to do with anything related to with either Family Guy (id 1434) or Shakespeare: Animated Tales (id 47361)?

ID 841826 is a movie, which is completely unrelated to anything related to TV...

Hi Travis,

You say (tmdb) ID 841826 is a movie, not related to Shakespeare: Animated Tales (id 47361). But I'm looking at it in another browser window... https://www.themoviedb.org/movie/841826-a-midsummer-night-s-dream?language=en-GB ...which shows me... A Midsummer Night's Dream (1992) 09/11/1992 (GB) 26m ...being the first episode of the first season of Shakespeare: Animated Tales (id 47361), which I'm also looking at in this browser window... https://www.themoviedb.org/tv/47361-shakespeare-the-animated-tales

I listed "Case 1" with two api calls for Family Guy because they show I'm successfully accessing the basic details in case 1 with... 1A curl -sS 'https://api.themoviedb.org/3/tv/1434/season/19/episode/4?api_key=' ...and retrieving the imdb_id of that episode with... 1B curl -sS 'https://api.themoviedb.org/3/tv/1434/season/19/episode/4/external_ids?api_key='

AND I get basic details with the same api call in "Case 2" for Shakespeare: Animated Tales with... 2A curl -sS 'https://api.themoviedb.org/3/tv/47361/season/1/episode/1?api_key=' BUT the corresponding attempt to get the imdb_id of that episode... 2B curl -sS 'https://api.themoviedb.org/3/tv/47361/season/1/episode/1/external_ids?api_key=' | jq ...just returns me... { "id": 1957421, "imdb_id": null, "freebase_mid": null, "freebase_id": null, "tvdb_id": null, "tvrage_id": null, "wikidata_id": null } ...but I know that 26-minute episode has imdb_id tt0762488 because I can see it on imdb.com... https://www.imdb.com/title/tt0762488/?ref_=ttrel_ov ...AND I can see the correct imdb_id on themoviedb.org https://www.themoviedb.org/movie/841826-a-midsummer-night-s-dream/edit?active_nav_item=external_ids&language=en-GB

I just can't see what I'm doing wrong. The code in my c++ app seems to be working ok for several other series - Family Guy, The Simpsons, The Enmglish (2022), Crisis in Six Scenes... It just fails on Shakespeare: Animated Tales.

@FumbleFingers said:

Hi Travis,

You say (tmdb) ID 841826 is a movie, not related to Shakespeare: Animated Tales (id 47361). But I'm looking at it in another browser window... https://www.themoviedb.org/movie/841826-a-midsummer-night-s-dream?language=en-GB ...which shows me... A Midsummer Night's Dream (1992) 09/11/1992 (GB) 26m ...being the first episode of the first season of Shakespeare: Animated Tales (id 47361), which I'm also looking at in this browser window... https://www.themoviedb.org/tv/47361-shakespeare-the-animated-tales

Movies and TV episodes are 2 separate things in our database. Even if, like it's the case here, episodes of an anthology series can also be listed as movies.

I listed "Case 1" with two api calls for Family Guy because they show I'm successfully accessing the basic details in case 1 with... 1A curl -sS 'https://api.themoviedb.org/3/tv/1434/season/19/episode/4?api_key=' ...and retrieving the imdb_id of that episode with... 1B curl -sS 'https://api.themoviedb.org/3/tv/1434/season/19/episode/4/external_ids?api_key='

For this episode, the IMDB Id is present in our database. So, we can return it.

AND I get basic details with the same api call in "Case 2" for Shakespeare: Animated Tales with... 2A curl -sS 'https://api.themoviedb.org/3/tv/47361/season/1/episode/1?api_key=' BUT the corresponding attempt to get the imdb_id of that episode... 2B curl -sS 'https://api.themoviedb.org/3/tv/47361/season/1/episode/1/external_ids?api_key=' | jq ...just returns me... { "id": 1957421, "imdb_id": null, "freebase_mid": null, "freebase_id": null, "tvdb_id": null, "tvrage_id": null, "wikidata_id": null } ...but I know that 26-minute episode has imdb_id tt0762488 because I can see it on imdb.com... https://www.imdb.com/title/tt0762488/?ref_=ttrel_ov ...AND I can see the correct imdb_id on themoviedb.org https://www.themoviedb.org/movie/841826-a-midsummer-night-s-dream/edit?active_nav_item=external_ids&language=en-GB

For this episode, the IMDB Id is not present in our database. So, we can't return it.

The fact that this episode of an anthology has also a movie entry in our database and that this entry include the IMDB Id doesn't change this. There are no link between the 2 entries in the database.

I just can't see what I'm doing wrong. The code in my c++ app seems to be working ok for several other series - Family Guy, The Simpsons, The Enmglish (2022), Crisis in Six Scenes... It just fails on Shakespeare: Animated Tales.

Your code is not failing. It return the correct data. No IMDB Id are available on the "Shakespeare: Animated Tales" episode.

All our data are entered by our users. So, feel free to add the missing data.

Hi superboy97,

Thank you so much for taking the trouble to explain all that. I just have one small final question before I roll up my sleeves and try to figure out how to make my code do what I want here...

You say "The fact that this episode of an anthology has ALSO a movie entry in our database..." Do you mean that (at least SOMETIMES and/or TEMPORARILY), a video may be present as BOTH "Movie" and "Episode within Season within Series" in themoviedb database?

I had to resolve some problems with my app last year because themoviedb classifies most "Tom and Jerry" episodes as "Movies", but I suspect the way I dealt with that was based on the assumption that everything would be recorded as EITHER a Movie OR an Episode, not BOTH.

Once again, thank you for the prompt response.

Regards - Fumblefingers

@FumbleFingers said:

You say "The fact that this episode of an anthology has ALSO a movie entry in our database..." Do you mean that (at least SOMETIMES and/or TEMPORARILY), a video may be present as BOTH "Movie" and "Episode within Season within Series" in themoviedb database?

Yes, there are such cases. They are listed here.

Can't find a movie or TV show? Login to create it.

Global

s focus the search bar
p open profile menu
esc close an open window
? open keyboard shortcut window

On media pages

b go back (or to parent when applicable)
e go to edit page

On TV season pages

(right arrow) go to next season
(left arrow) go to previous season

On TV episode pages

(right arrow) go to next episode
(left arrow) go to previous episode

On all image pages

a open add image window

On all edit pages

t open translation selector
ctrl+ s submit form

On discussion pages

n create new discussion
w toggle watching status
p toggle public/private
c toggle close/open
a open activity
r reply to discussion
l go to last reply
ctrl+ enter submit your message
(right arrow) next page
(left arrow) previous page

Settings

Want to rate or add this item to a list?

Login