Single and double quotation marks for Command handler

[sucremad]

Hi,

I want to write multiline command, but it does not work. I thought it may because of the syntax and tried writing differently the quotation marks to fix but could not make it. Command works normally via cli and ghost user is the same. Here is the json file:

{
    "Id": "ae2ff2b6-4a01-4253-9dfa-e6f98f433d7b",
    "Status": "Run",
    "TimeLineHandlers": [
        {
            "HandlerType": "Command",
            "Initial": "",
            "UtcTimeOn": "00:00:00",
            "UtcTimeOff": "24:00:00",
            "Loop": false,
            "TimeLineEvents": [
                {
                    "Command": "cd C:\\Users\\<username>\\Desktop",
                    "CommandArgs": [
                        "powershell $password = '<password>' | ConvertTo-SecureString -AsPlainText -Force; $username = '<username>'; $credential = New-Object System.Management.Automation.PSCredential ($username, $password); Invoke-Command -Credential $credential -ScriptBlock { $query = 'INSERT INTO <table> (col1, col2) VALUES (\"val1\", \"val2\")'; Invoke-Sqlcmd -ServerInstance localhost -Database <database> -Query $query } -ComputerName '<servername>'"
                    ],
                    "DelayAfter": 10,
                    "DelayBefore": 10000
                }
            ]
        }
    ]
}

How should I write this command? Could you please help?

[sei-dupdyke]

Would you please post up the command as it works in PowerShell (with the relevant line breaks) and I will have a look - thank you!

[sucremad]

Hi,

My oneliner command that works:

$password = "<password>" | ConvertTo-SecureString -asPlainText -Force; $username = "<username>"; $credential = New-Object System.Management.Automation.PSCredential ($username, $password); Invoke-Command -Credential $credential -ScriptBlock { $query = " INSERT INTO <table> (<col1>, <col2>, <col3>, <col4>, <col5>) VALUES (<val1>, '<val2>', '<val3>', '<val4>', '<val5>')"; Invoke-Sqlcmd -ServerInstance localhost -Database <db> -Query $query } -computername "<server>"

here is the line by line version:

$password = "<password>" | ConvertTo-SecureString -asPlainText -Force; 
$username = "<username>"; 
$credential = New-Object System.Management.Automation.PSCredential ($username, $password); 
Invoke-Command -Credential $credential -ScriptBlock { 
    $query = " INSERT INTO <table> (<col1>, <col2>, <col3>, <col4>, <col5>) VALUES (<val1>, '<val2>', '<val3>', '<val4>', '<val5>')"; 
    Invoke-Sqlcmd -ServerInstance localhost -Database <db> -Query $query 
} -computername "<server>"

Thank you!

[sei-dupdyke]

We need to escape the inner double quotes and ensure the command is correctly formatted as a single string, something like this:

{
    "Status": "Run",
    "TimeLineHandlers": [
        {
            "HandlerType": "Command",
            "Initial": "",
            "UtcTimeOn": "00:00:00",
            "UtcTimeOff": "24:00:00",
            "Loop": "False",
            "TimeLineEvents": [
                {
                    "Command": "once",
                    "CommandArgs": [
                        "powershell -command $password = \"<password>\" | ConvertTo-SecureString -asPlainText -Force; $username = \"<username>\"; $credential = New-Object System.Management.Automation.PSCredential ($username, $password); Invoke-Command -Credential $credential -ScriptBlock { $query = \" INSERT INTO <table> (<col1>, <col2>, <col3>, <col4>, <col5>) VALUES (<val1>, '<val2>', '<val3>', '<val4>', '<val5>')\"; Invoke-Sqlcmd -ServerInstance localhost -Database <db> -Query $query } -computername \"<server>\"\n"
                    ],
                    "DelayAfter": 0,
                    "DelayBefore": 0
                }
            ]
        }
    ]
}

There are some tools that can help jsonify that string. You might use python or some online tool such as https://codebeautify.org/jsonify-string.