Questions tagged [data]

All Data related Queries

Filter by
Sorted by
Tagged with
0
votes
1answer
36 views

Updating Accounts without the ID

What would be the most efficient way to update an excel sheet with 400 accounts that do not have an ID nor external ID of accounts that exist in the system. There are about 40,000 accounts in ...
0
votes
0answers
20 views

Uploading speed to Salesforce Marketing Cloud SFTP

Is there anyway we can increase uploading speed to Salesforce Marketing Cloud SFTP SFTP? Our data size is quite huge and with current speed (maximum 2MB/sec) it's taking quite a lot of time to upload ...
2
votes
0answers
32 views

How to Set up Contacts in Marketing Cloud to populate records from Personalization Builder Data Extension

I worked on Personalization Builder and collected data about users based on collection codes set up on a demo webpage. The data is in the Standard Personalization Builder Data Extension. IGO_PROFILES ...
0
votes
0answers
22 views

Formatting data on a lightning component without using lightningrecordform

So, I am currently working on a call out to another service outside of Salesforce. I have made the call out and am successfully returning data from the service outside Salesforce. So, my question is ...
0
votes
0answers
15 views

how to Map Production Id in sandbox without saving the Production ID in sandbox record level

I am inserting a production record to the sandbox while inserting a record I wanted to map production and sandbox records without storing the key on record level. I am facing difficulties in mapping ...
0
votes
0answers
22 views

Can we push data to salesforce from other application Using connected Application [closed]

My client is asking me to push data from other system to salesforce and they already have one connected app in salesforce. They are asking to explore the possibility using the same connected app to ...
-2
votes
0answers
21 views

Data is uploading successfully in object but is not displaying in lightning data table and the table with blank page [duplicate]

<template> <lightning-card icon-name="custom:custom19" title='Credit card information uplaod' aria-setsize="small"> <div class="slds-m-around_medium"> <...
3
votes
1answer
39 views

Using Salesforce as Single Source of Truth [closed]

From a software architecture perspective, are there major issues with using Salesforce as an application's single source of truth (as opposed to a traditional relational database like Postgres)? It ...
0
votes
1answer
19 views

Dataloader Command line error

I need to be able to run Data Loader from the command line (we need a scheduled import/export of data once per day). I created the conf file but get the error message below when I run the proccess.bat ...
0
votes
1answer
14 views

Outbound Email Message empty Attachment Related List

When sending an email, the person receiving it gets both the body text and the attachment being sent out along with it. So it sends out correctly. When I go into the activity history related list and ...
0
votes
1answer
20 views

Unravel table links

What are the relationship links (field names and any other tables used to link) between the four tables below: Account Opportunity Quote User Thanks you for any help
0
votes
0answers
32 views

How does Potential Duplicate Component and Duplicate Record Sets work?

TLDR: Can we retrieve duplicate records in 'View Duplicates' using Apex or SOQL. Details I am planning to create a list view with a column of 'View Duplicates' link or button. Similar to below image ...
1
vote
0answers
21 views

Providing a list of data to non-users securely [closed]

We have a requirement to send data to a list of people who are not users. This data is, and should be treated as, highly secure. These people are owed this data and are allowed to view it but it ...
2
votes
1answer
34 views

Trying to conserve data consumption using record Types?

So, I've been working on a Project where there is a very large volume of data that is kept and there is a relatively low amount of traffic, so it can afford more strain in terms of process/IO. I'd ...
0
votes
0answers
9 views

Salesforce CLI data tree command load Account with User lookup

I want to export and import an account record that has a custom field lookup to User table. I was able to do that with Account and Contact. But I am not able to get User- Account relationship.Is there ...
1
vote
1answer
53 views

Query to compare branches of a journey after a percentage split

I ran a journey where I used a decision split to separate the audience into 4 branches and then sent each branch the same series of emails with varying wait times in between sends. Now I want to ...
0
votes
0answers
30 views

Exceeded max length for one record data loader

How can I spot which record exceeds the limit shown by data loader when I try to insert the CSV in my 'to' salesforce environement? The same files export fine in my 'from' environment. I have tried ...
0
votes
0answers
14 views

