Source: Omdbapi.com


Name Description Inputs
(ordered)
Output
(only one)

This function returns the movie details for a given title.

Example:
=Ignite("omdbapi.com","lookup","Actors","The Wolf of Wall Street")

t

Title Year Rated Released Runtime Genre Director Writer Actors Plot Language Country Awards Poster Metascore imdbRating imdbVotes imdbID

This function returns the movie details for a given IMDB ID.

Example:
=Ignite("omdbapi.com","lookup_imdb","Actors","tt1285016")

i

Title Year Rated Released Runtime Genre Director Writer Actors Plot Language Country Awards Poster Metascore imdbRating imdbVotes imdbID
Required Optional Output

Examples:

 AB (Forumla)C (Output)
1 The Wolf of Wall Street =Ignite("omdbapi.com","lookup","Title",A1) The Wolf of Wall Street
2 The Wolf of Wall Street =Ignite("omdbapi.com","lookup","Year",A2) 2013
3 The Wolf of Wall Street =Ignite("omdbapi.com","lookup","Rated",A3) R
4 The Wolf of Wall Street =Ignite("omdbapi.com","lookup","Released",A4) 2013-12-25
5 The Wolf of Wall Street =Ignite("omdbapi.com","lookup","Runtime",A5) 180 min
6 The Wolf of Wall Street =Ignite("omdbapi.com","lookup","Genre",A6) Biography, Comedy, Crime
7 The Wolf of Wall Street =Ignite("omdbapi.com","lookup","Director",A7) Martin Scorsese
8 The Wolf of Wall Street =Ignite("omdbapi.com","lookup","Writer",A8) Terence Winter (screenplay), Jordan Belfort (book)
9 The Wolf of Wall Street =Ignite("omdbapi.com","lookup","Actors",A9) Leonardo DiCaprio, Jonah Hill, Margot Robbie, Matthew McConaughey
10 The Wolf of Wall Street =Ignite("omdbapi.com","lookup","Plot",A10) Based on the true story of Jordan Belfort, from his rise to a wealthy stock-broker living the high life to his fall involving crime, corruption and the federal government.
11 The Wolf of Wall Street =Ignite("omdbapi.com","lookup","Language",A11) English, French
12 The Wolf of Wall Street =Ignite("omdbapi.com","lookup","Country",A12) USA
13 The Wolf of Wall Street =Ignite("omdbapi.com","lookup","Awards",A13) Nominated for 5 Oscars. Another 33 wins & 97 nominations.
14 The Wolf of Wall Street =Ignite("omdbapi.com","lookup","Poster",A14) http://ia.media-imdb.com/images/M/MV5BMjIxMjgxNTk0MF5BMl5BanBnXkFtZTgwNjIyOTg2MDE@._V1_SX300.jpg
15 The Wolf of Wall Street =Ignite("omdbapi.com","lookup","Metascore",A15) 75
16 The Wolf of Wall Street =Ignite("omdbapi.com","lookup","imdbRating",A16) 8.3
17 The Wolf of Wall Street =Ignite("omdbapi.com","lookup","imdbVotes",A17) 532,255
18 The Wolf of Wall Street =Ignite("omdbapi.com","lookup","imdbID",A18) tt0993846
19 tt0387564 =Ignite("omdbapi.com","lookup_imdb","Title",A19) Saw
20 tt0387564 =Ignite("omdbapi.com","lookup_imdb","Year",A20) 2004
21 tt0387564 =Ignite("omdbapi.com","lookup_imdb","Rated",A21) R
22 tt0387564 =Ignite("omdbapi.com","lookup_imdb","Released",A22) 29 Oct 2004
23 tt0387564 =Ignite("omdbapi.com","lookup_imdb","Runtime",A23) 103 min
24 tt0387564 =Ignite("omdbapi.com","lookup_imdb","Genre",A24) Horror, Mystery
25 tt0387564 =Ignite("omdbapi.com","lookup_imdb","Director",A25) James Wan
26 tt0387564 =Ignite("omdbapi.com","lookup_imdb","Writer",A26) Leigh Whannell, James Wan (story), Leigh Whannell (story)
27 tt0387564 =Ignite("omdbapi.com","lookup_imdb","Actors",A27) Leigh Whannell, Cary Elwes, Danny Glover, Ken Leung
28 tt0387564 =Ignite("omdbapi.com","lookup_imdb","Plot",A28) Two men awaken in the secure lair of a killer who forces them to play a deadly game that will determine life or death.
29 tt0387564 =Ignite("omdbapi.com","lookup_imdb","Language",A29) English
30 tt0387564 =Ignite("omdbapi.com","lookup_imdb","Country",A30) USA, Australia
31 tt0387564 =Ignite("omdbapi.com","lookup_imdb","Awards",A31) 6 wins & 8 nominations.
32 tt0387564 =Ignite("omdbapi.com","lookup_imdb","Poster",A32) http://ia.media-imdb.com/images/M/MV5BMjAyNTcxNzYwMV5BMl5BanBnXkFtZTgwMzQzNzM5MjE@._V1_SX300.jpg
33 tt0387564 =Ignite("omdbapi.com","lookup_imdb","Metascore",A33) 46
34 tt0387564 =Ignite("omdbapi.com","lookup_imdb","imdbRating",A34) 7.7
35 tt0387564 =Ignite("omdbapi.com","lookup_imdb","imdbVotes",A35) 265333
36 tt0387564 =Ignite("omdbapi.com","lookup_imdb","imdbID",A36) tt0993846