Events HyperSQL DB? Virtualize Server events are published using a JMS broker, not a HyperSQL DB. For JMS connection info, see Integrating a Third-Party Monitoring System with Virtualize Event Monitoring
You may also consider posting your question to the Virtualize forum next time.
One idea would be to rename the "reqcmMacAddress" field using an extension tool. A script could do a simple string replacement on the text in the outgoing response using the value from the data bank.
To do this attach an extension tool to the outgoing response. Get the desired value from the data bank and then do a string replace. The method should then return the newly modified response message.
See this documentation for how to access a data bank value from a scripthttps://docs.parasoft.com/display/SOAVIRT9103CTP310/Extensibility+and+Scripting+Basics#ExtensibilityandScriptingBasics-AccessingDataSourcesfromScripts
I was able to reproduce what you are seeing. It seems when the data repository is in use then the field name does not get parameterized. You will probably have to remove the data repository data source entirely to be able to get the parameterization of the field name to work.
Would you be able to share an example pva file? When I set up an example using data banks it works, the field gets parameterized. What version of Virtualize are you using?
When using the data repository the columns often indicate hierarchy rather than actual data values. In this case, the "ParasoftColumn" being set to "cmMacAddress" means that in the data repository there is a list field that is controlling how many occurrences of the JSON object should be written. So using that to parameterize a field name is not going to work because there is no text data value associated with that column.
I tested that when not using a data repository data source I was able to parameterize the field name to a column name.
Do you have to use a data repository for this use case or can a table data source be used instead? If you have to use a data repository data source look for a column on the parent record that referss the "cmMacAddress" field. It may be possible to use a data column on the parent record to parameterize the field name.
I notice that there is a field named "ParasoftColumn" in the original literal payload. Is the responder using a Data Repository Data Source?
This is something that you should bring up with our support team.
They will instruct you in how to create a detailed Insure log, which you would then send to them, and they will help you diagnose the problem.
Awesome! Glad that works!