Python program to updated youtube videos based on SQL Server data

Job ID: 33276766

Budget: $30 – $250 USD

I need a python program to login to my youtube channel, scan through videos uploaded and then update the info for the videos that haven't been updated yet.

Youtube videos will be uploaded with the title "vidout " followed by the id of the video, e.g. "vidout 2". The db has the video id which is just the number, so in that last example, you'd get that video data by doing a select statement on the 'id' column where the id = 2.

The phrases within in the "{}" are column names.

Title:
{title} + " - " + {broadcaster_name} + " | " + {game} + " | " + {curator_name}
Only include curator_name if there is space in the title.

Description:
"Contact me here: <email>\n\nGame: {game}\nCurator: {curator_name}\nBroadcaster: {broadcaster_name}

(Freelancer doesn't allow me to put my email in there so I had to put "<email>")

Tags:
The tags need to be: {title}, {broadcaster_name}, {game}, {curator_name}

The configs for this program need to be in a file called data.json
Related categories: Python SQL Microsoft SQL Server