API Dataset Export Issue
I've been trying to use the below example to export a dataset from a browser URL bar.
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>
I've put in my own dataset code and my API key but every time I run it I get the following error.
{"status":401,"statusReason":"Internal Server Error","path":"/v1/datasets/74266a90-4ebb-4417-aad7-b52ca99e407e/data","message":"com.domo.bedrock.service.exception.UnauthorizedException: Full authentication is required to access this resource","toe":"HVURVVTBIG-UT8IM-KEHK2"}
I've also tried running it through a API VBA get function that i've had work with other API in the past without any luck. I'm not sure what I am missing. Does anyone know how to get this to work?
Any help would be greatly apprecaited.
Comments
-
Can anyone help with this request?
Thanks,
0 -
You won't be able to hit that endpoint from a browser URL as it requires the use of the Authorization header being added to the HTTP request. You could use a tool like cURL or Postman or a programming language to do it, however.
It's a two step process. First you have to hit the endpoint to authenticate with the API using your ClientID and ClientSecret created at developer.domo.com. The response from that call will contain the token needed in the Authorization header for subsequent calls.
This process is outlined here: https://developer.domo.com/docs/authentication/overview-4 Give it a look and see if you still have questions afterwards.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive