The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

OSAdmin's avatar
OSAdmin
Icon for OneStream Employee rankOneStream Employee
6 years ago

we are looking for a way to refresh excel workbook with the add-in in automated fashion using VBA with excel. did anyone do it with okta sso authentication?

Originally posted by Ashok Amresh

We are looking for a way to refresh excel workbook with the add-in in automated fashion.  did anyone do it with okta sso authentication?

basically looking for VBA version of below power-shell code. has anyone ever done it? Appreciate any help.

 

$ssoToken = $xfApi.Authentication.ProcessSSOAuthenticationAndCreateToken("<server address>", "Username", "Password", [OneStream.Shared.Wcf.XFClientAuthenticationType]::ClearTextPW)
$xfLogonInfo = $xfApi.Authentication.LogonAndOpenApplication("<server address>", "username", "$ssoToken", "appname", [OneStream.Shared.Wcf.XFClientAuthenticationType]::ClearTextPW)

Excel Add In

1 Reply

  • OS_Pizza's avatar
    OS_Pizza
    Contributor III
    4 years ago

    With an Okta user you could try the following: ' Set Excel Addin object Set xfAddin = Application.COMAddIns("OneStreamExcelAddIn").Object 'OneStream Web URL url = "url" 'okta user credentials oktaUsername = "enter okta username" oktaPassword = "enter okta password" ' app name app = "enter application name" ' get SSO Token ssoToken = xfAddin.ProcessSSOAuthenticationAndCreateToken(url, oktaUsername, oktaPassword) ' display token, only use for validating, if no token exists then login will not be successful MsgBox ssoToken ' Get user from SSO token user = xfAddin.GetXFUserNameFromSSOToken(ssoToken) ' log into application using token isLoggedIn = xfAddin.LogonAndOpenApplication(url, user, ssoToken, app) If isLoggedIn Then MsgBox ("Logged into OneStream") Refresh = xfAddin.RefreshQuickViewsForActiveWorksheet() xfAddin.Logoff Else MsgBox ("Problem with login") End If