Questions tagged [wsproxy]
The wsproxy tag has no usage guidance.
36
questions
0
votes
1
answer
22
views
Performing a record retrieval via WSProxy in SSJS
In my data extension, I have two fields / columns:
JobID
DE_NAME
In this use case i want to receive the value for JobID and DE_NAME (1st row only)
var queryAllAccounts = true;
var cols = [&...
- 109
0
votes
1
answer
32
views
Is it possible to call DataExtractActivity using WSProxy by using CustomerKey? If not , is it possible to get ObjectId of DataExtractActivity? [duplicate]
Is it possible to call DataExtractActivity using WSProxy by using CustomerKey? If not , is it possible to get ObjectId of CustomerExtract?
Using a Script activity I want to call the ...
0
votes
1
answer
47
views
Cannot Retrieve Data Extensions' folder Name when running script for the entire enterprise
For a set of specific Business units, I am trying to retrieve Data extensions older than 92 days (using ModifiedDate) and load them into another DE. And, I would like to retrieve these fields: DE ...
0
votes
0
answers
31
views
Need to copy entire automation in Automation Studio via Script
I have gone through many posts and Salesforce documentations however I am unable to find any script / API which can help to copy entire Automation via either SSJS or WSProxy or REST API.
I am also ...
0
votes
2
answers
38
views
Create a text-only email programmatically in Marketing Cloud
Hi Marketing Cloud gurus,
Does anyone know how to create a text-only email programmatically?
I am building an application in a Cloudpage (so users don't have to login into SFMC and the initial step is ...
- 5
0
votes
1
answer
54
views
Moving over 2000+ old Data Extensions to new folder for review/delete
I am trying to move multiple old DEs into a new folder. And, with my limited experience with SFMC Objects & WSProxy/SSJS, I dug deep into multiple resources & samples codes like (Zuzanna - ...
0
votes
0
answers
28
views
APIProperty PartnerProperties for Activities Object
I would be so grateful if someone can help me with the below issue.
I am trying to retrieve a list of all automations with Activities and activity types using the Retrieve function from Marketing ...
0
votes
1
answer
47
views
Testing retrieving Automation Statuses in Batches. Error looping through results
I'm building an automation to retrieve the latest statuses for a number of specified automation instances. The flow is something like run SJSS to retrieve all statuses for the automation instance and ...
- 103
0
votes
1
answer
58
views
WSProxy Data Extension AddOnly bug
I'm trying the following code:
Platform.Load("Core", "1");
var prox = new Script.Util.WSProxy();
function addDE(DEKey) {
var updateObject = {
...
1
vote
0
answers
84
views
How to create a Triggered Send Definition using SSJS?
I want to create a triggered send definition using SFMC SSJS. This should be possible using either the TriggeredSend Platform object's Add method or via WSProxy. However, I can not get either to work....
- 11
0
votes
1
answer
58
views
Does WSProxy Calls consume SFMC API limits?
We have a use-case where we have to find out all the Data extensions present in a Business unit. We can achieve this by using the WSProxy Retrieve option or SSJS RetrieveRequest approach. As the ...
0
votes
0
answers
47
views
I want to retrieve records from a List and update a DE, what's wrong with my code?
I tried retrieve the records from my list and then try "updateitem" with Data Extension inside
but it's not working
<script runat="server">
Platform.Load("core&...
1
vote
2
answers
117
views
Creating a DE with retention using WSProxy (Data Extension Manage Data Retention user permission error)
While trying to create a Data Extension with data retention using WSProxy, I am getting the following error:
The Data Extension Manage Data Retention user permission must be set
in order to use the ...
- 10.4k
0
votes
1
answer
85
views
Rename columns in Data Extensions programmatically
Is there a way to rename column names with WSProxy or another SSJS method in DEs? Columns have data in there so I cannot remove and add again.
EDIT:
I get this in error message when using WSProxy to ...
- 111
1
vote
1
answer
96
views
WSProxy HTTP POST Request only runs a handful of records at a time before erroring and pausing
I'm leveraging SSJS WSProxy's HTTP Request to send a payload over to a third-party server. The payload is essentially a data extension's information that is being looped over until all records are ...
- 149
0
votes
0
answers
71
views
Script activity not pausing and deleting the TS
I am trying to Pause and Delete the Triggered sends present in out account which were created/used before 3 years. Below code works fine in a CloudPage but does not perform any action when using it in ...
1
vote
1
answer
183
views
Retrieving data extension data from a WSProxy retrieve
I'm drawing a total blank. I have the following code to retrieve data from a data extension:
<script type="text/javascript" runat="server">
Platform.Load("Core",...
- 839
1
vote
1
answer
129
views
Getting Interactions with WSProxy
I need to retrieve the info of the active journeys via API.
I've been trying to get it with the Retrieve method of WSProxy but I cannot find the correct object for it.
I've tried: Interaction, ...
2
votes
1
answer
126
views
Using WSProxy to retrieve a list of automations that do not have the "On Error" recipient set
Here's the code that I have (below). I'm trying to find out how I can retrieve a list of automations that do not have an "Error" notification recipient set. I did find the API field name ...
- 839
1
vote
1
answer
84
views
Fetch data combining SOAP and REST API
I am trying to fetch all Triggered sends in our account and associated emails (email name) used in triggered send but unable to do so.
Issue being triggeredsendDefinition is fetched thru SOAP or ...
1
vote
1
answer
245
views
How to correctly read response from a WSProxy call to retrieve DE rows (more than 2500 using HasMoreRows) and update All Subs List
I have a Data Extension holding 80,000 rows of USA customer data.
Within the DE is a field named "Country_Code" which sets a default value of "US" for everyone.
My All subs list ...
- 11
0
votes
2
answers
124
views
ImportDefinition File Name
Is it possible to get the exact filename from an import definition? My Code
<script runat=“server”>
Platform.Load(“Core”,“1”);
var api = new Script.Util.WSProxy();
try {
var ...
- 27
0
votes
1
answer
180
views
Looping through wsproxy retrieve results with SSJS
I'm trying to loop through all folders found in the parent folder and show the folder names. This is what I have so far but it doesn't work (I just get an error page)
<script runat="server&...
- 149
1
vote
1
answer
94
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 ...
- 149
0
votes
0
answers
83
views
SSJS Triggered Send not working
I tried to strip this back as simple as possible using WSProxy to conduct the triggered send. I tested this in Cloud Pages, and I just get the loading screen when I click Publish to preview. I also ...
- 149
1
vote
1
answer
289
views
Extracting ObjectID of an Automation
I am not sure what I have done wrong but I am not able to extract the ObjectID of an Automation.
Here is my code
var prox1 = new Script.Util.WSProxy();
var cols = [ "Name", "ObjectID&...
- 141
3
votes
1
answer
113
views
WSProxy - is it possible to move categories / automations?
With the new year I am trying to create a fresh start by cleaning up old folders and files from our MID. It's quite a tedious job to move folders and files manually within automation studio. I am ...
- 63
1
vote
0
answers
292
views
Retrieve Business Units and add to data extension SSJS
I have the following SSJS function which uses WSProxy to return an array of all business units, however, when I test the script in a CloudPage, it returns an error.
I'm hoping someone can take a look ...
0
votes
1
answer
557
views
Bulk delete rows from Data Extension using WSProxy
I am looking to delete rows from "ProxyTest22" data extension and trying to achieve this through WSProxy as the number of rows are in millions. I keep getting Error executing delete call.\r\...
- 3
1
vote
1
answer
76
views
Is there a WSProxy equivalent of the SQL "SELECT * "?
I am curious if there is a way, specifically in WSProxy, to select all data that is associated with an object without individually identifying each column.
For instance, instead of
var prox = new ...
- 117
0
votes
0
answers
63
views
API: SenderProfile Object - What is the DataType "TriggeredSendDefinition"?
Documentation Link: https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-apis.meta/mc-apis/senderprofile.htm
If you look at the above documentation link, 'AutoForwardTriggeredSend' and '...
- 125
1
vote
1
answer
428
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 ...
- 149
1
vote
1
answer
102
views
Obtain publishedURL via WSProxy
I'm trying to obtain the publishedUrl of every CloudPage published.
With this script:
<script runat="server">
// Load the Core Library
Platform.Load("core", "...
- 11
0
votes
1
answer
65
views
Display email name associated with a TriggeredSendDefinition via WSProxy on a Cloud Page
I want to retrieve the email name associated with a triggered send definition via WSProxy on a Cloud Page. To be clear, I'm not trying to retrieve the name of the Triggered Send Definition, rather the ...
- 171
1
vote
2
answers
508
views
Retrieve Ordered Automation Rows in WSProxy Retrieve
I've written a script with WSProxy that retrieves all Automations (Programs) in a Marketing Cloud business unit. Then, I retrieve all runs (AutomationInstance) of that automation and get the status of ...
- 165
0
votes
1
answer
216
views
WSProxy Retrieve Ordered Rows
There is a way to return ordered rows from a Data Extension when making a retrieve request using WSProxy?
Something like a LookupOrderedRows, but with SSJS WSProxy.
- 454