Skip to main content
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
Results tagged with
Search options not deleted user 61872

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 …
Julie Nguyen's user avatar
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 …
Julie Nguyen's user avatar
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 …
Julie Nguyen's user avatar
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 …
Julie Nguyen's user avatar
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 …
Julie Nguyen's user avatar
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 …
Julie Nguyen's user avatar
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 …
Julie Nguyen's user avatar
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 …
Julie Nguyen's user avatar
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 …
Julie Nguyen's user avatar
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 …
Julie Nguyen's user avatar
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 …
Julie Nguyen's user avatar
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 …
Julie Nguyen's user avatar
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 …
Julie Nguyen's user avatar
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 …
Julie Nguyen's user avatar
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 …
Julie Nguyen's user avatar

15 30 50 per page