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

HoneyGulati's avatar
HoneyGulati
New Contributor III
2 years ago

Push file from OS Export to AWS S3 folder via business rule

Hi, Can anyone guide me to push the file from OS export folder to AWS S3 bucket via business rule? Currently it is being taken care by power script. Wondering if it can be achieved by business ru...
Methodology
planning
hbindu's avatar
hbindu
Icon for OneStream Employee rankOneStream Employee
2 years ago

Hi,

I wrote an extensibility BR to extract data from OS to a csv file and the file is then moved to an FTP folder. 

In your case instead of FTP folder it will be AWS S3 bucket. 

below is the sample code:

If filecount > 0  Then 
Dim sessionOptions As New SessionOptions
Dim transferOptions As New TransferOptions
Dim transferResult As TransferOperationResult
Using session As New Session
session.Open(sessionOptions)
transferOptions.TransferMode = TransferMode.Binary
transferOptions.OverwriteMode = OverwriteMode.Overwrite
'transferOptions.PreserveTimeStamp = True
transferOptions.ResumeSupport.State = TransferResumeSupportState.Off
Dim RootFolder As String = $"{session.HomePath}/<RootFolderpath>"
  files = From chkFile In Directory.EnumerateFiles(_path, "*.PGP", SearchOption.TopDirectoryOnly)
For Each Filepath In files
transferResult = session.PutFiles($"{Filepath}", RootFolder, False, transferOptions)
transferResult.Check()
Next
Using 
End If