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
- 7.7K All Categories
- 2 Connect
- 918 Connectors
- 244 Workbench
- 476 Transform
- 1.8K Magic ETL
- 60 SQL DataFlows
- 446 Datasets
- 35 Visualize
- 198 Beast Mode
- 2K Charting
- 8 Variables
- 1 Automate
- 348 APIs & Domo Developer
- 82 Apps
- Workflows
- 14 Predict
- 3 Jupyter Workspaces
- 11 R & Python Tiles
- 241 Distribute
- 59 Domo Everywhere
- 241 Scheduled Reports
- 15 Manage
- 36 Governance & Security
- 23 Product Ideas
- 1.1K Ideas Exchange
- Community Forums
- 15 Getting Started
- 1 Community Member Introductions
- 49 Community News
- 18 Event Recordings
- 579 日本支部