Unanswered

Converting Output from Filter Array into XML

(0) Share

Report

Posted on by DH2023

I am currently building a flow to extract fields from emails received into a shared mailbox. I have previously used an expression in a flow to convert and Output from a filter arrray into a XML to use Xpath. The expression is as follows:

xml(json(concat('{"root": { value:', body('Filter_array'), '}}')))

When trying to use this expression on my new flow, I am not getting any of the pulled data from the XML compose step although it appears to be present in the output of the XML step.

Is my current expression used in my XML step incorrect?

Thank you,

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

VictorIvanidze 13,073 on at

Like (0)

Report

Could you show the output of "Filter Array"?

Was this reply helpful? Yes No
DH2023 84 on at

Like (0)

Report

[
"======================================================================",
"Personnel Change Authorization",
"(Termination)",
"======================================================================",
"Please see the Termination PCA details below for Jane Doe.",
"======================================================================",
"Employee Details:",
"======================================================================",
"Employee ID : 11111111",
"Name : Dane Doe",
"Job Title : Manager",
"Report to Manager : 22222222 John Doe",
"Action Date : 2/2/2023",
"Effective Date : 2/3/2023",
"Division : XXXX - OGR",
"Branch/Dept. : Payroll",
"Work Location : United States",
"Discipline : Back Office",
"Sales Location : United States",
"Service : SA-Staff Aug (SA-Staff Aug)",
"======================================================================",
"Termination Details:",
"======================================================================",
"Last Day Of Work : 2/2/2023",
"Shut Off Access : Immediately",
"Transfer Business To : 22222222 John Doe",
"Notes:",
"Human Resources Department",
"Ph:123-456-7891",
"[cid:image001.png@01D93723]",
"First Last Name",
"IT Support",
"Tel: 123-456-7891",
"first_lastname@random.com",
"Connect With Us",
"For immediate assistance, please contact IT Technical Support",
]

Was this reply helpful? Yes No
DH2023 84 on at

Like (0)

Report

After playing with this for a few days, I don't appear to be able to crack the code.

Below is what the XML output looks like.

<root><value>======================================================================</value><value>Personnel Change Authorization</value><value>(Termination)</value><value>======================================================================</value><value>Please see the Termination PCA details below for Dane Doe.</value><value>======================================================================</value><value>Employee Details:</value><value>======================================================================</value><value>Employee ID : 11111111</value><value>Name : Dane Doe</value><value>Job Title : Payroll</value><value>Report to Manager : 22222222 John Doe</value><value>Action Date : 2/2/2023</value><value>Effective Date : 2/3/2023</value><value>Division : XXXX - OGR</value><value>Branch/Dept. : Payroll</value><value>Work Location : United States</value><value>Discipline : Back Office</value><value>Sales Location : United States</value><value>Service : Sales</value><value>======================================================================</value><value>Termination Details:</value><value>======================================================================</value><value>Last Day Of Work : 2/2/2023</value><value>Shut Off Access : Immediately</value><value>Transfer Business To : 22222222 John Doe</value><value>Notes:</value><value>HR</value><value>Ph:123-456-7891</value><value>Image</value><value>Some One</value><value>IT | OGR</value><value>Tel: 123456789</value>
</root>

Any assistance on this is helpful!

Thank you

Was this reply helpful? Yes No