topic [resolved] Problem with Simple in Talend Studio

[resolved] Problem with Simple

hvanderheyden — Sat, 16 Nov 2024 11:36:37 GMT

Hello,
I'have somes trouble with Simple code.
We're using AMQ to transit XML message to process:

<?xml version="1.0"?>
<response>
	<sender>CP2</sender>
	<method>createThreshold</method>
	<userId>monmail@mondomaine.fr</userId>
	<threshold>
		<oldId>SA01</oldId>
		<startDate>1996-01-01</startDate>
		<endDate>1996-12-31</endDate>
		<amount>78,206.35</amount>
	</threshold>
</response>

I would like create a simple expression to process "method" field when the value is 'createThreshold'. So i've written the following expression

"${body.response.method} == 'createThreshold'"

At the route execution, i've that stacktrace in log:

Démarrage du job QueueRouter a 11:22 20/06/2014.
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Fou

To see the whole post, download it here

Re: [resolved] Problem with Simple

Anonymous — Fri, 20 Jun 2014 15:54:42 GMT

Hi Hervé,
Simple doesn't understand XML - that syntax works when the body is a Java Bean instead of just a String of XML. The most direct way to do this with your XML is to use XPath rather than Simple. I'll give you a couple of options.
Option 1: Just use XPath
For your predicates on your router paths, you can select the XPath language. Select it and use an XPath expression something like this:
"/response/method"
and
"/response/method"

Option 2: Pull value with XPath, evaluate with Simple
Step 1: Add a cSetHeader component after your JMS listener and add a property to be set
- Choose the XPath Language
- Name the new header property (for instance, Response_Method)
- Set the expression to: "/response/method/text()"
Step 2: Evaluate with Simple
- In your Router predicate choose the Simple language
- Set it like this: "${header.Response_Method} == 'createThreshold'"

Deciding which option is better really depends on your end use case, but either should get the job done
Best Regards,
Ben

Re: [resolved] Problem with Simple

hvanderheyden — Mon, 23 Jun 2014 09:11:36 GMT

Hi Ben,
Thanks for your answser. I will using xpath expression.
I was looking for the best method to evalute the method tag content, that can contains values like "*Threshold". I knew how doing that with simple... now i'know with xpath

"response/method"

Regards