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
Celebrity
  • 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.


Reply


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