OneStream – execute a rule as an Administrator using Powershell 8

' helper method that takes the script path and loads up the script text
' into a variable, and passes the variable to the RunScript method
' that will then execute the contents
Private Function LoadScript(ByVal si As SessionInfo,ByVal filename As String) As String
	Try
		' Create an instance of StreamReader to read from the file.
		Dim sr As New StreamReader(filename)
		' use a string builder to get all the lines from the file
		Dim fileContents As New StringBuilder()
		' string to hold the current line
		Dim curLine As String = ""
		' loop through the file and read each line into the
		' stringbuilder
		Do
			' read each line
			curLine = sr.ReadLine()
			fileContents.Append(curLine + vbCrLf)
		Loop Until curLine Is Nothing
		' close the reader
		sr.Close()
		' call RunScript and pass in the file contents
		' converted to a string
		Return fileContents.ToString()
		
	Catch ex As Exception
		Throw ErrorHandler.LogWrite(si, New XFException(si, ex))
	End Try
End Function

' Takes script text as input and runs it, then converts
' the psResults to a string to return to the user		
Private Function RunScript(ByVal si As SessionInfo, ByVal scriptText As String) As String
	Try
		
		' create Powershell runspace
		Dim psRunSpace As Runspace = RunspaceFactory.CreateRunspace()
		' open it
		psRunSpace.Open()
		
		' create a pipeline and feed it the script text
		Dim psPipeLine As Pipeline = psRunSpace.CreatePipeline()
		Dim newScriptText As String = scriptText.Replace("InitiatedUserName", "InitiatedUserName=" & si.UserName)
		psPipeLine.Commands.AddScript(newScriptText)
		
		' add an extra command to transform the script output
		psPipeLine.Commands.Add("Out-String")
		' execute the script
		Dim psResults As Collection(Of PSObject) = psPipeLine.Invoke()
		' close the runspace
		psRunSpace.Close()
		' convert the script result into a single string
		Dim psOut As New StringBuilder()
		For Each obj As PSObject In psResults
			psOut.AppendLine(obj.ToString())
		Next
		' return the results of the script
		Return psOut.ToString()
		
	Catch ex As Exception
		Throw ErrorHandler.LogWrite(si, New XFException(si, ex))
	End Try
End Function

Add-Type -Path "C:\Program Files (x86)\OneStream Software\OneStreamStudio\OneStreamClientApi.dll"
$xfApi = new-object OneStream.Client.Windows.OneStreamClientApi
$xfApi.Authentication.EncryptPassword("password", [OneStream.Shared.Wcf.XFClientAuthenticationType]::EncryptedPW)

Add-Type -Path "C:\Program Files (x86)\OneStream Software\OneStreamStudio\OneStreamClientApi.dll"
$xfApi = new-object OneStream.Client.Windows.OneStreamClientApi
$xfLogonInfo = $xfApi.Authentication.LogonAndOpenApplication("https://yourserver.onestreamcloud.com/OneStreamWeb", "userName", "FvAIwgx8Ff2uXefWJ0OazNym6cub0gRARJTvQyo//Lc=","Application Name", [OneStream.Shared.Wcf.XFClientAuthenticationType]::EncryptedPW)
if ($xfLogonInfo.IsAuthenticated)
{
	# UserName will be replaced from the BR with a real value
	$xfResult = $xfApi.DataManagement.ExecuteSequence("YourSequence", "InitiatedUserName")
    if (-Not ($xfResult.IsOK)){
       $xfResult.Message
    }
	"Data transferrred and processed"
    $xfApi.Authentication.Logoff()
}
Else
{
	"Error logging in user"
    $xfLogonInfo.ErrorMessage
}

Add-Type -Path "C:\Program Files (x86)\OneStream Software\OneStreamStudio\OneStreamClientApi.dll"
$xfApi = new-object OneStream.Client.Windows.OneStreamClientApi
$ssoToken = $xfApi.Authentication.ProcessSSOAuthenticationAndCreateToken("https://centene-dev.onestreamcloud.com/OneStreamWeb", "userName", "FvAIwgx8Ff2uXefWJ0OazNym6cub0gRARJTvQyo//Lc=", [OneStream.Shared.Wcf.XFClientAuthenticationType]::EncryptedPW)
$xfLogonInfo = $xfApi.Authentication.LogonAndOpenApplication("https://yourserver.onestreamcloud.com/OneStreamWeb", $xfApi.Authentication.GetXFUserNameFromSSOToken($ssoToken), "$ssoToken","Application Name", [OneStream.Shared.Wcf.XFClientAuthenticationType]::ClearTextPW)
if ($xfLogonInfo.IsAuthenticated)
{
	# UserName will be replaced from the BR with a real value
	$xfResult = $xfApi.DataManagement.ExecuteSequence("YourSequence", "InitiatedUserName")
    if (-Not ($xfResult.IsOK)){
       $xfResult.Message
    }
	"Data transferrred and processed"
    $xfApi.Authentication.Logoff()
}
Else
{
	"Error logging in user"
    $xfLogonInfo.ErrorMessage
}