Hi,
Firstly, a big thank you for all your effort in building up the database and the API.
My query: I am trying to pull out/extract a list of all movies released in a specific year (2014) for a particular language (Hindi - )
I used the following query:
http://api.themoviedb.org/3/discover/movie?api_key=&primary_release_year=2014&language=hi
But unfortunately it seems to ignore the language parameter. What am I doing wrong?
Thanks in advance. :)
Cheers -j
Can't find a movie or TV show? Login to create it.
Want to rate or add this item to a list?
Not a member?
Reply by jimmykd
on July 12, 2014 at 2:08 AM
http://api.themoviedb.org/3/discover/movie?api_key=###&primary_release_year=2014
Reply by Travis Bell
on July 12, 2014 at 12:12 PM
It’s not ignoring the language param but rather it’s likely that not many movies have been translated to Hindi. Hindi has mediocre to low support in our db. I’ve noticed it’s been improving lately but the best you can do is browse the website and help out by adding missing translations.
Cheers.
Reply by jimmykd
on July 13, 2014 at 12:39 AM
Hi Travis,
Actually it is returning the wrong resultset but that could because I may be using the wrong parameter?
My query:
http://api.themoviedb.org/3/discover/movie?api_key=###&primary_release_year=2014&language=hi
Returns:
{"adult":false,"backdrop_path":null,"id":279185,"original_title":"Ai no Uzu","release_date":"2014-03-01","poster_path":"/gz5YI9KwNZdlYzFNeROVJCHMOgl.jpg","popularity":0.3458315339069,"title":"Ai no Uzu","vote_average":10.0,"vote_count":1} ... ... ...
But none of the results are for Hindi (hi) at least for the first page...
Your thoughts?
Thanks for all the help.
Cheers -j
Reply by Travis Bell
on July 13, 2014 at 2:10 PM
Looks like just not that much is translated into Hindi.
You can browse the website to see what has and hasn’t been and unfortunately, I’m just not seeing very much that has.
https://www.themoviedb.org/movie?language=hi
Cheers.
Reply by jimmykd
on July 14, 2014 at 3:09 AM
Hi Travis,
Firstly thanks for the help and the quick responses.
I had a look at your link which is:
https://www.themoviedb.org/movie?language=hi
And that link returns no results for Hindi inspite of themoviedb.org having quite a large collection. For example:
https://www.themoviedb.org/movie/44425-dabangg
Notice the language is also correctly setup as Language: hi under the Movie Facts section (left).
Is it a case of wrong internal column mapping for:
URL https://www.themoviedb.org/movie?language=hi and also in the API?
Thanks heaps for looking into this.
Cheers -j
Reply by Travis Bell
on July 14, 2014 at 9:58 AM
No, this is what I am saying. While there is probably some HI translations available, it doesn't seem to be that common.
44425 doesn't have a Hindi translation either from the looks of it. You can see in the drop down that it only has a translations created in English, French, Russian and Chinese.
What you're seeing here: http://note.io/1mBw0qB is an English (en) translation.
Reply by jimmykd
on July 14, 2014 at 2:38 PM
So then what is the "Language:hi" column under the [Movie Facts] section (Below Revenue:$0 and above Webpage:Link column) ???
Reply by Travis Bell
on July 15, 2014 at 9:56 AM
Ah, I see where this is confusing you.
You're looking at the spoken language field and that has nothing to do with translations. Translations are the listed in drop down on the left column of every movie page or underneath the title on edit pages.
If you head into your account and change your "Preferred Language" to Hindi and start browsing TMDb, you'll see that not very much has been translated.
Reply by jimmykd
on July 15, 2014 at 11:20 AM
Hey Travis,
Glad that we are on the same page now.
So now how do I filter out all the movies in 2014 with the spoken language as Hindi (hi) using the API?
http://api.themoviedb.org/3/discover/movie?api_key=###&primary_release_year=2014 (what more do I need to add here?)
Thanks heaps.
Reply by Travis Bell
on July 15, 2014 at 11:32 AM
Unfortunately, as it stands right now there is currently no way to search for or filter any of our queries based on spoken languages. I've created a ticket to look at this in the future here.
Reply by jimmykd
on July 15, 2014 at 12:38 PM
Oh! No worries. Let me know if I can be of help. Am good with SQL and PHP is not that bad either.
Reply by AnandShah5
on April 3, 2016 at 2:37 AM
Use this query - add year paramter. It works for me
Reply by ab.inpathtoadev@gmail.com
on December 12, 2021 at 12:26 AM
for someone who stumble upon this thread, required parameter is
with_original_language
eg:Reply by ticao2 🇧🇷 pt-BR
on December 13, 2021 at 6:17 AM
Filtering by the original language is possible. Use &with_original_language=
Example
But beware of duplicity:
A Language with Multiple Countries
A Country with Multiple Languages
Reply by Travis Bell
on December 14, 2021 at 11:23 AM
Using
with_origin_country
is another potentially useful filter. This was just added yesterday, and will be reflected in the docs shortly.