Questions tagged [data]

All Data related Queries

Filter by
Sorted by
Tagged with
1
vote
0answers
20 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
31 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
8 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
47 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
18 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
44 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
57 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
12 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
62 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
28 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
24 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
23 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
29 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
16 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
76 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
39 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
67 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
32 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
40 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
26 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
45 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
166 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
85 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
30 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
340 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
42 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
376 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
170 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
167 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
152 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
62 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
338 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.
0
votes
0answers
43 views

Salesforce Web To Lead form storing strange data

I have some web to lead forms with a hard coded firstname and lastname, the records in Salesforce itself seem to randomly either be correctly showing the hard-coded fields or showing a random string ...
0
votes
0answers
15 views

How to measure responses to a content block used in multiple sends

I have a saved piece of content that I have used in dynamic content blocks in multiple emails. I want to measure the opens and clicks that the content received to see how effective it was. What's the ...
0
votes
1answer
23 views

Why two exports would be different and How to identify the differences [closed]

I have two exports. One of the activity object at the end of November. One of the activity object at the end of December. Both are the same queries and neither have date restrictions(so they ...
1
vote
1answer
560 views

UNABLE_TO_LOCK_ROW error during inserting a new Record [duplicate]

I am trying to insert new records in Salesforce using data loader, but getting the below error - Error received from salesforce.com. Fields []. Status code [UNABLE_TO_LOCK_ROW]. Message [unable to ...
1
vote
1answer
51 views

Displaying related cases Email data on visualforce Page for Big Objects Data

First of all i am very new in salesforce and not have anything to do with programming however i have been trying to finish my first project by getting help online. I have created a BIG OBJECT "...
1
vote
1answer
62 views

Marketing Cloud Business Unit - tracking data

I have a need to bring two existing Business units into one. I have all of the standard tracking data stored in them both (Linked by a parent). I would like to be able to maintain all of the data but ...
0
votes
1answer
217 views

Can not see data on VisualForce page for Big Objects data

I created a Visual force page for Big object data to be seen. However when i import data from workbench i am unable to see the full data in VF page. For some reason i can only 2 records out of 10 and ...
1
vote
1answer
46 views

Attachments extraction using dataloader

I am trying to extract all Attachments from a sandbox using Dataloader(salesforce provided inbuilt application) but I didn't find 'Attachments' object in object selection. Whereas if I do the same ...
4
votes
1answer
279 views

Best approach to implementing Contact Builder in SFMC?

What data design and modelling practices work best with Contact Builder in SFMC? From poking around in default Contact Builder DEs, I'm guessing Marketing Cloud uses Star Schema-is this correct? I've ...
0
votes
1answer
22 views

Multiply two fields if an ID is found in a separate table

Trying to create a Data Extension where we calculate the total spend in a category, if the category exists in a list of promotional categories. The point is that we want to provide an offer when a ...
0
votes
1answer
261 views

Call API FireEvents: multiple records for data extension

we are calling to this method: https://www.exacttargetapis.com/interaction/v1/events In body, raw text is this: { "ContactKey": "XXX", "EventDefinitionKey": "APIEvent-XXX", "...
0
votes
1answer
210 views

Journey Builder Entry Data Extension

I have a standard Data Extension as the entry audience of the Journey. I would like that everytime the value of a specific text field changes - the Contact will be injected into the Journey. Is it ...