How to Extract value from XML object from Schema | Community
Skip to main content
C
CSLTGUPTAA
New Participant
October 30, 2020
Solved

How to Extract value from XML object from Schema

  • October 30, 2020
  • 2 replies
  • 4303 views

Hi, 

I want to extract email "Subject" value from email header parameter (which is xml object) from broadLogRcp(deliveries) 

in my workflow. Any insight/sample code would be highly appreciated. 

Example : I want to extract user's email "Subject" from "email header parameters" under Delivery from broadLogRcp schema just to know the Subject of the emails sent out.

Currently user's email "Subject"  in "email header parameter" is in XML object format so directly we can get the value so I am trying to write one JavaScript code for the same, so need help to find a solution around this. appreciate your time on this.

Looking forward...

-CSLTgupta

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Jonathon_wodnicki

Hi,

 

It's ordinary XML/E4X. To parse the data field's XML with js, use var delivery = new XML(data).

 

Thanks,

-Jon

2 replies

Jonathon_wodnicki
Jonathon_wodnickiAccepted solution
New Participant
November 2, 2020

Hi,

 

It's ordinary XML/E4X. To parse the data field's XML with js, use var delivery = new XML(data).

 

Thanks,

-Jon

    C
    CSLTGUPTAAAuthor
    New Participant
    November 3, 2020
    thanks Jon for your suggestion. But Can you please elaborate your comments. FYI - here is code snippet below which I'm trying to use :
    SachinDhir
    SachinDhir
    New Participant
    November 2, 2020

    Data Extraction (file) activity allows doing that.

    Otherwise, we can't extract using query or enrichment activity.

     

     

    Terms & ConditionsAccessibility statement

    Loading footer...