如何使用PowerShell通过REST API将CSV文件附加到Service Now事件

Question

我需要使用 PowerShell 脚本通过 SNOW REST API 将文件附加到特定事件。我已经尝试使用以下代码：

if (!$script:ServiceNowCreds) {
    $script:ServiceNowCreds = Get-Credential
}
$snow_url = 'https://dev652xx.service-now.com/api/now/table/incident'
$Body = @{
    'number' = 'INC00xx059'    
}
$result = Invoke-RestMethod -Uri  $snow_url -Credential $script:ServiceNowCreds -Body $Body -ContentType "application/json" 
$result.result | select sys_id, number | ForEach-Object {
    $Upload_snow_url ='https://dev652xx.servicenow.com/api/now/attachment/upload'
    $headers = New-Object "System.Collections.Generic.Dictionary[[String],[String]]"
    $headers.Add('Content-Type','text/csv')
    $headers.Add('Accept','*/*')
    $sys_id = $_.sys_id
    $incident_number = $_.number
    $UploadBody = @{
        'table_name'='incident'; 
        'table_sys_id'=$sys_id;
        'file_name' = 'C:Userssuganthanraj.pDocumentsServers.csv'
    }
    $uploadParam = $UploadBody | ConvertTo-JSon
    Write-Host $sys_id
    Write-Host $incident_number
    $UploadResult = Invoke-RestMethod -Uri $Upload_snow_url -Credential $script:ServiceNowCreds -Body $uploadParam -Method Post -Headers $headers
    $UploadResult
}

当我执行上述脚本时，出现以下错误：

调用-休息方法： 远程服务器返回错误： （415） 不支持媒体类型。at C：\Users\suganthanraj.p\Desktop\SNOW-UploadAttachment.ps1：39 char：21+ ...oadResult = Invoke-RestMethod -Uri $Upload_snow_url -Credential $scr ...+                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~    + CategoryInfo ： InvalidOperation： （System.Net.HttpWebRequest：HttpWebRequest） [Invoke-RestMethod]， WebException    + FullQualifiedErrorId ： WebCmdletWebResponseException，Microsoft.PowerShell.Commands.InvokeRestMethodCommand

Answer 1

尝试将内容类型更改为"多部分/表单数据"

$headers.Add('Content-Type','multipart/form-data')
$UploadBody = @{
    'table_name'='incident'; 
    'record_sys_id'=$sys_id;
    'uploadFile' = 'C:Userssuganthanraj.pDocumentsServers.csv'
}

错误显示"远程服务器返回错误：（415） 不支持媒体类型。

可以在这里找到 API 上的 Doco：

https://docs.servicenow.com/bundle/geneva-servicenow-platform/page/integrate/inbound_rest/reference/r_AttachmentAPI-POSTmultipart.html

Answer 2

最好的选择是利用ServiceNow中的OOB Attachment API。 您需要从Powershell进行后期呼叫。 Powershell有两个选项用于此Invoke-RestMethod和Invoke-WebRequest。 在尝试开机自检时，我对后者的运气更好。 您也可以先在Postman中构建休息调用，确保可以将附件放入ServiceNow，然后担心编写PS。

$Body = @{
User = 'jdoe'
password = 'P@S$w0rd!'
}
$LoginResponse = Invoke-WebRequest 'http://www.contoso.com/login/' - SessionVariable 'Session' -Body $Body -Method 'POST'
$Session
$ProfileResponse = Invoke-WebRequest 'http://www.contoso.com/profile/' -`WebSession $Session $ProfileResponse`

Answer 3

最后我从下面的链接中找到了答案

https://community.servicenow.com/community?id=community_question&sys_id=d3707023dbaceb8023f4a345ca961949 及以下为代码：

 # Eg. User name="admin", Password="admin" for this code sample.
 $user = "admin"
 $pass = "XXX"
 # Build auth header
 $base64AuthInfo = [Convert]::ToBase64String([Text.Encoding]::ASCII.GetBytes(("{0}:{1}" -f $user, $pass)))
# Set proper headers
$headers = New-Object "System.Collections.Generic.Dictionary[[String],[String]]"
$headers.Add('Authorization',('Basic {0}' -f $base64AuthInfo))
$headers.Add('Accept','application/json')
$headers.Add('Content-Type','application/json')

# Specify endpoint uri
$uri = "https://dev652XX.service-now.com/api/now/attachment/file?table_name=incident&table_sys_id=850XXXXX2200e0ef563dbb9a71c1&file_name=TreeSizeReport.csv"
# Specifiy file to attach
$fileToAttach = "C:Userssuganthanraj.pDesktopTreeSizeReport.csv"
# Specify HTTP method (POST, PATCH, PUT)
$method = "POST"
# Send HTTP request
$response = Invoke-WebRequest -Headers $headers -Method $method -Uri $uri -InFile $fileToAttach
# Print response
$response.RawContent