Python Refresh Sheet or Workbook - OneStream Excel Add In

accountant 

If the answer helped you, Please give kudos and mark the answer as accepted solution

1. Open an excel workbook
2. Press Alt+F11 to open VBA Editor
3. Insert a New Module from Insert Menu
4. 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.