-
Notifications
You must be signed in to change notification settings - Fork 1
/
ImportCsvToRayFlow.ps1
28 lines (22 loc) · 1.02 KB
/
ImportCsvToRayFlow.ps1
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
## Module RayFlow is required, see readme.md for more details
## Replace with your values
$pathToCSV = '<csv_file_full_path>'
$csvDelimeter = ';'
$rayflowUrl = 'https://<rayflow-server-url>:<port>/<instance>'
$rayflowUser = '<your-user-name>'
$rayflowPass = '<your-password>'
$rayflowProjectName = '<your-project-name>'
#Defaults
$category = '<app-category>'
$schedule = '<app-schedule>'
$type = '<app-type>'
#Import CSV
$csvObjects = Import-CSV -Path $pathToCSV -Delimiter $csvDelimeter
#Connect to RayFlow
$rayflowCredential = Get-RayFlowCredentials -UserName $rayflowUser -PlainTextPassword $rayflowPass
$rayflowProject = Get-RayFlowProject -ProjectName $rayflowProjectName -RayFlowServerUrl $rayflowUrl -Credentials $rayflowCredential
foreach ($package in $csvObjects) {
Write-Progress -Activity "Processing task [$package.ApplicationName]...";
$rayflowOrder = New-RayFlowOrder -Project $rayflowProject -Category $category -Schedule $schedule -Type $type -Datafields $package
Publish-RayFlowOrder -Order $rayflowOrder
}