...
| Table of Contents |
|---|
File Format Acceptable Structure
These are given the accepted file formats for the environment variables.
Supported
...
Format 1 (JSON
...
)
...
| Code Block |
|---|
[{ "keyName": "Mysql_Connection_String",
"typesecured": "normal"false,
"keyValue": "jdbc:sqlserver://localhost;databaseName=DbName;user=MyUserName;password=*****;"
},
{ "paramNamekeyName": "AzQueueQueue_Conn_String",
"typesecured": "secured"true,
"paramValuekeyValue": "DefaultEndpointsProtocol=https;AccountName=storageaccnt2508;AccountKey=z4zvWOWMVweXrD6vhUeFQh8I+AStPzq/9w==;EndpointSuffix=core.windows.net"
}] |
Supported
...
Format 2 (CSV
...
)
...
| Code Block |
|---|
"Mysql_Connection_String": "normal##jdbcfalse##jdbc:sqlserver://localhost;databaseName=DbName;user=MyUserName;password=*****;" , "AzQueueQueue_Conn_String":"secured##true## DefaultEndpointsProtocol=https;AccountName=storageaccnt2508;AccountKey=z4zvWOWMVweXrD6vhUeFQh8I+AStPzq/9w==;EndpointSuffix=core.windows.net" |
...
JSON format:
| Code Block |
|---|
[{ "paramNamekeyName": "Mysql_Connection_String",
"typesecured": "mysqlfalse",
"paramValuekeyValue": "jdbc:sqlserver://${{SQL_DB_ENVWISE_HOST}};databaseName=DbName;user=MyUserName;password=*****;"
},
{ "paramNamekeyName": "AzQueueQueue_Conn_String",
"typesecured": "customtrue",
"paramValuekeyValue": "DefaultEndpointsProtocol=https;AccountName=${{Storage_Account_Name}};AccountKey=z4zvWOWMVweXrD6vhUeFQh8I+AStPzq/9w==;EndpointSuffix=core.windows.net"
}] |
...
| Code Block |
|---|
"Mysql_Connection_String": "mysql##jdbcfalse##jdbc:sqlserver://${{SQL_DB_ENVWISE_HOST}};databaseName=DbName;user=MyUserName;password=*****;" , "AzQueueQueue_Conn_String":"custom##true## DefaultEndpointsProtocol=https;AccountN |
Input
...
Argument Acceptable Structure
Any entry to Application Setting or Connection String environment variables 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 environment variables 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
Supported Format 1 (JSON
...
)
...
| Code Block |
|---|
[
{
"paramNamekeyName": "Mysql_Connection_String",
"typesecured": "mysqlfalse",
"paramValuekeyValue": "jdbc:sqlserver://localhost;databaseName=DbName;user=MyUserName;password=*****;"
},
{
"paramNamekeyName": "AzQueueQueue_Conn_String",
"typesecured": "customtrue",
"paramValuekeyValue": "DefaultEndpointsProtocol=https;AccountName=storageaccnt2508;AccountKey=z4zvWOWMVweXrD6vhUeFQh8I+AStPzq/9w==;EndpointSuffix=core.windows.net"
}
] |
...
Supported Format 2 (CSV)
| Code Block |
|---|
"Mysql_Connection_String": "mysql##jdbcfalse##jdbc:sqlserver://localhost;databaseName=DbName;user=MyUserName;password=*****;" , "AzQueueQueue_Conn_String":"custom##true## DefaultEndpointsProtocol=https;AccountName=storageaccnt2508;AccountKey=z4zvWOWMVweXr |
...