New answers tagged

1

This is not possible with any API or anything else. It is due to the basic concept of database. A primary key is used to identify a row uniquely in the data extension. If you change a value for the Primary key column it will simply insert a new record. The best way for you to achieve this is to completely remove the old rows and then insert new rows with the ...


-4

Sorry for the auto-rubber-ducking here. This IS possible and it works just the way you would expect it to given the API surface.


0

I am going to guess that the issue is that this data extension is a shared data extension which can only be accessed via the parent level context in API. Either this or it is a synchronized data extension, which cannot be written to. If it is a shared data extension, then try using a token at the parent/enterprise level of your account to do this DE upsert ...


0

The typical issue on other similar questions with this was a missing "key:" in the URL preceding the customer Key, but you have that. Can you try using the "fullyQualifiedName" of the PK field from the response? Meaning "keys": { ET_Contact_Detail.Contact External Key": "10014" }, This is a ...


0

There are many ways your can do it , A. Automation - SQL Query Ensure that your DE has subscriber Key as primary key . Execute a sql query operation on _Unsubscribe dataview and update the data extension B. WSProxy and UnsubEvent Object : Create a script activity using wsproxy and query the UnsubEvent object on eventdate. Get all unsubs from today and ...


2

I'm not a fan of DEManager. I'd recommend creating your own simple Code Resource CloudPage to consume the form data and add the row to the data extension. You'll have a lot more control and flexibility. There's an example of that in my custom preference center boilerplate (starting on line 49). Then you can just use a simple AJAX form handler on your page ...


7

You can determine a data extension's size through REST API, by its objectID: GET {{restEndpoint}}/email/v1/dataextensions/YOURDATAEXTENSIONOBJECTID/filesize Headers Content-Type:application/json Authorization: Bearer {{accessToken}} which returns the size in bytes: { "customObjectId": "YOURDATAEXTENSIONOBJECTID", "filesize": ...


1

This is not readily available information. Multiple Automation Studio activities can populate a Data Extension -- Imports, Queries, Filter Definitions, Filter Activities. There's no way to search through each Automation without using the SOAP API or (WSProxy) to build some sort of inventory.


1

I was researching this and got to thinking about it after posting the question and I stumbled upon an answer. I thought I could loop the zip codes after putting them in an array. Just as I was thinking about this someone from the Email Geeks Slack channel responded, so I figured I'd answer my own question in case someone else has a similar issue: <...


2

Why "User" Synchronized data extension is sendable? That's because it has email addresses and the User is considered as one of the sendable objects, along with Contact and Lead. https://help.salesforce.com/s/articleView?id=sf.mc_cab_contact_definition_and_count_determination.htm&type=5 As it is consuming unnecessary Marking cloud contacts ...


1

I actually wrote a blog post a while back about pretty much this exact thing. Reference here for a ton of more details on the whole process. You were right to go with Stuff, but I think the part you were missing was the FOR XML PATH part. Example of solution: SELECT a.id, emailStr = STUFF( ( SELECT ',' + b.email FROM [myDE] b WHERE a.id = b.id ...


1

We are unable to completely understand your requirement! Based on a similar project, I have tried to illustrate your requirement. Hope this helps you to implement. [If NOT at least it might help some others trying to implement similar one!. Hoping your NOT Triggering emails immediately after registration.


Top 50 recent answers are included