I didn't check if IMPORTDATA is working, but your query should use "?" instead of "&".

Do you mean in A1 part where the previous cell is called, like this - "?A1?" instead of "&A1&" ?

=IMPORTDATA("https://api.themoviedb.org/3/movie/"?A1?"&apikey=MYAPYKEY")

Doesn't work either way (same if I change & to ? , before the apikey= part). I also tried with API KEY and with API Read Access Token, no success

It doesn't work even with static movie ID. like this (with or without my API key added):

=IMPORTDATA("https://api.themoviedb.org/3/movie/343611&apikey=MYAPIKEY")

Is there any other function that should be called instead to pull the data in the cell, - IMPORTXML, IMPORTHTML or what? or some parameters have to be added / changed in IMPORTDATA?

Any help highly appreciated.

No. I mean before the API key.

• "?" should be used before the parameters
• "&" should be used to separate the parameters.

In this case, there is only one parameter (the API key), so you should use "?" in front of it.

Also, the API key parameter is called "api_key", not "apikey".

Yes, that's it. I don't know how I missed it; should've drink the coffee first, wouldn't mess the syntax :)

It works now: =IMPORTDATA("https://api.themoviedb.org/3/movie/"&A2&"?api_key=MYAPIKEY")

Is there a way to add parameters to the function to return / call only these:

• videos.results.1.key
• backdrop_path
• tagline

@vedranst said:

Is there a way to add parameters to the function to return / call only these:

• videos.results.1.key
• backdrop_path
• tagline

No.