$Процедуры =
'Продажи'

foreach ($п in $Процедуры)
{
    Clear-Host
    $conn = New-Object System.Data.SqlClient.SqlConnection("Data Source=s; User ID=u; Password=p; Initial Catalog=b; Integrated Security=SSPI")
    $conn.Open()

    $Запрос = $П1 + $п + $П2 + $П3 + $П4
	$Результат = Invoke-RestMethod $Запрос -Credential $cred -TimeoutSec 6000

    $cmd = $conn.CreateCommand()
    $cmd.CommandText ="INSERT INTO [dbo].[temp_request] ([JSON_string],[mark]) VALUES ('"+ $Результат +"','"+$п+"')"
    $cmd.ExecuteNonQuery()
    $conn.Close()
}

$ЗапросСтатьи = 'Выбрать Код Ссылка  Из Справочник'
$ЗапросСтатьи = $link + $ЗапросСтатьи
 $a = Invoke-RestMethod $ЗапросСтатьи -Credential $cred -TimeoutSec 600

 Clear-Host
$conn = New-Object System.Data.SqlClient.SqlConnection("Data Source=s; User ID=u; Password=p; Initial Catalog=b; Integrated Security=SSPI")
$conn.Open()

$cmd = $conn.CreateCommand()
$cmd.CommandText ="INSERT INTO [dbo].[temp_1C_request] ([JSON_string],[mark]) VALUES ('"+ $a +"','Статьи')"
$cmd.ExecuteNonQuery()

$conn.Close()
 

foreach ($п in $Процедуры)
{
    $Запрос = $П1 + $п + $П2 + $П3 + $П4
	$file =  'C:\BIprojects\exim.json'
	$a = Invoke-RestMethod $Запрос -Credential $cred -OutFile $file  -TimeoutSec 6000
    $b = Get-Content  -Path $file -Encoding UTF8
    $b = $b -replace "'" , ""

    Clear-Host
    $conn = New-Object System.Data.SqlClient.SqlConnection("Data Source=s; User ID=u; Password=p; Initial Catalog=b; Integrated Security=SSPI")
    $conn.Open()
       $cmd = $conn.CreateCommand()
       $cmd.CommandText ="INSERT INTO [dbo].[temp_request] ([JSON_string],[mark]) VALUES ('"+ $b +"','"+$п+"')"
       $cmd.ExecuteNonQuery()
    $conn.Close()

    Remove-Item  $file
}

$Результат = Invoke-RestMethod $Запрос -Credential $cred -TimeoutSec 6000 | ConvertFrom-Json

foreach ($п in $Процедуры)
{
    $Запрос = $П1 + $п + $П2 + $П3 + $П4
	$a = Invoke-RestMethod $Запрос -Credential $cred  -TimeoutSec 6000 | ConvertFrom-Json
    $b = $a -replace "'" , ""

    Clear-Host
    $conn = New-Object System.Data.SqlClient.SqlConnection("Data Source=s; User ID=u; Password=p; Initial Catalog=b; Integrated Security=SSPI")
    $conn.Open()
       $cmd = $conn.CreateCommand()
       $cmd.CommandText ="INSERT INTO [dbo].[temp_1C_request] ([JSON_string],[mark]) VALUES ('"+ $b +"','"+$п+"')"
       $cmd.ExecuteNonQuery()
    $conn.Close()

}

$conn = New-Object System.Data.SqlClient.SqlConnection("Data Source=s; User ID=u; Password=p; Initial Catalog=b; Integrated Security=SSPI")
$conn.Open()
$cmd = $conn.CreateCommand()

foreach ($п in $Процедуры)
{
    $Запрос = $П1 + $п + $П2 + $П3 + $П4
    $a = Invoke-RestMethod $Запрос -Credential $cred  -TimeoutSec 6000 | ConvertFrom-Json
    $b = $a -replace "'" , ""

    Clear-Host
    $cmd.CommandText ="INSERT INTO [dbo].[temp_1C_request] ([JSON_string],[mark]) VALUES ('"+ $b +"','"+$п+"')"
    $cmd.ExecuteNonQuery()

}
$conn.Close()

foreach ($п in $Процедуры)
{
    $Запрос = $П1 + $п + $П2 + $П3 + $П4
	$a = Invoke-RestMethod $Запрос -Credential $cred  -TimeoutSec 6000 | Out-String | ConvertFrom-Json
    $b = $a -replace "'" , ""
    write-host $b

}

ConvertFrom-Json : Недопустимый примитив JSON: value.
+ ... | Out-String | ConvertFrom-Json