The Movie Database Support

 Ongoing Maintenance

Dear TMDb Community,

In the next few months, you might notice some changes on our site. My primary goal is, and always has been, to build the best media database on the internet and in order for me to stay true to that goal, we will be making these changes to enable TMDb to be more robust and reliable than before.

As you might recall from my 2019 recap, I have some pretty amazing plans for 2020 so stay tuned for some really fantastic launches this year!

If you have any questions please contact us at support@themoviedb.org.

Sincerely,

Travis

Is there a way—without needing to make millions(!) of queries—to get a list of the ids of all actors/actresses whose names contain each of A, E, I, O, and U exactly once (in any order)—e.g., 1204 (the id for Julia Roberts)?

Technically one could call

https://api.themoviedb.org/3/person/latest?api_key=5555555&language=en-US

and extract the value from the response's "id" field—call this value latest—and then iterate a value i from 1 to latest and for each call

https://api.themoviedb.org/3/person/i?api_key=5555555&language=en-US

checking the "name" value (and "also_known_as" values) on the client side to see if each of A, E, I, O, and U occur exactly once (in any one of those values)... but that looks like it'd take over 2 million HTTP calls, which is... intractable.

I'd certainly appreciate any suggestions for solutions that are actually feasible—thanks!

2 replies (on page 1 of 1)

Jump to last post

Hi @horwitz,

Unfortunately, there is no API implementation to suit your needs. You would have to bring the data down locally and do this on your end.

If you are only interested in names, you could use the daily ID export. It contains a list of all of the people in TMDb.

The exports look to be very helpful—thanks! (And thanks for the quick response!)

Can't find a movie or TV show? Login to create it.

Global

s focus the search bar
p open profile menu
esc close an open window
? open keyboard shortcut window

On media pages

b go back (or to parent when applicable)
e go to edit page

On TV season pages

(right arrow) go to next season
(left arrow) go to previous season

On TV episode pages

(right arrow) go to next episode
(left arrow) go to previous episode

On all image pages

a open add image window

On all edit pages

t open translation selector
ctrl+ s submit form

On discussion pages

n create new discussion
w toggle watching status
p toggle public/private
c toggle close/open
a open activity
r reply to discussion
l go to last reply
ctrl+ enter submit your message
(right arrow) next page
(left arrow) previous page

Want to rate or add this item to a list?

Login