Skip to main content

Get Youtube V=ID Script

  • November 9, 2020
  • 5 replies
  • 48 views
W
  • wjb
  • Known Participant
  • 18 replies

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.

5 replies

B
Forum|alt.badge.img+19
  • Bill_French
  • Inspiring
  • 3263 replies
  • November 9, 2020

I think this is where the issue is - I think it needs to be:

var ytOUT = youtube_parser(myUpdateField);

B
Forum|alt.badge.img+19
  • Bill_French
  • Inspiring
  • 3263 replies
  • November 10, 2020

Maybe I’m missing something, but I get the sense that you’re missing something that definitively sets the value of the URL that needs to be parsed. I see you open the table and get the records, but where do you decide which record to use in the parse process? I assume you want to run this process for all records, perhaps?

Another thing - to get the value of the youtube ID from the URL, you don’t need the youtube_parser() function; rather, I think this is all you need given the URL is in a variable…

  let myInput = "https://www.youtube.com/watch?v=YAIlMUX9VLg";
  let ytOUT = myInput.split("?v=")[1];
  output.set('myOutput', ytOUT);
W
  • wjb
  • Author
  • Known Participant
  • 18 replies
  • November 10, 2020

Maybe I’m missing something, but I get the sense that you’re missing something that definitively sets the value of the URL that needs to be parsed. I see you open the table and get the records, but where do you decide which record to use in the parse process? I assume you want to run this process for all records, perhaps?

Another thing - to get the value of the youtube ID from the URL, you don’t need the youtube_parser() function; rather, I think this is all you need given the URL is in a variable…

  let myInput = "https://www.youtube.com/watch?v=YAIlMUX9VLg";
  let ytOUT = myInput.split("?v=")[1];
  output.set('myOutput', ytOUT);

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&amp;hl=en_US&amp;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

source https://stackoverflow.com/a/8260383

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);

B
Forum|alt.badge.img+19
  • Bill_French
  • Inspiring
  • 3263 replies
  • November 10, 2020

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&amp;hl=en_US&amp;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

source https://stackoverflow.com/a/8260383

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);


Yep, the variants do require regex.

Just create a Script Block version of the same process and allow it to process all existing records.

W
  • wjb
  • Author
  • Known Participant
  • 18 replies
  • November 10, 2020

Yep, the variants do require regex.

Just create a Script Block version of the same process and allow it to process all existing records.


Great idea. You’re awesome.


Terms & ConditionsAccessibility statement