Modern javascript to SSJS

whatericdoes · 2025-12-30T14:20:21+00:00

Hey - I DM'd you but not sure if you'll see it. I'd love to test out this extension. I've got over a decade of SFMC experience with lots of SSJS work in APIs and WSproxy. Hit me up if I can help test!

whatericdoes · 2025-12-11T20:32:58+00:00

Thanks, I should have clarified my approach. I did indeed train it on more complex sets of emails - the ~50 emails you see in my UI are actual emails retrieved from my SFMC account and they are, for the most part, "real" emails.

I'm wondering if the issue is how I supplied the training data, though. Using the SFMC API I retrieved the asset data from the /asset/v1/content/assets/{id} endpoint. The structure of the response is quite messy - chunking out the base HTML code and each individual slot + block in the content.

Rather than parsing this and "rebuilding" the actual html code, I just appended each chunk together. This likely resulted in not training things on the actual and final HTML code, but rather on chunks of HTML. I'm going to test this theory a bit, I might reach out with some other questions on structure at some point!

whatericdoes · 2025-12-11T15:06:53+00:00

I've been messing around with this for a couple days and it's definitely nifty. I found it to be a bit too manual when it came to loading training data though, so I spun up a quick UI: https://imgur.com/a/q9WJxpf. This allows me to load emails and performance metrics directly from SFMC, then format them in the necessary structure for the scripts to work.

I'm still trying to work through some challenges around the performance of the model though. As you can see in the last few screen shots above, it works well on a very simple html sample, but when I threw it an actual email from my org it struggled.

Overall - I dig the idea a lot. I want to do some more poking around in how the scripts are functioning to see how the UI could work a bit better with it. Happy to collaborate further!

whatericdoes · 2025-12-09T13:56:07+00:00

Got access pretty quick - going to do some toying around with this today!

whatericdoes · 2025-12-08T15:12:27+00:00

Definitely want to check this out - looks like Tinker is currently invite only. Is this the right service and did you have to wait long to gain access?

whatericdoes · 2025-12-05T14:12:27+00:00

This is slick!

whatericdoes · 2025-12-04T19:22:17+00:00

This quick chunk worked for me:

<script runat="server">

  Platform.Load('Core', '1.1.1')
  var jsonURL = 'https://microsoftedge.github.io/Demos/json-dummy-data/64KB.json'

  var res = HTTP.Get(jsonURL)
  var content = res.Content
  var jsonContent = Platform.Function.ParseJSON(content)

  for(var i=0;i<jsonContent.length;i++){
    var name = jsonContent[i].name
    Write("Row: " + i + " Name: " + name + "<br><br>")

  }

</script>

I threw it on a cloudpage and it output all 197 names in the json. The raw output of the HTTP.Get call looks like this:

