Error in expression

Question

Hi All,
Can you please help me understand why I am getting the below errors while using the below expression?
Expression -
eval(“lib.environment.getAppConf(‘OracleEBS’).” + lib.parameters.getAppConf(‘parameters’).EBS_Instance + “.srcDB”)
Error -
failure:
“Unexpected error occurred while evaluating expression: lib.environment.getAppConf(‘OracleEBS’).FNDV.srcDB”
value:
“Please check your expression”
reason:
“Please check your expression”

viktor_n · Answer

Hi @amit.saroha,
Try instead of eval function to do it with square brackets.
I think that will work.
Like this:
lib.environment.getAppConf(‘OracleEBS’)[lib.parameters.getAppConf(‘parameters’).EBS_Instance]['srcDB']
Regards,
Viktor

amit_saroha · Answer

@viktor_n - Thank you, it worked but what I should do if I have to fetch value for any specific DB?

viktor_n · Answer

Can you explain it a little bit more what you want to achieve

amit_saroha · Answer

Hi Victor,
Enclosed are the expression files. What I want is to retrieve 4 values (say to pass in child pipelines or in some mapper) and I am trying to do it as below but my expressions are failing. You already helped me to correct one of them.
What I want is that if I am in Dev then the expression must return dev configuration values and when in prod then prod values.
I would truly appreciate if you can help me doing so.

Database_Account

Oracle_Cloud_Soap_Account

HCM_Flow_Service_WSDL

Generic_Soap_WSDL

eval(“lib.environment.getAppConf(‘OracleEBS’).” + lib.parameters.getAppConf(‘parameters’).EBS_Instance + “.srcDB”)

eval(“lib.environment.getAppConf(‘HCMCloud’).” + (lib.parameters.getAppConf(‘parameters’).HCM_Cloud_Instance) + “.Soap_Account”)

eval(“lib.environment.getAppConf(‘HCMCloud’).”+ (lib.parameters.getAppConf(‘parameters’).HCM_Cloud_Instance) +“.URL”) + lib.parameters.getAppConf(‘parameters’).HCM_Flow_Service_WSDL_URL

eval(“lib.environment.getAppConf(‘HCMCloud’).”+ (lib.parameters.getAppConf(‘parameters’).HCM_Cloud_Instance) +“.URL”) + lib.parameters.getAppConf(‘parameters’).Generic_Soap_WSDL_URL

HCM_Interface_config.expr (1.3 KB)
HCM_Interface_Processes.expr (695 Bytes)
config.expr (3.6 KB)

amit_saroha · Answer

@viktor_n - Could you please help me here?

Forum Discussion

Error in expression

5 Replies

Recent Discussions

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?

Multipart Reader failure - 'content-type' was not found

Unable to write sldb file to file system