Public/New-ServiceNowRecord.ps1
|
<# .SYNOPSIS Create a new record in any table .DESCRIPTION Create a new record in any table by specifying the table name and values required for that table .PARAMETER Table Name or class name of the table to create the new record .PARAMETER InputData Key/value pairs of fields and their values .PARAMETER PassThru If provided, the new record will be returned .PARAMETER Connection Azure Automation Connection object containing username, password, and URL for the ServiceNow instance .PARAMETER ServiceNowSession ServiceNow session created by New-ServiceNowSession. Will default to script-level variable $ServiceNowSession. .EXAMPLE New-ServiceNowRecord -Table incident -InputData @{'Caller'='me';'short_description'='my issue'} Create a new record in the incident table .EXAMPLE @{'short_description'='my issue';'assignment_group'='IT Support'}, @{'short_description'='another issue'} | New-ServiceNowRecord -Table incident Create multiple records in the same table by piping the input data .INPUTS InputData .OUTPUTS PSCustomObject if PassThru provided #> function New-ServiceNowRecord { [CmdletBinding(SupportsShouldProcess)] Param ( [parameter(Mandatory)] [string] $Table, [parameter(Mandatory, ValueFromPipeline)] [Alias('Values')] [hashtable] $InputData, [Parameter()] [Hashtable] $Connection, [Parameter()] [hashtable] $ServiceNowSession = $script:ServiceNowSession, [Parameter()] [switch] $PassThru ) process { $params = @{ Method = 'Post' Table = $Table Values = $InputData Connection = $Connection ServiceNowSession = $ServiceNowSession } If ( $PSCmdlet.ShouldProcess($Table, 'Create new record') ) { $response = Invoke-ServiceNowRestMethod @params If ( $PassThru ) { $type = $script:ServiceNowTable | Where-Object { $_.Name -eq $Table -or $_.ClassName -eq $Table } | Select-Object -ExpandProperty Type if ($type) { $response | ForEach-Object { $_.PSObject.TypeNames.Insert(0, $type) } } $response } } } } |