Questions tagged [wsproxy]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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 ...
Peter Luo's user avatar
  • 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 ...
Leon's user avatar
  • 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 ...
Prash's user avatar
  • 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 ...
Mohammad's user avatar
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&...
yoni349's user avatar
  • 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":"...
zahaan's user avatar
  • 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", &...
B3G1NNER's user avatar
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. ...
Glen McMillan's user avatar
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 ...
Vishal Kumar C V's user avatar
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,...
Lukkinator's user avatar
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&...
Duc Le's user avatar
  • 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 ...
jjalbert's user avatar
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, ...
Chris Mathews's user avatar
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 ...
Aayush Kukreti's user avatar
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 ...
Chris Mathews's user avatar
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", ...
SFMC's user avatar
  • 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("...
Wilson Moreira's user avatar
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/...
user12971's user avatar
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"]; ...
user117440's user avatar
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",...
deks's user avatar
  • 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 = [&...
kuml2's user avatar
  • 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 ...
Sathish KumarSS's user avatar
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 ...
Araarso's user avatar
  • 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 ...
nerran's user avatar
  • 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 - ...
Araarso's user avatar
  • 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 ...
JimS's user avatar
  • 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 = { ...
Christopher Carswell's user avatar
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....
Denis's user avatar
  • 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 ...
Sayan Prachanda's user avatar
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&...
Marcos Felipe's user avatar
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 ...
zuzannamj's user avatar
  • 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 ...
GentSVK's user avatar
  • 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 ...
Julie Nguyen's user avatar
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 ...
Sanket kharwade's user avatar
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",...
Mike Marks's user avatar
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, ...
Eduardo Ruiz de Pascual's user avatar
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 ...
Mike Marks's user avatar
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 ...
Sanket kharwade's user avatar
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 ...
Andrew's user avatar
  • 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 ...
PSB's user avatar
  • 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&...
Julie Nguyen's user avatar
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 ...
Julie Nguyen's user avatar
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 ...
Julie Nguyen's user avatar
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&...
Eliott's user avatar
  • 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 ...
PatrickSF's user avatar
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 ...
Sanket kharwade's user avatar
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\...
Sudhir's user avatar
  • 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 ...
Matt Goldstein's user avatar
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 '...
charliefay's user avatar
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 ...
Julie Nguyen's user avatar