Hey all. I’ve got an Automation script seemingly close to get the Youtube Video ID from a full URL which I found here.
Script from link above
<script type="text/javascript">
function youtube_parser(url){
var regExp = /^.*((youtu.be\/)|(v\/)|(\/u\/\w\/)|(embed\/)|(watch\?))\??v?=?([^#&?]*).*/;
var match = url.match(regExp);
return (match&&match[7].length==11)? match[7] : false;
}
</script>
Goal:
I’m trying to take a Youtube URL in an existing field: myInput
or https://www.youtube.com/watch?v=YAIlMUX9VLg
and strip out only YAIlMUX9VLg to pass onto the next step (or output to the field Video ID, doesn’t matter).
I’m feel like I’m so close but at the end of my copy/paste/adapt coding skills. Here’s my code:
let myTable = base.getTable("Video Tracker");
let query = await myTable.selectRecordsAsync();
let myUpdateField = myTable.getField('Video ID');
console.log(query.records);
function youtube_parser(myInput){
var regExp = /^.*(youtu\.be\/|v\/|u\/\w\/|embed\/|watch\?v=|\&v=)([^#\&\?]*).*/;
var match = myInput.match(regExp);
if (match && match[2].length == 11) {
return match[2];
} else {
//error
}
}
var ytOUT = youtube_parser;
output.set('myOutput', ytOUT);
And the error I get that I cannot make heads or tails of:
ERROR
TypeError: Invalid arguments passed to output.set(key, value): • value should be a JSON-serializable type, not a function (undefined)
at main on line 16
Here’s my Edit Script screen overall
and the Automation overall if it helps:
Thanks for any help.
Thanks, Bill. My intent of using the youtube_parser script was because it could handle so many variations of the initial URL. Just trying to prevent future human error. I’m wanting the Automation to just always be looking for that Live URL to land to be able to strip the video ID out into the field for that string. I can use this for a bunch of other stuff (Zapier, buttons, edit links). That’s not necessary, obviously.
Types of URLS
These are the types of URLs supported
http://www.youtube.com/watch?v=0zM3nApSvMg&feature=feedrec_grec_index
http://www.youtube.com/user/IngridMichaelsonVEVO#p/a/u/1/QdK8U-VIH_o
http://www.youtube.com/v/0zM3nApSvMg?fs=1&hl=en_US&rel=0
http://www.youtube.com/watch?v=0zM3nApSvMg#t=0m10s
http://www.youtube.com/embed/0zM3nApSvMg?rel=0
http://www.youtube.com/watch?v=0zM3nApSvMg
http://youtu.be/0zM3nApSvMg
I wondered if I hadn’t selected the right record, thanks. Also, I was missing that youtube_parser(liveURL) bit.
After a bit more guessing and testing, I found this article that helped me revise the input variables I had entered on the left (wasn’t calling those and didn’t know how till I saw the example).
Thanks for pointing me in the right direction. After turning this automation on I’ve realized that it’s not going to process all my existing entries but only new ones :thinking: . Not the end of the world I suppose.
Here’s my working script (for new entries)
let inputConfig = input.config();
var liveURL = inputConfig.myInput;
function youtube_parser(liveURL){
var regExp = /^.*(youtu\.be\/|v\/|u\/\w\/|embed\/|watch\?v=|\&v=)([^#\&\?]*).*/;
var match = liveURL.match(regExp);
if (match && match[2].length == 11) {
return match[2];
} else {
//error
}
}
var ytOUT = youtube_parser(liveURL);
output.set('myOutput', ytOUT);
