Questions tagged [data]
All Data related Queries
529
questions
-1
votes
0
answers
11
views
Recipe dataset error
I trying to run my recipe, but error has occured.
I want to know why these error happened and where can i check error category of dataset.
In this case, I should delete the field (scouts_lat....
0
votes
1
answer
54
views
i want to export 3.4 TB size of files and attachements from salesforce
i want to export 3.4 TB size of files and attachements from salesforce,
*I tried to extract the files and attachements using data export module in salesforce but now its running for 3 weeks and no ...
0
votes
0
answers
41
views
Arbitrarily splitting an Address
This is a bit of a weird one, but due to a limitation with the Bringg/Zenkraft integration, Shipments cannot be created if either address line 1 or address line 2 > 35 characters. The issue is that ...
- 1
0
votes
1
answer
41
views
Unsubscribe user with one subscriber key but many email addresses
I have one user with one subscriber key but with different email addresses in a data extension. If I send through Journey builder, I can target all the email addresses by setting the field in "...
- 21
-1
votes
0
answers
40
views
Is there a way to automatically delete records from an entry data extension after the journey has been executed?
We have a DE which is updated periodically from Data Cloud. It contains records of users which have a service hired with us. Each month this list changes, as some users unsubscribe from the service ...
- 1
0
votes
0
answers
37
views
Maintaining a standard set of data in centralised place and used by one or more salesforce orgs
I have a requirement to use a standard set of data that is the same for every Salesforce org.
The standard data is huge in size and rarely changes. However, each customer has their own dedicated org ...
- 101
0
votes
1
answer
40
views
How to Begin Large Data Analysis in Org?
I'm a new admin and tasked with performance an analysis to address large data volumes. I'm hoping for some direction on where to begin.
How do I tell if there are current issues due to large data?
...
- 1
1
vote
1
answer
39
views
Backend SFMC not available in Data Views
A previous employee was able to insert a number of SFMC tables into SSMS, but I do not see how he did it.
Tables like Account, AccountUser, Business Unit, etc. are not data views available in SFMC. ...
-1
votes
1
answer
20
views
Existing data duplication clean up help
I'm trying to de-duplicate existing data in SF. I've created and activated matching rules and duplicate rules and checked off reports, yet there is nothing on the "Duplicate Contact Records",...
- 1
0
votes
1
answer
32
views
Get a mapping of External Ids and Salesforce Ids when migrating data from simple-salesforce
I want to migrate Account data into Salesforce and create a lookup table containing Salesforce IDs and External IDs.
I am using the simple-salesforce library to perform a bulk insert of Accounts into ...
0
votes
0
answers
27
views
Monitor Data Consistency of the org
I'd like to set up a control over our data to make sure that our data in the org is correct and if not - know about it before the users reach out to us.
The way I see it - I'd like to have a tool that ...
- 1,041
0
votes
1
answer
148
views
Data Cloud permission sets are not visible on new developer org
I can't assign permission sets to my user cause there are no permission sets related to Data Cloud from Trailhead.
0
votes
1
answer
74
views
SOQL query to find Tasks by Subject and Count
We are trying to find tasks of the same Subject that occupy a lot of records. For example, there might be 4,000 tasks all titled "Opportunity closing in 3 days" and we want to find all ...
0
votes
0
answers
48
views
Can CumulusCI Migrate Files?
I'm using CumulusCI to automate org setup, deployment and data migration. This is all working great but I have run into a problem using the tool to migrate files.
Is this a known limitation of ...
-1
votes
1
answer
81
views
Using a Salesforce Data Extension as an entry source in Journey Builder
I have a Salesforce Data Extension in Marketing Cloud that is filtering through people with a specific name.
When I add someone with that name to my list they get picked up by that data extension.
How ...
- 1
0
votes
0
answers
52
views
Can Tableau data be passed into Salesforce?
We are pulling data from multiple sources into Tableau and would like to leverage the salesforce and tableau integration to push data back info our Salesforce account records. Is that possible? And ...
0
votes
0
answers
63
views
SQL Query Not quite working - Unengaged Contacts
I'm using SSMS and trying to identify contacts that have received 10 or more emails in the past 1 year and have not clicked or open any. When I run the query, some contacts fit the parameters, but I ...
0
votes
0
answers
25
views
mobile push extract problem
Currently we are trying to obtain the detailed mobile push data from the last 24 hours daily but the Mobile Push Detail Extract report only provides: Rolling range from 1 day which captures 12AM to 12 ...
- 1
-2
votes
2
answers
55
views
How can one copy account data from one org to another without errors? Is it possible to do so without mapping all fields?
How can this upload be done without mapping all the fields from source instance? Is it possible to do so without any errors?
- 11
-1
votes
1
answer
23
views
Insert user email logged into a site within a screen flow
I have created a screen flow with a form within a site with salesforce, I would like to automatically take the email of the logged in user so as to insert it automatically when I create a new record, ...
- 1
0
votes
0
answers
2k
views
Workbench Data Updates
I am attempting to update some records in my org using Workbench which i do very often. Today when i go in and select account, and upload my csv, i keep getting the following error. This is a small ...
- 21
1
vote
1
answer
78
views
Extracting data from Salesforce using SystemModStamp
I am looking at pulling data from Salesforce incrementally using the "systemmodstamp" field into a "data lake". The plan is to use the max(systemmodstamp) in the datalake, as the ...
- 113
-1
votes
1
answer
125
views
Storing a table with multiple value data in custom metadata types
I have a table with two columns. One column is a role and the other are keywords associated with that role. For example:
Roles
Keywords
Admin
Desk, Forms, Data Entry
HR
People, Communication
What ...
- 133
0
votes
0
answers
38
views
customized report marketing cloud
I'm new to the marketing cloud and I want to create a custom report using data views within an activity in the automation studio. My objective is to automate the process because currently the data ...
-1
votes
1
answer
133
views
Data Import Wizard overwriting Account Names
I have about 1600 contacts that I need to bulk import into Salesforce. Some of the contacts already exist in Salesforce and are assigned to Accounts. For the existing ones I just need to check a ...
- 1
0
votes
2
answers
252
views
Cannot read properties of undefined (reading 'data') when implementing LWC
<template>
<lightning-card title="filters" icon-name="standard:calibration">
<div class="slds-m-horizontal_medium">
<lightning-input ...
-1
votes
1
answer
225
views
How to load more than 255 chars data in Text Area as seperate line
How to load more than 255 chars data in Text Area as seperate line when pushing data from Mule soft is there any line break can we add
- 1
-1
votes
2
answers
289
views
How to import data with a mapping to custom address field?
I have made a custom object which has various fields, out of which one is a custom address field. Now, as per documentation Data Import Wizard does not support the custom address field. So what are ...
-2
votes
1
answer
600
views
Help with Connections issues in the Data Manager for Analytics Studio
I would like to know why the connection to an object does not allow me to see ALL the Fields?
I have another ORG with the same Object and it allows me to add more Fields although some are still ...
1
vote
4
answers
10k
views
Data loader CSV Error: Can't read from CSV file
I am attempting to load using Dataloader and I am running into a "CSV Error: Can't Read from CSV file" on every attempt.
Originally I successfully loaded some data without any error but now ...
- 41
0
votes
1
answer
95
views
query received same email multiple times
I have a data issue where we have duplicate emails under different Subscriberkey.
I'm trying to build a query now to check how many of this duplicate emails have received the same email multiple times....
- 457
0
votes
0
answers
54
views
What is the possbile reasons for a record in AccountShare Object disappeared suddenly?
Just found some records in my AccountShare Object disappeared suddenly.
All related objects(Accounts,group,etc),batchs and tables are checked and nothings has changed.
row casue remained unchanged too....
- 1
0
votes
1
answer
45
views
Why is the concurrent API limit not present in the Limits data end point?
Looking at https://developer.salesforce.com/docs/atlas.en-us.api_rest.meta/api_rest/resources_limits.htm, I am not able to associate anything with the Concurrent API requests.
Why is this limit not ...
- 246
0
votes
1
answer
138
views
Getting the First Value of Assigned to (Lookup )
Would it be possible to capture the First Value of the "Assigned to" field(Task Object; Lookup Field) by creating a formula field in Activity Object named "Sample".
Lets say, the &...
0
votes
1
answer
498
views
LAST_N_DAYS is not working as expected in SOQL query
I am running an SOQL query to get 10th, 30th and 60th days before created records to notify users to take action. I wrote a query using LAST_N_DAYS:10 OR LAST_N_DAYS:30 in WHERE condition, but the ...
- 183
1
vote
0
answers
81
views
Data extention REST API fails during inserting
Lets say we've got followed code
var createDE = createDE(dataExtensionName,fieldNamesArray);
// TODO check for correct response value
if(createDE.Status == "OK")
{
var deObjectID = ...
- 839
-1
votes
1
answer
161
views
Manually delete GroupMember Record
Would I be shooting myself in the foot if I manually deleted a single record from the GroupMember object that links an inactive user to a queue? Is there something that happens when you do it via the ...
- 133
1
vote
0
answers
98
views
Translation of formula field code into SQL
I am building a DWH and am currently working on our Salesforce data extractions. In order to improve data quality I would like to extract the formulas from custom fields and translate them into SQL ...
- 11
0
votes
0
answers
21
views
Get Geocodes using Address field Beta
I was wondering if salesforce's 'new' Beta custom fields can get geo coding?
After enabling the Custom Fields on the user interface we can get the Same functionality as the address fields on account ...
- 96
0
votes
1
answer
395
views
Running Apex in parallel
I have an Apex REST webservice that creates a contact and a community user when being called with some input data (username, email etc.).
I need to import about 20k users. I want to save processing ...
- 644
0
votes
0
answers
152
views
Unexpected token 'Boolean'
Hey guys I'm new to Apex and even pretty new to Java, It's probably a stupid mistake but I can't figure it out. I am getting "Unexpected token 'boolean'." error , tried with both Boolean and ...
- 3
1
vote
1
answer
191
views
Special Characters breaking Apex Loop
I have code that is being uploaded as a CSV that is breaking if special characters are present i.e:
comma ,
Apostrophe '
à
I have built docs that has them remove these but the one I am not sure how ...
0
votes
2
answers
128
views
Marketing Cloud - Create a Data Extension by filtering out Subscribers
big Marketing Cloud Noob here!
I have inherited the admin Role in the Company in Marketing Cloud and I cannot make ends meet.
My Company regularly sends emails to their subscribers and professionals ...
0
votes
2
answers
527
views
Inspector Update Data Unexpected Token
I am trying to insert the data from an excel sheet which I previously exported. I just merged two fields together. I keep getting the error message unexpected token. So I tried to not insert the whole ...
- 1
0
votes
0
answers
120
views
Data Extension masking in marketing cloud
I am trying to mask Data Extension records followed by PERSONAL INFORMATION PROTECTION ACT (Korea regulations). In this case, I need to mask as below;
For example,
Customer Name: John -> J**n
...
- 1
0
votes
1
answer
24
views
Turning off Visual Flows through CCI
I would like to load large datasets using Snowfakery and CCI into a testing environment. There are some flows in the org that fail and prevent the data from getting loaded. What I am trying to figure ...
0
votes
1
answer
491
views
To seed the data from production into the developer sandbox using SandboxPostCopy interface
I don't have much experience in the creation of sandboxes. I have a requirement to seed some data from Prod into the sandbox using SandboxPostCopy interface. Is there any way I can do that using SOQL'...
- 429
0
votes
0
answers
240
views
Is it possible to perform validation of data in data extensions in SFMC automatically?
Currently, we have a ton of AdHoc (one-time emails) each month and for each email:
the email creative is different
audience list and DE fields are different
So, every time we get the list imported ...
- 317
0
votes
1
answer
2k
views
LWC - Perform Data validation on Table upon entering value on Table column and populate other columns
In one of my requirements I am having a empty table with just one blank row having some 5 columns. I can enter new record/data on the rows.
On one particular column, when the user enters the data on ...
0
votes
0
answers
14
views
Trigger Email from Marketing cloud when a record is added manually to DE [duplicate]
Built a DE and template and configured Trigger Send by selecting both respective DE and template.
I have activated the TSD, when I manually added a record in DE under Contact builder. the TSD did not ...
- 17