You are viewing limited content. For full access, please sign in.

Question

Question

Question about ReadXML and relational fields

Workflow
Updated September 28, 2021
asked on September 28, 2021 • Show version history

I am setting up a ReadXML activity in workflow to read the values returned by an API which returns in XML format.

After reviewing the documentation and multiple online examples of XPath notation I am having trouble finding one simple concept.

How do you get relational fields?

For example I have for each //employee node, both a firstName and a workEmail attribute. These fields are relational.

I can create an xPath Expression to get one or the other, or both by using the | option, but it does not delimit the results in any way that keeps them relational in the output.

Some employees do not have a workEmail, so having 2 separate multi-value tokens does not match index by index.

0 0

Replies

replied on September 28, 2021

Determined a solution for this specific data. Thankfully each employee had a unique ID, so I could get the ID's then cycle through the values and ask for the sub fields by ID, working with one employee at a time. However this solution would not work for XML data that does not include a unique parent ID.

For example

<book>
<author></author>
<subject></subject>

</book>

 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...