@TSAJAN213 said:
API data fenching.
I was trying create a dataset using this api but it also throws the connectivity error issue and max retires ,
what is the requests limit and what the number of pages can i request at ones.

Maybe this will help you.

API Request Limit
The limit should probably be a maximum of 40 per second.
Here's what Travis Bell, the Administrator, said.
https://www.themoviedb.org/talk/66997ca6d3a5dbcf7c3a7994?page=1#669a84b510ab9ed1d367341a

The easiest way to help with your issue is it to introduce a small delay in between every requests so that you are issuing more than ~40 per second.
There are fancier designs where you can keep track of the number of requests in a second,
and then limit the number you execute within a threshold of sorts.
It's really up to you how you want to implement this.