The Movie Database Support
Support → API Support
Why can this discover call actually display the correct release date sort order?
posted by brianminorSTAFFMOD on November 17, 2019 at 10:40 PM
https://api.themoviedb.org/3/discover/movie?api_key={API_KEY}&language=en-US®ion=US&sort_by=release_date.asc&include_adult=false&include_video=false&page=1&release_date.gte=2019-11-17&release_date.lte=2019-12-17&with_release_type=3
I really wish this would actually return the correct order of movies based on the release type. I understand movies have all different releases, but the fact that in this call I am specifying the release type and asking it to be sorted by release type and I get an order of movies all out of order because its looking at what I can only guess is another release type release date.
Only solutions I've came up with so far, for this issue is to to make smaller release window calls (so all movies fit on a single page), or to call all pages (one after another) then manually sort the data, but those additional calls don't always succeed.
Reply by ticao2 š§š· pt-BR
on November 18, 2019 at 2:53 PM
I didn't quite understand what the problem is.
I believe Google Translate didn't work correctly.
But...
Maybe if you use primary_release_date the result is what you want.
Reply by brianminor
on November 20, 2019 at 1:55 PM
no both result in the movies being in the wrong order.
if you try (with a valid api key):
https://api.themoviedb.org/3/discover/movie?api_key={API_KEY}&language=en-US-US®ion=US&sort_by=release_date.asc&include_adult=false&include_video=false&page=1&release_date.gte=2019-11-17&release_date.lte=2019-12-17&with_release_type=3
You can quickly see the order by release dates is not looking at the release_type to order the releases. It is going by the premiere date, which for some movies can be multiple weeks before they major public release.
Reply by Travis Bell
on November 20, 2019 at 2:54 PM
Hi @brianminor,
I think I know why this is happening. I don't have time to look into this right away but I've created a ticket for it here.
Reply by brianminor
on December 7, 2019 at 10:19 AM
Awesome thanks, this has definitely been the biggest hurdle Ive had with the API, right now I am just calling all the pages of movies for an entire year at a time and manually displaying the order. Biggest issue with that is so many unneeded calls for some users and sometimes calls fail and I have to setups check and do recalls.
Reply by Travis Bell
on April 3, 2020 at 1:50 PM
Hey Brian,
I think I just corrected this. How's it look for you?
Reply by brianminor
on May 21, 2020 at 9:55 AM
Travis,
Sorry for the delay and thanks so much this is working perfectly cant wait to get an update of my app out with it included.