Forum Discussion
OS_Pizza
Contributor III
If the answer helped you, Please give kudos and mark the answer as accepted solution
- Open an excel workbook
- Press Alt+F11 to open VBA Editor
- Insert a New Module from Insert Menu
- Copy the below code and Paste in the code window.
With an Okta user you could try the following:
' Set Excel Addin object
Set xfAddin = Application.COMAddIns("OneStreamExcelAddIn").Object
'OneStream Web 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)
' Get user from SSO token
user = xfAddin.GetXFUserNameFromSSOToken(ssoToken)
' log into application using token
isLoggedIn = xfAddin.LogonAndOpenApplication(url, user, ssoToken, app)
If isLoggedIn Then
Refresh = xfAddin.RefreshQuickViewsForActiveWorksheet()
Else
MsgBox ("Problem with login")
End If
Save the file as macro enabled workbook
Open the workbook to test it, it will Run a Macro Automatically.
AdamB
7 months agoNew Contributor II
Do you know if this Okta login module will work with version 8?
Related Content
- 3 months ago
- 7 months ago