Suport de The Movie Database

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 resposta (a les pàgines 1 de 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.

No trobeu una pel·lícula o una sèrie? Inicieu la sessió per a crear-la.

Global

s centra la barra de cerca
p obre el menú del perfil
esc tanca una finestra oberta
? obre la finestra de dreceres de teclat

A les pàgines de materials

b torna enrere (o la superior quan sigui aplicable)
e ves a la pàgina d’edició

A les pàgines de temporades

(fletxa dreta) ves a la temporada següent
(fletxa esquerra) ves a la temporada anterior

A les pàgines d'episodis

(fletxa dreta) ves a l'episodi següent
(fletxa esquerra) ves a l'episodi anterior

A totes les pàgines d'imatges

a obre la finestra d'afegir imatges

A totes les pàgines d'edició

t obre el selector de traducció
ctrl+ s envia el formulari

A les pàgines de debat

n crea un debat nou
w canvia l'estat de visualització
p canvia públic/privat
c tanca o obre
a obre activitat
r resposta al debat
l ves a la darrera resposta
ctrl+ enter envieu el vostre missatge
(fletxa dreta) pàgina següent
(fletxa esquerra) pàgina anterior

Configuracions

Desitgeu valorar o afegir aquest element a una llista?

Inicieu la sessió