Jason Hanshaw
  • Member for 4 years, 2 months
  • Last seen this week
  • Austin, TX, USA
Transactional Email API: TriggeredSend definition not enabled for this route
Accepted answer
10 votes

You cannot create a triggered send definition with the UI if you are using the Transactional Messaging API. You need to create your definition via the REST API in order for this to work.

View answer
How to populate a Data Extension with click data for the last 2 years
Accepted answer
7 votes

You'll need to use Tracking Extracts in order to obtain the data beyond the window provided in data views. For reference, your automation to pull this data should look something like this: Step 1: ...

View answer
Controlling Journey Builder custom activity exit time based on DE update completion
Accepted answer
6 votes

You should add in a decision split after your custom activity that checks whether that date is NULL in the data extension. If it is, then have a wait step (15mins - 1hr) before you rejoin the path and ...

View answer
SFMC JB Custom Activity | POST values from DE to endpoint that requires specific data set
Accepted answer
4 votes

I wouldn't go through the trouble of pushing this to a DE just so you can reformat your payload. Instead, create a save function on your client-side controller that will request the eventdefinitionkey ...

View answer
Syntax error in this IF statement?
Accepted answer
4 votes

At a first glance, I don't see anything that should be throwing a 500 error. When you are testing new functionality on a Cloudpage, it's always a good idea to wrap your scripts within a try/catch so ...

View answer
How can I relate a Journey Exit to an Email Send in Automation Studio (Marketing Cloud)?
4 votes

You can add an Update Contact activity as the last step in the journey, which will modify a data extension column to include a specific value. Just create a column in your journey entry source DE ...

View answer
Find the name of an image based on its URL in Marketing Cloud
Accepted answer
3 votes

By far, the easiest method to determine the name from the image URL is to enable Predictive File URLs. If your solution needs to account for images uploaded before the enablement of that feature, or ...

View answer
How to insert csv file record inside data extension from cloud page?
3 votes

You can't perform this action on the client-side. Since you already have this data available, why don't you post your data back to your cloud page (or another page just for processing) and then parse ...

View answer
Set a Blackout period on Triggered Send Definition?
Accepted answer
3 votes

I believe you are looking for send throttling. This should allow you to specify both the time range you want to send between as well as the volume you want to send each hour. You will need SF support ...

View answer
Not receiving email test sends
Accepted answer
3 votes

The most common reasons why this is happening are: 1) The subscriber you are sending a test against is unsubscribed. Check in All Subs to confirm their status before you test again. 2) Your email ...

View answer
Get all journey ids via API/Query?
3 votes

Yes, you can retrieve all journeys using the following REST API request: Host: https://YOUR_SUBDOMAIN.rest.marketingcloudapis.com GET /interaction/v1/interactions/ Content-Type: application/json ...

View answer
How do I get SMS Shortlink API response to be a link and not a payload?
Accepted answer
2 votes

You need to parse the JSON response and select the value that you are looking to populate. You can do this fairly easily with SSJS: <script runat="server"> Platform.Load("Core&...

View answer
WSProxy Retrieve Ordered Rows
2 votes

Since the response being returned from your call will be an array of JS objects, you could just sort the response yourself with a simple function like (sorts alphabetically): response.sort(function(a, ...

View answer
marketing cloud to Salesforce data update from a web page
Accepted answer
2 votes

The length of time it will take you to implement this is going to depend primarily on your experience and familiarity working with forms, Cloudpages and Ampscript, but it should not be a very heavy ...

View answer
Can't receive journey builder emails because error queue
2 votes

Deploying a triggered send with unhandled errors will cause those records to queue up and prevent additional ones from processing until the the queue has been cleared and the trigger has been ...

View answer
A Data Extension for Journey logs in addition to the Entry Point
Accepted answer
2 votes

You can use the Update Contact Activity in order to update a data extension based on a customer's pathway through your journey. You could use this method, for example, to identify exactly who is in a ...

View answer
Assets REST API - target specific BU/MID
2 votes

I believe you will need to authenticate into the desired Business Unit to generate an access token before processing your request. You'll just need to specify the account_id when making that auth ...

View answer
Email Activity in a Journey using Salesforce Data Entry to Personalize Content not working
Accepted answer
2 votes

When you are using Salesforce data (or any data that has field names including characters such as ":") you need wrap your attribute call in brackets. So your variable declaration should be: set @...

View answer
SSJS Email.Retrieve function not getting emails
Accepted answer
2 votes

Why don't you use the REST API for this? <script runat = "server" > Platform.Load("Core", "1"); var url = 'https://auth.exacttargetapis.com/v1/requestToken'; var contentType = 'application/json'...

View answer
Removing records with email address from sync
Accepted answer
2 votes

Trying to remove records coming from SF within Marketing Cloud is not a good idea. A much better solution is to never sync those records to begin with. To accomplish this, all that you need to do is ...

View answer
Find email address that are part of a domain exclusion data extension
2 votes

You could accomplish something like this by joining the _subscribers data view with the domain exclusions table on the users email address domain in order to find matches between the two. To identify ...

View answer
Re-Subscribing a Mobile Subscriber
2 votes

The only reliable way I've found to manage this is to never actually unsubscribe them from receiving messages. So, whenever a subscriber texts STOP, I present them with the standard STOP language but ...

View answer
How do I resolve this Marketing Cloud Journey Object Activity permissions error?
Accepted answer
1 votes

You'll need to configure your journey with a user that has been integrated with the core platform. Here's the doc on resolving the above error.

View answer
What is the use of the save/publish/validate/stop events?
1 votes

The logc that executes when those routes are called is going to depend on your application, and use-case, but they must return some response to JB. Let's say you wanted to log an event every time ...

View answer
Update a field if contacts don't exist in a data extension
1 votes

You're close, but you don't have any exclusionary criteria in your query and the DE names don't match with your description above. To filter out only those records that have a match, you'd need to use ...

View answer
Prepopulate email body when subscriber replies to an email?
1 votes

You can append both subject and body parameters to your mailto links in order to pre-populate content. Here's a simple example: <a href="mailto:example@example.com?subject=Hello%20World&...

View answer
SQL birthday reminder, leap year in Marketing cloud
1 votes

If possible, I would suggest breaking your query out into two segments that can separate leap years from non-leap years. Then, you could add a column IsLeapYear so that you can check the type in your ...

View answer
Using Python FuelSDK to manage content with the new content builder
Accepted answer
1 votes

You'll need to utilize the REST API in order to perform CRUD operations on Content Builder assets. Here are some example JSON payloads, from the documentation, on creating content using this approach. ...

View answer
SFMC JB Custom Activity | Access inArgs from activity backend to send in POST to another endpoint
Accepted answer
1 votes

Your execute logic doesn't make sense. You're attempting to make a request before you've decoded your JWT and retrieved the necessary value. At the beginning of your execute script, you should decode ...

View answer
Best way to remove/delete all contacts in Marketing Cloud?
Accepted answer
1 votes

To delete a large volume of contacts like this, you could query (or import) these records into a data extension and then call the REST API to delete all contacts within that data extension. Here's the ...

View answer