sort_by query parameter not working as expected when a given combination of query parameters are passed

The Movie Database Support

Support → API Support

posted by vishwa2
STAFFMOD
on September 1, 2019 at 12:14 AM

Hi ,

I was just testing a small get api with a combination of query parameters as shown below . I do see that for the resultant api response for the given combination of query parameters is not working as expected.

eg: the below api request is trying to fetch the details based on vote_count.gte>5 and other parameters with a sort_by=vote_average.desc, however the api response is showing the details of vote_count from 3 onwards.

This issue is majorly coming whenever a sort_by query parameters is used, else the api retrieves the rite set of data. This is a small issue , might not be of much relevance , but i thought of letting the api community know about it.

Note: Enter a valid api key in the below request.

Api Request : https://api.themoviedb.org/3/discover/movie?api_key=123&vote_average.gte>7&page=3&vote_count.gte>5&sort_by=vote_average.desc

Part of the api response is:

{
    "page": 3,
    "total_results": 10000,
    "total_pages": 500,
    "results": [
        {
            "popularity": 1.3,
            "id": 500424,
            "video": false,
            "vote_count": 3,
            "vote_average": 10,
    ...
}

4 replies (on page 1 of 1)

• Jump to last post

Reply by Travis Bell

STAFFMOD

on September 3, 2019 at 10:09 AM

It doesn't look like that's a valid discover request. What are the results of this? Still seeing the vote_count.gte / vote_average.gte filters not working?

https://api.themoviedb.org/3/discover/movie?api_key=123&vote_average.gte=7&page=3&vote_count.gte=5&sort_by=vote_average.desc

Reply by vishwa2

STAFFMOD

on September 5, 2019 at 10:15 AM

Hi Travis ,

Thank you for the response. I have seen that vote_count.gte&vote_average.gte filters are not giving the right result set . Could you verify once .., pls find my api details:

https://api.themoviedb.org/3/discover/movie?api_key=test123&vote_average.gte>7&page=3&vote_count.gte>5

As per my understanding , Below result shows a vote_count:3 , this record shouldnt have come in the response when we use an "AND" combination in the query parameters [ote_average.gte>7&page=3&vote_count.gte>5] . The below result is expected when we do an OR combination on the query parameters . Please let me know if i am missing anything or if my understading is not rite.

Results: ( part of api response )

   {
            "popularity": 46.85,
            "vote_count": 3,
            "video": false,
            "poster_path": "/eU0orGizEpOli4wtN8HtfOOJDlA.jpg",
            "id": 516700,
            "adult": false,
            "backdrop_path": "/nmHCKQ1GtlPLZVAtBfsYDqVPhPW.jpg",
            "original_language": "id",
            "original_title": "Gundala",
            "genre_ids": [
                28,
                80,
                18
            ],
            "title": "Gundala",
            "vote_average": 8.2,
            "overview": "Sancaka has lived on the streets since his parents left him. Living a hard life, Sancaka survives by thinking about his own safety. When the condition of the city gets worse and injustice rages throughout the country, Sancaka must decide whether he continues to live to look after himself or rise to become their oppressed hero.",
            "release_date": "2019-08-29"

Reply by Travis Bell

STAFFMOD

on September 5, 2019 at 10:37 AM

Hi @vishwa2,

You're not using the right syntax for the query parameters. HTTP doesn't understand < or >. Instead of using >, you need to use =.

https://api.themoviedb.org/3/discover/movie?api_key=###&vote_average.gte=7&page=3&vote_count.gte=5

Reply by vishwa2

STAFFMOD

on September 5, 2019 at 11:31 AM

ahh , got you.. thanks for the clarification and quick response.

Users In This Discussion

Categories

The Movie Database Support