Page History

...
You can use JSON path expressions with following mediators:
Mediator | Usage | |||||
---|---|---|---|---|---|---|
Log | As a log property:
| |||||
Property | As a standalone property:
| |||||
PayloadFactory | As the payload arguments:
IMPORTANT: You MUST omit the | |||||
Switch | As the switch source:
| |||||
Filter | As the filter source:
|
JSON path syntax
Suppose we have the following payload:
...
The following table summarizes sample JSONPath expressions and their outputs:
Expression | Result |
---|---|
$. | { "id":12345, "id_str":"12345", "array":[1, 2, [[],[{"inner_id":6789}]]], "name":null, "object":{}, "$schema_location":"unknown", "12X12":"image12x12.png"} |
$.id | 12345 |
$.name | null |
$.object | {} |
$.['$schema_location'] | unknown |
$.12X12 | image12x12.png |
$.array | [1, 2, [[],[{"inner_id":6789}]]] |
$.array[2][1][0].inner_id | 6789 |
You can learn more about JSONPath syntax here.
...
XML to JSON transformation parameters
You can use XML to JSON transformation parameters add the parameters listed below to the synapse.properties
file (stored in the <EI_HOME>/conf/
directory) when you need to transform XML formatted data into the JSON format.Following are the XML to JSON transformation parameters and their descriptions:
Parameter | Description | Default Value |
---|---|---|
| Preserves the namespace declarations in the JSON output in XML to JSON transformations. | false |
| Builds valid XML NCNames when building XML element names in XML to JSON transformations. | false |
| Allows primitive types in the JSON output in XML to JSON transformations. | true |
| The namespace prefix separation character for the JSON output in XML to JSON transformations. | The default separation character is - |
| Adds XML namespace declarations in the JSON output in XML to JSON transformations. | false |
| Disables auto primitive conversion in XML to JSON transformations. | null |
| Sets the JSON output to an array element in XML to JSON transformations. | true |
| Sets the JSON output to an xml multiple processing instruction in XML to JSON transformations. | true |
| Sets the XML output to an array element in XML to JSON transformations. | true |
| Sets the XML output to an xml multiple processing instruction in XML to JSON transformations. | false |
| Sets an empty element to an empty JSON string in XML to JSON transformations. | true |
Anchor | ||||
---|---|---|---|---|
|
...
The parameters available in this section are as follows.
Parameter Name | Description |
---|---|
Schema keys defined for Validate Mediator | This section is used to specify the key to access the main schema based on which validation is carried out, as well as to specify the JSON, which needs to be validated. |
Source | The JSONPath expression to extract the JSON that needs to be validated. E.g: json-eval($.msg)" |
Following example use the below sample schema StockQuoteSchema.json
file. Add this sample schema file (i.e. StockQuoteSchema.json
) to the following Registry path: conf:/schema/StockQuoteSchema.
json. For instructions on adding the schema file to the Registry path, see Adding a Resource.
...