Custom solution (I haven't tested this though)
1) create a csv file with these columns
2) then write powershell script and have admin credentials, instance endpoint ready
I took help of AI to get the powershell script
Note: I assume all files are in path C:\Users\Arkesh\Downloads
attachment_map.csv file is stored in the C:\Temp folder
$instance = "https://yourinstance.service-now.com"
$username = "admin"
$password = "your_password"
$csvPath = "C:\Temp\attachment_map.csv"
$baseFolder = "C:\Users\Arkesh\Downloads"
$pair = "$username`:$password"
$encodedCreds = [Convert]::ToBase64String([System.Text.Encoding]::ASCII.GetBytes($pair))
$headers = @{
Authorization = "Basic $encodedCreds"
Accept = "application/json"
}
$rows = Import-Csv $csvPath
foreach ($row in $rows) {
$tableName = $row.table_name.Trim()
$sysId = $row.table_sys_id.Trim()
$fileName = $row.file_name.Trim()
$filePath = Join-Path $baseFolder $fileName
if (-not (Test-Path $filePath)) {
Write-Host "File not found: $filePath" -ForegroundColor Yellow
continue
}
$encodedFileName = [System.Uri]::EscapeDataString($fileName)
$uri = "$instance/api/now/attachment/file?table_name=$tableName&table_sys_id=$sysId&file_name=$encodedFileName"
try {
$response = Invoke-RestMethod `
-Uri $uri `
-Method Post `
-Headers $headers `
-InFile $filePath `
-ContentType "application/octet-stream"
Write-Host "Uploaded: $fileName -> $tableName / $sysId" -ForegroundColor Green
}
catch {
Write-Host "Failed: $fileName -> $tableName / $sysId" -ForegroundColor Red
Write-Host $_.Exception.Message -ForegroundColor Red
}
}💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏
