I`m trying to get table information using PowerShell stored in the MIDServer.
It performs fine on development and testing instances, but gives an error on production instances.
I was able to register an ECC Queue with Servicenow and run PowerShell,
but an error occurred when sending an API request from MidServer to Servicenow, and processing was not possible.
The error message I'm encountering is: "remote name can not be resolved"
I've also verified that the URL, API user and user permissions are correct.
I also confirmed that the scripts stored in MidServer function normally when executed from a PC.
I can't pinpoint the cause, I'd appreciate some help.
$INSTANCE = $args[0]
$TABLE_NAME = $args[1]
$QUERY = $args[2]
Write-Host "Instance: ${INSTANCE}, Table Name: ${TABLE_NAME}, Query: ${QUERY}"
# folder_path
$FOLDER_PATH = ""
# SSL/TLS
[Net.ServicePointManager]::SecurityProtocol = @([Net.SecurityProtocolType]::Ssl3,[Net.SecurityProtocolType]::Tls,
[Net.SecurityProtocolType]::Tls11,[Net.SecurityProtocolType]::Tls12)
# Base64
$head_auth = @{
Authorization= "Basic Base64="
}
# conf table
$table_folder_path = Join-Path $FOLDER_PATH $TABLE_NAME
try {
if ( -not ( Test-Path $table_folder_path ) ) {
Write-Host "We have not a Table directory and make directory."
New-Item -Path $table_folder_path -ItemType Directory
}
}
catch {
Write-Host "Error make a table directory: $_"
}
# get table sysid
try {
if ( $QUERY -eq "none" ) {
Write-Host "Wa are going to download attachments of all records."
$response = Invoke-WebRequest -Uri "https://${INSTANCE}.service-now.com/api/now/table/${TABLE_NAME}?sysparm_fields=sys_id"`
-Method "GET"`
-Headers $head_auth
}
else {
Write-Host "Wa are going to download attachments of query records."
$response = Invoke-WebRequest -Uri "https://${INSTANCE}.service-now.com/api/now/table/${TABLE_NAME}?sysparm_query=${QUERY}&sysparm_fields=sys_id"`
-Method "GET"`
-Headers $head_auth
}
$stream = $response.RawContentStream
$reader = New-Object System.IO.StreamReader($stream, [System.Text.Encoding]::UTF8)
$json = $reader.ReadToEnd()
$reader.Close()
$response.RawContentStream.Close()
$records_json = $json | ConvertFrom-Json
}
catch {
Write-Host "Error get table info： $_"
return
}
