Questions tagged [dataextensions]
ExactTarget - A data extension is a table within the application database that contains your data.
1,207
questions
0
votes
1answer
27 views
Is there any way of retrieving all records from a data extension via REST API for Marketing Cloud?
I want to retrieve all contacts from a specific data extension via REST API but I don't find any documentation to do that.
Is there any way of retrieving all records from a data extension via REST API ...
0
votes
1answer
31 views
Send a test without being Subscriber
If I have a DE and is properly linked using SubscriberKey, when try to send a test, it says success but is not sent.
So there's no way to create a test if I have not added manually this email as an ...
0
votes
0answers
8 views
How to use SOQL to extract list of invalid emails from Data Extension imports?
I couldn't find any resource explaining this but I'm curious if the list of invalid email addresses identified during the import of records in data extensions are stored somewhere in Salesforce? ...
0
votes
1answer
25 views
How much data will maximum into the journey?. when choosing Recurring Schedule as repeat 'every daily' in 1 time
I have a problem when have 30,000 data. When choosing Recurring Schedule as repeat every daily, there are thousand data into the journey. I would like to know how much Recurring Schedule as repeat '...
0
votes
1answer
41 views
Marketing Cloud: Syncronised Data Extension Help
I am a salesforce Developer and do not work with SFMC. We lost our SFMC resource and I have been trying to gen up to cover.
We have 2 Salesforce Objects: RequestType (RT) and RequestResponse (RR). The ...
0
votes
1answer
60 views
Deleting records from Data Extensions that have no primary key without cloning Data Extension
I see in other threads, that it's not possible to delete individual records from Data Extension because, without a primary key, individual records couldn't be identified.
Question 1: Is this the ...
0
votes
1answer
29 views
Creating a new dataextension in a new folder using SSJS
I would like to write a single SSJS script that creates a new folder within the Shared Data Extensions tree, and then creates a new Shared Data Extension inside that folder.
I'm able to create the ...
0
votes
1answer
45 views
Interpret Ampscript variable saved in a data extension field value
I'm facing an issue trying to evaluate a concatampscript function and variable saved in a data extension attribute.
I tried to evaluate them with treatAsContent function but it's still not evaluated.
...
0
votes
0answers
35 views
Using SSJS to delete rows from DE's with more than 25 million rows
I have scrolled through these pages but can't seem to find a solution. Here's hoping someone can help me out :)
I am using the below SSJS in an Automation to remove rows with IsDeleted = 'True' from a ...
0
votes
1answer
26 views
Query Activity - complicated Date requirement [closed]
In my query activity WHERE clause I want to check the value of a CreatedDate. If the current day is Monday I want to bring in records where the CreatedDate is on the previous three days (preceding ...
0
votes
1answer
32 views
How do I add a field to the list of filterable attributes in Audience Builder?
My organization has a new requirement for filtering audiences, however, the field did not exist when we stood up Audience Builder. The field exists in a Synchronized Data Extension that is already ...
0
votes
2answers
25 views
How to send to a group based on graduation year [closed]
I would like to create a data extension with all of our student population. The user would then send an email to a subset of that group based on the year that the student graduated. I am hoping ...
0
votes
1answer
27 views
How to Exclude those who opened an Email from a Mobile Connect Send?
We routinely send email promos and have to follow up with an SMS to those who have not opened the email.
I know this can be done in Journey Builder with an engagement split but we can't predict which ...
0
votes
1answer
35 views
What is the max size/ limit of data extention?
We want to populate a DE using AMPscript on a landing page.
The script may entire millions of rows during a period of time.
Is there a limit to that amount of rows DE can contain?
0
votes
0answers
22 views
Safehouse File Format
I need to transfer my DE to the FTP folder.
So I use data extract (csv) - Transfer.
The format of the file in the safehouse is wrong, how do I know which format it supports, utf 8 or utf 16?
1
vote
1answer
31 views
Journey: Send Email to Sales Team using Filtered Data Extension
I have a form submission Data Extension in Marketing Cloud that creates a Filtered Data Extension to pull in a list of leads that need to alert my sales team. The filtered data extension pulls in a ...
0
votes
1answer
44 views
Send email with multiple Subscriber
I have a DE and my subscriber is present multiple times because he has multiple contracts (ContractID is the primary key).
When i send an email in a journey, the same subscriber will receive multiple ...
0
votes
1answer
32 views
SQL Activity Query - Combine Publication List to Data Extension
I have a Data Extension that contains a large amount of subscriber information for mails. As well, I have other subscribers that are stored in multiple different Publication Lists. I want to be able ...
0
votes
1answer
18 views
Extracting Email Addresses by Domains from Multiple Data Extensions?
I am trying to extract all Verizon owned email domains from existing data extensions in SFMC and placing these subscribers into a new DE that will contain only the subscribers who use a Verizon domain....
0
votes
1answer
15 views
Pull extra CRM Data into a Distributed Marketing Data Extension
I am building a Distributed Marketing Email that needs to have the senders contact information and ideally a photo. (Phone, Fax, Name, Title, Email, etc.) Is there a clean way to gather that from the ...
0
votes
0answers
8 views
Transient Error: PerformResult has OK status, but is missing a Result list
I am using the Perform endpoint to request starting ImportDefinition for an FTP CSV file.
Some highlights:
I use the CustomerKey of the Import Definition in the PerformRequest Definition tag.
I am ...
1
vote
1answer
63 views
Track DE in journey
I want to track multiple journey campaigns,
So I decided to create a DE to track subscriber logs.
My question is :
Is it better to create a DE for each journey? Or to track all logs within a DE? ...
0
votes
1answer
23 views
Merging dynamically created Data extensions in Audience Builder SFMC into a single master Data Extension to use in Journey Builder
The business needs to create multiple single DEs and then merge them using automation into a single master DE. This happens on a weekly basis
This master DE will be then used in Journey Builder.
The ...
0
votes
0answers
29 views
When do i use subscriber id in send relationship (DE)?
When I create a DE, when do I use "in send relationschip" subcriber id instead of subscriber key?
0
votes
2answers
51 views
Reference fields from DE not tied to Journey in Email Template
I have a need to pull current Mortgage Rates in to an email template in Marketing Cloud. There is daily transmission of the rates to a Data Extension via external API. Will need to display these in ...
0
votes
0answers
36 views
CRM User Data to Marketing Cloud Data Extension
I am working on a Distributed Marketing Email and when a user sends an email from the CRM I want to carry over that users Name, Email, Phone, Address, and Photo from their User Profile in the CRM to ...
0
votes
1answer
51 views
Invalid Field Count when uploading .csv file to a data extension [duplicate]
ValidationErrors:
CaseSensitiveSalesforceID: 99
Required Field: 7
Invalid Field Count: 1
I'm trying to data load a .csv files, everything matches accordingly, trying to troubleshoot what this error ...
0
votes
1answer
19 views
Data extension export problem
I want to export records from a data extension but when I am exporting the records into csv file I found out that most of the records contain unusual name like this -> Ra�l Rodr�guez Ram�rez. ...
0
votes
1answer
35 views
Send one email per unique data extension field value without de-duplicating emails
I'm trying to send one email per order number to a data extension. Data extension is set up so contact id relates to subscribers on subscriber key. No primary key. The data would look something like ...
0
votes
1answer
29 views
Push the value of button or Link to DE
Good day,
I need to create email with two buttons or links "Confirm" an "Cancel".
When user clicks on it, the Status field in DE should change its value on "Confirmed" or ...
0
votes
1answer
21 views
How to Populate a dropdown list with values into a DE using ampscript
How do I populate my form field that is a dropdown into my DE using AMPscript?
Thank you for your help!!
<div class="loc-container">
<span>Up to</span>
...
0
votes
0answers
36 views
Data Extension List Count Mismatch in UI and Api
I am trying to retrieve the list of all the Data Extensions created for a Business Unit and i am successful in it. But, the problem is there is a mismatch in the count from the API and UI. In UI I see ...
0
votes
1answer
41 views
Not able to Save the HTTPPOST2 response in the data extension
I have made a HTTPPOST2 API call and got the JSON response. I want to insert the JJSON response into Data Extension. Below is the JSON response :
{
"success": true,
"...
0
votes
1answer
28 views
Invalid Data Extension Key Field Reference
I have just started learning email studio and I need help.
I am writing personilized email. I have two DE: Contacts and Opportunities.
Trying to get data from DE Opportunities I use this code:
%%[ var ...
0
votes
0answers
17 views
Does update journey data work in a running journey?
I have an automated data extension by a SQL query. My journey has been running, and I currently overwriting the data.
The first question, I am not sure what I am doing wrong but since I started using ...
0
votes
1answer
24 views
Overwrite Rows in Data Extension using Script Activity and SSJS
I've been working for about two years within Salesforce Marketing Cloud, but haven't had the need to utilize anything outside of AMPScript, HTML, and CSS as I mostly just build and deploy emails with ...
1
vote
1answer
36 views
Counting DE records based on a specific field
Can we check DE count based on specific field in same DE?
For Example :
If Date= today()
If DE_Count > 1
set @Subject= "hello"
else
set @...
1
vote
1answer
27 views
Help understanding Primary Key Violation
We collect unsubscribe survey responses and store them in a DE. I want to run a query to combine the data from this DE with the Job and Sent data views to get a complete picture of what email the ...
0
votes
1answer
19 views
Replace function - SQL - Data Extension
I have a data extension with a column titled 'Email Name'. My reporting I have it pipe (|) delimited into a .txt file. When the 'Email Name' column comes in, some values have spaces in the front for ...
0
votes
0answers
20 views
Can we pull HTML from out site and put it into a Data Extension for ampscript in an email
I am trying to pull HTML with images, links, etc from another source (our website) and get that into a Data Extension with 1 text field. Then using ampscript I'd want to display that HTML script into ...
1
vote
0answers
25 views
Unzip file through file transfer activity
I have an automation that runs daily. It is based on a file drop when file.zip is uploaded into the import folder of the FTP. I then use a file transfer activity to unzip the file, if I am not ...
0
votes
0answers
32 views
Journey Builder - use API responses as pre-email/sms activity step checks within a Marketing Cloud journey
We're looking to implement an APP acquisition campaign, where we send the customer an initial email, followed by reminder interactions depending on how they interacted with the initial email (...
0
votes
1answer
47 views
Add ReCaptcha to SmartCapture Form in Cloud Pages
We are trying to implement Google Recaptcha v2 into our Smart Capture form within a Cloud Page. Here's what we've done so far:
Created a Data Extension
Created Cloud Pages Collection
Added Cloud ...
0
votes
0answers
15 views
SFMC - Journey Builder - custom activity - Read Data extension in UI
We are developing a custom journey activity for a client - this first for us.
As part of the configuration of the activity in the UI - the client wants us to reach out to their system using a Key to ...
0
votes
1answer
54 views
Get row identifier from DataExtension
I use an undocumented preview API to render email preview.
POST /guide/v1/emails/<emailID>/dataExtension/<DE-Key>/rows/<rowId>/preview?kind=html
To render preview I need to specify ...
0
votes
2answers
33 views
Query Account Data Extension with 2 different keys [closed]
Just ran into a little situation, where it seems the query isn't doing what it's supposed to do. I believe it blocks on the joins and then doesn't proceed to the rest. I didn't get an error, but i'll ...
0
votes
0answers
50 views
SSJS failed to process 500K records
The script activity is getting timeout while processing 500K records. I have 2 data extensions.
First data extension: Contains the 10 programs mapped to each account numbers. Account number is primary ...
0
votes
1answer
58 views
Retrieve data extension values from encrypted CloudPage URL to fill hidden Smart Capture form attribute?
I'm trying to pre-populate the hidden fields on my Smart Capture form from a CloudPage URL to gather survey responses. Here's what I've done so far:
I have an email I want to send to data extension &...
1
vote
1answer
51 views
Using DEmanager to fill Data Extensions
<html>
<body>
<form action="https://cl.exct.net/DEManager.aspx" name="subscribeForm" method="post">
<input type="hidden&...
0
votes
0answers
13 views
Smart Capture does not capture data in data extension
I am trying to set up a Cloud Pages form using a smart capture component. For that I created a data extension with the fields I need to populate. When I add them to the smart capture field and test ...
