Youtube API and excel - retrieve username from cell (video URL)

Question

This is Excel macro homework. The task is to display a YouTube video channel name, based on URL. Let's say we have column A (each cell is separate video URL) and column B in which I want to display names.

I know that by using this code:

https://www.googleapis.com/youtube/v3/videos?id=<video_id>&key=<YOUR_API_KEY>&part=snippet

I can display basic data which includes "channelTitle" variable. But how do I display only channel title?

Show us what "bunch of data" beholds – online Thomas Jan 27 '16 at 11:22 — online Thomas, Jan 27 '16 at 11:22
http://pastebin.com/LBVfM6wd example in provided URL – Paweł Skaba Jan 27 '16 at 11:23 — Paweł Skaba, Jan 27 '16 at 11:23

score 1 · Accepted Answer · edited May 23 '17 at 10:28

1

https://developers.google.com/youtube/v3/getting-started#part

I'd say fields = channelTitle. Play around with it little or parse the json in VBA macro: Parsing JSON in Excel VBA

edited May 23 '17 at 10:28

Community

1
1

answered Jan 27 '16 at 11:34

online Thomas

8,864
6
44
85

Youtube API and excel - retrieve username from cell (video URL)

1 Answers1