How to Extract value from XML object from Schema

Forum|Forum|5 years ago
October 30, 2020
2 replies
4304 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

SachinDhir

Level 2

Data Extraction (file) activity allows doing that.

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

Jonathon_wodnicki

Accepted solution

Community Advisor

Hi,

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

Thanks,

-Jon

Jonathon_wodnicki

Community Advisor

<node expr="data"/> and then new XML(res.data)

V

vandanaverma

How do I convert the data to XML and return XML data to CRM for broadlog delivery data where I have created the API and stored the broadlog data like id, labelname, address,eventdate in one variable and also in variable I have mirrorpage URL based on broadlogid, delivery id. I need the output in XML and return the XML data based on use case for multiple email need mirrorpage URL.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded