Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 11 Next »

File format acceptable structure

These are given file formats for the environment variables.

Supported format 1 (JSON format)

[{   "keyName": "Mysql_Connection_String",
   "secured": false,
   "keyValue": "jdbc:sqlserver://localhost;databaseName=DbName;user=MyUserName;password=*****;"
},
{   "keyName": "Queue_Conn_String",
  "secured": true,
    "keyValue": "DefaultEndpointsProtocol=https;AccountName=storageaccnt2508;AccountKey=z4zvWOWMVweXrD6vhUeFQh8I+AStPzq/9w==;EndpointSuffix=core.windows.net"
}]

Supported format 2 (CSV Format)

"Mysql_Connection_String": "false##jdbc:sqlserver://localhost;databaseName=DbName;user=MyUserName;password=*****;" , "Queue_Conn_String":"true## 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:

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

}]

 CSV Format:

"Mysql_Connection_String": "false##jdbc:sqlserver://${{SQL_DB_ENVWISE_HOST}};databaseName=DbName;user=MyUserName;password=*****;" , "Queue_Conn_String":"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 (JSON format):

[
{
   "keyName": "Mysql_Connection_String",
   "secured": "false",
   "keyValue": "jdbc:sqlserver://localhost;databaseName=DbName;user=MyUserName;password=*****;"
},
{
   "keyName": "Queue_Conn_String",
   "secured": "true",
    "keyValue": "DefaultEndpointsProtocol=https;AccountName=storageaccnt2508;AccountKey=z4zvWOWMVweXrD6vhUeFQh8I+AStPzq/9w==;EndpointSuffix=core.windows.net"
}
]

Input (csv Format):

"Mysql_Connection_String": "false##jdbc:sqlserver://localhost;databaseName=DbName;user=MyUserName;password=*****;" , "Queue_Conn_String":"true## DefaultEndpointsProtocol=https;AccountName=storageaccnt2508;AccountKey=z4zvWOWMVweXr

  • No labels