How to Parse XML Column in Dataset Using Pre-Built XML Parser Construct (No Custom Code)

Ask the Community
1

Hi everyone,

I’m working in Pipeline Builder and have a dataset with a column that contains raw XML strings (e.g., xml_payload). I’d like to extract fields from the XML using the pre-built Parse XML as Schema construct, without writing custom code (like Python or Expression Language).

My goal is to:

  • Map the XML column from the dataset to the parser
  • Use XPath to extract values from the XML
  • Output a structured dataset with those extracted fields

However, I’m unsure how to properly connect the dataset column to the xml parameter expected by the construct, and how to configure the XPath expressions.

Can someone please guide me through:

  • How to correctly map a dataset column (e.g., xml_payload) to the XML Parser construct?
  • Best practices for configuring XPath inside the pre-built construct?
  • Any tips or limitations I should be aware of?

Thanks in advance for your help!