10k ft connector - limiting time entry approvals returned

We use the Domo 10k ft connector and it's very helpful for more advanced forecasting and audits than we can do out of the box with 10,000ft. One of our audit reports is for time entries missing approvals and we use the standard report from the connector: "Time Expense Approvals". Unfortunately, that report does not allow a date range (either specific or relative) in settings. So I think it's trying to pull years of data. It's always only succeeded ~60% of the time and recently it's almost never successful.
Is there any way to limit the results in this dataset (either with the current connector or please add as a feature).
Thanks,
Shockoe
Comments
-
Hey - just jumping in to share a similar concern. I am having a similar row-count issue with a CRM provider CallTrackingMetrics (CTM / Call Tracking Metrics for search purposes).
Basically the API Connector will fetch the most recent 10k rows, then stop. The problems I have are:
A) With the 'Replace' update method - I can't reliably use this because the connector will never fetch ALL the data, so the replace method is useless. Especially without some filtering options. And,
With the 'Append' update method - it doesn't actually append, it just duplicates! I'm assuming because I can't set any parameters for *what* to append on, the API just duplicates.
I've reached out to support and looked for support docs but I can't seem to find anything. Sorry I don't have a solution for you but I'm hopeful the volume of reported issues might get some attention or creative solutions from other folks out there.
Cheers,
Pat
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 308 Workbench
- 6 Cloud Amplifier
- 10 Federated
- 3.8K Transform
- 660 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 84 App Studio
- 46 Variables
- 780 Automate
- 191 Apps
- 482 APIs & Domo Developer
- 84 Workflows
- 23 Code Engine
- 41 AI and Machine Learning
- 21 AI Chat
- 2 AI Projects and Models
- 18 Jupyter Workspaces
- 414 Distribute
- 122 Domo Everywhere
- 281 Scheduled Reports
- 11 Software Integrations
- 146 Manage
- 142 Governance & Security
- 8 Domo Community Gallery
- 49 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive