The Movie Database atbalsts

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!

Vai nevarat atrast filmu vai TV pārraidi? Piesakieties, lai to izveidotu.

Vispārējs

s fokusējiet meklēšanas joslu
p atveriet profila izvēlni
esc aizveriet atvērtu logu
? atveriet īsinājumtaustiņu logu

Mediju lapās

b atgriezties (vai pie vecākiem, ja nepieciešams)
e dodieties uz rediģēšanas lapu

TV sezonas lappusēs

(labā bultiņa) pāriet uz nākamo sezonu
(kreisā bultiņa) pāriet uz iepriekšējo sezonu

TV epizodes lappusēs

(labā bultiņa) pāriet uz nākamo sēriju
(kreisā bultiņa) pāriet uz iepriekšējo sēriju

Visās attēlu lapās

a atveriet attēla pievienošanas logu

Visās rediģēšanas lapās

t atvērt tulkošanas atlasītāju
ctrl+ s iesniegt formu

Diskusiju lapās

n radīt jaunu diskusiju
w pārslēgt skatīšanās statusu
p pārslēgt publisko/privāto
c pārslēgt aizvērt/atvērt
a atklāta darbība
r atbilde uz diskusiju
l dodieties uz pēdējo atbildi
ctrl+ enter iesniedziet savu ziņojumu
(labā bultiņa) nākamajā lapā
(kreisā bultiņa) iepriekšējā lapa

Iestatījumi

Vai vēlaties novērtēt vai uzskaitīt šo vienumu?

Pieslēgties