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
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 656 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 813 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 771 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 77 Workflows
- 23 Code Engine
- 36 AI and Machine Learning
- 19 AI Chat
- AI Playground
- AI Projects and Models
- 17 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 142 Manage
- 138 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive