Problematically Replicate Exporting to Excel in the UI?
I know I can use the API to pull data down from Domo which would allow me to do manipulation to it but my goal would be to replicate what data shows on the card, the same data that is returned when you do a manual Export to Excel in the browser. That's what I would want to access programatically, not the whole underlying dataset. Is that possible? The only workaround I can think of is to take all the data down and use some libraries to create pivot tables, etc which seems like a lot of work.
Also I'd like it to be via the API and not through browser automation via something like selenium.
Any ideas? Thanks!
**Make sure to like any users posts that helped you and accept the ones who solved your issue.**
Comments
-
That does seem Problematic.
Where are you wanting to pull the data down to? Would the Domo embed feature be of any use here?
Admittedly, I don't do much with APIs so there may be a solution I'm not aware of. However, I believe that only data sets can be accessed via API calls and not individual cards.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0 -
Ha, I didn't notice a reply to this thread and when i came back to double check i noticed my spelling error in the title, dangit. From what I can tell so far I can only access the underlying data, I'd essentially have to rebuild the card with some excel programming or something which I'd LOVE to avoid even venturing that route. Unfortunately embed isn't going to work because I'm trying to give summarized data to non Domo users
**Make sure to like any users posts that helped you and accept the ones who solved your issue.**0 -
Unfortunately you cannot access a card's data via the API, just the underlying dataset. Although this seems a popular request - would be a good idea for the Idea's Exchange.
Browser automation or further data manipulation after the API call would be the only viable routes I can think of.
Although, it might be worth reaching out to the Domo support team. They sometimes have internal API's they use and can maybe share.
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