Azure DataFactory V2: Use SecureString Parameter in dynamic content

Question

I have a secure string parameter in data fatory

According to another post this is the way to access said parameter

@{pipeline().parameters.ChassisSqlUsername.value}

This use to and still give a validation error within the dynamic content window:

However the pipeline worked like this without issue. This validation error did not block publishing.

Asof today I can no longer publish if that validation error is present

How do I get around this?

Answer 1

I don't know why the syntax of ADF is so terrible.

@{json(string(pipeline().parameters.ChassisSqlUsername)).value}

Answer 2

Refer it in this way:

@{pipeline().parameters.ChassisSqlUsername}

It will work.