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

The Movie Database -tuki

Tuki → API-tuki

Kirjoittanut vishwa2
STAFFMOD
pvä 1 syyskuu 2019 klo 12:14AM

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 vastausta (sivulla 1, sivuja yhteensä 1)

• Jump to last post

Vastaus käyttäjältä Travis Bell

STAFFMOD

3 syyskuu 2019 klo 10:09AM

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

Vastaus käyttäjältä vishwa2

STAFFMOD

5 syyskuu 2019 klo 10:15AM

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"

Vastaus käyttäjältä Travis Bell

STAFFMOD

5 syyskuu 2019 klo 10:37AM

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

Vastaus käyttäjältä vishwa2

STAFFMOD

5 syyskuu 2019 klo 11:31AM

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

Käyttäjät tässä keskustelussa

Kategoriat

The Movie Database -tuki