Getting RapidAPI to work with GoogleSheets to extract IMDB data

Question

Google Sheets with RapidAPI

First time trying to get APIs to work! I thought a simple project would be to get a Googlesheet to retrieve movie information based on the title.

Googling around I happened upon RapidAPI which has a Googlesheets add-on. Unfortunately I haven't found much useful documentation so have hit a dead end.

What I've learned so far

There only seems to be one example for how to implement it... by using the =GET() command like so (in this case for pulling finance info):

=GET(”https://investors-exchange-iex-trading.p.rapidapi.com/stock/{symbol}/book”,”quote.companyName”,”YOUR_API_KEY_HERE”,”symbol”,”AAPL”)

I couldn't get this example to work, and the IMDB Code Snippet seems a little different, so I'm not sure how that works at all. Not the curly bracers around {symbol}.

var axios = require("axios").default;

var options = {
  method: 'GET',
  url: 'https://imdb8.p.rapidapi.com/title/find',
  params: {q: 'Dredd'},
  headers: {
    'x-rapidapi-host': 'imdb8.p.rapidapi.com',
    'x-rapidapi-key': '5840855726msh193dee7e1600046p145eddjsnc66aff778896'
  }
};

axios.request(options).then(function (response) {
    console.log(response.data);
}).catch(function (error) {
    console.error(error);
});

When I run a typical search on IMDB, I get a URL that looks like this:

https://www.imdb.com/find?q=dredd&ref_=nv_sr_sm

I notice this q parameter there, which seems important...

• I'm not sure how I am meant to format this =GET() command for IMDB data. The example suggests one thing, but Googlesheets suggests another: "GET(url, selectPaths, rapidApiKey)"
• I'm not sure what the curly bracers are doing in the example URL.
• Whatever I try seems to give the same error message:

Error Request failed for https://imdb8.p.rapidapi.com returned code 400. Truncated server response: 400 - Bad Request (use muteHttpExceptions option to examine full response) (line 98).

Send Help

Does anyone have a better, working tutorial for using this setup? Or could you direct me to some useful reading material that a layperson could understand?