Chapter 21. JsonPath Overview The JsonPath language provides a convenient syntax for extracting portions of a JSON message. The syntax of JSON is similar to XPath, but it is used to extract JSON objects from a JSON message, instead of acting on XML. The jsonpath DSL command can be used either as an expression or as a predicate (where an empty result gets interpreted as boolean false ). Adding the JsonPath package To use JsonPath in your Camel routes, you need to add a dependency on camel-jsonpath to your project, as follows: Java example The following Java example shows how to use the jsonpath() DSL command to select items in a certain price range: If the JsonPath query returns an empty set, the result is interpreted as false . In this way, you can use a JsonPath query as a predicate. XML example The following XML example shows how to use the jsonpath DSL element to define predicates in a route: Easy Syntax When you wish to define a basic predicate using jsonpath syntax it can be a bit hard to remember the syntax. For example, to find out all the cheap books, you have to write the syntax as follows: However, what if you could just write it as: You can also omit the path if you just want to look at nodes with a price key: To support this, there is a EasyPredicateParser which you use to define the predicate using a basic style. That means the predicate must not start with the USD sign, and must include only one operator. The easy syntax is as follows: You can use Camel simple language in the right operator, for example, Supported Message Body Types Camel JSonPath supports message body using the following types: Type Description File Reading from files String Plain strings Map essage body as java.util.Map type List Message body as java.util.List type POJO Optional If Jackson is on the classpath, then camel-jsonpath is able to use Jackson to read the message body as POJO and convert to java.util.Map which is supported by JSonPath. For example you can add camel-jackson as dependency to include Jackson. InputStream If none of the above types matches, then Camel will attempt to read the message body as an java.io.InputStream . If a message body is of unsupported type then an exception is thrown by default, however you can configure JSonPath to suppress exceptions. Suppress Exceptions JsonPath will throw an exception if the path configured by the jsonpath expression is not found. The exception can be ignored by setting the SuppressExceptions option to true. For example, in the code below, adding the true option as part of the jsonpath parameters: In XML DSL use the following syntax: JsonPath injection When using bean integration to invoke a bean method, you can use JsonPath to extract a value from the message and bind it to a method parameter. For example: Inline Simple Expressions New in Camel 2.18. Camel supports inline Simple expressions in the JsonPath expressions. The Simple language insertions must be expressed in Simple syntax as shown below: Turn off support for Simple expressions by setting the option allowSimple=false as shown below. Java: // Java DSL .when().jsonpath("USD.store.book[?(@.price < 10)]", false, false) XML DSL: // XML DSL <jsonpath allowSimple="false">USD.store.book[?(@.price &lt; 10)]</jsonpath> Reference For more details about JsonPath, see the JSonPath project page .

Commands:
<dependency> <groupId>org.apache.camel</groupId> <artifactId>camel-jsonpath</artifactId> <version>USD{camel-version}</version> </dependency>
from("queue:books.new") .choice() .when().jsonpath("USD.store.book[?(@.price < 10)]") .to("jms:queue:book.cheap") .when().jsonpath("USD.store.book[?(@.price < 30)]") .to("jms:queue:book.average") .otherwise() .to("jms:queue:book.expensive")
<camelContext id="camel" xmlns="http://camel.apache.org/schema/spring"> <route> <from uri="direct:start"/> <choice> <when> <jsonpath>USD.store.book[?(@.price < 10)]</jsonpath> <to uri="mock:cheap"/> </when> <when> <jsonpath>USD.store.book[?(@.price < 30)]</jsonpath> <to uri="mock:average"/> </when> <otherwise> <to uri="mock:expensive"/> </otherwise> </choice> </route> </camelContext>
USD.store.book[?(@.price < 20)]
store.book.price < 20
price < 20
left OP right
store.book.price < USD{header.limit}
from("direct:start") .choice() // use true to suppress exceptions .when().jsonpath("person.middlename", true ) .to("mock:middle") .otherwise() .to("mock:other");
<route> <from uri="direct:start"/> <choice> <when> <jsonpath suppressExceptions="true">person.middlename</jsonpath> <to uri="mock:middle"/> </when> <otherwise> <to uri="mock:other"/> </otherwise> </choice> </route>
// Java public class Foo { @Consume(uri = "activemq:queue:books.new") public void doSomething(@JsonPath("USD.store.book[*].author") String author, @Body String json) { // process the inbound message here } }
from("direct:start") .choice() .when().jsonpath("USD.store.book[?(@.price < `USD{header.cheap}`)]") .to("mock:cheap") .when().jsonpath("USD.store.book[?(@.price < `USD{header.average}`)]") .to("mock:average") .otherwise() .to("mock:expensive");
// Java DSL .when().jsonpath("USD.store.book[?(@.price < 10)]", false, false)
// XML DSL <jsonpath allowSimple="false">USD.store.book[?(@.price &lt; 10)]</jsonpath>