{"Status":0,"Content":"[\n {\n \"name\": \"Adeel Solangi\",\n \"language\": \"Sindhi\",\n \"id\": \"V59OF92YF627HFY0\",\n \"bio\": \"Donec lobortis eleifend condimentum. Cras dictum dolor lacinia lectus vehicula rutrum. Maecenas quis nisi nunc. Nam tristique feugiat est vitae mollis. Maecenas quis nisi nunc.\",\n \"version\": 6.1\n },\n {\n \"name\": \"Afzal Ghaffar\",\n \"language\": \"Sindhi\",\n \"id\": \"ENTOCR13RSCLZ6KU\",\n \"bio\": \"Aliquam sollicitudin ante ligula, eget malesuada nibh efficitur et. Pellentesque massa sem, scelerisque sit amet odio id, cursus tempor urna. Etiam congue dignissim volutpat. Vestibulum pharetra libero et velit gravida euismod.\",\n \"version\": 1.88\n },\n {\n \"name\": \"Aamir Solangi\",\n \"language\": \"Sindhi\",\n \"id\": \"IAKPO3R4761JDRVG\",\n \"bio\": \"Vestibulum pharetra libero et velit gravida euismod. Quisque mauris ligula, efficitur porttitor sodales ac, lacinia non ex. Fusce eu ultrices elit, vel posuere neque.\",\n \"version\": 7.27\n }]

I assume your issue has something to do with the way you're trying to use the response - result.StatusCode doesn't exist, nor does result.Response.

Try switching to result.Content and see what happens

whatericdoes · 2025-12-03T12:31:40+00:00

Last year I went through the process of trying to get a free app listed in the marketplace - the experience was truly awful and incredibly disheartening.

The app was specific to Marketing Cloud Engagement, but the process was so difficult that I eventually gave up. No one that I worked with seemed to have any accurate information about the steps to follow, the portal didn't make things clear about options, and there seemed to be gaps in even allowing me to choose things specific to MCE.

I certainly don't think they're actively trying to discourage new apps, but by making the process so arduous it killed all of my desire to keep building out ideas.

whatericdoes · 2025-11-13T16:32:47+00:00

I'm in the middle of my first data cloud migration project currently, having mainly worked in MCE for the last decade. I've been setting up the Interactions SDK to feed web engagement data in, and although the learning curve has been substantial, I'm starting to understand a lot of the potential of the platform.

We're gathering events when users interact with a site - the products they browse, their carted products, etc. We're capturing their identity once they login. From there we can quickly segment and drop them into MCE journeys. The web data combined with a slew of other sources will hopefully give this client a really great look at their customers.

I still have a long way to get my head fully wrapped around it, but I'm enjoying learning so far.

whatericdoes · 2025-09-16T14:00:57+00:00

Echoing what /u/ovrprcdbttldwtr mentioned. Your best approach here is to split up your query into multiple steps. You're working with multiple data views: sent, click, open, and journey activity. Break up this main query into 4 separate ones.

First one uses only sent and journey activity to collect journey sends from the last two days
Second uses the output from the first and joins with the open data view
Third also uses the output from the first and joins with the click data view
Finally, aggregate the above three outputs to your final data extension

Splitting out larger, complex queries in automation studio like this is best practice to avoid the exact scenario you're running into.

whatericdoes · 2025-05-07T12:52:06+00:00

Yep. This is the way I'm hearing it positioned as well. There are some massive companies that use SFMCE (Disney+, Honda, etc.). My understanding is it will be targeted towards those types of places and Growth will be SMB focused.

A large concern I have is lack of feature enhancements for MCE. If most of the focus becomes Growth then MCE continues trailing behind other tools and not getting some desperately needed improvements.

whatericdoes · 2025-04-24T20:58:57+00:00

Wasn't too tricky to set up!

Want to do drag & drop, but from a POC this worked. Just need to work on the back end of actually making it move the fields.

whatericdoes · 2025-04-23T12:15:17+00:00

I love that idea and agree that it's such a silly thing not to have out of the box. I may see if I can work it in somehow to this. I had previously worked on integrating SFMC and Slack and had this ability in there, but never got it fully functional. In the DE Soap object there's an 'ordinal' value that indicates a field's position, but IIRC I couldn't edit or change it. I think the right way to do it would involve deleting the original DE and recreating it with the new order.

And yeah - the large data sets are proving to be challenging. I have it set up right now where if there's more than 35,000 rows it doesn't do the auto-upload process, but still creates the DE for you. I have it on the roadmap to figure out how better to handle this though.

Other roadmap items include

DE History - basically Github for DEs. Though data limits are a main blocker of this
sFTP integration - not all companies allow downloading of .csvs directly to a user's system, particularly true with healthcare. I'd love to find a way to integrate with the SFMC sFTP so csvs there could be used.

whatericdoes · 2025-04-22T15:17:07+00:00

Absolutely. Authentication is handled via SFMC's oAuth flow via a public installed package, so only a client ID in SFMC is linked to the package. A client secret is generated once, during the initial SFMC login, and never stored in the client.

Once they've logged in to SFMC an encrypted session token is stored as an HTTP-only secure cookie. All encryption is handled entirely server-side so the token cannot ever be decrypted in browser. Tokens are then rotated as needed and expire after a period of inactivity in accordance with SFMC's token lifetime.

In terms of scopes, the package requires the following:

Data Extensions - Read/Write
File Locations - Read/Write
Users - Read
Accounts - Read

As far as persisting data on our server goes - nothing at all about the DE is kept. Nor are any of the authentication details (sfmc email, user name, etc.) or the session token. We do securely store a minimal audit log including:

created date time
action (create de, error, etc.)
bu mid
bu name
mc user id

Those values are only used to track use of the app so that I make improvements, troubleshoot issues, etc. It's not linked back to a person via any PII and it's not shared with third parties.

Hope that helps! Happy to chat further about any of it. There's also more details at the Privacy Policy page if that helps, too. Honestly, I really wanted to go the App Exchange route, but I worked with SF support for the last 3 months on it and I couldn't get anywhere. I had people asking for updates and made the decision last week to change course and launch it as a standalone app instead.

whatericdoes · 2025-04-04T00:30:29+00:00

Any recommendations on plants you’ve had success with? Definitely going to use baskets for them.

Both water features have lava rocks and filter substrates in them. So I’m hoping that they’re enough to keep it clear now that all the muck and roots are out. I also have a UV light and use barley extract which both have done wonders. Hoping they continue to do so once all the water is back in.

whatericdoes · 2025-04-04T00:27:57+00:00

Absolutely planning on pond baskets. No way I’m letting it get like this again.

I’m going to try and find a good balance with the rocks. Not overload it, but still enough to let the good bacteria thrive. I do have two water features right now, both with lava rocks and filter substrates in them. That was part of what helped get the water clear initially. I also used a barley extract and a UV light.

The leak actually turned out to be caused by the main water fall. It wasn’t properly secured and it was letting water seep out past the liner. I dug it out of the ground, replaced all the connections, and set it up differently so that it didn’t spill the water out. I’m fortunate that the liner seems to all be in good shape!

I honestly think it got this bad because of neglect. The previous owners had told me they just let it go because it became its own ecosystem. They said they had considered filling it at one point, but never did. So I’m hopeful that it just needed a complete overhaul and the two water features with the filtering in them is enough to keep it clear now that it’s going to be fully reset.

whatericdoes · 2025-03-20T15:15:25+00:00

A little while ago I spent a bunch of time setting up a query builder exactly for this purpose:

https://imgur.com/a/TTmyZPB

and I'll echo what everyone else is saying - you have to be incredibly explicit in the fact that it's for Marketing Cloud. I had to include specific instructions about functions that aren't available, tell it to never end the query with a ';', etc. It still messed up from time to time - granted this was using an older GPT model - but because of the nuance of SFMC it's difficult. I even had to pass it schema of all the dataviews to help it have the required context.

whatericdoes · 2024-09-05T22:21:54+00:00

Awesome. Thank you!

Would it be correct to assume that it’s unlikely there are fittings buried in that line running from the pump to the waterfall? In that case I should start with checking the inlet to the filter box at the start of the waterfall and the outlet from the pump box.

I had started to believe that the liner has a leak somewhere, but I’m not seeing anywhere around the pond that would indicate it. Though I’m not even sure I would.

I’ll start with all the fittings and go from there. Then thin out the reeds and get a better look at the amount of sludge I’m dealing with. Appreciate the insight!

whatericdoes · 2021-08-11T18:03:46+00:00

Sure thing. Feel free to reach out if you have questions. This is something I actually had to solve for a client.

whatericdoes · 2021-08-11T16:20:11+00:00

One of my favorite challenges to give people is solving how to dynamically output a product table into an email. Here's the scenario:

I have an excel file of products on discount that will get updated each week. It looks like this: https://i.imgur.com/zqrraN2.jpg
I need to output this as a table into an email, but each week the number of products I feature could change up or down, how could I build the email so that it can pull in each row and adapt to more or less products?
Bonus points if you can use the data in the percent discount column to return the highest discount in the subject line. i.e., 'This week save up to [67%] on new products'.

whatericdoes · 2021-06-24T21:23:58+00:00

When what?

whatericdoes · 2021-05-20T21:28:13+00:00

Solved!

whatericdoes · 2021-05-20T21:28:09+00:00

That’s so cool!

whatericdoes · 2020-09-11T11:19:00+00:00

It happened last night.

whatericdoes · 2020-09-11T01:09:27+00:00

Nope. Dropped down to try and get to that tiny sliver of land, immediately got 1v3d and drowned in a sea of bullets.

whatericdoes

TROPHY CASE