Search Results
Search type | Search syntax |
---|---|
Tags | [tag] |
Exact | "words here" |
Author |
user:1234 user:me (yours) |
Score |
score:3 (3+) score:0 (none) |
Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
Views | views:250 |
Code | code:"if (foo != bar)" |
Sections |
title:apples body:"apples oranges" |
URL | url:"*.example.com" |
Saves | in:saves |
Status |
closed:yes duplicate:no migrated:no wiki:no |
Types |
is:question is:answer |
Exclude |
-[tag] -apples |
For more details on advanced search visit our help page |
The Salesforce Marketing Cloud is the leading 1:1 digital marketing platform, connecting companies with customers in entirely new ways. Platform APIs and SDKs enable developers to manage and automate marketing campaigns and extend the Marketing Cloud with integrated apps and app extensions.
0
votes
2
answers
598
views
SFMC - Is it possible to pull the entire data structure?
I'm working with an instance that has what I'll be estimating about 300 DEs, with 80% of the DEs not being used.
I'm curious to hear if anyone had mapped out every single DE, along with it's folder p …
1
vote
1
answer
1k
views
SFMC Activity Record for Sent exists, and a related Click Activity Exists, but no Open Activity
I'm conducting reporting and I'm finding that there a few thousand records that have a click activity but no correlated open event.
I'm matching based on jobid, batchid, subscriberkey for _Sent, _Open …
0
votes
1
answer
201
views
Ampscript not displaying field because of '<' character?
I've set up a rowset and I'm defining a field, all the other fields are rendering fine, except one field and I suspect it is because the values start with '<' and end with '>'.
The value of this field …
1
vote
1
answer
137
views
Is there a limit to the amount of times I can start an Automation via SOAP API?
I was able to successfully run this call once, but I'm not seeing it actually run in SFMC again after that.
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www …
0
votes
0
answers
32
views
Split a string on delimiter with SQL in SFMC [duplicate]
I've got a table of 8 million+ records in SFMC with one column called "AllData" and records that look like this:
D||John Smith|EML|[email protected]|Y|2014/10/22 10:15:08.000000|
I'm not looking t …
0
votes
1
answer
211
views
Can't display child elements of ParseJSON in SSJS
I'm trying to extract data and present it in a readable format (testing this out with a public API)
<script runat="server">
Platform.Load("Core","1.1.5");
var url="https://api.nasa.gov/planetary/a …
2
votes
1
answer
745
views
Possible to filter REST API Queries endpoint?
I'm doing a spot check right now to see if any queries are using a specific DE. What qualifies as using a specific DE is if they mention my target DE's name in a query, or the query saves to that targ …
0
votes
1
answer
689
views
SFMC SQL Query not ordering decimal values correctly [closed]
I'm trying to order a record so that the latest date, and the highest value populate first and then decrease in a descending order.
This is what I've written:
SELECT contact__c,
Ind_Assets_Reta …
0
votes
0
answers
264
views
Can't Access Child JSON Element of JSON Payload with SSJS
I've got this script up, I intentionally replaced some parts of the code with a series of Xs to censor any secure information.
<script runat="server" type="text/javascript">
Platform.Load("core", "1.1 …
1
vote
0
answers
33
views
API Time is converted in a weird way in SFMC
There is an external API connecting to a SFMC DE.
I've got a DE set up with a date/time field
Here's an example of a snippet of our payload coming through
[
{
"Transaction_Start_DateTime":"2020 …
0
votes
1
answer
387
views
How to delete rows from DE based on another DE
I'm a bit new to SSJS so I'm having trouble understanding how I would go about this.
I've started by referencing this: https://sprignaturemoves.com/prune-rows-data-extension-ssjs/
I created two Data E …
0
votes
1
answer
440
views
How to select last order on SF Marketing Cloud?
I have a database consisting of over 1 million orders, I'm looking to select the last order (indicated by OrderDate) for a customer (indicated as CustomerID).
Here's what I've tried so far:
SELECT
…
1
vote
1
answer
461
views
Trying to lookup Folder ID when there are multiple folders sharing the same name (SFMC WSProxy)
I have this scenario right now where I'm coding a cloud page form with SSJS right now (I'm a bit of a noob at this) and the basic functionality is:
-Create data extensions automatically when form sub …
1
vote
1
answer
641
views
SFMC Dynamic Timezone Sends
Timezones are a concept I have a hard time wrapping my head around. I'm trying to build a dynamic timezone program that runs an adjusted sendtime on a daily basis.
Everyone should be receiving an emai …
1
vote
1
answer
1k
views
How to batch delete more than 2500 records (based on data extension)
I'm looking to remove refunded transactions from the master transaction table (they have two ID where they join on) so that we don't email people about their transactions when they have already receiv …