Login / Register  search  syndication  about

          Ryan Farley's Blog

Ryan Farley on .NET Development with a focus on CRM Development for SalesLogix

Passing Connection Information from SalesLogix Web to Another Website

When integrating another system, application, or website with SalesLogix there are many options. If you're need to make connections to the SalesLogix database via the provider using user credentials you either need to prompt the user for login (again) or you can pass the connection information along to the other system.

It's easy enough to get the connection information using the DataService in SalesLogix. However, you don't really want to pass around a complete connection string around, especially since it will have the user's username and password in it. However, you can get the user's authentication token and then pass that to another system. It can use that authentication token to get all the connection values and form a valid connection string. Let's take a look.

Retrieving the current user's Authentication Token

To retrieve the user's authentication token, you can use the AuthenticationProvider service.

var authService = ApplicationContext.Current.Services.Get<IAuthenticationProvider>();
string authToken = authService.AuthenticationToken;

The authentication token will look like a long string of letters and numbers. You can pass this to some other website so that website/webpage can log into SalesLogix as that same user without prompting the user for their username and password. Let's look at what to do with this authentication token.

Decrypting and Using the Authentication Token

Once the other website or webpage has the Authentication Token all you need to do is convert it back to a stream and then read out the values from it. Then you have everything you need to form a valid connection string to the SalesLogix database as the user whose authentication token you have.

// In this code the "authToken" variable holds the authentication token value
// passed from SalesLogix Web (see code above)

using (var stream = new MemoryStream(Convert.FromBase64String(authToken)))
    using (var reader = new StreamReader(stream))
        string UserName = reader.ReadLine();
        string Password = reader.ReadLine();
        string UserId = reader.ReadLine();
        string Database = reader.ReadLine();
        string Alias = reader.ReadLine();
        string Server = reader.ReadLine();
        string ExtendedProperties = reader.ReadLine();
        string Provider = reader.ReadLine();
        string UserType = reader.ReadLine();

        string ConnectionString = string.Format(
                "Provider={5};Persist Security Info=True;Initial Catalog={1};Data Source={0};User ID={3};Password=\"{4}\";Extended Properties=\"{2}\"", 
                Server, Database, ExtendedProperties, UserName, Password, Provider

Pretty easy and the other external website or password didn't need to ask the user again for credentials or store a connection string locally.

Note if passing the Auth Token in a URL

If you are passing this authorization token from SalesLogix to another website or webpage via a parameter in the URL, you must encode the token otherwise any contained "+" chars will break the string (since that will be interpreted in the URL as a space).

On the SalesLogix side, encode the token using something like this:

authToken = System.Web.HttpUtility.UrlEncode(authToken);

Then, on the receiving side, grab the token from the URL and then decode is using something like this:

authToken = System.Web.HttpUtility.UrlDecode(authToken);

Then all will work fine and you can proceed to get the connection values from the token.

What's This?
Bookmark and Share

About Ryan Farley

   Ryan Farley is the Director of Development for Customer FX and creator of slxdeveloper.com. He's been blogging regularly about SalesLogix since 2001 and believes in sharing with the community. He loves C#, Javascript, Python, web development, open source, and Linux. He also loves his hobby as an amateur filmmaker.

View the SalesLogix Mobile Seveloper Series
View the SalesLogix SData Developer Series
View the Git for the SalesLogix Developer series

Related Content
   Configuring and Packaging secured actions in Saleslogix 8.0
Using Secured Actions, you can restrict access to user interface elements in the Saleslogix web client.
Posted on Aug 12, 2014 by Jason Buss to Jason Buss' Blog
   How do you add a parameter for File Attachment Size and Timeout in Saleslogix 8.1?
Question: Is it possible to set a parameter for file attachment size and timeout in Salelogix? If
Posted on Aug 07, 2014 by Dale Richter to SalesLogix Questions & Answers
   Saleslogix XBar Installation
When installing the new XBar application I found the instructions a little vague so I thought I would pas
Posted on Jul 18, 2014 by Mark Duthoy to SalesLogix Support
   Finding the Current Parent Record ID in SalesLogix Web
Sometimes it's the easiest things that can be a big barrier to entry for getting started with somet
Posted on Jun 27, 2014 by Ryan Farley to Ryan Farley's Blog
   SalesLogix 8.1 Job Service Scheduling Executions Error Resolution
Often times a web implementation will have an application server that is used to deploy the web portals t
Posted on Jun 20, 2014 by Mark Duthoy to SalesLogix Support


Jeff LeFevre said:


I need to pass the token from SLX to another web site like you describe above. My site has to be in a new browser window. Not inside SLX.

My problem is I need to do it from a Menu item.

In the Nav Url for the item, I am using javascript:window.open('xx.xx.xx/default.aspx' + , 'My Website', 'status=no,width=950,height=700');

This launches the site.  My problem is how do I get the current user's Authentication Token and put in the url string such as....


If there is a better way to call my new web site please let me know.

Please help.

April 16, 2012 10:38 AM

Ryan Farley said:

If you're doing that from a menu item you would need to set the location that the menu goes to at runtime. You can refer to this post on getting access to the menu items from a module: customerfx.com/.../creating-modules-for-saleslogix-web-and-hiding-toolbar-items-at-runtime.aspx This article looks are removing menu items in code, but once you have the menu item you could set it's link location just the same (and append on the authentication token)


April 16, 2012 6:00 PM

Leave a Comment

All contents Copyright © 2014 Customer FX Corporation
Customer FX Corporation
2324 University Avenue West, Suite 115
Saint Paul, Minnesota 55114
Tel: 800.728.5783

  Follow @CustomerFX on twitter
Follow the best news, tips, and articles
  Subscribe to Customer FX on youtube
Watch SalesLogix tutorial videos from Customer FX
Login / Register