FSM Connect - Substitution Variable in Message Routing

Hi @SAMLK,

What Execution Point would you use for that? I’m assuming ‘On Mapping’.

If so, the process is in place on the map, and checking the logging I cannot see that being fired.

Ady

Hi Ady,

Yes I would use On Mapping. Could you share the xml map with the header and process if possible?

@SAMLK 

I didn’t think I needed a Process Argument as the SQL script in the function is bringing back a single value.

Therefore its a pretty simple process.

The Message Routing and Function are unchanged from the above.

Thank you

Ady

Hi Ady,

If your SQL query "select token from AW_LANDSCAPE_TOKEN" returns only one record, you don't need a process argument. For multiple values, you can either hardcode them in the SQL or use a process argument. To troubleshoot, change the execution point to "on mapping," set the primary table to "request," and enable "always" logging. Then check if you can see any observations.

Make sure to refresh the integration cache and server cache.

@SAMLK 

Configuring the Process to call the call SQL correctly with the correct table name has done the trick.

I am now getting a valid response.

Thank you

Ady