Authorization

In This Topic

OAuth is an open-standard authorization protocol that creates a platform for unlinked servers and services to allow authenticated access to data sources without sharing private credentials. OAuth is used in a wide variety of applications for user authentication. For more information on OAuth and types of credentials, refer to the OAuth Authorization topic.

To connect to a CSV server that requires OAuth authentication, provide the following properties:

C#	Copy Code
//CSV server protected by OAuth 2.0 authentication const string TokenEndpoint = @"http://**//"; const string URI = @http:////**; const string ClientId = @"yourid"; const string ClientSecret = @"yoursecretcode"; const string Scope = @"yourscope"; const string Username = @"yourusername"; const string Password = @"yourpassword";

Copy Code

//CSV server protected by OAuth 2.0 authentication
const string TokenEndpoint = @"http://****/****/****";
const string URI = @http://****/****/****;
const string ClientId = @"yourid";
const string ClientSecret = @"yoursecretcode";
const string Scope = @"yourscope";
const string Username = @"yourusername";
const string Password = @"yourpassword";

In the following code, the OAuthClientId, OAuthClientSecret, and other attributes are set to fetch the data using properties of the C1CSVConnection class.

C#	Copy Code
static string connectionStringForOAuth = @$OAuth Token Endpoint={TokenEndpoint}; Uri={URI}; OAuth Client Id={ClientId}; OAuth Client Secret={ClientSecret}; OAuth Scope={Scope}; Username={Username}; Password={Password}; static void SelectDocumentWithOAuth() { Console.WriteLine("Query all Books via OAuth..."); using (var con = new C1CSVConnection(connectionStringForOAuth)) { con.Open(); var table = con.GetSchema("columns", new string[] { "value" }); ShowDataTable(table); var cmd = con.CreateCommand(); cmd.CommandText = "Select * From value"; var reader = cmd.ExecuteReader(); } } static void ShowDataTable(DataTable table, int length = 25) { foreach (DataColumn col in table.Columns) { Console.Write("{0,-" + length + "}", col.ColumnName); } Console.WriteLine(); foreach (DataRow row in table.Rows) { foreach (DataColumn col in table.Columns) { if (col.DataType.Equals(typeof(DateTime))) Console.Write("{0,-" + length + ":d}", row[col]); else if (col.DataType.Equals(typeof(decimal))) Console.Write("{0,-" + length + ":C}", row[col]); else Console.Write("{0,-" + length + "}", row[col]); } Console.WriteLine(); } }

Copy Code

static string connectionStringForOAuth = @$OAuth Token Endpoint={TokenEndpoint}; Uri={URI};
       OAuth Client Id={ClientId}; OAuth Client Secret={ClientSecret}; OAuth Scope={Scope};
       Username={Username}; Password={Password};
                
static void SelectDocumentWithOAuth()
    {
        Console.WriteLine("Query all Books via OAuth...");
        using (var con = new C1CSVConnection(connectionStringForOAuth))
        {
            con.Open();
            var table = con.GetSchema("columns", new string[] { "value" });
            ShowDataTable(table);
            var cmd = con.CreateCommand();
            cmd.CommandText = "Select * From value";
            var reader = cmd.ExecuteReader();
        }
    }
                
static void ShowDataTable(DataTable table, int length = 25)
    {
        foreach (DataColumn col in table.Columns)
        {
            Console.Write("{0,-" + length + "}", col.ColumnName);
        }
        Console.WriteLine();

        foreach (DataRow row in table.Rows)
        {
            foreach (DataColumn col in table.Columns)
            {
                if (col.DataType.Equals(typeof(DateTime)))
                    Console.Write("{0,-" + length + ":d}", row[col]);
                else if (col.DataType.Equals(typeof(decimal)))
                    Console.Write("{0,-" + length + ":C}", row[col]);
                else
                    Console.Write("{0,-" + length + "}", row[col]);
            }
            Console.WriteLine();
        }
    }