Skip to main content
The 2024 Developer Survey results are live! See the results

New answers tagged

1 vote
Accepted

Account.Retrieve SSJS core function has stopped working

partially copied from comment: code works for me, stack51. to narrow down if the operator is (or became) the problem, try a filter that relies on operator equals but also assumes nothing, like filter =...
Jonas Lamberty's user avatar
0 votes

Best Practices for Automating Reporting in Salesforce Marketing Cloud

You are asking a non-technical question, so you'll get a non-technical answer :) Tracking data is fine, but you have almost zero infrastructure for custom reporting. Short answer: export the raw data ...
Jonas Lamberty's user avatar
0 votes

SSJS Syntax Checker

This is a great resource you can use to play around with SSJS (and much more): https://mcsnippets.herokuapp.com/cloudpages
Yevgeni Y's user avatar
1 vote

Update a field as 'TRUE' if exist in the other data extensions and 'FALSE' otherwise

You don't mention how it is not updating the "Exist_in_SF" field properly, but I guess there are records not being updated anything. This is because you are using INNER JOIN which it will ...
Duc Le's user avatar
  • 3,508
0 votes

Send Cloudpage content in an email to a set email address

I hope i got your issue correctly... One option you can use is to export the table date to an Excel with JavaScript. It's not an email :) but i think it's a good solution. I used this code before and ...
Yevgeni Y's user avatar
-1 votes

Query subscribers who have not opened an email in the last XX days

SELECT DISTINCT s.SubscriberKey, s.SubscriberId AS EmailId, s.jobid FROM _Sent s LEFT JOIN _Open o ON s.SubscriberKey = o.SubscriberKey AND o.IsUnique = 1 WHERE o.SubscriberKey IS NULL
Drashti Varaiya's user avatar
0 votes

getDataExtensions: $search is a required parameter

It is in fact super simple to start using those URL parameters. The important part is to understand how your chosen API call expects you to append them. In your case: Method: GET URL: https://{...
Niko's user avatar
  • 2,744
0 votes

Migration Issues from MarketingCloudSDK 7.6.0 to 8.1.2 version

Looking at the error seems to be Simulator permission issue, request to check this. Also, recommend to follow the steps for migration of SDK to 8.x provided here: https://developer.salesforce.com/docs/...
Prakashini Pattabiraman's user avatar
0 votes

Trigger automation when row added to Data Extension (without external API)

You can do this by: Create one DE called "Last Triggered Record". The goal of this one is to keep the date of the most recent record. It should only have 1 date field. Create another DE ...
Eduardo Ruiz de Pascual's user avatar
0 votes

Salesforce Data Cloud Web SDK

Yes, Data Cloud Web SDK can now customize websites in real time with the newly introduced feature in July'24 release. Please find the below link to the same. Link:- https://help.salesforce.com/s/...
Nikhil Patil's user avatar
1 vote
Accepted

HTTP DELETE for a Push Location

As @identigral commented above, you can use the Script.Util.HttpRequest() function as it lets you be more flexible with the method. You can alter the your code something like this: <script runat=&...
Duc Le's user avatar
  • 3,508
2 votes

How do I know the Marketing Cloud Edition, which I am logged into?

The chrome extension is no longer available. Links in previous answers are broken. Even if the extension does exist somewhere, you might still want to avoid installing things in your browser. To find ...
Alex Kozlov's user avatar
1 vote
Accepted

Possible to export a Data Extension programmatically through SSJS

The only way to interact with the SFTP is Data Extract/File Transfer (and imports). The problem is that you need both, one after the other is finished. -> The solution is to put them into an ...
Jonas Lamberty's user avatar
0 votes

Cannot change the entry Data Extension in copied journey: Failed to find the Automation selected for this Journey

You shouldn't click "Edit" button to change the schedule but there is a drop down right there let you "Change Schedule Type" where you can select the new automation schedule.
Duc Le's user avatar
  • 3,508
1 vote
Accepted

HTTP GET for All Push Locations not working

