Skip to content

Instantly share code, notes, and snippets.

View davebremer's full-sized avatar
💭
Working on SQLite-tools - converting excel

Dave Bremer davebremer

💭
Working on SQLite-tools - converting excel
View GitHub Profile
@dharmatech
dharmatech / YouTube-JRE-to-CSV.ps1
Last active April 9, 2020 06:19
PowerShell script that downloads information from all JRE episodes on YouTube. Store in a CSV file. Example of data imported into coda.io: https://coda.io/@eduardo-cavazos/jre-video-list
$api_key = (Get-Content C:\Users\dharm\Dropbox\Documents\youtube-api-key)
function get-channel-uploads ($channel_id)
{
$result = Invoke-RestMethod `
"https://www.googleapis.com/youtube/v3/channels?id=$channel_id&key=$api_key&part=contentDetails"
$result.items[0].contentDetails.relatedPlaylists.uploads
}