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
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 472 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 198 Visualize
- 254 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 176 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive