The Movie Database Support

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!

5 replies (on page 1 of 1)

Jump to last post

Aha- this appears to need a range. Plus, I think the date format is YYYY-MM-DD (or YYYY-DD-MM). Hence, this works:

https://api.themoviedb.org/3/discover/movie?api_key=###&language=en-US&sort_by=release_date.desc&include_adult=false&include_video=false&release_date.gte=2017-01-01&release_date.lte=2018-01-01

:)

Arghhhh! That range doesn't work after all! Because this (sort ascending) returns films from the 1900's!:

https://api.themoviedb.org/3/discover/movie?api_key=###&language=en-US&sort_by=release_date.asc&include_adult=false&include_video=false&release_date.gte=2017-01-01&release_date.lte=2018-01-01

Help!

Er, primary_release_date seems to work better. So I guess I'm misunderstanding something about release dates...

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 "&region=".

I made this thread private, so only mods can see it. Next time please remove your API key from your example urls.

Sorry!

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

Settings

Want to rate or add this item to a list?

Login