The Movie Database Support
Support → API Support
How to get full list of series IDs by filtering and paging?
posted by bennyaeSTAFFMOD on July 2, 2015 at 8:06 PM
hi
I want to get all the TV shows info.
Then if i do http://api.themoviedb.org/3/discover/tv?api_key=mykey. I can see "total_pages": 3093, "total_results": 61856
But there is a max page limit 1000, which means i can not get page further than 1000.
But if i do filter by air_date:
http://api.themoviedb.org/3/discover/tv?api_key=mykey&first_air_date.lte=2000-01-01
I get: "total_pages": 375, "total_results": 7487
and
http://api.themoviedb.org/3/discover/tv?api_key=mykey&first_air_date.gte=2000-01-01 i get: "total_pages": 802, "total_results": 16021
7487+16021 = 23508
The total numbers are not even close.
So how can i get all of these IDs?
Thanks.
Reply by Travis Bell
on July 3, 2015 at 5:34 PM
Hi bennyae,
If you would like to bring down all of the data, you would be best to iterate though the ids instead. Start ad id 1 and run all the way up to the latest id found in /tv/latest. Discover isn't designed for this task.
Reply by swagle
on September 5, 2017 at 12:13 AM
Hi Travis, this link is not deprecated. We would like to bring down all the TV data but would like to know how many records there are an the /tv/latest is deprecated. Can you tell me how else we can do this. Thank you.
Reply by Travis Bell
on September 5, 2017 at 10:13 AM
@swagle The new link to /tv/latest is here.
A lot of has changed since 2015, if you are wanting to get all of the valid TV ids, you're better off using the newer daily ID exports. You can read about this here.
Reply by Purshotham
on June 20, 2019 at 12:58 PM
I there a way where we can limit the list size per page?
Reply by Travis Bell
on June 20, 2019 at 1:23 PM
Hi @Purshotham, no, all of our page sizes are locked at 20 items.