Salsforce Connector with primary key does not work
Hi all,
I connected some reports from my Salesforce Org directly into DOMO.
When I
- use Opportunity ID (which is quite unique) as primary key, I even got wrong data in my report
- use no primary key, the data only pulls the first 2000 records
There is also the fact that our DOMO instance is set up in US and our Salesforce org is set up in EU.
Any idea what I could try to receive all and the correct data?
Thanks
Answers
-
Hi Juliane, which Salesforce connector are you using? And which data selection method?
If I solved your problem, please select "yes" above
0 -
I am using the Salesforce Advanced Connector and for the Data Selection Method, I use a Tabular Report, which is referring to a report in Salesforce.
Does this give you a hint what could be the problem?
Thanks
0 -
The 2000 row limit is a feature of the connector when no primary key is used. Have you tried an alternative primary key that would also be unique to each opportunity such as account ID? What do you mean when you say the data you are seeing returned is wrong?
If I solved your problem, please select "yes" above
0 -
Account ID would not work as it could be that we have multiple Opportunities listed under one account. So, Opportunity-ID would be ideal as this is the data element we are looking for.
When I activate the Opportunity-ID as primary key, I receive wrong data. E.g., I do have a report showing all Opportunities only for the Area UK. But when I have this report linked via the Connector with Opportunity ID as primary key, I also retrieve Data from GSA - and the Opportunies do not have the same ID within Salesforce. That's very weird, that I can see data within Domo that does not exist in the report…Any more ideas/tips?
0 -
This may mean that there are permissions in salesforce preventing you from seeing GSA data in SF but not in Domo. Not sure, but just a guess. If I were you the next thing I would try is using the regular Salesforce Connector (instead of the advanced one) and select "reports" for HOW DO YOU WANT TO SELECT YOUR SALESFORCE DATA?. This is the connector I use when bringing SF reports in to Domo. Let me know if that gives you the right results in terms of correct data, not necessarily the number of rows included. You can always filter out GSA data in a dataflow or card.
If I solved your problem, please select "yes" above
0 -
Thanks.
So, I tried "Salesforce Connector" and "Salesforce Upsert Connector".
When I check "Opportunity ID" to be used as primary key, I receive again wrong data and when I uncheck it, I receive only 2000 rows….Any other ideas how I could get all our data into DOMO and to be replaced when something changed?
Thank you very much in advance.
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 294 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 707 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive