File format acceptable structure
These are given the file formats for the environment variables.
Supported format 1 (JSON format):
[{ "keyName": "Mysql_Connection_String",
"type": "normal",
"keyValue": "jdbc:sqlserver://localhost;databaseName=DbName;user=MyUserName;password=*****;"
},
{ "paramName": "AzQueue_Conn_String",
"type": "secured",
"paramValue": "DefaultEndpointsProtocol=https;AccountName=storageaccnt2508;AccountKey=z4zvWOWMVweXrD6vhUeFQh8I+AStPzq/9w==;EndpointSuffix=core.windows.net"
}]
Supported format 2 (CSV Format):
"Mysql_Connection_String": "normal##jdbc:sqlserver://localhost;databaseName=DbName;user=MyUserName;password=*****;" , "AzQueue_Conn_String":"secured## DefaultEndpointsProtocol=https;AccountName=storageaccnt2508;AccountKey=z4zvWOWMVweXrD6vhUeFQh8I+AStPzq/9w==;EndpointSuffix=core.windows.net"
Important note: Either entire or part of parameter value can be dynamic in nature (e.g. url, hostname, db name/port etc). In such cases the value can be stored in as Project /Environment properties and the placeholder can be added in file as shown below. In case the values are provided the placeholder would be replaced with actual value during deployment. The same implementation will be applicable while passing the input through input as well.
JSON format:
[{ "paramName": "Mysql_Connection_String",
"type": "mysql",
"paramValue": "jdbc:sqlserver://${{SQL_DB_ENVWISE_HOST}};databaseName=DbName;user=MyUserName;password=*****;"
},
{ "paramName": "AzQueue_Conn_String",
"type": "custom",
"paramValue": "DefaultEndpointsProtocol=https;AccountName=${{Storage_Account_Name}};AccountKey=z4zvWOWMVweXrD6vhUeFQh8I+AStPzq/9w==;EndpointSuffix=core.windows.net"
}]
CSV Format:
"Mysql_Connection_String": "mysql##jdbc:sqlserver://${{SQL_DB_ENVWISE_HOST}};databaseName=DbName;user=MyUserName;password=*****;" , "AzQueue_Conn_String":"custom## DefaultEndpointsProtocol=https;AccountN
Input argument acceptable structure
Any entry to Application Setting or Connection String as workflow input would work in upsert mode. They will be added along with the entries present as part of the Application Setting File/Connection Setting File. However, in case of the same value present in both, an entry made through input argument will take precedence over any value in the case provided through files in Project properties.
Below are given Input argument formats for the environment variables.
Input (JSON format):
[
{
"paramName": "Mysql_Connection_String",
"type": "mysql",
"paramValue": "jdbc:sqlserver://localhost;databaseName=DbName;user=MyUserName;password=*****;"
},
{
"paramName": "AzQueue_Conn_String",
"type": "custom",
"paramValue": "DefaultEndpointsProtocol=https;AccountName=storageaccnt2508;AccountKey=z4zvWOWMVweXrD6vhUeFQh8I+AStPzq/9w==;EndpointSuffix=core.windows.net"
}
]
Input (csv Format):
"Mysql_Connection_String": "mysql##jdbc:sqlserver://localhost;databaseName=DbName;user=MyUserName;password=*****;" , "AzQueue_Conn_String":"custom## DefaultEndpointsProtocol=https;AccountName=storageaccnt2508;AccountKey=z4zvWOWMVweXr