How to Extract value from XML object from Schema

Avatar

Avatar
Validate 1
Level 1
CSLTGUPTAA
Level 1

Likes

0 likes

Total Posts

17 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
CSLTGUPTAA
Level 1

Likes

0 likes

Total Posts

17 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
CSLTGUPTAA
Level 1

29-10-2020

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

977 likes

Total Posts

1,096 posts

Correct reply

516 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

977 likes

Total Posts

1,096 posts

Correct reply

516 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

02-11-2020

Hi,

 

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

 

Thanks,

-Jon

Answers (1)

Answers (1)

Avatar

Avatar
Give Back
Level 1
SachinDhir
Level 1

Likes

2 likes

Total Posts

13 posts

Correct reply

0 solutions
Top badges earned
Give Back
Validate 1
Boost 1
View profile

Avatar
Give Back
Level 1
SachinDhir
Level 1

Likes

2 likes

Total Posts

13 posts

Correct reply

0 solutions
Top badges earned
Give Back
Validate 1
Boost 1
View profile
SachinDhir
Level 1

02-11-2020

Data Extraction (file) activity allows doing that.

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