246 questions
0
votes
0
answers
73
views
Is it possible to encrypt subscriberkey when it is an email_XtraLinkParameters which is handled in Setup > Parameter Management
My customer wants to encrypt sensitive data (subscriberkey) in email urls.
The url points to external webpages.
I guess we could use EncryptSymmetric if it wasn't so that the subscriberkey is added ...
- 75
0
votes
0
answers
94
views
SFMC email templates that work across email clients
I've been coding HTML emails for several years, and I've been sending my HTML emails through Marketing Cloud for a few years. I have a good understanding of how to code an email to look consistent ...
- 81
0
votes
0
answers
39
views
Correct key for REST API endpoint
I'm trying to authenticate against the Marketing Cloud SOAP API and am having a nightmare trying to pass the Oauth token in. Code is below. Does anyone have some working code to compare to, I can't ...
- 65
2
votes
0
answers
222
views
Outlook 2025 not honoring email conditional HTML
The long trusted conditional HTML statements for Outlook do not seem to be honored by the latest version of Outlook (2025). They still work in older versions.
Example code:
<!--[if gte mso 9]> ...
0
votes
2
answers
198
views
SFMC SQL Query - Limit number of records
I'm trying to create an automation in Salesforce Marketing Cloud that takes customers from the rolling table and puts them into the entry table with recommended stock numbers pulled from a vehicle ...
0
votes
0
answers
91
views
display custom error message returned from /validate endpoint inside marketing cloud journey builder canvas
i am validating custom activity user selected configuration inside /validate endpoint implementation, from there i want to return informative error message to be shown inside journey builder canvas so ...
- 652
0
votes
1
answer
87
views
Issue with YouTube Video Embed: Black Bars on Desktop, Correct Aspect Ratio on Mobile
I'm working on an email campaign that includes a CTA (Call to Action) directing users to a cloud page where I've embedded a YouTube video. The video displays correctly on mobile devices, maintaining ...
- 13
0
votes
0
answers
124
views
SFMC SQL string to get records which are 90 days between TODAY and a date field
I'm having issues with a SFMC SQL string which should get records that's within the next 90 days from today and my date field (Check_In_Date__c). I'm not sure what I'm missing here, but I thought ...
- 1
0
votes
0
answers
41
views
a.InsertedDate>= dateadd(hh,-1,getdate())
In salesforce marketing cloud, I have an InsertedDate field that is a date format field. The values look like this: Nov 16 2024 10:45AM. I am in eastern time zone.
I am trying to only select records ...
-1
votes
1
answer
172
views
Query Timeout error for DE with 600M records
We have a Backup log DE with Data spreading for 4yrs with around 600M records.
When i trying to Query a DE with filters like date ,status..the query fails with the timeout error. I tried to use the ...
- 1
0
votes
1
answer
53
views
SQL - how to delete duplicate on the table and keep them based on certain conditions
I'm a complete beginner when using SQL. I have a scenario where I need to delete the duplicates if it does not meet a condition below.
IF a duplicate is found, check if the subscriber key starts with ...
- 1
0
votes
1
answer
441
views
Google Promotional Annotation doesn't work in emails sent by SalesForce Marketing Cloud
I'm trying to use the notes feature in Gmails but I'm not having success. Communications are sent via the Salesforce Marketing Cloud platform and I am following documentation at the this link:
https://...
- 1
0
votes
1
answer
604
views
How do I programmatically run a query against Salesforce Marketing Cloud
I am trying to automate the extraction of data from some Data Extensions within Salesforce Marketing Cloud (formerly Exact Target).
Currently, there are queries being run from within the Query Studio (...
- 35
0
votes
1
answer
54
views
Mulesoft connection Issue - Marketing cloud
We are tyring to authenticate Marketing cloud SOAP api using Marketing cloud connector. The test connection is successful when on public network. But, when on VPN, test connection is failing with ...
1
vote
0
answers
556
views
Why is my Journey Builder 'Wait by Attribute' step sending contacts onwards before the attribute date?
I have a journey in Marketing Cloud whose basic function is to pick up subscribers who click a link in an email, hold them until a date defined by their entry source Data Extension, add a wait ...
- 13
0
votes
3
answers
89
views
Why are these two SQL queries returning different records?
I'm testing a few variations of a query to check which runs most efficiently. Most of the variations return the same number of records, but one doesn't, and I can't understand why. Can anyone help?
...
- 13
0
votes
1
answer
77
views
How to Add Multiple 3rd Party Forms to One Marketing Cloud Data Extension with AmpScript
I have been asked to figure out how to direct submissions from multiple 3rd party forms into one Marketing Cloud data extension.
I have the following built but instead of returning one record with the ...
0
votes
1
answer
74
views
Hotel Reservation Markup for Google in Salesforce Marketing Cloud
I've added Hotel Reservation Markup to a transactional emails in SFMC to display general reservation data at the top of the email for recipients. Referencing this article: https://developers.google....
0
votes
1
answer
111
views
SFMC API authenication scope
I am using the api "guide/v1/emails/preview/send" which is not list in the REST API Permission IDs and Scopes page. Does anyone know what kind of scope I can use? Thanks.
I have refer this ...
0
votes
1
answer
34
views
Upper and lower limit based on hour
I have a first date field based on utc-6 named date_utc_minus_6. I managed to create a new version of this field based on utc+1 named date_utc_1. Now what I am trying to do is to create two fields ...
- 13
1
vote
0
answers
98
views
Can I pass values in the body root instead of through inArguments with Marketing Cloud Custom Activity
We built a custom activity POST in Journey Builder. It works as designed, connects to our API and passes field:value pairs like a typical REST POST. However it works because we hard code values in the ...
- 11
0
votes
1
answer
259
views
Salesforce marketing cloud api - package manager
I have a question about marketing cloud API - is there an API for package manager. To create a package (of assets, data extensions, landing pages etc.) using the API.
I am aware of Content builder API ...
- 353
1
vote
0
answers
434
views
Can we get all the journey details using API or SSJS or Ampsctipt on a cloud page
I wanted to created a cloud page that takes journey link as input both activated and draft journeys and produce the list of configured emails and their subjects lines sender and delivery profiles and ...
- 23
5
votes
2
answers
2k
views
One-click unsubscribe is not visible on some emails with Gmail
Since Gmail will start requiring one-click-unsubscribe in 2024, we want to ensure compliance for our emails.
Our emails already have one List-Unsubscribe header field and one List-Unsubscribe-Post ...
- 51
0
votes
1
answer
841
views
salesforce marketing cloud mobile connect - sharing short codes across multiple SMS message streams
I am new to SFMC Mobile Connect and wanted some clarity on short codes.
We have a client that uses a short code for a SMS campaign - essentially directing their targets to a generic web site about ...
- 353
1
vote
0
answers
173
views
React Native Android release build crashes after integrating react-native-marketingcloudsdk
react-native-marketingcloudsdk 8.0.0
It crashes at the startup, and from Crashlytics the crash is reported as follows:
Fatal Exception: java.lang.RuntimeException
Unable to start activity ...
- 1,119
-1
votes
1
answer
136
views
Allow email address with a dot OR hyphen in the domain (HTML)
I created a form using html. I have an email address field in which i'm allowing domains containing a dot. However i can still have domains with a hyphen, a kind of "[email protected]" It's ...
- 13
0
votes
0
answers
406
views
React Native Salesforce Marketing Cloud Sdk ios App crash Error
I have integrated react-native-marketingcloudsdk with my react native project.
Android integration was successful. Foreground Notifications are working fine. But Background and quit notifications are ...
- 41
0
votes
1
answer
381
views
How do I display different HTML depending on if fields have values? (aka a loop)
I have a Data Extension with fields like Email 1, Email 2, ... , Email 10 and Phone 1, Phone 2, ... , Phone 10. Every contact will have a value for Email 1, but the rest could vary (e.g. Email 1, ...
- 1
-1
votes
1
answer
262
views
How to Extract a Substring From a String from any character position
I am facing an issue while writing a query to extract a substring from a string available in my data extension.
I have a field with data in this format {"Body":"Hi TestSFMC"}. I ...
- 1
0
votes
1
answer
475
views
Can Data Retention be applied retroactively on a Data Extension with over 100 million rows in Salesforce Marketing Cloud?
Referring the Developer Docs of SFMC, Source: Here , it mentions that performance shows degradation if rows in data extension exceed 100 million rows.
I need to know whether Data Retention can be ...
- 538
0
votes
1
answer
33
views
Getting compilation error in below Soql while checking is won = tru;e
List OppListWithClosewon = [SELECT id,IsWon,Name,Accountid FROM
Opportunity WHERE Id IN :opplist && Iswon = True];
i am not able find what is the error im making here not able filter this ...
1
vote
1
answer
733
views
crypto-js AES exchange with Marketing Cloud (AMPScript)
I'm trying to use crypto-js to manage encryption and decryption of data from Marketing Cloud (AMPScript).
I checked the lib docs and several "guides" on the web. The lib docs don't talk ...
- 3,032
0
votes
0
answers
332
views
SFMC SQL How to select 1 record
Customers Data extension
Customer_ID
1
2
3
4
5
6
Orders data extension
Customer_ID
Shipment_Type
1
A
1
A
3
C
1
B
5
E
I would like to see the following result by picking only first record of shipment ...
- 1
0
votes
1
answer
1k
views
Marketing cloud : Is it possible to find emails used in journey
I am using rest call to get journey details
https://{{TenantId}}.rest.marketingcloudapis.com/interaction/v1/interactions?name=
The response is journey json which contain activities section which has ...
0
votes
1
answer
669
views
Attempting to link GA4 Audiences to SFMC Journey Builder as an Entry Source
I am working on a project where I have come across an issue with connecting Audiences from GA4 to SFMC so I can use them in Journey Builder.
Currently my GA4 is properly linked to SFMC as we are ...
2
votes
1
answer
971
views
Retrieve Shared Data Extension records using WSProxy
I'm trying to retireve records from a shared Data Extension using WS Proxy and I always get DataExtension doesn't exist error. I'm using the below sample code.
<script runat="server">
...
- 175
0
votes
1
answer
168
views
Is there a way to get html template before Outlook renders it with additional classes?
I have a template that has been created in different platform and received it through Outlook. Trying to re-create the same Email in the Salesforce Marketing Cloud Platform, but there are a lot of ...
- 11
0
votes
1
answer
211
views
Can I save the email open time to my data extension using APM script on Salesforce?
I am sending an email to my subscriber. So when a subscriber open the email from the inbox I would like to save the email open time to the data extension using AMP script.
I am using this code:
%%[
...
-1
votes
2
answers
171
views
SQL to add quotes to a attribute inside JSON
I have a table (DE in SFMC) with the following schema
Incoming_data
Id -- Text(40)
Data_Json -- Text(4000)
The field Data_Json contains data in JSON format.
Sample data shown below
ID ...
- 1
0
votes
1
answer
614
views
Refresh Filter Data Extension
I have create one Filter Data Extension using Standard Data Extension. Now, I want to automatically refresh the filter data extension. For that I have to use script activity in Automation studio. So, ...
0
votes
1
answer
507
views
MarketingCloudSDK Crashes SwiftUI App in Beta TestFlight: "_dispatch_once"
MarketingCloudSDK Crashes SwiftUI App in Beta TestFlight
We've implemented Push Notifications through SalesForce Marketing Cloud and after some beta testing with internal testers it seems the SFMCSDK ...
0
votes
1
answer
827
views
Adding interaction studio user segment to the journey builder in SFMC with additional fields
I have linked user segment to the journey builder. But in data extension which I have used for Journey API as entry source, there I am getting only three fields from user segment.
I want first name, ...
0
votes
1
answer
466
views
Parsing response from Unirest and extracting tag value
I am calling a rest end point in Java using Unirest. The response is a JSON message which is complex and contains multiple levels inside.
I need to extract the value of a specific tag "...
0
votes
1
answer
581
views
How do I remove characters before the dot in a first name using substring and index of functions in ampscript and Salesforce Marketing Cloud?
■ If there is a name is followed with middle initial and dot, for example,
"Sara N." then remove the dot and two characters before it so that it
becomes "Sara"
■ If there are two ...
- 1
0
votes
1
answer
1k
views
Salesforce Marketing Cloud : Journey History API
I am trying to get journey history using journeyhistory end points
https://{{TenantId}}.rest.marketingcloudapis.com/interaction/v1/interactions/journeyHistory/search?$page=10&$pageSize=1000&$...
0
votes
1
answer
217
views
Marketing cloud - SOAP API ContinueRequest - Error - Missing action
I am trying to call soap api and since the number of records is more than 2500 , i have to use ContinueRequest
<?xml version="1.0" encoding="UTF-8"?>
<s:Envelope xmlns:s=&...
0
votes
0
answers
18
views
How to return the max value of a field from a subquery within the main query? [duplicate]
I am writing a query that needs to be able to return several fields, however for the fields from my [Opportunity] table i.e. [stage] & [yearid], it needs to be static relative to the max year [...
- 41
0
votes
1
answer
29
views
Update MS Dynamics 365 records with email metrics data from Salesforce Marketing Cloud
I am working on an integration project between Salesforce Marketing Cloud and MS Dynamics 365. The scope is to capture email engagment activities such as open, click and sent in SFMC and write them ...
- 1
0
votes
0
answers
252
views
SQL Max of Multiple Columns in Salesforce Marketing Cloud?
I'm looking to measure the maximum date values of multiple columns in SQL for Marketing Cloud. Unfortunately Marketing Cloud lacks the built in functions for other answers I have seen across the ...
- 1