Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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=*****;"
},
{   "keyName": "Queue_Conn_String",
   "typesecured": "secured"true,
    "keyValue": "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=*****;" , "Queue_Conn_String":"secured##true## DefaultEndpointsProtocol=https;AccountName=storageaccnt2508;AccountKey=z4zvWOWMVweXrD6vhUeFQh8I+AStPzq/9w==;EndpointSuffix=core.windows.net"

...

Code Block
[{   "keyName": "Mysql_Connection_String",
   "typesecured": "normalfalse",
   "keyValue": "jdbc:sqlserver://${{SQL_DB_ENVWISE_HOST}};databaseName=DbName;user=MyUserName;password=*****;"
},
{   "keyName": "Queue_Conn_String",
   "typesecured": "securedtrue",
    "keyValue": "DefaultEndpointsProtocol=https;AccountName=${{Storage_Account_Name}};AccountKey=z4zvWOWMVweXrD6vhUeFQh8I+AStPzq/9w==;EndpointSuffix=core.windows.net"

}]

...

Code Block
"Mysql_Connection_String": "normal##jdbcfalse##jdbc:sqlserver://${{SQL_DB_ENVWISE_HOST}};databaseName=DbName;user=MyUserName;password=*****;" , "Queue_Conn_String":"secured##true## DefaultEndpointsProtocol=https;AccountN

Input

...

Argument Acceptable Structure

Any entry to environment variables as workflow input would work in upsert mode. They will be added along with the entries present as part of the 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
[
{
   "keyName": "Mysql_Connection_String",
   "typesecured": "normalfalse",
   "keyValue": "jdbc:sqlserver://localhost;databaseName=DbName;user=MyUserName;password=*****;"
},
{
   "keyName": "Queue_Conn_String",
   "typesecured": "securedtrue",
    "keyValue": "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=*****;" , "Queue_Conn_String":"secured##true## DefaultEndpointsProtocol=https;AccountName=storageaccnt2508;AccountKey=z4zvWOWMVweXr

...