Public/Contacts/Remove-Five9ContactRecord.ps1
function Remove-Five9ContactRecord { <# .SYNOPSIS Function used to remove record(s) from the Five9 contact record database Using the function you are able to remove records 3 ways: 1. Specifying a single object using -InputObject 2. Specifying an arrary of objects using -InputObject 3. Specifying the path of a local CSV file using -CsvPath .EXAMPLE Remove-Five9ContactRecord -InputObject $dataToBeRemoved # Records in $dataToBeRemoved will be removed from the contact record database .EXAMPLE Remove-Five9ContactRecord -CsvPath 'C:\files\contact-records.csv' # Records in CSV file 'C:\files\contact-records.csv' will be removed from the contact record database .EXAMPLE Remove-Five9ContactRecord -CsvPath 'C:\files\contact-records.csv' ` -CrmDeleteMode: DELETE_ALL -Key @('number1', 'first_name') ` -FailOnFieldParseError $true -ReportEmail 'jdoe@domain.com' # Removes records in CSV file from contact record database, specifying additional optional parameters #> [CmdletBinding(DefaultParametersetName='InputObject', PositionalBinding=$false)] param ( # Single object or array of objects to be removed from the contact record database. Note: Parameter not needed when specifying a CsvPath [Parameter(ParameterSetName='InputObject', Mandatory=$true)][psobject[]]$InputObject, # Local file path to CSV file containing records to be removed from contact record database. Note: Parameter not needed when specifying an InputObject [Parameter(ParameterSetName='CsvPath', Mandatory=$true)][string]$CsvPath, <# Specifies the modes used for deleting data from the contact database Options are: • DELETE_ALL (Default) - Delete all specified records • DELETE_SOLE_MATCHES - Delete only single matches • DELETE_EXCEPT_FIRST - Delete all records except the first matching record #> [Parameter(Mandatory=$false)][string][ValidateSet("DELETE_ALL", "DELETE_SOLE_MATCHES", "DELETE_EXCEPT_FIRST")]$CrmDeleteMode = "DELETE_ALL", # Single string, or array of strings which designate key(s). It is used to find matching reocrds in the database to remove. # If omitted, 'number1' will be used [Parameter(Mandatory=$false)][string[]]$Key = @("number1"), <# Whether to stop the removal if incorrect data is found For example, if set to True and you have a column named hair_color in your data, but that field has not been created as a contact field, the function will fail Options are: • True: The record is rejected when at least one field fails validation • False: Default. The record is accepted. However, changes to the fields that fail validation are rejected #> [Parameter(Mandatory=$false)][bool]$FailOnFieldParseError, # Notification about results is sent to the email addresses that you set for your application [Parameter(Mandatory=$false)][string]$ReportEmail ) try { Test-Five9Connection -ErrorAction: Stop if ($PSCmdlet.ParameterSetName -eq 'InputObject') { $csv = $InputObject | ConvertTo-Csv -NoTypeInformation } elseif ($PSCmdlet.ParameterSetName -eq 'CsvPath') { # try to import csv file so that if it throw an error, we know the data is bad $csv = Import-Csv $CsvPath | ConvertTo-Csv -NoTypeInformation } else { # should never reach this point becasue user should use either InputObject or CsvPath return } $headers = $csv[0] -replace '"' -split ',' # verify that key(s) passed are present in $Inputobject foreach ($k in $Key) { if ($headers -notcontains $k) { throw "Specified key ""$k"" is not a property name found in data being imported." return } } $crmDeleteSettings = New-Object PSFive9Admin.crmDeleteSettings # prepare "fieldMapping" per Five9's documentation $counter = 1 foreach ($header in $headers) { $isKey = $false if ($Key -contains $header) { $isKey = $true } $crmDeleteSettings.fieldsMapping += @{ columnNumber = $counter fieldName = $header key = $isKey } $counter++ } $csvData = ($csv | select -Skip 1) | Out-String $crmDeleteSettings.crmDeleteModeSpecified = $true $crmDeleteSettings.crmDeleteMode = $CrmDeleteMode if ($PSBoundParameters.Keys -contains "FailOnFieldParseError") { $crmDeleteSettings.failOnFieldParseErrorSpecified = $true $crmDeleteSettings.failOnFieldParseError = $FailOnFieldParseError } if ($PSBoundParameters.Keys -contains "ReportEmail") { $crmDeleteSettings.reportEmail = $ReportEmail } Write-Verbose "$($MyInvocation.MyCommand.Name): Removing contact records from database." # single record if ($InputObject.Count -eq 1) { $data = $csvData -replace '"' -split ',' $response = $global:DefaultFive9AdminClient.deleteFromContacts($crmDeleteSettings, $data) } else { $response = $global:DefaultFive9AdminClient.deleteFromContactsCsv($crmDeleteSettings, $csvData) } return $response } catch { $_ | Write-PSFive9AdminError $_ | Write-Error } } |