The Movie Database Support

Hi...

I'm trying to build a discover request to show me what movies are releasing in the next week in the UK.

Here's the request URL:

https://api.themoviedb.org/3/discover/movie?include_adult=false&include_video=false&language=en&region=gb&sort_by=primary_release_date.asc&with_release_type=2|3&release_date.gte=2023-10-20&release_date.lte=2023-10-27

This is giving unexpected results that are not (seemingly) in order. The first 3 movies are from 1960 - 1993.

This can also be observed on the website: https://www.themoviedb.org/movie/upcoming

Set the filters to:

  • Sort: Release Date Ascending
  • Country: United Kingdom
  • Theatrical checked
  • From: 20/10/23
  • To: 27/10/23

You will see that the results are not in order, and include releases from 1960.

I may just be misinterpreting the results, but any help would be greatly appreciated!

3 replies (on page 1 of 1)

Jump to last post

Hi @mdavis1982, when you use "release_date" for the date range, you get -all- release dates that fit the date range and the other qualifiers. For the first movie returned, "Peeping Tom (1960)", see the releases here, there is a UK theatrical release for 10/27/2023 (4k Re-release) that is matching your search. I'm sure the others that don't make sense have a similar situation.

You might want to try changing the "release_date" range to a "primary_release_date" range, this will only match the primary release dates so you won't get these type of matches.

Hi @robbie3999

Thanks for the info. Switching to sorting by "primary_release_date" has helped a little, but I'm still getting the data in a confusing order.

For example, in the results, I get:

  • Beyond Utopia - 27 Oct 2023
  • The Metamorphosis - 24th October 2023
  • Pure Clean Water - 25th October 2023
  • The Killer - 27th October 2023
  • More results...
  • The Holdovers - 19th January 2024 (This one is strange as the "primary_release_date.lte" is set to 30th October)
  • Only Love Matters - 27th October 2023

This ordering doesn't seem to make sense to me, but that's the order that they're coming back with from the API.

Any more help would be greatly appreciated!

Well, changing release_date to primary_release_date is kind of a bandaid. What you are getting now is a mix of release date and primary release date information.

This is what a primary release date is. Note that this can be any country, it's just the first one that matches the criteria.

So your search is finding a primary release date in the date range, but the filters "region" and "with_release_type" apply to release date only, not primary release date. So when these match you are getting that also. What gets returned in the results is the release date match first, and then the primary release date match. But you are sorting by primary release date. So thats why the dates don't sort, because they are release dates.

Take Beyond Utopia, the primary release date is US 10/23/2023. But the UK release date match is 10/27/2023 (because you specified region=gb and with_release_type=2|3).

Take The Holdovers, the primary release date is US 10/27/2023. But the UK release date match is 01/19/2024.

I think all this is correct, but perhaps someone else may come along with more information. So you can play around with different ways to do what you are trying to do. But I'm not sure anything is going to be perfect.

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