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
Un film, une émission télévisée ou un artiste est introuvable ? Connectez-vous afin de créer une nouvelle fiche.
Vous souhaitez évaluer ou ajouter cet élément à une liste ?
Pas encore membre ?
Réponse de Travis Bell
le 30 septembre 2024 à 13h05
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 (id1434
) or Shakespeare: Animated Tales (id47361
)?ID
841826
is a movie, which is completely unrelated to anything related to TV...Réponse de FumbleFingers
le 30 septembre 2024 à 20h02
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.
Réponse de superboy97
le 1 octobre 2024 à 00h50
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.
For this episode, the IMDB Id is present in our database. So, we can return it.
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.
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.
Réponse de FumbleFingers
le 1 octobre 2024 à 10h37
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
Réponse de superboy97
le 1 octobre 2024 à 11h57
Yes, there are such cases. They are listed here.