Salesforce Connector 2000 rows limit for reports?
Comments
-
I've come up against this problem as well. It turns out that it is Salesforce, not Domo, that is imposing the limit. (See this thread in the Salesforce Developer community). The Salesforce API will only return 2,000 records for a saved search/tabular report. It will, however, pull any number of records from the tables themselves. I've had success pulling data from tables and then recreating the report data using Dataflows like Magic ETL.
2 -
@zcameron is exactly right. I found here Salesforce's official documentation regarding this.
https://help.salesforce.com/HTViewHelpDoc?id=limits_analyticsapi.htm&language=en_US
- The API returns up to the first 2,000 report rows. You can narrow results using filters.
1 -
Any good workarounds?
ex. collect Salesforce leads with Create Date of Yesterday (assuming less than 2000 leads are created a day) and simply append it to the end of the data set already in Domo?
0 -
you can run the job more frequently (maybe every 2 or 4 hours) so the total new leads do not go over 2000 and just append them to your dataset.
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 310 Workbench
- 7 Cloud Amplifier
- 9 Federated
- 3K Transform
- 113 SQL DataFlows
- 650 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 792 Beast Mode
- 78 App Studio
- 44 Variables
- 754 Automate
- 187 Apps
- 479 APIs & Domo Developer
- 71 Workflows
- 17 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 407 Distribute
- 118 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 141 Manage
- 137 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive