APIs & Domo Developer

APIs & Domo Developer

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().)

  1. RestClient dataClient = new RestClient("https://api.domo.com");
  2. RestRequest dataRequest = new RestRequest("v1/datasets/{dataset-id}/data", Method.Get);
  3. dataRequest.AddHeader("Authorization", $"Bearer {token}");
  4. var domoResponse = await dataClient.ExecuteAsync(dataRequest);
  5.  
  6. // ALWAYS ENDS IN AN ERROR HERE
  7. if(domoResponse.IsSuccessful == false)
  8. {
  9. domoResponse.Content.Dump("ErrorMessage");
  10. // error = {"status":500,"statusReason":"Internal Server Error","message":"Internal Server Error","toe":"E3OSUEGHUK-MPIU2-L469S"}
  11. return;
  12. }
  13. 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?

Best Answer

  • Member
    Answer ✓

    Bah...

    Ignore me...

    1. dataRequest.AddHeader("Accept", "text/csv");

Answers

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In