I've been working for about two years within Salesforce Marketing Cloud, but haven't had the need to utilize anything outside of AMPScript, HTML, and CSS as I mostly just build and deploy emails with minimal Data Extension tampering. The Data Extensions are currently being created through a less-than-ideal process which occasionally requires a last-minute change to a field's content. In this scenario, a URL that is the same for all recipients of the email needs to change to something else. I have a template that pulls that URL into the email using AMPScript, and I wanted to find a way to keep the template as is so I don't need to change anything. The goal is to have some code that will overwrite this URL with a new one in these rare instances this occurs. I'm relatively new to this and I didn't find anything entirely similar on the site thus far. Here's what I've got based on my current research:
<script runat="server" type="text/javascript">
Platform.Load("Core","1.1");
// Initialize Data Extension by Name into a Variable
var LoadDE = DataExtension.Init("Data_Extension_Name");
// Find URL column and add new URL
LoadDE.Rows.Update({"Banner URL":"https://new-url.com/",["Banner URL"],["https://old-url.com"]);
</script>
The "Validate Syntax" doesn't throw any errors, but if I run it, nothing changes. I feel this is way simpler than some of the other questions on here, but as a newbie to SSJS I'm hoping on the right track, however any information to direct me towards a proper solution is welcome if I'm heading in the wrong direction. Trying to learn by doing, thanks in advance!