API DataSet export using RestSharp.RestClient
Folks,
I have a valid client ID and Client Secret, and I can export the data I want using Postman.
But I need to do this thru C# code in Linqpad, and it fails every time. (The .Dump() method below is their clever variation on Console.WriteLine().)
RestClient dataClient = new RestClient("https://api.domo.com"); RestRequest dataRequest = new RestRequest("v1/datasets/{dataset-id}/data", Method.Get); dataRequest.AddHeader("Authorization", $"Bearer {token}"); var domoResponse = await dataClient.ExecuteAsync(dataRequest); // ALWAYS ENDS IN AN ERROR HERE if(domoResponse.IsSuccessful == false) { domoResponse.Content.Dump("ErrorMessage"); // error = {"status":500,"statusReason":"Internal Server Error","message":"Internal Server Error","toe":"E3OSUEGHUK-MPIU2-L469S"} return; } domoResponse.Content.Substring(0,1000).Dump("Sample");
I know this code and my secrets and the token work, because if I remove the "{dataset-id}/data" from the target, it happily downloads a list of my DataSets.
What am I missing?
0
Best Answer
-
Bah...
Ignore me...
dataRequest.AddHeader("Accept", "text/csv");
1
Answers
-
Bah...
Ignore me...
dataRequest.AddHeader("Accept", "text/csv");
1
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 473 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 478 Datasets
- 209 Visualize
- 257 Beast Mode
- 2.1K Charting
- 12 Variables
- 18 Automate
- 355 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
- 183 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive