Questions tagged [wsproxy]
The wsproxy tag has no usage guidance.
59
questions
0
votes
1
answer
50
views
Unable to perform PUT request using WSProxy
I am trying to do a PUT request. I am able to generate a token (using POST method) and am able to run this in POSTMAN and do a cURL command in the command line. I can't do it in SFMC though. I have ...
- 33
0
votes
1
answer
25
views
Why is the SSJS constructed query not updating?
I'm trying to construct a query using SSJS and update the quarry activity.
Using Core SSJS: When I'm using the variable containing the new query string, I get a smile error with now details:
Error
...
- 163
0
votes
1
answer
49
views
Data Extension Inventory script - not loading into the DE
I have this SSJS/WSProxy script that should extract all DEs over 2 years old from create date & load the DE info into "DE_Inventory_list" DE. No errors but would not load the list of DEs ...
- 23
3
votes
0
answers
95
views
SFMC WSProxy / API: Is there a way to determine which BUs have access to a Shared or Synchronized DE folder?
I'm working on an automated setup backup of synchronized data extensions in an multi-org account. There are multiple connections present and different business units have synchronized data extensions ...
- 3,401
-1
votes
1
answer
64
views
Automation data into data extention
I found a script for retrieving automation data on https://www.ssjsdocs.xyz/automation-studio/automations/retrieve/all.html. I still learning SSJS and can't figure out how to store this kind of ...
- 143
0
votes
1
answer
310
views
Retrieve with ws proxy with filter using DateValue does not work
Hello dear sfmc people,
using date field in filter does not work as it's stated in the documentation
https://developer.salesforce.com/docs/marketing/marketing-cloud/guide/simplefilterpart.html
I have ...
- 148
0
votes
1
answer
175
views
Get MID from CloudpagesURL()
I am trying to create an unsubscribe page at the parent BU level for multiple child BUs. I want to use impersonatation with WSProxy in order to log the unsubscribe at the right BU, to do that I need ...
- 180
1
vote
0
answers
225
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 ...
- 150
0
votes
1
answer
313
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
85
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
1
vote
1
answer
785
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&...
- 163
0
votes
0
answers
162
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
217
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", &...
- 11
1
vote
1
answer
1k
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
362
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 ...
- 2,003
0
votes
1
answer
160
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
187
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&...
- 3,710
0
votes
0
answers
410
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
372
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
1
vote
1
answer
185
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
98
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
144
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
736
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
111
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
866
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
623
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 = [&...
- 353
0
votes
1
answer
122
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
124
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
316
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
263
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
237
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
233
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,047
1
vote
1
answer
656
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
289
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
113
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
513
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.4k
0
votes
1
answer
254
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 ...
- 148
1
vote
1
answer
297
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 ...
- 159
0
votes
0
answers
104
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 ...
2
votes
1
answer
809
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",...
- 884
1
vote
1
answer
549
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
429
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 ...
- 884
1
vote
1
answer
322
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
876
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
3
answers
829
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
1
vote
1
answer
842
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&...
- 159
1
vote
1
answer
453
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 ...
- 159
0
votes
0
answers
202
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 ...
- 159
2
votes
1
answer
1k
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&...
- 173
3
votes
1
answer
265
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