Copying dataset pdp settings

I scripted it using PowerShell and the API... All you need to add is the access token and the dataset ids. there are comments in the code from past projects and it is not perfect but it worked for our purpose. We have thousands of PDP rules and the excel pugin bogs down. There is also a PDP utility but you have to create a dataset of PDP rules... This was easier.

function Get-Dataset($datasetId, $Authentication) {
#Write-Host $Authentication
$headers = @{
Accept = 'text/csv'
Authorization = $Authentication.access_token
}
#Write-Host "https://api.domo.com/v1/datasets/$datasetId/data?includeHeader=true&fileName=dump.csv" -Headers $headers
try {
$csv = Invoke-RestMethod -Method Get -Uri "https://api.domo.com/v1/datasets/$datasetId/data?includeHeader=true&fileName=dump.csv" -Headers $headers
$csv = $csv -replace '\\N', $null
$data = ConvertFrom-Csv $csv
#Write-Host "must have Successfully Read CSV File"
}
catch {
Write-Host "Failed to Read Dataset CSV File"
Write-Host $_.ErrorDetails
Write-Host $_.Exception
Write-Host $_.FullyQualifiedErrorId
Start-Sleep -Seconds 10
}
return $data
}

function Get-Dataset-Object($datasetId, $Authentication) {
#Write-Host $Authentication
$NeedData = $true
While( $NeedData -eq $true -and $Cnct_Cntr -lt 100){
try {
$headers = @{
Accept = 'application/json'
Authorization = $Authentication.access_token
}
#Write-Host "https://api.domo.com/v1/datasets/$datasetId" -Headers $headers
$data = Invoke-RestMethod -Method Get -Uri "https://api.domo.com/v1/datasets/$datasetId" -Headers $headers
#Write-Host "must have Successfully Read CSV File"
$Cnct_Cntr++
$NeedData = $false
}
catch {
Write-Host "Failed to get dataset object"
Write-Host $_.ErrorDetails
Write-Host $_.Exception
Write-Host $_.FullyQualifiedErrorId
$Cnct_Cntr++
Write-Host $Cnct_Cntr
Start-Sleep -Seconds 10
}
}
return $data
}

function Get-Dataset-PDP($datasetId, $Authentication) {
#Write-Host $Authentication
$NeedData = $true
While( $NeedData -eq $true -and $Cnct_Cntr -lt 100){
try {
$headers = @{
Accept = 'application/json'
Authorization = $Authentication.access_token
}
#Write-Host "https://api.domo.com/v1/datasets/$datasetId" -Headers $headers
$data = Invoke-RestMethod -Method Get -Uri "https://api.domo.com/v1/datasets/$datasetId/policies" -Headers $headers
#Write-Host "must have Successfully Read CSV File"
$Cnct_Cntr++
$NeedData = $false
}
catch {
Write-Host "Failed to get dataset object"
Write-Host $_.ErrorDetails
Write-Host $_.Exception
Write-Host $_.FullyQualifiedErrorId
$Cnct_Cntr++
Write-Host $Cnct_Cntr
Start-Sleep -Seconds 10
}
}
return $data
}

function Get-Authorization($clientID, $clientSecret) {
$basicAuth = [Convert]::ToBase64String([Text.Encoding]::ASCII.GetBytes(("{0}:{1}" -f $clientID, $clientSecret)));
$authenticationHeader = @{
Authorization = ("Basic {0}" -f $basicAuth)
}
$NeedToken = $true
$Cnct_Cntr = 0

#keep trying to get a token
While( $NeedToken -eq $true -and $Cnct_Cntr -lt 100){
try {
$data = Invoke-RestMethod -Method Post -Uri "https://api.domo.com/oauth/token?grant_type=client_credentials&scope=data%20user" -Headers $authenticationHeader
# $data = Invoke-RestMethod -Method Post -Uri "https://api.domo.com/oauth/token?grant_type=client_credentials&scope=full" -Headers $authenticationHeader
$data.access_token = "bearer $($data.access_token)"
# Write-Host "Got Token"
$Cnct_Cntr++
$NeedToken = $false
}
catch {
#$ErrorActionPreference = Stop #this does not recognize "Stop"
Write-Host "Failed to get Token"
Write-Host $_.ErrorDetails
Write-Host $_.Exception
Write-Host $_.FullyQualifiedErrorId
$Cnct_Cntr++
Write-Host $Cnct_Cntr
Start-Sleep -Seconds 10
}
}
return $data
}