HTTP.GET returns the response object with attributes are Status and Content Therefore you should parse the response like this: ...... var responseAllLocation= Platform.Function.ParseJSON(response....
Duc Le's user avatar
  • 3,508
1 vote

How to populate FromName and FromEmail in EmailSendLog with both regular and dynamic Sender Profiles

You can make your SendLog Data Extension as one source of truth for that matter by setting up an Automation with a SQL Query Activity that will find records from _Job Data View where "FromName&...
Niko's user avatar
  • 2,744
0 votes

Why is the SSJS constructed query not updating?

Found the issue, the var sqlQuery = "" was in a try/catch scope. So the actual function received an empty variable. Here is the updated part: var sqlQuery = "" try { var de = ...
yoni349's user avatar
  • 133
0 votes

Error while building on Android (class file has wrong version 61.0, should be 55.0). (React Native)

I'm having a very similar problem with Android in react-native 0.67.4 (iOS works fine) The app was working fine with react-native-marketingcloudsdk 8.0.0 but when I try to implement Analytics using ...
Antonio Mendiola's user avatar
0 votes

Errored out automations for the past 1 hour

What have you tried? Where are you stuck? We will be happy to help you, but expect some degree of research on your side. You can, however, start looking at the Automation Instance data view. It can ...
Lukas Lunow's user avatar
  • 21.8k
0 votes

Generate bitly to SMS campaign

Maybe the group guid is not with the correct value. It works when I try to remove the group_guid attribute in the payload. So if you don't really need that attribute, you can remove it. Try it ...
Duc Le's user avatar
  • 3,508
0 votes

Marketing Cloud - SQL Query to Return all Subscribers Who've been sent an email

Data views store only last 6 months of data. Hence, you won't be able to retrieve data for last 5 years using data views. See here You have to start archiving your engagement data into a third party ...
Swati Mishra's user avatar
  • 1,683
0 votes

Create an externaly hosted SFMC Custom App with dynamic credentials

I would typically see the credentials in environment variables in your app, so heroku, cloudflare etc. Meaning they would not be hardcoded inside the app, but you'd host one version for each customer, ...
Jonas Lamberty's user avatar
0 votes
Accepted

CreateSalesforceObject creating duplicate records

I'd suggest excluding test sends and adding some debugging output: %%[ set @debug = 1 set @id = AttributeValue("_subscriberkey") set @isTestSend = AttributeValue("_IsTestSend") ...
Adam Spriggs's user avatar
  • 30.8k
0 votes

Sending follow up email after immediate open in Journey Builder

Your question inspired my thought process, which resulted in this article. It explains how you are able to track opens, and trigger "something" in real time, using Ampscript. This something ...
Lukas Lunow's user avatar
  • 21.8k
1 vote

Remove customers from journey in case they placed an order within the wait activities of 6h or 24h

I didn't understand why Exit Criteria doesn't work for you - you can set it to check if the customer made an order and that can be the trigger to get the customer out of the Journey, right?
Eduardo Ruiz de Pascual's user avatar
0 votes

Sending follow up email after immediate open in Journey Builder

You cannot do this with Journey Builder alone, you'd need to monitor the opens with another scheduled process that ingest people into the follow up Journey. Let me try to explain the structure: You ...
Eduardo Ruiz de Pascual's user avatar
0 votes

Emails not being sent

I was facing the same issue and the solution was that the PersonContactId wasn't the primary key (I had chosen that field for he subscriber relationship). Once I changed that, I was able to send the ...
Mari Hurrie's user avatar
0 votes
Accepted

Retrieving Email Legacy IDs from Shared Folders Across Business Units in Marketing Cloud Using REST API

I've contacted SF support and received a solution for my issue. I'm sharing it here in case it helps anyone facing a similar problem. "As I mentioned, the /asset/v1/content/assets/query endpoint'...
Evelina's user avatar
  • 11
0 votes

Image Upload Feature on Marketing Cloud Landing Page Not Storing in Data Extension

DE Field limits; We cannot see the DE, so just indications: you seem to handle empty checks PK is fine if the field is text/ 36 chars (length of a guid) CreatedDate is fine if the field is date ...
Jonas Lamberty's user avatar
1 vote

Data inconsistency between SFMC and Sales Cloud

I know it's quite late, but I had a similar problem. What happened in my case is that I synchronized fields after synchronizing the object, and then the update of the synchronized DE did not come out ...
Mario's user avatar
  • 31
1 vote
Accepted

Validate an email in Marketing Cloud using APIs

This endpoint can help you validate whether an email address meets certain criteria. The checks you can perform can be either or a combination of: SyntaxValidator: Validates that the email address ...
Lukas Lunow's user avatar
  • 21.8k
1 vote

Retrieving Email Legacy IDs from Shared Folders Across Business Units in Marketing Cloud Using REST API

The below worked for me to fetch the Email created in a Child BU & shared with Parent BU. Note that while generating the access token, ONLY upon using CHILD BU MID the email was fetched { &...
Vishal Kumar C V's user avatar
0 votes
Accepted

Correct syntax to reference dynamic column name with SSJS Rows.Update() function

just found the answer which tested and works (thanks chatgpt) var colWrite = 'Column' + e.num; var updateObject = {}; updateObject[colWrite] = payloadStr; DEName.Rows.Update(updateObject, ['CampaignID'...
mozzy69's user avatar
  • 38
0 votes

Use email attribute from Contacts. Not Working in marketing cloud

The email attribute from Contacts is going to pick the Email Address saved in All Subscribers. This email is only updated is only updated when you send an email to this Subscriber Key using the ...
Eduardo Ruiz de Pascual's user avatar
0 votes

I want to update Salesforce Automotive Cloud Object and Marketing Cloud Data Extension using SSJS in Automation Studio

I found a post on Stackexchange that mentioned when updating a Salesforce object's datetime field with a value from a Marketing Cloud datetime field using AMPscript, you need to use FormatDate() to ...
Hyein Park's user avatar
1 vote
Accepted

Contact Deletion + Auto Suppressions

Contact Deletion works on Sendable Data Extensions. Source https://help.salesforce.com/s/articleView?id=sf.mc_cab_contact_deletion.htm&type=5 "the Contact" in a data extension is ...
Jonas Lamberty's user avatar

Top 50 recent answers are included