I am using the correct API key. And when I use that api key with a sample code in web browser, it fetches the correct result but with the code (below) and my query, it does not
Here is the code :
import pandas as pd
import requests
pd.options.display.max_columns = 30
discover_api = "https://api.themoviedb.org/3/discover/movie?"
api_key="????"
query1 = "&primary_release_date.gte=2020-01-01&primary_release_date.lte=2020-02-27"
url = discover_api+api_key+query1
data = requests.get(url).json()
data
Output :
{'status_code': 7,
'status_message': 'Invalid API key: You must be granted a valid key.',
'success': False}
Can somebody help me, to understand, what is wrong with the code, as its not fetching any data
Thanks for your help in advance
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 robbie3999
on October 26, 2023 at 12:54 PM
Hi @aniketism_tmdb, your missing the string "api_key=" in the url. The url is
You need to set the string api_key to "api_key=????". Or add "api_key=" to the end of "discover_api".
Reply by aniketism_tmdb
on October 26, 2023 at 2:56 PM
Hi Robbie,
Thanks for responding. Yes I did set the variable api_Key to the real api key, instead of ????
Also, instead I did try to add it to the end of discover_api as discover_api = "https://api.themoviedb.org/3/discover/movie?" But still getting the same message as 'Invalid API key: You must be granted a valid key.
Any other information will help
Thanks
Reply by superboy97
on October 26, 2023 at 4:22 PM
Is the content of your api_key variable in the form "api_key=YOUR_KEY" ? If the variable just contain the key, this will not worl.
Reply by aniketism_tmdb
on October 26, 2023 at 4:44 PM
Thanks superboy97,
Yes, I couldn't understand that earlier and after the message from robbie and you, I realized that I was missing the "api_key=" string in the variable. Its working now....
Thanks very much... Appreciate everyone,s help
Happy Learning......
Reply by ticao2 š§š· pt-BR
on October 26, 2023 at 4:45 PM
A suggestion to try to resolve it.
Try changing your line below
to this line below
Reply by robbie3999
on October 26, 2023 at 4:46 PM
Yes, you are missing the point, your code produces this url:
You need it to produce this url:
You need to add the string "api_key=" to one of the variables or the statement that creates the url.
Reply by aniketism_tmdb
on October 26, 2023 at 4:50 PM
Thanks robbie
Reply by aniketism_tmdb
on October 26, 2023 at 4:50 PM
Thanks ticao2