In Classic, how can I track the productivity of my team cleaning up records?

Prereqs: Team of 6 employees @ 8/hours a day for 1-2 weeks 25,000-35,000 total records affected (Likely won't get to them all) Various issues -- missing address, missing phone number, "Unknown Last ...
0
votes
1answer
46 views

Help with the SOQL query on multiple objects

Need SOQL or SOSL query to return the Accounts Name having at least a Partner, and/or Contact and/or an Activity attached to it. So far i am able to get the account name where owner ID is '...
0
votes
0answers
16 views

how to restrict visibility of text field rows of values based on user's accountshare on a single record

I have requirement to create an alert everyday displaying list of calls submitted by users sharing same set of accounts over last 7 days. But the text field should display selective values for user ...
1
vote
1answer
133 views

Upserting records using SFDX CLI for a object with no External Id

Below are the available data related commands in CLI. If I want to insert records using SFDX CLI, how to do that? force:data:bulk:delete -- bulk delete records from a csv file force:data:bulk:...
0
votes
0answers
13 views

Migrating Quote object data between 2 SaleForce Orgs. AccountID giving error

I am attempting to migrate data (many objects) to a new SF org. I am using SQLServer as a staging area to map IDs and Talend as my ETL tool. When migrating the Quote object, I am getting an error ...
0
votes
0answers
16 views

Mask Data Based on Opportunity Team

I am wondering the approach to take on this.. The requirement is to have a certain opportunity type where the data is masked to everyone except the members of the opportunity team... We are thinking ...
0
votes
0answers
8 views

Global Report NO LONGER Global

I created a Global Report for all my users that was working just fine. In the last couple weeks, two of my users stopped getting the report. I went to log in as one of them to find out why they ...
1
vote
1answer
165 views

Marketing Cloud to s3

I have an s3 bucket I would like to transfer data to daily via automation. It currently doesn't look like there is a native way to transfer data into s3 via a file transfer activity. Has anyone had ...
1
vote
0answers
32 views

Client MID is now a PARENT MID, but Data Views do not recognize this

We recently added a BU under an existing MID, so now the MID is the "parent" to the newly created BU's MID. However, when we run a simple query and add ent. as a prefix the system does not recognize ...
0
votes
1answer
27 views

Optimal Data Load Speeds

We are currently attempting to load a large amount of data, and are currently using the BulkAPI, with chunk size of 200 and batches of 2000. Is there documentation anywhere that would outline the ...
0
votes
0answers
24 views

Customer Key Of The _PushTag Data View [duplicate]

Is there a customer key to the "_PushTag" data view? I need it for API uses and SSJS development.
0
votes
1answer
36 views

How can I update a parent record by comparing two date fields on parent and child record in Salesforce?

I have two objects namely Account Record and Purchase Record. My scenario is when I create a new Purchase record, it should check Purchase record field (Purchase.LastSODate) and update the Account ...
0
votes
0answers
18 views

Can I access the Message IDs inserted by Marketing Cloud's MTA to resolve SORBS blacklisting?

Our dedicated IP address has been blacklisted by SORBS twice now, and I'm looking to avoid repeat offenses. However, it's difficult to say what kind of behavior landed us on that blacklist. We don't ...
0
votes
1answer
388 views

Limits of API Calls to Salesforce

I want to send data daily to Salesforce. I am building a custom integration. I have tested with Postman the API Rest of Salesforce and it works well, but I have doubts the limits of integrations to ...
0
votes
0answers
9 views

How do I get my salesforce reporting snapshot to map the value from the source report to the correct object?

I am trying to map one piece of data into a new report through a data snapshot. The snapshot runs daily, and reports each day with the info I am looking for, but then additionally maps multiple blank ...
1
vote
1answer
41 views

Help with NOT in SOQL [duplicate]

I'm trying to query for records that do not contain LTD or LLP in the name and are also not assigned to a certain record type. I have tried just about every variation with parenthesis and AND/OR ...
0
votes
1answer
130 views

Access Token stopped working - Connection App problem - INVALID_SESSION_ID

I'm facing a problem with one of my Sandboxes. Today I noticed that Access Token received from Connected App doesn't work (Session expired or invalid - INVALID_SESSION_ID). It's weird because ...
1
vote
1answer
34 views

are data encrypted when it travels from Salesforce to an external system?

My question is how Salesforce encrypted data when it travels to an external system? or are not encrypted? I know that Salesforce use TLS between browser and Salesforce server, but what happen with the ...
0
votes
2answers
50 views

How can I cross-check a large csv file of email addresses against Salesforce data?

We use Salesforce Marketing Cloud and have thousands of records that don't appear to be in Salesforce. Hence, I want to delete these records so the two systems are in sync and we can save some money ...
0
votes
1answer
30 views

Why does Data Loader force a record update (last modified) with only the record ID?

I have seen this and I cannot find documentation as to why just updating with the record ID would force a record update as seen in the "Last Modified Date" field. It seem odd that "updating" the ...
1
vote
2answers
55 views

Variance Alerts for Triggered Emails - Marketing Cloud Email Studio

Within email studio we have a set of triggered emails. While we can go data extract s to see how many emails have been sent, it's often difficult to see if a the variance of a particular send from the ...
2
votes
1answer
220 views

Marketing Cloud Disaster Recovery

I have below questions for MC Data disaster recovery: What is the data backup plan for MC from Salesforce? What if the whole instance data get corrupted or MC got crashed & all data is lost, what ...
1
vote
1answer
168 views

How to Mass Update Records Without Changing the Last Modified By Field

I have a custom object that I need to do a mass update on to set a field on each to the same value. I had written a snippet of code to execute in the Developer Console that would get all the correct ...
0
votes
1answer
31 views

Restructure hierarchical data in a REST callout

I found contact data as JSON on the web that is not organized as the Contact sObject as the phone number is being stored as hierarchical data: please see https://api.androidhive.info/contacts/ for the ...
2
votes
1answer
502 views

Is there a Mobile Push _Open data view

Is there a _Open data view for mobile push equivalent to Channel email? I cannot find any https://help.salesforce.com/articleView?id=mc_as_data_views.htm&type=5 but the Mobile Push Studio tracks ...
0
votes
0answers
65 views

Move approval history to another record

We currently have an object that for many different reasons will be deprecated. We want to move the records to a new object, but also want to retain the approval history. Has anyone done this before? ...
0
votes
1answer
535 views

SFDX commands to export and import related objects

I have read everything in the documentation on how to export and import data between orgs using SFDX commands. But I am struggling to write a script which serializes all related objects. Here is the ...
2
votes
1answer
284 views

Groups vs Data Extensions in Marketing Cloud - what's the difference?

I have created a data extension and a group in marketing cloud but not sure what is the basic difference between them? Can we use group in journey builder as entry source?
0
votes
0answers
186 views

Issue upserting Account Contact Relationship - INVALID_FIELD_FOR_INSERT_UPDATE:Unable to create/update fields: AccountId

I'm upserting Account Contact Relationships the first load, works fine and we are upserting on a customer external ID field. When the upsert is run a second time - we see this error in the logs: "...
0
votes
1answer
198 views

SAQL to generate a field not in a group by statement

I'm a bit of a beginner to SAQL. I have been tasked with maintaining a fairly elaborate dashboard and data flow and have been asked to add some features to it. There is a lens that displays a chart ...
1
vote
1answer
70 views

How can we convert XML to Native Objects when the XML includes “Date” and “Time” as elements?

I'm currently trying to determine whether we can replace our company's convoluted XML processing solution (based on XPath) with one based on @SfdcFox's XmlToJson solution. Unfortunately, the XML we ...
0
votes
1answer
32 views

Configure a many-to-many relationship with one side being a fixed set of records, which may have different types [closed]

What is the best way to configure a many-to-many relationship with one side being a fixed set of records, which may have different types? I think it will be a lot easier to understand what my ...
-1
votes
1answer
448 views

Does marketing cloud have a Database or Can we access it?

Can somebody tell me that marketing cloud have any database or if yes which database MC use to store data extension or list data. Thank you in advance.