Spreadsheet Automation 101 Lesson 4: JSON (beautifier) and OmdbAPI parameters

<div>0:00 All right, welcome back. We are gonna talk about J S O N, not JSON and the Argonauts, but J S O N.<br>0:06 This is the type of, of very common type of data that comes to us in APIs. It comes to us on the web and it looks like this.<br>0:15 It has some curly brackets, it has quotes of sort of the names of things and then the value of those things, the key of it or the value.<br>0:23 But what I wanna show you is we're just going to get outta Google sheets for a hot moment. And here's sort of a respon, a typical response of json.<br>0:31 I'm gonna copy that. How do we look at this?

How do we get the information out of this? Well, one thing is we can beautify it.<br>0:39 So I literally just searched for Google for JSON Beautif Fire. Here's the top one. I just used that one. And we paste the information on the left.<br>0:48 And over here on the right is the data , but it's beautified. It shows us the title Titanic year 1997. It shows us all the options writer.<br>0:57 We can get the actors. We can't even get the plot of the movie.

What I wanna really get, and we will get by the end of this, is we're gonna get poster here.<br>1:07 So we're gonna be able to bring in some cool images into Google Sheets. But this json whenever you trying to access a API in specifically a restful API or arrest api, make sure you're getting the right data .<br>1:24 I say this because in our app script , we use this dot get content text. This could be a very easily skippable step.<br>1:33 What we're end gonna end up doing is we will end up needing, what is it? Let me double check.

We need variable js o n actually values , let's say equals mm at j o n dot parse.<br>1:52 And we'll put all of this response dot get content text inside here, okay? Now what this allows us to do, this JS O again, is built-in functions that allows us to look into this data .<br>2:04 And we'll, what we wanna do is we wanna return just say poster and we'll return values and we'll use bracket notation and we'll do poster.<br>2:16 Let's see what happens. If we get poster, we got equal, we'll get poster a one.

We are getting literally only one item out of all of that json We're getting the poster.<br>2:31 We can wrap this with a normal Google sheet formula here, image that takes a u URL of an image and creates the image in here.<br>2:42 So that's pretty cool that we can actually bring an image inside two Google sheets from an api, right? So we got that because we got to beautify this J s o.<br>2:52 We got to see the actual structure of it. We got to look at what this poster is, what this plot is.<br>2:58 And if We, we go back to our information, our, our script.

This is normal bracket notation , right? We've learned about what bracket notation is when it looks at arrays of information, like the first array, the first element, the second element, the third element.<br>3:13 We added brackets to it. But in this case, we're using the name of the key, which is poster or title or year or actors or director, right?<br>3:25 We can do that and we're gonna get an error here cuz it's not an image , actually no error . But this is pretty cool stuff.<br>3:34 We have been able to now parse lots of information across json.

And in the next one, in next video, we're gonna create a new script that allows us to seek out which parameter we want.<br>3:47 We don't want to have to hard code this.</div>