Salesforce: You can't run more than 500 reports synchronously every 60 minutes.
We have one data set that never succeeds when pulling data from Salesforce. It's based on the Quote Lines object for Salesforce CPQ. There are only around 20,000 rows in the data set which is small compared to many other Salesforce data imports that we have completed successfully.
Domo is ready, but Salesforce returned a 'FORBIDDEN' error. Details: FORBIDDEN : You can't run more than 500 reports synchronously every 60 minutes.
We have tried:
- Reducing the scope of the underlying Salesforce report
- Running the import outside of business hours
- Using different unique keys
Has anyone run into this before?
In another post, this issue simply went away, but it seems persistent for us on this particular report.
Comments
-
Have you attempted defining a custom SOQL query and pulling the data in that way instead of a report or does your use case require it to be pulled in via a report? I haven't used CPQ but I assume you can query the data using SOQL like the rest of Salesforce.
**Make sure to like any users posts that helped you and accept the ones who solved your issue.**0 -
That's a good idea. It should be accessible like any other custom object and there's nothing special about the way I've defined my report that would prevent me from doing the same in SOQL.
0 -
Not exactly a solution but hopefully a valid workaround, let me know if it works and/or if you need any help.
**Make sure to like any users posts that helped you and accept the ones who solved your issue.**0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 738 Beast Mode
- 57 App Studio
- 40 Variables
- 685 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive