Hi guys,

I'm trying to get specific CSV file(s) from Discover API Request for my personal movie diary db; I connected it to Google sheets via API connector

• I do example query - english speaking movies from 2020-2024 & min. 500 votes;
  
• In results, I get those specified movies only with these columns:

backdrop_path - genre_ids. - id - language - title - overview - popularity - poster_path - release_date - vote_average - vote_count

• and also, in "genre" fields I get only genre numeric IDs, not the actual text strings

Q1.) How can I get these additional needed info columns? - director - cast (only up to 3 or 4 main actors) - runtime - imdb id - imdb rating - tagline

Modify query URL somehow? (see at the bottom)

Q2.) How can I get in sheet fields (google sheet csv) actual genre names (action, thriller ...) instead of genre IDs (16, 18, 878)?

Any help highly appreciated. Have a good day!

My query:

URL: https://api.themoviedb.org/3/discover/movie?language=en-US%7Cen-UK&page=1&sort_by=popularity.desc&page=1&primary_release_year.gte=2020&primary_release_year.lte=2024&vote_count.gte=500&with_original_language=en

Authorization: Bearer [API key] Content-Type: application/json