Questions tagged [wsproxy]
The wsproxy tag has no usage guidance.
54
questions
1
vote
0
answers
36
views
Does WSProxy have an Upsert Batch?
I'm looking at using WSProxy in my ssjs script to upsert multiple rows into a Data Extension.
I know there's updateBatch for updating records and createBatch for inserting new records. However, I'm ...
- 138
0
votes
1
answer
29
views
Performing File Transfer Activities using ssjs
i am currently trying to create and and start Activites in Automation Studio and i am stuck at performing File Transfer activities. i made sure to preform a series of Data Extracts so that the files ...
- 3
0
votes
1
answer
49
views
Unable to update a second column value in data extension using wsproxy
I want to pull a data extension DE1 where it has two columns I used wsproxy to copy these column values to another data extension where one of the two column is encrypted and another column needs to ...
- 1
0
votes
0
answers
55
views
Custom pref center using WSProxy
I just start learning WSProxy and I'm trying to build custom preference center in SFMC for multiple publication lists so I started with 2 test publication lists test1, test2.
I use if else statement ...
- 1
0
votes
1
answer
220
views
How to batch update DE records using WSProxy?
I was able to update 1 record at a time using this code:
var prox = new Script.Util.WSProxy();
var props = [
{
"Name": "Contact_Key",
"Value&...
- 81
0
votes
0
answers
130
views
Not able to retrieve null values from nested JSON array using SSJS For loop
Here's the nested json I'm working with
{
"Instructions":{
"Instruction":[
{
"Type 1":"abc",
"Type 2":"...
- 1
0
votes
0
answers
109
views
Retrieve AccountUser List Using WS Proxy and returns no rows Found
Help, I'm new to using WS Proxy.
I'm trying to retrieve Inactive users but throws me no rows found.
Here's the code I used.
<script runat="server">
Platform.Load("Core", &...
- 1
1
vote
1
answer
311
views
Updating a Subscriber on AllSubscribers list from Unsubscribed to Active
I'm building a custom prefs centre that updates Publication Lists via WSProxy. It includes an "Unsubscribe from all emails" option that updates the status on AllSubscribers to unsubscribed. ...
0
votes
0
answers
185
views
How to clear records of Shared Data Extension using WSproxy
I am using the below script for a particular testing scenario to clear ALL [x] or a specific [y]
Data extension. However, I am unable to use this script to CLEAR records of Shared Data extension :(
I ...
- 1,905
0
votes
1
answer
105
views
Applying RowBasedRetention to existing data extension by using WSproxy or API
i'm looking for a way to automatically apply RowBasedRetention to existing data extensions, best case by using wsproxy as we are talking about quite a few.
Open to other solutions than WSproxy as well,...
- 21
0
votes
2
answers
134
views
Cannot Perform action on TriggeredSend object via WSProxy?
I'm trying to perform an action (Start, Pause, Publish) on a Triggered Send via WSProxy but with no success so far.
<script runat="server">
Platform.Load("core", "1.1&...
- 2,254
0
votes
0
answers
226
views
How to retrieve all rows from Data Extension using WSProxy
I need to retrieve all rows from a data extension to create a validateEmail API call. There are almost 400 000 users in the data extension, so I need to use WSProxy, because it allows to retrieve more ...
- 43
0
votes
1
answer
192
views
WS Proxy - create importdefinition to list
I've managed to get an ImportDefinition created with the destination object being a list in postman, but I'm struggling a bit with wsproxy, I'm getting a 500 server error. My contentJson is read ok, ...
- 174
0
votes
0
answers
154
views
How to update an Automation to set notification emails using API?
I am trying to set notification emails using WSProxy. Below is the code I am working with. Tried running this in Cloudpages as well as in a script activity in Automation Studio.
Part of the result I ...
1
vote
1
answer
129
views
Create multiple content type data folders after retrieving parent folder ID using WS Proxy
I'm trying to create a wsproxy script to create data folders in a BU for multiple content types. I'm struggling to understand how I can set the parent folder ID once I've retrieved them. I have a ...
- 174
0
votes
0
answers
73
views
How to update DE containing millions of records without primary key field
I tried updating large batch of records(millions of records), but i couldn't.What would be the mistake in this code?
var props = [
{
"Name": "JOBID",
...
- 21
1
vote
1
answer
114
views
ERROR "Unable to retrieve security descriptor for this frame." When using WSPROXY's createitem with JSON object any tips?
So, I've been testing some use cases with SSJS and got into this error "Unable to retrieve security descriptor for this frame." which occurs with the
apiAudiencia.createItem("...
- 113
2
votes
2
answers
453
views
SSJS WSProxy code is unable to access SFMC object - AutomationActivityInstance
I am trying to work on SSJS script to fetch the details about the automation activities.
I found an object called AutomationActivityInstance - https://developer.salesforce.com/docs/marketing/...
- 23
0
votes
1
answer
61
views
retrieve code snippet data via wsproxy
I am trying to retrieve the name and customer key from many content blocks like I do with data estensions
var prox1 = new Script.Util.WSProxy();
var cols1 = ["Name","CustomerKey"];
...
0
votes
1
answer
608
views
SSJS code to fetch automation details issue
I am using the below SSJS WSproxy code to extract the automation details like name, status,start time etc. to create a dashboard
<script runat="server">
Platform.Load("Core",...
- 3
0
votes
1
answer
344
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 = [&...
- 305
0
votes
1
answer
95
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
79
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 ...
- 23
0
votes
2
answers
210
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
181
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 - ...
- 23
0
votes
1
answer
179
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 ...
- 113
0
votes
1
answer
171
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,027
1
vote
1
answer
409
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
195
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
100
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
367
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 ...
- 14.2k
0
votes
1
answer
204
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
225
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
97
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
586
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",...
- 874
1
vote
1
answer
378
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
269
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 ...
- 874
1
vote
1
answer
235
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
674
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
551
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
631
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
291
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
176
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
2
votes
1
answer
824
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&...
- 163
3
votes
1
answer
221
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
624
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
1k
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
163
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
96
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 '...
- 185
1
vote
1
answer
914
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