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

The Movie Database 支持

支持 → API 支持

vishwa2
STAFFMOD
发布于 2019 年 09 月 01 日 12:14上午

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 回复（第 1 页，共 1 页）

• Jump to last post

Travis Bell 的回复

STAFFMOD

于 2019 年 09 月 03 日 10:09上午

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

vishwa2 的回复

STAFFMOD

于 2019 年 09 月 05 日 10:15上午

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"

Travis Bell 的回复

STAFFMOD

于 2019 年 09 月 05 日 10:37上午

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

vishwa2 的回复

STAFFMOD

于 2019 年 09 月 05 日 11:31上午

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

关注此讨论的用户

分类

The Movie Database 支持