When I run this:
https://api.themoviedb.org/3/discover/movie?api_key=###&sort_by=release_date.asc&release_date.gte=2017
I wasn't expecting returned with a release date less than 2017, but the first result I get back is a film with a release date in 1895. In fact, that query just seems to return all films!
{
"popularity": 4.706,
"id": 82120,
"video": false,
"vote_count": 100,
"vote_average": 7,
"title": "Tables Turned on the Gardener",
"release_date": "1895-12-27",
"original_language": "fr",
"original_title": "Arroseur et arrosé",
"genre_ids": [
35
],
"backdrop_path": "/A0hONP6cxTthAsw6IvPMX4Aowkr.jpg",
"adult": false,
"overview": "A gardener is watering his flowers, when a mischievous boy sneaks up behind his back, and puts a foot on the water hose. The gardener is surprised and looks into the nozzle to find out why the water has stopped coming. The boy then lifts his foot from the hose, whereby the water squirts up in the gardener's face. The gardener chases the boy, grips his ear and slaps him in his buttocks. The boy then runs away and the gardener continues his watering. Three separate versions of this film exist, this is the original, filmed by Louis Lumière.",
"poster_path": "/5UsXVtEbaL88lxLy9AbfvLlki9T.jpg"
}
I'm sure I'm doing something wrong, but it's not obvious what.
Additionally, what should be the format of that release date? "2017-01-31"? Or "2017-31-01"? Or "2017/01/31" Or "2017/31/01" Or "31/01/2017" etc...
Any help, greatly appreciated. Thanks!
Can't find a movie or TV show? Login to create it.
Want to rate or add this item to a list?
Not a member?
Reply by steve.huckle@gmail.com
on November 7, 2019 at 7:14 AM
Aha- this appears to need a range. Plus, I think the date format is YYYY-MM-DD (or YYYY-DD-MM). Hence, this works:
:)
Reply by steve.huckle@gmail.com
on November 7, 2019 at 7:31 AM
Arghhhh! That range doesn't work after all! Because this (sort ascending) returns films from the 1900's!:
Help!
Reply by steve.huckle@gmail.com
on November 7, 2019 at 7:51 AM
Er, primary_release_date seems to work better. So I guess I'm misunderstanding something about release dates...
Reply by talestalker
on November 7, 2019 at 8:02 AM
I made this thread private, so only mods can see it. Next time please remove your API key from your example urls.
As for your question - the movie Le Voyage dans la Lune has one of its release dates set to 2017-02-04 (Japan, Nasu Onsen Film Festival) and this is why it is returned by your query. You should use "&primary_release_date.lte=" and "&primary_release_date.gte=" if you are trying to limit your query based on original release dates. Or, if you need to look at all existing release dates, you can limit your discover query with "&release_date.lte=" and "&release_date.gte=" to some specific country by using "®ion=".
Reply by steve.huckle@gmail.com
on November 7, 2019 at 10:08 AM
Sorry!