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

Suport de The Movie Database

Suport → Suport de l'API

publicat per vishwa2
STAFFMOD
el dia 1 n de 2019 a les 12:14 A.M.

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 resposta (a les pàgines 1 de 1)

• Jump to last post

Resposta per Travis Bell

STAFFMOD

el 3 n de 2019 a les 10:09 A.M.

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

Resposta per vishwa2

STAFFMOD

el 5 n de 2019 a les 10:15 A.M.

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"

Resposta per Travis Bell

STAFFMOD

el 5 n de 2019 a les 10:37 A.M.

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

Resposta per vishwa2

STAFFMOD

el 5 n de 2019 a les 11:31 A.M.

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

Usuaris en aquest debat

Categories

Suport de The Movie Database