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

پشتیبانی پایگاه داده‌ فیلم

پشتیبانی → پشتیبانی API

ارسال شده توسط vishwa2
STAFFMOD
در تاریخ سپتامبر 1, 2019 ساعت 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

در تاریخ سپتامبر 3, 2019 ساعت 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

در تاریخ سپتامبر 5, 2019 ساعت 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

در تاریخ سپتامبر 5, 2019 ساعت 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

در تاریخ سپتامبر 5, 2019 ساعت 11:31 ق.ض

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

کاربران در این بحث

دسته بندی ها

پشتیبانی پایگاه داده‌ فیلم