Need to read a Domo dataset using C#

ArborRose · 2024-09-04T16:55:55+00:00

There was an error rendering this rich post.

I am having trouble getting an access token to work in C#. I am writing an application, and I need to update an office list using the data in one of my Domo datasets.

I have created client and secret IDs and post to "https://api.domo.com/oauth/token". I have tried several grant types and included/excluded a scope. The response is always unauthorized.

StatusCode: 401, ReasonPhrase: 'Unauthorized', Version: 1.1,…



var tokenUrl = "https://api.domo.com/oauth/token";

var values = new Dictionary<string, string>

{

    { "grant_type", "client_credentials" },

    { "scope", "data" },

    { "client_id", clientId },

    { "client_secret", clientSecret }

};


var content = new FormUrlEncodedContent(values);




HttpResponseMessage response = client.PostAsync(tokenUrl, content).Result;

if (!response.IsSuccessStatusCode)

{

    throw new Exception($"Failed to get access token: {response.ReasonPhrase}");

}

I just need to read a single dataset in Domo, using C#. Or VB.net…I'll convert code if needed. I haven't had trouble using Python. But that doesn't translate to C#.

Find more posts tagged with

Accepted answers

GrantSmith

It looks like you're not passing in an Authorization Header.

Here's some sample code I've used in the past which may be helpful:

using System;
using System.Net.Http;
using System.Net.Http.Headers;
using System.Text;
using System.Threading.Tasks;

class Program
{
    private static readonly string ClientId = "YOUR_CLIENT_ID";
    private static readonly string ClientSecret = "YOUR_CLIENT_SECRET";
    private static readonly string DomoAuthUrl = "https://api.domo.com/oauth/token";
    
    static async Task Main(string[] args)
    {
        string token = await GetDomoOAuthToken();
        Console.WriteLine($"OAuth Token: {token}");
    }

    private static async Task<string> GetDomoOAuthToken()
    {
        using (HttpClient client = new HttpClient())
        {
            // Construct the authorization header
            string authHeader = Convert.ToBase64String(Encoding.ASCII.GetBytes($"{ClientId}:{ClientSecret}"));
            client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Basic", authHeader);

            // Prepare the request content
            HttpContent content = new StringContent("grant_type=client_credentials", Encoding.UTF8, "application/x-www-form-urlencoded");

            // Make the POST request
            HttpResponseMessage response = await client.PostAsync(DomoAuthUrl, content);

            // Ensure the request was successful
            response.EnsureSuccessStatusCode();

            // Parse and return the token from the response
            string responseContent = await response.Content.ReadAsStringAsync();
            dynamic jsonResponse = Newtonsoft.Json.JsonConvert.DeserializeObject(responseContent);
            return jsonResponse.access_token;
        }
    }
}

All comments

GrantSmith

It looks like you're not passing in an Authorization Header.

Here's some sample code I've used in the past which may be helpful:

using System;
using System.Net.Http;
using System.Net.Http.Headers;
using System.Text;
using System.Threading.Tasks;

class Program
{
    private static readonly string ClientId = "YOUR_CLIENT_ID";
    private static readonly string ClientSecret = "YOUR_CLIENT_SECRET";
    private static readonly string DomoAuthUrl = "https://api.domo.com/oauth/token";
    
    static async Task Main(string[] args)
    {
        string token = await GetDomoOAuthToken();
        Console.WriteLine($"OAuth Token: {token}");
    }

    private static async Task<string> GetDomoOAuthToken()
    {
        using (HttpClient client = new HttpClient())
        {
            // Construct the authorization header
            string authHeader = Convert.ToBase64String(Encoding.ASCII.GetBytes($"{ClientId}:{ClientSecret}"));
            client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Basic", authHeader);

            // Prepare the request content
            HttpContent content = new StringContent("grant_type=client_credentials", Encoding.UTF8, "application/x-www-form-urlencoded");

            // Make the POST request
            HttpResponseMessage response = await client.PostAsync(DomoAuthUrl, content);

            // Ensure the request was successful
            response.EnsureSuccessStatusCode();

            // Parse and return the token from the response
            string responseContent = await response.Content.ReadAsStringAsync();
            dynamic jsonResponse = Newtonsoft.Json.JsonConvert.DeserializeObject(responseContent);
            return jsonResponse.access_token;
        }
    }
}

ArborRose

That works. Thank you @GrantSmith .