Questions tagged [dataextensions]
ExactTarget - A data extension is a table within the application database that contains your data.
0
votes
1answer
65 views
AMPscript can't declare a variable
I've been trying to print the product rows from a DE in a digital receipt email. Everything works fine unless I want to declare the variables. So the code underneath works perfectly if I remove the
...
0
votes
1answer
27 views
Journey Builder API Event Entry Internal Server Error
I created a simple journey to test API events. It looks like this:
As you can see it's a very simple journey. It's supposed to be triggered by an API call, send an email and exit.
It uses a sendable ...
0
votes
1answer
19 views
Marketing Cloud SOAP API Returns Empty Response
I'm trying to send a SOAP request to the marketing cloud api so I can retrieve information from a data extension.
My current request looks like this:
<soapenv:Envelope xmlns:soapenv="http://...
5
votes
2answers
207 views
Changing the PK column of a data extension without completely recreating it
I just realized that the datatype of the PK column of my data extension should be of type Text instead of Number (otherwise I can not link it to the ContactId).
The data extension is rather big with ...
1
vote
1answer
18 views
Attribute Group definition for a simple data model of 3 Data Extensions
I am slightly confused by Trailblazers Help's definition for Attribute Groups. What I do not understand is what is the equivalent of an attribute group in a typical database management system.
...
0
votes
1answer
28 views
Update Subscriber attribute at the send time
I already discussed this with support and it seems that it is not possible to update custom Subscriber attribute when sending to a data extension.
For example:
Subscriber attribute = "favorite ...
0
votes
1answer
20 views
Rendering Image using data in my Data Extension
I have a Data Extension in which I have the path a different path for each image in the row. I am trying to pull this data in my email using an image block. How can I do it?
Should I be using image ...
0
votes
1answer
29 views
Invalid decimal on values less than zero e.g. “,5”
I am trying to import a file from the enhanced SFTP location into one of my data extensions. I have a decimal column in my DE with the length of (8,2). When I import the file I get the error
...
-1
votes
0answers
26 views
working example of custom journey builder activity to fetch data from DE
I am newbie to salesforce marketing cloud. I want to integrate journey builder with by nodejs app which is deployed on heroku and want to pass some DE values to it (for e.g. Email). How can i achieve ...
1
vote
1answer
39 views
Render Dynamic content based on data filter - AMPscript
We currently have our subscriber data sitting in the data extensions section, from there data filters have been created to segment the main audience into smaller pieces to facilitate certain send ...
0
votes
1answer
37 views
Will Update SQL In Automation Studio Remove Records That Don't Satisfy Requirement?
I am attempting to automate our payment failures to alert consumers their subscription payment hasn't processed. My initial thought was to run a SQL activity once a day and inject new records into a ...
0
votes
1answer
39 views
Manage Data Permission for Shared Data Extensions [closed]
I'm setting up permissions for shared data extensions for business units in marketing cloud. I'd like to know the details for the "manage data" permission, as opposed to view/update/delete. I've tried ...
1
vote
0answers
43 views
Recognizing random data extension by API
Is there a way to check by API which of data extension is type of 'random'? I can't retrieve by SOAP type property of data extension. Thanks for help.
0
votes
1answer
38 views
How to record customer preference from SFMC email template
I need your valuable advice to confirm about one of my problem. We have a use case where have to send a SFMC email which have a URL about some event. We would like to give the preference to customer ...
1
vote
1answer
80 views
Fill a DE thanks to SSJS in Script Activity using an external API
What I'm trying to do, is to fill a Data Extension using SSJS on weather column.
(For the test I'm using nodeJS)
Data Extension : "Weather API"
weather | city name | country code
(empty)...
2
votes
0answers
27 views
MC Attributes in Salesforce Org
I'm working on Distributed Marketing (DM).
I have created an Email Template in MC and configured with Salesforce Campaign for sending Email from Salesforce Org to the Leads/Contacts.
I have added ...
0
votes
2answers
23 views
How to get email address against email id in Job data view?
Job data view provides the status of an email if it was delivered or not but it provides only Job Id and Email Id. This email id is a numeric number and not the email address.
How to get Email ...
0
votes
1answer
52 views
Using SQL to combine Bounces, Opens, and Clicks into one DE
I currently have two SQLs pushing data into one DE. One populates Opens, and the other populates Clicks. I then combined the SQLs to an automation with the last step being to enter a journey.
The ...
0
votes
1answer
33 views
Is it possible to have a DE that houses all click-related information to be used in a journey?
I want to be able to trigger activities and journeys based on Click behaviours, but from what I understand, to do this I would need to create a SQL query, a Data Extension, automation, and a DE ...
0
votes
0answers
32 views
Contacts with multiple email addresses tied to single ID - SQL Join
We have 2 data extensions which we would like to join.
The first called "MasterContacts" has contact information, including multiple email addresses tied to one FederationID, which is present in the ...
0
votes
0answers
13 views
Unable to Create Folder under Shared Data Extension from Parent BU through SSJS Script
I am trying to create a folder dynamically under "Shared Data Extensions" in Parent Business Unit using SSJS script. But it is throwing "Error adding folder." .
Do we need to enable any special ...
-1
votes
1answer
50 views
Dynamic portion of a preference center based on data extension of child BU
Is it possible to pull in the columns based on an iterative basis? Like using the nth value?
Use Case: want to unify 90% of a pref. center across all BUs (26) but allow for BUs to have their own ...
0
votes
2answers
44 views
Dynamic Content in content builder - Profile attributes
For one of my clients I am trying to create a dynamic content block for the standard email footers. Since this client is sending emails in more then 70 languages, the desired solution is to have one ...
1
vote
0answers
71 views
Posting to data extensions from external forms
We have an external form and need to insert record from the form fields to marketing cloud data extension. Is it possible?
Can you please provide some steps?
If possible, then I need to validate ...
1
vote
1answer
27 views
Extension update ( Based on another field)
Extension Update-
I have two data extensions, Data Extension "A" and Data Extension "B". I want to add the data of Data Extension "B" to Data Extension "A".
Problem - I want to update the Data ...
1
vote
1answer
55 views
Shared Data Extension Not visible under Subscribers
I am trying to create a Shared Data Extension to use across multiple Business Units.
Documentation says to follow these steps
1.Click Subscribers.
2.Click Shared Data Extension.
3.Select the data ...
1
vote
0answers
73 views
SSJS - Read a Data Extension after an Rows.Update
i'm now in my firsts baby steps in JavaScript on Salesforce Marketing Cloud.
In my script i read one Data Extension with an DataExtension.Init("DE") and a DE.Rows.Retrieve(filter).
After this, some ...
1
vote
1answer
63 views
How can I get all the values from a column of a DE?
Having the following Data Extension named "RamiroTest", with just two columns Name and Email
How can I print only the Email column values?
This is the code I have for the moment, but it's not ...
0
votes
2answers
34 views
Salesforce Marketing Cloud API Get Data Extensions a ContactKey is in
A contact Key can be in multiple data extensions. I was wondering if there's a way to retrieve through the APIs all the data extensions a contact key is in?
EDIT: We foresee our marketers creating ...
0
votes
1answer
46 views
Variable not defined on Data Extension but able to print it in content
For parsing variables for the respective values on the email content html blocks, I usually have 2 kinds of variables.
The first case. The variable is defined on the sendable Data Extension.
The ...
0
votes
1answer
23 views
Importing data with primary key duplicates
We have a file that's dropped on the FTP regularly to update our master database, which has FEDId as its primary key. On rare occasions, the receiving file can contain a few records with identical ...
1
vote
1answer
48 views
Automation SQL or Filter Activities with MCC Synchronized Data Extension
Sales cloud and Marketing cloud are integrated using MCC. Entities have been setup under Data Sources and sendable Data Extensions are populated. In addition, the Salesforce entities are in an ...
0
votes
1answer
63 views
How to retrieve data from dataextension using fuelsdk java
I am trying to retrieve records currently contained in a data extension. I have checked the documentation but couldn't typically find out how to retrieve from the extension and examples I've found ...
1
vote
0answers
28 views
Querying data from data extension using SOAP
I am trying to extract the data in one of my data extensions. The data extension currently has one field which is the client ID.
I am using the SOAP api and following the guide located here:
https://...
1
vote
1answer
43 views
Marketing Cloud - Just trying to get record count of a Data Extension in SSJS
I followed part of the solution posted by @Gortonington here: How to improve this SSJS, but the following code does not reach the end of the DataExtension and unless I break, moreData always reads ...
1
vote
1answer
63 views
Is there a Data View of Email Content Tied to the Job Data View?
The Data View for Job has an EmailID as one of the columns. Is there a Data View for Email that can be associated with the job using that EmailID column? Documentation of Data Views doesn't have ...
1
vote
1answer
22 views
Records not being imported properly into SMS All Contacts
I've created a DE that's populated via entries on a Smart Capture form a user completes via a link in an email. The form captures the user's submission for 'MobileNumber', passes the 'ContactKey' as a ...
1
vote
1answer
43 views
Unable to access Synchronized Data Sources in the Contact Builder
I have already done the Marketing Cloud Connect setup. My issue is when I am trying to access the synchronized data sources under the contact builder, data sources, synchronized. When I have clicked ...
1
vote
2answers
40 views
Derived column in a data extension
The journey builder thats been used has entry event as DE populated with data imported from Automation studio
Can I create a Data extension column with values derived from two other columns in same ...
1
vote
0answers
25 views
How do I update record of DataExtension in Marketing Cloud (ExactTarget) and trigger a push notification if certain criteria are met?
I need to understand if this is possible to implement the following flow in Marketing Cloud.
A User opens mobile app and performs some action. A new record to custom object ( I guess to custom ...
1
vote
1answer
30 views
Lookup records in a data extension and match on mailing data extension
I'm trying to write AMPscript that will take the data extension I'm mailing to and see if a record exists in a separate data ext. If it does then write to a value on one of our tables. Here's the ...
1
vote
1answer
22 views
Enhanced Segmentation - Final send volume after exclusion
I'm busy building filtered data extensions using the new enhanced segmentation features, so that we can drag and drop segments in to our sends.
So as an example I have created 2 filtered DEs, one ...
1
vote
1answer
64 views
SQL Query Activity Data Extension Values are Case Sensitive
Are Data Extension values case sensitive when querying with SQL query activity?
I found this to be the case when querying WHERE Status = 'Active' that it ignored records with a status value of "...
0
votes
0answers
20 views
Marketing Cloud Data Relation not returning value [duplicate]
I have three Data Extensions (with the properties):
Root (Id, Name, Value)
Child (Id, Name, ValueChild, IdRoot)
Grandchild (Id, Name, ValueGrandChild, IdChild)
I made Data Relations, where:
(From ...
0
votes
1answer
21 views
Using both lists and data extensions at the same time in for email and SMS sending?
So I know this isn't the best practice but is it possible to use both lists and data extensions in marketing cloud without any complications?
Use case could be like: I use lists when I want to send ...
0
votes
2answers
61 views
Create Marketing Cloud DE Using SOAP API in Postman
I haven't been having luck with using the FuelSDKs to use the Marketing Cloud APIs. So I've been trying to test the SOAP API directly in postman first to see if it works; and sadly I haven't gotten ...
4
votes
2answers
43 views
How to find query that populated a marketing cloud data extention?
I am looking at a data extension that is appended to daily. Is there an easy way to find the query that is adding that data? There are too many folders for me to dig through to find the query with the ...
1
vote
1answer
45 views
Export from Data Extension to open in Excel columns
When doing a DE export using automation studio data extension export activity, I've exported data from a DE to a file to SFMC SFTP with tab delimitation.
I've tried as .csv and and .txt but when I ...
1
vote
1answer
29 views
Fill Subscribers Custom field with fields in a Data Extension
In Marketing Cloud, I have a custom field in Subscribers that I need to fill the value from another custom field in a Data Extension.
This Data Extension have contacts that will become subscribers, ...
2
votes
1answer
38 views
Why can I no longer access Synchronized Data Extensions folder in Data Designer?
For the past six months, when creating new attribute groups in Data Designer my team and I had the ability to access the Synchronized Data Extensions folder and simply drag and drop a synchronized ...
