Stack Exchange Network

Stack Exchange network consists of 174 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

0
votes
0answers
21 views

What API/methods to use for bi- directional sync of organization user data? [closed]

In need to be able to push new user data to an external system and I need updates in that system to be pushed back to salesforce. Bewildered a bit here. So many APIs! What is the best way to go?
1
vote
1answer
79 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
21 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 "...
0
votes
0answers
21 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
34 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
23 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 ...
3
votes
0answers
37 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
19 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
52 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
30 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
15 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
36 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
43 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 ...
8
votes
2answers
158 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
28 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
0answers
14 views

Talend job UNKNOWN_EXCEPTION in component tSalesforceInput_5

Here are the full exception details: Exception in component tSalesforceInput_5 AxisFault faultCode: {urn:fault.partner.soap.sforce.com}UNKNOWN_EXCEPTION faultSubcode: faultString: ...
0
votes
1answer
30 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
18 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
58 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
333 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 ...
0
votes
0answers
20 views

Unable to apply dashboard filter for components

We have a old dashboard with 18 components And we had the filter setup as user role. But the filter is not applied to the components, its showing a warning is "The Filter is Invalid because not all ...
0
votes
0answers
29 views

Update field based on lookup returning an error in Data Loader and Import Wizard

We are using the Person-Account model. We have Accounts (households) with Primary Keys populated, and then we have contacts who have their own External IDs and had Accounts created for them through ...
1
vote
1answer
27 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 ...
0
votes
1answer
17 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
27 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 ...
2
votes
1answer
24 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
20 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
44 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
108 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
13 views

Is there a way to solve this problem when I leave the data out of the cols part because I have the label type as text?

Is there a way to solve this problem when I leave the data out of the cols part because I have the label type as text? ({ goInitView : function(component, event, helper, recordToDisplay, ...
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
72 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
30 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
56 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
300 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
148 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
30 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
25 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
29 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 ...
0
votes
1answer
36 views

Obtaining Values Instead of API Names when Building a DataFlow in Einstein Analytics

I am trying to build a dashboard for my company. However, in order to do that I need to create a dataset. One of the fields that I need to draw for my dataset is an object of picklist type, which ...
1
vote
1answer
55 views

Counting records by sql query and saving the all counts in one data extensions in different columns

So, I have two data extensions and I want to calculate count in 3rd data extension in each individual column. My DE 1 (included all Emails of customers) My DE 2 (included all Emails and Status of ...
0
votes
1answer
85 views

State/Country Picklist: The BillingStateCode field contains New Jersey, which isn't an available state

I am trying to migrate our production org to State/Country picklists. I followed the instructions of scanning my org in a Dev sandbox. There was no data to convert because it was a new blank sandbox, ...
1
vote
0answers
18 views

Import Activity locking file before import starts

I have created an automation that has an Import Activity from my SFTP. What we have noticed is that the automation seems to have been writing over the file prior to the automation running (it's set to ...
1
vote
1answer
38 views

Empty XML Fallback?

I'm trying to put some code that pulls in product names, but if that field is blank, I'm getting this error: XML parameter cannot be null or an empty string. Function Name: TransformXML Parameter ...
0
votes
0answers
36 views

Providing feedback to Einstein Vision using URL

I've been working with Einstein Vision and read all the documentation I can find. I am having trouble trying to provide feedback to the model using an image from an online source (Salesforce or ...
0
votes
0answers
90 views

Binding of parent data in lightning data table

I have seen Winter 18 <lightning:datatable> does not get values from a parent record I am creating the data table dynamically . Its working fine by parent record is not showing on data table . ...
0
votes
2answers
42 views

Sort by # of Opportunity Contact Roles

Is there a way for me to find out which opportunities have more than one opportunity contact roles that are primary? Unfortunately when I try to use grouping on report to do this, there are two many ...
0
votes
0answers
9 views

CSV Deletion in marketing cloud via SFTP

I have an import coming into marketing Cloud on an hourly basis via SFTP, and I am wondering if there is a way to automatically delete that csv after the import occurs, perhaps within the hour? ...
0
votes
0answers
12 views

Best way to input information on state licensing

We have a data feed that will match our leads and populate the leads state licenses for each state. So for each state, there are about multiple values, here is an example: Licensed State: {{State}}...