Search: "xpath"

Xpath Expert

Key concepts == This microlearning focuses on very complex XPath operations. With XPath Expert, we mean learning that XPath options are sometimes very complex but could benefit you in specific cases in your daily work.

XPath Expert == Within the crash course, we already explained XPath conceptually.

In this microlearning, we will wrap the concept of XPath by looking at three complex XPath alternatives that are sometimes needed when dealing with messages in eMagiz.

expert-create-your-transformations-xpath-expert

XPath Advanced

advanced-create-your-transformations-xpath-advanced

Some of the more complex XPath options are: * dateTime calculation * Filter list * XPath on JSON * SpEL notation for XPath == 3. XPath Advanced == Within the crash course, we already explained XPath conceptually.

Key takeaways == Some of the more complex XPath options are: * dateTime calculation * Filter list * XPath on JSON * SpEL notation for XPath == 5.

Transformation - XPath Basic

crashcourse-platform-create-transformation-xpath-basic--emagiz-transformation-custom-xpath-result.png

crashcourse-platform-create-transformation-xpath-basic--emagiz-transformation-xpath.png

crashcourse-platform-create-transformation-xpath-basic--wildcard-xpath.png

crashcourse-platform-create-transformation-xpath-basic

For those cases, you can use a custom (handwritten) XPath expression to achieve the desired result. === 3.1 What is XPath === Before we delve into the use of XPath within the eMagiz tooling let us first discuss XPath itself.

I can either start at the root (Absolute XPath) and navigate down from there which would give me /Projects/Project as a valid XPath expression. On the other hand, I could also start directly at the Project element (Relative Xpath) which would give me //Project as a valid XPath expression.

Transformation - XPath Intermediate

intermediate-create-your-transformations-xpath-intermediate--substring-transformation-tooling.png

intermediate-create-your-transformations-xpath-intermediate

. * With XPath Intermediate we mean: Learning which XPath options are widely used and could benefit you in your daily work. == 3. Transformation - XPath Intermediate == Within the crash course, we already explained XPath conceptually.

We will pick up the subject of XPath later on once more to delve even deeper into the world of XPath. == 4.

crashcourse-platform-create-splitting-messages--xpath-splitter-pop-up-filled-in-wildcard.png

crashcourse-platform-create-splitting-messages--xpath-splitter-pop-up-filled-in.png

crashcourse-platform-create-splitting-messages--xpath-splitter-pop-up.png

With the help of the Xpath splitter, you can split the message based on the result of an Xpath expression.

As you remember from our microlearnings on Xpath an XPath navigates through the input XML based on the expression given.

If you want to write an XPath while doing a transformation any input element can be the starting point of your XPath.

crashcourse-messaging-filter--xpath-filter-filled-in.png

crashcourse-messaging-filter--xpath-filter.png

If not it will be dropped. === 3.2 XPath Filter === The XPath filter can only be used to filter XML messages.

Think back to what we learned in the crash course * platform with regards to XPath. The same logic applies in this case. With the help of this filter, you can filter messages based on the evaluation of an XPath expression [[image:Main.Images.Microlearning.WebHome@crashcourse-messaging-filter--xpath-filter.png]] In this example, we want to validate that at least one Project is available in our CDM message [[image:Main.Images.Microlearning.WebHome@crashcourse-messaging-filter--cdm-structure.png]] To do so we need to fill in the correct XPath and place the component at the correct place within the flow. [[image:Main.Images.Microlearning.WebHome@crashcourse-messaging-filter--xpath-filter-filled-in.png]] Once again, don't forget about the namespace == 4.

intermediate-create-your-transformations-xpath-intermediate--substring-transformation-tooling.png

If your grouping-key is complex, select Custom Key and write a custom XPath expression. In the dropdown menu, you can choose all attributes belonging to the **input** list or the [Custom Key] option. Selecting the second option allows you to specify your own XPath to get the correct value on which to base your grouping logic. [[image:Main.Images.Microlearning.WebHome@intermediate-create-your-transformations-grouping--grouping-popup-dropdown.png]] === 3.2 Starting With === The option Starting with allows you to write an XPath expression specifying the start of a new group.

Standard we often see an xpath like: /Records/Record. In the example below we choose /_:Employees/_:Employee. Alternatively you can determine the namespace prefix and the namespace itself, just as you can in the support object called Xpath expression. [[image:Main.Images.Microlearning.WebHome@intermediate-create-your-transformations-FlatFileTransformation-xml2flat-Step4.png]] **Filling in the correct xpath expression per column** For each column you have just generated you now have to define the xpath expression.

Due to the nature of the xml message that will form the input the xpaths you need to set will mimic the name of the attribute they correspond with.

XSLT parameters need to be: * Defined on transformation level * Defined as static input (or part of an XPath) in the transformation * Filled with a static or dynamic value With the help of such an XSLT parameter, you can inject a static or dynamic value.

You can also use parameters as part of an XPath or an XSLT snippet. When you select the option static input you can choose the option called Parameter.

Key takeaways == * For a working solution you need to execute three steps ** Define the parameter on transformation level ** Defined as static input (or part of an XPath) in the transformation ** Define on component level how the parameter should be filled * A parameter can be filled with the help of a static (i.e. property) or dynamic (i.e. message header) value == 5.

This is particularly useful for namespaces that unlock additional XPath features such as format-dateTime and dateTime calculations.

This means that when you use a custom XPath you should manually change this to reflect the changes in namespace but when you simply use the line as drawn in Design eMagiz will automatically update the XPath so your transformation will keep working.