App Connect

Hi Team,

How to access the EnvironmentVariables: from server.conf.yaml file into esql.

Hi Ravi

You can get whatever you want from a java compute node, there you can just request environment variables with the standard java api

String value_name = System.getEnv(key_of_variable);

Depending on your use case,  you can also access them on the mqinput node

the "encodedvar" being the name of the variable you want to use there.

Hi Team,

How to access the EnvironmentVariables: from server.conf.yaml file into esql.

what is the Xpath used in Esql for accessing the below section variable (EnvironmentVariables:) from the server.conf.yaml from the execution group , attached below screen shot 

EnvironmentVariables:
  ENV_VAR_ONE: 'env_var_one_value'    --> How to access this variable in Esql or what is the usecase in the server.conf.yaml

Hi Ravi

You can get whatever you want from a java compute node, there you can just request environment variables with the standard java api

String value_name = System.getEnv(key_of_variable);

Depending on your use case,  you can also access them on the mqinput node

the "encodedvar" being the name of the variable you want to use there.

Hi Team,

How to access the EnvironmentVariables: from server.conf.yaml file into esql.

Hi Ravi

I don't beleive it is meant to be used that way. Have a look here: https://www.ibm.com/docs/en/app-connect/12.0?topic=servers-configuring-independent-integration-server-startup-script

As you can see from my screenshot in the previous post, you can access them from the mqinput node.

If you want to access env variables from anywhere in your flow you can always create a java function

And an esql function that point to that java function

CREATE FUNCTION readEnvVar(IN varName CHARACTER)
    RETURNS CHARACTER
    LANGUAGE JAVA
    EXTERNAL NAME "ReadEnvVar_ReadEnvVar.getVar";

So you can use it anywhere in esql like so

CREATE FUNCTION Main() RETURNS BOOLEAN
    BEGIN
        CALL CopyEntireMessage();
        SET OutputRoot.JSON.Data.Result = readEnvVar(InputRoot.JSON.Data.Request);
        RETURN TRUE;
    END;

It works for any env var specified in your server.conf.yaml

what is the Xpath used in Esql for accessing the below section variable (EnvironmentVariables:) from the server.conf.yaml from the execution group , attached below screen shot 

EnvironmentVariables:
  ENV_VAR_ONE: 'env_var_one_value'    --> How to access this variable in Esql or what is the usecase in the server.conf.yaml

Hi Ravi

You can get whatever you want from a java compute node, there you can just request environment variables with the standard java api

String value_name = System.getEnv(key_of_variable);

Depending on your use case,  you can also access them on the mqinput node

the "encodedvar" being the name of the variable you want to use there.

Hi Team,

How to access the EnvironmentVariables: from server.conf.yaml file into esql.

Hi Ravi

I don't beleive it is meant to be used that way. Have a look here: https://www.ibm.com/docs/en/app-connect/12.0?topic=servers-configuring-independent-integration-server-startup-script

As you can see from my screenshot in the previous post, you can access them from the mqinput node.

If you want to access env variables from anywhere in your flow you can always create a java function

And an esql function that point to that java function

CREATE FUNCTION readEnvVar(IN varName CHARACTER)
    RETURNS CHARACTER
    LANGUAGE JAVA
    EXTERNAL NAME "ReadEnvVar_ReadEnvVar.getVar";

So you can use it anywhere in esql like so

CREATE FUNCTION Main() RETURNS BOOLEAN
    BEGIN
        CALL CopyEntireMessage();
        SET OutputRoot.JSON.Data.Result = readEnvVar(InputRoot.JSON.Data.Request);
        RETURN TRUE;
    END;

It works for any env var specified in your server.conf.yaml

what is the Xpath used in Esql for accessing the below section variable (EnvironmentVariables:) from the server.conf.yaml from the execution group , attached below screen shot 

EnvironmentVariables:
  ENV_VAR_ONE: 'env_var_one_value'    --> How to access this variable in Esql or what is the usecase in the server.conf.yaml

Hi Ravi

You can get whatever you want from a java compute node, there you can just request environment variables with the standard java api

String value_name = System.getEnv(key_of_variable);

Depending on your use case,  you can also access them on the mqinput node

the "encodedvar" being the name of the variable you want to use there.

Hi Team,

How to access the EnvironmentVariables: from server.conf.yaml file into esql.

Hi Ravi

I don't beleive it is meant to be used that way. Have a look here: https://www.ibm.com/docs/en/app-connect/12.0?topic=servers-configuring-independent-integration-server-startup-script

As you can see from my screenshot in the previous post, you can access them from the mqinput node.

If you want to access env variables from anywhere in your flow you can always create a java function

And an esql function that point to that java function

CREATE FUNCTION readEnvVar(IN varName CHARACTER)
    RETURNS CHARACTER
    LANGUAGE JAVA
    EXTERNAL NAME "ReadEnvVar_ReadEnvVar.getVar";

So you can use it anywhere in esql like so

CREATE FUNCTION Main() RETURNS BOOLEAN
    BEGIN
        CALL CopyEntireMessage();
        SET OutputRoot.JSON.Data.Result = readEnvVar(InputRoot.JSON.Data.Request);
        RETURN TRUE;
    END;

It works for any env var specified in your server.conf.yaml

what is the Xpath used in Esql for accessing the below section variable (EnvironmentVariables:) from the server.conf.yaml from the execution group , attached below screen shot 

EnvironmentVariables:
  ENV_VAR_ONE: 'env_var_one_value'    --> How to access this variable in Esql or what is the usecase in the server.conf.yaml

Hi Ravi

You can get whatever you want from a java compute node, there you can just request environment variables with the standard java api

String value_name = System.getEnv(key_of_variable);

Depending on your use case,  you can also access them on the mqinput node

the "encodedvar" being the name of the variable you want to use there.

Hi Team,

How to access the EnvironmentVariables: from server.conf.yaml file into esql.

Hi Ravi

You can get whatever you want from a java compute node, there you can just request environment variables with the standard java api

String value_name = System.getEnv(key_of_variable);

Depending on your use case,  you can also access them on the mqinput node

the "encodedvar" being the name of the variable you want to use there.

Hi Team,

How to access the EnvironmentVariables: from server.conf.yaml file into esql.

Any document shows that how the environment variable being used in the node properties like this way?

Hi Ravi

You can get whatever you want from a java compute node, there you can just request environment variables with the standard java api

String value_name = System.getEnv(key_of_variable);

Depending on your use case,  you can also access them on the mqinput node

the "encodedvar" being the name of the variable you want to use there.

Hi Team,

How to access the EnvironmentVariables: from server.conf.yaml file into esql.