Skip to main content
Solved

Syntax to extract children into attributes with XMLFragmenter


aaron
Contributor
Forum|alt.badge.img+10
  • Contributor

I am using an HTTPCaller to return some XML which I then want to turn into attributes. I can extract the Project fragment below using the XMLFragmenter (with Projects/Project in the Elements to Match parameter) but I haven't figured out how to directly extract the children into fragments or directly into attributes. Using Projects/Project/* doesn't work. For instance, I want to extract ProjectNumber and Status more directly into attributes. So far my solution has been to use a StringSearcher and SubstringExtractor to get each attribute. That's a tedious way to do it. Any advice on a better way?

 

<?xml version="1.0" encoding="UTF-16"?><Project ProjectId="508DKDS6B2KA" ProgramId="YAK0C5V4UNVH" ProjectNumber="EST-00001" Status="Cancelled/Archived" StatusTimestamp="2021-04-01T12:23:55-06:00" LastChangeTimestamp="2021-06-29T14:15:01-06:00" ></Project>

 

Best answer by aaron

david_r wrote:

Try something like this:

imageResult:

image

Thanks @david_r​ , worked perfectly.

View original
Did this help you find an answer to your question?

2 replies

david_r
Evangelist
  • March 7, 2023

Try something like this:

imageResult:

image


aaron
Contributor
Forum|alt.badge.img+10
  • Author
  • Contributor
  • Best Answer
  • March 7, 2023
david_r wrote:

Try something like this:

imageResult:

image

Thanks @david_r​ , worked perfectly.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings