Hi @Yaseen55,

You need to use the page parameter.

https://api.themoviedb.org/3/discover/movie?api_key=###&sort_by=popularity.desc&with_genres=28&page=1
https://api.themoviedb.org/3/discover/movie?api_key=###&sort_by=popularity.desc&with_genres=28&page=2
https://api.themoviedb.org/3/discover/movie?api_key=###&sort_by=popularity.desc&with_genres=28&page=3

Etc...

Hi @travisbell i know that as i said i can specify the page but like that if there is 500 pages out there i have to send 500 requests!!

Hi @Yaseen55.

You are right: the only way to get all results is to process each result page (and to use 500 requests in your example). You cannot specify in the request the number of results by page.

Best regards.

i know that as i said i can specify the page but like that if there is 500 pages out there i have to send 500 requests!!

That's normal. Typically, you need to query all pages only if you are trying to make some local mirror of TMDB dataset and in this case you can wait a while for all pages to download. You can use more download threads if you need to speed things up.

@talestalker thanks, could you give me a hint how to query all pages? I'm kinda new at this things

@bcourtine that's not fun!

could you give me a hint how to query all pages?

You must make 500 separate queries. But it really isn't that bad, as it takes just ~70 seconds to download all 500 pages with one thread and ~4 seconds using 32 threads.

#Simple python solution to do this
df = pd.DataFrame(
for i in range(1,500):
        url = f'https://api.themoviedb.org/3/discover/movie?include_adult=false&include_video=false&language=en-US&page={i}&sort_by=popularity.desc&api_key={api_key}'
        response = requests.get(url)
        temporary_df = pd.DataFrame(response.json()['results'])
        df = pd.concat([df,temporary_df],ignore_index=True)

HEY HOW DO I KNOW THE TOTAL NUMBER OF PAGES AVALIAVLE?

You are getting the total number of pages in every response to discover method:

{
  "page": 1,
  "results": [
   ...
  ],
  "total_pages": 38808,
  "total_results": 776151
}

You can query only first 500 pages, though.