Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [data]

All Data related Queries

2
votes
1answer
74 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
33 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
28 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 ...
1
vote
1answer
71 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
18 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
98 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
53 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
96 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
61 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
37 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
31 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
151 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
30 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
14 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
225 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
41 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
46 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
154 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
34 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
174 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
138 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
150 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 ...
1
vote
1answer
28 views

How to Display Report Table in a Third Party Web App

New to salesforce, here! I would like to display a Report from SalesForce in a third party app. It is effectively just a datatable. I've been reading various documents in the developer site but I ...
0
votes
1answer
214 views

How do I fire a lighting component function after a data load

I have a save button on a lightning component that when clicked fires a SAVE function that does validations, computations and then sets params on several diff actions that create or updates other ...
0
votes
2answers
55 views

Using Direct Mail and a CloudPage

Is it possible to use a CloudPage as an entry point for a visitor who originally receives a direct mail piece. In my scenario, I send a postcard to a Contact with an ID and a CloudPage URL. The ...
9
votes
2answers
231 views

New BUG in Winter 19: We can't turn ON Country State Picklists on fresh new Orgs (Confirmed as Know Issue by Salesforce)

We turn on Country-State-Picklists on almost every Org we touch. Assume we act on a NEW and BLANK Org, just fresh spun DE (Developer Edition) Org. But it is the same on any Org and we have tried lots ...
0
votes
1answer
29 views

How to find all Person Account records with a-z/A-Z characters in the phone number fields

Background The telephone number fields like mobile phone and home phone on the Person Account object contain descriptive words in like: 07970 123 123 (dad mobile) Question How could I get a list/...
0
votes
1answer
36 views

Get only specific values from External CSV File

I'm struggling to find out the best solution to the following scenario: I have a big static csv file containing data not related to salesforce. I would like to get a specific value on my csv file and ...
0
votes
2answers
36 views

do I need to update or insert a list, set or map in testclass

When ik create a list, set or map and add records to these do I need to update / insert after adding records. I did a test system debug on a testclass with only a return. My debug returns a list with ...
1
vote
1answer
249 views

Data Filters vs. Query Activities - discrepancy between the two

I'm noticing a discrepancy between running a data filter versus running a SQL query activity (containing the same logic). Here's my data filter: And, here's my query activity: Finally, here are ...
6
votes
2answers
347 views

What is the difference between using the LIMIT clause and using a fixed index to retrieve data from a query?

This code recover the exact same account, I thought there could be differences with the way it ask the database ... Seems not to be the way it works, So an idea ? public static void ...
1
vote
1answer
33 views

Can a CSV used in Data Loader have unused fields?

We are using the Upsert command in Salesforce Data Loader. If we have a CSV with several columns we do not wish to update (it's a wide CSV), can we still use it and just not map it? Or do all columns ...
1
vote
1answer
27 views

Data fields in Data sources but not a field in JourneyBuilder

I have added a new object and data from Salesforce to Marketing cloud in data sources and it has synced. When I go to create a new journey, the object is there but not the fields. Am I missing a step?
0
votes
0answers
32 views

any specific way to organize audience builder audience lists?

It looks like there is no option to create folders in audience builders. Can anyone share any specific way to organize audience builder audience lists? I understand that naming pattern is one way but ...
3
votes
1answer
46 views

Does field length matter much in performance

Maybe very trivial question but I don't know the answer. When I create a new field , I always think why don't I give the max length for this field? How does 20 is different from giving 100 as length. ...
0
votes
1answer
44 views

How to resolve below Dataloader error

Too many retries of batch save in the presence of Apex triggers with failures: when triggers are present partial save requires that some subset of rows save without any errors in order to avoid ...
0
votes
1answer
99 views

Retrieve data from “FeedTrackedChange” table between particular time period

I want to retrieve data from "FeedTrackedChange" table between particular time period. For Example: select * from FeedTrackedChange where CreatedTime >= jan 2000 But the problem here is there is ...
0
votes
1answer
343 views

Synchronized Data Extensions

I want to use Synchronized Data Extensions as a standard data extension but i am not able to copy data extension . I Created the same fields into the standard data extension now how can we get the ...
0
votes
0answers
14 views

Data Loader - Upsert Error [duplicate]

Why Im getting this error Attempting to update (as part of an upsert) parent field Account__c with new value XXXXXXXX, current value is XXXXXXX
0
votes
1answer
346 views

Need help with System.LimitException: Apex CPU time limit exceeded

I am receiving the following error, when trying to bulk load the customer records. Some of them are uploaded successfully, while some of them are throwing the following error. <message> ...
1
vote
1answer
38 views

Production issues handling and data sync to downstream salesforce environment

I want to know how you are handling with below business case. How are you copying production data to the downstream environment, i e test, production support etc.. ?(I have 20 plus objects with ...
1
vote
1answer
109 views

Retrieve Org's API Usage and Data Storage Programmatically?

I'm new to Programming and Salesforce. I had to retrieve the API Usage and Data Storage of the org programmatically. Is this even correct? RestRequest req = RestContext.request; String sysov = req....
1
vote
1answer
907 views

Binding (and Filtering) two listselectors independently with an Einstein Analytics Chart

Description: We are using Einstein Analytics to compare two different dates which share the same values in the same dataset. See the dataset sample image below. The dates are string fields and in the ...
0
votes
1answer
25 views

Unable to assign or populate a list into a class

I have the following classes (simplified) which I hope will convey enough information to make it clear the issue I am having. I believe the issue in the Role_Definition class where I defined a list ...
2
votes
2answers
404 views

Variance Analysis using Einstein -Wave- Analytics

Description: We are using Einstein Analytics to create more insight on products our customers have, this requires creation of Einstein Analytics dataflows, datasets, dashboards and apps. We have a ...
0
votes
0answers
31 views

Data Loader keeps AUTOMATICALLY updating Opportunity name, even though I didn't want to

I'm using data loader to update a few hundred records (opportunities), I'm moving what account the opportunities are related to. In doing so, the opp names are being automatically updated/mirrored to ...
0
votes
1answer
27 views

What to use instead of n-dimensional List in Apex?

I have the following data model: My purpose is to get all the needed data from the server-side on the client side. And I need to know: all the assessments, for each assessment I need to know ...
1
vote
2answers
35 views

Importing data from multiple external tables to a single object

I am trying to use a production SQL Server database to send relevant data into Salesforce to generate reports. Some of the data I would like to use however is not consolidated into a single database ...