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!
.לא מצאת סרט או סדרה? היכנס כדי ליצור אותם
?רוצה לדרג או להוסיף פריט אל רשימה
?לא חבר אתר
תגובה מאת steve.huckle@gmail.com
ב-נובמבר 7, 2019 ב-7:14לפני חצות יום
Aha- this appears to need a range. Plus, I think the date format is YYYY-MM-DD (or YYYY-DD-MM). Hence, this works:
:)
תגובה מאת steve.huckle@gmail.com
ב-נובמבר 7, 2019 ב-7:31לפני חצות יום
Arghhhh! That range doesn't work after all! Because this (sort ascending) returns films from the 1900's!:
Help!
תגובה מאת steve.huckle@gmail.com
ב-נובמבר 7, 2019 ב-7:51לפני חצות יום
Er, primary_release_date seems to work better. So I guess I'm misunderstanding something about release dates...
תגובה מאת talestalker
ב-נובמבר 7, 2019 ב-8:02לפני חצות יום
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=".
תגובה מאת steve.huckle@gmail.com
ב-נובמבר 7, 2019 ב-10:08לפני חצות יום
Sorry!