hello and welcome to live code happy hour for April 24 2020 and we're excited to be here today with a great group of folks so let's go ahead and get the introductions Brad you want to start us off sure my name is Brad Tilton I'm a developer advocate with the developer program at ServiceNow I've been developing and doing things with ServiceNow since about 2008 and have spent time as a customer a partner trainer and now employee wonderful day hey I'm Dave Slusher I am a software engineer on the integration hub team formerly a developer advocate at ServiceNow been on the platform since 2013 and been been developing software 20-some years 23 years now at this point 25 years holy cow yeah you think you would think that would require math but Oh wonderful thank you and I'm Andrew Barnes developer advocate service now been on the platform for over five years been developing custom applications implementations for customers so I've been at a customer a partner and now at ServiceNow focus on you know managing dev teams integrations and core platform functionality so the next part is is one of our favorite parts is introducing our beverage of choice back in the same order all right it is it is 91 here in College Station Texas so I have a Saint Arnold summer pills it is time for summer beers yes we've got it it's a good it's a nice looking can what's the color handful what do you got on the can there Dave so I have a hopping nomad IPA I bought this thing it all be all these I strongly suspect this as some sort of om situation because there's no brand on the can whatsoever this is a being green is a little chroma key unfriendly it's from octopi brewings in Wisconsin and just in case I called an audible and myself as Brad was talking I've got good to go in case I actually go with that one if I finish that I've got the aligning kugel summer Shandy which is very good for as the temperature rises that's nice for the temperature rising and I have got a hilarious one today is an arrogant bastard ale and this is from San Diego that's stone this is from out in California so that's I my wife bought the you know normally I buy my own beers but she bought the beer last week and this week and I don't know if you noticed but they're big ones so LiveCode happy hour we're here today to do some unscripted unscripted development on service now what we're going to work on today is we've got YouTube integration that runs this show and collects data forests so it creates the events then collects information afterwards and allows us to to do other things because it handles that automation for us because yay automation and I discovered that one of our integration things wasn't working that I didn't even know existed that a former advocate Josh Nereus built when it was Dave and Josh on this team to collect the videos from YouTube whether or not we had you know created it from our system or not and the so it is loading those and it's when it's trying to match up with the exist penguins it's not using the an identical format and therefore failing so it's creating a bunch of duplicates and I'll show you that once we get into the the instance and share so we're gonna fix that up and maybe do some sprucing with the YouTube integration while we're in there but that's the that's the rock bottom floor go is no more duplicates after the show today well and that sounds like that's one of those situations too that probably anybody who has done any form of service now work on any on an instance of any maturity at some point or another there's the question of why did this happen and what made that happen is there an undocumented business rule that no one knows exists this changing my record value from this thing to that thing or something where is this email coming from that no one knows where it's coming from it happens all the time especially in those those older you know older applications in in our world it's the ServiceNow instance my last job was a pre aspen instance so the amount of oh no I've got to I've got a cook closed that door I just opened there are there dark things in there now the thing that makes us better than a lot of the other companies is that at least we know it's on the instance as opposed to somewhere in my network is a thing that is doing something and I don't know what machine is on or where it is or what language is written in or anything about this process but I know I can see behavior that's a goostin machine so when I was working at the University just a fun little speaking of tracking weird stuff down they they actually traced at one of my sister universities so I was at NC State University and our our fighting opponents Carolina they found a full rack like a data center rack that was dry walled up and they found it by tracing the network cables that just went into a but there was no room like nobody could find how to get to it and eventually you know they went to all the sides and they were like there there's something behind this wall it's a touch through it and because they were tracing down a problem and the problem was that you know on this rack and they needed to physically get there and but but it had been sealed up like just completely sealed which is hilarious now that's a darkroom you don't want to go in the one that's been sealed so let me go ahead and start the share and he can hear us also I think you're also sharing your audio again let me tell you what we'll we'll cover while you figure that out that should be better okay there you go there we go yeah very handy when you need it but uh that was not one of those times oh no you're sharing your slack come on I haven't drank that big beer yet here we go sharing the right screen does it look okay this looks great you lovely I remembered to downscale the the screen and everything today so this is our production instance and as you can see I've sorted by title so you could see what the issue we're running into is you know this you might want to Andrew you might want to blow that up like one or two steps sure just for people like me with old bad eyes all right so you can see when I sort by title that we have a bunch of duplicates and so one of these is the one that is the local copy that we then pushed to YouTube and the other one is YouTube saying hey I've got this video and syncing it locally and you know when you don't match on the a unique key properly you get to so let us go into our development instance we're going to go to the table that is doing this if I can spell artifact correctly today so there's this YouTube videos under our YouTube integration application menu and it will let me sign in alright come on do-do-do-do-do-do-do it I said seriously whatever are you why are you giving me trouble there we go that's what I get for having it prepared so to the YouTube video table and this one will need to be blown up similarly that should probably be okay so in this table we have the synchronization that's coming from YouTube to local so the only data in this table is stuff that's coming from YouTube and there is I believe a business rule so we'll probably go look at that integration as well but there's a business rule that it's the the root cause I believe so if we go to our business rules we'll see there is a business rule on this table let's generate artifact from YouTube video and so artifact is the name of our table in which we store our management records and so you'll see after it's been inserted we're going to do this script and the thing that we're looking for is the published Earl is our Earl and I believe that what is happening is that the format of the two files is slightly different this is that one of those things where you have you can do the watch equals or you can do the direct so so so what you say you can be passing it if you'll notice like what you're just showing a second ago it's like youtube.com/watch and then a query parameter V equals like video ID the YouTube video ID and then there's one that doesn't involve that query parameter that could be the case absolutely so let's go take a look at two of the records and see what the actual differences are and in order to do that I inaccurately loaded that locally and I need to do it in production so let's load these two records that are getting duplicated and take a look at the published Earl is this compressed YouTube EE you've actually you actually have both you know in that previous record you had both examples right there and so here's the watch mm-hmm one that this is the one that has come down from YouTube mm-hmm and yeah yeah so you can see it like right there you got a nice head to head comparison that those are synonymous yeah but I mean they both go to the they both show the same video but clearly one is slightly shortened right so we have to decide how to approach this Dewey one just fix this up real quick and I wasn't I wasn't keen on that idea I was like a business rule most of the stuff for this integration now is in flows let's let's get it on over into flow what go ahead Dave here's what I think here here is my like I've got three seconds of thought in this because like YouTube as somebody who has a couple years of you know integrating things to YouTube experience now it is subject to wackiness at a whim and so I for example like I wouldn't necessarily assume that whatever formats coming down now will be the format in the future so here's what I would suggest let's find some way of just normalizing given a you Earl let's normalize out the ID and then use that basically has to coalesce key that seems reasonable I like that because then if they have let's say that at some point in the future if there's a third different format sure but YouTube is you know it this is is our unique ID as far as YouTube's concerned for like all time well I mean you have two different ways of doing it then you could actually make sure that we never we don't generate anything but that so let's see if one are we getting that ID in the record directly at any point if they were filled for that it totally wouldn't shock me if when if we're getting both of these via integration and one integration is returning it in one format what integrations returning it in the other right right because aren't we getting the one like you're doing the scheduling via integration it isn't that watch Earl coming from the scheduling it is and the retrieved one is the watch as well this is I believe a a copy-paste so let us go take a look at so this is due to due to due to these records let's take a look at one of these so this is so we're gonna get rid of prod now so we narrow down the things we're gonna look at I'm gonna look at the last three marker didn't just see what's in here and see if we've parsed out that ID already because I suspect we did and if not we probably have it in the did I click the artifact record I sure did oh this is I I clicked the wrong record no wonder YouTube videos they're so similar video ID look at that it's already in there parsed out separately so I suspect we could probably just super super easy is just looking for a URL that contains that absolutely yes yeah you know as our coalesce is look in the draft URL field and look for this string if it's there that's our buddy go pair with it so we we already have the handy video ID so we could do that here which is we wanted to this one is saying what is that get that unique value for you oh if it's already linked so if we wanted to adjust this one we could have just taken instead of the earl taken this ID video ID and looked in instead of the published earl we look in the draft earl and for its buddy so that is the easy way and and i might do that but i feel like doing this in a flow today because i like flow designer I do too and this this business rule has gone over the line for how long I like them to be it's too long a a you know 20 lines is too long business rules need to be so short should I use description glued there new flow let's do it we're going to sync video with live stream and this is going to be an artifact manager we're going to do this is the system user we're gonna submit so we're gonna set up our trigger and so our trigger is going to be a created record on our video table do you table and I'll probably set up a sympathetic flow on our artifact table so that if for some reason the video had already been created but we didn't find the match the first time it will will sync up later so YouTube video table add a filter no we don't need a filter right it's new records good done new records so we've got our video record and we've got our video ID which is there BAM that's probably off the screen we want to look up records look up records do I want to do a look up records or look up record I feel that I tend to just use look up records because it doesn't cause my flow to error when there's no results does that is returning nothing in error is it a catchable error or as I don't remember because I haven't it's not a catchable error it just stops your flow I don't want my this particular flow to do anything else if it doesn't find a result so I think that's okay in this case okay so we'll just do do a lookup record so we're gonna look up on our artifact table for artifact table and we're going to go to the type field type is video or livestream and we want to check the draft URL contains our I'll use the little picker record video ID so the draft or the published URL contains I want to copy you let me copy you not today it says not today maybe later I do like it when you have like a string input field and like you can copy the data mills and the strings and things but but so low data pills there's there's no copying them so we don't need order we only need one record so we have our record now yay now we want to update the record update the record and I actually did not look to see what that what it was updating it says set the type to live stream what it it's I think we so you're creating and you're creating a net new one you're creating a net new artifact yeah is so if I didn't find one create new artifact but what if it was a static video I'm if it's a oh if it's the static video then you're gonna call it livestream no matter what is that distinction in the YouTube video there there is a distinction in YouTube yes whether or not it was a live stream or a is that distinction in our youtube record though or is it getting dropped I I don't know when we're retrieving the YouTube record like we may only be retrieving live streams with this integration mm-hmm that's a good question well and and do you like if there if you are retrieving static videos is there a place to put that in that other table so you may actually need a new column in that table while you're looking at that up I just want to call out hello - oops 360 on Twitch we have we have twitch chats I just happened to I happen to notice it as I was making sure it was streaming over there was a scheduled job let me just narrow it down by application how about show me why can't you filter by application well that's not huh I don't I don't approve of that whatever man clear clearly I got something interesting going on there artifact manager why do y'all look at D I'm gonna here's process my uploads what was the net looks promising yeah this this one looks really promising so process my uploads is and runs daily on Monday run daily on Monday yeah so I know this thing only runs once a week so that's probably it so let's open up that record and then we'll get to the script include open and so that was process my uploads and it says hey go to YouTube get the uploaded playlist so I suspect that this gets all of the videos from YouTube fresh stream or not yeah if you look so at some point like the thing under that is that process video items which is doing that kind of absurd yep into our target record that is your thing which is this one which is the one we're working on right now so scroll down a little bit see is it hard coding live stream or is it getting it I don't know that it's put a live stream in metal okay I don't believe it's putting them in this okay because it's not a that's not a thing this knows about hey what let's put a pin in that so that's like a subsequent thing it is me write that down so I needed what I was supposed to have been doing was looking to see what we actually want to update in our target record was there anything that I did want to update where is how come I don't have my business role there it is generate artifacts from YouTube video so we want to you know get the title description URL unique set the YouTube video and the publish date all right that's not too bad let us update some values so we are going to update the record we found so I'm back in flow designer now and we're going to update the record that we looked up which is going to be on the artifact table and if we found a record I think the only thing we want to do if we fought oh this is why I do want to do lookup records because if I fail I want to do something different which is create a new record that was my bad so I do I do want to do that so I should stop with that because it'll remove my data pills anyway so lookup records which is on the artifact table and we want the type stream actually I don't even care about tight I only care about the URL contains heart trigger records video ID or be published Brad is is quieter than normal how're you doing over there Brad I'm good is anybody being entertaining in chat we had a couple of questions Dave is just taking everything in the chat so he's got him answered with some I think I think our artifact table we could we could talk about a little bit is our artifacts are all sorts of things we track our our blogs our live coding happy hour videos we have some videos that are not you know we publish videos to YouTube sometimes or some people publish videos to our YouTube they're not live and so we have a lot of different types of artifacts in the artifact table which that we do why this is some fraud so it's only gonna live streams because that's the only thing in the table right now but if we opened up one of them we could take a look at the types which is we've got blog posts series content blocks knowledge sessions videos webinars workshops in-person apps we have all all the things and we have a lot of people that have access to this to contribute to that it's not just it's not just the dev advocates and to provide visibility to other groups that are not contributing but want to know what's going on so I'm looking up for my video ID if it's in a URL you know in fact that already exists if it does I'd like to update that artifact record so actually I want to my bad we're gonna add a flow logic of if our count is one we're gonna do this stuff whatever counts not one we're gonna do other stuff so if our count is 1 then for each thing in our one bucket we are going to do this which is we are going to update its video field to match up with this record BAM so that's pretty straightforward if there's already an existing artifact record go along with that record and set the its video record to point to me and the other thing I'd like to do is I'd like to automate the the publishing so we'd like to set the state to published and mmm I kind of want to update the published URL if it's not present how annoying it's reasonable to add in as well I think I think I'll do another check I guess I kind of want to script it cuz that would be so easy to script to do so logic if the published published is empty do you care if there's I mean so do you care if it exists already you just want to make sure that it's right what happens writer just don't we just do it either way good good call if I found a record that I align with go ahead and set its publish value to my value so if if for example we did what you pointed out earlier which is we pasted one in and it used the a different format use the format that that you that YouTube is giving us I like that actually so per URL BAM that's nice and shorter logic consistency I like it so if we fail now we're gonna create a record and then we'll be done create a record on our artifact table and we're gonna add a value we're gonna set a type even though we're not sure what the type is but we're gonna lace narrow down to a type of video and we're gonna set the and there is a conceptual case I'm not arguing this necessarily just that it one could argue that like we have two different artifacts in the creation of this thing that we have a live stream and then we do the live stream and then the artifact becomes a video mm-hm that we actually don't care necessarily when it's done whether the source was done via I mean actually I'm not sure if we care but it is possible that we don't care and that that at that point it's just although it had a different creation process is they're all videos oh oh I see what you're saying there yeah I think for for our understanding of the impact of videos versus live streams mm-hmm I'd either want to I might want to have some cut over time I start counting a live stream as a video like a week or two later mm-hmm because because yeah you have a point the live stream is a one artifact type while it is you know while it's new and relevant but but then as soon as you know essentially the next live stream happens I don't care that the previous one was a live stream mm-hmm I I could dig that I thought I believed you just answered what the logic should be in that sentence right there which is when you schedule the next one the previous one stops being a live stream yeah it stops being a live stream it's it's not just a video I can dig it so the type is gonna be video because because that's the type now and we so we want the URL we want the description what else do we want let's expand this data pill to see what's even in here so we don't need the channel ID we don't need the tags the title is the short description wait I think it might be called cutting hair and it is called title very good it's the short description field but the label is title title and come on data pill come back and that's oh let's check the check the business rule and see what's in there you know wasn't it longer than that yeah it was but I don't know if I want any of there's at least one thing that we don't want oh so this and I want the reference to the YouTube video right I had that one night okay so oh no I did not set that you're right we do want that though YouTube video links to the record BAM the state is now published and the something about the date let's go swish date look at you guys not planned published date published act here we go that's looking pretty snazzy so let's review what we did and then we'll test it and see if we you know did that appropriately please save thanks I I was a better steward of that in in my workshop earlier in the week so when a YouTube video is created via the integration so a new record is created in our YouTube video table we're gonna look up in our artifact table to see if we've got that video ID in a URL because that's how we're storing that video ID in our artifact table we don't have a field for that is that mouse over new coz that mouse over looks new to me that's gotta be new I don't even know what we're looking at is that yeah that is new so that's that's that's the encoded query kind of equivalent well it's just no dot dots it's huh it's all the same content is I'm bouncing over it's just with no dot dots it's interesting it's it's kind of nice I like it but I didn't know it was like it's been distracting me let me let me got not get distracted by that it's cool though especially when you know that it gets long-winded up here which you know you you can you not rename these things I'm you stay in the action designer where you the in the action designer you can rename the steps but here I mean that is auto-generated via like the the things that contains the data you put in there all right so we look up the artifact record to see if it's there and if it is there and we only have one of them then we're going to update that record to connect it if it if there isn't one in only one record we're going to create a new artifact record we're going to associate our existing record with that new artifact record and set some fields so let us test now there is actually a potential bug I don't know if it will ever actually happen but there is a potential bug here which is if you have two records already you will create a third yes absolutely and and I yeah and the way I phrased it definitely includes that right one in my town one and only one match for my matching you know my unique value that I'm trying to match on go ahead and create a new one because which means that this has to fail your mode of possibly creating a whole bunch like one every week for perpetuity if if it yeah if it if we have a case like that it could continue to grow assuming that we had something that was duplicating the artifact records in the in the in our artifact table yeah so if some something else causes a bug we could then have two bugs like we're like right now if you put this in production like all the ones that already had the problem are gonna continue to have the problem right you would have to bleed everything wait yes because we already have duplicates so it would it wouldn't cause us any problems right now because this is a only run on insertion rule mm-hmm wouldn't but if I gotta fix it for the existing ones I guess that would cause a problem so let's test it out and before we test it out we need to go look at the data to see if you know our results are going to be good so artifacts we have YouTube videos and this and and refresh my memory this has instance data replication with the same data from production rate this does not those actually retrieving them okay so this one part which is why the only data in our artifact table is these is because it has created all of the equivalent live stream I gotcha okay so we are going to grab this record and let's go find its artifact friend which is going to be star ma'am so we should have one here so there is a matching record right now for that and it is connected to its YouTube video so the first thing I'm gonna do is unconnect it from a YouTube video and now we all try and get back to that record this one and see how flow designer wants to find that to test it yeah so we need the name so let's get the title of this bad boy oh that's a recent one that's last week hello recent parsing XML that we did we're not successful at video so our expectation is that it finds a record and it attaches itself to it I took way longer than than is reasonable okay it completed and it took the no branch to create a new record you dirty looks like it went down both branches yeah but did we know that's not an else yeah that's an unconditional create record there my friend good job Andrew well everyone you mean everyone failed to notice that so it's not a one person responsibilities so our expectation is this got this record where is it this one this artifact record did get connected and a brand new one was created now because of that that logic so was a brand new one created a knot type livestream yes yes it was all right so we'll fix that logic and while we're at it we're gonna delete these goodbye friends J sabzi Jason mark object to being blamed there there abdicating their responsibility as extra eyes all right if else now we could be better stewards you know and just go ahead since we've talked about oh that is not what I wanted flow designer no IOU son you did not save so I would yeah we are reloading because I object to deleting my record there buddy old pal so we since we talked about it we'll go ahead and do a conditional check and if the count is zero we shall proceed and if the count is not we will you know throw an error mmm is zero because because we're good stewards of the world our little world right here create artifact record if count is 0 and then else throw a log Oh error all right we should ask the people in chat if this looks good now yeah have some skin in the game let them off the hook throw in like the sis ID or I was just already yeah where I said put that go away at the end that's where the cannon ball helps some somewhat you have a little more control over it all does does help with that I actually really prefer the cannon ball almost always because I can search with it which makes me yeah anytime you have to dot walk to the task table and I like the and then the next thing I wanted to say was the title of the video this one come on so mark and Jace say this is definitely gonna work they went from uninvolved to a real firm on that all right so now our expectation is that we find zero this time and we create a new record so let us guess if assuming that works we you could also create yourself you just do an insert and stay and then test out branch to write yes Ren test you recited that it took too long but it is hitting YouTube right so oh no it's not it's looking only a little creating the record we hit they fail you know so we hit zero which is good we created a record which is good this is what we wanted we open that record uh-huh very good we're gonna clear this out then we'll hit the first branch and then we'll do an insert and stay and hit the last branch oh you're so thorough man so we're gonna run that test again first branch we should update with the linking yay and now we insert and stay oh wait wait and error it said this URL is already in use buddy hilariously it doesn't stop you it doesn't right it's a warning that is uh that's there but it created a new record so there should be two of those over here hello friend so it let us know you're being bad don't do that but but then let us be bad because that's okay so this should hit the calhfa's not zero counts as not one throw a log oh and one of the interesting things in the YouTube chat is a like mark was mentioning that he has created a custom record exists action to do exactly this kind of thing right so you just get a yes or no oh okay and you know super duper duper disclaimer the look up record is getting adjusted - - hand - not error on say so you can proceed with your flow that's a that's that forward-looking statement there don't make any decisions based off with it safe harbor bloody buddy blah yeah body blood of God especially no financial decisions not guaranteed delivery on any specific date and in a specific version and boilerplate you have duplicate video IDs an artifact table it's exactly what we expected yay our flow is done fantastic activate this sucker we're gonna move it into production so we stopped getting duplicates I don't want this show to get a duplicate now what do you have to do to your existing stuff you you want to get rid of that business rule right or deactivate I'm just gonna I'm just gonna nuke the I'm gonna deactivate the business rule and then I'm gonna nuke all of the records that created in in production mm-hmm so in my work here you're right the the the next thing I need to do is deactivate so kill this kill this go to our business rule deactivate that business rule as Jayce mentions it's the opposite of safe harbor it's dangerous Harbor dangerous dangerous all right so our business rule goes away now we don't have any business rules on this table yay only flows I I kind of wish there was a thing that would show me like those together like it's good actually behave it's beautiful features rules it's got you know everything that will happen when this changes that regardless of a lot of cool yeah so our business rules deactivated our flow is activated our flow is doing what we expect I believe that's time for stop chair oh right I'm rusty clearly so not super complicated today we've been really busy with not really busy with prepping for knowledge and but the but this was annoying the crap out of me like that's the best kind of a problem right it was Oh problem it's causing real issues in your day-to-day work so let's fix it on Friday yeah what's causing me realize two hundred and fifty duplicates get annoying me and costing some integration annoyances I'm sure an info message for every one of them right really annoying so I'll fix that but you know as a good steward I had a little time in a window and a box to work in so I I cleaned up our process I've made it more sustainable and maintainable for the future so future me will still look back and say yeah old me you could have done better but at least you did me a solid today and test ik so thank you for your help gentlemen anything else that we want to cover about this yeah I mean this is super common like thing that you'll run into I've got an old older process running doing a thing that no longer is functioning I need to tweak it a little bit spruce it up a little while you're in there well I'll tell you it's so considering my new responsibilities in my current role you know my I am more or less 100% tasked with getting more people doing more work with the flow so given that that's my agenda I am completely on board but here's the other thing is the thing you have is more maintainable by more people than that business rule that script include it's true I mean it it's more obvious what's happening which if there is one I've had over the on the last four years I always whether it's the most optimal and whether it's the fastest I always will favor clarity over obscurity in a multi-person production environment right I want everyone to be able to tell what this is doing not have to hunting you go on an Easter egg hunt for where the logic is happening I kind of like a place to to store some information nearer to my records mm-hmm to that point I love the point of you know clarity over and over nearly everything else is being able to give so the flow is it's pretty clear what it does but I'd really like to give it like some textual clarity mm-hmm like yes that's a thing I also have to maintain but I'd like to be able to put some text there and and help the next person along a little better than I am today you're saying annotating the flow or just annotating the record the actual record itself saying these things will happen to this record yeah I was talking about annotating the flow but you you can do yeah I mean you can't annotate the flow right you could do that in the description you can add annotations to each of those steps in fact that's true you can I don't ever do that because I don't think about that the annotations where on where on the individual steps can I add an annotation I believe in a bearing in mind that I also although I'm talking about this as a great thing I've never actually done it myself I believe that there's a little like comment looking icon right next to that that you can add an annotation there for each step there is a little comment a little icon there you go it's a good idea that you know clearly underused at least by those on this go you know just because you have a good idea doesn't mean that you know that it exist to start leveraging it so so that was a good point so how are your beers today you find find gentle folk thither are with me on the call today bread well my my my colorful summer fills looks wonderful and it was pretty good for a a lighter summer beer so I'll give it a for based on having success and learning about annotations as well alright so here's the deal the hoppin Nomad IPA session ale which again is quite chromakeying into acute I'm giving it a 375 the Leinenkugel's summer Shandy cuz I've got a big bastard which you know it's very clear at the bottom to say you are not worthy in case you didn't catch that before it's it's good like this is good this is a for this is solid for it did it's not getting a bump from the victory cuz it was a low bar for victory today but this is a solid good beer I like it it's a four this is this is great yeah I love fixing problems that cause me woes I appreciate your help today coming up really soon next weekend the hackathon so our hackathon we had already planned for it to be virtual now it has to be virtual but but we're excited to have the hackathon running from basically right now next week over the weekend is going to be the hackathon we're gonna kick it off from this show is when the when we stop the show is when the hackathon starts so we're excited to have the hackathon next week sign up we'll put the description or the link to the sign up in the description of the video here if you watch this over the next week if you're coming back later the hackathon already happened you can't participate but while this is marked in the artifact manager as a live stream this is relevant to you which is come join the hackathon sign up get a team you know go ahead and sign up even if you don't have teammates yet we'll help you find a team we've got some great prizes the the big prize is gonna be $5,000 prize we're gonna have five different categories for your apps to be built in and each category winner will compete for that 5000 grand prize and but the individual category winners will get a $500 prize and that's for your team Brett why don't you bread is our main stage man for the hackathon why don't you add a little more yeah so again we're gonna run it next weekend it's gonna kick off Friday after the show is done and it'll run through Sunday night at 11:59 Eastern is when we're going to end it we're gonna be doing some live shows during the hackathon itself on one on Saturday that's gonna be midday and one on Sunday morning so that we are friendly to all areas world the world centric view that's right and we'll have some live guru sessions in case your team runs into any issues but yeah everybody's welcome most people are welcome to come come sign up and there there are some exclusions we have learned after talking with our lawyers but for the most right everyone's for winning prizes yeah feel free to sign up and compete so yeah it's gonna be it's gonna be a fun we and if you're interested in being on a live stream you'll have the opportunity to be on a live stream and share what your team is working on and more you know more details will come for that so we're really excited about it and you know we have a lot of people signed up already and and you know come-come checks you you who's watching right now you can sign up right now ah URL Fred it's hack mount service - now.com slash creator con suite and on you know engine in a normal world you might have conflicts but this year what else do you have to do that I never participated directly in the hackathon was because I wanted to go to sessions and ya know engage with things and that's the reason we were moving it virtual this year was so that it could be related to knowledge but not conflicting with session times so I think if I was even talking about in the world right you might know that - you might normally they had something going on on the weekend but we're all in our house so what else do you have to do you're not going anywhere else come on down join the hackathon don't have to be a traditional developer you know if you're a product manager or designer or you know just have a problem you want to solve and you want to help contribute and work on the presentation join a team I it's not just for developers to to be in a hackathon because a large part of it is the convincing judges that what you've built was also so you know building awesome things are good convincing other people that what you built was was awesome is also a different skill set so come on down and join us then right after the hackathon the you know couple of days after will be the launch of the knowledge event and then the week later we'll have creator kaan and have the creator concentric stuff for you so go register for knowledge and the hackathon join us compete in a team watch the live streams that we'll have next weekend and we appreciate you joining us today so just one question about the hack hackathon that just came in on twitch if you don't have an idea you can you join a team of somebody else absolutely so if you're a lone person you're a lone person you'd like to participate you have no idea you can find a team that's already needs more people and just joy and we're gonna have some problem space suggestions as well so even if you have no idea and you have a team we can help you find an idea yeah we're gonna publish some some ideas for each category we're gonna try to come up with some business problems by talking to people in each category we have some of those and we'll publish those before the event starts and then we also have a creator con hackathon community forum on the ServiceNow community and there is a post up there already about you know if you're looking to find a team you can comment on that post and we've got a number of teams that have been created based on you know people looking for teammates and finding teams so you know look for that and use that to find a team if you're looking for one awesome well thank you for joining us Dave Thank You audience for participating we're happy that you joined us today and we'll see you back again at the regularly scheduled town next weekend and then we'll kick off that hackathon so have a great day everybody