function Send-ToEmail([string]$email, [string]$body){

$message = new-object Net.Mail.MailMessage;
$message.From = "Domo@daltile.com";
$message.To.Add($email);
$message.Subject = "Error Running Vistex jobs Script";
$message.Body = $body;
$smtp = new-object Net.Mail.SmtpClient("smtpmail.mohawkind.com");
$smtp.send($message);
write-host "Mail Sent" ;
}

Write-Host "go get auth token"
$Authentication = Get-Authorization -clientID $apiKey -clientSecret $apiToken
Write-Host "have token"
#Write-Host $Authentication
#$MetData = Get-Dataset -datasetId $datasetmetadata -Authentication $Authentication

$output = ''
$haserr = $true
$Have_PDP = $false
#get the list of WB jobs
while(!$Have_PDP){
try{
$Authentication = Get-Authorization -clientID $apiKey -clientSecret $apiToken
$DS_PDP = Get-Dataset-PDP -datasetId $PDPSourceDatasetID -Authentication $Authentication
$Have_PDP = $true
}
catch{
Write-Host "Failed to get dataset list of PDP rules"
Write-Host $_.ErrorDetails
Write-Host $_.Exception
Write-Host $_.FullyQualifiedErrorId
Start-Sleep -Seconds 10
}
}
# Cycle through the list of jobs ensuring they run successfully.

$PDPs = $DS_PDP.Where{$_."name" -like "z_rep_*" -or $_."name" -like "z_ssc_*" } #| Sort-Object -Property $_."Execution Order"| Sort-Object -Property $_."Execution Order"
foreach($PDP in $PDPs){
$haserr = $true
$output = ''
$msg = ''
$Count = 0

Try{
$hdrs = New-Object "System.Collections.Generic.Dictionary[[String],[String]]"
$hdrs.Add("Content-Type", "application/json")
$hdrs.Add("Accept", 'application/json')
$hdrs.Add("Authorization", $Authentication.access_token)
$filter = $PDP.filters
$name = $PDP.name
$type = $PDP.type
$users = $PDP.users
$groups = $PDP.groups

$i = 0
$pdp_rule = '{ "name": "'+$name+'",'
$fString = '"filters": ['
foreach($f in $PDP.filters){
$fString += '{ "column": "'+$f.column+'", "values": [ "'+$f.values+'" ], "operator": "'+$f.operator+'" }'
$i++
if($i -lt $PDP.filters.count){$fString += ','}
}

$pdp_rule += $fString +' ], "groups": [ "'+$groups+'" ] }'
# {
# "name": "z_ssc_4000",
# "filters": [ {
# "column": "business_area_number",
# "values": [ "4000" ],
# "operator": "EQUALS"
# } ],
# "groups": [ 612003576 ]
#}

$post = Invoke-WebRequest -Method POST -Uri "https://api.domo.com/v1/datasets/$DestinationDatasetId/policies" -UseBasicParsing -Body $pdp_rule -Headers $hdrs -ContentType 'application/json'

Write-Host "updated $name in Proex dataset PDP "
}

catch {
Write-Host "Failed to add $email to Domo"
Write-Host $_.ErrorDetails
Write-Host $_.Exception
Write-Host $_.FullyQualifiedErrorId

}

}#end foreach job

$now = Get-Date -Format g
Write-Host "$now Done."