Royal Apps

Hi!

you can specify the script parameters using a simple XML encoded string. Here's an example:

Line 4 to 18 in the screenshot above shows the XML which is expected by Royal TS/X. 

Line 1 shows the actual property value as XML encoded string.

You can create the following XML:

<?xml version="1.0" encoding="utf-16">
<ParamConfig xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    <ParamConfigItems>
        <ParamConfigItem>
            <ParameterName>Param1</ParameterName>
            <Value>$EffectiveUsername$</Value>
            <TestValue />
        </ParamConfigItem> 
        <ParamConfigItem>
            <ParameterName>Param2</ParameterName>
            <Value>Some Value</Value>
            <TestValue />
        </ParamConfigItem>
    </ParamConfigItems>
</ParamConfig>

Set this XML as XML encoded string to the Parameters property as described in the Advanced Scenarios topic:

https://docs.royalapps.com/r2021/scripting/rjson/advanced-scenarios.html

I hope this helps. I will also include the XML sample in the docs.

Regards,
Stefan

Hi Nino,

the sample I included in the docs is the very same as the one above. Do you still need assistance to incorporate this into your script?

Regards,
Stefan

Hi Nino,

you first need to create the XML according to your requirements. Once you have that, you need to encode the XML block into a XML-encoded string (like the line 1 in the screenshot). This string must then be added to the Properties -> Parameters property in the rJson (see https://docs.royalapps.com/r2021/scripting/rjson/advanced-scenarios.html)

I'm not a PowerShell expert. I guess you can use the XML powershell cmdlets to create the paramters XML and also use a cmdlet to encode it into a string. In C# I would youse the XmlTextWriter.WriteString method but there's probably a better way to do it in PowerShell.

Let me know if this helps. I'm currently quite busy and don't have much time to provide more details. If you need further help with that, I'm happy to dig deeper and provide a more complete sample.

Regards,
Stefan

Hi Nino,

I think I can see the confusion ;)

In my previous post, I showed you how to "build" the XML for each parameter. The XML must be inserted as "XML encoded string" into the json. Here's the example I used:

"Properties": {
    "Parameters": "<?xml version=\"1.0\" encoding=\"utf-16\"?><ParamConfig xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\" xmlns:xsd=\"http:\/\/www.w3.org\/2001\/XMLSchema\"><ParamConfigItems><ParamConfigItem><ParameterName>Param1<\/ParameterName><Value>$EffectiveUsername$<\/Value><TestValue \/><\/ParamConfigItem><ParamConfigItem><ParameterName>Param2<\/ParameterName><Value>Bla<\/Value><TestValue \/><\/ParamConfigItem><\/ParamConfigItems><\/ParamConfig>"
}

Does this help?

Regards,
Stefan

Hi again,

sorry this took so long. I was quite busy but I had some time today to take a closer look. Here's a quick summary what I found:

1. I was mistaken that the parameters XML must be an XML encoded string. It actually needs to be an escaped string for json.

2. The same applies to the script. New lines, etc. are not allowed. It must be escaped for json usage.

Here's a working example I just tested:

{
    "Objects": [
        {
            "Type": "Credential",
            "Name": "DEVuser",
            "Username": "User123",
            "Password": "mysecretpassword",
            "ID": "Dev1"
        },
        {
            "Type": "PowerShellConnection",
            "Name": "Powershell-Dev",
            "Computername": "localhost",
            "CredentialMode": 3,
            "CredentialID": "Dev1",
            "Description": "Dev connection",
            "Properties": {
                "DefaultOutput": 1,
                "CredentialAutologon": false,
                "Parameters": "<ParamConfig xmlns:xsi=\"http:\/\/www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org\/2001\/XMLSchema\">\n                    <ParamConfigItems>\n                        <ParamConfigItem>\n                            <ParameterName>Param1</ParameterName>\n                            <Value>$$EffectiveUsername$$</Value>\n                            <TestValue />\n                       </ParamConfigItem> \n                        <ParamConfigItem>\n                            <ParameterName>Param2</ParameterName>\n                            <Value>Some Value</Value>\n                            <TestValue />\n                        </ParamConfigItem>\n                    </ParamConfigItems>\n                </ParamConfig>"
            },
            "Script": "#Get RoyalTS Creds\nparam ([string] $uid,\n            [string] $userpw,\n            [string] $Param3)\n      Set-PSDebug -trace 1\nwrite-host $uid\nwrite-host $userpw\nWrite-host $Param3\nWrite-host $Param4\nwrite-host 'CredUser Name' $$CredentialUsername$$ \nwrite-host 'password' $$CredentialPassword$$\nwrite-host 'Effective user' $$Effectiveusername$$\n"
        }
    ]
}

Let me know if this works for you.

Regards,
Stefan

A quick tip: if you are using a code editor like VS Code you can easily spot issues with malformed json as it constantly validates your json as you type. There are also a lot of extensions which may be helpful, like this one: https://marketplace.visualstudio.com/items?itemName=joshuapoehls.json-escaper