I don't think I can answer your question.
But I know it would be better if you provided more information.

@bverdoorn said:
I created a list of 800 movies

That list you created, what data does it contain? What fields?

and I would like to download the basic fields (id, title, release_date, overview, genres, popularity, etc.) via the API.

Which fields do you want the data? There can't be etc ... there.

I was able to get 500 records out,

How did you get the data for those first 500?
And how is this data stored?
A single table? One .NFO file for each movie?

Google Translate

The list was created in TMDB, The 500 records that I downloaded via the API into Python contained the following fields (vote_count, popularity, id, video, media_type, vote_average, title, release_date, original_language, original_title, genre_ids, backdrop_path, adult, overview, poster_path, original_name, name, origin_country, first_air_date). These were the fields that were delivered through the GET /list/{list_id} method via the API. Thanks for the quick reply.

I personally never used this feature.
But I believe that using Lists in V4 mode it is possible to import an unlimited amount of items.
What I don't know, because I don't use it, is whether there is a quantity limitation when making an GET API Request.
But I think it’s worth taking a look.
https://developers.themoviedb.org/3/lists/v4-or-v3-lists

Yes, the best way to accomplish this will be to page through the results on a v4 list. This way you can get all of the items.

@travisbell said:

Yes, the best way to accomplish this will be to page through the results on a v4 list. This way you can get all of the items.

But v3 or v4 lists? says "You can import "unlimited" items in a single request". How can we achieve this when there is a page parameter that defaults to 1 in list details API?

@shahood said:

@travisbell said:

Yes, the best way to accomplish this will be to page through the results on a v4 list. This way you can get all of the items.

But v3 or v4 lists? says "You can import "unlimited" items in a single request".
How can we achieve this when there is a page parameter that defaults to 1 in list details API?

I don't know which List Request you made.
Usually the response informs the number of items and pages.

 "runtime": 68495,
  "sort_by": "original_order.asc",
  "total_pages": 31,
  "total_results": 618

And there are usually 20 items per page.
So just re-submit the following pages.
For example:

https://api.themoviedb.org/4/list/9792?language=en-US&page=1
https://api.themoviedb.org/4/list/9792?language=en-US&page=2
https://api.themoviedb.org/4/list/9792?language=en-US&page=3
...
https://api.themoviedb.org/4/list/9792?language=en-US&page=29

@ticao2 said:

@shahood said:

@travisbell said:

Yes, the best way to accomplish this will be to page through the results on a v4 list. This way you can get all of the items.

But v3 or v4 lists? says "You can import "unlimited" items in a single request".
How can we achieve this when there is a page parameter that defaults to 1 in list details API?

I don't know which List Request you made.
Usually the response informs the number of items and pages.

 "runtime": 68495,
  "sort_by": "original_order.asc",
  "total_pages": 31,
  "total_results": 618

And there are usually 20 items per page.
So just re-submit the following pages.
For example:

https://api.themoviedb.org/4/list/9792?language=en-US&page=1
https://api.themoviedb.org/4/list/9792?language=en-US&page=2
https://api.themoviedb.org/4/list/9792?language=en-US&page=3
...
https://api.themoviedb.org/4/list/9792?language=en-US&page=29

Thanks for taking time to reply.

I know how the pagination works in all TMDB requests.

All I'm asking is that since V4 lists are advertised as having the ability to fetch "unlimited items in a single request", how can we achieve this with a single request?

@shahood said:
Thanks for taking time to reply.
I know how the pagination works in all TMDB requests.
All I'm asking is that since V4 lists are advertised as having the ability to fetch "unlimited items in a single request",
how can we achieve this with a single request?

Using v3 we have a limitation on IMPORTING data.
Using v4 there is no IMPORTING limitation.
As for EXPORTING data, via API, the rule remains the same.
20 items per page.

@ticao2 said:

Using v3 we have a limitation on IMPORTING data.
Using v4 there is no IMPORTING limitation.
As for EXPORTING data, via API, the rule remains the same.
20 items per page.

Can u please explain what importing and exporting means here?

@shahood said:
Can u please explain what importing and exporting means here?

I've never done this using API.
The point of view is from the Database.
If you have a list of movies that originate from your media center, your KODi, your IMDB account, you can IMPORT that data to the TMDb Database.
And you can EXPORT that data from a list of yours that is already in the TMDb Database.
Using API the limit is the same as always.