An API to pull the data from a card
Hello,
I know there are plenty of connecots and API documentation to bring data into Domo. However, is it possible to use the API to pull data from a Domo card to another software?
Best Answer
-
Hi Alexis,
it is possible to use the API to import and export datasets. The documentation is here and specific export instructions are here, share it with a developer, he or she will understand the details.
Essentially, you send something like
GET https://api.domo.com/v1/datasets/317970a1-6a6e-4f70-8e09-44cf5f34cf44/data?includeHeader=true&fileName=Q4_Sales_Data.csv Accept: text/csv Authorization: bearer <your-valid-oauth-access-token>
and the dataset will be returned to you. This does not afaik work for the data in cards (and things like filters, sorting and beast modes), but it would work for the dataset you use to power a card - in case of doubt, make the dataset as you want using a dataflow and then just request that one.
HTH
PS: you might also need to talk to Domo Support to enable the connection on their end.
1
Answers
-
Hi Alexis,
it is possible to use the API to import and export datasets. The documentation is here and specific export instructions are here, share it with a developer, he or she will understand the details.
Essentially, you send something like
GET https://api.domo.com/v1/datasets/317970a1-6a6e-4f70-8e09-44cf5f34cf44/data?includeHeader=true&fileName=Q4_Sales_Data.csv Accept: text/csv Authorization: bearer <your-valid-oauth-access-token>
and the dataset will be returned to you. This does not afaik work for the data in cards (and things like filters, sorting and beast modes), but it would work for the dataset you use to power a card - in case of doubt, make the dataset as you want using a dataflow and then just request that one.
HTH
PS: you might also need to talk to Domo Support to enable the connection on their end.
1 -
Thank you
0
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 472 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 202 Visualize
- 255 Beast Mode
- 2.1K Charting
- 12 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 180 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive