Cannot override global parameter with object type

[tanakornp]

I have been using datafactory.tools for a year and it has been great but I have just run into issue trying to override global parameter with object type. Here is the original json in the /factory/FACTORY_NAME.json

"P_GLBL_DB": { "type": "object", "value": { "SERVER_NM": "xxxxdev.database.windows.net", "DB_NM": "xxxxdev01", "USER_NM": "adfuser", "SECRET_NM": "SECRET_XXX" } }

I have put a line in environment config file and have tried several format (sample below) but no matter what I tried that global param was deployed with only structure but not value.

factory,FACTORY_NAME,"$.properties.globalParameters.'P_GLBL_DB'","{'type': 'object','value': {'SERVER_NM': 'xxxxdev.database.windows.net','DB_NM': 'xxxxdev01','USER_NM': 'adfuser','SECRET_NM': 'SECRET_XXX'}}"

factory,FACTORY_NAME,"$.properties.globalParameters.'P_GLBL_DB'.value","{'SERVER_NM':'database.database.windows.net','DB_NM':'xxxxdev01','USER_NM':'adfuser','SECRET_NM':'SECRET_XXX'}"

Here is what it looks like in ADF.

{"SERVER_NM":[],"DB_NM":[],"USER_NM":[],"SECRET_NM":[]}

Can anyone guide me on how to override value for Global parameter with object type ?

[tanakornp]

I finally can find the formula that make it work.

in csv put
factory,ADF-DEV,"$.properties.globalParameters.'P_GLBL_DB'.value",$($Env:P_GLBL_DB)

and in env var I put single quote in the value

'{ "SERVER_NM": "xxxxdev.database.windows.net", "DB_NM": "xxxxdev01", "USER_NM": "adfuser", "SECRET_NM": "SECRET_XXX" }'